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.

1 comment:

  1. have you actually tried it, because it just gives me "Variable Spreadsheetformatcellrange undefined" do you know if that is a bug?

    ReplyDelete