Scenario: I try to open attached XLSX file to convert it to PDF. Aspose.Cells 18.6
Issue: FormatException is thrown saying “String was not recognized as a valid DateTime”.
Issue is caused by the DateTime format of the dateTime attribute of the x:header element in the “xl\revisions\revisionHeaders.xml” OpenXml part.
It seems that Aspose.Cells does not like “Z” at the end, because there is no error if I manually remove it.
Microsoft Excel may read both formats - w/ and w/o “Z”.
The value of the dateTime attribute was set using OpenXml SDK (not by manual manipulation with XML file in text editor), so I think it would be good for Aspose.Cells to support both formats.
header.DateTime = DateTime.Now;
sample.zip (7.1 KB)