Status:
New
Inconsistency with XLL in custom functions: when using matrix arguments, do not pass blanks as 0
1. Create a custom function with one argument. 2. For the argument, specify type: 'any', dimensionality: 'matrix' and repeating: true. 3. Invoke this function like =MYFUNC("A",M1,"B") where M1 is a...
AdrianWu
Microsoft
MicrosoftHi, thank you very much for the suggestion! This issue was fixed in the last Q3 and the update was shared on the monthly community call. Please check here for more information:
https://youtu.be/12mHuf7qAkg?si=0ealfKHkOW1odJ_R&t=728
Hope this is helpful! Thank you!!