Oct 16 2020 06:26 AM - edited Oct 16 2020 12:01 PM
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.getWorksheet("By Item");
sheet.getProtection().protect(ExcelScript.WorksheetProtectionOptions.allowFormatColumns);
}
Here is the link.
Oct 16 2020 07:53 AM
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.
Thank you for your understanding and patience
Nikolino
I know I don't know anything (Socrates)
Oct 16 2020 09:57 AM
@NikolinoDE This did not help.
Oct 16 2020 11:04 AM
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)
Oct 16 2020 02:35 PM
Solution
Thanks for the post. I replied here - https://stackoverflow.com/questions/64393820/protect-worksheet-in-office-scripts-with-options/643953...
Oct 17 2020 02:40 AM
Oct 16 2020 02:35 PM
Solution
Thanks for the post. I replied here - https://stackoverflow.com/questions/64393820/protect-worksheet-in-office-scripts-with-options/643953...