Skip to Content
Globals

@univerjs-site/api

Enumerations

AbsoluteRefType

none: A1 row: A$1 column: $A1 all: $A$1

Enumeration Members

Enumeration MemberValue
ALL3
COLUMN2
NONE0
ROW1

AlignTypeH

Enumeration Members

Enumeration MemberValue
BOTH5
CENTER0
DISTRIBUTE6
INSIDE1
LEFT2
OUTSIDE3
RIGHT4

AlignTypeV

Enumeration Members

Enumeration MemberValue
BOTTOM0
CENTER1
INSIDE2
OUTSIDE3
TOP4

BaselineOffset

Enumeration Members

Enumeration MemberValue
NORMAL1
SUBSCRIPT2
SUPERSCRIPT3

BlockType

Type of block

Enumeration Members

Enumeration MemberValue
CUSTOM1
DRAWING0

BooleanNumber

General Boolean Enum

Enumeration Members

Enumeration MemberValue
FALSE0
TRUE1

BorderStyleTypes

Border style types enum

Enumeration Members

Enumeration MemberValue
DASH_DOT5
DASH_DOT_DOT6
DASHED4
DOTTED3
DOUBLE7
HAIR2
MEDIUM8
MEDIUM_DASH_DOT10
MEDIUM_DASH_DOT_DOT11
MEDIUM_DASHED9
NONE0
SLANT_DASH_DOT12
THICK13
THIN1

BulletAlignment

The types of alignment for a bullet.

Enumeration Members

Enumeration MemberValue
BOTH4
BULLET_ALIGNMENT_UNSPECIFIED0
CENTER2
END3
START1

CellValueType

General Boolean Enum

Enumeration Members

Enumeration MemberValue
BOOLEAN3
FORCE_STRING4
NUMBER2
STRING1

characterSpacingControlType

Enumeration Members

Enumeration MemberValue
compressPunctuation0
compressPunctuationAndJapaneseKana1
doNotCompress2

ColumnSeparatorType

The style of column separators between columns.

Enumeration Members

Enumeration MemberValue
BETWEEN_EACH_COLUMN2
COLUMN_SEPARATOR_STYLE_UNSPECIFIED0
NONE1

CustomDecorationType

Enumeration Members

Enumeration MemberValue
COMMENT0
DELETED9999

CustomRangeType

Enumeration Members

Enumeration MemberValue
BOOKMARK3
COMMENT4
CUSTOM5
DELTED9999
FIELD1
HYPERLINK0
MENTION6
SDT2
UNI_FORMULA7

DashStyleType

The kinds of dashes with which linear geometry can be rendered.

Enumeration Members

Enumeration MemberValue
DASH3
DASH_STYLE_UNSPECIFIED0
DOT2
SOLID1

DocumentFlavor

Enumeration Members

Enumeration MemberValue
MODERN2
TRADITIONAL1
UNSPECIFIED0

DrawingTypeEnum

Types of drawings, used to distinguish between images, shapes, charts, tables, SmartArt, videos, DrawingGroup, Unit, Dom, etc.

Enumeration Members

Enumeration MemberValueDescription
DRAWING_CHART2Chart
DRAWING_DOM8Dom element, allows inserting HTML elements as floating objects into the document
DRAWING_GROUP6Drawing group
DRAWING_IMAGE0Image
DRAWING_SHAPE1Shape, similar to shapes in Office, including circles, rectangles, lines, etc.
DRAWING_SMART_ART4SmartArt, similar to SmartArt in Office
DRAWING_TABLE3Table
DRAWING_UNIT7Univer object, allows inserting images, tables, documents, slides as floating objects into the document
DRAWING_VIDEO5Video
UNRECOGNIZED-1Unrecognized drawing type, requires user to determine

GridType

Enumeration Members

Enumeration MemberValue
DEFAULT0
LINES1
LINES_AND_CHARS2
SNAP_TO_CHARS3

HorizontalAlign

An enum that specifies the horizontal alignment of text.

Enumeration Members

