Spreadsheet::WriteExcel Too Many Formats Problemsby water (Deacon)
|on Jun 02, 2006 at 01:14 UTC||Need Help??|
water has asked for the
wisdom of the Perl Monks concerning the following question:
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?