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]
