Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||Q-PCD EaseOfUse-NN-02 Allow (A:A) as range in functions|
|Component:||ui||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P4||CC:||discoleo, eva-email, frank.loehmann, guychan, issues, kamataki, kpalagin, michel.leprevost, ooo, strideroflands|
|Issue Type:||DEFECT||Latest Confirmation in:||4.1.2|
|Issue Depends on:|
Description niklas.nebel 2003-09-30 17:31:49 UTC
Task tracking system for Childs PLEASE CREATE CHILD-TASKS IN ISSUEZILLA! Source QA/Customer Category Calc 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) ) Comment - 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 (http://www.openoffice.org/servlets/ReadMsg?list=releases&msgNo=7503) 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
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 OpenOffice.org, 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 "firstname.lastname@example.org".