Bug#418541: oocalc amd64 XNPV also affected
Hi,
XNPV, the invers function to XIRR, also appears to be affected in a similar way. Calculating the Net Present Value based on
the rate calculated by XIRR, a rate of 0% and 13.0662% all result in 7.25E-322 as a NPV (displayed as 0). I would
have expected that only 13.0662% (or maybe the XIRR result) yield 0.
Addition to xirr-demo1-amd64:
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXnpv(0;[.B1:.B3];[.A1:.A3])" office:value-type="float"
office:value="7.25E-322">
<text:p>0</text:p>
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXnpv([.B5];[.B1:.B3];[.A1:.A3])" office:value-type="float"
office:value="7.25E-322">
<text:p>0</text:p>
table:formula="oooc:=com.sun.star.sheet.addin.Analysis.getXnpv(0.130662;[.B1:.B3];[.A1:.A3])" office:value-type="float"
office:value="7.25E-322">
<text:p>0</text:p>
Kai
Reply to: