On Wed, Jan 6, 2010 at 2:35 AM, Nick Burch <[email protected]> wrote: > On Tue, 5 Jan 2010, Phil Varner wrote: >> >> The EBEE tries to format decimal values before returning them using >> the method formatNumberDateCell. I have some xls (unfortunately I >> can't share) that throw an exception from the DecimalFormat >> constructor: >> java.lang.IllegalArgumentException: Unquoted special character ';' in >> pattern "_(*#,##0_);_(*(#,##0);_(* "-"_);_(@_)" > > Any chance you could create a new simple workbook, and copy just the number > formatting and that number over? If you upload that to bugzilla, we can then > take a look > > OOI, does the usermodel cope ok with your format?
UserModel copes, but because no formatting is applied. Relevant code in ExcelExtractor: case HSSFCell.CELL_TYPE_NUMERIC: // Note - we don't apply any formatting! text.append(cell.getNumericCellValue()); break; However, a date formatted cell (string cell type) with "hh:mm;hh:mm;hh:mm" fails in both. I believe this means conditional cell formatting never works (either not being applied or throwing exception), only static cell formatting. I'm not sure what the above format of the 3- or 4-valued conditional is, though. I'll file a bug for this. Attached is a doc that exhibits the issue and a java class that reproduces. --Phil
poi_format_bug_repro.xls
Description: MS-Excel spreadsheet
--------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
