Incorrect PPMT execution result

Aspose.Cells Product Family
1

Formula: =PPMT(0,005833333;3,6;12;-1750;0;0)
Aspose result: 143.69915167651834
Expected result: 143.365216572828
c# validation code: Microsoft.VisualBasic.Financial.PPmt(0.005833333,3.6,12,-1750,0,0)

2

@abulaev,

Please notice, I am able to reproduce the issue as you mentioned. I found that there is difference b/w the calculation results for PPMT formula of MS Excel Vs Aspose.Cells.
e.g.
Sample code:

Workbook wb = new Workbook();
Worksheet worksheet = wb.Worksheets[0];
string formula = "=PPMT(0.005833333,3.6,12,-1750,0,0)";
object value = worksheet.CalculateFormula(formula);

I have logged a ticket with an id “CELLSNET-47731” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

3

@abulaev,
This is to inform you that we have fixed your issue now. We will soon provide you the fixed version after performing QA and incorporating other enhancements and fixes.

1 Like
4

@abulaev,

Please try our latest version/fix: Aspose.Cells for .NET v20.11.5 (attached)

Your issue should be resolved.

Let us know your feedback.
Aspose.Cells20.11.5 For .Net2_AuthenticodeSigned.Zip (5.4 MB)
Aspose.Cells20.11.5 For .Net4.0.Zip (5.4 MB)

1 Like
5

The issues you have found earlier (filed as CELLSNET-47731) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao

6

There is another issue with the PPMT:
Formula =PPMT(287.98,0.005833333,12,-1750,0,0)
Returns $151.07 in the Excel
But “#NUM!” in the code
var wb = new Workbook();
var worksheet = wb.Worksheets[0];
var formula = “=PPMT(287.98,0.005833333,12,-1750,0,0)”;
var value = worksheet.CalculateFormula(formula);

7

@abulaev,

I tried your formula “=PPMT(287.98,0.005833333,12,-1750,0,0)” in MS Excel 2016 manually and it also gives me “#NUM!”, so it is correct behavior. See the screenshot (attached) for your reference.
sc_shot1.png (36.1 KB)

8

Sorry, I made mistake in parameters.
=PPMT(0.005833333,12.6,12,-1750,0,0)

9

@abulaev,

Thanks for providing more details.

Please notice, now I am able to reproduce the issue as you mentioned. I found that there is difference b/w the calculation results for PPMT formula of MS Excel Vs Aspose.Cells. MS Excel returns $151.07 in the Excel whereas “#NUM!” is retrieved via Aspose.Cells APIs.
e.g.
Sample code:

var wb = new Workbook();
var worksheet = wb.Worksheets0;
var formula = "=PPMT(0.005833333,12.6,12,-1750,0,0)";
var value = worksheet.CalculateFormula(formula);

I have logged a separate ticket with an id “CELLSNET-47824” for your issue. We will look into it soon.

Once we have an update on it, we will let you know.

10

Please try our latest version/fix: Aspose.Cells for .NET v21.1.2 (attached)
Your issue should be resolved.
Let us know your feedback.
Aspose.Cells21.1.2 For .Net2_AuthenticodeSigned.Zip (5.5 MB)
Aspose.Cells21.1.2 For .Net4.0.Zip (5.5 MB)
Aspose.Cells21.1.2 For .NetStandard20.Zip (5.5 MB)

11

It works. Thank you.

12

@abulaev,

Good to know that your issue is resolved by the new fix. Have questions, comments or find issue(s)? feel free to write us back.

13

The issues you have found earlier (filed as CELLSNET-47824) have been fixed in this update. This message was posted using Bugs notification tool by simon.zhao