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.
Version: 126.96.36.199 (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: 188.8.131.52.alpha0+ (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.
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.
*** This bug has been marked as a duplicate of bug 62289 ***