It seems the HYPERLINK function in LibreOffice Calc has been changed. Since several years I use a spreadsheet containing a summarizing worksheet to summarize several worksheets in the same file. The HYPERLINK formula is
in which column B contains a year ("2013") and column C the name of the worksheet which is summarized in various fields/columns in that row. With 'Ctrl'-click I can jump to the first row of the referenced year in the referenced worksheet.
When a new year has to be added I simply copy the rows containing all summarizing formulas. The formula mentioned above becomes
Unfortunately the new (i.e. just copied function) function does not work now: 'Ctrl'-click does nothing, no pop-up window, no error message or whatsoever. Simply, nothing happens. In addition, the cursor which changes when hovering above a cell containing the hyperlink function does not change in the newly copied cell as it does change in the existing cells where 'Ctrl'-click functions as expected.
I have tried to change Libreoffice Options settings, but no success.
How can I get a working 'Ctrl'-click and jump to a certain cell in another worksheet in the same (spreadsheet)file?
In addition I create a simple Calc spreadsheet to see if there is indeed something going on. I have attached the file ("testhyper.ods").
Cell Sheet1.A1 contains the formula =HYPERLINK(Sheet2.A1;"LINK
Ceel Sheet2.A10 contains a formula evolving to the string "Sheet2 cell A10" [formula is a very simple one "=LEFT(A9;FIND("A";A9))&RO
The cursor changes when hovering above the cell Sheet1.A1 containg the hyperlink formula. When using 'Ctrl'-click an error message window pops up:
"Sheet2 cell A10" is not an absolute URL that can be passed to an external application to open it.
(un)Checking the "Save URLs relative to" both filesystem and internet settings (Tools - Options - Load/Save - General)does not any effect at all.
My system consists of Windows 8.1 (desktop mode), 6GB RAM and Libreoffice 18.104.22.168. I encountered these problems using version 4.2.1
Any help is appreciated.