poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject [Bug 55747] nested function in IF's in formulas produce #VALUE! error in excel
Date Wed, 05 Aug 2015 15:55:15 GMT
https://bz.apache.org/bugzilla/show_bug.cgi?id=55747

Andrew <dron007@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|NEEDINFO                    |NEW

--- Comment #8 from Andrew <dron007@gmail.com> ---
I created file "badFile.xls" using my java code (in POI 3.13beta1). After
recalculating in Excel saved as "goodFile.xls".
BiffViewer result of "badFile.xls" in "badFileBiff.txt", "goodFile.xls" in
"goodFileBiff.txt".
As you expected, there are differences in formula records:
    Ptg[4]=org.apache.poi.ss.formula.ptg.RefPtg [A1]R
in BAD file againist
    Ptg[4]=org.apache.poi.ss.formula.ptg.RefPtg [A1]V
in GOOD.

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