Apache OpenOffice (AOO) Bugzilla – Issue 125612
HYPERLINK wizard gives a wrong URL if you want to go on another sheet
Last modified: 2014-10-01 19:42:25 UTC
Steps to reproduce: 1- Open a spreadsheet and stay in Sheet1, A1 cell 2- Run Function wizard 3- Choose HYPERLINK function 4- In URL field, click on [Select] button 5- Go to Sheet2, select A1 cell and click on [Maximize] button 6- In URL field, text is now "Sheet2.A1" (without double quotes) 7- In CellText field, input "Jump to Sheet2" (with double quotes) 8- Press [OK] button 9- Now click on this hyperlink Expected behavior: you jump to Sheet2 Wrong behavior: Windows alert that Sheet2 is not found Help F1 says that syntax must be: =HYPERLINK("#Sheet1.A1";"Go to top") So, wizard should add the hashtag and double quotes to URL in this case.
Confirmed defect on 4.1.1