Ask Your Question

Hyperlinks to internal sheets disappear after the click

asked 2019-02-19 21:26:33 +0200

Corsari gravatar image

updated 2019-02-19 21:28:18 +0200

Hello to all the community

I have done a really simple brief test

LibreOffice Calc

Created a new file test.ods

Added 4 sheets

Created a TOC in sheet #1 mean that e.g. in

cell B3 you have "Sheet #2" cell B4 you have "Sheet #3" cell B5 you have "Sheet #4" cell B6 you have "Sheet #5"

then I have selected string Sheet #2 and with Ctrl-k I have made it a link to sheet number 2,

then I did the same for the remaining three strings and linked EACH of them to the respective sheet

Saved the document

AS SOON I click ANY of the strings, it does correctly jump to the selected sheet, BUT, when I come back to sheet #1 all the cells are EMPTY

What is this bug?

Thank you Thank you

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2019-02-19 21:40:42 +0200

Corsari gravatar image

updated 2019-02-19 21:42:27 +0200


I had a suspect and tried this

if I DON'T write any string and instead I JUST select one EMPTY cell and I Ctrl-k insert the link,

well, that works

I can click to sheet #2, it jumps to sheet #2 and when I go back to sheet #1 the link is still there

mmmh ,

though this looks like a bug

in fact,

If I do use a shape and make it a link (select the shape and Ctrl-k on it) , e.g. on the Sheet #2 I place a button shape and make it the "home" button to go back to sheet #1,

well, I click that home button, it jumps to sheet #1 but when I go back to sheet #2, the button shape is disappeared

If I click ctrl-z it does re appear


edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2019-02-19 21:26:33 +0200

Seen: 38 times

Last updated: Feb 19