Enumeration MemberValue
BOTH5
CENTER2
DISTRIBUTED6
JUSTIFIED4
LEFT1
RIGHT3
UNSPECIFIED0

ListGlyphType

An enumeration of the supported glyph types.

Enumeration Members

Enumeration MemberValueDescription
AIUEO15-
AIUEO_FULL_WIDTH23-
ARABIC_ABJAD52-
ARABIC_ALPHA51-
BULLET0-
CARDINAL_TEXT9-
CHICAGO12-
CHINESE_COUNTING38-
CHINESE_COUNTING_THOUSAND40-
CHINESE_LEGAL_SIMPLIFIED39-
CHOSUNG26-
CUSTOM60-
DECIMAL2-
DECIMAL_ENCLOSED_CIRCLE21-
DECIMAL_ENCLOSED_CIRCLE_CHINESE29-
DECIMAL_ENCLOSED_FULLSTOP27-
DECIMAL_ENCLOSED_PAREN28-
DECIMAL_FULL_WIDTH17-
DECIMAL_FULL_WIDTH222-
DECIMAL_HALF_WIDTH18-
DECIMAL_ZERO3-
GANADA25-
HEBREW149-
HEBREW250-
HEX11-
HINDI_CONSONANTS54-
HINDI_COUNTING56-
HINDI_NUMBERS55-
HINDI_VOWELS53-
IDEOGRAPH_DIGITAL13-
IDEOGRAPH_ENCLOSED_CIRCLE30-
IDEOGRAPH_LEGAL_TRADITIONAL35-
IDEOGRAPH_TRADITIONAL31-
IDEOGRAPH_ZODIAC32-
IDEOGRAPH_ZODIAC_TRADITIONAL33-
IROHA16-
IROHA_FULL_WIDTH24-
JAPANESE_COUNTING14-
JAPANESE_DIGITAL_TEN_THOUSAND20-
JAPANESE_LEGAL19-
KOREAN_COUNTING42-
KOREAN_DIGITAL41-
KOREAN_DIGITAL244-
KOREAN_LEGAL43-
LOWER_LETTER5-
LOWER_ROMAN7-
NONE1-
NUMBER_IN_DASH48-
ORDINAL8Not yet achieved, aligned with Excel’s standards. 17.18.59 ST_NumberFormat (Numbering Format)
ORDINAL_TEXT10-
RUSSIAN_LOWER46-
RUSSIAN_UPPER47-
TAIWANESE_COUNTING34-
TAIWANESE_COUNTING_THOUSAND36-
TAIWANESE_DIGITAL37-
THAI_COUNTING59-
THAI_LETTERS57-
THAI_NUMBERS58-
UPPER_LETTER4-
UPPER_ROMAN6-
VIETNAMESE_COUNTING45-

LocaleType

Built-in locales.

Enumeration Members

Enumeration MemberValue
EN_US"enUS"
FA_IR"faIR"
FR_FR"frFR"
RU_RU"ruRU"
VI_VN"viVN"
ZH_CN"zhCN"
ZH_TW"zhTW"

NamedStyleType

Types of name style

Enumeration Members

Enumeration MemberValue
HEADING_14
HEADING_25
HEADING_36
HEADING_47
HEADING_58
HEADING_69
NAMED_STYLE_TYPE_UNSPECIFIED0
NORMAL_TEXT1
SUBTITLE3
TITLE2

NumberUnitType

Enumeration Members

Enumeration MemberValue
CHARACTER2
LINE1
PERCENT4
PIXEL3
POINT0

ObjectRelativeFromH

Enumeration Members

Enumeration MemberValue
CHARACTER2
COLUMN1
INSIDE_MARGIN4
LEFT_MARGIN6
MARGIN3
OUTSIDE_MARGIN5
PAGE0
RIGHT_MARGIN7

ObjectRelativeFromV

Enumeration Members

Enumeration MemberValue
BOTTOM_MARGIN5
INSIDE_MARGIN6
LINE2
MARGIN3
OUTSIDE_MARGIN7
PAGE0
PARAGRAPH1
TOP_MARGIN4

