[Libreoffice-bugs] [Bug 132136] The reference via the ADDRESS function should also work with the table number.
https://bugs.documentfoundation.org/show_bug.cgi?id=132136 --- Comment #3 from Jürgen Kirsten --- Unfortunately, a function SHEETNAME() has still not been introduced in LibreOffice Calc. The implementation does not seem particularly difficult. No one has yet been able to give me an answer to the question of what I should do with the sheet number that I can read out with SHEET(). Without a referencing with the SHEET number or with the help of SHEETNAME() in ADDRESS, this information is of no use to me. -- You are receiving this mail because: You are the assignee for the bug.
[Libreoffice-bugs] [Bug 132136] The reference via the ADDRESS function should also work with the table number.
https://bugs.documentfoundation.org/show_bug.cgi?id=132136 --- Comment #2 from Jürgen Kirsten --- 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.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132136] The reference via the ADDRESS function should also work with the table number.
https://bugs.documentfoundation.org/show_bug.cgi?id=132136 Eike Rathke changed: What|Removed |Added Status|UNCONFIRMED |NEW Version|7.0.0.0.alpha0+ |Inherited From OOo Whiteboard| QA:needsComment| Ever confirmed|0 |1 --- Comment #1 from Eike Rathke --- This is not how the ADDRESS() function works in any spreadsheet application so wouldn't be interoperable. Also, accepting a sheet number wouldn't work in cases where the sheet is moved to a different location or sheets were inserted in front of it. We should rather have a new function SHEETNAME() that optionally takes a reference or sheet number of which it determines the sheet name. -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132136] The reference via the ADDRESS function should also work with the table number.
https://bugs.documentfoundation.org/show_bug.cgi?id=132136 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Blocks||108827 Referenced Bugs: https://bugs.documentfoundation.org/show_bug.cgi?id=108827 [Bug 108827] [META] Calc functions bugs and enhancements -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
[Libreoffice-bugs] [Bug 132136] The reference via the ADDRESS function should also work with the table number.
https://bugs.documentfoundation.org/show_bug.cgi?id=132136 QA Administrators changed: What|Removed |Added Whiteboard|| QA:needsComment -- You are receiving this mail because: You are the assignee for the bug.___ Libreoffice-bugs mailing list Libreoffice-bugs@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs