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

            Bug ID: 101943
           Summary: BETAINV and BETA.INV constraints
           Product: LibreOffice
           Version: 5.3.0.0.alpha0+ Master
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Both BETA.INV and BETAINV are Excel functions, the first being the
newest and recommended one. There may be differences in accuracy between
the 2, but essentially they are identical and could be combined in 1
test document.

ODFF1.2 only mentions BETAINV.

The code does neither fully comply with the published Excel constraints,
nor with the ODFF1.2 constraints:
The code accepts a probability of 0 but not of 1 (which does comply
neither with ODFF1.2 nor with Excel);
The code does not accept A == B, but does accept A > B (which is not
allowed in both ODFF1.2 and Excel (not published, but constraint is
applied in Excel);
The code returns 0 when p equals 0, which is incorrect when A is not 0.

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

Reply via email to