(ODF TC in CC)
Dear Andreas,
I hope you are well. I know that you have left ODF TC due to lack of
time. But maybe you can still help us with this problem:
The functions HLOOKUP, LOOKUP, MATCH and VLOOKUP have parameters of type
"ForceArray Reference|Array" in the syntax. What does "Reference|Array"
mean in this context? These are the only functions in the standard with
such a parameter type.
Would it be possible to simply use "ForceArray Array" as the parameter
type in the syntax of all these functions?
The background to my question is that the ODF TC is in the process of
adding functions to the standard, that correspond to the Excel functions
XLOOKUP, XMATCH, SORT, SORTBY and FILTER.
Kind regards,
Regina