Documentation/Calc Functions/SHEET

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

Under construction.
For now, see the system Help files.


Function name:

SHEET

Category:

Spreadsheet

Summary:

Returns the sheet number of a reference or a string representing a sheet name. If you do not enter any parameters, the result is the sheet number of the spreadsheet containing the formula.

Syntax:

SHEET(Reference)

Returns:

Arguments:

Reference is optional and is the reference to a cell, an area, or a sheet name string.

Additional details:

Examples:

=SHEET(Sheet2.A1) returns 2 if Sheet2 is the second sheet in the spreadsheet document.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: