Highlighted

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

Explorer ,
Aug 06, 2014

Copy link to clipboard

Copied

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.

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.

Views

181

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more

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

Explorer ,
Aug 06, 2014

Copy link to clipboard

Copied

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.

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.

Views

182

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Aug 06, 2014 0
Explorer ,
Aug 12, 2014

Copy link to clipboard

Copied

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.

Likes

Translate

Translate

Report

Report
Community Guidelines
Be kind and respectful, give credit to the original source of content, and search for duplicates before posting. Learn more
Reply
Loading...
Aug 12, 2014 0