Feature request: Show sheet name in calc window title

[Tilman]

I am working on a really big, complicated calc document with many sheets. In this settings, it’s helpful to have multiple windows open on the same document showing different sheets.

It would be very helpful if each window title would include the currently shown sheet, so I can easily find the right window when switching windows.

[JohnSUN]

If you want workaround just set this code to Standard library

Sub SetTitleForThisFrame
Dim sURL As String
Dim aStr
Dim nameOfActiveSheet As String
Dim oCurrentController As Variant
Dim nameOfDocument As String
Dim sTitle As String
	sURL = ThisComponent.getURL()
	If sURL="" Then Exit Sub
	aStr = Split(sURL,"/")
	nameOfDocument = ConvertFromURL(aStr(UBound(aStr)))
	oCurrentController = ThisComponent.getCurrentController()
	nameOfActiveSheet = "{"+oCurrentController.getActiveSheet().getName()+"} "
	sTitle = InputBox ("Input name for this frame", "New name", nameOfActiveSheet+nameOfDocument)
	oCurrentController.getFrame().setTitle(sTitle)
End Sub

and run it for each new window of workbook. No need “sheet name”, you can set any nick

Update: See this small example, please - NamewWindows.ods

[Tilman]

Thanks for the hint! (Sorry, only now saw it!) One question: Is there some kind of hook that gets run when the page is switched, so I could run that automatically?

[JohnSUN]

What about listeners on events “View created” and “PropertyChanged” (ViewData)? I’m attach example to my answer