https://bugs.documentfoundation.org/show_bug.cgi?id=140665
Ming Hua <[email protected]> changed:
What |Removed |Added
----------------------------------------------------------------------------
Status|UNCONFIRMED |NEW
CC| |[email protected]
Ever confirmed|0 |1
--- Comment #5 from Ming Hua <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
