[Bug] Protected cell content is not visible

[Maksych]

Before you submit this issue, have you checked the following

• Is this really a problem?
• I have searched the Github Issues for similar issues, but did not find anything.

Affected packages and versions

I used latest versions.

Reproduction link

Reproduction link

Expected behavior

Protected cell content visible.

Actual behavior

Protected cell content is not visible.

System information

System:
OS: macOS 26.0.1
CPU: (14) arm64 Apple M3 Max
Memory: 1.09 GB / 36.00 GB
Shell: 5.9 - /bin/zsh
Binaries:
Node: 22.18.0 - /Users/maksych/.nvm/versions/node/v22.18.0/bin/node
npm: 10.9.3 - /Users/maksych/.nvm/versions/node/v22.18.0/bin/npm
pnpm: 10.18.0 - /Users/maksych/Library/pnpm/pnpm
Browsers:
Chrome: 141.0.7390.66
Safari: 26.0.1

[VicKun4937]

hi, you may read https://docs.univer.ai/guides/sheets/features/core/permission,
you should add permissionId in your json , and the permissionId which ref the permission piont define which can view or edit

or , we have demo in pull request view deployment , you can compare the snapshot too

[Maksych]

@VicKun4937 ok, will try. What data structure and name for loading permission points with resources?

[Maksych]

@VicKun4937 We have 2 permission points for range protection (view and edit), but in protection ranges we have only one permissionId. Maybe protection ranges must contain 2 permission ids? permissionViewId and permissionEditId?

[VicKun4937]

Here is an example : https://univer-qeczu7qon-univer.vercel.app/sheets/

In console eval following code:
const workbook = univerAPI.getActiveWorkbook()._workbook const sheet = workbook.getActiveSheet(); console.log(workbook.getSnapshot())
you can get

It's hard to description, you may read following code ,
https://github.com/dream-num/univer/blob/dev/packages/sheets/src/services/permission/range-permission/range-protection.service.ts

this code makes the point work:

It mains the range protect json resource descipt witch piont will be use for range by permissionId, and the permissionId action can be allowed defined in list you define in your system

[VicKun4937]

here is one example from our system:

we save the range protect info in snapshot[SHEET_RANGE_PROTECTION_PLUGIN] , and the piont who save the same objectID and define the allow rule
the number is UitAction witch define in @univerjs/protocol.

export declare enum UnitAction {
    View = 0,
    Edit = 1,
    ManageCollaborator = 2,
    Print = 3,
    /** Duplicate - create a copy */
    Duplicate = 4,
    Comment = 5,
    Copy = 6,
    Share = 7,
    Export = 8,
    /** @deprecated */
    MoveWorksheet = 9,
    /** @deprecated */
    DeleteWorksheet = 10,
    /** @deprecated */
    HideWorksheet = 11,
    /** @deprecated */
    RenameWorksheet = 12,
    /** @deprecated */
    CreateWorksheet = 13,
    /** @deprecated */
    SetWorksheetStyle = 14,
    /** @deprecated */
    EditWorksheetCell = 15,
    InsertHyperlink = 16,
    Sort = 17,
    Filter = 18,
    PivotTable = 19,
    /** @deprecated */
    FloatImg = 20,
    /** @deprecated */
    History = 21,
    /**
     * RwHgtClWdt - row height, column width
     *
     * @deprecated
     */
    RwHgtClWdt = 22,
    /**
     * ViemRwHgtClWdt - row height, column width in view mode
     *
     * @deprecated
     */
    ViemRwHgtClWdt = 23,
    /**
     * ViewFilter - filter in view mode
     *
     * @deprecated
     */
    ViewFilter = 24,
    MoveSheet = 25,
    /** DeleteSheet - delete the sub sheet */
    DeleteSheet = 26,
    HideSheet = 27,
    CopySheet = 28,
    RenameSheet = 29,
    CreateSheet = 30,
    SelectProtectedCells = 31,
    SelectUnProtectedCells = 32,
    SetCellStyle = 33,
    SetCellValue = 34,
    SetRowStyle = 35,
    SetColumnStyle = 36,
    InsertRow = 37,
    InsertColumn = 38,
    DeleteRow = 39,
    DeleteColumn = 40,
    EditExtraObject = 41,
    /** Delete - delete the unit file */
    Delete = 42,
    RecoverHistory = 43,
    ViewHistory = 44,
    CreatePermissionObject = 45,
    UNRECOGNIZED = -1
}

[VicKun4937]

hope above can help you @Maksych

[Maksych]

@VicKun4937
I don't understand what to do.
I want to do this with the workbook object.
Can you change this workbook object to enable the visibility of protected cell contents?

const wb = {
  id: 'workbook1-id',
  name: 'workbook1-name',
  sheetOrder: ['rId1'],
  sheets: {
    rId1: {
      id: 'rId1',
      name: 'Sheet1',
      cellData: { 0: { 0: { v: 'Hello World' } } },
    },
  },
  resources: [
    {
      name: 'SHEET_RANGE_PROTECTION_PLUGIN',
      data: JSON.stringify({
        rId1: [
          {
            id: '1',
            unitId: 'workbook1-id',
            subUnitId: 'rId1',
            unitType: 3,
            ranges: [
              { startRow: 0, endRow: 0, startColumn: 0, endColumn: 0 },
            ],
            viewState: 'othersCanView',
            editState: 'designedUserCanEdit',
            name: 'Permission 1',
          },
        ],
      }),
    },
  ],
}

[Maksych]

@VicKun4937 or it's can be done only via api calls?
This works, but want to do it only with data object.

        const data = {
            id: 'workbook1-id',
            name: 'workbook1-name',
            sheetOrder: ['rId1'],
            sheets: {
                rId1: {
                    id: 'rId1',
                    name: 'Sheet1',
                    cellData: { 0: { 0: { v: 'Hello World' } } },
                },
            },
            resources: [
                {
                    name: 'SHEET_RANGE_PROTECTION_PLUGIN',
                    data: JSON.stringify({
                        rId1: [
                            {
                                id: '1',
                                unitId: 'workbook1-id',
                                subUnitId: 'rId1',
                                permissionId: '1',
                                unitType: 3,
                                ranges: [
                                    { startRow: 0, endRow: 0, startColumn: 0, endColumn: 0 },
                                ],
                                viewState: 'othersCanView',
                                editState: 'designedUserCanEdit',
                                name: 'Permission 1',
                            },
                        ],
                    }),
                },
            ],
        }

        univerAPI.createWorkbook(data)

        const permission = univerAPI.getActiveWorkbook()?.getPermission()
        for (const resource of data.resources) {
            if (resource.name !== "SHEET_RANGE_PROTECTION_PLUGIN") continue
            const resourceData: { [key: string]: IRangeProtectionRule[] } = JSON.parse(resource.data)
            for (const rangeProtectionRule of Object.values(resourceData).flat()) {
                permission?.setRangeProtectionPermissionPoint(rangeProtectionRule.unitId, rangeProtectionRule.subUnitId, rangeProtectionRule.permissionId, permission.permissionPointsDefinition.RangeProtectionPermissionViewPoint, true)
                permission?.setRangeProtectionPermissionPoint(rangeProtectionRule.unitId, rangeProtectionRule.subUnitId, rangeProtectionRule.permissionId, permission.permissionPointsDefinition.RangeProtectionPermissionEditPoint, false)
            }
        }