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

2016-07-04 Thread Eike Rathke
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 a

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

2016-07-04 Thread 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 pr