Skip to main content
A
Anonymous
August 3, 2015
Question

Limit to formatted cells in Excel?

  • August 3, 2015
  • 1 reply
  • 455 views

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?

    This topic has been closed for replies.

    1 reply

    James Moberg
    James Moberg
    Inspiring
    August 4, 2015

    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

    A
    Anonymous
    August 4, 2015

    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.

    Terms & ConditionsAccessibility statement
    Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices