Issue 112049 - Functions on columns works different compared to Excel
Summary: Functions on columns works different compared to Excel
Status: CLOSED DUPLICATE of issue 20495
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 3.1.1
Hardware: All All
: P2 Trivial (vote)
Target Milestone: ---
Assignee: kyoshida
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-06-02 21:14 UTC by lanciaux
Modified: 2010-06-08 14:46 UTC (History)
1 user (show)

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

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description lanciaux 2010-06-02 21:14:53 UTC 
Hello,

I have found something really different compared to Excel behavior this week and
this should only be the visible part of affected functions.

I use sometimes columns like this on Excel : CountA(B:B) which on Excel give a
number of non empty cells ... but on Openoffice : I got 1 all the time even if
the column is empty.

I'm sure there is a lot of functions working like this (sum(), average(), etc.)

Hope to get it fixed in Ooo 3.3

Ludovic (Belgium)
Comment 1 Joe Smith 2010-06-03 15:40:29 UTC 
This is covered by Issue 20495

Until that change is made, you must use a complete reference for the entire
column: A1:A65536 or row: A1:AMJ1
Comment 2 ooo 2010-06-08 14:45:31 UTC 
Then let's mark it as duplicate..

*** This issue has been marked as a duplicate of 20495 ***
Comment 3 ooo 2010-06-08 14:46:33 UTC 
Closing dup.