Skip to content

Instantly share code, notes, and snippets.

@mindspank
Created October 26, 2015 20:45
Show Gist options
  • Select an option

  • Save mindspank/5318b0410c3133ef7e25 to your computer and use it in GitHub Desktop.

Select an option

Save mindspank/5318b0410c3133ef7e25 to your computer and use it in GitHub Desktop.
Grid change
app.getObject( "THE SHEET ID" ).then(function(obj) {
// Patch some properties on the sheet.
// In this case replace the column and row properties with new values
obj.applyPatches([{
qPath: '/columns',
qOp: 'replace',
qValue: '200'
},{
qPath: '/rows',
qOp: 'replace',
qValue: '100'
}])
})
.then(function() {
// Save the app, on QES you could just save
// the objects instead of the whole app.
return app.doSave()
})
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment