private void Sp_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e) { SpreadsheetControl control = sender as SpreadsheetControl; if (e.MenuType == SpreadsheetMenuType.Cell) { e.Menu.RemoveMenuItem(SpreadsheetCommandId.InsertHyperlinkContextMenuItem); ISpreadsheetCommandFactoryService service = (ISpreadsheetCommandFactoryService)control.GetService(typeof(ISpreadsheetCommandFactoryService)); //SpreadsheetMenuItemCommandWinAdapter adapter = new SpreadsheetMenuItemCommandWinAdapter(service.CreateCommand(SpreadsheetCommandId.FileNew)); //SpreadsheetMenuItem item = (SpreadsheetMenuItem)adapter.CreateMenuItem(DXMenuItemPriority.Normal); //item.BeginGroup = true; //item.Caption = "新建"; //e.Menu.Items.Add(item); //SpreadsheetMenuItemCommandWinAdapter adapter2 = new SpreadsheetMenuItemCommandWinAdapter(service.CreateCommand(SpreadsheetCommandId.FileOpen)); //var item2 = (SpreadsheetMenuItem)adapter2.CreateMenuItem(DXMenuItemPriority.Normal); //item2.Caption = "打开Excel文件"; //e.Menu.Items.Add(item2); SpreadsheetMenuItemCommandWinAdapter adapter3 = new SpreadsheetMenuItemCommandWinAdapter(service.CreateCommand(SpreadsheetCommandId.FileSaveAs)); var item3 = (SpreadsheetMenuItem)adapter3.CreateMenuItem(DXMenuItemPriority.Normal); item3.Caption = "另存为"; e.Menu.Items.Add(item3); SpreadsheetMenuItemCommandWinAdapter adapter4 = new SpreadsheetMenuItemCommandWinAdapter(service.CreateCommand(SpreadsheetCommandId.FilePrintPreview)); var item4 = (SpreadsheetMenuItem)adapter4.CreateMenuItem(DXMenuItemPriority.Normal); item4.Caption = "打印预览"; e.Menu.Items.Add(item4); SpreadsheetMenuItemCommandWinAdapter adapter5 = new SpreadsheetMenuItemCommandWinAdapter(service.CreateCommand(SpreadsheetCommandId.ViewShowGridlines)); var item5 = (SpreadsheetMenuItem)adapter5.CreateMenuItem(DXMenuItemPriority.Normal); item5.Caption = "显示/隐藏网格线"; e.Menu.Items.Add(item5); SpreadsheetMenuItemCommandWinAdapter adapter6 = new SpreadsheetMenuItemCommandWinAdapter(service.CreateCommand(SpreadsheetCommandId.ViewShowHeadings)); var item6 = (SpreadsheetMenuItem)adapter6.CreateMenuItem(DXMenuItemPriority.Normal); item6.Caption = "显示/隐藏excel列头"; e.Menu.Items.Add(item6); } }
private void spreadsheetControl1_PopupMenuShowing(object sender, PopupMenuShowingEventArgs e) { if (e.MenuType == SpreadsheetMenuType.Cell) { // Remove the "Clear Contents" menu item. e.Menu.RemoveMenuItem(SpreadsheetCommandId.FormatClearContentsContextMenuItem); // Disable the "Hyperlink" menu item. e.Menu.DisableMenuItem(SpreadsheetCommandId.InsertHyperlinkContextMenuItem); // Create a menu item for the Spreadsheet command, which inserts a picture into a worksheet. ISpreadsheetCommandFactoryService service = (ISpreadsheetCommandFactoryService)spreadsheetControl1.GetService(typeof(ISpreadsheetCommandFactoryService)); SpreadsheetCommand cmd = service.CreateCommand(SpreadsheetCommandId.InsertPicture); SpreadsheetMenuItemCommandWinAdapter menuItemCommandAdapter = new SpreadsheetMenuItemCommandWinAdapter(cmd); SpreadsheetMenuItem menuItem = (SpreadsheetMenuItem)menuItemCommandAdapter.CreateMenuItem(DevExpress.Utils.Menu.DXMenuItemPriority.Normal); menuItem.BeginGroup = true; e.Menu.Items.Add(menuItem); // Insert a new item into the Spreadsheet popup menu and handle its click event. SpreadsheetMenuItem myItem = new SpreadsheetMenuItem("My Menu Item", new EventHandler(MyClickHandler)); e.Menu.Items.Add(myItem); } }