Japanese calendar is different from Excel output

[nagamune_iis]

I'm concerned that the Japanese calendar output is different between Spire.Pdf and Excel.
Please note that some parts are in Japanese language.

# Explanation of the difference

- Spire.Pdf output
- "日本年号令和6年1月19日"

- excel output
- "令和6年1月19日"

- Excel function

Code: Select all

=TEXT("2024/01/19","[$-411]ggge年m月d日")

# Points of concern

"日本年号" text is not required

# question
- Q1
- Is this output by design? bug?

- Q2
- Will this output continue in future versions?
- The first "日本年号" word added remains unchanged

# reference
Search the Microsoft site for the following sentence:
"[<=43585][$-ja-JP]ggge"?"m"?"d"?";[>=43831]ggge"?"m"?"d"?";ggg"??"m"?"d"?""

# Execution environment
- Spire.Pdf.dll 8.10.5.1420
- OS WIndows11/WindowsServer/Linux(Ubuntu other)
- Net6/Net8
- Microsoft Excel 2019

I hope for a good answer.
Yours sincerely

[Annika.Zhou]

Hello,

Thank you for your inquiry.

Based on your description, I conducted initial testing and found that the value of the function in the Excel file is displayed as "令和6年1月19日". This result is consistent with the calculation result obtained when using Microsoft Excel.
However, when converting the Excel file to PDF using Spire.XLS Pack Version:14.1, the resulting PDF file displays the same result as you mentioned. After careful investigation, I have determined that this issue is a bug in our product. I have logged the issue into our bug tracking system with the ticket number SPIREXLS-5105. Our development team will investigate and fix it. Once it is resolved, I will inform you in time. Sorry for the inconvenience caused.

Sincerely,
Annika
E-iceblue support team

[nagamune_iis]

Thank you for your prompt reply.

Thank you for investigating this as a bug.
We will wait for the release of the corresponding version.

[Annika.Zhou]

Hello,

You're welcome.
Rest assured that once a fix for this issue is released, I will notify you immediately.
Thank you for your understanding and patience.

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Thank you for your patience.
Regarding the SPIREXLS-5105 bug you previously reported, we have successfully resolved it and implemented the fix in our latest version 14.3.3. Please download the newest version from the following link.
Website download link: https://www.e-iceblue.com/Download/download-excel-for-net-now.html
Nuget download link: https://www.nuget.org/packages/Spire.XLS

Sincerely,
Annika
E-iceblue support team

[nagamune_iis]

Hello.

Sorry for the delay in replying.
I have tried the new module and it works as expected.
We are very satisfied.

Thank you very much.

[Annika.Zhou]

Hello ,

You're welcome.
If you encounter other issues related to our products in the future, please feel free to contact us.
Have a nice day.

Sincerely,
Annika
E-iceblue support team