Hi,
I found this example on registerMathMethod in the documentations:
For example, let’s create a function “FIRST” that will return the value of the first cell in a range. So, we should add our function to the list as follows:
$$("ss").registerMathMethod("FIRST", function(range){
return range[0];
});
And we can use the new method as:
=FIRST(H3:H5);
However, this is limited to having one dimensional arrays. H3 to H5
In case I am giving =FIRST(H3:I5)
, the argument range comes in as an array of length 6 with 6 values in a single dimensional array. I want it to be a 2 dimensional array so that I know which values belong to which row or column.
Is this supported. Please help!!
Thanks in advance!