SpreadsheetFormatColumn() on large spreadsheet

[MarcAckermann]

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]

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