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]
