Contact
12 programs
Explore the site

Collabora Online Calc and Collabora Office Calc · Data management · Intermediate

Create and Reuse Named Ranges in Collabora Online Calc

Define a readable range name, check its absolute reference and scope, and distinguish it from a database range.

Official documentation reviewed; independent synthetic checks; not tested in Collabora applications. · Editorial standards

Give a selected block a name, then use that name in formulas such as =SUM(Start). Verify which cells the name actually refers to; readable formulas do not guarantee that a fixed range expands when you append data.

Product scope

Collabora’s Online 25.04 announcement places named-range Define controls on the Data tab and describes address-box selection and formula autocomplete. Its 6.4.3 announcement separately documents Define and Manage Names in Online. Check your server build and interface; desktop and installed mobile applications do not necessarily use the same route.

The detailed naming/reference rules below follow Collabora Office 26.04 Naming Cells help and Define Names. Collabora Office Classic is the separate traditional desktop product. The Help label 26.04 identifies the documentation version, not a verified Classic runtime. New Collabora Office 26.04 uses an Online-style interface; traditional menu-bar routes below apply only where the installed interface actually exposes them. Use a fresh editable ODS workbook for practice.

Define a small reusable name

Enter 10 in Sheet1.A1, 20 in B1, 30 in A2 and 40 in B2. The A1:B2 range and Start name provide a small, reproducible total. The setup text file records the inputs.

  1. Select A1:B2. In Online’s tabbed interface use Data → Define in the named-range controls. In an installation exposing the traditional menu-bar Help route, use Sheet → Named Ranges and Expressions → Define.
  2. Enter Start as the name. Confirm the range/expression refers to $Sheet1.$A$1:$B$2. Use document/global scope when the name should work throughout the workbook; do not silently create a same-spelled sheet-local name.
  3. Add or confirm the definition as the dialog requires. Use Manage Names to inspect it afterward. The name should resolve to four cells, not just the active cell A1.
  4. In D1 enter =SUM(Start). The expected result is 100. Enter the same formula on another sheet to check the intended document scope. See SUM for aggregation behavior.
  5. Change Sheet1.B2 from 40 to 45. Both formulas should return 105. Restore 40 for the remaining tests.

Inspect scope and structural changes

Use the address-box dropdown where supported to select Start and inspect the highlighted cells. Names must not contain spaces; avoid names that look like cell references, such as A1. Sales_Total is clearer than a vague name that duplicates an existing definition.

Add 50 and 60 below the block in A3:B3. A definition still pointing to A1:B2 continues to total 100; appending values below it is not a reason to assume inclusion. To include them, explicitly edit the definition to $Sheet1.$A$1:$B$3 and verify a total of 210.

Inserting rows within a named block and adding rows just outside it are different operations. The help describes reference adjustment for insertions/deletions, but always inspect the resulting definition after a structural edit. Renaming or deleting a definition can affect every formula using it. Do that only after checking dependent formulas in a copy.

Named ranges are not database ranges

A named range supplies a readable reference for formulas and navigation. A database range describes a rectangular record area for data operations. For an installation exposing the traditional menu-bar route, Defining a Database Range uses Data → Define Range, with records in rows and fields in columns. That is a separate command and concept from Online’s named-range Define control; it is not asserted to be available in every Online interface.

Do not treat either one as automatically equivalent to an Excel Table, its structured references, or guaranteed auto-expansion. If you need recurring sorting/filtering of records, consider the database-range workflow only in an installation that exposes the documented controls, and test its exact options separately.

Save and portability checks

Save, close and reopen the ODS file. Verify the name, its scope, its absolute reference and the 210 result. If exchanging XLSX, reopen that exported file in the recipient’s target application and repeat those checks, including a source-value change. CSV preserves neither named ranges nor workbook formulas as reusable definitions.

If a formula returns a name error, inspect spelling and scope before rebuilding it. If the value is wrong but no error appears, check bounds and whether another local name shadows the intended document name.

Testing disclosure: The official product-specific routes and independent totals were checked. This tutorial has not been executed in Collabora Online or desktop; name creation, scope resolution and round-trip persistence need target-application verification.