https://bugs.documentfoundation.org/show_bug.cgi?id=70806
Eike Rathke <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|NEW |ASSIGNED
Hardware|Other |All
Version|4.1.2.3 release |Inherited From OOo
Assignee|[email protected] |[email protected]
|desktop.org |
OS|Windows (All) |All
--- Comment #12 from Eike Rathke <[email protected]> ---
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
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
