Skip to main content
A
akkanto
Participant
February 4, 2014
Question

Cfspreadsheet compatibility issues with Office 2013 (Excel 2013)

  • February 4, 2014
  • 2 replies
  • 1318 views

I have a web application that generate Excel Spreadsheets with formulas, colors and formatting.
If the XLS generated by the application is opened from an Office 2013, we randomly loose the formatting (and colors) in the middle of the page. (It starts corrently but at some point, the formatting seems to stops for an entire column or two).
It works well with Office 2010 so it looks like there is some sort of imcompatibility issue.

Note. I'm using coldfusion 9

This topic has been closed for replies.

2 replies

E
ericbegins
Known Participant
November 23, 2016

We are seeing the exact same behavior with ColdFusion 10.  Formatting works fine for about half of the sheet and then goes haywire.

WolfShade
WolfShade
Legend
November 23, 2016

ericbegins​, are you using CFSPREADSHEET, or SpreadsheetNew()?

If you are using SpreadsheetNew(), format it for .xlsx (XML) instead of .xls.  I've seen where the .xls files have had issue with formatting, similar to what you refer to.

SpreadsheetNew('mySheet',true); 
// Uses updated XML format for Excel spreadsheets, 
// not the old (Office 2010 or earlier) version.

HTH,

^_^

E
ericbegins
Known Participant
November 23, 2016

That worked!  We'll have to rewrite some custom color pallet functionality we had, but that's not nearly as important as it throwing off the content of the worksheet.

Thanks!

Carl Von Stetten
Carl Von Stetten
Legend
February 4, 2014

Since you are using an older version of ColdFusion that was released in 2009 to generate documents for a newer version of Excel that was released in 2012, it shouldn't be surprising that there could be incompatibility issues.  You might try testing against the current ColdFusion release (version 10 - you can install a developer edition copy somewhere to do your testing).  Otherwise, you might look at using the Apache POI project which might be more compatible.

-Carl V.

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