DO NOT REPLY [Bug 24205] New: - Reading value of formula from excel file

[bugzilla]

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=24205>.
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=24205

Reading value of formula from excel file

           Summary: Reading value of formula from excel file
           Product: POI
           Version: 3.0-dev
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: Major
          Priority: Other
         Component: HSSF
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


I am trying to read value generated by formula from a cell in excel file like 
"=2+2". the excel file shows 4.

But the code 

String.valueOf(cell.getNumericCellValue());

returns 0.0 instead of 4.0

I am using latest 3.0-dev POI classes. 

regards,
vikas

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]