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

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

Hi Peter,

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

Happy to help.  Usually you would allow the overwrite parameter to  
default to false.  Suppose you create an object with ID foo.  Then you  
attempt to recreate a new object foo, for example during a recalc.   
The system verifies that the new object resides in the same cell as  
the existing one, which is the usual case, and the old object is  
overwritten by the new one.  If the new object resides in a different  
cell, this usually indicates an error on the part of the user - you  
have tried to create two different objects with the same name - and  
the construction of the new object fails with an error message to the  
effect that an existing object with the same name resides in a  
different cell.  If you set overwrite to true then the creation of the  
new object will succeed even if the new object resides in a different  
cell than the old one.  There are not many situations where it is  
desirable to set overwrite to true.

I am worried that you have found a memory leak so I am curious to hear  
the results of your investigations.

Kind 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