How to Get the Sheet Name in LibreOffice Calc
Populate a cell with the name of a sheet dynamically into your sheet. A benefit of this is to avoid typing it and updating it manually when renaming sheets or duplicating sheets. You don't want the cell to end up with the old name!
Formulas used in this video:
=CELL("filename")
=RIGHT(A1,LEN(A1)-FIND("#$",A1)-1)
Video Timestamps:
00:00 Methods to Insert Sheet Name
00:34 Using Edit Mode to Insert Sheet Name
01:40 Using Functions to Display the Current Sheet's Name
03:12 Using Functions to Display Multiple Sheets' Names
04:45 Recap, Combining Functions, Automate by Macro
Link to official help pages for these Functions:
CELL:
https://help.libreoffice.org/latest/e...
RIGHT:
https://help.libreoffice.org/latest/e...
FIND:
https://help.libreoffice.org/latest/e...
LEN:
https://help.libreoffice.org/latest/e...