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 2008/01/28 13:15:43 UTC

DO NOT REPLY [Bug 44306] New: - Support getCellFormula() for CHOOSE formulas without triggering EmptyStackException

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG�
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=44306>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND�
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=44306

           Summary: Support getCellFormula() for CHOOSE formulas without
                    triggering EmptyStackException
           Product: POI
           Version: 3.0-dev
          Platform: Other
        OS/Version: other
            Status: NEW
          Severity: normal
          Priority: P2
         Component: HSSF
        AssignedTo: dev@poi.apache.org
        ReportedBy: nick@torchbox.com


On a formula
    =CHOOSE(2,A2,A3,A4)

calling cell.getCellFormula() will blow up with an EmptyStackException

Not sure if it's a bug with the formula parser, or the processing of the Ptgs

Test for the Ptg parsing is in
src/testcases/org/apache/poi/hssf/record/TestFormulaRecord.java#testWithConcat()
but may not be fully correct

Test for the usermodel side is in
src/testcases/org/apache/poi/hssf/usermodel/TestBugs.java#test42618() with the
last line calling getCellFormula commented out

-- 
Configure bugmail: http://issues.apache.org/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug, or are watching the assignee.

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org