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

[Ferdinando A. <na...@am...>]

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