|
From: a.p. <an...@gm...> - 2008-08-25 08:52:50
|
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? -- View this message in context: http://www.nabble.com/Some-questions-about-forcing-recalculation-tp19140076p19140076.html Sent from the quantlib-dev mailing list archive at Nabble.com. |