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.
Repro with Version: 6.4.6.2 (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: 7.1.0.0.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. https://help.libreoffice.org/latest/en-US/text/scalc/01/04060109.html?DbPAR=CALC#bm_id9959410
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 ***