diff --git a/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/Excel/XLWorkbook_Load.cs index caf4c3f..d62bb95 100644 --- a/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/Excel/XLWorkbook_Load.cs @@ -611,7 +611,6 @@ } } - #endregion } @@ -1131,8 +1130,8 @@ xlCell._dataType = XLCellValues.Number; else xlCell.DataType = GetDataTypeFromCell(xlCell.Style.NumberFormat); - } } + } else if (cell.CellValue != null) { if (s == null) diff --git a/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx b/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx index 9cd627d..5bc0db9 100644 --- a/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx +++ b/ClosedXML_Tests/Resource/Examples/PivotTables/PivotTables.xlsx Binary files differ