Comment 10 for bug 681080

Revision history for this message
In , penalvch (penalvch) wrote :

(In reply to comment #1)
> this is not a bug
>
> as
> http://wiki.services.openoffice.org/wiki/Documentation/How_Tos/Calc:_DCOUNT_function
> mentions 0 is used for all columns

<email address hidden>, as mentioned in the above link:
"Issues:

The exact use of 0 as the field parameter is unclear, both in operation and in compatibility (issue 84168)".

As well, Microsoft clears up what it means via:
http://office.microsoft.com/en-us/excel-help/dcount-HP005209049.aspx

The field parameter is not supposed to have a 0 in it as field is the column to use. A 0 column does not make sense. Hence, LO should throw an error for Excel compatibility reasons (Gnumeric also throws the error appropriately).