Skip to Content
ClassesFEventName

类: FEventName

属性

属性修饰符类型描述

BeforeClipboardChange

readonly

"BeforeClipboardChange"

Trigger this event before the clipboard content changes. Type of the event parameter is IBeforeClipboardChangeParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeClipboardChange, (params) => {
  const { workbook, worksheet, text, html, fromSheet, fromRange } = params;
  console.log(params);
 
  // Cancel the clipboard change operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeClipboardPaste

readonly

"BeforeClipboardPaste"

Trigger this event before pasting. Type of the event parameter is IBeforeClipboardPasteParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeClipboardPaste, (params) => {
  const { workbook, worksheet, text, html } = params;
  console.log(params);
 
  // Cancel the clipboard paste operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeCommentAdd

readonly

"BeforeCommentAdd"

Event fired before comment added

参阅

IBeforeSheetCommentAddEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeCommentAdd, (params) => {
  const { comment, workbook, worksheet, row, col } = params;
  console.log(params);
 
  // Cancel the comment add operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeCommentDelete

readonly

"BeforeCommentDelete"

Event fired before comment delete

参阅

IBeforeSheetCommentDeleteEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeCommentDelete, (params) => {
  const { comment, workbook, worksheet, row, col } = params;
  console.log(params);
 
  // Cancel the comment delete operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeCommentResolve

readonly

"BeforeCommentResolve"

Event fired before comment resolve

参阅

ISheetCommentResolveEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeCommentResolve, (params) => {
  const { comment, row, col, resolved, workbook, worksheet } = params;
  console.log(params);
 
  // Cancel the comment resolve operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeCommentUpdate

readonly

"BeforeCommentUpdate"

Event fired before comment update

参阅

IBeforeSheetCommentUpdateEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeCommentUpdate, (params) => {
  const { comment, workbook, worksheet, row, col, newContent } = params;
  console.log(params);
 
  // Cancel the comment update operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeFloatDomAdd

readonly

"BeforeFloatDomAdd"

Triggered before float dom insertion.

参阅

IBeforeFloatDomAddParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeFloatDomAdd, (params) => {
  console.log(params);
  // do something
  const { workbook, drawings } = params;
  // Cancel the insertion operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeFloatDomDelete

readonly

"BeforeFloatDomDelete"

Triggered before float dom deletion.

参阅

IBeforeFloatDomDeleteParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeFloatDomDelete, (params) => {
  console.log(params);
  // do something
  const { workbook, drawings } = params;
  // Cancel the deletion operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeFloatDomUpdate

readonly

"BeforeFloatDomUpdate"

Triggered before float dom update.

参阅

IBeforeFloatDomUpdateParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeFloatDomUpdate, (params) => {
  console.log(params);
  // do something
  const { workbook, drawings } = params;
  // Cancel the update operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeOverGridImageChange

readonly

"BeforeOverGridImageChange"

Triggered before floating image change.

参阅

IBeforeOverGridImageChangeParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeOverGridImageChange, (params) => {
  console.log(params);
  // do something
  const { workbook, images } = params;
  // Cancel the image change
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeOverGridImageInsert

readonly

"BeforeOverGridImageInsert"

Triggered before floating image insertion.

参阅

IBeforeOverGridImageInsertParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeOverGridImageInsert, (params) => {
  console.log(params);
  // do something
  const { workbook, insertImageParams } = params;
  // Cancel the insertion operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeOverGridImageRemove

readonly

"BeforeOverGridImageRemove"

Triggered before floating image removal.

参阅

IBeforeOverGridImageRemoveParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeOverGridImageRemove, (params) => {
  console.log(params);
  // do something
  const { workbook, images } = params;
  // Cancel the removal operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforeOverGridImageSelect

readonly

"BeforeOverGridImageSelect"

Triggered before floating image selection.

参阅

IBeforeOverGridImageSelectParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeOverGridImageSelect, (params) => {
  console.log(params);
  // do something
  const { workbook, selectedImages, oldSelectedImages } = params;
  // cancel the selection operation
  params.cancel = true;
})
 
// Remove the event listener, use `disposable.dispose()`

BeforePivotTableAdd

readonly

"BeforePivotTableAdd"

The before pivot table add event.The event parameter is IPivotTableAddedEventParams

示例

univerAPI.addEvent(univerAPI.Event.BeforePivotTableAdd, (params) => {
    const { positionType, targetCellInfo } = params;
    if (positionType === univerAPI.Enum.PositionTypeEnum.Existing && targetCellInfo.sheetName === 'Sheet 1') {
        params.cancel = true;
        console.log(`The pivot table can't be added to the sheet ${targetCellInfo.sheetName}`);
    }
});

BeforePivotTableMove

readonly

"BeforePivotTableMove"

The before pivot table moved event.The event parameter is IPivotTableMovedEventParams

示例

univerAPI.addEvent(univerAPI.Event.BeforePivotTableMove, (params) => {
    const { pivotTableId, targetCellInfo } = params;
    if (pivotTableId === 'pivotTable1' && targetCellInfo.sheetName === 'Sheet 1') {
        params.cancel = true;
        console.log(`The pivot table can't be moved to the sheet ${targetCellInfo.sheetName}`);
    }
});

BeforeSheetDataValidationAdd

readonly

"BeforeSheetDataValidationAdd"

Event fired before a rule is added

参阅

IBeforeSheetDataValidationAddEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationAdd, (params) => {
  const { worksheet, workbook, rule } = params;
  console.log(params);
 
  // Cancel the data validation rule addition operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetDataValidationCriteriaUpdate

readonly

"BeforeSheetDataValidationCriteriaUpdate"

Event fired before the criteria of a rule are updated

参阅

IBeforeSheetDataValidationCriteriaUpdateEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationCriteriaUpdate, (params) => {
  const { worksheet, workbook, ruleId, rule, newCriteria } = params;
  console.log(params);
 
  // Cancel the data validation rule criteria update operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetDataValidationDelete

readonly

"BeforeSheetDataValidationDelete"

Event fired before a rule is deleted

参阅

IBeforeSheetDataValidationDeleteEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationDelete, (params) => {
  const { worksheet, workbook, ruleId, rule } = params;
  console.log(params);
 
  // Cancel the data validation rule deletion operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetDataValidationDeleteAll

readonly

"BeforeSheetDataValidationDeleteAll"

Event fired before all rules are deleted

参阅

IBeforeSheetDataValidationDeleteAllEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationDeleteAll, (params) => {
  const { worksheet, workbook, rules } = params;
  console.log(params);
 
  // Cancel the data validation rule deletion operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetDataValidationOptionsUpdate

readonly

"BeforeSheetDataValidationOptionsUpdate"

Event fired before the options of a rule are updated

参阅

IBeforeSheetDataValidationOptionsUpdateEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationOptionsUpdate, (params) => {
  const { worksheet, workbook, ruleId, rule, newOptions } = params;
  console.log(params);
 
  // Cancel the data validation rule options update operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetDataValidationRangeUpdate

readonly

"BeforeSheetDataValidationRangeUpdate"

Event fired before the range of a rule is updated

参阅

IBeforeSheetDataValidationRangeUpdateEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDataValidationRangeUpdate, (params) => {
  const { worksheet, workbook, ruleId, rule, newRanges } = params;
  console.log(params);
 
  // Cancel the data validation rule range update operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetEditEnd

readonly

"BeforeSheetEditEnd"

Event fired before a cell edit ends

参阅

IBeforeSheetEditEndEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetEditEnd, (params) => {
  const { worksheet, workbook, row, column, value, eventType, keycode, isZenEditor, isConfirm } = params;
  console.log(params);
 
  // Cancel the cell edit end operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetEditStart

readonly

"BeforeSheetEditStart"

Event fired before a cell is edited

参阅

IBeforeSheetEditStartEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetEditStart, (params) => {
  const { worksheet, workbook, row, column, eventType, keycode, isZenEditor } = params;
  console.log(params);
 
  // Cancel the cell edit start operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetLinkAdd

readonly

"BeforeSheetLinkAdd"

Event triggered before adding a link

参阅

IBeforeSheetLinkAddEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetLinkAdd, (params) => {
  const { workbook, worksheet, row, col, link } = params;
  console.log('before sheet link add', params);
 
  // Cancel the sheet link add operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetLinkCancel

readonly

"BeforeSheetLinkCancel"

Event triggered before canceling a link

参阅

IBeforeSheetLinkCancelEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetLinkCancel, (params) => {
  const { workbook, worksheet, row, column, id } = params;
  console.log('before sheet link cancel', params);
 
  // Cancel the sheet link cancel operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetLinkUpdate

readonly

"BeforeSheetLinkUpdate"

Event triggered before updating a link

参阅

IBeforeSheetLinkUpdateEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetLinkUpdate, (params) => {
  const { workbook, worksheet, row, column, id, payload } = params;
  console.log('before sheet link update', params);
 
  // Cancel the sheet link update operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetNoteAdd

public

"BeforeSheetNoteAdd"

Event fired before a note is added

参阅

ISheetNoteAddEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetNoteAdd, (params) => {
  const { workbook, worksheet, row, col, note } = params;
  console.log(params);
 
  // Cancel the note addition operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetNoteDelete

public

"BeforeSheetNoteDelete"

Event fired before a note is deleted

参阅

ISheetNoteDeleteEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetNoteDelete, (params) => {
  const { workbook, worksheet, row, col, oldNote } = params;
  console.log(params);
 
  // Cancel the note deletion operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetNoteHide

public

"BeforeSheetNoteHide"

Event fired before a note is hidden

参阅

ISheetNoteHideEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetNoteHide, (params) => {
  const { workbook, worksheet, row, col } = params;
  console.log(params);
 
  // Cancel the note hide operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetNoteShow

public

"BeforeSheetNoteShow"

Event fired before a note is shown

参阅

ISheetNoteShowEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetNoteShow, (params) => {
  const { workbook, worksheet, row, col } = params;
  console.log(params);
 
  // Cancel the note show operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetNoteUpdate

public

"BeforeSheetNoteUpdate"

Event fired before a note is updated

参阅

ISheetNoteUpdateEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetNoteUpdate, (params) => {
  const { workbook, worksheet, row, col, note, oldNote } = params;
  console.log(params);
 
  // Cancel the note update operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

BeforeSheetPrintCanceled

readonly

"BeforeSheetPrintCanceled"

Event triggered before print operation is canceled

参阅

IBeforeSheetPrintCancelEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetPrintCanceled, (params) => {
  const { renderConfig, layoutConfig } = params;
  console.log('params', params);
 
  // Cancel the print cancel operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`.

BeforeSheetPrintConfirm

readonly

"BeforeSheetPrintConfirm"

Event triggered before print settings are confirmed

参阅

IBeforeSheetPrintConfirmEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetPrintConfirm, (params) => {
  const { renderConfig, layoutConfig } = params;
  console.log('params', params);
 
  // Cancel the print confirmation operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`.

BeforeSheetPrintOpen

readonly

"BeforeSheetPrintOpen"

Event triggered before print dialog opens

参阅

IBeforeSheetPrintOpenEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetPrintOpen, (params) => {
  const { workbook, worksheet } = params;
  console.log('params', params);
 
  // Cancel open print configuration dialog operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`.

BeforeSheetZoomChange

readonly

"BeforeSheetZoomChange"

Event fired before zoom changed

参阅

ISheetZoomEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetZoomChange, (params)=> {
  const { worksheet, workbook, zoom } = params;
  console.log(params);
 
  // Cancel the zoom change operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`

CellClicked

readonly

"CellClicked"

Event fired when a cell is clicked

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CellClicked, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CellHover

readonly

"CellHover"

Event fired when a cell is hovered

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CellHover, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CellPointerDown

readonly

"CellPointerDown"

Event fired when a cell is pointer down

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CellPointerDown, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CellPointerMove

readonly

"CellPointerMove"

Event fired when move on spreadsheet cells

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CellPointerMove, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CellPointerUp

readonly

"CellPointerUp"

Event fired when a cell is pointer up

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CellPointerUp, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

ClipboardChanged

readonly

"ClipboardChanged"

Trigger this event after the clipboard content changes. Type of the event parameter is IClipboardChangedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.ClipboardChanged, (params) => {
  const { workbook, worksheet, text, html, fromSheet, fromRange } = params;
  console.log(params);
})
 
// Remove the event listener, use `disposable.dispose()`

ClipboardPasted

readonly

"ClipboardPasted"

Trigger this event after pasting. Type of the event parameter is IClipboardPastedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.ClipboardPasted, (params) => {
  const { workbook, worksheet, text, html } = params;
  console.log(params);
})
 
// Remove the event listener, use `disposable.dispose()`

ColumnHeaderClick

readonly

"ColumnHeaderClick"

Triggered when a column header is clicked

参阅

ISheetColumnHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.ColumnHeaderClick, (params) => {
  const { worksheet, workbook, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

ColumnHeaderHover

readonly

"ColumnHeaderHover"

Triggered when pointer hovers over a column header

参阅

ISheetColumnHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.ColumnHeaderHover, (params) => {
  const { worksheet, workbook, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

ColumnHeaderPointerDown

readonly

"ColumnHeaderPointerDown"

Triggered when pointer is pressed down on a column header

参阅

ISheetColumnHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.ColumnHeaderPointerDown, (params) => {
  const { worksheet, workbook, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

ColumnHeaderPointerUp

readonly

"ColumnHeaderPointerUp"

Triggered when pointer is released on a column header

参阅

ISheetColumnHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.ColumnHeaderPointerUp, (params) => {
  const { worksheet, workbook, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CommentAdded

readonly

"CommentAdded"

Event fired after comment added

参阅

ISheetCommentAddEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CommentAdded, (params) => {
  const { comment, workbook, worksheet, row, col } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CommentDeleted

readonly

"CommentDeleted"

Event fired after comment deleted

参阅

ISheetCommentDeleteEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CommentDeleted, (params) => {
  const { commentId, workbook, worksheet } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CommentResolved

readonly

"CommentResolved"

Event fired after comment resolve

参阅

ISheetCommentResolveEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CommentResolved, (params) => {
  const { comment, row, col, resolved, workbook, worksheet } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CommentUpdated

readonly

"CommentUpdated"

Event fired after comment updated

参阅

ISheetCommentUpdateEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CommentUpdated, (params) => {
  const { comment, workbook, worksheet, row, col } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CrosshairHighlightColorChanged

readonly

"CrosshairHighlightColorChanged"

Triggered when the crosshair highlight color is changed.

参阅

ICrosshairHighlightColorChangedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CrosshairHighlightColorChanged, (params) => {
  const { color, workbook, worksheet } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

CrosshairHighlightEnabledChanged

readonly

"CrosshairHighlightEnabledChanged"

Triggered when the crosshair highlight is enabled or disabled.

参阅

ICrosshairHighlightEnabledChangedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.CrosshairHighlightEnabledChanged, (params) => {
  const { enabled, workbook, worksheet } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

DragOver

readonly

"DragOver"

Event fired when the drag element passes over the spreadsheet cells

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.DragOver, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

Drop

readonly

"Drop"

Event fired when the drag element is dropped on the spreadsheet cells

参阅

ICellEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.Drop, (params) => {
  const { worksheet, workbook, row, column } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

FloatDomAdded

readonly

"FloatDomAdded"

Triggered after float dom insertion.

参阅

IFloatDomAddedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.FloatDomAdded, (params) => {
  console.log(params);
  // do something
  const { workbook, drawings } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

FloatDomDeleted

readonly

"FloatDomDeleted"

Triggered after float dom deletion.

参阅

IFloatDomDeletedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.FloatDomDeleted, (params) => {
  console.log(params);
  // do something
  const { workbook, drawings } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

FloatDomUpdated

readonly

"FloatDomUpdated"

Triggered after float dom update.

参阅

IFloatDomUpdatedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.FloatDomUpdated, (params) => {
  console.log(params);
  // do something
  const { workbook, drawings } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

OverGridImageChanged

readonly

"OverGridImageChanged"

Triggered after floating image change.

参阅

IOverGridImageChangedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.OverGridImageChanged, (params) => {
  console.log(params);
  // do something
  const { workbook, images } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

OverGridImageInserted

readonly

"OverGridImageInserted"

Triggered after floating image insertion.

参阅

IOverGridImageInsertedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.OverGridImageInserted, (params) => {
  console.log(params);
  // do something
  const { workbook, images } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

OverGridImageRemoved

readonly

"OverGridImageRemoved"

Triggered after floating image removal.

参阅

IOverGridImageRemovedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.OverGridImageRemoved, (params) => {
  console.log(params);
  // do something
  const { workbook, removeImageParams } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

OverGridImageSelected

readonly

"OverGridImageSelected"

Triggered after floating image selection.

参阅

IOverGridImageSelectedParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.OverGridImageSelected, (params) => {
  console.log(params);
  // do something
  const { workbook, selectedImages } = params;
})
 
// Remove the event listener, use `disposable.dispose()`

PivotTableAdded

readonly

"PivotTableAdded"

The pivot table added event.The event parameter is IPivotTableAddedEventParams

示例

univerAPI.addEvent(univerAPI.Event.PivotTableAdded, (params) => {
  const { positionType, targetCellInfo } = params;
  if (positionType === univerAPI.Enum.PositionTypeEnum.Existing) {
    console.log('A pivot table created in an existing sheet');
    console.log(`
      The target sheet name is ${targetCellInfo.sheetName},
      the target row is ${targetCellInfo.row}, the target column is ${targetCellInfo.column}
    `);
  } else {
    console.log('A pivot table created in a new sheet');
  }
});

PivotTableFieldAdded

readonly

"PivotTableFieldAdded"

The pivot table field added event. The event parameter is IAddPivotFieldCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldAdded, (params) => {
   const { pivotTableId, fieldId, fieldArea, fieldIndex } = params;
   const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
   const fieldSetting = pivotTable.getFieldSetting('fieldId');
   console.log(fieldSetting);
});

PivotTableFieldCollapseChanged

readonly

"PivotTableFieldCollapseChanged"

The pivot table field collapse changed event. The event parameter is ISetPivotCollapseCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldCollapseChanged, (params) => {
  const { pivotTableId, fieldId, isCollapsed } = params;
  const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
  const fieldSetting = pivotTable.getFieldSetting(fieldId);
  console.log(`The source name ${fieldSetting.sourceName} the display name ${fieldSetting.displayName}`);
});

PivotTableFieldFilterChanged

readonly

"PivotTableFieldFilterChanged"

The pivot table field filter changed event. The event parameter is ISetPivotFilterCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldFilterChanged, (params) => {
    const { pivotTableId, fieldId, filter } = params;
    const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
    const fieldSetting = pivotTable.getFieldSetting(fieldId);
    console.log(`The Checklist filter value is ${fieldSetting.filterInfo.checklist}`);
});

PivotTableFieldMoved

readonly

"PivotTableFieldMoved"

The pivot table field moved event. The event parameter is IMovePivotFieldCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldMoved, (params) => {
  const { pivotTableId, fieldId, fieldArea, fieldIndex } = params;
  const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
  const fieldSetting = pivotTable.getFieldSetting(fieldId);
  console.log(`The source name ${fieldSetting.sourceName} the display name ${fieldSetting.displayName}`);
});

PivotTableFieldRemoved

readonly

"PivotTableFieldRemoved"

The pivot table field removed event. The event parameter is IRemovePivotFieldCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldRemoved, (params) => {
    const { pivotTableId, fieldId } = params;
    const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
    const fieldSetting = pivotTable.getFieldSetting(fieldId);
    console.log(fieldSetting);
});

PivotTableFieldSettingChanged

readonly

"PivotTableFieldSettingChanged"

The pivot table field setting changed event. The event parameter is IUpdatePivotFieldSettingCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldSettingChanged, (params) => {
    const { pivotTableId, fieldId, setting } = params;
    const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
    const fieldSetting = pivotTable.getFieldSetting(fieldId);
    console.log(`The source name ${fieldSetting.sourceName} the display name ${fieldSetting.displayName}`);
});

PivotTableFieldSortChanged

readonly

"PivotTableFieldSortChanged"

The pivot table field sort changed event. The event parameter is ISetPivotSortCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableFieldSortChanged, (params) => {
   const { pivotTableId, fieldId, sort } = params;
   const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
   const fieldSetting = pivotTable.getFieldSetting(fieldId);
   console.log(`The sort info is ${fieldSetting.sortInfo}`);
});

PivotTableMoved

readonly

"PivotTableMoved"

The pivot table moved event. The event parameter is IPivotTableMovedEventParams

示例

univerAPI.addEvent(univerAPI.Event.PivotTableMoved, (params) => {
  const { pivotTableId, targetCellInfo, originTargetInfo } = params;
  if (pivotTableId === 'pivotTable1') {
    console.log(`
      The pivot table moved from row: ${originTargetInfo.row} & column: ${originTargetInfo.column}
      to the sheet ${targetCellInfo.sheetName} row: ${targetCellInfo.row} & column: ${targetCellInfo.column}
    `);
  }
});

PivotTableRemoved

readonly

"PivotTableRemoved"

The pivot table removed event. The event parameter is IPivotTableRemovedEventParams

示例

univerAPI.addEvent(univerAPI.Event.PivotTableRemoved, (params) => {
   const { pivotTableId } = params;
   console.log(`The pivot table ${pivotTableId} has been removed`);
});

PivotTableRendered

readonly

"PivotTableRendered"

The pivot table calculated done and fill the value to worksheet, the event parameter is IPivotTableRenderedEventParams

示例

// import { unionPivotViewRange } from '@univerjs-pro/sheets-pivot';
univerAPI.addEvent(univerAPI.Event.PivotTableRendered, (params) => {
    const { pivotTableId, rangeInfo } = params;
    console.log(`The pivot table ${pivotTableId} has been rendered`);
    if (rangeInfo) {
        console.log(unionPivotViewRange(rangeInfo));
    }
});

PivotTableValuePositionChanged

readonly

"PivotTableValuePositionChanged"

The pivot table value position changed event. The event parameter is IUpdatePivotValuePositionCommandParams

示例

const fWorkbook = univerAPI.getActiveWorkbook();
univerAPI.addEvent(univerAPI.Event.PivotTableValuePositionChanged, (params) => {
    const { pivotTableId, valueId, position } = params;
    const pivotTable = fWorkbook.getPivotTableById(pivotTableId);
    const valueSetting = pivotTable.getValueSetting(valueId);
    console.log(`The source name ${valueSetting.sourceName} the display name ${valueSetting.displayName}`);
});

RowHeaderClick

readonly

"RowHeaderClick"

Triggered when a row header is clicked

参阅

ISheetRowHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.RowHeaderClick, (params) => {
  const { worksheet, workbook, row } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

RowHeaderHover

readonly

"RowHeaderHover"

Triggered when pointer hovers over a row header

参阅

ISheetRowHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.RowHeaderHover, (params) => {
  const { worksheet, workbook, row } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

RowHeaderPointerDown

readonly

"RowHeaderPointerDown"

Triggered when pointer is pressed down on a row header

参阅

ISheetRowHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.RowHeaderPointerDown, (params) => {
  const { worksheet, workbook, row } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

RowHeaderPointerUp

readonly

"RowHeaderPointerUp"

Triggered when pointer is released on a row header

参阅

ISheetRowHeaderEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.RowHeaderPointerUp, (params) => {
  const { worksheet, workbook, row } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

Scroll

readonly

"Scroll"

Event fired when scroll spreadsheet.

参阅

IScrollEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.Scroll, (params) => {
  const { worksheet, workbook, scrollX, scrollY } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SelectionChanged

readonly

"SelectionChanged"

Event fired when selection changed.

参阅

ISelectionEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SelectionChanged, (params)=> {
  const { worksheet, workbook, selections } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SelectionMoveEnd

readonly

"SelectionMoveEnd"

Event fired when selection move end

参阅

ISelectionEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SelectionMoveEnd, (params)=> {
  const { worksheet, workbook, selections } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SelectionMoveStart

readonly

"SelectionMoveStart"

Event fired when selection move start

参阅

ISelectionEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SelectionMoveStart, (params)=> {
  const { worksheet, workbook, selections } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SelectionMoving

readonly

"SelectionMoving"

Event fired when selection move end

参阅

ISelectionEventParam

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SelectionMoving, (params)=> {
  const { worksheet, workbook, selections } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetBeforeRangeFilter

readonly

"SheetBeforeRangeFilter"

This event will be emitted before the filter criteria on a column is changed.

参阅

ISheetRangeFilteredParams

示例

const callbackDisposable = univerAPI.addEvent(univerAPI.Event.SheetBeforeRangeFilter, (params) => {
  console.log(params);
  const { workbook, worksheet, col, criteria } = params;
 
  // your custom logic
 
  // Cancel the filter criteria change operation
  params.cancel = true;
});
 
// Remove the event listener, use `callbackDisposable.dispose()`

SheetBeforeRangeFilterClear

readonly

"SheetBeforeRangeFilterClear"

This event will be emitted after the filter on a worksheet is cleared.

参阅

ISheetRangeFilterClearedEventParams

示例

const callbackDisposable = univerAPI.addEvent(univerAPI.Event.SheetBeforeRangeFilterClear, (params) => {
  console.log(params);
  const { workbook, worksheet } = params;
 
  // your custom logic
 
  // Cancel the filter clear operation
  params.cancel = true;
});
 
// Remove the event listener, use `callbackDisposable.dispose()`

SheetBeforeRangeSort

public

"SheetBeforeRangeSort"

This event will be emitted before sorting a range on a worksheet.

参阅

ISheetRangeSortParams

示例

const callbackDisposable = univerAPI.addEvent(univerAPI.Event.SheetBeforeRangeSort, (params) => {
  console.log(params);
  const { workbook, worksheet, range, sortColumn } = params;
 
  // Cancel the sorting operation.
  params.cancel = true;
});
 
// Remove the event listener, use `callbackDisposable.dispose()`

SheetDataValidationChanged

readonly

"SheetDataValidationChanged"

Event fired when a rule is added, deleted, or modified

参阅

ISheetDataValidationChangedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetDataValidationChanged, (params) => {
  const { origin, worksheet, workbook, changeType, oldRule, rule } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetDataValidatorStatusChanged

readonly

"SheetDataValidatorStatusChanged"

Event fired when a cell validator status is changed

参阅

ISheetDataValidatorStatusChangedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetDataValidatorStatusChanged, (params) => {
  const { worksheet, workbook, row, column, status, rule } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetEditChanging

readonly

"SheetEditChanging"

Event fired when a cell is being edited

参阅

ISheetEditChangingEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetEditChanging, (params) => {
  const { worksheet, workbook, row, column, value, isZenEditor } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetEditEnded

readonly

"SheetEditEnded"

Event fired after a cell edit ends

参阅

ISheetEditEndedEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetEditEnded, (params) => {
  const { worksheet, workbook, row, column, eventType, keycode, isZenEditor, isConfirm } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetEditStarted

readonly

"SheetEditStarted"

Event fired after a cell is edited

参阅

ISheetEditStartedEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetEditStarted, (params) => {
  const { worksheet, workbook, row, column, eventType, keycode, isZenEditor } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetNoteAdd

public

"SheetNoteAdd"

Event fired when a note is added

参阅

ISheetNoteAddEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetNoteAdd, (params) => {
  const { workbook, worksheet, row, col, note } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetNoteDelete

public

"SheetNoteDelete"

Event fired when a note is deleted

参阅

ISheetNoteDeleteEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetNoteDelete, (params) => {
  const { workbook, worksheet, row, col, oldNote } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetNoteHide

public

"SheetNoteHide"

Event fired when a note is hidden

参阅

ISheetNoteHideEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetNoteHide, (params) => {
  const { workbook, worksheet, row, col } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetNoteShow

public

"SheetNoteShow"

Event fired when a note is shown

参阅

ISheetNoteShowEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetNoteShow, (params) => {
  const { workbook, worksheet, row, col } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetNoteUpdate

public

"SheetNoteUpdate"

Event fired when a note is updated

参阅

ISheetNoteUpdateEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetNoteUpdate, (params) => {
  const { workbook, worksheet, row, col, note, oldNote } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetPrintCanceled

readonly

"SheetPrintCanceled"

Event triggered when print operation is canceled

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetPrintCanceled, (params) => {
  const { renderConfig, layoutConfig } = params;
  console.log('params', params);
});
 
// Remove the event listener, use `disposable.dispose()`.

SheetPrintConfirmed

readonly

"SheetPrintConfirmed"

Event triggered when print settings are confirmed

参阅

ISheetPrintConfirmedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetPrintConfirmed, (params) => {
  const { renderConfig, layoutConfig } = params;
  console.log('params', params);
});
 
// Remove the event listener, use `disposable.dispose()`.

SheetPrintOpen

readonly

"SheetPrintOpen"

Event triggered when print dialog opens

参阅

ISheetPrintOpenEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetPrintOpen, (params) => {
  const { workbook, worksheet } = params;
  console.log('params', params);
});
 
// Remove the event listener, use `disposable.dispose()`.

SheetRangeFilterCleared

readonly

"SheetRangeFilterCleared"

This event will be emitted when the filter on a worksheet is cleared.

参阅

ISheetRangeFilterClearedEventParams

示例

const callbackDisposable = univerAPI.addEvent(univerAPI.Event.SheetRangeFilterCleared, (params) => {
  console.log(params);
  const { workbook, worksheet } = params;
 
  // your custom logic
});
 
// Remove the event listener, use `callbackDisposable.dispose()`

SheetRangeFiltered

readonly

"SheetRangeFiltered"

This event will be emitted when the filter criteria on a column is changed.

参阅

ISheetRangeFilteredParams

示例

const callbackDisposable = univerAPI.addEvent(univerAPI.Event.SheetRangeFiltered, (params) => {
  console.log(params);
  const { workbook, worksheet, col, criteria } = params;
 
  // your custom logic
});
 
// Remove the event listener, use `callbackDisposable.dispose()`

SheetRangeSorted

public

"SheetRangeSorted"

This event will be emitted when a range on a worksheet is sorted.

参阅

ISheetRangeSortParams

示例

const callbackDisposable = univerAPI.addEvent(univerAPI.Event.SheetRangeSorted, (params) => {
  console.log(params);
  const { workbook, worksheet, range, sortColumn } = params;
});
 
// Remove the event listener, use `callbackDisposable.dispose()`

SheetSkeletonChanged

readonly

"SheetSkeletonChanged"

Event fired when sheet skeleton changed

参阅

ISheetSkeletonChangedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetSkeletonChanged, (params)=> {
  const { worksheet, workbook, skeleton, payload, effectedRanges } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetSparklineChanged

readonly

"SheetSparklineChanged"

Trigger this event after the sparkline changes. Type of the event parameter is IFSheetSparklineChangedEventParams

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetSparklineChanged, (params) => {
  console.log('SheetSparklineChanged', params);
  const { workbook, worksheet, sparklines } = params;
});
 
// Remove the event listener, use `disposable.dispose()`.

SheetValueChanged

readonly

"SheetValueChanged"

Event fired when sheet value changed

参阅

ISheetValueChangedEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetValueChanged, (params)=> {
  const { effectedRanges, payload } = params;
  console.log('sheet value changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`

SheetZoomChanged

readonly

"SheetZoomChanged"

Event fired when zoom changed

参阅

ISheetZoomEvent

示例

const disposable = univerAPI.addEvent(univerAPI.Event.SheetZoomChanged, (params)=> {
  const { worksheet, workbook, zoom } = params;
  console.log(params);
});
 
// Remove the event listener, use `disposable.dispose()`

访问器

ActiveSheetChanged

Getter 签名

get ActiveSheetChanged(): "ActiveSheetChanged";

Event fired after the active sheet changes

参阅

IActiveSheetChangedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.ActiveSheetChanged, (params) => {
  const { workbook, activeSheet } = params;
  console.log('after active sheet changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"ActiveSheetChanged"

BeforeActiveSheetChange

Getter 签名

get BeforeActiveSheetChange(): "BeforeActiveSheetChange";

Event fired before the active sheet changes

参阅

IBeforeActiveSheetChangeEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeActiveSheetChange, (params) => {
  const { workbook, activeSheet, oldActiveSheet } = params;
  console.log('before active sheet change', params);
 
  // Cancel the active sheet change operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeActiveSheetChange"

BeforeCommandExecute

Getter 签名

get BeforeCommandExecute(): "BeforeCommandExecute";

Event fired before a command is executed

参阅

ICommandEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeCommandExecute, (event) => {
  const { params, id, type, options } = event;
  console.log('before command executed', event);
 
  // Cancel the command execution
  event.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeCommandExecute"

BeforeGridlineColorChange

Getter 签名

get BeforeGridlineColorChange(): "BeforeGridlineColorChange";

Event fired before gridline color changed

参阅

IBeforeGridlineColorChanged

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeGridlineColorChange, (params) => {
  const { workbook, worksheet, color } = params;
  console.log('before gridline color change', params);
 
  // Cancel the gridline color change operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeGridlineColorChange"

BeforeGridlineEnableChange

Getter 签名

get BeforeGridlineEnableChange(): "BeforeGridlineEnableChange";

Event fired before gridline enable changed

参阅

IBeforeGridlineEnableChange

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeGridlineEnableChange, (params) => {
  const { workbook, worksheet, enabled } = params;
  console.log('before gridline enable change', params);
 
  // Cancel the gridline enable change operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeGridlineEnableChange"

BeforeRedo

Getter 签名

get BeforeRedo(): "BeforeRedo";

Event fired before a redo command is executed

参阅

ICommandEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeRedo, (event) => {
  const { params, id, type } = event;
  console.log('before redo command executed', event);
 
  // Cancel the redo operation
  event.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeRedo"

BeforeSheetCreate

Getter 签名

get BeforeSheetCreate(): "BeforeSheetCreate";

Event fired before a sheet is created

参阅

IBeforeSheetCreateEventParams

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetCreate, (params) => {
  const { workbook, index, sheet } = params;
  console.log('before sheet create', params);
 
  // Cancel the sheet creation operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeSheetCreate"

BeforeSheetDelete

Getter 签名

get BeforeSheetDelete(): "BeforeSheetDelete";

Event fired before a sheet is deleted

参阅

IBeforeSheetDeleteEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetDelete, (params) => {
  const { workbook, worksheet } = params;
  console.log('before sheet delete', params);
 
  // Cancel the sheet deletion operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeSheetDelete"

BeforeSheetHideChange

Getter 签名

get BeforeSheetHideChange(): "BeforeSheetHideChange";

Event fired before a sheet is hidden

参阅

IBeforeSheetHideChangeEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetHideChange, (params) => {
  const { workbook, worksheet, hidden } = params;
  console.log('before sheet hide change', params);
 
  // Cancel the sheet hide operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeSheetHideChange"

BeforeSheetMove

Getter 签名

get BeforeSheetMove(): "BeforeSheetMove";

Event fired before a sheet is moved

参阅

IBeforeSheetMoveEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetMove, (params) => {
  const { workbook, worksheet, newIndex, oldIndex } = params;
  console.log('before sheet move', params);
 
  // Cancel the sheet move operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeSheetMove"

BeforeSheetNameChange

Getter 签名

get BeforeSheetNameChange(): "BeforeSheetNameChange";

Event fired before a sheet name is changed

参阅

IBeforeSheetNameChangeEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetNameChange, (params) => {
  const { workbook, worksheet, newName, oldName } = params;
  console.log('before sheet name change', params);
 
  // Cancel the sheet name change operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeSheetNameChange"

BeforeSheetTabColorChange

Getter 签名

get BeforeSheetTabColorChange(): "BeforeSheetTabColorChange";

Event fired before a sheet tab color is changed

参阅

IBeforeSheetTabColorChangeEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeSheetTabColorChange, (params) => {
  const { workbook, worksheet, newColor, oldColor } = params;
  console.log('before sheet tab color change', params);
 
  // Cancel the sheet tab color change operation
  params.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeSheetTabColorChange"

BeforeUndo

Getter 签名

get BeforeUndo(): "BeforeUndo";

Event fired before an undo command is executed

参阅

ICommandEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.BeforeUndo, (event) => {
  const { params, id, type } = event;
  console.log('before undo command executed', event);
 
  // Cancel the undo operation
  event.cancel = true;
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"BeforeUndo"

CommandExecuted

Getter 签名

get CommandExecuted(): "CommandExecuted";

Event fired when a command is executed

参阅

ICommandEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.CommandExecuted, (event) => {
  const { params, id, type, options } = event;
  console.log('command executed', event);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"CommandExecuted"

DocCreated

Getter 签名

get DocCreated(): "DocCreated";

Event fired when a document is created

参阅

IDocCreatedParam

示例
const disposable = univerAPI.addEvent(univerAPI.Event.DocCreated, (params) => {
  const { unitId, type, doc, unit } = params;
  console.log('doc created', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"DocCreated"

DocDisposed

Getter 签名

get DocDisposed(): "DocDisposed";

Event fired when a document is disposed

参阅

IDocDisposedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.DocDisposed, (params) => {
  const { unitId, unitType, snapshot } = params;
  console.log('doc disposed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"DocDisposed"

GridlineChanged

Getter 签名

get GridlineChanged(): "GridlineChanged";

Event fired when gridline changed

参阅

IGridlineChangedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.GridlineChanged, (params) => {
  const { workbook, worksheet, enabled, color } = params;
  console.log('gridline changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"GridlineChanged"

LifeCycleChanged

Getter 签名

get LifeCycleChanged(): "LifeCycleChanged";

Event fired when life cycle is changed

参阅

ILifeCycleChangedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.LifeCycleChanged, (params) => {
  const { stage } = params;
  console.log('life cycle changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"LifeCycleChanged"

Redo

Getter 签名

get Redo(): "Redo";

Event fired when a redo command is executed

参阅

ICommandEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.Redo, (event) => {
  const { params, id, type } = event;
  console.log('redo command executed', event);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"Redo"

SheetCreated

Getter 签名

get SheetCreated(): "SheetCreated";

Event fired after a sheet is created

参阅

ISheetCreatedEventParams

示例
const disposable = univerAPI.addEvent(univerAPI.Event.SheetCreated, (params) => {
  const { workbook, worksheet } = params;
  console.log('sheet created', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"SheetCreated"

SheetDeleted

Getter 签名

get SheetDeleted(): "SheetDeleted";

Event fired after a sheet is deleted

参阅

ISheetDeletedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.SheetDeleted, (params) => {
  const { workbook, sheetId } = params;
  console.log('sheet deleted', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"SheetDeleted"

SheetHideChanged

Getter 签名

get SheetHideChanged(): "SheetHideChanged";

Event fired after a sheet is hidden

参阅

ISheetHideChangedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.SheetHideChanged, (params) => {
  const { workbook, worksheet, hidden } = params;
  console.log('sheet hide changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"SheetHideChanged"

SheetMoved

Getter 签名

get SheetMoved(): "SheetMoved";

Event fired after a sheet is moved

参阅

ISheetMovedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.SheetMoved, (params) => {
  const { workbook, worksheet, newIndex } = params;
  console.log('sheet moved', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"SheetMoved"

SheetNameChanged

Getter 签名

get SheetNameChanged(): "SheetNameChanged";

Event fired after a sheet name is changed

参阅

ISheetNameChangedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.SheetNameChanged, (params) => {
  const { workbook, worksheet, newName } = params;
  console.log('sheet name changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"SheetNameChanged"

SheetTabColorChanged

Getter 签名

get SheetTabColorChanged(): "SheetTabColorChanged";

Event fired after a sheet tab color is changed

参阅

ISheetTabColorChangedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.SheetTabColorChanged, (params) => {
  const { workbook, worksheet, newColor } = params;
  console.log('sheet tab color changed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"SheetTabColorChanged"

Undo

Getter 签名

get Undo(): "Undo";

Event fired when an undo command is executed

参阅

ICommandEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.Undo, (event) => {
  const { params, id, type } = event;
  console.log('undo command executed', event);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"Undo"

WorkbookCreated

Getter 签名

get WorkbookCreated(): "WorkbookCreated";

Event fired after a workbook is created

参阅

IWorkbookCreateParam

示例
const disposable = univerAPI.addEvent(univerAPI.Event.WorkbookCreated, (params) => {
  const { unitId, type, workbook, unit } = params;
  console.log('workbook created', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"WorkbookCreated"

WorkbookDisposed

Getter 签名

get WorkbookDisposed(): "WorkbookDisposed";

Event fired after a workbook is disposed

参阅

IWorkbookDisposedEvent

示例
const disposable = univerAPI.addEvent(univerAPI.Event.WorkbookDisposed, (params) => {
  const { unitId, unitType, snapshot } = params;
  console.log('workbook disposed', params);
});
 
// Remove the event listener, use `disposable.dispose()`
返回

"WorkbookDisposed"

方法

get()

static get(): FEventName;

返回

FEventName

FEnumFEventRegistry