https://bugs.freedesktop.org/show_bug.cgi?id=70806
Priority: medium
Bug ID: 70806
Assignee: [email protected]
Summary: EDITING: DCOUNT and DCOUNTA function parameter.
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: Other
Whiteboard: BSA
Status: UNCONFIRMED
Version: 4.1.2.3 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 88047
--> https://bugs.freedesktop.org/attachment.cgi?id=88047&action=edit
An ODT document, illustrating with a screenshot, the situation described above.
Problem description:
The DCOUNT and DCOUNTA functions have a parameter 'Database field', stated as
'required' which appears to be optional.
Steps to reproduce:
1. Open an instance of Calc and launch the Function Wizard.
2. Select the Database category and double-click on DCOUNT or DCOUNTA.
3. Click in the Database field input box to display the explanation.
Current behavior:
It states that this parameter is required. It can be omitted in both functions
without returning an error and with the correct result being returned.
Expected behavior:
Either the instructions for both functions are wrong and the parameter is
optional, or the functions have a bug which fails to return an error.
The Help file text for DCOUNT specifically states the parameter cannot be
omitted. The Help text for DCOUNTA is not specific about it, but that
conclusion can be drawn from the phrasing.
It appears that as long as the Search criteria parameter includes the field
heading a result will be returned.
Operating System: Windows XP
Version: 4.1.2.3 release
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
