[Libreoffice-bugs] [Bug 133353] Function wizard for DCOUNT and DCOUNTA tells second parameter is required, but it is optional

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=133353

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
     Ever confirmed|0                           |1
                 CC|                            |newbie-02 at gmx.de

--- Comment #1 from b. <newbie-02 at gmx.de> ---
repro, 

Version: 7.0.0.0.alpha1+ (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
Calc: 

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. 4.1.6.2, 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,

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200525/b527d9b6/attachment-0001.htm>