Posted by
Eric Ehlers-2 on
Mar 22, 2011; 10:53pm
URL: http://quantlib.414.s1.nabble.com/qlxl-dependencies-and-object-updates-tp13212p13213.html
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
------------------------------------------------------------------------------
Enable your software for Intel(R) Active Management Technology to meet the
growing manageability and security demands of your customers. Businesses
are taking advantage of Intel(R) vPro (TM) technology - will your software
be a part of the solution? Download the Intel(R) Manageability Checker
today!
http://p.sf.net/sfu/intel-dev2devmar_______________________________________________
QuantLib-dev mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-dev