poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 48494] New: EventBasedExcelExtractor and ExcelExtractor don't process conditional cell formatting correctly
Date Wed, 06 Jan 2010 17:49:51 GMT
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: dev@poi.apache.org
        ReportedBy: philvarner@gmail.com


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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org


Mime
View raw message