Bug 29241 - 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: 1.0.2
Hardware: All other
: P3 major (vote)
Target Milestone: ---
Assignee: POI Developers List
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2004-05-27 09:03 UTC by Rahul
Modified: 2008-05-17 04:45 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 Rahul 2004-05-27 09:03:05 UTC 
Hi,
I do the following using POI HSSF.

1. Create a copy of an excel template. This template contains several sheets 
and has a lot of formula fields. I have a sheet where I need to paste values 
from Database.
2. I retrieve the values from database and write into the paste sheet.
3. The cells of the paste sheet are used for many calculations.
4. I have another sheet for reading the values generated by these formulas.

But when I read the values from the read sheet, I get the values only as 0.00 
and not the formula generated values.

Please help.
Comment 1 Yegor Kozlov 2008-05-17 04:45:23 UTC 
That is expected. You'll need to calculate the value yourself:
        http://poi.apache.org/hssf/eval.html

Yegor