(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).
(In reply to comment #1) wiki.services. openoffice. org/wiki/ Documentation/ How_Tos/ Calc:_DCOUNT_ function
> this is not a bug
>
> as
> http://
> 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: office. microsoft. com/en- us/excel- help/dcount- HP005209049. aspx
http://
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).