Re: Quantlib objects not created outside 65, 356 row range

classic Classic list List threaded Threaded
1 message Options
Reply | Threaded
Open this post in threaded view
|

Re: Quantlib objects not created outside 65, 356 row range

Eric Ehlers-2
Hi Gavin,

On 2012-10-26 10:18, Gavin08 wrote:

> Dear community,
> I stumbled upon what seems to be a bug to me:
>
> In Excel 2010, when I try to create schedule or bond objects within
> cells on
> row 65,357 or above, the objects are actually not instantiated and
> cannot be
> used by other functions.
>
> I could reproduce this issue on a second PC. The same cell formulas
> used on
> rows below or equal 65,356 worked fine.
>
> Can somebody confirm this is a bug?
>
> Regards
> Gavin

QuantLibXL was developed under Excel 2003 where the maximum number of
rows in a worksheet is 65536.  Later versions of Excel provide new
interfaces to deal with larger worksheets but QuantLibXL has not been
upgraded to use these and so the addin malfunctions for ranges that
exceed the dimensions supported by Excel 2003.

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

------------------------------------------------------------------------------
Free Next-Gen Firewall Hardware Offer
Buy your Sophos next-gen firewall before the end March 2013
and get the hardware for free! Learn more.
http://p.sf.net/sfu/sophos-d2d-feb
_______________________________________________
QuantLib-users mailing list
[hidden email]
https://lists.sourceforge.net/lists/listinfo/quantlib-users