diff --git a/ClosedXML/Excel/XLWorkbook_Save.cs b/ClosedXML/Excel/XLWorkbook_Save.cs index 2200894..9e92af5 100644 --- a/ClosedXML/Excel/XLWorkbook_Save.cs +++ b/ClosedXML/Excel/XLWorkbook_Save.cs @@ -973,7 +973,7 @@ } else { - var value = c.Value.ToInvariantString(); + var value = c.Value.ToInvariantString(); if (newStrings.ContainsKey(value)) c.SharedStringId = newStrings[value]; else @@ -4893,7 +4893,7 @@ valueCalculated = ((double)xlCell.CachedValue).ToInvariantString(); else valueCalculated = xlCell.CachedValue.ToString(); - + cell.CellValue = new CellValue(valueCalculated); } } @@ -5598,6 +5598,7 @@ case String s: openXmlCell.DataType = new EnumValue(CellValues.String); break; + case DateTime dt: openXmlCell.DataType = new EnumValue(CellValues.Date); break; @@ -5653,8 +5654,7 @@ { var timeSpan = xlCell.GetTimeSpan(); var cellValue = new CellValue(); - cellValue.Text = - XLCell.BaseDate.Add(timeSpan).ToOADate().ToInvariantString(); + cellValue.Text = timeSpan.TotalDays.ToInvariantString(); openXmlCell.CellValue = cellValue; } else if (dataType == XLDataType.DateTime || dataType == XLDataType.Number)