[Libreoffice-bugs] [Bug 119573] New: YIELD function shows inconsistent results for basis 3

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 119573
           Summary: YIELD function shows inconsistent results for basis 3
           Product: LibreOffice
           Version: 6.0.5.2 release
          Hardware: All
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: minor
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: postgrey at outlook.com

Created attachment 144524
  --> https://bugs.documentfoundation.org/attachment.cgi?id=144524&action=edit
spreadsheet showing bug

Using the YIELD function, with basis argument 3 ("Exact number of days in
month, year has 365 days"), for the different settlement and maturity dates but
with the same number of days inbetween those dates, results in different yield
numbers.

They are also different from the output in MS Excel while the two programs
agree when the default basis of 0 is used (360 days in the year, 30 days in the
month).

Maybe something is going wrong with the dates math.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180828/26f544e3/attachment.html>