function testButton {
var ss= SpreadsheetApp.openById('YOUR_ID');
var sheet= ss.getSheetByName('TEST_A');
sheet.getRange('F3').clearContent();
ss.removeEditor(Session.getActiveUser());
}
Trigger use button, and not owner sheet. I try with my other gmail with share accsess editor.
in this case apps script coding i want to clear cell F3, after that remove editor the user. But this coding bugged it always running remove editor first, and then can't clear cell F3 because not have accsess.
and if i change with coding ss.removeEditor('YOUR_EMAIL');.... its same running remove first and then cannot clear cell F# because not have acsess.
Thank you, maybe this is a bug or can someone help me solve this case
User | Count |
---|---|
2 | |
1 | |
1 | |
1 | |
1 |