Issue 50303 - Cannot easily reference entire column in a formula
Summary: Cannot easily reference entire column in a formula
Status: CLOSED DUPLICATE of issue 20495
Alias: None
Product: Calc
Classification: Application
Component: ui (show other issues)
Version: recent-trunk
Hardware: All Windows XP
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2005-06-04 11:39 UTC by userinput
Modified: 2005-06-15 15:04 UTC (History)
1 user (show)

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


Note You need to log in before you can comment on or make changes to this issue.
Description userinput 2005-06-04 11:39:29 UTC
One feature I used quite frequently in Excel was the ability to easily reference
an entire column in a formula. Entering "=SUM(A:A)" in Excel returns the sum of
all elements in column A in Excel. In Calc, I get #NAME? instead.

I find this feature useful because it makes it easy to continue adding data to
the column even after the formula has been entered. I have verified that the
feature is missing on 1.1.4 and 2.0 Beta 1.9.104. Not supporting this limits
compatibility with Excel!
Comment 1 frank 2005-06-15 15:04:42 UTC
This is a double to Issue 20495 

*** This issue has been marked as a duplicate of 20495 ***
Comment 2 frank 2005-06-15 15:04:57 UTC
closed double