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?
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).
I wrote a UDF to export queries using Ben's library. It will detect & properly format dates more reliably than CFSpreadsheet.
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.