You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2012/09/18 16:49:39 UTC
[Bug 53888] New: Incorrect formula value for empty string value
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
[Bug 53888] Incorrect formula value for empty string value
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=53888
--- Comment #1 from Sebas <sc...@gmail.com> ---
In the attachment, A9 is the cell with the empty result formula.
--
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