If we manipulate DateTimeFormat for CurrentCulture in our code, and then try to convert an xlsx file having a DateTimeFormat-ted cell with a value, we get an unexpected result.
Sample code could be:
ShortDatePattern = “d MMMM yyyy”,
var cellDoc = new Aspose.Cells.Workbook("d://Book2.xlsx"); cellDoc.Save("d://CellsResult.pdf", Aspose.Cells.SaveFormat.Pdf);
The source xlsx is Book2.zip (6.4 KB)
The result looks like:
11/14 November 2019/2019
Thursday, 14 November 2019