Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
dlealv opened this issue May 7, 2023 · 0 comments

Comments

@dlealv
Copy link

dlealv commented May 7, 2023

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants