https://bugs.freedesktop.org/show_bug.cgi?id=42535
Bug #: 42535
Summary: Editing UI: Ctrl+Shift-RightArrow faulty extension
result
Classification: Unclassified
Product: LibreOffice
Version: unspecified
Platform: Other
OS/Version: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Context:
in Calc of LO 3.4.3 on WinXP Pro
The cell range L155:AA155 contains empty cells. The cells on either end of that
range are filled with numbers.
The cell above L155 contains a formula. In fact all the cells in the row above
(cells ...L154:AA156...) contain either a formula or a value.
The task is to copy the formula from L154 to L155, make an edit, extend the
range from L155 to AA155, Edit | Fill Right.
The keystokes:
In L154: Ctrl+C
Down Arrow: moves to L155
Ctrl+V: paste
Esc: terminate the "dotted border" focus on L154
F2: make the small edit
Enter: terminate the edit
Ctrl+Shift+RightArrow: SHOULD extend to AB156 where it finds the next filled
cell in the row.
~~~~~~~~~~~~~~~~~~~~~: ACTUALLY extends selection to a large portion of column
L. I originally thought that the faulty extension was to the entire column L.
Mr. Stephan Zeitsman of the User's Help forum subsequently observed:
"I just tried your example (after I posted my reply). I find that the
selection is actually extended to K1:L155, which means it selects
column K and column L (but not the entire column, only up to row 155).
This is very strange behaviour, as it actually extends the selection
to the *left*, although I pressed Ctrl + Shift + RightArrow."
Workaround
start as above until:
F2: make the small edit
Enter: terminate the edit
RightArrow (once): shift focus from L155 to M155
LeftArrow (once): shift focus from M155 to L155
Ctrl+Shift+RightArrow: SHOULD and DOES extend to AB156 where it finds the next
filled cell in the row.
I use the M$ Natural Keyboard. The defective behavior results using either of
the possible keys for "RightArrow": the 4-keypad "compass set" or the NumberPad
(NumLock off).
Mr. Stephan Zeitsman suggested I examine these two existing bugs:
https://bugs.freedesktop.org/show_bug.cgi?id=39212
https://bugs.freedesktop.org/show_bug.cgi?id=37230
I slogged through those two. I think my issue is different. I am in no way
attempting or expecting my keystroke sequence to intelligently (or foolishly)
emulate any behavior I have ever used in M$ Excel.
So I respectfully report here.
--
David S. Crampton
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
