[Libreoffice-bugs] [Bug 132136] The reference via the ADDRESS function should also work with the table number.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=132136

--- Comment #2 from Jürgen Kirsten <dscheikey at gmail.com> ---
Function Sheetname(Optional No) As String

        On Error GoTo Errorhandler
        IF IsMissing(No) Then 
        Sheetname = ThisComponent.CurrentController.ActiveSheet.name
        Else
        Sheetname = ThisComponent.Sheets(No - 1).name
        End If

Exit Function   
        Errorhandler: 
        Sheetname = Error

End Function

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200821/30424809/attachment.htm>