Re: Existing Excel Files

[Dmitry Beransky <db...@dembel.org>]

Hi,

I've just tried the new 2.5 library, but it seems that the problem 
described below is still present.  I'm dealing with fairly complicated 
financial templates, so clicking on cells to update values is not 
feasible.  Is there any other way around this problem?


Thanks
Dmitry


>From: Andrew C. Oliver
>Subject: Re: Existing Excel Files
>Date: Mon, 19 Aug 2002 17:57:57 -0700
>Hi John,
>
>This is a known issue with Formula support.  Currently as I understand
>it (from a previous email) clicking on the cells can get the
>correct values.  Regardless, I've got another project I'm finishing up
>this month, and if Avik or Glen haven't fixed this by then, I will.
>
>-Andy
>
>John Rizzo wrote:
>
> >I have been trying to read/modify existing excel files with new data.
> >Writing the file out works fine and the data does appear when I open the
> >workbook in excel.  The problem is that excel doesn't seem to realize the
> >data has been altered and simple excel formulas won't update with the new
> >data.
> >
> >For example, if I have excel suming two cells and then I write the numbers 1
> >and 2 to the two cells with poi, when I open up the spreadsheet in excel,
> >the two cells have the 1 and 2, but the cell that is suming them has 0.
> >Hitting F9 or other excel force calculate functions don't seem to matter.
> >
> >Has anyone been able to workaround this?





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