Bug 143427 - Hyperlink for Document doesn't work always correctly
Summary: Hyperlink for Document doesn't work always correctly
Status: RESOLVED DUPLICATE of bug 62289
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.1.4.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2021-07-18 06:30 UTC by rfrijhoff@gmail.com
Modified: 2021-07-19 09:00 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
Example file made per instructions (8.69 KB, application/vnd.oasis.opendocument.spreadsheet)
2021-07-19 08:38 UTC, NISZ LibreOffice Team
Details
How it looks after opening (26.79 KB, image/png)
2021-07-19 08:42 UTC, NISZ LibreOffice Team
Details
After clicking the link in C2, E4 is highlighted on the same sheet (16.67 KB, image/png)
2021-07-19 08:44 UTC, NISZ LibreOffice Team
Details

Note You need to log in before you can comment on or make changes to this bug.
Description rfrijhoff@gmail.com 2021-07-18 06:30:11 UTC
Description:
When making a Document hyperlink it doesn't always work correctly. If I name a sheet like a cell (e.g. BR03) and I make a hyperlink for that sheet in a different sheet, then it will jump to that cell in the sheet I create the link in i.s.o. to the other sheet in the same document (though it might happen too in a different document, but I haven't tried that out). To explain why I named the sheet BR03, it's a type of German steam locomotive.

Steps to Reproduce:
1.Make 2 sheets
2.Name the 2nd sheet like a cell (e.g. BR03)
3.Create a hyperlink in the first sheet and select Document
4.Select as path the same document as you are working in now.
5.Select as target the named sheet (BR03) and for convience set a text so you can CTRL+Click on it to jump.



Actual Results:
It will jump to cell BR3.

Expected Results:
It should jump to sheet BR03.


Reproducible: Always


User Profile Reset: No



Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: yes
.
There is no OpenGL option only a OpenCL option, which is enabled.
Comment 1 [REDACTED] 2021-07-18 09:40:00 UTC
Repro

Version: 7.1.4.2 / LibreOffice Community
Build ID: a529a4fab45b75fefc5b6226684193eb000654f6
CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5
Locale: en-US (en_US.UTF-8); UI: en-US
Calc: threaded
Comment 2 m_a_riosv 2021-07-18 11:03:07 UTC
Please attach a sample file
Comment 3 NISZ LibreOffice Team 2021-07-19 08:38:27 UTC
Created attachment 173666 [details]
Example file made per instructions
Comment 4 NISZ LibreOffice Team 2021-07-19 08:42:55 UTC
Created attachment 173667 [details]
How it looks after opening
Comment 5 NISZ LibreOffice Team 2021-07-19 08:44:12 UTC
Created attachment 173668 [details]
After clicking the link in C2, E4 is highlighted on the same sheet

Also happens in:

Version: 7.3.0.0.alpha0+ (x64) / LibreOffice Community
Build ID: da13b76e07231131cb951868a314ee6f51c0f254
CPU threads: 4; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win
Locale: hu-HU (hu_HU); UI: en-US
Calc: CL
Comment 6 NISZ LibreOffice Team 2021-07-19 08:59:27 UTC
This is likely the same issue as bug #62289 ... or bug 135545 or bug 136390
Comment 7 NISZ LibreOffice Team 2021-07-19 09:00:56 UTC

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