We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.

Add and Delete Row events

Thread ID:

Created:

Updated:

Platform:

Replies:

125726 Sep 6,2016 04:57 PM Sep 7,2016 06:21 AM WPF 1
loading
Tags: SfSpreadsheet
James
Asked On September 6, 2016 04:57 PM

For the sfSpreadsheet control, Does anyone know

1. Are there events fired when then user selects  InsertRow or  DeleteRow ?
2. Can these command, and others, be removed from the Spreadsheet control context menu (when right click on a cell)
3. Can these commands, and others, be removed from the Spreadsheet Ribbon control?


I have spent quite some time reading all knowledge base, but no references to these seem to exist

James

Kanimozhi Bharathi [Syncfusion]
Replied On September 7, 2016 06:21 AM

Hi James, 
 
Thank you for contacting Syncfusion Support. 
 
Please find the details below, 
 
QUERY 
RESPONSE 
Are there events fired when then user selects  InsertRow or  DeleteRow ? 
 
While inserting row/column or deleting row/column, the following Events of SpreadsheetGridModel class are fired, 
 
1)      ColumnsInserted 
2)      ColumnsRemoved 
3)      RowsInserted 
4)      RowsRemoved 
 
Can these command, and others, be removed from the Spreadsheet control context menu (when right click on a cell) 
The existing menu items in the cell context menu can be removed by invoking CellContextMenuOpening event like below code example, 
 
spreadsheet.ActiveGrid.CellContextMenuOpening += ActiveGrid_CellContextMenuOpening;  
void ActiveGrid_CellContextMenuOpening(object sender, CellContextMenuOpeningEventArgs e) 
{  
//Get the existing Context menu items 
var items = spreadsheet.ActiveGrid.CellContextMenu.Items; 
//Remove the existing Context menu  
spreadsheet.ActiveGrid.CellContextMenu.Items.RemoveAt(6); 
} 
 
 
Please find the UG link for your reference, 
 
 
 
Can these commands, and others, be removed from the Spreadsheet Ribbon control? 
 
Yes. You can remove the ribbon tab and also  ribbon items from the ribbon tab. Please find the UG link for your reference, 
 
 
 
 
Regards 
Kanimozhi B 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.

;