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]
