XLOPER12

[igitur]

Hi Eric,

I noticed that a formula like =ohPack(A1:F70000) returns #N/A. In fact, the largest row number to give a correct return value is =ohPack(A1:F65535).

I'm guessing this is an Excel4 vs Excel12 issue. I tried to make sense of the xlsdk and it seems in many places it's using XLOPER. Other places OPER is used, which typedefs back to XLOPER. I'm not sure whether the distinction there is relevant.

Do you think changing from XLOPER to XLOPER12 would fix the issue above? Of course this will break compatability with Excel 2003 and lower, but I think that would be OK.

[igitur]

Sorry, wrong repo. Moved to eehlers/QuantLibAddin-Old#24