类: CommandManager

Spread.Commands.CommandManager

Table of contents

构造方法

• constructor

方法

• execute
• register
• setShortcutKey

构造方法

constructor

• new CommandManager(context)

命令管理器

参数

方法

execute

▸ execute(commandOptions): boolean

执行命令并将该命令添加到UndoManager中

代码示例

//例如，下面的代码执行autoFitColumn命令
var spread = GC.Spread.Sheets.findControl(document.getElementById("ss"));
spread.commandManager().execute({cmd: "autoFitColumn", sheetName: "Sheet1", columns: [{col: 1}], rowHeader: false, autoFitType: GC.Spread.Sheets.AutoFitType.cell});

参数

返回值

boolean

执行命令的结果

register

▸ register(name, command, key?, ctrl?, shift?, alt?, meta?): void

向命令管理器注册命令

代码示例

//For example, the following code registers the changeBackColor command and then executes the command.
var command = {
  canUndo: true,
  execute: function (context, options, isUndo) {
    var Commands = GC.Spread.Sheets.Commands;
    options.cmd = "changeBackColor";
    if (isUndo) {
      Commands.undoTransaction(context, options);
      返回true
    } else {
      Commands.startTransaction(context, options);
      var sheet = context.getSheetFromName(options.sheetName);
      var cell = sheet.getCell(options.row, options.col);
      cell.backColor(options.backColor);
      Commands.endTransaction(context, options);
      返回true
    }
  }
};
var spread = GC.Spread.Sheets.findControl(document.getElementById("ss"));
var commandManager = spread.commandManager();
commandManager.register("changeBackColor", command);
commandManager.execute({cmd: "changeBackColor", sheetName: spread.getSheet(0).name(), row: 1, col: 2, backColor: "red"});

参数

返回值

void

setShortcutKey

▸ setShortcutKey(commandName, key?, ctrl?, shift?, alt?, meta?): void

将快捷键绑定到命令

代码示例

//本示例改变了默认键的行为
var activeSheet = spread.getActiveSheet();
//Change the default Up arrow key action to "Page Up" for the active cell.
spread.commandManager().setShortcutKey('navigationPageUp', GC.Spread.Commands.Key.up, false, false, false, false);
//Change the default Down arrow key action to "Page Down" for the active cell.
spread.commandManager().setShortcutKey('navigationPageDown', GC.Spread.Commands.Key.down, false, false, false, false);

参数

返回值

void