You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by bu...@apache.org on 2009/04/23 15:02:28 UTC
DO NOT REPLY [Bug 47083] New: AND Formula not working in HSSF
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: dev@poi.apache.org
ReportedBy: kiransireesh@gmail.com
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: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
DO NOT REPLY [Bug 47083] AND Formula not working in HSSF
Posted by bu...@apache.org.
https://issues.apache.org/bugzilla/show_bug.cgi?id=47083
Nick Burch <ni...@alfresco.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEEDINFO |RESOLVED
Resolution| |WORKSFORME
--- Comment #2 from Nick Burch <ni...@alfresco.com> 2010-06-03 07:16:29 EDT ---
No response received in over a year, so assuming it's working with a newer
version of POI
--
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
DO NOT REPLY [Bug 47083] AND Formula not working in HSSF
Posted by 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