Argument Truncation Warning

85 views
Skip to first unread message

Anthony

unread,
Apr 7, 2025, 3:45:22 PM4/7/25
to Excel-DNA
My UDF is working (almost) fine but I see the message below. The problem i see is that the Intellisense for the UDF is only showing the first 24 parameters of the 39 total parameters. (I know 39 is a lot -- it's our users' decision, not mine).

Is it possible to make Intellisense   show up for all 39 parameters?


Registration [Warning] Truncated argument names of function 'Alamo.DEV.CREATE_TREASURY_FUTURES_TRADES'

Govert van Drimmelen

unread,
Apr 14, 2025, 6:29:58 AM4/14/25
to Excel-DNA
When we register a function with Excel, the argument names are put into a single string passed to the registration function. This string is limited by Excel to 255 characters (including the list separators). So, you can have more argument names if the names are shorter.

-Govert

Tom Baxter

unread,
Apr 15, 2025, 11:06:49 AM4/15/25
to Excel-DNA
Thank you, Govert,

Is there any way to circumvent this behavior or is it simply an artifact of Excel 365?

Reply all
Reply to author
Forward
0 new messages