poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew C. Oliver" <acoli...@apache.org>
Subject Re: Very complex SpreadSheets...
Date Thu, 10 Jul 2003 14:11:40 GMT
That¹s 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" <max.nam@jpmorgan.com> 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
> 
> 
> 
> 
>                  
>                     avik@apache.org
>                                              To:
> poi-user@jakarta.apache.org
>                     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" <avik.sengupta@itellix.com>
>> To: "POI Users List" <poi-user@jakarta.apache.org>
>> 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 <rodrigo@instaservi.com>
>>>> 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: poi-user-unsubscribe@jakarta.apache.org
>>>>  For additional commands, e-mail: poi-user-help@jakarta.apache.org
>>>    -------Original Message-------
>>> 
>>> 
>>> 
>> 
>> 
>> 
>> ---------------------------------------------------------------------
>> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
>> For additional commands, e-mail: poi-user-help@jakarta.apache.org
>> 
> --
> Avik Sengupta <avik@apache.org>
> 
> 
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 
> 
> 
> 
> 
> 
> 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: poi-user-unsubscribe@jakarta.apache.org
> For additional commands, e-mail: poi-user-help@jakarta.apache.org
> 

-- 
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?


Mime
View raw message