[Date Prev][Date Next] [Thread Prev][Thread Next] [Date Index] [Thread Index]

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: