A few issues with custom function parameter option documentation #4589
Open
Description
Issue 1
url1
The following sentence is probably missing a "[]":
"In Typescript, indicate that the parameter is multi-dimensional."
Issue 2
url2
Highlighted sentence does not make sense.
Issue 3
It seems like Excel can only handle the case of "one repeating parameter at the end", and not any other cases. However, this isn't clear from the documentation.
For example, suppose we have func1(required_param_1, [repeating_param_1], required_param_2)
and we pass in func1(A1, A2, A3)
, then it's not clear whether A3
corresponds to repeating_param_1
(and then required_param_2
would be null
) or required_param_2
. It's even more complex when there are mixed dimensions. The documentation should explicitly cover what is / isn't supported.