Bug 157072

Summary:	Calc - Hyperlink to sheet names as a cell address brings to the cell instead of the sheet
Product:	LibreOffice	Reporter:	lore <lovecraft22>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	minor	CC:	LibreOffice
Priority:	medium
Version:	Inherited From OOo
Hardware:	All
OS:	All
See Also:	https://bugs.documentfoundation.org/show_bug.cgi?id=62289
Whiteboard:
Crash report or crash signature:		Regression By:

Description lore 2023-09-03 08:44:48 UTC

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

Comment 1 Rainer Bielefeld Retired 2023-09-03 15:33:26 UTC

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

Comment 2 Rainer Bielefeld Retired 2023-09-04 07:49:32 UTC

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 ***