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