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]
