WPF平台中的GcSpreadSheet控件的CTRL+C,CTRL+V功能

收藏

WPF平台中的GcSpreadSheet控件，本身是支持CTRL+C,CTRL+V的，但是我们的业务需要用户按下CTRL+C,CTRL+V的时候做一些业务处理，怎么可以屏蔽掉控件本身的CTRL+C,CTRL+V功能，重写自己的事件处理程序？

dexteryao · dexteryao

您参考下下面代码，自定义keymap

public MainWindow()
{
InitializeComponent();
Dictionary<GrapeCity.Windows.SpreadSheet.UI.KeyStroke, GrapeCity.Windows.SpreadSheet.UI.SpreadAction> keyMap = gcSpreadSheet1.View.KeyMap;
keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.OemPlus, ModifierKeys.Alt), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(OnInsertSumFormula));
keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.B, ModifierKeys.Alt), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(GrapeCity.Windows.SpreadSheet.UI.SpreadActions.NavigationLeft));
keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.A, ModifierKeys.Alt), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(GrapeCity.Windows.SpreadSheet.UI.SpreadActions.Clear));
}
private void OnInsertSumFormula(GrapeCity.Windows.SpreadSheet.UI.SheetView sheet)
{
int r = sheet.Worksheet.ActiveRowIndex;
int c = sheet.Worksheet.ActiveColumnIndex;
if (r > 0)
{
int rStart = r - 1;
System.ComponentModel.TypeConverter doubleConverter = System.ComponentModel.TypeDescriptor.GetConverter(typeof(double));
while (rStart > 0)
{
object val = sheet.Worksheet.Cells[rStart, c].Value;
if (val is double || val is float || val is long || val is int || val is short || val is byte ||
(val != null && doubleConverter.CanConvertFrom(val.GetType())))
rStart--;
}
//Type numbers in a few cells in a column and type Alt + equal in the cell below them.
//Hit enter to see the formula update.
string formula = "SUM(" + sheet.Worksheet.Cells[rStart, c, r - 1, c].ToString() + ")";
sheet.Worksheet.Cells[r, c].Formula = formula;
sheet.StartCellEditing();
}
}

复制代码

hcy525 · hcy525

private void gcSpreadSheet1_Loaded(object sender, RoutedEventArgs e)
      {
         try
         {

            this.gcSpreadSheet1.ClipboardPasted += gcSpreadSheet1_ClipboardPasted;
            LoadSpreadMain();
            this.gcSpreadSheet1.TabStripVisibility = Visibility.Hidden;
            //if (m_ReportCtrl == null) return;

            //m_ReportCtrl.ActiveCellChanged();
            Dictionary<GrapeCity.Windows.SpreadSheet.UI.KeyStroke, GrapeCity.Windows.SpreadSheet.UI.SpreadAction>  keyMap = gcSpreadSheet1.View.KeyMap;
            keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.C, ModifierKeys.Control), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(OnCopy));
            keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.V, ModifierKeys.Control), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(OnPaste));
         }
         catch (Exception ex)
         {
            MessBox.MsgBoxErr(ex);

         }
      }
      //操作面板复制
      private void OnCopy(object sender,ActionEventArgs e)
      {
         m_ReportCtrl.CopyCellProperty();
      }
      private void OnPaste(object sender, ActionEventArgs e)
      {
         m_ReportCtrl.PasteCellProperty();
      }
像这样写的代码，当按下CTRL+C,CTRL+V的时候，没有触发相应的事件，该怎么处理？

dexteryao · dexteryao

因为keyMap中已经有ctrl+c了，所以您要先remove掉
keyMap.Remove(new KeyStroke(Key.C, ModifierKeys.Control));
keyMap.Add(new KeyStroke(Key.C, ModifierKeys.Control), new SpreadAction(OnCopy));

hcy525 · hcy525

因为keyMap中已经有ctrl+c了，所以您要先remove掉
keyMap.Remove(new KeyStroke(Key.C, ModifierKeys.Control));
keyMap.Add(new KeyStroke(Key.C, ModifierKeys.Control), new SpreadAction(OnCopy));与这种方式相反，怎么可以还原成控件原有的CTRL+C,CTRL+V功能，屏蔽掉自定义的CTRL+C,CTRL+V功能？

dexteryao · dexteryao

您好，同样是remove掉老的，
然后

keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.C, ModifierKeys.Control), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(GrapeCity.Windows.SpreadSheet.UI.SpreadActions.Copy));
keyMap.Add(new GrapeCity.Windows.SpreadSheet.UI.KeyStroke(Key.V, ModifierKeys.Control), new GrapeCity.Windows.SpreadSheet.UI.SpreadAction(GrapeCity.Windows.SpreadSheet.UI.SpreadActions.Paste));

hcy525 · hcy525

请问下，我用下面的方式屏蔽了控件本身的F2快捷键，加上了自定义的F2快捷键功能，我怎么可以屏蔽掉自定义的功能，还原到控件原有的F2快捷键？
keyMap.Remove(new KeyStroke(Key.F2, ModifierKeys.None));
keyMap.Add(new KeyStroke(Key.F2, ModifierKeys.None), new SpreadAction(OnEditProperty));

Alice · Alice

hcy525 发表于 2016-9-7 11:48
请问下，我用下面的方式屏蔽了控件本身的F2快捷键，加上了自定义的F2快捷键功能，我怎么可以屏蔽掉自定义的 ...

您好。
这个问题已经在您新开的帖子里回复，如果有任何需要沟通的问题，您可以在那个帖子里跟帖。

		自动登录	找回密码
密码			立即注册

[已处理] WPF平台中的GcSpreadSheet控件的CTRL+C,CTRL+V功能

7 个回复

讲师达人

悬赏达人

元老葡萄

SpreadJS 认证

SpreadJS 高级认证

微信认证勋章

活字格认证