I'm using ClosedXML to read an existing Excel sheet. I tried to load the Excel using a stream. When I load the excell I get an Object reference not set to an instance of an object.
exception. This occurs in the line:
EnumValue<ReferenceModeValues> referenceMode = dSpreadsheet.WorkbookPart.Workbook.CalculationProperties.ReferenceMode;
of the LoadSpreadsheetDocument method.
It apears that the CalculationProperties property is null, so the call to the
ReferenceMode throws the exception. Has anybody any idea why this is?