https://issues.apache.org/bugzilla/show_bug.cgi?id=48494
Summary: EventBasedExcelExtractor and ExcelExtractor don't
process conditional cell formatting correctly
Product: POI
Version: 3.6
Platform: PC
OS/Version: Mac OS X 10.4
Status: NEW
Severity: normal
Priority: P2
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
Created an attachment (id=24803)
--> (https://issues.apache.org/bugzilla/attachment.cgi?id=24803)
sheet that exhibits issue
>> 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);_(* "-"_);_(@_)"
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.
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
