Bug 11031 - Reading value of a cell having formula
Summary: Reading value of a cell having formula
Alias: None
Product: POI
Classification: Unclassified
Component: HSSF (show other bugs)
Version: 1.5.1
Hardware: PC All
: P3 blocker (vote)
Target Milestone: ---
Assignee: POI Developers List
Depends on:
Reported: 2002-07-22 09:06 UTC by Amit Sangal
Modified: 2005-03-20 17:06 UTC (History)
0 users


Note You need to log in before you can comment on or make changes to this bug.
Description Amit Sangal 2002-07-22 09:06:20 UTC
I am using jakarta-poi-contrib-1.5.1-final-20020615.jar  to read a excel file 
which is having cells of type CELL_TYPE_FORMULA.When I try to read these cell 
values while iterating over a HSSFRow , a null value is returned for the cells 
which has formula.
Please let me know whether its a bug in POI or the formula feature i snot 
supported in HSSF as of the above said version.
I will be very thankful for your sooner reply.

Amit Sangal
Comment 1 Andy Oliver 2002-09-02 00:29:19 UTC
Formulas are very definitely not part of 1.5.1.  Either use a development build
or wait.