public static void InitializeSpreadsheet(this SpreadsheetControl spreadsheetControl) { SpreadsheetUtils.InitializeWorkbook(spreadsheetControl.Document); spreadsheetControl.Options.Behavior.FunctionNameCulture = FunctionNameCulture.English; spreadsheetControl.DocumentLoaded += (s, e) => SpreadsheetUtils.InitializeWorkbook(((SpreadsheetControl)s).Document); spreadsheetControl.EmptyDocumentCreated += (s, e) => SpreadsheetUtils.InitializeWorkbook(((SpreadsheetControl)s).Document); spreadsheetControl.CellBeginEdit += SpreadRichTextEditForm.SpreadsheetControl_CellBeginEdit; spreadsheetControl.PopupMenuShowing += SpreadRichTextEditForm.SpreadsheetControl_PopupMenuShowing; spreadsheetControl.KeyDown += SpreadsheetControl_KeyDown; spreadsheetControl.BeforeDragRange += SpreadsheetControl_BeforeDragRange; spreadsheetControl.DragOver += SpreadsheetControl_DragOver; spreadsheetControl.DragDrop += SpreadsheetControl_DragDrop; var oldMouseHandler = (IMouseHandlerService)spreadsheetControl.GetService(typeof(IMouseHandlerService)); if (oldMouseHandler != null) { spreadsheetControl.RemoveService(typeof(IMouseHandlerService)); } var newMouseHandler = new SCMouseHandlerService(spreadsheetControl, oldMouseHandler); spreadsheetControl.AddService(typeof(IMouseHandlerService), newMouseHandler); }
// add a "MS Access File" option into a standard Open File dialog public static void ExtendOpenFileCommand(this SpreadsheetControl spreadSheet) { IDocumentImportManagerService service = (IDocumentImportManagerService)spreadSheet.GetService(typeof(IDocumentImportManagerService)); CustomDocumentImportManagerService customService = new CustomDocumentImportManagerService(spreadSheet.Document); spreadSheet.ReplaceService <IDocumentImportManagerService>(customService); }
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); } }