Skip to main content
Inspiring
August 6, 2014
Answered

Spreadsheet formatting gets messed up when using update to add additional sheets

  • August 6, 2014
  • 1 reply
  • 336 views

Has anyone had issues with cfspreadsheet where a sheet has formatting issues when the sheet is added as a additional sheet using the update action, while the same sheet looks fine when the sheet is the first or only sheet added using the write action?

I am using CF 10.

This topic has been closed for replies.
Correct answer SteveTX

For what it's worth, based on some other posts I found here, I reconfigured my code so it creates a single spreadsheet object with multiple sheets, rather than individual spreadsheet objects for each sheet, Then it makes a single call to write that object to disk. Than seems to have resolved most if not all of my formatting issues. The basic takeaway I guess is don't use the update action if you can possibly avoid it.

1 reply

SteveTXAuthorCorrect answer
Inspiring
August 12, 2014

For what it's worth, based on some other posts I found here, I reconfigured my code so it creates a single spreadsheet object with multiple sheets, rather than individual spreadsheet objects for each sheet, Then it makes a single call to write that object to disk. Than seems to have resolved most if not all of my formatting issues. The basic takeaway I guess is don't use the update action if you can possibly avoid it.