Bug 39703

Summary: Unable to Read values from Formula generated excel cells.
Product: POI Reporter: kannan <akvf>
Component: HSSFAssignee: POI Developers List <dev>
Status: RESOLVED WONTFIX    
Severity: normal CC: akvf
Priority: P1    
Version: unspecified   
Target Milestone: ---   
Hardware: Other   
OS: other   

Description kannan 2006-06-02 09:33:09 UTC
Hi ,

I am using POI 2.0. In a excel if i have a cell value been computed using a
excel formula ,i couldnt able to read that.

For EX:

test.xls

A     B   C
100  200  300 = SUM(A1,B1)

in this case when i try reading this excel i can able to read 100, 200 but not
300.Even its not giving any error also.
Please revert back the solution asap.

Thanks in advance
Comment 1 Yegor Kozlov 2007-04-19 10:58:00 UTC
Not a POI bug.
Use HSSFFormulaEvaluator to evaluate formulas.

Regards,
Yegor