I have problem with converting xls file to pdf when it comes to date format.
My short date format in Windows10 is yy/MM/dd e.g. Windows taskbar shows date 22/02/22.
Xls file contains cell with date format yy/MM/dd e.g. 22/02/15.
After converting file to pdf, pdf shows date in format M/dd/yyyy e.g. 2/15/2022,
so format is different in xls and pdf file.
I attached original xls file and converted pdf file.
This is the code I use for converting:
- Code: Select all
Workbook workbook = new Workbook();
workbook.LoadFromFile(filePath);
workbook.ConverterSetting.SheetFitToPage = true;
workbook.SaveToFile(convertedToPdfFilePath, Spire.Xls.FileFormat.PDF);
I am using paid version Spire.Office for .NET 11.12.0.5420
I want to preserve formating of date format in pdf so date appears in same format as in original pdf.
Can you help?
Thanks