diff --git a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs index a5daeea..e473333 100644 --- a/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs +++ b/ClosedXML/ClosedXML/ClosedXML/Excel/XLWorkbook_Load.cs @@ -87,13 +87,17 @@ var date1904 = dSpreadsheet.WorkbookPart.Workbook.WorkbookProperties.Date1904; Use1904DateSystem = date1904 != null && date1904.Value; - var referenceMode = dSpreadsheet.WorkbookPart.Workbook.CalculationProperties.ReferenceMode; - if (referenceMode != null) - ReferenceStyle = referenceMode.Value.ToClosedXml(); + var calculationProperties = dSpreadsheet.WorkbookPart.Workbook.CalculationProperties; + if (calculationProperties != null) + { + var referenceMode = calculationProperties.ReferenceMode; + if (referenceMode != null) + ReferenceStyle = referenceMode.Value.ToClosedXml(); - var calculateMode = dSpreadsheet.WorkbookPart.Workbook.CalculationProperties.CalculationMode; - if (calculateMode != null) - CalculateMode = calculateMode.Value.ToClosedXml(); + var calculateMode = calculationProperties.CalculationMode; + if (calculateMode != null) + CalculateMode = calculateMode.Value.ToClosedXml(); + } if (dSpreadsheet.ExtendedFilePropertiesPart.Properties.Elements().Count() > 0) Properties.Company = dSpreadsheet.ExtendedFilePropertiesPart.Properties.GetFirstChild().Text;