Go to https://help.libreoffice.org/Calc/Financial_Functions_Part_Three#XIRR Read: If the payments take place at regular intervals, use the IRR function. the source code should be in the optimal case: If the payments take place at regular intervals, use the [[Scalc/SC HID FUNC IRR|IRR function]]. @jani @ohallot: EasyHack?
same for XNPV --> NPV: https://help.libreoffice.org/index.php?title=5.2/Calc/Financial_Functions_Part_Three&Language=de&System=WIN&Version=5.2#XNPV
Gabor Kelemen committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=67f77ad0e414cfc4d08b821944616f5b819ac774 tdf#103241 Link XIRR and IRR as well as XNPV and NPV to each other
Gabor is already working on it. Moving it to New
Gabor Kelemen committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/help/commit/?id=bc8558025b4c47b6506d002eb98ba3f0774264e6 tdf#103241 related: fix this bad file reference I made
@Gabor: can you backport the change please to 5.3 so that we get an updated help in February when 5.3 is released? Thx
Gabor Kelemen committed a patch related to this issue. It has been pushed to "libreoffice-5-3": http://cgit.freedesktop.org/libreoffice/help/commit/?id=58d8c98f612bdd9c8e4a25581e165ab01881dec8&h=libreoffice-5-3 tdf#103241 Link XIRR and IRR as well as XNPV and NPV to each other