poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From bugzi...@apache.org
Subject DO NOT REPLY [Bug 29241] New: - Unable to Read values from Formula generated excel cells.
Date Thu, 27 May 2004 09:03:06 GMT
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=29241>.
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=29241

Unable to Read values from Formula generated excel cells.

           Summary: Unable to Read values from Formula generated excel
                    cells.
           Product: POI
           Version: 1.0.2
          Platform: All
        OS/Version: Other
            Status: UNCONFIRMED
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: poi-dev@jakarta.apache.org
        ReportedBy: zangojain@indiatimes.com


Hi,
I do the following using POI HSSF.

1. Create a copy of an excel template. This template contains several sheets 
and has a lot of formula fields. I have a sheet where I need to paste values 
from Database.
2. I retrieve the values from database and write into the paste sheet.
3. The cells of the paste sheet are used for many calculations.
4. I have another sheet for reading the values generated by these formulas.

But when I read the values from the read sheet, I get the values only as 0.00 
and not the formula generated values.

Please help.

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


Mime
View raw message