Hi,
I am facing difficulties while reading formula cell values with POI version
2.5.
I have created formula cell as follows:
cell.setCellType(HSSFCell.CELL_TYPE_FORMULA);
cell.setCellFormula("SUM(D8..F8)");
And I am reading it as follow:
double formulaCellValue = row.getCell((short) 7).getNumericCellValue();
When read this way(using getNumericCellValue()), I am always getting the value
of 0.0.
Any quick help in this regard would be highly appriciated.
Thanks in advance,
Yogita.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
Mailing List: http://jakarta.apache.org/site/mail2.html#poi
The Apache Jakarta Poi Project: http://jakarta.apache.org/poi/
