@univerjs/sheets v0.1.17 • Docs

@univerjs/sheets

Enumerations

Enumeration	Description
OperatorType	-
SelectionMoveType	-

Classes

Class	Description
BorderStyleManagerService	This service is for managing settings border style status.
DefinedNameDataController	-
MergeCellController	-
NumfmtService	-
RangeMergeUtil	-
RangeProtectionPermissionEditPoint	-
RangeProtectionPermissionViewPoint	-
RangeProtectionRefRangeService	-
RangeProtectionRenderModel	-
RangeProtectionRuleModel	-
RangeProtectionService	-
RefRangeService	Collect side effects caused by ref range change
SelectionManagerService	This service is responsible for managing the selection data.
SheetInterceptorService	This class expose methods for sheet features to inject code to sheet underlying logic.
UniverSheetsPlugin	The main sheet base, construct the sheet container and layout, mount the rendering engine
WorkbookCommentPermission	-
WorkbookCopyPermission	-
WorkbookCopySheetPermission	-
WorkbookCreateSheetPermission	-
WorkbookDeleteSheetPermission	-
WorkbookDuplicatePermission	-
WorkbookEditablePermission	-
WorkbookExportPermission	-
WorkbookHideSheetPermission	-
WorkbookHistoryPermission	-
WorkbookManageCollaboratorPermission	-
WorkbookMoveSheetPermission	-
WorkbookPermissionService	-
WorkbookPrintPermission	-
WorkbookRenameSheetPermission	-
WorkbookSharePermission	-
WorkbookViewPermission	-
WorksheetCopyPermission	-
WorksheetDeleteColumnPermission	-
WorksheetDeleteRowPermission	-
WorksheetEditExtraObjectPermission	-
WorksheetEditPermission	-
WorksheetFilterPermission	-
WorksheetInsertColumnPermission	-
WorksheetInsertHyperlinkPermission	-
WorksheetInsertRowPermission	-
WorksheetManageCollaboratorPermission	-
WorksheetPermissionService	-
WorksheetPivotTablePermission	-
WorksheetProtectionPointModel	-
WorksheetProtectionRuleModel	-
WorksheetSelectProtectedCellsPermission	-
WorksheetSelectUnProtectedCellsPermission	-
WorksheetSetCellStylePermission	-
WorksheetSetCellValuePermission	-
WorksheetSetColumnStylePermission	-
WorksheetSetRowStylePermission	-
WorksheetSortPermission	-
WorksheetViewPermission	-

Interfaces

Interface	Description
IAddRangeProtectionCommandParams	-
IAddRangeProtectionMutationParams	-
IAddWorksheetMergeMutationParams	Params of AddWorksheetMergeMutation
IAddWorksheetProtectionParams	-
IBorderInfo	-
IDeleteRangeMoveLeftCommandParams	-
IDeleteRangeMoveUpCommandParams	-
IDeleteRangeMutationParams	Params of DeleteRange
IDeleteRangeProtectionCommandParams	-
IDeleteSelectionProtectionMutationParams	-
IDeltaColumnWidthCommandParams	-
IDeltaRowHeightCommand	-
IInsertColCommandParams	-
IInsertColMutationParams	Params of InsertColMutation
IInsertRangeMutationParams	Params of InsertRange
IInsertRowCommandParams	-
IInsertRowMutationParams	Params of InsertRowMutation
IInsertSheetCommandParams	-
IInsertSheetMutationParams	Params of `InsertSheetMutation`
IMoveColsCommandParams	-
IMoveColumnsMutationParams	-
IMoveRangeCommandParams	-
IMoveRangeMutationParams	-
IMoveRowsCommandParams	-
IMoveRowsMutationParams	-
INumfmtItemWithCache	-
INumfmtService	-
IRangeProtectionRule	-
IRemoveColMutationParams	Params of InsertColMutation
IRemoveNumfmtMutationParams	-
IRemoveRowColCommandParams	-
IRemoveRowsMutationParams	Params of InsertRowMutation
IRemoveSheetCommandParams	-
IRemoveSheetMutationParams	Params of `RemoveSheetMutation`
IRemoveWorksheetMergeMutationParams	Params of RemoveWorksheetMergeMutation
IReorderRangeCommandParams	Copyright 2023-present DreamNum Inc.
IReorderRangeMutationParams	Copyright 2023-present DreamNum Inc.
ISelectionStyle	https://support.microsoft.com/en-us/office/select-cell-contents-in-excel-23f64223-2b6b-453a-8688-248355f10fa9 (opens in a new tab)
ISelectionWidgetConfig	Whether to display the controller that modifies the selection, distributed in 8 locations tl top_left_corner tc top_center_corner tr top_right_corner ml middle_left_corner mr middle_right_corner bl bottom_left_corner bc bottom_center_corner br bottom_right_corner
ISelectionWithCoordAndStyle	-
ISelectionWithStyle	-
ISetBorderBasicCommandParams	-
ISetBorderColorCommandParams	-
ISetBorderCommandParams	-
ISetBorderPositionCommandParams	-
ISetBorderStyleCommandParams	-
ISetColHiddenMutationParams	-
ISetColVisibleMutationParams	-
ISetColorCommandParams	-
ISetDefinedNameCommandParams	-
ISetFontFamilyCommandParams	-
ISetFontSizeCommandParams	-
ISetFrozenMutationParams	-
ISetHorizontalTextAlignCommandParams	-
ISetNumfmtMutationParams	-
ISetRangeProtectionCommandParams	-
ISetRangeProtectionMutationParams	-
ISetRangeValuesCommandParams	-
ISetRangeValuesMutationParams	Params of `SetRangeValuesMutation`
ISetRangeValuesRangeMutationParams	Params of `SetRangeValuesMutation`
ISetRowHiddenMutationParams	-
ISetRowVisibleMutationParams	-
ISetSelectionsOperationParams	-
ISetSpecificColsVisibleCommandParams	-
ISetSpecificRowsVisibleCommandParams	-
ISetStyleCommandParams	-
ISetTabColorMutationParams	-
ISetTextRotationCommandParams	-
ISetTextWrapCommandParams	-
ISetVerticalTextAlignCommandParams	-
ISetWorkbookNameCommandParams	-
ISetWorkbookNameMutationParams	-
ISetWorksheetActivateCommandParams	-
ISetWorksheetActiveOperationParams	-
ISetWorksheetColWidthMutationParams	-
ISetWorksheetHideMutationParams	-
ISetWorksheetNameCommandParams	-
ISetWorksheetNameMutationParams	-
ISetWorksheetOrderMutationParams	-
ISetWorksheetRowAutoHeightMutationParams	-
ISetWorksheetRowHeightMutationParams	-
ISetWorksheetRowIsAutoHeightCommandParams	-
ISetWorksheetRowIsAutoHeightMutationParams	-
ISheetCommandSharedParams	Copyright 2023-present DreamNum Inc.
ISheetLocation	-
ISheetLocationBase	-
ISheetRangeLocation	-
ISheetRowLocation	-
IStyleTypeValue	-
IUniverSheetsConfig	-
IWorksheetProtectionRule	-
InsertRangeMoveDownCommandParams	-
InsertRangeMoveRightCommandParams	-

Type Aliases

Type alias	Description
EffectRefRangeParams	-
FormatType	-
ICellPermission	-
IModel	-
INumfmtItem	-
IObjectModel	-
IOperator	-
IRangePermissionPoint	-
ISetCellsNumfmt	-
IWorksheetProtectionRenderCellData	-

Variables

Variable	Description
AddRangeProtectionCommand	-
AddRangeProtectionMutation	-
AddWorksheetMergeMutation	-
AddWorksheetProtectionMutation	-
COMMAND_LISTENER_SKELETON_CHANGE	Mutations those will trigger the skeleton change.
COMMAND_LISTENER_VALUE_CHANGE	-
ClearSelectionAllCommand	The command to clear all in current selected ranges.
ClearSelectionContentCommand	The command to clear content in current selected ranges.
ClearSelectionFormatCommand	The command to clear content in current selected ranges.
CopySheetCommand	-
DeleteRangeMoveLeftCommand	The command to delete range.
DeleteRangeMoveUpCommand	The command to delete range.
DeleteRangeProtectionCommand	-
DeleteRangeProtectionMutation	-
DeleteWorksheetProtectionMutation	-
DeltaColumnWidthCommand	-
DeltaRowHeightCommand	-
EffectRefRangId	-
EmptyMutation	-
INTERCEPTOR_POINT	-
InsertColAfterCommand	-
InsertColBeforeCommand	-
InsertColCommand	-
InsertColMutation	-
InsertDefinedNameCommand	The command to insert new defined name
InsertRangeMoveDownCommand	The command to insert range.
InsertRangeMoveRightCommand	The command to insert range.
InsertRowAfterCommand	-
InsertRowBeforeCommand	-
InsertRowCommand	this command and its interface should not be exported from index.ts
InsertRowMutation	-
InsertSheetCommand	The command to insert new worksheet
InsertSheetMutation	-
MAX_CELL_PER_SHEET_KEY	Copyright 2023-present DreamNum Inc.
MoveColsCommand	-
MoveColsMutation	-
MoveRangeCommand	-
MoveRangeMutation	-
MoveRowsCommand	Command to move the selected rows (must currently selected) to the specified row.
MoveRowsMutation	-
NORMAL_SELECTION_PLUGIN_NAME	-
RemoveColCommand	This command would remove the selected columns. These selected rows can be non-continuous.
RemoveColMutation	-
RemoveDefinedNameCommand	The command to remove new defined name
RemoveNumfmtMutation	-
RemoveRowCommand	This command would remove the selected rows. These selected rows can be non-continuous.
RemoveRowMutation	-
RemoveSheetCommand	The command to insert new worksheet
RemoveSheetMutation	-
RemoveWorksheetMergeCommand	-
RemoveWorksheetMergeMutation	-
ReorderRangeCommand	-
ReorderRangeMutation	-
ResetBackgroundColorCommand	-
ResetTextColorCommand	-
SELECTION_CONTROL_BORDER_BUFFER_COLOR	-
SELECTION_CONTROL_BORDER_BUFFER_WIDTH	-
ScrollToCellOperation	-
SetBackgroundColorCommand	-
SetBoldCommand	Set bold font style to currently selected ranges. If the cell is already bold then it will cancel the bold style.
SetBorderBasicCommand	-
SetBorderColorCommand	-
SetBorderCommand	The command to clear content in current selected ranges.
SetBorderPositionCommand	-
SetBorderStyleCommand	-
SetColHiddenCommand	-
SetColHiddenMutation	-
SetColVisibleMutation	-
SetColWidthCommand	-
SetDefinedNameCommand	The command to update defined name
SetFontFamilyCommand	-
SetFontSizeCommand	-
SetFrozenCommand	-
SetFrozenMutation	-
SetHorizontalTextAlignCommand	-
SetItalicCommand	Set italic font style to currently selected ranges. If the cell is already italic then it will cancel the italic style.
SetNumfmtMutation	-
SetRangeProtectionCommand	-
SetRangeProtectionMutation	-
SetRangeValuesCommand	The command to set values for ranges.
SetRangeValuesMutation	TODO@Dushusir: Excel can display numbers with up to about 15 digits of precision. When the user inputs more than 15 digits, interception is required, but there are unknown performance risks.
SetRowHeightCommand	-
SetRowHiddenCommand	-
SetRowHiddenMutation	-
SetRowVisibleMutation	-
SetSelectedColsVisibleCommand	-
SetSelectedRowsVisibleCommand	-
SetSelectionsOperation	-
SetSpecificColsVisibleCommand	-
SetSpecificRowsVisibleCommand	-
SetStrikeThroughCommand	Set strike through font style to currently selected ranges. If the cell is already stroke then it will cancel the stroke style.
SetStyleCommand	The command to set cell style. Set style to a bunch of ranges.
SetTabColorCommand	-
SetTabColorMutation	-
SetTextColorCommand	-
SetTextRotationCommand	-
SetTextWrapCommand	-
SetUnderlineCommand	Set underline font style to currently selected ranges. If the cell is already underline then it will cancel the underline style.
SetVerticalTextAlignCommand	-
SetWorkbookNameCommand	The command to set the workbook name. It does not support undo redo.
SetWorkbookNameMutation	-
SetWorksheetActivateCommand	-
SetWorksheetActiveOperation	-
SetWorksheetColWidthMutation	-
SetWorksheetHideCommand	-
SetWorksheetHideMutation	-
SetWorksheetNameCommand	The command to set the sheet name.
SetWorksheetNameMutation	-
SetWorksheetOrderCommand	-
SetWorksheetOrderMutation	-
SetWorksheetPermissionPointsCommand	-
SetWorksheetProtectionMutation	-
SetWorksheetRowAutoHeightMutation	-
SetWorksheetRowHeightMutation	-
SetWorksheetRowIsAutoHeightCommand	-
SetWorksheetRowIsAutoHeightMutation	-
SetWorksheetShowCommand	-
defaultWorkbookPermissionPoints	-
defaultWorksheetPermissionPoint	-

