title: ClosedXML generated file wont open in MS Spreadsheet Compare tool
body: <p>I'm trying to build new process to auto generate Excel files using ClosedXML (0.92.1). The very basic XLSX file will open in Excel just fine, but when I try to use the <a href="https://support.office.com/en-us/article/Compare-two-versions-of-a-workbook-by-using-Spreadsheet-Compare-0E1627FD-CE14-4C33-9AB1-8EA82C6A5A7E" rel="nofollow noreferrer">MS tool Spreadsheet Compare tool</a>, it can't open the file. The error we are getting is </p>
  
  <p><em>"Error opening workbook. Attempted to read past the end of the stream"</em></p>
  
  <p>If I open the ClosedXML generated file in Excel and save it first, the file can now be opened by the Spreadsheet Comparison tool. Excel is fixing/adding something to the file that is missing from ClosedXML.</p>
  
  <p>I'm just using very basic code</p>
  
  <pre><code>    using (var workbook = new XLWorkbook())
      {
          workbook.Properties.Author = "Me";
          workbook.Properties.Title = "Title";
          var worksheet = workbook.AddWorksheet("Sheet 1");
          worksheet.Row(1).Cell(1).SetValue("test");
          workbook.SaveAs("c:\\temp\\testing.xlsx");
      }
  </code></pre>
  
  <p>The goal is to use the Spreadsheet comparison tool to make sure what we are generating is matching the old process that created the same file. </p>
  
  <p>I ran the file the "Open and Repair" in the Excel file open dialog, and it gives me this report on the original file generated from ClosedXML. </p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8" standalone="yes"?&gt;
  &lt;recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main"&gt;
  &lt;logFileName&gt;error260080_01.xml&lt;/logFileName&gt;&lt;summary&gt;Errors were detected in file 'C:\TEMP\testing.xlsx'&lt;/summary&gt;
  &lt;additionalInfo&gt;&lt;info&gt;Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.&lt;/info&gt;&lt;/additionalInfo&gt;
  &lt;/recoveryLog&gt;
  </code></pre>