title: Can not read spread sheet cell with different font in C#
body: <p>A spread sheet contains 5 columns and 8 rows. First row is the header of the sheet. I have to read all the data of the cells. The last column contains blank value. C# is unable to read the 5th column of 7th and 8th row. The below code returns array index out of bound exception. </p>
  
  <p>rows[7].Descendants().ElementAt(4)</p>
  
  <p>I have found that the font size of 5th column of rows 7th and 8th are different from the other. If I have changed the font size then it is working fine. I don't have any explanation for this unnatural behaviour.</p>
  
  <p>Please find the code base below</p>
  
  <pre><code>using (SpreadsheetDocument spreadSheetDocument = SpreadsheetDocument.Open(filePath, false))
              {
                  WorkbookPart workbookPart = spreadSheetDocument.WorkbookPart;
                  var workBookSheet = spreadSheetDocument.WorkbookPart.Workbook.GetFirstChild&lt;Sheets&gt;().Elements&lt;Sheet&gt;().Where(s =&gt; s.Name.ToString() == "Feuil1").FirstOrDefault();
  
                  if (workBookSheet != null)
                  {
                      string relationshipId = workBookSheet.Id.Value;
                      WorksheetPart worksheetPart = (WorksheetPart)spreadSheetDocument.WorkbookPart.GetPartById(relationshipId);
                      Worksheet workSheet = worksheetPart.Worksheet;
                      SheetData sheetData = workSheet.GetFirstChild&lt;SheetData&gt;();
                      IEnumerable&lt;Row&gt; rows = sheetData.Descendants&lt;Row&gt;();
                      var data = rows.ElementAt(2).Descendants&lt;Cell&gt;().ElementAt(4);
                  }
              }
  </code></pre>
  
  <p>The spreadsheet looks like below -
  <a href="https://i.stack.imgur.com/lU7gH.jpg" rel="nofollow noreferrer">enter image description here</a></p>
  
  <p>As per the sheet I have got error on row 3 column 4.</p>