[Libreoffice-bugs] [Bug 140665] Help for XIRR / XNPV gives wrong result for the examples

[bugzilla-daemon at bugs.documentfoundation.org]

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

Ming Hua <ming.v.hua at qq.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |ming.v.hua at qq.com
     Ever confirmed|0                           |1

--- Comment #5 from Ming Hua <ming.v.hua at qq.com> ---
The main issue (wrong results of XIRR() and XNPV()) in this bug seems to have
already been fixed by Steve Fanning a few weeks ago:
https://git.libreoffice.org/help/+/1babc5665e751c926cd049e4784b08b0e2f26f7d%5E%21/

And the online help built from master reflects the fix:
https://help.libreoffice.org/7.2/en-US/text/scalc/01/04060118.html

The problem was in the sample data, cell A2 should be Feb. 1st instead of Jan.
2nd.  Mainly a date format mistake, likely caused by the original help author
using a non-standard YYYY-DD-MM format.

The order of entries wasn't touched in the above commit and I didn't
investigate further.

-- 
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/20210226/0c029a32/attachment.htm>