Google New Sheets Protection Issues -


i experiencing strange problems protection in google new sheets. have created demo of experiencing. url sheet is:

https://docs.google.com/spreadsheets/d/1ibaiqu6on48ql_wm3terl9tqg6dfsbktc86jelv0kbo/edit?usp=sharing

i have protected sheet edit owner except rows 5 7 using 'sheet protect except cells' method under 'data - protected sheets , ranges...'

i have simple user function menu invoked on open wich contains simple google apps script insert given number of rows (code below).

the following happening when user accesses sheet:

  1. the basic protection seems working. user can edit rows 5 7.
  2. the insert row function (selected under user functions menu) produces 'service error: spreadsheets'.
  3. if user tries delete of 3 unprotected rows message 'can't save changes. copy recent changes, revert earlier version...' appears in red box @ top of screen. clicking on 'revert earlier version...' link reverses delete.

if remove protection 100% user - insert rows funtion - delete rows etc.

the functionality have reproduced here similar have been using in old sheets years without problems (i.e. protecting areas of spreadsheet edit shared users).

i must add, posted issue insert row function not working couple of days ago.

here's function code:

function onopen() {   var ss = spreadsheetapp.getactivespreadsheet();   var menuentries = [{name: "insert rows", functionname: "insertrows"}];   ss.addmenu("user functions", menuentries);  }  function insertrows() {   var numrows = browser.inputbox('insert rows', 'enter number of rows insert', browser.buttons.ok);   var ss = spreadsheetapp.getactivespreadsheet();   var sheet = ss.getactivesheet();   var curs = sheet.getactivecell();   var cursrow = curs.getrow();   var curslastcol = sheet.getlastcolumn();   sheet.insertrowsafter(cursrow, numrows);    var source_range = sheet.getrange(cursrow,1,1,curslastcol);   var target_range = sheet.getrange(cursrow+1,1,numrows);   source_range.copyto(target_range);    browser.msgbox('insert rows', +numrows+' rows inserted.', browser.buttons.ok);  }

can this. have large customers have built complex online spreadsheets don't function correctly under new sheets.

try setting project trigger onopen() rather using simple onopen(). runs privileges rather of current user. click on resources/current project triggers , add new trigger.


Comments

Post a Comment

Popular posts from this blog

toolbar - How to add link to user registration inside toobar in admin joomla 3 custom component -

im trying write component admin side , need add user creation. dont want duplicate existing codes add link. know how add task not simple link toolbar. thx help. if wanting button opens new user screen can try in component: $bar = jtoolbar::getinstance('toolbar'); $bar->appendbutton('link', 'users', 'new user','index.php?option=com_users&task=user.add'); you need add view.html.php file wherever you're creating toolbar. is need?
Read more

linux - disk space limitation when creating war file -

i have 1 gb disk space limitation hosting app , have used 700mb of it. however want create war file directory big (around 600mb) using command : jar -cvf root.war folderpath that's why encounter quota limitation , can't following. i'm looking way delete folder content when it's applying archive conserve disk space take note can't install zip tool in ssh shell ~ the code works on test directories, test first anyway, deletes files. it's not efficient. assumptions: 300mb free space, in destructively compress 600mb folderpath directory. none of files big -- if file in folderpath 300mb or larger, fail. notes: if ' $out ' file exists, nothing. first find pipes file list while , if ' $out ' doesn't exist in loop, create it, don't update -- if does exist, update it. each pass adds 1 more file, deletes unless file directory. after loop finishes delete empty directories too. unset u ; in=folderpath ; out=roo...
Read more