Work Around For 256 Character Return Limit on RTD Functions

46 views
Skip to first unread message

Alexander Rickman

unread,
Jun 20, 2023, 7:48:42 AM6/20/23
to Excel-DNA
Hi all, 

I rely heavily on the on the functionality and flexibility of the `ExcelRtdServer` class in my project, but I have noticed that the private `Topic.FixValue` function (see image below) truncates anything over 256 characters. 

Topic.FixValue.PNG

In a previous thread (256 char limit on RTD), Govert mentions that one could use the `ExceObserver`/`Observable` wrapper to overcome the character limitation, but this would be a major redesign for me that I would really like to avoid. 

Does this limitation still apply to Excel 2016 and up? Is there any way that the truncating code in `Topic.FixValue` can be deprecated? If not, is there any other suggested workaround for this? 

Best, 

Alexander
Reply all
Reply to author
Forward
0 new messages