Created attachment 79906 [details] Sample spreadsheet Hi, How to reproduce: * Download attachment or: * Open Calc * Enter the following numbers from B1 to B8: 2, 4, 4, 4, 5, 5, 7, 9 (by example of https://en.wikipedia.org/wiki/Stdev#Basic_examples) * Select A1 * formula in A1: =STDEVP(B1;B2;B3;B4;B5;B6;B7;B8;) * Enter Result: 2,454524<bla bla bla> Expected result: 2 (see https://en.wikipedia.org/wiki/Stdev#Basic_examples) Doing the same in Excel for Mac result in a 2 (which is correct). Also other Standard Deviation functions are affected. Kind regards, Joren
Tested on LO 4.0.3.3 (Win7 32bit) =STDEVP(B1;B2;B3;B4;B5;B6;B7;B8;) -> 2,4545247 =STDEVP(B1;B2;B3;B4;B5;B6;B7;B8) -> 2 I think ; followed with no value should trigger error message & suggest correction
Empty argument is considered as 0. Not specific to statistical functions. With 1 in A1, 2 in A2, =AVERAGE(A1;A2;) gives result 1
Thanks for all replies and testing! You both are right! Deleting the trailing ';' fix this, I agree a warning/suggestion would be very welcome in this cases. Therefore I'll change this bug to an enhancement request. Kind regards, Joren
Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.