Re: [Quantlib-dev] qlxl dependencies and object updates

[Peter C. <pca...@vo...>]

Eric, thank you very much. I will try to set overwrite to yes in the 
formulas, this is certainly the origin of the problem. Is it by the way 
in general useful _not_ to overwrite objects, i.e. is there a special 
reason why this parameter defaults to false?
Peter

Am 22.03.2011 23:53, schrieb Eric Ehlers:
> Hi Peter,
>
>> 2. If I have a sheet where I construct an object depending on some input
>> on the same sheet and these input cells does not change, then the
>> version of the object is updated every time I press shift F9. Why is
>> that? Excel should think that no recalculation is necessary, i.e. the
>> cell should not be dirty in the dependency tree and the version should
>> not be updated?
>
> IIRC cell X's dependencies recalculate whenever cell X recalculates, 
> whether or not the value in cell X changes.
>
>> 3. The trigger argument in constructors: Is that purely dummy forcing a
>> dependency on excel level
>
> Yes.
>
>> 4. Overwrite: I suppose that not specified means true.
>
> Not specified means false.
>
>> When I
>> recalculate a sheet very often it slows down until it is not usable any
>> more. My workaround is to call the delete all objects - method in the oh
>> on a suitable position in the recalculation loop. Then it works fine.
>> This looks like objects are not overwritten, but new objects are created
>> on every update?
>
> What does ohRepositoryObjectCount() tell you?
>
> Regards,
> Eric
>
> ===================================================
> Eric Ehlers
> nazcatech sprl | Brussels | http://www.nazcatech.be
> * Distributed computing for pricing analytics
> * Use Microsoft Excel as a client to the Grid
>