I am experiencing a strange issue with QuantLibXL when I use the quick-access PasteOptions/Values button on the Excel right-click toolbar (apologies for the picture: it is surprisingly hard to capture screen-grabs of right-click menus!).
Has anyone else experienced this?
If I use this button to Paste Special/Values, rather than the 'Paste Special...' sub-menu, then QuantLib seems to crash internally and all calls to the library return #NUM!. The only solution is to close and re-start Excel.
These is a simple sheet that reproduces the issue (NB Excel calculation is Automatic).
with the formulas:
So the qlCalendarAdvance() function is taking a parameter (B2) which is itself the result of a function (=B1).
Steps to reproduce the error:
- Select cell B1
- Right-click on cell B2, and choose the Paste Options / Values shortcut button (as in the picture above).
- Cell B3 turns to #NUM!
- If B2 is already hard-coded, then the error doesn't occur.
- The error does not occur 100% of the time, though much more often than not, suggesting some sort of timing issue on re-calculation.
- Clearly the work-around is to avoid that button (!).
Excel: Microsoft 365 64-bit. Version 2009 (Build 13231.20390)
QL Addin: QuantLibXL-vc141-x64-mt-s-1_16_0.xll