diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index af014f2..44171ed 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -1221,18 +1221,19 @@ } else if (cell.DataType == CellValues.Date) { - if (!XLHelper.IsNullOrWhiteSpace(cell.CellValue.Text)) + if (cell.CellValue != null && !XLHelper.IsNullOrWhiteSpace(cell.CellValue.Text)) xlCell._cellValue = Double.Parse(cell.CellValue.Text, XLHelper.NumberStyle, XLHelper.ParseCulture).ToInvariantString(); xlCell._dataType = XLCellValues.DateTime; } else if (cell.DataType == CellValues.Boolean) { - xlCell._cellValue = cell.CellValue.Text; + if (cell.CellValue != null) + xlCell._cellValue = cell.CellValue.Text; xlCell._dataType = XLCellValues.Boolean; } else if (cell.DataType == CellValues.Number) { - if (!XLHelper.IsNullOrWhiteSpace(cell.CellValue.Text)) + if (cell.CellValue != null && !XLHelper.IsNullOrWhiteSpace(cell.CellValue.Text)) xlCell._cellValue = Double.Parse(cell.CellValue.Text, XLHelper.NumberStyle, XLHelper.ParseCulture).ToInvariantString(); if (s == null) diff --git a/ClosedXML_Tests/ClosedXML_Tests.csproj b/ClosedXML_Tests/ClosedXML_Tests.csproj index ba753e5..96f18bb 100644 --- a/ClosedXML_Tests/ClosedXML_Tests.csproj +++ b/ClosedXML_Tests/ClosedXML_Tests.csproj @@ -273,6 +273,7 @@ + diff --git a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs index 8746443..6ce8051 100644 --- a/ClosedXML_Tests/Excel/Loading/LoadingTests.cs +++ b/ClosedXML_Tests/Excel/Loading/LoadingTests.cs @@ -23,7 +23,8 @@ @"Misc\LoadPivotTables.xlsx", @"Misc\LoadFileWithCustomSheetViews.xlsx", @"Misc\LoadSheetsWithCommas.xlsx", - @"Misc\ExcelProducedWorkbookWithImages.xlsx" + @"Misc\ExcelProducedWorkbookWithImages.xlsx", + @"Misc\EmptyCellValue.xlsx" }; foreach (var file in files) diff --git a/ClosedXML_Tests/Resource/Misc/EmptyCellValue.xlsx b/ClosedXML_Tests/Resource/Misc/EmptyCellValue.xlsx new file mode 100644 index 0000000..f90b0fc --- /dev/null +++ b/ClosedXML_Tests/Resource/Misc/EmptyCellValue.xlsx Binary files differ