Bug 39246

Summary: Unable to Read values from Formula generated excel cells.
Product: POI Reporter: Levan Mahamed <mahamud.mahamed>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WONTFIX    
Severity: critical    
Priority: P2    
Version: 2.5-FINAL   
Target Milestone: ---   
Hardware: PC   
OS: Windows XP   

Description Levan Mahamed 2006-04-07 20:43:26 UTC 
I am having problem with reading cell values from excell sheet genarated by 
formula. I could see the cell with value example 99.99. but I am getting the 
value as 0.00

In my output sheet, i have other cells that use formula values and I able to 
read it them fine.

Any Idea why would it happen to certain cells containing formula.

Any help is appreciated.

Levan
Comment 1 Yegor Kozlov 2008-12-29 09:01:28 UTC 
HSSFCell.getNumberCellValue() does not evaluate cell formulas, it just returns the precalculated formula value or 0.0 if it is not set.

Please follow the formula evaluation guide:
http://poi.apache.org/spreadsheet/eval.html

Yegor