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

Reply via email to