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

2023-03-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #12 from ady --- (In reply to Heiko Tietze from comment #11) > (In reply to ady from comment #10) > > ...it is very rare for me to use relative _worksheet_ references. > > That's true. My proposed first toggle on/off should i

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

2023-03-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 Heiko Tietze changed: What|Removed |Added Keywords|needsUXEval | CC|libreoffice-u

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

2023-03-21 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 Heiko Tietze changed: What|Removed |Added Status|UNCONFIRMED |NEW Ever confirmed|0

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

2023-03-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #10 from ady --- (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 re

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

2023-03-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #9 from Heiko Tietze --- 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

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

2023-03-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #8 from ady --- > To sum-up, from the POV of final users, the resulting change should be: > From current: To Proposed: > 0. $Sheet2.A1 0. $Sheet2.A1 > 1. Sheet2.$A$11. $Sheet2.$A$1 > 2. Sheet2.A$1

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

2023-03-19 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 Roman Kuznetsov <79045_79...@mail.ru> changed: What|Removed |Added Keywords||needsUXEva

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

2023-03-09 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #7 from ady --- (In reply to Justin L from comment #6) > I have > coded up your suggested sequence. > https://gerrit.libreoffice.org/c/core/+/148516 I have no coding skills/knowledge in order to comment about it. I do thank y

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

2023-03-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #6 from Justin L --- (In reply to ady from comment #3) > I cannot reproduce your sequence. Sorry - I mis-read. I thought you said there was an existing case where your SUGGESTION was followed. Although I have no intention of

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

2023-03-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #5 from ady --- (In reply to Justin L from comment #4) > please provide the > exact formula/steps that you are following to trigger this cycle. Using: Version: 7.6.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 0484a9

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

2023-03-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #4 from Justin L --- (In reply to ady from comment #3) I cannot reproduce your sequence. If I just type in the formula area "=$Sheet1.$A$1" and then cycle with F4 I get: -$Sheet1.B$2 = sheet + row (aka 6) -$Sheet1.$B2 = sheet

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

2023-03-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #3 from ady --- (In reply to ady from comment #2) > BTW, the suggested cycle is also already the current cycle when editing a > formula that was already introduced, for example by the Formula Wizard. Sorry, I think I was not

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

2023-03-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 --- Comment #2 from ady --- (In reply to ady from comment #1) > The suggestion is for the F4 cycle to work as follows: > 0. $Sheet2.A1 < this is before pressing F4 (no change) > > 1. $Sheet2.$A$1 > 2. $Sheet2.A$1 > 3. $Sheet2.$A1 > 4. S

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

2023-03-08 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=154075 ady changed: What|Removed |Added Summary|Cacl's F4 absolute cycle is |Calc's F4 absolute cycle is