XLSX to PDF conversion - date format is disturbed in Java

Hello,

We have the latest version of GroupDocs, and when we try converting a Spreadsheet with a cell in the DD/MM/YYYY format to PDF, these cells get converted to MM/DD/YYYY. I wonder if there’s a load or save option we can use to avoid this behavior. I have found an option (setConvertDateTimeData) for CSV that might do the trick, but it’s not present in Spreadsheets so I couldn’t confirm if it would work.

I can’t attach an example .xlsx, but you can do the steps below and create one. I could reproduce the issue in your Live Demo here too:

  1. Open a Microsoft Excel file and right click on a cell and select Number Format;
  2. In Number Format, change the locale to UK english and set the format to the asterisk first option;
  3. Check the checkbox to save this as your preferred regional format;
  4. In a cell enter a date using the DD/MM/YYYY format, save and export the file;
  5. Convert the file and see that the format changed to MM/DD/YYYY.

Book.xlsx.zip (6.7 KB)

I have compressed the file, here you go!

1 Like

@murilopaiva

This issue is reproduced at our end. Hence, we’ve logged it in our internal issue tracking system with ID CONVERSIONJAVA-1463. You’ll be notified in case of any further update.

1 Like

@Atir_Tahir
Thank you very much!

@murilopaiva

You’re welcome.