Naming sheet tabs

[PeteofEbor]

I suspect there isn’t, but I’ll ask anyway… Is there any way to dynamically name and rename sheet tabs in calc ? For example, I may want to change the tab name to mirror the text string in a particular cell ?

[Lupp]

Thinkable rules for naming sheets are so manifold that I cannot imagine a tool automatimg it in a way needing less input than direct renaming per sheet. If you actually think to need an automatism for one specific rule (first word from cell A1 e.g.) you can implement it by rather simple user code. However, you have to provide a handling for the case that action cannot be performed. You cannot have two sheets with the same name e.g.
Example code in Basic:

REM  *****  BASIC  *****
Sub nameSheetsA1()
doc0          = ThisComponent
theSheets     = doc0.Sheets
For Each oneSheet in theSheets
  strA1         = oneSheet.getCellRangeByName("A1").String
  renameSheet(oneSheet, Split(strA1, " ")(0))
Next oneSheet
End Sub

Sub renameSheet(pSheet As Object, pNewName) As String
On local Error Goto lError
pSheet.Name = pNewName
Goto ok
lError:
MsgBox("Action ""renameSheet"" failed.")
ok:
End Sub  

BTW: You don’t name the tabs but the sheets. The tabs are a kind of labels showing the sheet names.