Functions

Function	Description
AddMergeRedoSelectionsOperationFactory	-
AddMergeUndoMutationFactory	-
AddMergeUndoSelectionsOperationFactory	-
FactoryAddRangeProtectionMutation	-
FactoryDeleteRangeProtectionMutation	-
FactorySetRangeProtectionMutation	-
INumfmtService	-
InsertColMutationUndoFactory	-
InsertRowMutationUndoFactory	-
InsertSheetUndoMutationFactory	-
MoveColsMutationUndoFactory	-
MoveRowsMutationUndoFactory	Get an undo mutation for the move rows mutation.
RemoveMergeUndoMutationFactory	-
RemoveSheetUndoMutationFactory	-
SetFrozenMutationFactory	-
SetRangeValuesUndoMutationFactory	-
SetWorksheetColWidthMutationFactory	-
SetWorksheetRowAutoHeightMutationFactory	-
alignToMergedCellsBorders	Adjust the range to align merged cell's borders.
convertPrimaryWithCoordToPrimary	-
convertSelectionDataToRange	Process a selection with coordinates and style, and extract the coordinate information, because the render needs coordinates when drawing. Since the selection.manager.service is unrelated to the coordinates, it only accepts data of type ISelectionWithStyle, so a conversion is necessary.
createTopMatrixFromMatrix	-
createTopMatrixFromRanges	-
expandToContinuousRange	-
factoryRemoveNumfmtUndoMutation	-
factorySetNumfmtUndoMutation	-
findAllRectangle	-
followSelectionOperation	-
generateNullCellValue	Generate cellValue from range and set v/p/f/si/custom to null
getAddMergeMutationRangeByType	calculates the selection based on the merged cell type
getAllRangePermissionPoint	-
getAllWorkbookPermissionPoint	-
getAllWorksheetPermissionPoint	-
getAllWorksheetPermissionPointByPointPanel	-
getCellAtRowCol	-
getDefaultRangePermission	-
getInsertRangeMutations	InsertRange is not a mutation but combination of `SetRangeValuesMutation` and `MoveRangeMutation`.
getMoveRangeUndoRedoMutations	-
getNormalSelectionStyle	-
getPrimaryForRange	Get the default primary cell (the most top-left cell) of a range.
getRemoveRangeMutations	-
getSheetCommandTarget	Get targeted Workbook & Worksheet of a command. If `unitId` and `subUnitId` are given, the function would try to get these instances. If not, it would try to get the current active instances.
getSheetCommandTargetWorkbook	-
getSheetMutationTarget	-
handleBaseInsertRange	-
handleBaseMoveRowsCols	-
handleBaseRemoveRange	-
handleCommonDefaultRangeChangeWithEffectRefCommands	-
handleDefaultRangeChangeWithEffectRefCommands	-
handleDefaultRangeChangeWithEffectRefCommandsSkipNoInterests	-
handleDeleteRangeMoveLeft	-
handleDeleteRangeMoveUp	-
handleDeleteRangeMutation	-
handleIRemoveCol	-
handleIRemoveRow	-
handleInsertCol	-
handleInsertRangeMoveDown	-
handleInsertRangeMoveRight	-
handleInsertRangeMutation	-
handleInsertRow	-
handleMoveCols	-
handleMoveRange	-
handleMoveRows	-
isSingleCellSelection	Examine if a selection only contains a single cell (a merged cell is considered as a single cell in this case).
rangeMerge	-
rotateRange	-
runRefRangeMutations	-
setEndForRange	-
transformCellDataToSelectionData	Convert the coordinates of a single cell into a selection data.
transformCellsToRange	-

Remotesyncservicename Borderstylemanagerservice