[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 10:38:46 UTC 2023


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

--- Comment #10 from ady <adylo811517 at gmail.com> ---
(In reply to Heiko Tietze from comment #9)
> 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.

In the current cycle, when I need to use F4s and the reference includes a
worksheet name, I end up using between five (5) and seven (7) F4s, because it
is very rare for me to use relative _worksheet_ references.

I repeat that the changes for Row and Column are non-existent; i.e. there is no
effect on them because the proposed cycle keeps them in the same order.

No user needs to use eight F4s on the same reference, unless the user realizes
he made some mistake so he goes through another cycle (or part of it) in order
to arrive to the desired reference type (again).

The current initial state (i.e. "0" above) is correct, not only because it is
the most common when worksheet references are included (in most other
spreadsheet software _too_) but also because, when it was implemented, it
reduced the amount of complaints and reports about "something" in Calc not
working. The proposed improvement here would start from the first F4 onwards.

@Heiko, sincerely, other than what I just mentioned, I didn't understand any of
those questions (perhaps I need some resting? Or perhaps they are not aimed at
a common user?).

Either I am a very particular user (I don't think so), or we have very
different experiences actually using spreadsheet software for real formula /
spreadsheet building.

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


More information about the Libreoffice-ux-advise mailing list