GNOME Bugzilla – Bug 662310
Hyperlink dialog places link in wrong sheet
Last modified: 2011-10-20 18:25:50 UTC
Version: 1.10.17 When using the "Target Range" button from the "Insert > Hyperlink" GUI to insert a hyperlink to a cell in another sheet, the wrong cell is selected to become the hyperlink. To replicate: 1) Open a new workbook 2) Click on any cell on Sheet 1 3) Click "Insert > Hyperlink" 4) Select "Internal Link" as the link type 5) Click the button to the right of the "Target Range" input box 6) Select any cell in Sheet 2 7) Hit "Enter" 8) Click "Ok" What should happen: The cell in Sheet 1 should now contain a hyperlink to the desired cell What does happen: Cell A1 in Sheet 2 contains the hyperlink to the desired cell This is because when I change to Sheet 2 the currently selected cell is changed to cell A1 on Sheet 2. Hence when I click "Ok" the hyperlink is created in the currently selected cell (Sheet2.A1)
A workaround is to switch back to the original sheet before clicking "ok". This problem has been fixed in the development version. The fix will be available in the next major software release. Thank you for your bug report.