no probs (yay- my first help in POI!)
It's not quite a bug, and i doubt it'll ever get solved - you see, POI is
only a read/write engine, it does not try to mimic the rest of Excel's
functionality, such as calc engine/macro, etc... Think of it as a driver,
rather than the database server (if that helps at all)
-Max
[EMAIL PROTECTED]
i.com To: [EMAIL PROTECTED]
cc:
10/07/03 15:38 Subject: Re: Very complex
SpreadSheets...
Please respond to
poi-user
Thanx Max... That should work for me until the bug is solved. Thanx
again...
Rodrigo
----- Original Message -----
From: <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
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
>
>
>
>
>
> [EMAIL PROTECTED]
> To:
[EMAIL PROTECTED]
> 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" <[EMAIL PROTECTED]>
> > To: "POI Users List" <[EMAIL PROTECTED]>
> > 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 <[EMAIL PROTECTED]>
> > > > 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: [EMAIL PROTECTED]
> > > > For additional commands, e-mail:
[EMAIL PROTECTED]
> > > -------Original Message-------
> > >
> > >
> > >
> >
> >
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: [EMAIL PROTECTED]
> > For additional commands, e-mail: [EMAIL PROTECTED]
> >
> --
> Avik Sengupta <[EMAIL PROTECTED]>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
>
>
>
> 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: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
