Hello Tomas,

Thank you for the provided sample.

I have been looking into it and after investigation, I determined that this behavior is due to the worksheet’s ActiveSelection’s cell range, which is different in the two scenarios you described.

When deleting a row by right-clicking on the row-index, the ActiveSelection’s CellRange is the entire row, including cells which are protected – i.e. “A2:XFD2”. Therefore attempting to delete the row is interpreted as attempting to delete protected cells.

On the other hand, when deleting a row by selecting any of the editable cells, the ActiveSelection’s CellRange is only that cell, however, the entire row deletion is indeed properly handled by the XamSpreadsheet. 

My suggestion in this case is to handle the spreadsheet’s CommandExecuting event, check for the “DeleteRows” command and manually set the proper CellRange, based on the current selection. Since the editable region is known as per your description, the startColumn and endColumn indexes are hardcoded for the purposes of the example:

private void spreadSheet_CommandExecuting(object sender, SpreadsheetCommandExecutingEventArgs e)
        {
			if(e.Command == SpreadsheetCommandType.DeleteRows)
            {
				int startRow = 0;
				int endRow = 0;
				int startColumn = 0;
				int endColumn = 2;
				XamSpreadsheet spreadsheet = sender as XamSpreadsheet;

				int cellRangesCount = spreadsheet.ActiveSelection.CellRanges.Count;
				startRow = spreadsheet.ActiveSelection.CellRanges[0].FirstRow;
				endRow = spreadsheet.ActiveSelection.CellRanges[cellRangesCount - 1].LastRow;

               //...

				spreadsheet.ActiveSelection.ClearCellRanges();
				spreadsheet.ActiveSelection.ReplaceActiveCellRange(
					new SpreadsheetCellRange(startRow, startColumn, endRow, endColumn), 
					spreadsheet.ActiveCell
				);
				
                //...				
            }
        }

I have modified the sample provided by you to use the approach from above. You can find it attached below. Please, test it on your side and let me know how it behaves.

Sincerely,

Bozhidara Pachilova

Associate Software Developer

4426.SpreadsheetSampleModified.zip

Steps to reproduce in the example 7318.SpreadsheetMinimalPrototype.zip:

• Click on the rowIndex for the datarow (row 2)
• Press ctrl+c
• Press ctrl+v

Result console output as to your logging:

Before modifying default ActiveSelection cell range:

A2:XFD2

Set selected rows: First 2, Last: 2

After modifying default ActiveSelection cell range:

A2:C2

Row pasted!

But there is still the error message that it is trying to change a protected cell.

The adapted sample is attached.

Thanks in advance,

Tomas