We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

SpreadsheetML is Invalid for OWC when cell contains DateTime


When I save a workbook as SpreadsheetML, the output is invalid for the OWC.

For example, I used the following code to produce a SpreadsheetML:

var workbook = new Workbook();

var worksheet = workbook.Worksheets[0];

// 2008-08-08 8:08:08am

worksheet.Cells[0,0].PutValue(new DateTime(2008, 8, 8, 8, 8, 8));

// Set display format of cell to a date

worksheet.Cells[0, 0].Style.Number = 15;

workbook.Save(“C:\SaveSpreadsheetMLCellWithDateTime.result.xml”, FileFormatType.SpreadsheetML);

The SpreadsheetML contains the line:

<ss:Data ss:Type=“DateTime”>2008-08-08T08:08:08Z</ss:Data>

The problem here is that the date here is not valid for OWC because of the “Z” at the end. Once the “Z” is removed, this SpreadsheetML becomes ok.

Is it possible if the “Z” can be removed for datetime types?



Please try this fix.

And we have fixed another bug about named range in <A href="wlmailhtml:{AF3FBF61-BA42-45F4-88B5-63096A803E39}mid://00000014/!x-usc:</A></P>

Fix is great, thank you!