https://issues.apache.org/bugzilla/show_bug.cgi?id=56859
Bug ID: 56859
Summary: IF Function evaluation
Product: POI
Version: 3.10-FINAL
Hardware: PC
OS: Windows XP
Status: NEW
Severity: normal
Priority: P2
Component: XSSF
Assignee: [email protected]
Reporter: [email protected]
I have a cell with an IF statement. The condition inside the IF statement uses
2 different unsupported functions.
example:
IF($J$5=1,SYD($B16,$D16,$C16,F$12),SLN($B16,$D16,$C16))
When I evaluated the cell, only 1 condition was evaluated by POI (which is the
TRUE part of the IF statement). In the example, only the SYD function was
detected.
Is there a way that POI will evaluate both conditions of the IF statement so
that both unsupported functions will be detected?
I am using XLSX file so I'm using XSSFWorkbook.
This is my code in evaluating the cell:
XSSFFormulaEvaluator fe = new XSSFFormulaEvaluator(wb);
fe.evaluateFormulaCell(cell);
--
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]
