https://bugs.documentfoundation.org/show_bug.cgi?id=97529

            Bug ID: 97529
           Summary: STDEV() - wrong result wehn adding a (;) at the end of
                    Formula
           Product: LibreOffice
           Version: unspecified
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Created attachment 122354
  --> https://bugs.documentfoundation.org/attachment.cgi?id=122354&action=edit
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

-- 
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to