Date: prev next · Thread: first prev next last
2011 Archives by date, by thread · List index


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


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.