Groups keyboard shortcuts have been updated
Dismiss
See shortcuts

All timing which all ExcelFunctions in the sheet are called automatically.

45 views
Skip to first unread message

김현욱

unread,
Dec 20, 2024, 4:12:55 AM12/20/24
to Excel-DNA
Hello,
Thank you for your your support!
When we using UDF function (method which is marked as [ExcelFunction] annotation) , it seems for all UDF functions in the sheet to be called automatically in various case.
First time I thought that when some row or column deleted, when data filter of some item is applied or removed it's called.
But as my observation now, it's called when I just type any characters in any cell of sheet after registration of ExcelDnaXll64 (only first time after registration).

So I need to know in which cases, all ExcelFunction (method which is marked as [ExcelFunction] annotation) in the sheet are called for proper handling in each case.

Thank you!

Snake David

unread,
Dec 21, 2024, 11:28:54 PM12/21/24
to Excel-DNA
did you ever tried use this modifier?

[ExcelFunction(IsVolatile=false)]

Reply all
Reply to author
Forward
0 new messages