Bug 118866 - EDITING Hyperlink to hidden sheet navigates to wrong sheet
Summary: EDITING Hyperlink to hidden sheet navigates to wrong sheet
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
4.1 all versions
Hardware: All All
: medium minor
Assignee: Not Assigned
Keywords: needsUXEval
: 157071 (view as bug list)
Depends on:
Blocks: Sheet Hyperlink-Calc
  Show dependency treegraph
Reported: 2018-07-21 07:54 UTC by Emil Tanev
Modified: 2023-09-19 09:00 UTC (History)
5 users (show)

See Also:
Crash report or crash signature:

file (59.80 KB, application/vnd.openxmlformats-officedocument.spreadsheetml.sheet)
2018-07-21 07:54 UTC, Emil Tanev

Note You need to log in before you can comment on or make changes to this bug.
Description Emil Tanev 2018-07-21 07:54:16 UTC
Created attachment 143665 [details]

Open the file
Hide sheet "jan"
Go back to sheet "summary"
Ctrl + mouse click on cell B2 (contains hyperlink to sheet "jan")

Issue: Navigates to sheet "feb"

Comment 1 Emil Tanev 2018-07-21 07:54:48 UTC
Version: (x64)
Build ID: 715fcaff01ed048c52c69264a7a0fb773dd57b32
CPU threads: 1; OS: Windows 10.0; UI render: default; 
TinderBox: Win-x86_64@42, Branch:master, Time: 2018-07-21_02:21:27
Locale: en-US (en_US); Calc: group threaded
Comment 2 m.a.riosv 2018-07-21 12:12:39 UTC
Version: (x64)
Build ID: dc68ad6c5cde3c62874b96422f2e5e8252499bad
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: es-ES (es_ES); Calc: CL
Comment 3 Xisco Faulí 2018-07-23 17:31:34 UTC
Also reproduced in

Build ID: c15927f20d4727c3b8de68497b6949e72f9e6e9e

Version (Build ID: efca6f15609322f62a35619619a6d5fe5c9bd5a)
Comment 4 QA Administrators 2019-10-28 03:29:45 UTC Comment hidden (obsolete)
Comment 5 QA Administrators 2021-10-28 04:15:01 UTC Comment hidden (obsolete)
Comment 6 Stéphane Guillou (stragu) 2023-09-19 08:22:22 UTC
*** Bug 157071 has been marked as a duplicate of this bug. ***
Comment 7 Stéphane Guillou (stragu) 2023-09-19 08:46:13 UTC
Same in recent master build:

Version: (X86_64) / LibreOffice Community
Build ID: b3fdd999f87312447d03915585812b3a5cd48141
CPU threads: 8; OS: Linux 5.15; UI render: default; VCL: gtk3
Locale: en-AU (en_AU.UTF-8); UI: en-US
Calc: threaded

But what would be a preferred behaviour? An error message? Nothing? -> asking for UX/Design team opinion.

Just noting that currently, regarding hidden sheet behaviour, we have:
- Using "Sheet > Navigate > Go to sheet..." does not list the hidden sheet.
- Ctrl + Page Down / Page Up bypasses the hidden sheet too.
- "Edit > Select > Select to next / previous sheet" jumps over the hidden sheet.

Only way to show the sheet again is to use the Show Sheet dialog.
Comment 8 Heiko Tietze 2023-09-19 09:00:22 UTC
I would show the sheet and switch rather than some modification on the hyperlink to make it look like disabled or to interrupt the workflow with a message box (or less obtrusive an infobar which could OTOH provide means to show/activate the target anyway).