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

[SteveTX]

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.

[SteveTX · Accepted solution]

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.