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