Documentation/Calc Functions/SHEETS

From The Document Foundation Wiki
Jump to: navigation, search


Im-jabber.svg

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


Function name:

SHEETS

Category:

Spreadsheet

Summary:

Determines the number of sheets in a reference. If you do not enter any parameters, it returns the number of sheets in the current document.

Syntax:

SHEETS(Reference)

Returns:

Arguments:

Reference is the reference to a sheet or an area. This parameter is optional.

Additional details:

Examples:

=SHEETS(Sheet1.A1:Sheet3.G12) returns 3 if Sheet1, Sheet2, and Sheet3 exist in the sequence indicated.

Related LibreOffice functions:

ODF standard:

Equivalent Excel functions: