[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

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

Eike Rathke  changed:

   What|Removed |Added

 Status|NEW |ASSIGNED
   Hardware|Other   |All
Version|4.1.2.3 release |Inherited From OOo
   Assignee|libreoffice-b...@lists.free |er...@redhat.com
   |desktop.org |
 OS|Windows (All)   |All

--- Comment #12 from Eike Rathke  ---
ODFF doesn't specify the Field parameter optional, but Excel accepts an empty
missing argument, which is why Calc also does. Furthermore, at least in the
DCOUNT case Excel behaves different if the argument is specified or missing. If
missing, DCOUNT behaves like DCOUNTA on the matching set no matter whether
there is numeric content or not, i.e. all rows that are matched by the criteria
are counted.

These things need clarification in the help documentation and the Field
argument value of 0 shouldn't be mentioned at all, it caters for old versions
and is incompatible with other implementations. Additionally the ODFF
specification needs to be adapted for the empty missing argument case.

-- 
You are receiving this mail because:
You are the assignee for the bug.___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

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

--- Comment #11 from QA Administrators  ---
** Please read this message in its entirety before responding **

To make sure we're focusing on the bugs that affect our users today,
LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed
bugs which have not been touched for over a year.

There have been thousands of bug fixes and commits since anyone checked on this
bug report. During that time, it's possible that the bug has been fixed, or the
details of the problem have changed. We'd really appreciate your help in
getting confirmation that the bug is still present.

If you have time, please do the following:

Test to see if the bug is still present on a currently supported version of
LibreOffice (5.0.4 or later)  https://www.libreoffice.org/download/

If the bug is present, please leave a comment that includes the version of
LibreOffice and your operating system, and any changes you see in the bug
behavior

If the bug is NOT present, please set the bug's Status field to
RESOLVED-WORKSFORME and leave a short comment that includes your version of
LibreOffice and Operating System

Please DO NOT:

- Update the version field
- Reply via email (please reply directly on the bug tracker)
- Set the bug's Status field to RESOLVED - FIXED (this status has a particular
meaning that is not appropriate in this case)

If you want to do more to help you can test to see if your issue is a
REGRESSION. To do so: 1. Download and install oldest version of LibreOffice
(usually 3.3 unless your bug pertains to a feature added after 3.3)

http://downloadarchive.documentfoundation.org/libreoffice/old/

2. Test your bug 3. Leave a comment with your results. 4a. If the bug was
present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not
present in 3.3 - add "regression" to keyword


Feel free to come ask questions or to say hello in our QA chat:
http://webchat.freenode.net/?channels=libreoffice-qa

Thank you for your help!

-- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #10 from Alex Thurgood ipla...@yahoo.co.uk ---
Adding self to CC if not already on

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #8 from Winfried Donkers winfrieddonk...@libreoffice.org ---
(In reply to Robinson Tryon (qubit) from comment #6)

My conclusion after a quick look in the code base is that the code explicitly
allows the absence of the field argument, as long as the criteria argument
produces valid results (DCOUNT as well as DCOUNTA).

The ODF1.2 standard does not mark any argument optional.

One could wonder if this is a violation of the standard or functionality that
is more than required by the standard. We have more functions in Calc that
offer more functionality than is required by the standard.

The code has not been changed since the start of LibreOffice, the last change
to the DCOUNT/DCOUNTA code is from March 2010.

I would suggest to change the (help) documentation to reflect its actual
functionality, which IMHO is more user friendly than strict coherence to the
standard. But then, I'm only a developer ;-)

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

Robinson Tryon (qubit) qu...@runcibility.com changed:

   What|Removed |Added

 Status|UNCONFIRMED |NEW
 Ever confirmed|0   |1

--- Comment #9 from Robinson Tryon (qubit) qu...@runcibility.com ---
(In reply to Winfried Donkers from comment #8)
 (In reply to Robinson Tryon (qubit) from comment #6)
 
 My conclusion after a quick look in the code base is that the code
 explicitly allows the absence of the field argument, as long as the criteria
 argument produces valid results (DCOUNT as well as DCOUNTA).
 
 The ODF1.2 standard does not mark any argument optional.
 
 One could wonder if this is a violation of the standard or functionality
 that is more than required by the standard. We have more functions in Calc
 that offer more functionality than is required by the standard.

So strictly speaking, it sounds like the code disagrees with the standard.

 The code has not been changed since the start of LibreOffice, the last
 change to the DCOUNT/DCOUNTA code is from March 2010.
 
 I would suggest to change the (help) documentation to reflect its actual
 functionality, which IMHO is more user friendly than strict coherence to the
 standard. But then, I'm only a developer ;-)

Fair enough. That solution seems reasonable to me, especially if we were to
make a note of our deviation from the standard the way that we do with
extensions to ODF:
https://wiki.documentfoundation.org/Development/ODF_Implementer_Notes/List_of_LibreOffice_ODF_Extensions

In any case, it seems clear that there's some real work to be done here
(Documentation, development, or etc..), so Status - NEW.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

Robinson Tryon (qubit) qu...@runcibility.com changed:

   What|Removed |Added

 CC||qu...@runcibility.com,
   ||winfrieddonkers@libreoffice
   ||.org

--- Comment #6 from Robinson Tryon (qubit) qu...@runcibility.com ---
Winfried: Your insight regarding these functions would be appreciated. Thanks!

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #7 from Winfried Donkers winfrieddonk...@libreoffice.org ---
(In reply to Robinson Tryon (qubit) from comment #6)
 Winfried: Your insight regarding these functions would be appreciated.
 Thanks!

I will have a look at the ODF1.2 standard and the code, but probably not this
week.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #5 from John Smith clicks...@yahoo.co.uk ---
(In reply to comment #4)
 @Dominique Boutry and John Smith: if it is NOTABUG and only documentation
 correction is needed can we close this bug and report new one for docs/help
 fix?

I am of the opinion that this is a bug having read through the specification
here; 
http://docs.oasis-open.org/office/v1.2/cs01/OpenDocument-v1.2-cs01-part2.html#DCOUNT
which shows no parameter to be optional.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

bfoman bfo.bugm...@spamgourmet.com changed:

   What|Removed |Added

 CC||bfo.bugm...@spamgourmet.com

--- Comment #4 from bfoman bfo.bugm...@spamgourmet.com ---
@Dominique Boutry and John Smith: if it is NOTABUG and only documentation
correction is needed can we close this bug and report new one for docs/help
fix?

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #3 from John Smith clicks...@yahoo.co.uk ---
Hi Dominique.
I'm working with the LO Docs team doing the User Guides, but not the Help
documentation. I'm trying to determine whether the documentation is wrong in
its description or the function is buggy. I'm quite happy to write up the User
Guide to indicate this is an optional parameter if that's the case. Thanks,  JS

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #2 from Dominique Boutry dominique.bout...@laposte.net ---
Let's examine the behaviour of the function DCOUNT or DCOUNTA :
1/ first, it applies a selection on the DB lines (the DB is the fisrt argument,
the criteria is the third argument),
2/ secondly, it counts the number of selected lines which have one column
(pointed to by the second argument, by name or by rank from 1 to N) or the
totality of the columns (second argument = 0 or omited) containing a value
either numeric (DCOUNT) or non empty (DCOUNTA).

I added or omited because it is what we see and it is logical. So NotABug,
but a clarification to do in the documentation.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

[Libreoffice-bugs] [Bug 70806] EDITING: DCOUNT and DCOUNTA function parameter.

[bugzilla-daemon]

https://bugs.freedesktop.org/show_bug.cgi?id=70806

--- Comment #1 from John Smith clicks...@yahoo.co.uk ---
Created attachment 88048
  -- https://bugs.freedesktop.org/attachment.cgi?id=88048action=edit
Spreadsheet illustrating the problem described.

-- 
You are receiving this mail because:
You are the assignee for the bug.
___
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs