/// <summary>
 /// Adds a new row at the bottom of the Excel editing range.
 /// </summary>
 /// <param name="clearColoringOfOldNewRow">Flag indicating whether the previous row that was placeholder for new rows is cleared of its formatting.</param>
 /// <returns>An Excel range containing just the newly added row.</returns>
 private ExcelInterop.Range AddNewRowToEditingRange(bool clearColoringOfOldNewRow)
 {
     EditingWorksheet.UnprotectEditingWorksheet(EditingWorksheet_Change, WorksheetProtectionKey);
     _editDataRange = _editDataRange.AddNewRow(clearColoringOfOldNewRow, out var newRowRange);
     EditingWorksheet.ProtectEditingWorksheet(EditingWorksheet_Change, WorksheetProtectionKey, _editDataRange);
     _editingRowsQuantity = _editDataRange.Rows.Count;
     return(newRowRange);
 }
 /// <summary>
 /// Protects the edit dialog's worksheet.
 /// </summary>
 public void ProtectWorksheet()
 {
     EditingWorksheet.ProtectEditingWorksheet(EditingWorksheet_Change, WorksheetProtectionKey, _editDataRange);
 }