IXLRows delete method's runtime is quadratic

[sechel]

In contract to what is stated in the documentation the runtime of IXLRows.Delete() is quadratic, see

ClosedXML/ClosedXML/Excel/Rows/XLRows.cs

Line 80 in a4f2312

kp.Key.Row(r).Delete();

In my case replacing IXLRows.Delete() by IXLRange.Delete() has huge performance gains.

public void Delete()
{
    if (_worksheet != null)
    {
        _worksheet.Internals.RowsCollection.Clear();
        _worksheet.Internals.CellsCollection.Clear();
    }
    else
    {
        var toDelete = new Dictionary<IXLWorksheet, List<Int32>>();
        foreach (XLRow r in Rows)
        {
            if (!toDelete.TryGetValue(r.Worksheet, out List<Int32> list))
            {
                list = new List<Int32>();
                toDelete.Add(r.Worksheet, list);
            }

            list.Add(r.RowNumber());
        }

        foreach (KeyValuePair<IXLWorksheet, List<int>> kp in toDelete)
        {
            foreach (int r in kp.Value.OrderByDescending(r => r))
                kp.Key.Row(r).Delete();
        }
    }
}