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+help@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
Context
- [libreoffice-users] in Calc: Keyboard trouble with Ctrl+Shift+RightArrow · David S. Crampton
Privacy Policy |
Impressum (Legal Info) |
Copyright information: Unless otherwise specified, all text and images
on this website are licensed under the
Creative Commons Attribution-Share Alike 3.0 License.
This does not include the source code of LibreOffice, which is
licensed under the Mozilla Public License (
MPLv2).
"LibreOffice" and "The Document Foundation" are
registered trademarks of their corresponding registered owners or are
in actual use as trademarks in one or more countries. Their respective
logos and icons are also subject to international copyright laws. Use
thereof is explained in our
trademark policy.