Bug 97529 - STDEV() - wrong result wehn adding a (;) at the end of Formula
Summary: STDEV() - wrong result wehn adding a (;) at the end of Formula
Status: CLOSED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
unspecified
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-03 15:30 UTC by hhaupt
Modified: 2016-02-03 16:07 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
shows the bug (or feature) (7.29 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-03 15:30 UTC, hhaupt 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description hhaupt 2016-02-03 15:30:58 UTC 
Created attachment 122354 [details]
shows the bug (or feature)

When calulating a standard deviation from different cells it can happend to get a worng result if a speator at the end.

A example file in the apendix..


The result of =STABW(A1;B1;C1;D1;E1)  and =STABW(A1;B1;C1;D1;E1;) is differnt!

We Found this in different Versions (3.x and 5.04.2) on Mac and Linux Computers in english and german version

=STABW(1;2;3;4;5) -> Result 1,5811388301
=STABW(1;2;3;4;5;) -> Result 1,8708286934
Comment 1 Eike Rathke 2016-02-03 16:06:52 UTC 
Alas, it's not a bug, it's a feature. An empty (missing value) argument is treated as zero in this case. Excel does it the same.