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. 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 the entire column L.
(????)
This unexpected column selection is, of course, very disorienting to one's
eyeballs and brain.
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).
--
David S. Crampton
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted