google apps script - Error encountered when accessing Spreadsheet via getActiveSheet() -- works correctly any other way -


i've been working set of scripts in google apps script (specifically on set of spreadsheets) on month now, , of sudden getting errors time try access sheet via spreadsheetapp.getactivesheet().

i assumed threw off in 1 of functions somewhere, until wrote test function didn't rely on of own code:

function basicfunctionality() {   var sheet = spreadsheetapp.getactivesheet();   var range = sheet.getrange('b2');   var vals = range.getvalues();   browser.msgbox(vals[0][0]); }

running function returns error...

unknown sheet name (line 5)

...which seem imply issue "getvalues" line, except when access sheet means other getactivespreadsheet() (e.g. getsheetbyname(), getsheets()[0]), function runs end , returns expected result.

now, i'm still assuming issue in code files, , not google bug -- i've run out of ideas. have tried copying script files new spreadsheet document/project -- test function works if it's thing port over, once rest of project gets in there, issue crops again (even if comment every other file out entirely, bizarre part).

is there way have conceivably "broken" getactivesheet()? or misidentifying problem?

thanks in advance insights!

your code works fine me. attached function drawing dropped spreadsheet, ran it, , returned data cell b2 in sheet.

could try again check it's still broken you?

is possible script running in context gas doesn't know active sheet is? when ran code in debugger seemed pick first sheet active sheet regardless of sheet had last had input.


Comments

Post a Comment

Popular posts from this blog

jquery - Invalid Assignment Left-Hand Side -

i trying assign class tag via jquery, resulting in error through firebug says "invalid assignment left-hand side" on fourth line below. <cfoutput> $('.pngfix a').each(function(index) { var hreflink = $(this).attr("href"); if (hreflink.tolowercase() = '../audio.cfm') { $(this).addclass('audioimg'); } }); </cfoutput> looking around online, looks syntax problem, don't seem see it... any tips? thanks if (hreflink.tolowercase() = '../audio.cfm') that attempts assign value, rather check equality. change = operator == .
Read more

java - Play! framework 2.0: How to display multiple image? -

i need display gallery of photos. here template: @(photos: list[photo]) @title = { <bold>gallery</bold> } @main(title,"photo"){ <ul class="thumbnails"> @for(photo <- photos) { <li class="span3"> <a href="#" class="thumbnail"> <img src="@photo.path" alt=""> </a> </li> } </ul> } and here controller method: public static result getphotos() { return ok(views.html.photo.gallery.render(photo.get())); } and here photo bean : @entity public class photo extends model { @id public long id; @required public string label; public string path; public photo(string path, string label) { this.path = path; this.label = label; } private static finder<long, photo> find = new finder<long, photo>( long.class, photo.class); public static list<phot...
Read more

gmail - Is there any documentation for read-only access to the Google Contacts API? -

i want read-only access user's google contacts. there stackoverflow member wanted this, , received following answer : yes, there is, use https://www.googleapis.com/auth/contacts.readonly scope , "view contacts". this exchange reference read-only access google contacts can find using google. simply using access token obtained attempt read usual google contacts api (i.e. https://www.google.com/m8/feeds ) fails insufficient permissions. similarly, using google contacts api on new target fails 404 errors (for example https://www.googleapis.com/auth/contacts.readonly/default/full ). is there documentation anywhere on how use api, or permissible way access google contacts api full read-write access?
Read more