Forum Discussion

Erut313's avatar
Erut313
Brass Contributor
Oct 16, 2020
Solved

How to add Parameters in Worksheet Protection? Office Scripts

How can I allow formatting of columns? I tried to insert the WorksheetProtectionOptions but I keep failing.         function main(workbook: ExcelScript.Workbook) { let sheet = workbook.getW...
developer
excel
Excel for web
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 16, 2020

Erut313 

I'm not familiar with Excel Online, but here is a little bit of information that might help you in your plans. If not please just ignore it.

 

You cannot create a sheet protection in the WebApp and you cannot remove any existing sheet protection. However, you can now upload folders with protected sheets and since this update they can also be opened. Editing is possible as far as the set protection allows. I have learned that so far, but if it is different, I am very happy to be taught.

Edit a workbook that contains features unsupported by Excel for the web

https://support.microsoft.com/en-gb/office/edit-a-workbook-that-contains-features-unsupported-by-excel-for-the-web-7220105d-97ad-4c35-95c8-58d4bbfd14af?ui=en-us&rs=en-gb&ad=gb

 

Thank you for your understanding and patience

 

Nikolino

I know I don't know anything (Socrates)

 

  • Erut313's avatar
    Erut313
    Brass Contributor
    Oct 16, 2020

    NikolinoDE This did not help.

    • NikolinoDE's avatar
      NikolinoDE
      Platinum Contributor
      Oct 16, 2020

      Erut313 

      Certainly not the right person to help you with Javascript. But I would like to provide you with information that might help you. If not please just ignore my post.

      Thank you for your time and patience and wish you much success in your project.

       

      var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("TRAVAUX");
var debug = sheet.getName();
var protections = sheet.getProtections(SpreadsheetApp.ProtectionType.RANGE);

       https://stackoverflow.com/questions/60092877/sheet-getprotections-no-longer-works

       

      Nikolino

      I know I don't know anything (Socrates)

Resources