You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
I realized that the Script Lab custom function, cannot be invoked using the input arguments of the LAMBDA variable names defined, from the dynamic array helper functions, such as BYROW, MAP, etc. You can use it inside the LAMBDA, but not use its variable names as an input argument of the custom function.
Screenshot(s):
The request is to allow it, obviously, you can define the javascript custom function SPHEREVOLUME to allow an array as input and return an array so you don't need to invoke it via a dynamic helper array function to spill the result , but this is less flexible than being able to invoke the custom function inside any dynamic array helper function. I tested it for Excel Web, probably it has the same behavior in other Excel platforms.
Thanks in advance,
David
The text was updated successfully, but these errors were encountered:
Description:
I realized that the Script Lab custom function, cannot be invoked using the input arguments of the
LAMBDA
variable names defined, from the dynamic array helper functions, such asBYROW
,MAP
, etc. You can use it inside theLAMBDA
, but not use its variable names as an input argument of the custom function.Screenshot(s):
The request is to allow it, obviously, you can define the javascript custom function
SPHEREVOLUME
to allow an array as input and return an array so you don't need to invoke it via a dynamic helper array function to spill the result , but this is less flexible than being able to invoke the custom function inside any dynamic array helper function. I tested it for Excel Web, probably it has the same behavior in other Excel platforms.Thanks in advance,
David
The text was updated successfully, but these errors were encountered: