[Libreoffice-bugs] [Bug 136390] New: Hyperlink to Sheetname that is Number links to Cell

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 136390
           Summary: Hyperlink to Sheetname that is Number links to Cell
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: tenaz04c at gmail.com

I have a spreadsheet where the names of all the sheets are years 1986, 1987,
etc.  If I hyperlink to the sheet name only, it links to the cell A#### e.g.
A1986 of the current sheet where the hyperlink is instead of to the sheet 1986.
 If I put 1986.A1, it works.  If I change the sheet name to 1986!, it also
works.  I'd like to use the wizard to add buttons, but cannot because of this.

=HYPERLINK("#1987.A1", "1987")  Works
=HYPERLINK("#1987", "1987") Does not work, links to cell A1987 in same sheet.

-- 
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/20200902/5e9c3e9e/attachment-0001.htm>