hi joern,
I've got the same issue since I switched from poi 2.5.1 to 3.0.1, did
you find any solution?

Is there a bug open for this? I couldn't find anyone.

thanks
--
Paolo

On 2/7/07, joern@mueh... <joern@mueh...> wrote:
>
> 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 writing 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!
>
> PS: Sorry for the mail to the dev list....
>
> Kind regards
> Joern
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jaka...
> Mailing List:     http://jakarta.apache.org/site/mail2.html#poi
> The Apache Jakarta Poi Project:  http://jakarta.apache.org/poi/
>
>

---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi....
For additional commands, e-mail: user-help@poi....