Solution -- don't use a singleton to create your styles.
On 5/9/2012 7:02 PM, Aram Mirzadeh wrote:
I created a bug and attached a test case for this in bugzilla, #53209.
I am creating ahead of time in a singleton and then just applying them
to the cells. I included the singleton in the attachment too. In
fact in the test, only a single style is applied.
I know it is supported ( at some level and in XML version ) because
even if it fails to open correctly, you can apply the sytle to the
cells again and save it/open it and it works.
Aram
On 5/9/2012 1:22 PM, Nick Burch wrote:
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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
