IssueTracker

please implement this!!

We need this feature...

Hi google ... Please implement this

Please implement this feature, Google.

This is very fundamental to produce sheets for non technicians

We need this cery much

Hope it is coming along...

We need this very much [2]

[Comment deleted]

yes, very basic and very necessary .. please implement ...

[Comment deleted]

Please implement the functionality to add/edit/delete "Named and protected ranges" to Google Spreadsheet Java API.

This sure would be useful

Please implement this feature, Google.

This sure would be useful

it would be very cool and useful, I do without this script is very bad sleep...

Really, waiting for this.

Also waiting for this!

Like others, i think it would be very usefull

Waiting also

Google. It is like 5 minutes work for you programmers farm.
First you kill Google reader, then you don't want to support docs...

How to script named and protect range in spreadsheet ?

This sure would be useful.

Would be very usefull to protect ranges in spreadsheets with a lot of users, its a pain to do it by hand.

Google... It would be great to hear more about when this issue will be dealt with...

Any ETA on this highly-desirable functionality?

I need this feature!!!

Need this feature

When will you implement this?

Just wondering: why this issue is not even prioritized.
This is the 2nd most starred issue. Something tells me it'll end up as Won't fix.

I like Google for a lot of reasons, but this (admittedly 2-year-old and rather long) post goes a long way toward explaining the state of the G-Apps Script department: https://plus.google.com/112678702228711889851/posts/eVeouesvaVX

I need this feature!!!

please implement this!!

When this problem is solved?

please implement this feature

Please implement this feature!

Please implement this feature!

when can we expect for this feature?

[Comment deleted]

How hard is it to create a method for the range object that sets protection? At least let us know if this is being prioritized and/or if there is an ETA on getting this done.

I and a lot of people really need this as can be seen in this thread. Please at least someone respond so that we know this is the best avenue to get things changed.

Thank you.

waiting for this feature to release...

Thank you for your interest in this feature. I'll pass your feedback along to the product team so they can prioritize the work appropriately.

The problem gets worse because of the fact that apps script will automatically give edit" permissions to all ranges when you add new editors through addEditors(email).

If you just add an editor to a spreadsheet with existing protected ranges, those ranges do not get edit permissions for the new editor. If apps script's addEditor would behave like that, we could use preconfigured spreadsheet templates that already have the range permissions needed, and we could make copies of the templates.

yes... much appreciate if could implement soon, right now am doing tedious manual for every spreadsheet i shared.

Could you please implement this feature as soon as possible?

Guys, I hope all of you who comment in this thread and request the feature, also star the isuue on the top left of the page.

Yes, this would be a useful feature. Here are two ideas that I believe would go a long way toward alleviating the pain that we experience when stamping out multiple spreadsheets with (even moderately) complex range permissions:

1. Provide a way to change permissions of groups in bulk. I have a spreadsheet that needs to be replicated which has 64 ranges that need to be protected. Changing permissions one-by-one takes approximately 25 minutes with the current workflow. A simple screen displaying the matrix of users and ranges, and providing the ability to set permissions for each intersection would reduce this to a 3 minute exercise.

2. I'm sure this request is logged elsewhere, but if we had the ability to register non-contiguous named ranges, then we could reduce the number of ranges that need to be configured, which would also alleviate the workflow problem.

It would be particularly interesting to have range protection excel like
from the owner too, this is important to release sheets to customers
protecting the most critical parts from inadvertent edits

I agree that protecting from the owner as well would be very useful, but this is the Apps Script issue tracker, and that's something to ask to the Drive team. Talking about it here has no effect :(

Please add this feature soon..!!

I was thinking to the API, but you're right indeed, without the
functionality it can be a problem :-)

please implement this feature. I need it now!

I posted a quick and dirty workaround for those who are interested at http://stackoverflow.com/questions/13352543/preventing-changes-to-a-cell-in-google-spreadsheet/18872688#18872688. Not perfect but I hope it helps.

I need to permanently lock cells down so no one can modify it. In your case, removing data validation from this cell, unlock it. That could be done by anyone. We don't someone modify the costing sheet without permission. In this case Protected Range is the only solution, unfortunately all sharing settings are clear when document submitted to Google Templates and only way to recreate those sharing settings are onOpen trigger, when document is being selected by user. Unfortunately there is no API to support this functionality. The other reason to go back to Excel & Outlook.

Having waited for this issue to resolve for 1.5 years. Unstarring it since i don't want to get notifications. I'm sure it's a  business tier that prevents google from implementing it. Have fun guys, i'm out!

This feature would be incredibly useful. I have to create dozens of nearly identical files and right now I will have to go through all of them to manually protect the cells that can't be edited by other users. This will take forever.

add this feature please. my client need this !!!!!!!!!!!!

I need this badly.

come on guys, please implement this !!!

Just like #59 I also am tired of getting emails, I will be unstarring this issue not because I no longer want it resolved but tired of the useless emails.

#64 really?! why don't you just mute/filter the emails?

Come on Google! What are you waiting for enable this feature? Please solve this issue

Please add this feature. Badly needed

Plz add this feature

[Comment deleted]

plz add feature

Hopefully, we'll get this feature in the new Google Spreadsheet...in a few months??? https://support.google.com/drive/answer/3543688

Would be usefull

Please implement this.

We definately need this

please implement

Implement this or we will use OpenOffice and Excel! :)

Please implement it!!!!

please implement!

We need to prevent cells for edition on Google spreadsheets. Besides, we also nees to have multiple usimpactingulating a spreadsheet without impacting each other's view. Google, start from BASIC

plz

I am waiting

Yes it will be very very useful. In the meantime if the copy of a range protected spreadsheet keeps the range protection configuration could be a interim satisfactory situation :-(now the range is kept, the members are kept but the privileges goes to can edit and is impossible to change it programmatically)

I am waiting too.

I need it also, please hurry

Eagerly waiting for the method to get implemented.

I need it too

we can wait, wait and wait. Google likes to keep people uninformed.

any updates on this request?

No updates at this time. We'll update this issue when there is news to
share.

I thought I'd share a workaround that helps in some small set if use-cases.

If you programmatcically insert a column or row inbetween a manually locked range the newly inserted cells that fall within the locked range are also locked.

This way if your use case involves locking of newly created cells, you may create a template sheet, lock a range in it and then create the new cells within that range.

Hope this helps someone.

Please implement this.

please implement this this would be a great addition.

please implement this.

please implement this. Thanks

need it

Pleasem implenet this!

please implement this.

We need this feature...

Please implement this. That is the only thing why we still use Excel.

So many possibilities if you implement this...

please!! it's the killer feature. excel will gone forever if you will make it. right now all the colaboration features of google docs have not much sence if that is so hard to protect ranges from public (by hard I mean doing it manually using mouse). The script functions will save alot of time.

How much Microsoft pay you for not implementing it?))

Just checked the add-ons store, only 37 add-ons for spreadsheets. If there was the ability to run the script as owner to allow the edit of protected ranges, I would add 3 add-ons in the next 3 months. Each one could change the way google spreadsheets are used. I have too many ideas for Google not to implement this.

Ability to edit protected ranges as the owner is not with this issue is about. It is about setting the protected ranges to begin with. It has been two years since it has been filed and yet this obviously important functionality has still not been implemented. Even when Google released a new version of Spreadsheets that completely revised how Protected Ranges work (yet still not making it a bit unintuitive to use, needing to save it like 3 times before it is accepted) this was left untouched.

Has anyone found a good workaround? I have tried data validation but this doesn't prevent adding/removing rows/columns. Neither does an onEdit trigger writing back any information. I tried not copying the spreadsheet but the invididual sheets to an existing spreadsheet, without the desired effect. In fact, this doesn't copy the protected ranges at all, not even without protection. There just does not seem to be a way to have a script make a duplicate of a spreadsheet without breaking the cell protection.

why it take all this time? it's very important thing and easy to develop, google!

[Comment deleted]

Here is another plea to implement this capability which would deliver tremendous value.

204 stars, almost 100 more than the next listed issue. Please fast-track this.

I teach a "community college" class in starting a business (actually TAFE in Australia). So I'm in front of probably 120 people a year. The Excel spreadsheet I use imports nicely into Google Docs. But it does not import protection. I could script protection except that the API doesn't support this.  So they all use Excel (or LibreOffice).

please implement this. we need this in our company. We employ 80 people.

pls implement this, very important one.

2 years and this functionality still hasn't been added...

just discovered the bleeding edge of non-features...

i need this!!!!

[Comment deleted]

Quite surprised the API does not support it yet

Yes, Google Team, pls implement this feature 'cos a lot of people expect it

This feature is critical! I have to manage spreadsheets for more than 250 clients. Without this feature last year they screwed up their spreadsheets leading to much wasted time.

Also would like this feature for an enterprise app serving 50+ schools.

This feature is a must have Google. Most of us are being forced to update permissions on files by hand. The other features in script have enabled us enterprise developers to create complex spreadsheet-based apps and systems and when the absence of this feature chokes these systems, it gets really frustrating! Please include this asap!

I also need this feature

por favor implementen esto, no quiero migrar a excel en el 2015

please implement this. any ideas when that can be implemented?

Please implement this, a big requirement when sharing sheets with a wide audience..

yes this is needed very badly.........

I need this too.

I need this feature!

same as me.

I need this as well

With millions of users... and only a few hundred people needing,  its no wonder.   But it really sucks.  Google sheets could rule the sheet world if this glaring problem were fixed.    You have got to be able to easily lock down a sheet except for the cells that the user is allowed to change..  its crazy to develop something and then discover you can not prevent users from whacking formulas in adjacent cells.   Especially since the cursor advances to the next cell if you enter data.  So users are stepping on formulas in the cells they are not supposed to be touching.  DOUBLE DUH!!

Please .... I need this for my sports organisation.

My Co-workers Keeps Deleting FUNCTIONS! please add this feature! We've been waiting for more than TWO YEARS!

please add this feature

Unfortunately I had come to the conclusion that clearly Google doesn't really care about this. I guess these code.google.com pages are just a lip service. Unfortunately, as someone else will probably come soon and will provide a much better solution than Google, or I guess they don't believe so...

