Hey, Here it only happens with documents stored and opened by MS Excel. If you store the template with OO Calc, and use POI to generate Excels from that, the problem does not occur. Also, even with the version stored by MS Excel, OO Calc will open it just fine.
Not sure what causes this... Regards, Elvis Willems On Tue, 2007-12-11 at 15:15 +0100, Viktor Dalinger wrote: > Hi all, > > > > We have a problem by generation of Excel-sheets after the switch from > poi 2.5.1 to poi 3.0-FINAL-20070503. > > > > The Excel-formula, that are stored in one Excel-worksheet and > referenced to some other Excel-worksheets, will not be refreshed / > calculated after opening of the document. > > Just if some cell-values are changed, the calculation will be > processed. > > We tried to call calculatemethod on worksheet in order to interrupt > the calculation of formula in worksheet, but without success. > > > > Best regards > > Viktor > > > > Viktor Dalinger > > FERNBACH-Software S.A. > > Software Engineer > > Tel. + 352 / 40 22 44 330 > > [EMAIL PROTECTED] > > http://www.fernbach.com > > > > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] **** DISCLAIMER **** http://www.schaubroeck.be/maildisclaimer.htm
