Bug 24205 - Reading value of formula from excel file
Summary: Reading value of formula from excel file
Status: RESOLVED INVALID
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 3.0-dev
Hardware: Other other
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2003-10-29 06:07 UTC by vikas
Modified: 2004-11-16 19:05 UTC (History)
0 users


Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description vikas 2003-10-29 06:07:58 UTC 
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
Comment 1 Avik Sengupta 2003-10-29 07:15:18 UTC 
use 2.0pre3. What do you mean by 3.0? are u using CVS HEAD directly, dont do
that.. thats unstable. if using CVS, use REL_2_BRANCH. This functionality is
well tested , and does work. If you still cant get it to work with 2.0pre3 ,
reopen this bug with example worksheet that replicates the problem.