I am struggling to use the function getCellRangeByName correctly, due to the way the documentation is written.
The first problem I figured out is that Calc requires a semi-colon as a parameter delimiter, yet the documentation usually states to use a comma. This resulted in error 508, which the help documentation incorrectly states is a missing bracket. I tried taking the delimiter out, as the documentation for this specific function does not list one, or perhaps lists white space as one, this resulted in error 509.
Now I have error `#NAME`, which is equally confusing because there is no name type of parameter, despite the name of the function containing the phrase "ByName".
Clearly I cannot understand the documentation as written, so I appreciate any clarity you can provide.
Here is the documentation I am referring to: https://www.openoffice.org/api/docs/com ... angeByName
Here is the most basic formula I am trying to get to work:
Code: Select all
=getcellrangebyname("A1"; "A1:C5")