Bug 39703 - Unable to Read values from Formula generated excel cells.
Summary: Unable to Read values from Formula generated excel cells.
Status: RESOLVED WONTFIX
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: unspecified
Hardware: Other other
: P1 normal (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-06-02 09:33 UTC by kannan
Modified: 2007-04-19 10:58 UTC (History)
1 user (show)


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 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