Hello,
I am using pov 3.0-dev to create an excel file from a template. The existing
excel file does contain some formulas. I am wrinting the raw data, which the
existing formulas evaluate.
Example:
- the formula in B1 is "=A1*2"
- in the template A1 = 50 is stored (-> B1 = 100)
- I update cell A1 to 100 (-> B1 = 200)
When I open the file in excel, B1 shows 100 until I press F2 and then Enter
(edit) on B2 -> the the formula is updated.
If I open the file in OpenOffice v2.1 the formula is recalculated.
I have read, that only Excel 97 is supposed to "forget" the recalculation
and that a possible solution is the SaveRecalcRecord class but I do not know
how to use it
Has any body the same problem with Excel 2003 (v 11.8117.8170, SP2) and / or
who can tell me, how to use the SaveRecalcRecord class.
Thanks in adance!
Kind regards
Joern
---------------------------------------------------------------------
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/
