Created attachment 125378 [details] Screenshot of activating hyperlinks in B3, to #b5 (left, correct) and #c5 (right, incorrect) Steps to reproduce (see attached screenshot) 0) Check that A1 style is activated 1) Create new calc document (or use any open one) A) Correct behaviour A2) Enter internal Hyperlink in e.g. cell B3, to e.g. B5 ("#B5") A3) Click hyperlink -> cell B5 correctly activates B) Incorrect behaviour B2) Enter internal Hyperlink in e.g. cell B3, to e.g. C5 ("#C5") B3) Click hyperlink -> column E (i.e. column number 5) activates Notes : - Any other letter than "C" behaves apparently OK - Behaviour same with entered hyperlink or with hyperlink formula - Behaviour same with link inside same sheet or another one -- Same sheet : e.g. "#C5" -> selects column E -- Other sheet : e.g. "#sheet!c5" -> correct goes to sheet "sheet", otherwise same bug - Bug already existent at least in 5.1.2
Reproducible with Version: 5.2.0.0.alpha1+ Build ID: 7b704dfbdb23540ff6366fa60c73474bbda9dc26 CPU Threads: 2; OS Version: Windows 6.0; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-05-20_05:45:40 Locale: fr-FR (fr_FR) Works with 5.0.6.2 Letter C is understood by Calc as "Column". Link to C5 go to 5th column, C10 to 10th column... etc Same for R : Link to cell R10 go to row 10.
This seems to have begun at the below commit. Adding Cc: to Markus ; Could you possibly take a look at this one? Thanks 0782aff02a7d65a009f634bd43cf0ecf2a6d4106 is the first bad commit commit 0782aff02a7d65a009f634bd43cf0ecf2a6d4106 Author: Norbert Thiebaud <nthiebaud@gmail.com> Date: Sat Jul 11 12:25:57 2015 -0700 source 106a4dc29980889c02faa526e5417b63fdce6c23 author Markus Mohrhard <markus.mohrhard@googlemail.com> 2015-05-27 18:24:28 (GMT) committer Markus Mohrhard <markus.mohrhard@googlemail.com> 2015-05-27 18:41:45 (GMT) commit 106a4dc29980889c02faa526e5417b63fdce6c23 (patch) tree c5c281809391df0dd95a05a452928334eeccf945 parent 5142c9226318019200ed6e055b4eb1503bd002db (diff) support R1C1 reference for hyperlinks
How about https://gerrit.libreoffice.org/#/c/27821/ as a solution ?
Caolán McNamara committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=405db7afbdba02eed9a9a4c4f22000fe623b029c Resolves: tdf#100123 prefer notation priority in detecting range/address It will be available in 5.3.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-2": http://cgit.freedesktop.org/libreoffice/core/commit/?id=9f45441144d7aacfb3e46b8b61f16886c4962d54&h=libreoffice-5-2 Resolves: tdf#100123 prefer notation priority in detecting range/address It will be available in 5.2.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Caolán McNamara committed a patch related to this issue. It has been pushed to "libreoffice-5-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=00992771455dae0eb83b8c705ae648ad3683f0ef&h=libreoffice-5-1 Resolves: tdf#100123 prefer notation priority in detecting range/address It will be available in 5.1.6. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.