Some questions about forcing recalculation

Posted by Andrew Kolesnikov on
URL: http://quantlib.414.s1.nabble.com/Some-questions-about-forcing-recalculation-tp12208.html

Hello guys.
Thank you for your priveous help - it was relly useful.
Currently, i try to solve one popular Excel problem - force recalculation within UDFs (in this case - QLXL functions). The main problem is string (ID) referring to QL add-inn objects. In QLXL there is one sophisticated way to force the correct dependency recalculation - usage trigger method for observable objects. Unfortunately this way is not relly convinient when you work within Excel workbook which contains a lot of objects (such as option trader workbooks) and data (so Ctrl+Alt+F9 method is also unaffordable). Could you suggest any decisions to clear this obstacle? For example, i tried to constuct a VBA UDFs with QLXL functions call and force recalculation in case of hitting F9 or Shift+F9, but i couldn't.
P.S. Am i right that the only way to solve this problem via C++ is to use trigger method?