Change Details

In the Investment Report, the XIRR() function is used to calculate the annual return. The previous implementation contains some errors that have been corrected with this commit. In addition, if XIRR cannot calculate the annual return to notify the user of this case, an empty column is displayed in the investment report with this commit. The basis for this fix is an update of the XIRR implementation from the KOffice project, which brings the calculation up to date and a further Complement from the libreoffice XIRR implementation to get more solutions using a two-pass approach. The class CashFlowList has been moved to separate files to standardize copyright. The obsolete and unused NPV function has been removed. Tests for XIRR have been extended to check for found errors. BUG:385993 FIXED-IN:4.8.3

In the Investment Report, the XIRR() function is used to calculate the annual return. The previous implementation contains some errors that have been corrected with this commit. In addition, if XIRR cannot calculate the annual return to notify the user of this case, an empty column is displayed in the investment report. The basis for this fix is an update of the XIRR implementation from the KOffice project [1], which brings the calculation up to date and a further improvement from the libreoffice XIRR implementation [2] to get more solutions using a two-pass approach. The class CashFlowList has been moved to separate files to have a cleaner separation. The obsolete and unused NPV function has been removed. Tests for XIRR have been extended to check for recognized issues. [1] https://github.com/KDE/koffice/blob/master/kcells/functions/financial.cpp [2] https://raw.githubusercontent.com/LibreOffice/core/master/scaddins/source/analysis/financial.cxx BUG:385993 FIXED-IN:4.8.3

In the Investment Report, the XIRR() function is used to calculate the annual return. The previous implementation contains some errors that have been corrected with this commit. In addition, if XIRR cannot calculate the annual return to notify the user of this case, an empty column is displayed in the investment report with this commit. The basis for this fix is an update of the XIRR implementation from the the KOffice project [1], which brings the calculation up to date and a further Compla further improvement from the libreoffice XIRR implementation to get more solutions[2] to get more solutions using a two-pass approach. The class CashFlowList has been moved to separate files to standardize copyright. has been moved to separate files to have a cleaner separation. The obsolete and unused NPV function has been removed. Tests for XIRR have been extended to check for recognized issues. [1] https://github.com/KDE/koffice/blob/master/kcells/functions/financial.cpp Tests for XIRR have been extended to check for found errors.[2] https://raw.githubusercontent.com/LibreOffice/core/master/scaddins/source/analysis/financial.cxx BUG:385993 FIXED-IN:4.8.3