Bug 39246 - 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: 2.5-FINAL
Hardware: PC Windows XP
: P2 critical (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2006-04-07 20:43 UTC by Levan Mahamed
Modified: 2008-12-29 09:01 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 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