On Mon, 7 May 2012, Aram Mirzadeh wrote:
Recently, after we upgraded to 3.8 we started to have a strange behavior. The excel file would open in a "corrupted" state, and excel would complain about invalid style.xml. Unzipping the file the style file looks good, valid -- although admittedly it has a lot of styles in it. A good file would have about 13,000 style nodes, a bad one would have 130,000.
I think that might well be more than Excel supports
Before I go hip deep into this, is there any issues anyone is aware of? Should I not be doing a cellStyle on each and every cell that I need to show as "link text"?
Cell Styles are workbook scoped, not cell scoped. So, you should create them up-front, and apply to cells as needed. You shouldn't be creating one per cell
Nick --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
