Issue 20495

Summary: Q-PCD EaseOfUse-NN-02 Allow (A:A) as range in functions
Product: Calc Reporter: niklas.nebel
Component: uiAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Normal    
Priority: P4 CC: discoleo, eva-email, frank.loehmann, guychan, issues, kamataki, kpalagin, michel.leprevost, ooo, strideroflands
Version: OOo 1.0.0Keywords: usability
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: 4.1.2
Developer Difficulty: ---
Issue Depends on:    
Issue Blocks: 15522    

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. ***