Re: qlxl dependencies and object updates

Posted by Ferdinando M. Ametrano-3 on Mar 24, 2011; 4:53pm
URL: http://quantlib.414.s1.nabble.com/qlxl-dependencies-and-object-updates-tp13212p13220.html

Hi all

as a general rule I suggest to avoid to recreate multiple time the
same object. If such a need arise it is generally an indication of bad
design: an object should be able to alter its state without being
recreated.

Anyway if you have to recreate an object multiple time this means you
create it in a dynamically changing workbook which is open and
recalculated: in this case I suggest to keep the object anonymous.
Naming it would be useless as you will have to reference it using the
cell address (or even better a named range), otherwise Excel won't
keep track of the dependency.
If you don't use names the overwrite parameter is not effective.

ciao -- nando

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