Larger files created with pyExcelerator do not open
smoothly in Excel2002 - a warnig is genereated with the
message "Too many fonts...". This happens, for
example, with the big-16MB.py sample.
I cannot reproduce this problem with pyExcelerator 0.6.3a and any of: Excel 2003 (I don't have Excel 2002), OOo Calc 2.0, and Gnumeric 1.7. In fact there are only 6 FONT records in the created big-16Mb.xls file.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
It's huge problem because it not only warning, Excel remove formats. This happen when more then 2500( not accurate) are with format. pyExcelerator as long as i see, work with only one cell at a time and make one format each cell. Witch work ok with 10x10 table :), but when you try 1000x10 or evan 10 000x10 it's crash. In pyXlWriter project, has range methods and have no such problems. Bad thing is that no one support it anymore.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I attempted to reproduce this, and even after modifying big-16Mb.py so that a bold red font and borders were applied to all cells, Excel 2003 (on Win XP) doesn't complain, and appears to load it correctly.
Perhaps this issue was fixed since it was reported. If anyone else is seeing this, please let us know.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Logged In: YES
user_id=480138
Originator: NO
I cannot reproduce this problem with pyExcelerator 0.6.3a and any of: Excel 2003 (I don't have Excel 2002), OOo Calc 2.0, and Gnumeric 1.7. In fact there are only 6 FONT records in the created big-16Mb.xls file.
Logged In: YES
user_id=1881993
Originator: NO
It's huge problem because it not only warning, Excel remove formats. This happen when more then 2500( not accurate) are with format. pyExcelerator as long as i see, work with only one cell at a time and make one format each cell. Witch work ok with 10x10 table :), but when you try 1000x10 or evan 10 000x10 it's crash. In pyXlWriter project, has range methods and have no such problems. Bad thing is that no one support it anymore.
I attempted to reproduce this, and even after modifying big-16Mb.py so that a bold red font and borders were applied to all cells, Excel 2003 (on Win XP) doesn't complain, and appears to load it correctly.
Perhaps this issue was fixed since it was reported. If anyone else is seeing this, please let us know.