Issue 74201 - Problem Selecting Entire Rows/Columns
Summary: Problem Selecting Entire Rows/Columns
Status: CLOSED DUPLICATE of issue 21869
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.1
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2007-02-05 23:59 UTC by glenndrayton
Modified: 2007-02-06 11:32 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description glenndrayton 2007-02-05 23:59:17 UTC
This issue follows from the discussions in the Calc forum under:

"Help need with selecting and dragging cells and rows"

The issue has been flagged as bug in that discussion, and is as follows:

The row marks and column headers in Calc can be used to select entire 
rows/columns. However, the selection cannot be extended using Shift-Up/Down 
(rows) or Shift-Left/Right as a user would expect.

To reproduce the issue, do the following:

1. Click a Row marker to select the entire row (e.g. Row "2").
2. Press Shift-Down arrow

The result is that cells A2:A3 are selected, but the expected result is that 
entire rows 2-3 should be selected.

There is a secondary (most likely related issue):

Selecting an entire row or column while editing a formula does not add the 
entire row or column reference to the formula. For example, if the formula is 
the sum of column A, then we want =SUM(A:A). To produce this, one would expect 
to be able to type =SUM( in a cell, and then click the header for column A, but 
this does nothing.
Comment 1 terrynorth 2007-02-06 00:26:15 UTC
It seems reasonable for a user to expect that a selection made using the headers
should have the same results as a selection made otherwise.

I can select a row with the row header and apply a style to the entire row - so
there is a selection of the row in some sense at least.  If I then use
Shift+Down, the selection becomes the cell in column A and the cell below it. 
Comment 2 frank 2007-02-06 09:10:30 UTC
double to Issue 21869

*** This issue has been marked as a duplicate of 21869 ***
Comment 3 frank 2007-02-06 09:11:24 UTC
please transfer your vote.
Closed double
Comment 4 glenndrayton 2007-02-06 11:32:27 UTC
What a cop-out! That other issue has been open for 4 years!!! When is this most
basic feature going to be fixed?. Hello, hello, is there anyone out there?