Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm
Message-ID: <019d01c346f0$f4db3d50$0400a8c0@orion>
From: "Rodrigo Reyes" <rodrigo@instaservi.com>
To: "POI Users List" <poi-user@jakarta.apache.org>
References: <OF9148CAFB.62AF3A8E-ON80256D5F.0025C949@ny.jpmorgan.com>
Subject: Re: Very complex SpreadSheets...
Date: Thu, 10 Jul 2003 09:38:29 -0500
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
Status: O

Thanx Max... That should work for me until the bug is solved. Thanx again...

Rodrigo

----- Original Message ----- 
From: <max.nam@jpmorgan.com>
To: <poi-user@jakarta.apache.org>
Cc: <poi-user@jakarta.apache.org>
Sent: Thursday, July 10, 2003 1:54 AM
Subject: Re: Very complex SpreadSheets...


>
> I've achieved that using excel itself - by embedding a macro that
> recalculates a given sheet on open, ie:
>
> Private Sub Workbook_Open()
>
>     Sheet1.Calculate
>
> End Sub
>
> this works fine with poi > 1.9
>
>
>
>
>
>                       avik@apache.org
>                                                To:
poi-user@jakarta.apache.org
>                       10/07/03 05:28           cc:
>                       Please respond to        Subject:  Re: Very complex
SpreadSheets...
>                       poi-user
>
>
>
>
>
>
> You've already found the bug, but just to be clear... you'll still have
> to open the sheet in excel for it to recalculate.. there is no way to
> recalculate it within poi. the bug is for the fact that the
> recalculation should happen transparently as soon as the sheet is
> opened, but sometimes doesnt, and forces you to click on each cell to
> ensure recalculation.
>
> HTH
> -
> Avik
>
>
> On Thu, 2003-07-10 at 01:41, Rodrigo Reyes wrote:
> > Thanx Avik... still, do you know if there is some way to have the entire
> > file recalculated? When doing my preliminary tests I found that when I
> > changed the value of a cell which was an input for a formula in another
> > cell, the value from the formula cell never got recalculated until I
> > refreshed the sheet in Excel. Is there anyway to have this recalculated?
> > Thanx...
> >
> > Rodrigo
> >
> > ----- Original Message -----
> > From: "Avik Sengupta" <avik.sengupta@itellix.com>
> > To: "POI Users List" <poi-user@jakarta.apache.org>
> > Sent: Wednesday, July 09, 2003 1:55 PM
> > Subject: Re: Very complex SpreadSheets...
> >
> >
> > >
> > > The only honest answer can be to test with your sheet. Anything else
is
> a
> > guess at best. We have used poi with very complex sheets, yet known it
to
> > fail on a particular cell for a simple sheet. All we can say is, its
> getting
> > better all the time, and if it passes your tests, go for it.
> > >
> > > As a side note, let me also mention, that for writing worksheets,
> having
> > poi pass your tests if a safe bet to use it in production, since most
> likely
> > you are sure of how it is being used. Reading is more risky, since you
> might
> > be hit with random sheets, and you will have to make a more careful
> analysis
> > of the risk with specific regard to your application and your users.
> > >
> > > In summary, many of us use POI regularly in production both for
reading
> > and writing, but YMMV.
> > >
> > > Regards
> > > -
> > > Avik
> > >
> > >
> > >
> > >    -------Original Message-------
> > >    > From: Rodrigo Reyes <rodrigo@instaservi.com>
> > >    > Subject: Very complex SpreadSheets...
> > >    > Sent: 09 Jul 2003 23:23:55
> > >    >
> > >    >  Hi all
> > >    >      I am helping a friend who wants to fill a spreadsheet with
> > information
> > >    >  from a DB. This spreadsheet is very complex, with lots of sheets
> and
> > macros.
> > >    >  Will HSSF be able to load this kind of spreadsheet and fill the
> > information
> > >    >  we need without corrupting it? Once the info is filled, is there
> > someway to
> > >    >  have all the information recalculated? Thanx...
> > >    >
> > >    >  Rodrigo
> > >    >
> > >    >
> > >    >
> > >
> >   >
> ---------------------------------------------------------------------
> > >    >  To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > >    >  For additional commands, e-mail:
poi-user-help@jakarta.apache.org
> > >    -------Original Message-------
> > >
> > >
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> > For additional commands, e-mail: poi-user-help@jakarta.apache.org
> >
> --
> Avik Sengupta <avik@apache.org>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>
>
>
>
>
>
> This communication is for informational purposes only.  It is not intended
as
> an offer or solicitation for the purchase or sale of any financial
instrument
> or as an official confirmation of any transaction. All market prices, data
> and other information are not warranted as to completeness or accuracy and
> are subject to change without notice. Any comments or statements made
herein
> do not necessarily reflect those of J.P. Morgan Chase & Co., its
> subsidiaries and affiliates.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>