Description: A hyperlink pointing to a sheet named as a cell address (i.e. P5) will direct to the cell instead of the sheet Steps to Reproduce: 1.In an empty spreadsheet create a second sheet named P5 2.Create an hyperlink to point to the sheet you just created in the first sheet 3.Click on the hyperlink Actual Results: You will be directed to cell P5 of the sheet where you created the hyperlink Expected Results: You should be directed to sheet P5 instead Reproducible: Always User Profile Reset: Yes Additional Info: Version: 7.6.0.3 (X86_64) / LibreOffice Community Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265 CPU threads: 8; OS: Mac OS X 13.4.1; UI render: Skia/Raster; VCL: osx Locale: en-GB (en_IT.UTF-8); UI: en-US Calc: threaded
a) Already Reproducible with OOo 3.2. So Inherited from OOo b) REPRODUCIBLE with Server Installation of Version: 7.6.0.0.alpha0+ (X86_64) Build ID: 9f56dff12ba03b9acd7730a5a481eea045e468f3 CPU threads: 12; OS: Windows 10.0 Build 19045; UI render: default; VCL: win Locale: Locale: de-DE (de_DE); UI: de-DE; Theme: Automatic (Colibre) Calc: CL threaded – Special new User Profile for testing c) Query <https://bugs.documentfoundation.org/buglist.cgi?cmdtype=dorem&remaction=run&namedcmd=DUPs157072&sharer_id=19321> shows some possible DUPs: c1) Bug 33067 - Hyperlink to Sheet with name like cell reference will lead to cell instead to sheet probably DUP, WONTFIX c2) Bug 62289 - Adding hyperlinks via the GUI to other sheets with only a number for the name in the same workbook take you to the ROW number in the current sheet, instead of to the target_sheet.a1 may be related, NEW
Well, (c) "Bug 33067 - Hyperlink to Sheet with name like cell reference will lead to cell instead to sheet" seems not "Inherited from OOo", at least links to target in document work fine in Ooo 3.2.0. But also reproducible with AOO4111m1(Build:9808) - Rev. bdb20b2a64 2021-09-20 16:18 What ever this might mean. I see this one as DUP of Bug 62289 Please feel free to reopen this one if you find evidence that we have an independent issue here *** This bug has been marked as a duplicate of bug 62289 ***