← 返回所有博客文章

Spread Winform中响应delete按键实现数据删除,需要手写代码。 在实践的过程发现有3种办法可供选择:

  • 响应KeyDown事件
  • 自定义Action
  • 自定义UndoAction
    最终效果见截图:

Spread_delete比如我是选中A4:B5 的8个单元格,在按delete键,按照excel的话,直接就删除八个里的数据

 

响应KeyDown事件

判断当前按键为delete键,对selection内容ActiveSheet.ClearRange即可,代码如下所示:

  1: this.fpSpread1.KeyDown += new KeyEventHandler(spread_KeyDown);
  2: 
  3: private void spread_KeyDown(object source, KeyEventArgs e)
  4:         {
  5:             if (e.KeyCode == Keys.Delete)
  6:             {
  7:                 FpSpread spread = (FpSpread)source;
  8:                 int selectionCount = spread.ActiveSheet.SelectionCount;
  9:                 if (selectionCount > 0)
 10:                 {
 11:                     for (int i = 0; i < selectionCount; i++)
 12:                     {
 13:                         CellRange range = spread.ActiveSheet.GetSelection(i);
 14:                         spread.ActiveSheet.ClearRange(range.Row, range.Column, range.RowCount, range.ColumnCount, true);
 15:                     }
 16:                 }
 17:                 else
 18:                 {
 19:                     int activeRow = spread.ActiveSheet.ActiveRowIndex;
 20:                     int activeColumn = spread.ActiveSheet.ActiveColumnIndex;
 21:                     spread.ActiveSheet.ClearRange(activeRow, activeColumn, 1, 1, true);
 22:                 }
 23:                 e.Handled = true;
 24:             }
 25:         }
 26: 

 

自定义Action

前面有一篇博文已经针对专门写的,且有C#、VB的源码:

自定义Spread中快捷键行为

 

自定义UndoAction

当有了删除操作,就会有Undo的潜在需求,玩意误删除怎么办呢?  毕竟Spread的UI和Excel非常相似。实现一个Undo、Redo操作在Spread下也非常简单。

需要一个继承UndoAction的类,每次撤销、重做算一次完整的操作,会实例化一个UndoAction继承类。

源码如下所示:

  1:             this.fpSpread1.GetInputMap(InputMapMode.WhenFocused).Put(new Keystroke(Keys.Delete, Keys.None), FarPoint.Win.Spread.SpreadActions.ClearSelectedCells);
  2:             this.fpSpread1.GetActionMap().Put(SpreadActions.ClearSelectedCells, new ClearSelectedCellsUndoAction());
  3: 
  4: 
  5:     public class ClearSelectedCellsUndoAction : FarPoint.Win.Spread.UndoRedo.UndoAction
  6:     {
  7:         SpreadView spreadView = null;                         // SpreadView where action happens
  8:         FarPoint.Win.Spread.SheetView activeSheet = null;     // active SheetView in root workbook
  9:         FarPoint.Win.Spread.SheetView sheet = null;           // SheetView where action happens 
 10:         FarPoint.Win.Spread.Model.CellRange cellRange = null; // CellRange being cleared
 11:         DataObject clipData = null;                           // DataObject containing data from CellRange
 12: 
 13:         public override bool PerformUndoAction(object sender)
 14:         {
 15:             SpreadView rootWorkbook = sender as SpreadView;     // sender is always root SpreadView when called from UI
 16: 
 17:             if (rootWorkbook != null) // but sender might be null if other code calls this, so check!
 18:             {
 19:                 activeSheet = rootWorkbook.Sheets[rootWorkbook.ActiveSheetIndex]; // save active SheetView (to restore on undo)
 20:                 spreadView = rootWorkbook.GetActiveWorkbook();                    // save active SpreadView (to restore on undo)
 21:                 sheet = spreadView.GetSheetView();                                // get SheetView to operate on
 22:                 cellRange = sheet.GetSelection(sheet.SelectionCount - 1);         // get CellRange to operate on
 23:                 if (cellRange == null)  // GetSelection return null if there is no selection, just active cell
 24:                     cellRange = new CellRange(sheet.ActiveRowIndex, sheet.ActiveColumnIndex, 1, 1); // use active cell in this case
 25:             }
 26:             if (SaveUndoState()) // save data from range
 27:             { // then clear it
 28:                 sheet.ClearRange(cellRange.Row, cellRange.Column, cellRange.RowCount, cellRange.ColumnCount, false);
 29:                 return true;
 30:             }
 31:             return false; // something failed, return false to discard action from undo stack
 32:         }
 33: 
 34:         protected override bool SaveUndoState()
 35:         {
 36:             if (cellRange != null) // need CellRange set in PerformUndoAction (implied sheet is valid)
 37:                 clipData = sheet.GetClipDataObject(false, cellRange, ClipboardCopyOptions.All); // save data object for cell range
 38:             return clipData != null;
 39:         }
 40: 
 41:         public override bool Undo(object sender)
 42:         {
 43:             SpreadView rootWorkbook = sender as SpreadView;
 44:             if (rootWorkbook != null)
 45:             {
 46:                 rootWorkbook.ActiveSheetIndex = rootWorkbook.Sheets.IndexOf(activeSheet); // restore active sheet (in case user changed it)
 47:                 rootWorkbook.SetActiveWorkbook(spreadView); // restore active workbook in sheet (in case user changed it)
 48:                 sheet.ClearSelection(); // reset selection (clear, then add)
 49:                 sheet.AddSelection(cellRange.Row, cellRange.Column, cellRange.RowCount, cellRange.ColumnCount);
 50:                 sheet.ClipboardPaste(ClipboardPasteOptions.All, clipData); // paste data pack from data object
 51:                 return true;
 52:             }
 53:             return false;
 54:         }
 55:     }
 56: 

 

C#源码如下: