Bug 11031

Summary: Reading value of a cell having formula
Product: POI Reporter: Amit Sangal <amit_sangal>
Component: HSSFAssignee: POI Developers List <dev>
Severity: blocker    
Priority: P3    
Version: 1.5.1   
Target Milestone: ---   
Hardware: PC   
OS: All   

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.