poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Xuemin Guan <xue...@appresso.com>
Subject unable to retrieve formula result
Date Fri, 05 Sep 2003 05:19:31 GMT
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 MS-Excel. But, when try to retrieve the
cell value from such a excel using POI, the correct
result(as it is as appears on MS-Excel) can not be
retrieved. The formula is SUM, and the result appearing
on the MS-Excel is 15. But when retrieved, 0.0 is
obtained instead of the 15. But, if opened with MS-Excel
once, and save it. Then the 15 can be retrieved.

Is this a known issue? Any workaround? Any one can help

The attached is the Excel file.

Thanks a lot,

Xuemin Guan

View raw message