Skip to Content
ClassesFEventName

类: FEventName

继承

  • IFSheetEventMixin.IFSheetLinkEvent.IFSheetFilterEventMixin.IFSheetSortEventMixin.IDataValidationEvent.ICommentEventMixin.IPivotTableEventMixin.IFSheetSparklineEventMixin.IFSheetsUIEventNameMixin.IFDrawingEventNameMixin.IFSheetCrosshairHighlightEventMixin.IFSheetPrintEventName

属性

属性修饰符类型描述

BeforeClipboardChange

readonly

"BeforeClipboardChange"

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

示例

univerAPI.addEvent(univerAPI.Event.BeforeClipboardChange, (param) => { const {text, html} = param; console.log('debugger', text, html); // {text: '...', html: '...'} // if want to cancel the clipboard change param.cancel = true; })

BeforeClipboardPaste

readonly

"BeforeClipboardPaste"

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

示例

univerAPI.addEvent(univerAPI.Event.BeforeClipboardPaste, (param) => { const {text, html} = param; console.log('debugger', text, html); // if want to cancel the clipboard paste param.cancel = true; })

BeforeCommentAdd

readonly

"BeforeCommentAdd"

Event fired before comment added

参阅

IBeforeSheetCommentAddEvent

示例

univerAPI.addEventListener(CommentEvent.BeforeCommentAdd, (event) => { const { comment, workbook, worksheet, row, col } = event; console.log(event); });

BeforeCommentDeleted

readonly

"BeforeCommentDeleted"

Event fired before comment delete

参阅

IBeforeSheetCommentDeleteEvent

示例

univerAPI.addEventListener(CommentEvent.BeforeCommentDeleted, (event) => { const { commentId, workbook, worksheet } = event; console.log(event); });

BeforeCommentResolve

readonly

"BeforeCommentResolve"

Event fired before comment resolve

参阅

ISheetCommentResolveEvent

示例

univerAPI.addEventListener(CommentEvent.BeforeCommentResolve, (event) => { const { comment, row, col, resolved, workbook, worksheet } = event; console.log(event); });

BeforeCommentUpdate

readonly

"BeforeCommentUpdate"

Event fired before comment update

参阅

IBeforeSheetCommentUpdateEvent

示例

univerAPI.addEventListener(CommentEvent.BeforeCommentUpdate, (event) => { const { comment, workbook, worksheet, row, col, newContent } = event; console.log(event); });

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, (event) => { const { worksheet, workbook, rule } = event; console.log(event); // Cancel the data validation rule addition operation event.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, (event) => { const { worksheet, workbook, ruleId, rule, newCriteria } = event; console.log(event); // Cancel the data validation rule criteria update operation event.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, (event) => { const { worksheet, workbook, ruleId, rule } = event; console.log(event); // Cancel the data validation rule deletion operation event.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, (event) => { const { worksheet, workbook, rules } = event; console.log(event); // Cancel the data validation rule deletion operation event.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, (event) => { const { worksheet, workbook, ruleId, rule, newOptions } = event; console.log(event); // Cancel the data validation rule options update operation event.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, (event) => { const { worksheet, workbook, ruleId, rule, newRanges } = event; console.log(event); // Cancel the data validation rule range update operation event.cancel = true; }); // Remove the event listener, use `disposable.dispose()`

BeforeSheetEditEnd

readonly

"BeforeSheetEditEnd"

Event fired before a cell edit ends

参阅

IBeforeSheetEditEndEventParams

示例

univerAPI.addEvent(univerAPI.Event.BeforeSheetEditEnd, (params) => { const { worksheet, workbook, row, column, value, eventType, keycode, isZenEditor } = params; });

BeforeSheetEditStart

readonly

"BeforeSheetEditStart"

Event fired before a cell is edited

参阅

IBeforeSheetEditStartEventParams

示例

univerAPI.addEvent(univerAPI.Event.BeforeSheetEditStart, (params) => { const { worksheet, workbook, row, column, eventType, keycode, isZenEditor } = params; });

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()`

BeforeSheetPrintCanceled

readonly

"BeforeSheetPrintCanceled"

Event triggered before print operation is canceled

示例

univerAPI.addEvent(univerAPI.event.BeforeSheetPrintCanceled, (params) => { const { renderConfig, layoutConfig } = params; console.log('params', params); });

BeforeSheetPrintConfirm

readonly

"BeforeSheetPrintConfirm"

Event triggered before print settings are confirmed

示例

univerAPI.addEvent(univerAPI.event.BeforeSheetPrintConfirm, (params) => { const { renderConfig, layoutConfig } = params; console.log('params', params); });

BeforeSheetPrintOpen

readonly

"BeforeSheetPrintOpen"

Event triggered before print dialog opens

示例

univerAPI.addEvent(univerAPI.event.BeforeSheetPrintOpen, (params) => { const { workbook, worksheet } = params; console.log('params', params); });

BeforeSheetZoomChange

readonly

"BeforeSheetZoomChange"

Event fired before zoom changed

参阅

ISheetZoomEvent

示例

univerAPI.addEvent(univerAPI.Event.BeforeSheetZoomChange, (p)=> { const { worksheet, workbook, zoom } = p; });

CellClicked

readonly

"CellClicked"

Event fired when a cell is clicked

参阅

ICellEventParam

示例

univerAPI.addEvent(univerAPI.Event.CellClicked, (params) => { const { worksheet, workbook, row, column, value, isZenEditor } = params; });

CellHover

readonly

"CellHover"

Event fired when a cell is hovered

参阅

ICellEventParam

示例

univerAPI.addEvent(univerAPI.Event.CellHover, (params) => { const { worksheet, workbook, row, column } = params; });

CellPointerDown

readonly

"CellPointerDown"

Event fired when a cell is pointer down

参阅

ICellEventParam

示例

univerAPI.addEvent(univerAPI.Event.CellPointerDown, (params) => { const { worksheet, workbook, row, column } = params; });

CellPointerMove

readonly

"CellPointerMove"

Event fired when move on spreadsheet cells

参阅

ICellEventParam

示例

univerAPI.addEvent(univerAPI.Event.CellPointerMove, (params) => { const { worksheet, workbook, row, column } = params; });

CellPointerUp

readonly

"CellPointerUp"

Event fired when a cell is pointer up

参阅

ICellEventParam

示例

univerAPI.addEvent(univerAPI.Event.CellPointerUp, (params) => { const { worksheet, workbook, row, column } = params; });

ClipboardChanged

readonly

"ClipboardChanged"

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

示例

univerAPI.addEvent(univerAPI.Event.ClipboardChanged, (param) => { const {text, html} = param; console.log('debugger', text, html); // {text: '...', html: '...'} })

ClipboardPasted

readonly

"ClipboardPasted"

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

示例

univerAPI.addEvent(univerAPI.Event.ClipboardPasted, (param) => { const {text, html} = param; console.log('debugger', text, html); // {text: '...', html: '...'} })

ColumnHeaderClick

readonly

"ColumnHeaderClick"

Triggered when a column header is clicked

参数

Event parameters containing unitId, subUnitId, and column index

示例

univerAPI.onSheetEvent(Event.ColumnHeaderClick, (params) => { console.log(`Column ${params.column} header clicked in sheet ${params.worksheet.getSheetId()}`); });

ColumnHeaderHover

readonly

"ColumnHeaderHover"

Triggered when pointer hovers over a column header

参数

Event parameters containing unitId, subUnitId, and column index

示例

univerAPI.onSheetEvent(Event.ColumnHeaderHover, (params) => { console.log(`Hovering over column ${params.column} header in sheet ${params.worksheet.getSheetId()}`); });

ColumnHeaderPointerDown

readonly

"ColumnHeaderPointerDown"

Triggered when pointer is pressed down on a column header

参数

Event parameters containing unitId, subUnitId, and column index

示例

univerAPI.onSheetEvent(Event.ColumnHeaderPointerDown, (params) => { console.log(`Pointer down on column ${params.column} header in sheet ${params.worksheet.getSheetId()}`); });

ColumnHeaderPointerUp

readonly

"ColumnHeaderPointerUp"

Triggered when pointer is released on a column header

参数

Event parameters containing unitId, subUnitId, and column index

示例

univerAPI.onSheetEvent(Event.ColumnHeaderPointerUp, (params) => { console.log(`Pointer up on column ${params.column} header in sheet ${params.worksheet.getSheetId()}`); });

CommentAdded

readonly

"CommentAdded"

Event fired after comment added

参阅

ISheetCommentAddEvent

示例

univerAPI.addEventListener(CommentEvent.CommentAdded, (event) => { const { comment, workbook, worksheet, row, col } = event; console.log(event); });

CommentDeleted

readonly

"CommentDeleted"

Event fired after comment deleted

参阅

ISheetCommentDeleteEvent

示例

univerAPI.addEventListener(CommentEvent.CommentDeleted, (event) => { const { commentId, workbook, worksheet } = event; console.log(event); });

CommentResolved

readonly

"CommentResolved"

Event fired after comment resolve

参阅

ISheetCommentResolveEvent

示例

univerAPI.addEventListener(CommentEvent.CommentResolved, (event) => { const { comment, row, col, resolved, workbook, worksheet } = event; console.log(event); });

CommentUpdated

readonly

"CommentUpdated"

Event fired after comment updated

参阅

ISheetCommentUpdateEvent

示例

univerAPI.addEventListener(CommentEvent.CommentUpdated, (event) => { const { comment, workbook, worksheet, row, col } = event; console.log(event); });

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 drag over spreadsheet cells

参阅

ICellEventParam

示例

univerAPI.getActiveWorkbook().addEvent(univerAPI.Event.DragOver, (params) => { const { worksheet, workbook, row, column } = params; });

Drop

readonly

"Drop"

Event fired when drop on spreadsheet cells

参阅

ICellEventParam

示例

univerAPI.getActiveWorkbook().addEvent(univerAPI.Event.Drop, (params) => { const { worksheet, workbook, row, column } = params; });

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`); }); </td> </tr> <tr> <td> <a id="pivottablerendered"></a> `PivotTableRendered` </td> <td> `readonly` </td> <td> `"PivotTableRendered"` </td> <td> The pivot table calculated done and fill the value to worksheet, the event parameter is IPivotTableRenderedEventParams **示例** ```typescript // 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

参数

Event parameters containing unitId, subUnitId, and row index

示例

univerAPI.onSheetEvent(Event.RowHeaderClick, (params) => { console.log(`Row ${params.row} header clicked in sheet ${params.worksheet.getSheetId()}`); });

RowHeaderHover

readonly

"RowHeaderHover"

Triggered when pointer hovers over a row header

参数

Event parameters containing unitId, subUnitId, and row index

示例

univerAPI.onSheetEvent(Event.RowHeaderHover, (params) => { console.log(`Hovering over row ${params.row} header in sheet ${params.worksheet.getSheetId()}`); });

RowHeaderPointerDown

readonly

"RowHeaderPointerDown"

Triggered when pointer is pressed down on a row header

参数

Event parameters containing unitId, subUnitId, and row index

示例

univerAPI.onSheetEvent(Event.RowHeaderPointerDown, (params) => { console.log(`Pointer down on row ${params.row} header in sheet ${params.worksheet.getSheetId()}`); });

RowHeaderPointerUp

readonly

"RowHeaderPointerUp"

Triggered when pointer is released on a row header

参数

Event parameters containing unitId, subUnitId, and row index

示例

univerAPI.onSheetEvent(Event.RowHeaderPointerUp, (params) => { console.log(`Pointer up on row ${params.row} header in sheet ${params.worksheet.getSheetId()}`); });

Scroll

readonly

"Scroll"

Event fired when scroll spreadsheet.

参阅

IScrollEventParam

示例

univerAPI.addEvent(univerAPI.Event.Scroll, (params) => { const { worksheet, workbook, scrollX, scrollY } = params; });

SelectionChanged

readonly

"SelectionChanged"

Event fired when selection changed.

参阅

ISelectionEventParam

示例

univerAPI.addEvent(univerAPI.Event.SelectionChanged, (p)=> { const { worksheet, workbook, selections } = p; });

SelectionMoveEnd

readonly

"SelectionMoveEnd"

Event fired when selection move end

参阅

ISelectionEventParam

示例

univerAPI.addEvent(univerAPI.Event.SelectionMoveEnd, (p)=> { const { worksheet, workbook, selections } = p; });

SelectionMoveStart

readonly

"SelectionMoveStart"

Event fired when selection move start

参阅

ISelectionEventParam

示例

univerAPI.addEvent(univerAPI.Event.SelectionMoveStart, (p)=> { const { worksheet, workbook, selections } = p; });

SelectionMoving

readonly

"SelectionMoving"

Event fired when selection move end

参阅

ISelectionEventParam

示例

univerAPI.addEvent(univerAPI.Event.SelectionMoving, (p)=> { const { worksheet, workbook, selections } = p; });

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, (event) => { const { origin, worksheet, workbook, changeType, oldRule, rule } = event; console.log(event); }); // 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, (event) => { const { worksheet, workbook, row, column, status, rule } = event; console.log(event); }); // Remove the event listener, use `disposable.dispose()`

SheetEditChanging

readonly

"SheetEditChanging"

Event fired when a cell is being edited

参阅

ISheetEditChangingEventParams

示例

univerAPI.addEvent(univerAPI.Event.SheetEditChanging, (params) => { const { worksheet, workbook, row, column, value, isZenEditor } = params; });

SheetEditEnded

readonly

"SheetEditEnded"

Event fired after a cell edit ends

参阅

ISheetEditEndedEventParams

示例

univerAPI.addEvent(univerAPI.Event.SheetEditEnded, (params) => { const { worksheet, workbook, row, column, eventType, keycode, isZenEditor } = params; });

SheetEditStarted

readonly

"SheetEditStarted"

Event fired after a cell is edited

参阅

ISheetEditEndedEventParams

示例

univerAPI.addEvent(univerAPI.Event.SheetEditStarted, (params) => { const { worksheet, workbook, row, column, eventType, keycode, isZenEditor } = params; });

SheetPrintCanceled

readonly

"SheetPrintCanceled"

Event triggered when print operation is canceled

示例

univerAPI.addEvent(univerAPI.event.SheetPrintCanceled, (params) => { const { renderConfig, layoutConfig } = params; console.log('params', params); });

SheetPrintConfirmed

readonly

"SheetPrintConfirmed"

Event triggered when print settings are confirmed

示例

univerAPI.addEvent(univerAPI.event.SheetPrintConfirmed, (params) => { const { renderConfig, layoutConfig } = params; console.log('params', params); });

SheetPrintOpen

readonly

"SheetPrintOpen"

Event triggered when print dialog opens

示例

univerAPI.addEvent(univerAPI.event.SheetPrintOpen, (params) => { const { workbook, worksheet } = params; console.log('params', params); });

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

示例

univerAPI.addEvent(univerAPI.Event.SheetSkeletonChanged, (p)=> { const { worksheet, workbook } = p; });

SheetSparklineChanged

readonly

"SheetSparklineChanged"

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

示例

univerAPI.addEvent(univerAPI.Event.SheetSparklineChanged, (params) => { console.log('SheetSparklineChanged', params); })

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

示例

univerAPI.addEvent(univerAPI.Event.SheetZoomChanged, (p)=> { const { worksheet, workbook, zoom } = p; });

访问器

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 } = 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 } = 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