Issue 68207 - Using a range to select a row/column
Summary: Using a range to select a row/column
Status: CLOSED DUPLICATE of issue 20495
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.0.2
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2006-08-07 03:54 UTC by diamondmagic
Modified: 2006-09-13 12:59 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description diamondmagic 2006-08-07 03:54:28 UTC
Unlike Excel, OOo Calc has no real way to have a range cover an entire row or
column. The docs (Help->Spreadsheets->Formulas and Calculations->Calculating
With Formulas) suguest instead to use a very wide range:

=SUM(B1:B65536)  Sums all numbers in column B.

However this can be unsuitable in some cases. If you use the suguested solution
(lets say in cell A1), and extend it to a row below by dragging, the second row
cell (A2) will take a value of "=SUM(B2:B#REF!)", obviously not the desired
result (to keep selecting the entire column).

I would enjoy it if (similar to Excel) omitting the column or row specifier
means select all of the cells. As a variation, omitting only the first or last
means select all from the start until one cell or from a cell onwards (so A2:A
means all column A cells starting at row 2). This would also need to be worked
into the equation editor so you can click a row/column header (If there is a
solution like this, it isn't implemented into the equation editor).
Comment 1 pagalmes.lists 2006-08-07 06:57:42 UTC

Already encountered this kind of problem.
Comment 2 frank 2006-09-13 12:59:35 UTC
Double to Issue 20495

*** This issue has been marked as a duplicate of 20495 ***
Comment 3 frank 2006-09-13 12:59:50 UTC
closed double