Issue 20495 - Q-PCD EaseOfUse-NN-02 Allow (A:A) as range in functions
Summary: Q-PCD EaseOfUse-NN-02 Allow (A:A) as range in functions
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P4 Normal with 17 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Keywords: usability
: 50303 68207 82189 105444 112049 112254 126915 (view as issue list)
Depends on:
Blocks: 15522
  Show dependency tree
Reported: 2003-09-30 17:31 UTC by niklas.nebel
Modified: 2017-11-26 20:02 UTC (History)
10 users (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description niklas.nebel 2003-09-30 17:31:49 UTC
Task tracking system for Childs



Product Requirement 
Allow (A:A) as range in functions

Customer Need/Problem
A compatible range for a whole column is needed (e.g. =sum(A:A) )


Eng Effort

Eng Owner
Niklas Nebel

Product Concept
In formulas in other applications, whole columns or rows can be referenced using
just the column or row names, like 'A:B' or '1:2'. In the Excel file import
these references are already converted to 'A1:B32000' or 'A1:IV2', so nothing is
lost. But a user who tries to enter such formulas in SO/OOo will get an error.
We dont want to change our definition of cell references, because it is part of
the documented file format. Instead, we will do the same conversion as in the
Excel import during formula input. The 'INDIRECT' function also has to be extended.

Functional Specification
Comment 1 lutz.hoeger 2003-10-23 07:44:18 UTC
added keyword Q-PCD
Comment 2 niklas.nebel 2003-12-19 16:14:24 UTC
*** Issue 23098 has been marked as a duplicate of this issue. ***
Comment 3 Martin Hollmichel 2004-05-28 15:00:57 UTC
according to the announcement on releases
( this issue
will be re-targeted to OOo Later.
Comment 4 frank 2005-06-15 15:04:37 UTC
*** Issue 50303 has been marked as a duplicate of this issue. ***
Comment 5 frank 2006-09-13 12:58:44 UTC
changed summary
Comment 6 frank 2006-09-13 12:59:35 UTC
*** Issue 68207 has been marked as a duplicate of this issue. ***
Comment 7 niederbayern 2007-02-23 20:28:23 UTC
The suggestion to convert automatically any entry like (A:A) to (A1:A65563) is
_not_ a sufficient solution!

If you mean to sum the entire culumn A by using =SUM(A1:A65563) in cell B1, and
extend it to a row below by dragging, the second row cell (B2) will take a value
of "=SUM(A2:A#REF!)", obviously not the desired result (to keep selecting the
entire column).

In addition there is a compatibility problem between old sheets that contain
32000 rows and new sheets that contain 65563 rows.

(A:A) and (A1:A65563) are just not the same, but a very different qualitiy of
information. Up to now, OOo lacks the possibility to express a reference to an
entire column or an entire row. 
Comment 8 niederbayern 2007-02-23 20:33:40 UTC
Please consider to enable entering a reference to an entire row/column by a
mouse click on the row/column header.
Comment 9 frank 2007-11-22 15:50:42 UTC
*** Issue 82189 has been marked as a duplicate of this issue. ***
Comment 10 hobleyd 2008-09-23 22:54:52 UTC
Note that the Excel 2007 file import does not convert these references
automatically which effectively breaks the compatibility for those sheets using
this syntax.
Comment 11 frank.loehmann 2009-01-27 11:06:17 UTC
Set target and cc myself.
Comment 12 ooo 2010-06-08 14:45:24 UTC
*** Issue 112049 has been marked as a duplicate of this issue. ***
Comment 13 niklas.nebel 2010-06-10 10:09:37 UTC
*** Issue 112254 has been marked as a duplicate of this issue. ***
Comment 14 CodeLurker 2013-02-14 16:47:59 UTC
Logical extensions or parts of this functionality, depending on whether you want these as separate issue(s) or not, would the the ability to click the SUM button (sigma), and then the column or row title, and get the whole column or row; or several columns or rows.  To be able to think in columns or rows, no matter how many are supported in future versions of the software, would also include being able to use the Format Paintbrush to paint a format on a column or row.  Painting a format on the whole sheet by clicking on the heading square in the upper-left corner would complete this user interface suite of niceties.  Note that one can already set formats this way through Cell | Format; just, not with the Format Paintbrush.  Think of this as one of the pre-Apache things the developers never got around to; but now, it is now a matter of just catching up to where Excel was 10-15 years ago.
Comment 15 damjan 2015-12-11 13:04:37 UTC
*** Issue 105444 has been marked as a duplicate of this issue. ***
Comment 16 orcmid 2015-12-14 00:52:30 UTC
This is now a defect since import of a proper .ods having A:A produced by Excel will cause a failure on entry into AOO as of 4.1.2.

There is a patch under review and there is also some developer discussion on how to accomplish this with appropriate attention to interoperability with earlier ODF 1.2 (and OpenForumula) supporting versions of, AOO, and also LibreOffice before this was repaired there.
Comment 17 Marcus 2017-05-20 10:45:06 UTC
Reset the assignee to the default "".
Comment 18 oooforum (fr) 2017-11-26 17:39:19 UTC
*** Issue 126915 has been marked as a duplicate of this issue. ***