INDIRECT in Collabora Office: Resolve Address Text and Control Reference Notation

• Introduced: the original Collabora release and launch date are not established by the reviewed sources.
• Availability: documented in Collabora Office 26.04 desktop help.
• Platform scope: online and mobile deployment support is not inferred from the desktop documentation.
• Checked: October 14, 2026. Function-specific documentation and independent controls; no native Collabora execution.

=INDIRECT(Ref [; A1])

Ref is text describing a cell or area. A1 equal to 0 selects R1C1 notation; omitted or nonzero A1 selects A1 notation.

In the cited Collabora help, A1 sheet-qualified text uses a dot, such as Data.C4. R1C1 sheet-qualified text uses an exclamation mark, such as Data!R4C3. Select the appropriate notation explicitly when constructing strings.

The source also states that INDIRECT recalculates whenever recalculation occurs. This does not mean it runs continuously as a clock or independently of workbook calculation settings.

Put numeric 75 in C4 and numeric 120 in C5. Enter the text C4 in A2. In B2 use:

=INDIRECT(A2)

Expected result: 75. Change A2 to the text C5, and the expected result becomes 120. Change C5 to 135, and the selected result becomes 135 after recalculation.

Those changes affect different parts of the process: the text chooses a location, while the referenced cell supplies its contents. A text string that resembles an address is not already a dereferenced value.

Keep B2 outside the addressed cells and avoid directing the string back to the formula itself. The examples do not certify circular-reference handling or exact invalid-address errors.

Enter numeric 10, 20, 30 and 40 in D2:D5. Put numeric end row 4 in A8:

=SUM(INDIRECT("D2:D"&A8))

The constructed text is D2:D4, so the expected sum is 60. Change A8 to 5 and the string becomes D2:D5, giving 100.

The user-supplied row number is part of the address-building policy. Validate it against the intended range instead of accepting arbitrary text. This example uses ordinary integer rows and does not certify malformed, reversed or out-of-bounds strings.

The resulting SUM is a normal numeric aggregation. INDIRECT supplies its reference; it does not independently define which observations ought to be included.

Create a sheet named Data and place -18 in C4. On another sheet, use these two producer formulas in B10 and B11:

=ADDRESS(4;3;1;1;"Data")
=ADDRESS(4;3;1;0;"Data")

Expected strings are Data.$C$4 and Data!R4C3. Resolve them separately:

=INDIRECT(B10;1)
=INDIRECT(B11;0)

Both have expected value -18. The second argument must match the address notation. The sheet separator changes along with that notation; a universal exclamation-mark rule would be wrong for the A1 strings documented here.

See ADDRESS for the separately documented reference modes. Absolute R1C1 addresses are used here; relative R1C1 offsets and unusual sheet-name escaping remain outside these controls.

Suppose A12 contains the number 3 and B12 contains ="D"&A12. B12 returns the text D3. =INDIRECT(B12) then has expected result 20 using the earlier D-column dataset.

The address text contains characters rather than a direct worksheet reference token. Do not assume every rename, row insertion, external-file conversion or import will rewrite constructed strings as intended. The Collabora help explicitly warns that Excel-style external addresses assembled from string functions are not automatically translated into Calc’s different external-reference syntax.

Preserve raw address components and test imported formulas with their intended file and sheet structure. These local examples require no external files or network connections.

Because the function recalculates whenever recalculation occurs, large workbooks should use it deliberately rather than replacing every ordinary reference with text. This is a documented calculation characteristic, not a measured performance claim.

The help also states that INDIRECT is saved without conversion to ODF 1.0/1.1; older Calc versions can reject its second argument. No exact last-working release or general cross-product compatibility is inferred from that warning.

Use ordinary direct references when the location is fixed and clear. SUM can consume the resolved range, while ISREF addresses a separate reference-type question. Exact native error codes and current online/mobile behavior remain unverified.

• Collabora Office 26.04: INDIRECT.
• Editorial testing standards.

Complete function-specific documentation reviewed. Worked outputs are independently modeled reference, text or arithmetic controls, not captured native application results. Unverified entry, conversion and error boundaries retain their stated scope.