"Use legacy cursor movement behavior when selecting"
"Last selected cell determines selection behavior of key board"
"Last selected row/column determines selection behavior of key board"
see patch https://gerrit.libreoffice.org/#/c/43371/
Comments in the patch:
* Eike Rathke (Oct 17 2:05 PM)
That sentence doesn't make sense to me.. ;-)
Also, it doesn't indicate any difference between checking and unchecking the option.
* Cor (Oct 17 5:35 PM)
Still hard to get ones head around, I fully agree. The useful example in Help is really needed (and still pending ;) )
However, it is surely more descriptive than the term "legacy behavior" not? And I guess the amount of characters is limited.
I thought about "... selected row/column ..", which gives more of a clue.
My understanding would be that checking, would activate the foo-behavior.
Please explain what the function does.
(In reply to Heiko Tietze from comment #1)
> Please explain what the function does.
(nice graphic is pending ;) )
(In reply to Cor Nouws from comment #2)
Don't get it.
ctrl+down and the cursor ends at 4*.
Created attachment 137547 [details]
screen print with both options
> (nice graphic is pending ;) )
To explain Cor's picture:
Starting at the upper left cell pressing shift+ctrl+right and shift+ctrl+down selects the A3:B8 in the new mode but A3:B12 when legacy is enabled.
So my suggestion for the option is: "Excel compatible selection for multiple cells". This feature would be better realized with two radio buttons that are labeled "(o) Expand to least row of right column" and "( ) Expand to last row of left column". And even better when the function works also in the other way from right to left, which isn't true.
(In reply to Heiko Tietze from comment #5)
> So my suggestion for the option is: "Excel compatible selection for multiple
_If_ choosing that style of description, make it "Excel style selection".
But I wouldn't.
> This feature would be better realized with two radio buttons that
> are labeled "(o) Expand to least row of right column" and "( ) Expand to
> last row of left column".
it works with every expanding of multi row/column selected cellranges in all directions.
It truly is: "let, when extending a selection, the content of last selected column/row determine where the automatic extending (using Ctrl+Shift) stops"
Or "when extending a selection, the content of last selected column/row determines where the automatic extending (using Ctrl+Shift) stops"
> And even better when the function works also in
> the other way from right to left, which isn't true.
test harder ;)
(In reply to Cor Nouws from comment #6)
> test harder ;)
/done & confirming that it works (guess I messed up with the setting yesterday)
Design team recommends to use 'Excel multiple cell keyboard selection'.
This was actually a bug in OpenOffice where the cursor moved with the selection.
For example if you have filled columns A B C and rows 1-10 and you are in A1, then you select with ctrl-shift-right it will select columns A-C, but the cursor will virtually move from A to C in the "legacy" mode, but in the "standard" mode it will always stay in A1. If you push down next, the cursor position will change from C1 to C10...
When doing selection it always starts looking at the current cursor position - in "legacy" mode the cursor position will move, but "normally" this will always stay in the original position. This is the reason why it is called "cursor movement behavior". However in the old buggy implementation it really was the cursor that moved - which was a bug and was later fixed so that the cursor stays in one place only. In the current implementation the cursor doesn't move or only moves virtually - the cell from which the lookup is made moves when you make a selection.
So maybe a good name would be "move cell look-up with the selection", but definitely not "Excel" anything ..
The design team discussed the issue again, first was 2017-Nov-09 , and recommend now "Position cell reference with selection".
(In reply to Heiko Tietze from comment #10)
> The design team discussed the issue again, first was 2017-Nov-09 , and
> recommend now "Position cell reference with selection".
>  https://wiki.documentfoundation.org/Design/Meetings/2017-11-09
thanks - I'll change the patch accordingly
A polite ping, still working on this bug?
(In reply to Xisco Faulí from comment #14)
> A polite ping, still working on this bug?
intending - having commit access issue atm.
pushed https://gerrit.libreoffice.org/60440 tdf#113235 - new attempt: More useful description for Calc option "Use legacy
Cor Nouws committed a patch related to this issue.
It has been pushed to "master":
tdf#113235 - new attempt: More useful description for Calc option "Use legacy
It will be available in 6.2.0.
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.
Why can't the label just say "Leave cursor at end of selection"?
-No more words.
-Easier to understand.