Actually the bug is exactly as described. Testing with LibreOffice 4.0.2 rc1 The problem is in interpreting an incomplete hyper link. 1) If the complete hyper link is entered Sheet 2.A2 it becomes #Sheet 2.A2 And movement to that sheet and cell is reliable. 2) If you insert the hyperlink without the cell reference, e.g. #Sheet 2, it takes you that sheet but looks to retain the last cell referenced, i.e. the landing cell is erratic. 3) And if as Tanstaafl reports in fdo#62289 <https://bugs.freedesktop.org/show_bug.cgi?id=62289> even if you use the GUI and select the numbers only page name, e.g. 3 so hyperlink is #3 ,the link is interpreted incorrectly and you remain on the same page--and apparently in that numbered row. So there is definitely an issue with the Target in Document GUI picker allowing an incomplete hyper link. Or equally an inconsistent parser/handling logic for incomplete hyperlink targets--would think that absent a complete hyperlink target, the parser should identify the sheet and default to a consistent cell--A1 I would imagine. Stuart -- View this message in context: http://nabble.documentfoundation.org/Hyperlink-Bug-in-calc-bug-62289-tp4043505p4044553.html Sent from the Users mailing list archive at Nabble.com. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted