Jim Watson wrote:
Eike Rathke wrote:
Hi TerryJ,
On Monday, 2007-02-05 21:19:45 +1100, TerryJ wrote:
From earlier posts in the thread, it seems that the company's
users select a row and try to extend the selection down with SHIFT
+ DOWN. The result is that the first column is selected down, NOT
the table.
Do it in reverse order: Select a range, and then use Shift-Space to
extend the selection to whole rows.
Thanks for replying but that's no good. On my system at least.
When I select a range in column A, SHIFT+SPACE extends the selection
beyond the used area to the last column in the Sheet. The occupied
cells are A1:E26; I select A1:A26 and SHIFT+SPACE extends the
selection to IV26. No use at all.
But that's exactly what you respectively the user asked for: the user
tried to select an entire row and to extend the selection down to
multiple entire rows, e.g. he marked one row A1:IV1 and tried to extend
the selection to A26:IV26 using shift+down, but instead the mark was
selected from the first column to the actual cell cursor position's
column (happened to be the first column then it seems) and extended
down. At least that's what you told us.
Eike
I had another look at the original formum posting and agree with Eike,
the original user question is about whole rows.
After some trials it appears the issue is about how rows are selected.
The common method is to click on the row number in the left hand side
bar. This is expected to select the entire row. But in calc this does
not happen. The entire row appears selected (black) but there is a
white box around the cell in column A. If some other cell was selected
before, then that selection is moved. The next action being
shift-down, operates on the selected cell, not the row that appears
selected.
Another method to select a row is to select the cell at column A
then Ctrl-Shift-Right arrow. The selected (white box) cell now
appears in column IV. The next action being shift-down now operates on
the entire row.
In both cases the "selection" reported in the input box above A1
reports the same range but the action in one case is based on the
highlighted cell, and in the other case is not. This is confusing and
inconsistent and from users perspective is certainly a bug.
The selection of row and column ranges by use of the side or top bars
is problematic at other times, as it can be seen that the range
selected is actually A1:IV1 or A1:A65536 and not 1:1 or A:A as expected.
So the short answer to any user is:
if row or column selection does not behave as expected, try selecting
the row or column using Ctrl-shift-arrow and not by clicking on the
side/top bar.
jim
ps: I think the new issue mentioned by Terry relates to
control-shift-end, which works fine.
Thanks for the replies. The user was asking about a whole row selection
but I did not see any difference in principle - Shift+Down should still
work.
It seems that the impression that the keybinding does not work arises
from the fact that the row "selection" is a different kind of
selection. *It is not true to say "in calc this does not happen"*. I
have used column selectors to *select* a whole column when I want to
apply a style (for example, a date style) to the whole column. I've
just experimented by *"selecting"* a row by clicking on the row header
and used that "selection" to apply a style (blue text) to the whole
row. I checked by entering text in various cells (including the last)
in the row.
It seems there are two kinds of selections. One can be extended by
Shift+ and the other can't. At the least, I think some sort of
clarification is needed. I also discovered the reason why the user's
macro recording showed no row selection: the recorder does not record
selection by clicking on the row header. :-X
Regards, Terry
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
