|Summary:||Reading value of a cell having formula|
|Product:||POI||Reporter:||Amit Sangal <amit_sangal>|
|Component:||HSSF||Assignee:||POI Developers List <dev>|
Description Amit Sangal 2002-07-22 09:06:20 UTC
Hi, 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. Rgds, 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.