https://issues.apache.org/bugzilla/show_bug.cgi?id=55843
Bug ID: 55843
Summary: Formula evaluation ROW() results in two different
results.
Product: POI
Version: 3.9
Hardware: PC
OS: Linux
Status: NEW
Severity: major
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
Created attachment 31090
--> https://issues.apache.org/bugzilla/attachment.cgi?id=31090&action=edit
junit test case
Consider the attached test case:
- If I evaluate the formula:
IF(B1=0,"",((ROW()-ROW(A$1))*12))
the result is:
org.apache.poi.ss.usermodel.CellValue [-12.0]
which in my eyes is wrong.
When negating the condition and the formula results in the correct value:
IF(NOT(B1=0),((ROW()-ROW(A$1))*12),"")
--
You are receiving this mail because:
You are the assignee for the bug.
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
