<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Function wizard for DCOUNT and DCOUNTA tells second parameter is required, but it is optional"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133353">bug 133353</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>UNCONFIRMED
</td>
<td>NEW
</td>
</tr>
<tr>
<td style="text-align:right;">Ever confirmed</td>
<td>
</td>
<td>1
</td>
</tr>
<tr>
<td style="text-align:right;">CC</td>
<td>
</td>
<td>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Function wizard for DCOUNT and DCOUNTA tells second parameter is required, but it is optional"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133353#c1">Comment # 1</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Function wizard for DCOUNT and DCOUNTA tells second parameter is required, but it is optional"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=133353">bug 133353</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>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,</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>