Japanese Era "Reiwa" Incorrect in Spire.XLS PDF Output

[nobu_441]

Dear Support Team,

I am experiencing an issue where the Japanese era name "Reiwa" is not displayed correctly when converting an Excel template to a PDF using Spire.XLS.

-Issue
When applying a date format with the Japanese era in an Excel cell, the displayed value is incorrect after PDF conversion.

-Details
When using Excel’s "Cell Format Settings" to display the era name (2019/04/30 → 平成31年4月30日 (Heisei 31, April 30, 2019)):
It is displayed correctly in the PDF output.

When using the formula TEXT("2019/04/30","[$-411]ggge年m月d日") in an Excel cell:
In Excel, it correctly displays "平成31年4月30日 (Heisei 31, April 30, 2019)".
However, after PDF conversion, it incorrectly displays "令和元年4月30日 (Reiwa 1, April 30, 2019)".

Since the "Reiwa" era officially started on May 1, 2019, the correct era for April 30, 2019, should be "Heisei 31". However, the PDF output incorrectly displays "Reiwa 1".

-Environment
OS: Windows 10
.NETCore: 8.0.12
Spire.XLS: 14.12.2
Excel:MS365

-Attachments
Excel template
PDF output
Source code

Could you please investigate this issue and let me know if a fix is possible?
If you need any additional information, please let me know.

Best regards,

[Nina.Tang]

Hi,

Thanks for your feedback.
I have reproduced your issue and logged it into our bug tracking system with the issue ID: SPIREXLS-5713. Our dev team will investigate it. Once it is resolved or there is any update, I will let you know. Apologize for the inconvenience caused.

Sincerely,
Nina
E-iceblue support team

[nobu_441]

Hi,

Thank you for your prompt response and for logging the issue. I appreciate your support.
I look forward to any updates on this matter.

Best regards,

[Nina.Tang]

Hi,

Glad to inform you that the reported bug SPIREXLS-5713 has been resolved and the new version (Spire.XLS Pack(Hotfix) Version:15.4.0) is available. Please download the version from the link below and set the cultural information to ensure the correctness of the conversion effect.

Code: Select all

 Thread.CurrentThread.CurrentCulture = new CultureInfo("ja-JP");

Websit download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link：https://www.nuget.org/packages/Spire.XLS/15.4.0
https://www.nuget.org/packages/Spire.XLSfor.NETStandard/15.4.0

Sincerely,
Nina
E-iceblue support team

[nobu_441]

Dear Spire.XLS Team,

Thank you for your prompt response and assistance regarding the issue with the "Reiwa" era in the PDF output. I have tested the suggested solution and confirmed that the problem has been resolved. The output now displays the "Reiwa" era correctly in the PDF file as expected.

I appreciate your support in addressing this bug and providing a timely fix.

Best regards,

[Nina.Tang]

Hi,

Your feedback is invaluable to us, and we truly appreciate you taking the time to share your positive experience.
If you encounter any further issues or have additional suggestions, please don’t hesitate to reach out. Our team is always here to assist you.

Sincerely,
Nina
E-iceblue support team