hi nick,
is a cell style different if the text is different?
For example
A
0 Name
1 Age
In the example both cells have identicle cell styles apart from the text is
different. Does this cause the cell style to be different?
many thanks
mark
Nick Burch wrote:
>
> On Tue, 15 Jul 2008, mjw_85uk wrote:
>> i have solved the people of java.lang.NoSuchMethodError only to be
>> confronted with another. I have used you cloneStyleFrom(HSSFCellStyle
>> source). However, when i open the spreadsheet in MS Excel it still
>> complains about having to many fonts.
>
> You'll still need to ensure you don't create too many cell styles,
> otherwise excel will still get in a miff.
>
> One option is to have a hashtable of old style to new style. If an entry
> doesn't exist in the hash, create one on the new wb and clone it over,
> then store the pair in the hash. Otherwise, look up the pre-existing new
> style for each old one, and use that
>
> Nick
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
--
View this message in context:
http://www.nabble.com/HSSFCellStyle-help-tp18401553p18483705.html
Sent from the POI - User mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
