handling of non-numeric values in STDEV and VAR functions in Calc

[Winfried Donkers]

Hi,

I was pointed to a difference in behaviour between Excel and Calc when the data range contains non-numeric entries (like #DIV/0!).
Excel returns an error with the various VAR and STDEV functions and mentions for these functions that errors or arguments that cannot be converted to numbers produce an error.
ODFF1.2 tells me that at least 2 numbers are needed as argument.
Do I interpret ODFF1.2 correct when I say that for the VAR and STDEV functions all values (single arguments and values in ranges) must return true when checking ISNUMBER(value)?

In that case I shall create a bug report and start fixing ScInterpreter::GetStVarParams(...).

Winfried

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice/attachments/20160704/2d250142/attachment.html>