[Libreoffice-ux-advise] [Bug 154075] Calc's F4 absolute cycle is sub-optimal when starting from a sheet-only absolute reference

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Mar 20 08:25:17 UTC 2023


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

--- Comment #9 from Heiko Tietze <heiko.tietze at documentfoundation.org> ---
Hard to imagine that user toggles trough all eight states to find the right
one. And what I miss in all the discussion is the opposite sequence starting
from relative references.

The primary use case is likely to switch from (any) relative to absolute
references ?Sheet?2.?A?1 => $Sheet2.$A$1 and the opposite ?Sheet?2.?A?1 =>
Sheet2.A1, where we obviously know the relative state only if there is zero
absolute tag.

Sheet2.A1 => $Sheet2.$A$1, ...
?Sheet2.?A?1 => Sheet2.A1, $Sheet2.$A$1, ...

The sequence after full absolute is probably not so important and the proposal
is okay.

(In reply to Justin L from comment #0)
> The other option would be to have a "remember the last used toggle" state
> and combine a "toggle session" with the "current toggle state" and have some
> special action for the "first toggle in a session" - which is probably the
> only acceptable solution for this request.

Basically I like this idea but the on/off scenario seems to be typical meaning
you don't have one single last used toggle state. Perhaps as second/third
option the one that was picked last from the many options?

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


More information about the Libreoffice-ux-advise mailing list