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

[Eric E. <eri...@na...>]

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