Don't ask to ask, just ask | |
PerlMonks |
comment on |
( [id://3333]=superdoc: print w/replies, xml ) | Need Help?? |
Hi --
I am using Spreadsheet::WriteExcel to make a sheet with several tabs, each tab with many populated cells, and many cells with multiple formats (color, currency, etc). I am applying the formats cell-wise, not row- or col- or region-wise. If the sheet gets too big, it seems I am overflowing some sort of Excel max-num-formats-applied limit: an excel warning error gets issued on spreadsheet open, and the resulting sheet 'loses' formatting somewhere along the way in one of the later tabs. Has anyone else encountered this over-use of Excel format problem, and have any suggestions to remedy it? Thanks! In reply to Spreadsheet::WriteExcel Too Many Formats Problems by water
|
|