Apache OpenOffice (AOO) Bugzilla – Issue 50303
Cannot easily reference entire column in a formula
Last modified: 2005-06-15 15:04:57 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!
This is a double to Issue 20495 *** This issue has been marked as a duplicate of 20495 ***
closed double