Posted by
Peter Caspers-2 on
Mar 23, 2011; 8:03pm
URL: http://quantlib.414.s1.nabble.com/qlxl-dependencies-and-object-updates-tp13212p13214.html
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
>
------------------------------------------------------------------------------
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