Incorrect DATEDIF function result

[nf64]

Hello,

I using Spire.XLS 10.5.7.

I'm trying to get the date difference using the DATEDIF function.
If you specify "Y", "M", "D" in the argument UNIT, it works well.
However, if you specify "YM", the result will be #NUM.

Recalculating in MS Excel gives the correct results, but
We need to get this result in Spire.XLS.

Code: Select all

using (var workbook = new Workbook())
{
    workbook.LoadFromFile("src.xlsx");

    var sheet = workbook.Worksheets[0];
    sheet["_begin_date"].Value = "1920/01/01";
    sheet["_end_date"].Value = "2048/05/12";
    workbook.CalculateAllValue();

    workbook.SaveToFile("out.xlsx");
}


Thank you and best regards,

[Sara.Yang]

Hi,

Thanks for your inquiry.
I have reproduced your issue and logged it into our bug tracking system with the ticket SPIREXLS-2389 for further investigating. If there is any update, we will inform you. Sorry for the inconvenience caused.

Sincerely,
Sara
E-iceblue support team

[rachel.lei]

Hello,

Thanks for your patient waiting.
Glad to tell you that we released the Spire.XLS Pack(Hotfix) Version:10.7.2 that fixes your issue. Welcome to download it from the following link.
Our website: https://www.e-iceblue.com/Download/down ... t-now.html
Nuget: https://www.nuget.org/packages/Spire.XLS/10.7.2

Sincerely,
Rachel
E-iceblue support team

[nf64]

Hello,

We have confirmed that this issue is fixed in Spire.XLS 10.7.2.
I am always grateful for your help.

Thank you.

[rachel.lei]

Hello,

Thanks for your feedback.
If you encounter any issues related to our products in the future, please feel free to contact us.
Wish you all the best!

Sincerely,
Rachel
E-iceblue support team