[Libreoffice-qa] [QA] Need someone having Excel

[Gérard Fargeot]

The reporter first, yhen Joel close yhe bug report.
I'm not sure this is a good idea. The screenshot provided by Miroslav show
that Excel handles functions in the same way whether the argument either
text or number.
=COUNTIF(range;1)
=COUNTIF(range;"1")
=COUNTIF(range;"=1")
provides the same result in Excel with range having text data while Calc
count only numerical values for the 1st one.

This apply to COUNTIF(S) and SUMIF(S).

What is the opinion of dev's about this (Eike or another)? Should we comply
to Excel in this case or not ?




--
View this message in context: http://nabble.documentfoundation.org/QA-Need-someone-having-Excel-tp4171047p4171093.html
Sent from the QA mailing list archive at Nabble.com.