please implement this. when you duplicate the sheet, the range protection is removed and we need to re-create it.

Thanks

[Comment deleted]

Yes, not to make it a priority for automate or improve functionality to protect ranges of cells on a spreadsheet ...we are really disappointed and it's a shame to use it only like that today !

disappointed too. Was thinking of switching over but for now i'll keep using dropbox...

Hay alguna fecha , Hay alguna forma de solucionarlo ?

Tengo mas de 200 planillas que tengo que modificar a mano

add the damn feature. currently you can edit the permissions of protected ranges only by clicking on each range, then on each userm, then selecting an option, then clicking ok, then clicking ok again, then clicking ok again. this is idiotic. the main scenario for protected ranges is to protect formula ranges. why not allow the administrator to select multiple ranges and edit permissions for the entire batch? or at least make this accessible through the api! i've already had to convert everything to array formulas to get around the fact that range protection prohibits sorting etc. but the permissions wtf is impossible to get around.

We surely need this one.

Please implement this feature, Google.

Please implement this feature.

please implement this

Pls implement this

please implement this

Please implement

Pls implement this

Hellooooo is anybody even listeing to this feature request anymore? The least you could do is reply with a "working on it" or something..

Pls implement this feature

Please implement this feature

There's API available for protecting the entire sheet, how come we don't have it for specific cells or range?

Por favor, nos ajudem!! Please, help us!!

here is a simple application: We email sheets to 100s of people as a kind of multipart form. Different sheets (parts of the form) have different deadlines.  We want to lock the sheets as the deadlines come due but still make them "view only" so the applicants can see what they entered we can automatically fill in other parts of the form with the entered data.

Please allow us to control sheet protection within the scripting/programming environments.

Please implement this feature.

Please do it, ASAP.

WOOH ! Great ... thank you very much for the new sheets protection !!
Good way ... really !
Now, more than to see if it is possible to play with this ... from google app scripts ;)
Thank you again
Best regards

Can anyone share what the script would look like when you want to Protect/unProtect Range

I'm happy For the improvements in Spreadsheet , but can not find how to use the protected ranges from Google Apps Script. Is there any example?

Please, i need this! :)

Please implement the functionality to add/edit/delete "Named and protected ranges" to Google Spreadsheet Java API.

Please I need this also!

Please release this feature.

Come on! #163 request and nothing! I need this very much. Thanks

Looks like this exists now: http://googledevelopers.blogspot.com/2015/02/control-protected-ranges-and-sheets-in.html

Today, we have launched the ability to programmatically create and manipulate protected ranges and protected sheets with Apps Script.

With the new Protection class in the Spreadsheet service, your scripts can touch every aspect of range or sheet protection, just like in the new UI. (The older PageProtection class, which had more limited features, will be deprecated, but will stick around in case you need to work with older spreadsheets. The new Protection class only applies to the newer version of Sheets.)

You can find more details here:

http://googledevelopers.blogspot.com/2015/02/control-protected-ranges-and-sheets-in.html

https://developers.google.com/apps-script/releases/#february_2015

https://developers.google.com/apps-script/reference/spreadsheet/protection

Happy Scripting!

Wowwww ! Great! and Thanksssss !

Yeah! Lots of thanks!

Great! I am going to check that right now.

Amazing!! This made my day! I'm firing up my script editor right now. :D thank you so much. You guys rock!

Great work guys.
Kudos.
 Il 11/feb/2015 21:24 <google-apps-script-issues@googlecode.com> ha scritto:

very good news. THANKS A LOT

YESSSS! Thank you very much for your work!

WOW  Good work Guys. let me test.

Good work Guys. let me test.

Nice work guys!

I'm running into issues removing the ranges after I create them? I could certainly use a little help!!

function remove() {
 // Remove all range protections in the spreadsheet that the user has permission to edit.
 var ss = SpreadsheetApp.getActive();
 var protections = ss.getProtections(SpreadsheetApp.ProtectionType.RANGE);
 for (var i = 0; i < protections.length; i++) {
   var protection = protections[i];
   if (protection.remove()()) {
     protection.remove();
   }
 }
}

[Comment deleted]

[Comment deleted]

Hello guys, great work really !
It would still a little cool feature to add ... I want to say about the cells excluded from the protection of the sheet, there should be the possibility for the owner or editors, so users can not change the format or data validation just have the ability to enter data and that's enough ...
It would be really "user friendly"
Thank you again for that

Hola Muchachos , gran trabajo !!!!
Muchas GRACIAS !
---
Hello guys, great work

One thing more awesome and very nice ... would be to add a feature to protect the user against himself for complex formulas as exist natively  on other spreadsheets. It's very useful in daily work... you didn't think that ?
Thank you again for your work !

Good work!
It would be even better if the protection could be applied on the Owner and Editor, or at lease the Editor.
Thanks again.

As well said above "the protection could be applied on the Owner",  this feature is really lacking for protected spreadsheets very useful way in the daily work ...
Thanks you again ...

Protection applied to the Editor will be very nice

[Comment deleted]