Re: [Quantlib-dev] How to enhance QuantLibXL without breaking anything?

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

Hi Piter,

I don't understand your question, can you elaborate?

>  	* Change coupons from scalar to InterestRate object -
> it means that any current spreadsheet will fail because it is a new type
> for the field

You say "Change coupons *from scalar*", I don't understand.  In the  
latest version of QuantLibXL (0.9.7), for function qlFixedRateBond(),  
the argument "Coupons" is not a scalar, it is a vector of doubles.

Do you want a setup where

1) old spreadsheets call function qlFixedRateBond() and pass to  
argument Coupon a value of type vector<double>, and
2) new spreadsheets call the same function and pass to the same  
argument a value of type InterestRate?

If so, this could be accomplished using coercion:

     http://quantlib.org/quantlibxl/coercion.html

Regards,
Eric