Dear all, I am experiencing a problem with retrieving
the result of a formula. The excel file is created by
using POI. The formula and the result all appear OK
if viewed by MSExcel. But, when try to retrieve the
cell value from such a excel using POI, the correct
result(as it is as appears on MSExcel) can not be
retrieved. The formula is SUM, and the result appearing
on the MSExcel is 15. But when retrieved, 0.0 is
obtained instead of the 15. But, if opened with MSExcel
once, and save it. Then the 15 can be retrieved.
Is this a known issue? Any workaround? Any one can help
this?
The attached is the Excel file.
Thanks a lot,
Xuemin Guan
