Bug 24205

Summary: Reading value of formula from excel file
Product: POI Reporter: vikas <vikasmehrotra_2000>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED INVALID    
Severity: major    
Priority: P3    
Version: 3.0-dev   
Target Milestone: ---   
Hardware: Other   
OS: other   

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.