I have a Calc document (created last year, but I’m currently running LibreOffice 18.104.22.168 on Linux Mint 18) containing multiple sheets. One sheet contains hyperlinks to cells in other sheets so I can jump to the relevant cell. The hyperlink cells use a function eg. ‘=HYPERLINK("#2017_Itemised.E1",“Fuel”)’ and they work perfectly until I have to edit them. The example given displays in the cell as ‘Fuel’ and if I Ctrl-click on it the view jumps to cell E1 in sheet ‘2017_Itemised’.
When I edit the hyperlinks they stop working. The above example cell then displays the formula as text, and it no longer works as a hyperlink. I have checked and rechecked, and the edited link address is perfectly valid. This problem occurs even if I don’t change the link address - such as by replacing ‘2017’ with ‘2017’ in the example.
The really weird thing is the first hyperlink in the sheet can be edited without any problem. Every other hyperlink in the sheet breaks when edited.
By using ‘Ctrl+F8’ to view the cell format types I can see that the format of the faulty edited hyperlink cells changes from green (ie. a formula) to blue (text).
What is causing this? More importantly, how can I get Calc to stop doing this, and how can I change the cell format back to Formula so the hyperlink works again?