The SheetName function

SHEETNAME() Description

The SHEETNAME() function returns the sheet name by serial number.

Main Features Functions SHEETNAME

Syntax:

=SHEETNAME(Seq)

Parameters:

• Seq: The sequence number of the sheet in the current workbook. If 0 (zero) is specified, the function returns a list of all sheets. If the parameter is missing, the name of the current sheet is returned.

Example Usage

The SHEETNAME() function is easy to use. You just need to specify the serial number of the sheet and LibreOffice Calc will automatically return its name:

=SHEETNAME(Seq)

We will have the following result:

This example uses the following values:

• Seq: A5 - Serial number of the sheet (2) .

Download the extension

You can use the SHEETNAME() function by installing the extension "YLC_Utilities.oxt" .

After that, this function will be available in all files that will be opened in LibreOffice Calc.