0

I am building XLL + RTD in the same dll. The RTD is not called directly from Excel but through wrapper formula. Similar to sample here Custom Functions in Excel: Part V, XLL-RTDs

The functionality seems to be working but when I edit formula inputs manually Excel confuses the edited formula with the one with topic number 0. Both ConnectData for edited item and DisconnectData for old item are called with correct topic ids.

What might be solution for this?

SparcU
  • 742
  • 1
  • 7
  • 27
  • Could you post your wrapper and some example of the formula and your edits? Excel will call Connect & Disconnect if the RTD function is called with new topic strings. – Govert Mar 09 '13 at 20:13
  • It is quite a big project I can not isolate functionality. Both Connect and Disconnect are called with correct values. The issue is that when function is triggered by RTD RefreshData Excel thinks it was called from fifferent location. The one where topicId = 0. – SparcU Mar 10 '13 at 22:46
  • What do you mean by "Excel thinks it was called from different location"? Excel calls your RTD server's RefreshData function, and you must return the topics to be updated. I'm not sure how you are inferring the 'location that Excel thinks it was called from'. – Govert Mar 11 '13 at 10:15
  • I use Excel4( xlfCaller, &xlOut, 0 ) ; return &xlOut; Somehow when I edit inputs in place Excel will return address of different cell here. – SparcU Mar 12 '13 at 19:05
  • Is this in your wrapper UDF? Is this perhaps an array formula? – Govert Mar 12 '13 at 19:35
  • I found the bug. It was in addTopic processing. Thank you Govert for trying to help. Your library is fantastic I use it a lot. – SparcU Mar 12 '13 at 23:37
  • Thanks - I'm glad there's not another RTD bug to deal with... – Govert Mar 13 '13 at 08:48

0 Answers0