I want to pass a multidimensional array to a custom function. I do it like this: =customFunction({{a1v1; a1v2};{a2v1; a2v2; a2v3};{a3v1}})However I don't get the expected behaviour becouse it behaves like a 1-dimension array.Here you have an example of expected values:https://docs.google.com/spreadsheets/d/1YBf367DFhkwlnnsEuNxLoyWbtbo77KbH2VDEvtTf-zY/edit#gid=679698405Thanks in advance!
How to pass multidimensional array to a custom function in Spreadsheets
google spreadsheets;google apps script
You're not adding an array or string but an object. Objects are not processed as such and simply returned. Coincidentally, you discovered that a semi-colon creates a column presentation and a backslash a row presentation. If you really want to add an array notation as a parameter, then you need to do the following.Formula=customFunction([['a1v1', 'a1v2'],['a2v1', 'a2v2', 'a2v3'],['a3v1']])Codefunction customFunction(multiArray) {  return  eval(multiArray);  }ScreenshotExplainedPrepare the string with single and double quotes, in order to use text within the array. This string is then evaluated, via the eval() method, as it if were JavaScript.ExampleI've add my solution to your example file.