Bug 136390 - Hyperlink to Sheetname that is Number links to Cell
Summary: Hyperlink to Sheetname that is Number links to Cell
Status: RESOLVED DUPLICATE of bug 62289
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All All
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Hyperlink-Calc
  Show dependency treegraph
Reported: 2020-09-02 02:47 UTC by Tenaz
Modified: 2021-07-19 09:00 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Tenaz 2020-09-02 02:47:52 UTC
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.
Comment 1 m.a.riosv 2020-09-04 17:51:20 UTC
Repro with
Version: (x64)
Build ID: 0ce51a4fd21bff07a5c061082cc82c5ed232f115
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: GL; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US Calc: threaded
Version: (x64)
Build ID: baa84b5b4d287da0f00fc3fbf11f464f267c9202
CPU threads: 4; OS: Windows 10.0 Build 20180; UI render: default; VCL: win
Locale: es-ES (es_ES); UI: es-ES Calc: CL

But I'm not absolutely sure it is a bug, the sample in the help includes the cell.
Comment 2 Tenaz 2020-09-05 00:02:17 UTC
It's definitely a bug since #sheet should only link to sheet names and cells should have a column reference e.g. A1985 instead of just 1985 going to the cell in column A.

Adding a button via the wizard for adding a hyperlink includes no way to add the cell reference, so either the wizard needs to be fixed or the hyperlink functionality itself.
Comment 3 NISZ LibreOffice Team 2021-07-19 09:00:43 UTC

*** This bug has been marked as a duplicate of bug 62289 ***