Hi Winfried, On Monday, 2016-07-04 10:36:32 +0200, Winfried Donkers wrote:
> I was pointed to a difference in behaviour between Excel and Calc when the > data range contains non-numeric entries (like #DIV/0!). Indeed, errors should be propagated. > 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. Otherwise a standard deviation can't be calculated. > 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)? Not quite, the general rules for 6.3.7 "Conversion to NumberSequence" apply as usul, i.e. text strings within a cell range are ignored, see https://docs.oasis-open.org/office/v1.2/os/OpenDocument-v1.2-os-part2.html#__RefHeading__1017992_715980110 > In that case I shall create a bug report and start fixing > ScInterpreter::GetStVarParams(...). Please do. Thanks Eike -- LibreOffice Calc developer. Number formatter stricken i18n transpositionizer. GPG key "ID" 0x65632D3A - 2265 D7F3 A7B0 95CC 3918 630B 6A6C D5B7 6563 2D3A Better use 64-bit 0x6A6CD5B765632D3A here is why: https://evil32.com/ Care about Free Software, support the FSFE https://fsfe.org/support/?erack
signature.asc
Description: PGP signature
_______________________________________________ LibreOffice mailing list LibreOffice@lists.freedesktop.org https://lists.freedesktop.org/mailman/listinfo/libreoffice
