https://issues.apache.org/bugzilla/show_bug.cgi?id=47083
Summary: AND Formula not working in HSSF
Product: POI
Version: 3.2-FINAL
Platform: PC
OS/Version: Windows XP
Status: NEW
Severity: critical
Priority: P1
Component: HSSF
AssignedTo: [email protected]
ReportedBy: [email protected]
I've got the following formula in a cell: =AND(B13="ACCEPT",B58="Inforce")
When the above cell is evaluated using formula evaluator, using the following
snippet
HSSFCell cell = workbook.getSheet("Calculation").getRow(63).getCell(4);
CellValue cellValue = formulaEvaluator.evaluate(cell);
System.out.println(cellValue.formatAsString());
I'm getting #VALUE! on the screen. It is not getting evaluated. This is very
much needed.
Regards,
Kiran
--
Configure bugmail: https://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- 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]
