@univerjssheetsfacadeclassesFpermission

@univerjs/sheets v0.5.4


Class: FPermission

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:22

FBase is a base class for all facade classes. It provides a way to extend classes with static and instance methods. The _initialize as a special method that will be called after the constructor. You should never call it directly.

Extends

Extended by

Constructors

new FPermission()

new FPermission(
   _injector, 
   _commandService, 
   _permissionService, 
   _worksheetProtectionRuleModel, 
   _rangeProtectionRuleModel, 
   _worksheetProtectionPointRuleModel, 
   _authzIoService): FPermission

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:27

Parameters

ParameterType
_injectorInjector
_commandServiceICommandService
_permissionServiceIPermissionService
_worksheetProtectionRuleModelWorksheetProtectionRuleModel
_rangeProtectionRuleModelRangeProtectionRuleModel
_worksheetProtectionPointRuleModelWorksheetProtectionPointModel
_authzIoServiceIAuthzIoService

Returns

FPermission

Overrides

FBase.constructor

Properties

PropertyModifierTypeDefault valueInherited fromDefined in
_authzIoServicereadonlyIAuthzIoServiceundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:34
_commandServicereadonlyICommandServiceundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:29
_disposedprotectedbooleanfalseFBase._disposedsubmodules/univer/packages/core/src/shared/lifecycle.ts:96
_injectorreadonlyInjectorundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:28
_permissionServicereadonlyIPermissionServiceundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:30
_rangeProtectionRuleModelreadonlyRangeProtectionRuleModelundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:32
_worksheetProtectionPointRuleModelreadonlyWorksheetProtectionPointModelundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:33
_worksheetProtectionRuleModelreadonlyWorksheetProtectionRuleModelundefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:31
permissionPointsDefinitionpublic{ RangeProtectionPermissionEditPoint: typeof RangeProtectionPermissionEditPoint; RangeProtectionPermissionViewPoint: typeof RangeProtectionPermissionViewPoint; WorkbookCommentPermission: typeof WorkbookCommentPermission; WorkbookCopyPermission: typeof WorkbookCopyPermission; WorkbookCreateProtectPermission: typeof WorkbookCreateProtectPermission; WorkbookCreateSheetPermission: typeof WorkbookCreateSheetPermission; WorkbookDeleteSheetPermission: typeof WorkbookDeleteSheetPermission; WorkbookDuplicatePermission: typeof WorkbookDuplicatePermission; WorkbookEditablePermission: typeof WorkbookEditablePermission; WorkbookExportPermission: typeof WorkbookExportPermission; WorkbookHideSheetPermission: typeof WorkbookHideSheetPermission; WorkbookHistoryPermission: typeof WorkbookHistoryPermission; WorkbookManageCollaboratorPermission: typeof WorkbookManageCollaboratorPermission; WorkbookMoveSheetPermission: typeof WorkbookMoveSheetPermission; WorkbookPrintPermission: typeof WorkbookPrintPermission; WorkbookRecoverHistoryPermission: typeof WorkbookRecoverHistoryPermission; WorkbookRenameSheetPermission: typeof WorkbookRenameSheetPermission; WorkbookSharePermission: typeof WorkbookSharePermission; WorkbookViewHistoryPermission: typeof WorkbookViewHistoryPermission; WorkbookViewPermission: typeof WorkbookViewPermission; WorksheetCopyPermission: typeof WorksheetCopyPermission; WorksheetDeleteColumnPermission: typeof WorksheetDeleteColumnPermission; WorksheetDeleteProtectionPermission: typeof WorksheetDeleteProtectionPermission; WorksheetDeleteRowPermission: typeof WorksheetDeleteRowPermission; WorksheetEditExtraObjectPermission: typeof WorksheetEditExtraObjectPermission; WorksheetEditPermission: typeof WorksheetEditPermission; WorksheetFilterPermission: typeof WorksheetFilterPermission; WorksheetInsertColumnPermission: typeof WorksheetInsertColumnPermission; WorksheetInsertHyperlinkPermission: typeof WorksheetInsertHyperlinkPermission; WorksheetInsertRowPermission: typeof WorksheetInsertRowPermission; WorksheetManageCollaboratorPermission: typeof WorksheetManageCollaboratorPermission; WorksheetPivotTablePermission: typeof WorksheetPivotTablePermission; WorksheetSelectProtectedCellsPermission: typeof WorksheetSelectProtectedCellsPermission; WorksheetSelectUnProtectedCellsPermission: typeof WorksheetSelectUnProtectedCellsPermission; WorksheetSetCellStylePermission: typeof WorksheetSetCellStylePermission; WorksheetSetCellValuePermission: typeof WorksheetSetCellValuePermission; WorksheetSetColumnStylePermission: typeof WorksheetSetColumnStylePermission; WorksheetSetRowStylePermission: typeof WorksheetSetRowStylePermission; WorksheetSortPermission: typeof WorksheetSortPermission; WorksheetViewPermission: typeof WorksheetViewPermission; }PermissionPointsDefinitions-submodules/univer/packages/sheets/src/facade/f-permission.ts:23
permissionPointsDefinition.RangeProtectionPermissionEditPointpublictypeof RangeProtectionPermissionEditPointundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:99
permissionPointsDefinition.RangeProtectionPermissionViewPointpublictypeof RangeProtectionPermissionViewPointundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:100
permissionPointsDefinition.WorkbookCommentPermissionpublictypeof WorkbookCommentPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:59
permissionPointsDefinition.WorkbookCopyPermissionpublictypeof WorkbookCopyPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:60
permissionPointsDefinition.WorkbookCreateProtectPermissionpublictypeof WorkbookCreateProtectPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:61
permissionPointsDefinition.WorkbookCreateSheetPermissionpublictypeof WorkbookCreateSheetPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:62
permissionPointsDefinition.WorkbookDeleteSheetPermissionpublictypeof WorkbookDeleteSheetPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:63
permissionPointsDefinition.WorkbookDuplicatePermissionpublictypeof WorkbookDuplicatePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:64
permissionPointsDefinition.WorkbookEditablePermissionpublictypeof WorkbookEditablePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:65
permissionPointsDefinition.WorkbookExportPermissionpublictypeof WorkbookExportPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:66
permissionPointsDefinition.WorkbookHideSheetPermissionpublictypeof WorkbookHideSheetPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:67
permissionPointsDefinition.WorkbookHistoryPermissionpublictypeof WorkbookHistoryPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:68
permissionPointsDefinition.WorkbookManageCollaboratorPermissionpublictypeof WorkbookManageCollaboratorPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:69
permissionPointsDefinition.WorkbookMoveSheetPermissionpublictypeof WorkbookMoveSheetPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:70
permissionPointsDefinition.WorkbookPrintPermissionpublictypeof WorkbookPrintPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:71
permissionPointsDefinition.WorkbookRecoverHistoryPermissionpublictypeof WorkbookRecoverHistoryPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:72
permissionPointsDefinition.WorkbookRenameSheetPermissionpublictypeof WorkbookRenameSheetPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:73
permissionPointsDefinition.WorkbookSharePermissionpublictypeof WorkbookSharePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:74
permissionPointsDefinition.WorkbookViewHistoryPermissionpublictypeof WorkbookViewHistoryPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:75
permissionPointsDefinition.WorkbookViewPermissionpublictypeof WorkbookViewPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:76
permissionPointsDefinition.WorksheetCopyPermissionpublictypeof WorksheetCopyPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:77
permissionPointsDefinition.WorksheetDeleteColumnPermissionpublictypeof WorksheetDeleteColumnPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:79
permissionPointsDefinition.WorksheetDeleteProtectionPermissionpublictypeof WorksheetDeleteProtectionPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:80
permissionPointsDefinition.WorksheetDeleteRowPermissionpublictypeof WorksheetDeleteRowPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:81
permissionPointsDefinition.WorksheetEditExtraObjectPermissionpublictypeof WorksheetEditExtraObjectPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:82
permissionPointsDefinition.WorksheetEditPermissionpublictypeof WorksheetEditPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:83
permissionPointsDefinition.WorksheetFilterPermissionpublictypeof WorksheetFilterPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:84
permissionPointsDefinition.WorksheetInsertColumnPermissionpublictypeof WorksheetInsertColumnPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:85
permissionPointsDefinition.WorksheetInsertHyperlinkPermissionpublictypeof WorksheetInsertHyperlinkPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:86
permissionPointsDefinition.WorksheetInsertRowPermissionpublictypeof WorksheetInsertRowPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:87
permissionPointsDefinition.WorksheetManageCollaboratorPermissionpublictypeof WorksheetManageCollaboratorPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:88
permissionPointsDefinition.WorksheetPivotTablePermissionpublictypeof WorksheetPivotTablePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:89
permissionPointsDefinition.WorksheetSelectProtectedCellsPermissionpublictypeof WorksheetSelectProtectedCellsPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:90
permissionPointsDefinition.WorksheetSelectUnProtectedCellsPermissionpublictypeof WorksheetSelectUnProtectedCellsPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:91
permissionPointsDefinition.WorksheetSetCellStylePermissionpublictypeof WorksheetSetCellStylePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:92
permissionPointsDefinition.WorksheetSetCellValuePermissionpublictypeof WorksheetSetCellValuePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:93
permissionPointsDefinition.WorksheetSetColumnStylePermissionpublictypeof WorksheetSetColumnStylePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:94
permissionPointsDefinition.WorksheetSetRowStylePermissionpublictypeof WorksheetSetRowStylePermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:95
permissionPointsDefinition.WorksheetSortPermissionpublictypeof WorksheetSortPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:96
permissionPointsDefinition.WorksheetViewPermissionpublictypeof WorksheetViewPermissionundefined-submodules/univer/packages/sheets/src/services/permission/permission-point/const.ts:97
rangeRuleChangedAfterAuth$publicObservable<unknown>undefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:24
sheetRuleChangedAfterAuth$publicObservable<unknown>undefined-submodules/univer/packages/sheets/src/facade/f-permission.ts:25

Methods

addRangeBaseProtection()

addRangeBaseProtection(
   unitId, 
   subUnitId, 
   ranges): Promise<
  | undefined
  | {
  permissionId: string;
  ruleId: string;
}>

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:180

Adds a range protection to the worksheet.

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook.
subUnitIdstringThe unique identifier of the worksheet.
rangesIRange[]The ranges to be protected.

Returns

Promise< | undefined | { permissionId: string; ruleId: string; }>

  • Returns an object containing the permissionId and ruleId if the range protection is successfully added. If the operation fails or no result is returned, it resolves to undefined. permissionId is used to stitch permission point ID,ruleId is used to store permission rules

addWorksheetBasePermission()

addWorksheetBasePermission(unitId, subUnitId): Promise<undefined | string>

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:74

This function is used to add a base permission for a worksheet.

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook for which the permission is being set.
subUnitIdstringThe unique identifier of the worksheet for which the permission is being set.

Returns

Promise<undefined | string>

  • Returns the permissionId if the permission is successfully added. If the operation fails or no result is returned, it resolves to undefined.

dispose()

dispose(): void

Defined in: submodules/univer/packages/core/src/shared/lifecycle.ts:109

Returns

void

Inherited from

FBase.dispose


disposeWithMe()

disposeWithMe(disposable): IDisposable

Defined in: submodules/univer/packages/core/src/shared/lifecycle.ts:99

Parameters

ParameterType
disposableDisposableLike

Returns

IDisposable

Inherited from

FBase.disposeWithMe


ensureNotDisposed()

protected ensureNotDisposed(): void

Defined in: submodules/univer/packages/core/src/shared/lifecycle.ts:103

Returns

void

Inherited from

FBase.ensureNotDisposed


removeRangeProtection()

removeRangeProtection(
   unitId, 
   subUnitId, 
   ruleIds): void

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:235

Removes the range protection from the worksheet.

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook.
subUnitIdstringThe unique identifier of the worksheet.
ruleIdsstring[]The rule IDs of the range protection to be removed.

Returns

void


removeWorksheetPermission()

removeWorksheetPermission(unitId, subUnitId): void

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:108

Delete the entire table protection set for the worksheet and reset the point permissions of the worksheet to true

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook for which the permission is being set.
subUnitIdstringThe unique identifier of the worksheet for which the permission is being set.

Returns

void


setRangeProtectionPermissionPoint()

setRangeProtectionPermissionPoint(
   unitId, 
   subUnitId, 
   permissionId, 
   FPointClass, 
   value): void

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:263

Modify the permission points of a custom area

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook.
subUnitIdstringThe unique identifier of the worksheet within the workbook.
permissionIdstringThe unique identifier of the permission that controls access to the range.
FPointClassRangePermissionPointConstructorThe constructor for the range permission point class. See the permission-point documentation for more details.
valuebooleanThe new permission value to be set for the range (e.g., true for allowing access, false for restricting access).

Returns

void


setRangeProtectionRanges()

setRangeProtectionRanges(
   unitId, 
   subUnitId, 
   ruleId, 
   ranges): void

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:283

Sets the ranges for range protection in a worksheet.

This method finds the rule by unitId, subUnitId, and ruleId, and updates the rule with the provided ranges. It checks for overlaps with existing ranges in the same subunit and shows an error message if any overlap is detected. If no overlap is found, it executes the command to update the range protection with the new ranges.

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook.
subUnitIdstringThe unique identifier of the worksheet within the workbook.
ruleIdstringThe ruleId of the range protection rule that is being updated.
rangesIRange[]The array of new ranges to be set for the range protection rule.

Returns

void


setWorkbookEditPermission()

setWorkbookEditPermission(unitId, value): void

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:64

This function is used to set whether the workbook can be edited

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook for which the permission is being set.
valuebooleanA value that controls whether the workbook can be edited

Returns

void


setWorkbookPermissionPoint()

setWorkbookPermissionPoint(
   unitId, 
   FPointClass, 
   value): void

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:50

Configures a specific permission point for a workbook.

This function sets or updates a permission point for a workbook identified by unitId. It creates a new permission point if it does not already exist, and updates the point with the provided value.

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook for which the permission is being set.
FPointClassWorkbookPermissionPointConstructorThe constructor function for creating a permission point instance. Other point constructors can See the permission-point documentation for more details.
valuebooleanThe boolean value to determine whether the permission point is enabled or disabled.

Returns

void


setWorksheetPermissionPoint()

setWorksheetPermissionPoint(
   unitId, 
   subUnitId, 
   FPointClass, 
value): Promise<undefined | string>

Defined in: submodules/univer/packages/sheets/src/facade/f-permission.ts:131

Sets the worksheet permission point by updating or adding the permission point for the worksheet. If the worksheet doesn’t have a base permission, it creates one to used render

Parameters

ParameterTypeDescription
unitIdstringThe unique identifier of the workbook.
subUnitIdstringThe unique identifier of the worksheet.
FPointClassWorkSheetPermissionPointConstructorThe constructor for the permission point class. See the permission-point documentation for more details.
valuebooleanThe new permission value to be set for the worksheet.

Returns

Promise<undefined | string>

  • Returns the permissionId if the permission point is successfully set or created. If no permission is set, it resolves to undefined.

extend()

static extend(source): void

Defined in: submodules/univer/packages/core/src/facade/f-base.ts:26

Parameters

ParameterType
sourceany

Returns

void

Inherited from

FBase.extend