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]
