Hey, this is a known bug, (No 21442). But I hope it will be fixed soon.
Meike ----- Original Message ----- From: "Rodrigo Reyes" <[EMAIL PROTECTED]> To: "POI Users List" <[EMAIL PROTECTED]>; "Avik Sengupta" <[EMAIL PROTECTED]> Sent: Wednesday, July 09, 2003 10:11 PM Subject: Re: Very complex SpreadSheets... > 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] > --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
