https://bz.apache.org/ooo/show_bug.cgi?id=84168
[email protected] changed: What |Removed |Added ---------------------------------------------------------------------------- Status|CONFIRMED |RESOLVED Latest|--- |4.2.0-dev Confirmation in| | Keywords|oooqa | OS|Windows XP |All Hardware|PC |All CC| |[email protected] Resolution|--- |FIXED --- Comment #5 from [email protected] --- In commit 561c6157b86908803ccecf18699e7b5dfaba10b2 the help text was changed to state: DCOUNT: If the DatabaseField parameter is present, it should specify the column in which to count the numerical values. If it is absent or set to the number 0, it doesn't count any column's values, and just returns the number of rows matching the criteria. DCOUNTA: If the DatabaseField parameter is present, it should specify the column in which to count the alphanumerical values. If it is absent or set to the number 0, it doesn't count any column's values, and just returns the number of rows matching the criteria. (And that's what my tests show. The "right most column" is irrelevant.) This will be available to users once the odf-1.3 branch is merged to trunk and other branches. You will also be able to omit the 2nd parameter to DCOUNT and DCOUNTA instead of using 0, like recent versions of Excel also allow. Resolving FIXED. -- You are receiving this mail because: You are the assignee for the issue. You are on the CC list for the issue.
