To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=84168
User regina changed the following:
What |Old value |New value
================================================================================
CC|'kpalagin' |'kpalagin,regina'
--------------------------------------------------------------------------------
Keywords| |oooqa
--------------------------------------------------------------------------------
------- Additional comments from [email protected] Sat Aug 1 23:24:30
+0000 2009 -------
The index 0 is an old syntax from StarOffice 5.2 and has the same meaning as
using the whole data table range as second parameter. In this cases StarOffice
5.2 applies the aggregate function to the right most column of the data table
for DCOUNT and for DCOUNTA. In StarOffice 5.2 you will get the correct result 0
for your example.
The results in OOo2 and OOo3 for the value 0 for the "Field" parameter differ
from those in StarOffice 5.2 and are wrong, not only for the new file format but
also when opening an old sdc file. I have no version OOo 1 installed to look
there.
The ODF 1.2 draft spec does not mention this syntax at all, but only uses the
singular "Field". In addition I find "A field selector that selects a
non-existent field is an error." in chapter 4.9.7. This would be true for the
value 0, because the leftmost column has index 1.
Therefore I think, that OOo should return an error for the old syntax, when it
is used in an ODF format and use the old implementation of "apply aggregate
function to rightmost column" with the correct meaning of DCOUNT and DCOUNTA
concerning number and text, when it is used in an old, non ODF format.
The help is very unclear in this point and needs to be improved, not only
concerning value 0 of the second parameter. For example the text "Indicates
which database field (column) is to be used for the search criteria." for the
second parameter is nonsense. The second parameter determines the field on which
the aggregate function is applied. Which fields are used for the search criteria
is part of the search criteria range itself.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
