InsertCellInWorksheet does not work properly

[iMrTidy]

Current code will fail in different scenarios. One of them: A1, B1, AD1 are existing cells while we are trying to insert C1. I recommend to update code as follows.

This part:

Cell refCell = null;
        foreach (Cell cell in row.Elements<Cell>())
        {
            if (cell.CellReference.Value.Length, == cellReference.Length)
            {
              if (string.Compare(cell.CellReference.Value, cellReference, true) > 0)
              {
                refCell = cell;
                break;
              }
            }
        }

should be replaced by this part:

Cell refCell = null;
			foreach (var cell in row.Elements<Cell>())
			{
				if ((cell.CellReference.Value.Length == cellReference.Length && string.Compare(cell.CellReference.Value, cellReference, StringComparison.OrdinalIgnoreCase) > 0)
					|| cell.CellReference.Value.Length > cellReference.Length)
				{
					refCell = cell;
					break;
				}
			}