The method getElementNames() returns an array containing the names of all named ranges. Use the methods hasByName(name) and getByName(name) to verify and retrieve a named range.

In a macro, a named range is accessed, created, and deleted using the NamedRanges property of a Calc document. Use the Define Names dialog to add and modify one named range at a time. Use Insert > Names > Define to open the Define Names dialog. To create a named range, select the range to define. For example, I created a range named Scores, and then I used the following equation: =SUM(Scores). The most common usage of a named range is, as its name implies, to associate a range of cells to a meaningful name.

The Navigator allows for quick navigation to the associated ranges. Ranges associated to a name are shown in the Navigator, which is available using the F5 key or clicking on the icon.If a range is referenced by name in multiple locations, you can point the name to another location and all references point to the new location.Associating a range with a name enhances readability by using a meaningful name.A name is usually associated with a range for one of three reasons: You can create either a database range, which has some database-like functionality, or a named range, which does not. You can associate a meaningful name to a range, which allows you to refer to the range using the meaningful name. In a Calc document, a range refers to a contiguous group of cells containing at least one cell.

Openoffice calc database