Return-Path: Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 64662 invoked from network); 10 Jul 2003 14:11:40 -0000 Received: from unknown (HELO set.superlinksoftware.com) (66.35.175.110) by daedalus.apache.org with SMTP; 10 Jul 2003 14:11:40 -0000 Received: from 66.147.173.240 ([66.147.173.240]) by set.superlinksoftware.com (JAMES SMTP Server 2.1) with SMTP ID 506; Thu, 10 Jul 2003 08:35:10 -0400 (EDT) User-Agent: Microsoft-Entourage/10.1.0.2006 Date: Thu, 10 Jul 2003 10:11:40 -0400 Subject: Re: Very complex SpreadSheets... From: "Andrew C. Oliver" To: POI Users List CC: POI Developers List Message-ID: In-Reply-To: Mime-version: 1.0 Content-type: text/plain; charset="ISO-8859-1" Content-transfer-encoding: quoted-printable X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N Status: O X-Status: X-Keywords: X-UID: 85 That=B9s a very sensible work around, but we of course do need to fix this. On 7/10/03 2:54 AM, "max.nam@jpmorgan.com" wrote: >=20 > I've achieved that using excel itself - by embedding a macro that > recalculates a given sheet on open, ie: >=20 > Private Sub Workbook_Open() >=20 > Sheet1.Calculate >=20 > End Sub >=20 > this works fine with poi > 1.9 >=20 >=20 >=20 >=20 > =20 > avik@apache.org > To: > poi-user@jakarta.apache.org > 10/07/03 05:28 cc: > Please respond to Subject: Re: Very complex > SpreadSheets... =20 > poi-user > =20 > =20 >=20 >=20 >=20 >=20 > 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. >=20 > HTH > - > Avik >=20 >=20 > 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... >>=20 >> Rodrigo >>=20 >> ----- Original Message ----- >> From: "Avik Sengupta" >> To: "POI Users List" >> Sent: Wednesday, July 09, 2003 1:55 PM >> Subject: Re: Very complex SpreadSheets... >>=20 >>=20 >>>=20 >>> 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 t= o >> 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. >>>=20 >>> 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. >>>=20 >>> In summary, many of us use POI regularly in production both for reading >> and writing, but YMMV. >>>=20 >>> Regards >>> - >>> Avik >>>=20 >>>=20 >>>=20 >>> -------Original Message------- >>>> From: Rodrigo Reyes >>>> Subject: Very complex SpreadSheets... >>>> Sent: 09 Jul 2003 23:23:55 >>>>=20 >>>> 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... >>>>=20 >>>> Rodrigo >>>>=20 >>>>=20 >>>>=20 >>>=20 >>>=20 > --------------------------------------------------------------------- >>>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org >>>> For additional commands, e-mail: poi-user-help@jakarta.apache.org >>> -------Original Message------- >>>=20 >>>=20 >>>=20 >>=20 >>=20 >>=20 >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org >> For additional commands, e-mail: poi-user-help@jakarta.apache.org >>=20 > -- > Avik Sengupta >=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: poi-user-help@jakarta.apache.org >=20 >=20 >=20 >=20 >=20 >=20 > This communication is for informational purposes only. It is not intende= d as > an offer or solicitation for the purchase or sale of any financial instru= ment > or as an official confirmation of any transaction. All market prices, dat= a > and other information are not warranted as to completeness or accuracy an= d > are subject to change without notice. Any comments or statements made her= ein > do not necessarily reflect those of J.P. Morgan Chase & Co., its > subsidiaries and affiliates. >=20 >=20 > --------------------------------------------------------------------- > To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org > For additional commands, e-mail: poi-user-help@jakarta.apache.org >=20 --=20 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?