Bug 47083 - AND Formula not working in HSSF
Summary: AND Formula not working in HSSF
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.2-FINAL
Hardware: PC Windows XP
: P1 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2009-04-23 06:02 UTC by Kiran Sireesh
Modified: 2010-06-03 07:16 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Kiran Sireesh 2009-04-23 06:02:26 UTC
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);			

I'm getting #VALUE! on the screen. It is not getting evaluated. This is very much needed.

Comment 1 Josh Micich 2009-04-23 09:26:27 UTC
Without an example spreadsheet it's hard to tell what is going wrong.  POI has quite a few junit test cases that show AND() to be working correctly.  Perhaps the problem is with one of the sub expressions.  If either evaluates to #VALUE!, that error will propagate to AND()'s return result.

You can drill down to the source of the #VALUE! error by trying things like this:
HSSFCell cell =  workbook.getSheet("Calculation").getRow(63).getCell(4);
CellValue cellValue = formulaEvaluator.evaluate(cell);            

If this doesn't help you solve your problem, please upload an example spreadsheet which demonstrates the error.
Comment 2 Nick Burch 2010-06-03 07:16:29 UTC
No response received in over a year, so assuming it's working with a newer version of POI