Leap year calculation correction

[H0rux]

This is:

- [ ] a bug report

What is the expected behavior?

File described here https://github.com/PHPOffice/PhpSpreadsheet/blob/master/tests/data/Calculation/DateTime/YEARFRAC.php does not calculate accurately after 2024, so leap years 2028, 2032, etc are having slight miscalculation

What are the steps to reproduce?

No adequate steps, file provided simply does not have data after 2024.
Issue is happening when using PMT function.

What features do you think are causing the issue

• Formula Calculations

Does an issue affect all spreadsheet file formats? If not, which formats are affected?

All

Which versions of PhpSpreadsheet and PHP are affected?

1.2.5
2.0.0

[oleibman]

I do not understand your issue. The file you point to consists only of test data, not code. Even so, it is test data for YEARFRAC, and your issue says there is a problem with PMT. Do you have an example where PhpSpreadsheet returns the wrong value for YEARFRAC or PMT?

[H0rux]

Hi again,

Apologies for long delay in reply, I wanted my team to review everything thoroughly again.

We are using this for client work, so I cannot share data and there is no way to anonymize it. The issue we are seeing is the usage of PMT in Excel vs usage in PMT in your code, that seems to be surfacing after 2028 leap year.

We made a correction in data from excel to account for this small anomaly.

I would only ask if you can keep an on other potential reports regarding leap year.

I will close this issue now, as I would not like to waste your time furher.