Hi, I'm using the poi-1.10-dev release to generate XLS files in a servlet environment (streaming straight down to a browser as an attachment). Everything is working pretty well except for one really niggly problem. I am using a large number of custom data formats (i.e. calling HSSFDataFormat.getFormat(String) with a custom string) and in general they work fine. Unfortunatly, any which include a high unicode value (e.g. the euro symbol) get the high byte truncated, so the symbol is wrong in Excel. Looking at the FormatRecord class there is a 16-bit flag (field 3), but it is never getting set and I can't see any way to set it myself (as there is no way to get access to the FormatRecord instance through the HSSFWorkbook). All the other places where unicode strings are used (cells, sheet names etc) you can set the 16-bit flag before setting the value, so this just looks like an omission. Am I missing something? If not, I'd be happy to patch it and put the patch onto the poi-dev list, just let me know :)
Cheers, Adam Reeve Firmwide Internet Group Goldman Sachs International * [EMAIL PROTECTED] * +44 (0)20 7774 8155 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
