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.
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
