[Libreoffice-ux-advise] [Bug 62289] Adding hyperlinks via the GUI to other sheets with only a number for the name in the same workbook take you to the ROW number in the current sheet, instead of to the target_sheet.a1

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Tue Oct 29 11:24:14 UTC 2019


https://bugs.documentfoundation.org/show_bug.cgi?id=62289

Heiko Tietze <heiko.tietze at documentfoundation.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |libreoffice-ux-advise at lists
                   |                            |.freedesktop.org

--- Comment #21 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
(In reply to Franklin Weng from comment #20)
> Looks like an UX option.

Rather an UX issue. You can also name the second sheet "S2" and you will jump
to cell S2 instead of the worksheet. Feels like an easter egg but from last
year and rotten since the intended function is not accessible anymore.

If cell references are needed as target I would request it to be entered in the
formula syntax $S$2 and allow to enter Sheet2:A2 or Sheet2:$A$2 (both result in
invalid range). If cell targets are not so important we could disable direct
editing and never target cells.

-- 
You are receiving this mail because:
You are on the CC list for the bug.


More information about the Libreoffice-ux-advise mailing list