script-lab icon indicating copy to clipboard operation
script-lab copied to clipboard

Allow Script Lab custom function to be invoked inside dynamic array helper function using LAMBDA names

Open dlealv opened this issue 2 years ago • 0 comments

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):

image

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

dlealv avatar May 07 '23 20:05 dlealv