search

Leftbower / cfspreadsheet-lucee-5

A cfspreadsheet extension for Lucee 5
23 stars 10 forks source link

SpreadsheetFormatColumn() on large spreadsheet #9

Open MarcAckermann opened 7 years ago

MarcAckermann commented 7 years ago

Using SpreadsheetFormatColumn() on a large spreadsheet throws error: "The maximum number of cell styles was exceeded. You can define up to 4000 styles in a .xls workbook" I have a sheet with 2100 rows and 12 columns.

In case someone else runs into this issue, the workaround SpreadsheetFormatCellRange (spreadsheetObj, format, startRow, startColumn, endRow, endColumn) works fine.

mjclemente commented 5 years ago

Ran into the same issue with spreadsheetFormatRow and spreadsheetFormatRows. Same workaround worked for me.