I've searched the archives and seen similar issues to the one
described below, but was unable to find a solution.
As a test case, I've created a workbook in Excel 2004 with a single
row. Cells A1 and B1 are empty, and cell C1 has a simple formula:
=SUM(A1*B1). Using POI, I open this workbook and populate cells A1 and
B1, and save the workbook as a new file.
Under POI 3.0.x (both the final and the beta), I'm able to write the
file successfully; however when the file is opened in Excel, the value
for C1 is not calculated.
Under POI 2.5.1 with the same procedure, when the file is opened in
Excel after writing from POI, the value in C1 is calculated correctly.
Calculation settings in Excel do not seem to effect the outcome.
Additionally, a macro-based solution to this problem is not preferred,
as macros are unavailable in the forthcoming Office 2008 for Mac OS X.
I've seen this problem described before, but has anyone seen a
solution to it?
Cheers,
James
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
