Bug 53888 - Incorrect formula value for empty string value
Summary: Incorrect formula value for empty string value
Status: NEW
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.8-FINAL
Hardware: PC Windows Vista
: P2 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2012-09-18 14:49 UTC by Sebas
Modified: 2015-10-29 09:25 UTC (History)
1 user (show)



Attachments
Example with the problematic formula (25.50 KB, application/vnd.ms-excel)
2012-09-18 14:49 UTC, Sebas
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Sebas 2012-09-18 14:49:39 UTC
Created attachment 29381 [details]
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.
Comment 1 Sebas 2012-09-18 14:51:45 UTC
In the attachment, A9 is the cell with the empty result formula.