PageOrientType

Paper orientation, whether it’s portrait (vertical) or landscape (horizontal)

Enumeration Members

Enumeration MemberValue
LANDSCAPE1
PORTRAIT0

PositionedObjectLayoutType

The possible layouts of a [PositionedObject]

Enumeration Members

Enumeration MemberValue
INLINE0
WRAP_NONE1
WRAP_POLYGON2
WRAP_SQUARE3
WRAP_THROUGH4
WRAP_TIGHT5
WRAP_TOP_AND_BOTTOM6

RANGE_TYPE

Enumeration Members

Enumeration MemberValue
ALL3
COLUMN2
NORMAL0
ROW1

SectionType

Represents how the start of the current section is positioned relative to the previous section.

Enumeration Members

Enumeration MemberValue
CONTINUOUS1
EVEN_PAGE3
NEXT_PAGE2
ODD_PAGE4
SECTION_TYPE_UNSPECIFIED0

SpacingRule

Enumeration Members

Enumeration MemberValueDescription
AT_LEAST1Specifies that the height of the line shall be at least the value specified, but might be expanded to fit its content as needed.
AUTO0Specifies that the line spacing of the parent object shall be automatically determined by the size of its contents, with no predetermined minimum or maximum size.
EXACT2Specifies that the height of the line shall be exactly the value specified, regardless of the size of the contents of the contents.

TableAlignmentType

Enumeration Members

Enumeration MemberValue
CENTER1
END2
START0

TableLayoutType

Enumeration Members

Enumeration MemberValue
AUTO_FIT0
FIXED1

TableRowHeightRule

Enumeration Members

Enumeration MemberValue
AT_LEAST1
AUTO0
EXACT2

TableSizeType

Enumeration Members

Enumeration MemberValue
SPECIFIED1
UNSPECIFIED0

TableTextWrapType

Enumeration Members

Enumeration MemberValue
NONE0
WRAP1

TabStopAlignment

The alignment of the tab stop.

Enumeration Members

Enumeration MemberValue
CENTER2
END3
START1
TAB_STOP_ALIGNMENT_UNSPECIFIED0

TextDecoration

Types of text decoration

Enumeration Members

Enumeration MemberValue
DASH0
DASH_DOT_DOT_HEAVY1
DASH_DOT_HEAVY2
DASH_LONG4
DASH_LONG_HEAVY5
DASHED_HEAVY3
DOT_DASH6
DOT_DOT_DASH7
DOTTED8
DOTTED_HEAVY9
DOUBLE10
NONE11
SINGLE12
THICK13
WAVE14
WAVY_DOUBLE15
WAVY_HEAVY16
WORDS17

TextDirection

An enum that specifies the text direction of a cell.

Enumeration Members

Enumeration MemberValue
LEFT_TO_RIGHT1
RIGHT_TO_LEFT2
UNSPECIFIED0

TextDirectionType

Direction of text

Enumeration Members

Enumeration MemberValue
LRTBV2
NORMAL0
TBRL1

ThemeColorType

Theme color type enum

Enumeration Members

Enumeration MemberValueDescription
ACCENT14-
ACCENT25-
ACCENT36-
ACCENT47-
ACCENT58-
ACCENT69-
DARK10TEXT
DARK22-
FOLLOWED_HYPERLINK11-
HYPERLINK10LINK
LIGHT11BACKGROUND
LIGHT23-

VerticalAlign

An enum that specifies the vertical alignment of text.

Enumeration Members

Enumeration MemberValue
BOTTOM3
MIDDLE2
TOP1
UNSPECIFIED0

VerticalAlignmentType

The content alignments for a Shape or TableCell. The supported alignments correspond to predefined text anchoring types from the ECMA-376 standard.

Enumeration Members

Enumeration MemberValue
BOTH1
BOTTOM4
CENTER3
CONTENT_ALIGNMENT_UNSPECIFIED0
TOP2

