Limit to formatted cells in Excel?

[Guest]

Hello,

I'm generating a normal spreadsheet file and formatting a couple of columns with SpreadsheetFormatColumn, to give them a particular date format. If I open the file through OpenOffice, everything works perfectly. However, if I open it through Excel, any cell in the formatted column past the 32nd row does not display the proper format (Cell is displayed as "general") and I need to do it manually.

What could be causing this?

[James Moberg]

You didn't indicate which version of ColdFusion you are using.  ColdFusion 10 is better than 9, but I don't think either version is correctly formatting dates.

Ben Nadal's POI Utility does a better job of exporting and retaining the date format (and it's faster & generates smaller Excel files).

https://github.com/bennadel/POIUtility.cfc

I wrote a UDF to export queries using Ben's library. It will detect & properly format dates more reliably than CFSpreadsheet.

http://gamesover2600.tumblr.com/post/116662989199/coldfusion-cfexcelpoi

[Guest]

I'm currently running 9, but you are correct, I ran the test on 10 and it did not properly work either.

Thanks for the utilities, I'll give it a shot and report back.