poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 53888] New: Incorrect formula value for empty string value
Date Tue, 18 Sep 2012 14:49:39 GMT
https://issues.apache.org/bugzilla/show_bug.cgi?id=53888

          Priority: P2
            Bug ID: 53888
          Assignee: dev@poi.apache.org
           Summary: Incorrect formula value for empty string value
          Severity: normal
    Classification: Unclassified
                OS: Windows Vista
          Reporter: scgdevelop@gmail.com
          Hardware: PC
            Status: NEW
           Version: 3.8
         Component: HSSF
           Product: POI

Created attachment 29381
  --> https://issues.apache.org/bugzilla/attachment.cgi?id=29381&action=edit
Example with the problematic formula

I am using the HSSFListener.

Type the following formula:

=IF(1=1,"","abc")

Excel shows nothing (empty string) while
FormatTrackingHSSFListener.formatNumberDateCell(formula) returns 0

The attachment contains the formula with problems.
The attachment also contains other formulas that work correctly: numbers and
strings.
I have debugged the code and the string formula values are cached except for
the one in the bug.

-- 
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