Correct way to protect workbook after load

[Tuan Ardouin]

Hello,

I don't understand what is the correct way to prevent the user from updating all the sheets in a workbook after loading them.

The property isProtected can't be applied to the whole workbook.

The method protectSheet takes a number or a string in argument, but I don't understand what the number should be, I tried 0 or 1 but only the active sheet is protected. And when using the method multiple time with the sheets name it also only freeze the current sheet.

My goal is to :

- Define the spreadsheet component

- Load the workbook and its spreadsheet(s) using openFromJson
- Protect all the sheets

What would be the correct way to do that in VueJS?

Thanks,
Tuan

[Sangeetha Priya Murugan]

Hi Taun, 

 

Thank you for contacting Syncfusion support. 

 

We have checked your reported requirement and it can be achievable in our spreadsheet by using the protectSheet method in actionComplete event as like as below. In this we have apply the protect sheet in actionComplete event for the switched sheets. 

 

 

<ejs-spreadsheet 

        ref="spreadsheet" 

        :created="created" 

        :actionComplete="actionComplete" 

        :heigth="height" 

      > 

      </ejs-spreadsheet> 

 

 

created: function () { 

      var spreadsheet = this.$refs.spreadsheet; 

      var parsedData = JSON.parse(this.response); // Parse the stringified response 

      spreadsheet.openFromJson({ 

        file: parsedData, 

      }); 

      // To protect the active sheet. 

      spreadsheet.protectSheet(1, this.protectSetting); 

       

    }, 

    actionComplete: function (args) { 

      var spreadsheet = this.$refs.spreadsheet; 

      // To protect the switched sheets 

      if (args.action === "gotoSheet") 

        spreadsheet.protectSheet( 

          args.eventArgs.currentSheetIndex, 

          this.protectSetting 

        ); 

    }, 

 

 

For your convenience, we have prepared the sample based on our suggestion. Please find the link below. 

 

Sample Link: https://codesandbox.io/s/blissful-dhawan-364ft?file=/src/App.vue 

 

Could you please check the above links and get back to us, if you need any further assistance on this. 

 

Regards, 

Sangeetha M 

[Tuan Ardouin]

Hi,

Thanks for your quick answer. It works like a charm if I change it a bit : 

In the created method it should be a `0` right ? 

      spreadsheet.protectSheet(0, this.protectSetting); 

It only works if I put the index 0, even is the default opened sheet is not at index 0.

Thanks,
Tuan

[Sangeetha Priya Murugan]

Hi Tuan, 

 

Thank you for your update. 

 

We have checked your suggestion and we would like to let you know that the protectSheet applied for active sheet only. So, only we have suggested to apply the protectSheet option in page switch actionComplete event.  Please get back to us if you need any further assistance on this. 

 

Regards, 

Sangeetha M