WrapStrategy

An enumeration of the strategies used to handle cell text wrapping.

Enumeration Members

Enumeration MemberValueDescription
CLIP2Lines that are longer than the cell width will be clipped. The text will never wrap to the next line unless the user manually inserts a new line. Example:
OVERFLOW1Lines that are longer than the cell width will be written in the next cell over, so long as that cell is empty. If the next cell over is non-empty, this behaves the same as CLIP . The text will never wrap to the next line unless the user manually inserts a new line. Example:
UNSPECIFIED0-
WRAP3Words that are longer than a line are wrapped at the character level rather than clipped. Example:

WrapTextType

Types of wrap text

Enumeration Members

Enumeration MemberValue
BOTH_SIDES0
LARGEST3
LEFT1
RIGHT2

Type Aliases

CellValue

type CellValue = string | number | boolean;

Cell value type


CustomData

type CustomData = Nullable<Record<..., ...>>;

DrawingType

type DrawingType = DrawingTypeEnum | number;

FHorizontalAlignment

type FHorizontalAlignment = "left" | "center" | "normal";

FontLine

type FontLine = "none" | "underline" | "line-through";

FontStyle

type FontStyle = "normal" | "italic";

FontWeight$1

type FontWeight$1 = "normal" | "bold";

FVerticalAlignment

type FVerticalAlignment = "top" | "middle" | "bottom";

IClipboardChangedParam

type IClipboardChangedParam = IBeforeClipboardChangeParam;

IClipboardPastedParam

type IClipboardPastedParam = IBeforeClipboardPasteParam;

IResources

type IResources = { data: ...; id: ...; name: ...; }[];

Type declaration

NameType
data…
id?…
name…

IUpdateCommandParams

type IUpdateCommandParams = any;

SortColumnSpec

type SortColumnSpec = | { ascending: ...; column: ...; } | number;

Classes

ClassDescription
ConditionalFormatColorScaleRuleBuilder-
ConditionalFormatDataBarRuleBuilder-
ConditionalFormatHighlightRuleBuilder-
ConditionalFormatIconSetRuleBuilder-
FBlob-
FChartThe facade class for the chart.
FChartBuilderBaseThe base class for chart builder.The chart builder is used to create a chart in the sheet.For line chart , radar chart and pie chart, you use the LineChartBuilder, RadarChartBuilder and PieChartBuilder classes respectively.
FCollaborationThe Facade API object for the Collaboration module. It provides methods to interact with the Univer Collaboration backend server, such as loading Univer Sheets and subscribing to collaborators.
FConditionalFormattingBuilder-
FDataValidation-
FDataValidationBuilderBuilder for data validation rules. use FUniver univerAPI.newDataValidation() to create a new builder.
FDefinedName-
FDefinedNameBuilder-
FDocument-
FEnum-
FEventName-
FFilterThis interface class provides methods to modify the filter settings of a worksheet.
FFormulaThis interface class provides methods to modify the behavior of the operation formula.
FHooks-
FMenuThis is the builder for adding a menu to Univer. You shall never construct this class by yourself. Instead, call createMenu of FUniver to create a instance.
FNetworkThis Facade provides a set of methods to make HTTP requests. You should not create an instance of this class directly, instead, use getNetwork of FUniver instead.
FOverGridImage-
FOverGridImageBuilder-
FPermission-
FPivotTableThe facade class for the pivot table.Which uses to setting the pivot table fields configs.
FRangeRepresents a range of cells in a sheet. You can call methods on this Facade API object to read contents or manipulate the range.
FSelectionRepresents the active selection in the sheet.
FSheetHooks-
FShortcutThe Facade API object to handle shortcuts in Univer
FSparklineThe facade class for the sparkline.
FSparklineGroupThe facade class for the sparkline group.Which uses to setting multiple sparklines, all sparkline in the same group will share the configs.
FSubmenuThis is the builder for add a menu that can contains submenus to Univer. You shall never construct this class by yourself. Instead, call createSubmenu of FUniver to create a instance.
FTextFinderThis interface class provides methods to find and replace text in the univer.
FTheadCommentBuilderA builder for thread comment. use FUniver univerAPI.newTheadComment() to create a new builder.
FThreadCommentA class that represents a thread comment already in the sheet.
FUniverThe root Facade API object to interact with Univer. Please use newAPI static method to create a new instance.
FUserManager-
FWorkbookFacade API object bounded to a workbook. It provides a set of methods to interact with the workbook.
FWorksheetA Facade API object bounded to a worksheet. It provides a set of methods to interact with the worksheet.
LineChartBuilderThe builder for creating a line chart.
PieChartBuilderThe builder for creating a pie chart.
RadarChartBuilderThe builder for creating a radar chart.

