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 2003/12/27 05:33:39 UTC

DO NOT REPLY [Bug 25769] New: - HSSFRow.getCell() returns null for cell with formula.

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

http://nagoya.apache.org/bugzilla/show_bug.cgi?id=25769

HSSFRow.getCell() returns null for cell with formula.

           Summary: HSSFRow.getCell() returns null for cell with formula.
           Product: POI
           Version: 1.5.1
          Platform: PC
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Blocker
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: matthew.ho@consonum.com
                CC: matthew.ho@consonum.com


I have an existing spreadsheet that I use the HSSF APIs to programmatically 
retrieve values.  For the cell that has formula like "='Trip Report Form'!$C$8".
The value returned is null.  (In fact, cell that has any formula always returns 
null).

This is a show-stopper for me.  I have customer deliverable approaching.
I wonder if POI contributors can response to this one quickly.
Is there at least a workaround?  Please help!  Thanks a lot!

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