Allow Script Lab custom function to be invoked inside dynamic array helper function using LAMBDA names
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 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