SHEET Function (OpenOffice Calc)

• Introduced: First release not established; documented by OpenOffice.org 3.3.
• Supported in: Apache OpenOffice 4.1.16; no final supported release is established.
• Scope: English desktop Calc, semicolon-separated formulas and local workbook references.
• Checked: October 14, 2026. Eight examples were recalculated in 4.1.16 on Linux x86-64, Build9816. Generated-ODF identities, saved results and controls were checked; no manual-entry or different-release test is claimed.

SHEET returns a sheet’s one-based position in the current workbook. With no argument it uses the sheet containing the formula. With a cell reference it uses that reference’s sheet, and the inspected implementation also accepts the name of an existing local sheet as text. Release implementation.

SHEET([Reference_or_SheetName])

The optional argument is a cell/range reference or sheet-name text. A name such as "Inputs" identifies a sheet, while Inputs.A1 is a reference to a cell on it. Omission asks for the current formula’s sheet position.

Create exactly three sheets in this order: Reference, Inputs, Archive. Put all eight output formulas on Reference. Inputs.A1 contains 20 and Archive.A1 contains 30; those values do not determine their sheet indices.

All eight formulas were recalculated. Quotation marks identify text results; unquoted #N/A identifies an error. Logical tests in the explicitly number-formatted output cells are shown as 1/0. Reference expectations follow the inspected callback, workbook structure and ordinary arithmetic.

On Reference, =SHEET() returns 1. =SHEET(Inputs.A1) returns 2 and =SHEET(Archive.A1) returns 3. This is useful when a workbook’s organization matters, but the result is an ordinal position rather than a permanent sheet identifier.

The text-name versions =SHEET("Inputs") and =SHEET("Archive") return the same respective positions. Do not confuse quoting a sheet name with quoting an entire address string. Keep references and labels intentional when adapting the formula to a workbook with different names.

A rectangular range on Reference still identifies that sheet, so =SHEET(H2:H3) returns 1. For the tested three-dimensional range Inputs.A1:Archive.A1, the source takes the first sheet endpoint and returns 2; it does not return the two-sheet span length.

Use SHEETS for that span-count question. In the same three-sheet setup, SHEETS() is 3, while SHEET() on Reference is 1. The numeric contents of Inputs.A1 and Archive.A1 can change without changing these positional answers.

Reordering or inserting sheets can change a position even when the human-readable sheet name is unchanged. These tests used the fixed order above; they did not execute a reorder scenario. Treat a stored sheet index as structure-dependent metadata rather than a stable key for external records.

The source accepts zero or one argument and resolves text as an existing local sheet name. Unknown names and non-reference numeric arguments have error branches, but those branches were not executed here.

Three-dimensional references carry both sheet and row/column endpoints. This guide establishes the first-sheet result for the displayed ordinary range, not every malformed or external reference. Names containing spaces also require the appropriate quoting in a reference expression; the simple local names above avoid that additional syntax issue. No external workbook or network access was involved.

SHEETS, ROW, COLUMN.

• Function-specific implementation
• Release function description and argument metadata
• English function identity

The generated ODF was opened in the native GUI, hard-recalculated and saved separately. The informational “Not all attributes could be read” load warning was retained. A deliberately stale SUM cache refreshed to 3, and an uncached SUM returned 7. The exact local inputs, sheet order, formula identities and saved values were reconciled. The authoring-tool XLSX and its previews were not used as native calculation evidence. Only the listed cases and release are covered.