public async Task Spreadsheet_AddRow_CellWithoutValue(Type type) { // Arrange using var stream = new MemoryStream(); await using (var spreadsheet = await Spreadsheet.CreateNewAsync(stream)) { await spreadsheet.StartWorksheetAsync("Sheet"); var cell = CellFactory.CreateWithoutValue(type); // Act await spreadsheet.AddRowAsync(cell); await spreadsheet.FinishAsync(); } // Assert SpreadsheetAssert.Valid(stream); using var actual = SpreadsheetDocument.Open(stream, true); var sheetPart = actual.WorkbookPart !.WorksheetParts.Single(); var actualCell = sheetPart.Worksheet.Descendants <OpenXmlCell>().Single(); Assert.Null(actualCell.DataType?.Value); Assert.Equal(string.Empty, actualCell.InnerText); }