Bug 133353 - Function wizard for DCOUNT and DCOUNTA tells second parameter is required, but it is optional
Summary: Function wizard for DCOUNT and DCOUNTA tells second parameter is required, bu...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Calc-Function
  Show dependency treegraph
Reported: 2020-05-24 16:04 UTC by Regina Henschel
Modified: 2020-05-31 22:11 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2020-05-24 16:04:22 UTC
The function wizard tells, that the second parameter (Database field) is required, but it is optional, see 70806. And with ODF 1.3 this is standard. The text in the function wizard needs to be adapted. The help is already correct.
Comment 1 b. 2020-05-25 07:21:02 UTC

Version: (x64)
Build ID: b587de60d4e6aa96238766272d94f1499b22f696
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default; VCL: win; 
Locale: de-DE (de_DE); UI: en-US

took some time to spot it, have a cell with DCOUNT[A] formula, set focus on it, click formula wizard right to 'name box', click into the formula shown in the box 'Formula' bottom right of the wizard dialog, place cursor on the second parameter, comment above says 'Database field (required)', 

is like that at already in ver., inherited? 

i could add that the function doesn't count the 'cells' in the range but the rows or datasets? 

and that 'Indicates which database field (column) is to be used for the search criteria' is also questionable, on a first view the search criteria is applied by matching the headers of the 'Database' and 'search criteria' definition, while the 'Database field' parameter - if given - restricts the result to rows (datasets) in which the column it indicates evaluates to a numerical value,