Documentation/Calc Functions/SHEETS

From The Document Foundation Wiki
Jump to navigation Jump to search


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:

Returns a positive whole number ranging from 1 to 32,000 which is the number of sheets in the Reference or current document.

Arguments:

Reference is the reference to a sheet or a named area.

  • If Reference is an invalid value then the function returns an error value.

Additional details:

  • Hidden sheets are not excluded from the sheet count.

Examples:

Formula Description Returns
=SHEETS(Sheet1.A1:Sheet3.G12) The function counts Sheet1, Sheet2, and Sheet3. 3
=SHEETS() where the document contains 2 sheets Since no Reference is available the function counts all sheets a document contains. 2
=SHEETS(MySheets) where "MySheets" is a named area containing Sheet1.A1:Sheet2.G12 The function counts Sheet1 and Sheet2 from the named area. Here we are using 3D referencing. 2

Related LibreOffice functions:

COLUMNS

ROWS

ODF standard:

Section 6.13.32, part 2

Equivalent Excel functions:

SHEETS