DO NOT REPLY [Bug 47083] AND Formula not working in HSSF

[bu...@apache.org]

https://issues.apache.org/bugzilla/show_bug.cgi?id=47083


Josh Micich <jo...@gildedtree.com> changed:

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




--- Comment #1 from Josh Micich <jo...@gildedtree.com>  2009-04-23 09:26:27 PST ---
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);
cell.setCellFormula("B13=\"ACCEPT\"");
CellValue cellValue = formulaEvaluator.evaluate(cell);            
System.out.println(cellValue.formatAsString());

If this doesn't help you solve your problem, please upload an example
spreadsheet which demonstrates the error.

-- 
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org