Calc: How to use the table name in a formula?

Discuss the spreadsheet application
Post Reply
UdoMM

Calc: How to use the table name in a formula?

Post by UdoMM »

Hi there!

I'd like to use the name of a table (e.g. "January") in a formula to make it appear in a certain cell.

How can this be accomplished?

I managed to get the table's number using "TABELLE()" but the number is not what I need, I need the name.

Couldn't find that function in the help.

Thanks in advance!

UdoMM
:
<><
User avatar
Villeroy
Volunteer
Posts: 31279
Joined: Mon Oct 08, 2007 1:35 am
Location: Germany

Re: Calc: How to use the table name in a formula?

Post by Villeroy »

=MID(CELL("filename");FIND("#$";CELL("filename"))+2;LEN(CELL("filename")))
Please, edit this topic's initial post and add "[Solved]" to the subject line if your problem has been solved.
Ubuntu 18.04 with LibreOffice 6.0, latest OpenOffice and LibreOffice
Post Reply