SHEET in Calligra Sheets: Find a Worksheet’s Position

SHEET() returns the current worksheet’s one-based position in its workbook. A valid reference argument instead identifies the first sheet of that reference. This is a position, not a permanent worksheet ID: moving tabs can change it.

=SHEET()
=SHEET(reference)

The argument is optional. With no reference, the inspected implementation uses the formula’s sheet, then returns its workbook index plus one. With a valid reference region, it uses that region’s first sheet. It does not look up a sheet by interpreting arbitrary text as a name. A scalar string that does not produce a valid region falls back to the current sheet in the source.

The KDE SHEET reference describes the positional result. Do not infer another product’s sheet-name-string behavior from the shared function name.

1. Create a workbook with two worksheets and note their actual left-to-right order.
2. On the first sheet enter =SHEET() in B2; the expected position is 1.
3. On the second sheet enter the same formula; the expected position is 2.
4. On either sheet put 7 in A2 and enter =SHEET(A2) in B3. Its expected result equals that sheet’s position; the stored number 7 is not the returned index.
5. Move the second sheet to the first position and recalculate. Recheck the order rather than preserving the old expected numbers.

These are conditional expectations for the stated workbook arrangement. An existing workbook can contain additional sheets; counting only the visible examples is not sufficient evidence for its actual indexes.

A report template can put =SHEET() beside a clearly labeled “Tab position” field. If the first tab must remain a cover page, a formula on that tab can use =IF(SHEET()=1;"Cover first";"Check tab order").

This is a layout check, not a stable report identifier. Retain a separate literal report code for exported data or historical records. Reordering tabs can legitimately change every downstream position without changing the reports’ business identities.

• A valid reference supplies sheet context, not the referenced cell’s numeric content.
• More than one argument is outside the registered interface.
• Text such as "missing" is not a reliable existence test for a sheet name. Do not use its fallback result as proof that such a worksheet exists.
• For multi-region references, the implementation selects the first sheet; it does not count sheets or return a list.
• Hidden-sheet and cross-sheet-reference presentation should be checked in the actual workbook before depending on visibility or parser assumptions.
• Tab positions can change when importing, adding, removing or moving sheets. Recalculate after structural changes.

• Release checked: Calligra Sheets 26.08.2, using KDE’s release source package and release information, inspected on October 18, 2026. Relevant locations: sheets/functions/reference.cpp lines 111–114 and 592–603.
• Introduced: The original introduction version is not established by these sources. Current registration establishes presence in 26.08.2, not the first release.
• Lifecycle: Registered in the inspected release; no retirement or deprecation marker was found in this function’s registration. Retirement (removed support) and deprecation (discouraged but retained support) are different claims; neither is asserted here.
• Native testing: Selected cases were recalculated and saved in Calligra Sheets 25.04.2. The source discussion concerns 26.08.2. Unlisted examples and edge cases remain source-derived or independently calculated.

• ROW
• COLUMN
• IF
• Calligra function guide index
• KDE formula entry instructions, checked October 18, 2026. Examples use leading = and semicolons, with a period for decimal numbers. Confirm regional separators in your installation before pasting.

These results were observed in Calligra Sheets 25.04.2, after loading a corrected ODS input, recalculating and saving. Formula references and results were read back from the saved workbook. This is not a 26.08.2 native test or certification of XLSX import behavior. Other examples and unlisted edge cases remain separate source or mathematical evidence.

The tested workbook contained eight tabs in this order: SHEET, SHEETS, UNIX2DATE, VALUE, XOR, SUBTOTAL, SUMIFS, SUMSQ. SHEET was first, so all three controls returned 1. The quoted string “missing” did not identify a real worksheet; its result demonstrates the scalar fallback. Reordering and hidden-sheet cases were not exercised.

Screenshot: Genuine native 25.04.2 capture. Selected F2 contains =SHEET() and displays 1.0000000000. Column F contains application results; column G contains descriptive formula labels. The selected formula is visible in the formula bar; long labels in other rows may be clipped by the panel.