Reformatting dates in Excel files - Japanese Environment

when displaying a page of an Excel file where the date format is DD/MM/YYYY it will appear as MM/DD/YYYY in the web client when running in a Japanese environment

Recreation steps:

create an Excel file.
Add a date and format it as dd/mm/yyyy.
Upload the file to EWB.
Display the page or create PDF
You will see the date as mm/dd/yyyy.
This does not happen with other date formats such as dd/mm/yy/

@idbs,

Could you please try our latest fix/version Aspose.Cells v21.12.6 (attached):
[.NET]
Aspose.Cells21.12.6 For .Net2_AuthenticodeSigned.Zip (5.6 MB)
Aspose.Cells21.12.6 For .Net4.0.Zip (5.6 MB)
Aspose.Cells21.12.6 For .NetStandard20.Zip (5.6 MB)

[Java]
aspose-cells-21.12.6-java.zip

If you still find the issue with latest version, kindly provide the following:

  1. Input Excel file having your desired format in tact.
  2. Output PDF file by Aspose.Cells API.
  3. Regional/locale settings of the system where you are processing the conversion code.

We will check your issue soon.