Interfaces

InterfaceDescription
IAbsoluteTransformCopyright 2023-present DreamNum Inc.
IActiveSheetChangedEventInterface for sheet active changed event Contains information about the newly activated sheet
IBeforeActiveSheetChangeEventInterface for sheet active change event Contains information about the sheet that will become active
IBeforeClipboardChangeParam-
IBeforeClipboardPasteParam-
IBeforeGridlineColorChangedInterface for event before gridline color change Triggered before changing the gridline color
IBeforeGridlineEnableChangeInterface for event before gridline enable/disable Triggered before changing the gridline visibility state
IBeforeOverGridImageChangeParam-
IBeforeOverGridImageChangeParamObject-
IBeforeOverGridImageInsertParam-
IBeforeOverGridImageRemoveParam-
IBeforeOverGridImageSelectParam-
IBeforeSheetCommentAddEventEvent interface triggered before a comment is added to a sheet IBeforeSheetCommentAddEvent
IBeforeSheetCommentDeleteEventEvent interface triggered before a comment is deleted from a sheet IBeforeSheetCommentDeleteEvent
IBeforeSheetCommentUpdateEventEvent interface triggered before a comment is updated in a sheet IBeforeSheetCommentUpdateEvent
IBeforeSheetCreateEventParamsInterface for event parameters triggered before creating a new worksheet Extends the base event interface and includes workbook and worksheet details
IBeforeSheetDataValidationAddEventEvent interface triggered before adding a new data validation rule IBeforeSheetDataValidationAddEvent
IBeforeSheetDataValidationCriteriaUpdateEventEvent interface triggered before updating a data validation rule’s criteria IBeforeSheetDataValidationCriteriaUpdateEvent
IBeforeSheetDataValidationDeleteAllEventEvent interface triggered before deleting all data validation rules IBeforeSheetDataValidationDeleteAllEvent
IBeforeSheetDataValidationDeleteEventEvent interface triggered before deleting a data validation rule IBeforeSheetDataValidationDeleteEvent
IBeforeSheetDataValidationOptionsUpdateEventEvent interface triggered before updating a data validation rule’s options IBeforeSheetDataValidationOptionsUpdateEvent
IBeforeSheetDataValidationRangeUpdateEventEvent interface triggered before updating a data validation rule’s ranges IBeforeSheetDataValidationRangeUpdateEvent
IBeforeSheetDeleteEventInterface for before sheet deletion event Contains information about the sheet that will be deleted
IBeforeSheetEditEndEventParamsEvent interface triggered before cell editing ends IBeforeSheetEditEndEventParams
IBeforeSheetEditStartEventParamsEvent interface triggered before cell editing starts IBeforeSheetEditStartEventParams
IBeforeSheetHideChangeEventInterface for before sheet hide state change event Contains information about the planned sheet visibility change
IBeforeSheetLinkAddEvent-
IBeforeSheetLinkCancelEvent-
IBeforeSheetLinkUpdateEvent-
IBeforeSheetMoveEventInterface for before sheet move event Contains information about the planned sheet movement
IBeforeSheetNameChangeEventInterface for before sheet name change event Contains information about the planned sheet name change
IBeforeSheetPrintCancelEventEvent triggered before print operation is canceled
IBeforeSheetPrintConfirmEventEvent triggered before print settings are confirmed
IBeforeSheetPrintOpenEventEvent triggered before sheet print dialog opens
IBeforeSheetTabColorChangeEventInterface for before sheet tab color change event Contains information about the planned sheet tab color change
IBorderDataStyle properties of top, bottom, left and right border
IBorderStyleDataStyle properties of border
IBulletProperties of list
ICellDataCell data
ICellEventParam-
ICellHyperLink-
IChartBuilderInfoThe chart builder info.
IChartBuildOptionsThe chart build options.
IChartTextStyleThe chart text style.
IColorStyleRGB color or theme color
IColumnDataProperties of column data
IColumnRange-
ICommandEventEvent interface for command execution ICommandEvent
ICrosshairHighlightColorChangedEvent-
ICrosshairHighlightEnabledChangedEvent-
ICustomBlockCustom Block
ICustomDecoration-
ICustomRangeBlock element, link like, disabled to self nested
ICustomTable-
IDistFromText-
IDocCreatedParamEvent interface triggered when a document is created IDocCreatedParam
IDocDisposedEventEvent interface triggered when a document is disposed IDocDisposedEvent
IDocDrawingBaseProperties of Drawing 20.4.2.8 inline (Inline DrawingML Object) 20.4.2.15 wrapNone (No Text Wrapping) 20.4.2.16 wrapPolygon (Wrapping Polygon) 20.4.2.17 wrapSquare (Square Wrapping) 20.4.2.18 wrapThrough (Through Wrapping) 20.4.2.19 wrapTight (Tight Wrapping) 20.4.2.20 wrapTopAndBottom (Top and Bottom Wrapping)
IDocDrawingPositionProperties of a draw object
IDocsBorderProperties of doc border
IDocStyleBaseBasics properties of doc style
IDocumentBodyProperties of document body Contain three update types: range overlay, range mutual exclusion, and placeholder \v COLUMN_BREAK \f PAGE_BREAK \0 DOCS_END \t TAB
IDocumentDataProperties of document
IDocumentLayout-
IDocumentRenderConfigthe alignment mode is returned with respect to the offset of the sheet cell, because the document needs to render the layout for cells and support alignment across multiple cells (e.g., horizontal alignment of long text in overflow mode). The alignment mode of the document itself cannot meet this requirement, so an additional renderConfig needs to be added during the rendering of the document component. This means that there are two coexisting alignment modes. In certain cases, such as in an editor, conflicts may arise, requiring only one alignment mode to be retained. By removing the relevant configurations in renderConfig, the alignment mode of the sheet cell can be modified. The alternative alignment mode is applied to paragraphs within the document.
IDocumentSettings-
IDocumentStyleBasics properties of doc style
IDrawingParam-
IDrawingsSet of Drawings
IDrawingSearch-
IDrawingSpace-
IEventParamConfig-
IFacadeClearOptions-
IFBlobSource-
IFCanvasPopup-
IFComponentKey-
IFICanvasFloatDom-
IFooterDataProperties of doc footer
IFootersSet of footer
IFreeze-
IFSheetSparklineChangedEventParams-
IFTextFinder-
IFWorksheetLegacy-
IGridlineChangedEventInterface for gridline change event Triggered when gridline visibility or color changes in a worksheet
IHeaderAndFooterBase-
IHeaderDataProperties of doc header
IHeadersSet of headers
IIndentStart-
ILifeCycleChangedEventEvent interface for lifecycle stage changes ILifeCycleChangedEvent
IListDataThe properties of a list which describe the look and feel of bullets belonging to paragraphs associated with a list.
IListsSet of lists
IMargin-
INestingLevelContains properties describing the look and feel of a list bullet at a given level of nesting.
INumberUnit-
IObjectArrayPrimitiveType-
IObjectMatrixPrimitiveTypeObject Matrix Primitive Type
IObjectPositionH-
IObjectPositionV-
IOffset-
IOverGridImageChangedParam-
IOverGridImageInsertedParam-
IOverGridImageRemovedParam-
IOverGridImageSelectedParam-
IPaddingDataTop,right,bottom,left padding
IParagraph-
IParagraphBorderProperties of paragraph border
IParagraphProperties-
IParagraphStyleProperties of paragraph style
IRangeRange data structure
IRangeLocation-
IReferenceSource-
IRotationSkewFlipTransform-
IRowDataProperties of row data
IRowRange-
IScale-
IScrollEventParam-
ISectionBreakProperties of section break
ISectionBreakBase-
ISectionColumnPropertiesProperties of section column
ISelectionEventParam-
IShadingProperties of shading
ISheetColumnHeaderEvent-
ISheetCommentAddEventEvent interface triggered after a comment is added to a sheet ISheetCommentAddEvent
ISheetCommentDeleteEventEvent interface triggered after a comment is deleted from a sheet ISheetCommentDeleteEvent
ISheetCommentResolveEventEvent interface triggered when a comment’s resolve status changes ISheetCommentResolveEvent
ISheetCommentUpdateEventEvent interface triggered after a comment is updated in a sheet ISheetCommentUpdateEvent
ISheetCreatedEventParamsInterface for event parameters triggered after a worksheet is created Extends the base event interface and includes workbook and worksheet details
ISheetDataValidationChangedEventEvent interface triggered when a data validation rule is changed ISheetDataValidationChangedEvent
ISheetDataValidatorStatusChangedEventEvent interface triggered when a data validation status changes ISheetDataValidatorStatusChangedEvent
ISheetDeletedEventInterface for sheet deletion event Contains information about the sheet that was deleted
ISheetEditChangingEventParamsEvent interface triggered while cell content is being changed ISheetEditChangingEventParams
ISheetEditEndedEventParamsEvent interface triggered when cell editing ends ISheetEditEndedEventParams
ISheetEditStartedEventParamsEvent interface triggered when cell editing starts ISheetEditStartedEventParams
ISheetHideChangedEventInterface for sheet hide state change event Contains information about the sheet visibility change
ISheetMovedEventInterface for sheet moved event Contains information about the sheet movement
ISheetNameChangedEventInterface for sheet name change event Contains information about the sheet name change
ISheetPrintCanceledEventEvent triggered when print operation is canceled
ISheetPrintConfirmedEventEvent triggered when print settings are confirmed by user
ISheetPrintOpenEventEvent triggered when sheet print dialog is opened
ISheetRangeFilterClearedEventParamsThe params of SheetRangeFilterCleared and SheetBeforeRangeFilterClear events.
ISheetRangeFilteredParamsThe params of SheetRangeFiltered and SheetBeforeRangeFilter events.
ISheetRangeSortParams-
ISheetRowHeaderEvent-
ISheetSkeletonChangedEvent-
ISheetTabColorChangedEventInterface for sheet tab color change event Contains information about the sheet tab color change
ISheetValueChangedEventInterface for sheet value changed event Contains information about the sheet value change
ISheetZoomEvent-
ISizeCopyright 2023-present DreamNum Inc.
ISortColumn-
IStyleBaseBasics properties of cell style
IStyleDataProperties of cell style
ITableProperties of table
ITableAnchor-
ITableCellProperties of table cell
ITableCellBorderProperties of cell border
ITableCellMargin-
ITableColumn-
ITableRowProperties of row of table
ITableRowSize-
ITables-
ITabStopA tab stop within a paragraph.
ITextDecorationProperties of text decoration
ITextRotation-
ITextRunA ParagraphElement that represents a run of text that all has the same styling.
ITextStyleProperties of text style
ITransformStateCopyright 2023-present DreamNum Inc.
IWidthInTableSize-
IWorkbookCreateParamInterface for workbook creation parameters Extends the base event interface and includes workbook initialization details
IWorkbookDataSnapshot of a workbook.
IWorkbookDisposedEventInterface for workbook disposal event Contains information about the disposed workbook including its snapshot data
IWorksheetDataSnapshot of a worksheet.