poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Aram Mirzadeh <...@mbcli.com>
Subject Re: Number of styles applied
Date Thu, 10 May 2012 00:47:25 GMT

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: user-unsubscribe@poi.apache.org
>> For additional commands, e-mail: user-help@poi.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org


Mime
View raw message