To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=112049 Issue #|112049 Summary|Functions on columns works different compared to Excel Component|Spreadsheet Version|OOo 3.1.1 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|FEATURE Priority|P2 Subcomponent|code Assigned to|kohei Reported by|lanciaux
------- Additional comments from lanci...@openoffice.org Wed Jun 2 20:14:53 +0000 2010 ------- 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) --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org