[Solved] Confusion RE: getCellRangeByName

[Fizzle_Fuze]

Greetings!

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")

Thanks in advance!

[FJCC]

getCellrangeByName is a function in the Application Programming Interface, i.e. it is used within macros, and you cannot use it in a cell in a spreadsheet. Calc functions in cells use the semicolon as the argument separator, functions in the API use a comma as the separator.

I am not sure what you are trying to do with the function. Can you please explain your goal?

[Villeroy]

Calc works like any other spreadsheet program. The documentation you refer to has nothing to do with Calc as a user application. It refers to the application programming interface.
----------
A reference to a cell range works like this when you need to sum up its numbers:
=SUM(A1:B10)

For all the rest you may use any old Excel book from the 90ies (with minor differences).

[Fizzle_Fuze]

getCellrangeByName is a function in the Application Programming Interface, i.e. it is used within macros, and you cannot use it in a cell in a spreadsheet. Calc functions in cells use the semicolon as the argument separator, functions in the API use a comma as the separator.

I am not sure what you are trying to do with the function. Can you please explain your goal?

Thank you very much for your reply, it is quite informative.

My goal is to use the value of a cell, which is referenced from within a range, in a formula.

E.g: I wish to use the number in the second row of the third column within the range named "TestRange" in a formula such as `x+1`.

[Villeroy]

Use the INDEX function.