That�s a very sensible work around, but we of course do need to fix this. On 7/10/03 2:54 AM, "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> wrote:
> > 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] > -- Andrew C. Oliver http://www.superlinksoftware.com/poi.jsp Custom enhancements and Commercial Implementation for Jakarta POI http://jakarta.apache.org/poi For Java and Excel, Got POI? --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
