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. _______________________________________________ List Name: Libreoffice-qa mailing list Mail address: Libreoffice-qa@lists.freedesktop.org Change settings: http://lists.freedesktop.org/mailman/listinfo/libreoffice-qa Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://lists.freedesktop.org/archives/libreoffice-qa/