[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

classic Classic list List threaded Threaded
1 message Options
bugzilla-daemon-2 bugzilla-daemon-2
Reply | Threaded
Open this post in threaded view
|

[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

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

Heiko Tietze <[hidden email]> changed:

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

--- Comment #21 from Heiko Tietze <[hidden email]> ---
(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.
_______________________________________________
Libreoffice-ux-advise mailing list
[hidden email]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-ux-advise