Sunday, August 1, 2010

ColdFusion SpreadSheet enhancement in 9.0.1

ColdFusion 9.0.1 also adds few enhancements for interacting with spreadsheets. There is significant performance improvement over formatting large number of rows and columns. Also added was a neat function to format a group of cells.

SpreadsheetFormatCellRange

Example: 

SpreadSheetFormatCellRange(spreadSheetVar,{bold='true',color='red',fontsize='15'},2,2,10,20);

This will format rows 2 to 10 and columns 2 to 20.

ColdFusion Updater 9.0.1 and Solr

There are lot enhancements done in ColdFusion wrt Solr in 9.0.1. There are few issues but: If you are running into this exception ""java.lang.NoClassDefFoundError: org/ccil/cowan/tagsoup/Parser" while indexing documents, you will need the following jar in ColdFusion lib directory:

http://dl.dropbox.com/u/7302119/tagsoup-1.2.jar
This happens when some binary files like .nfo are indexed and ColdFusion is unable to parse the file.

Get CF 9.0.1 here: http://www.adobe.com/go/getcf901