4

To select cells with a script: var sheet = SpreadsheetApp.getActiveSheet(); var rangeList = sheet.getRangeList(['C3', 'C7', 'C17', 'C56']); sheet.setActiveRangeList(rangeList); The last range in the list is set as the active range. To type in a dialog box: function promptRangesList() { var ui = SpreadsheetApp.getUi(); var response = ui.prompt('Comma-...


3

There are two basic categories of Apps Script files - Bound to the document (Sheet, Doc, Form) Stand Alone Bound files do not show up in your Google Drive. Stand Alone Apps Scripts files do show up in your Google Drive. You can create multiple projects inside of an Apps Script file, but projects in other files can not be searched or loaded into the code ...


2

Short answer At this time it's not possible to programmatically select multiple cells. Remarks The conditional formatting rule allowing to set several ranges separated by commas is an oddity of Google Sheets as other features like Named Ranges, Range Protection, doesn't allow this and Google Apps Script doesn't have a class for disjoint ranges. Anyway some, ...


1

I'm not sure that this is possible but if it was possible, to assign a function to a drawing you should know the name of the function and that function name should not be used on any other add-on or bounded script otherwise the results are unpredictable. If you want to try, the first that you should do is to get the function name. The best way to get this ...


1

Use Data->Named Ranges to manually accomplish the same thing (you will need to specify an entire column however as it will not auto-expand downward (without GAS). It is strange indeed that Google decided not to use the same table reference naming conventions but the reason is probably because they have no concept of tables. "Filter Views" are the closest ...


1

Publish a Google Add-on to the G Suite Marketplace Basic Concepts: You must use the G Suite Marketplace SDK in order to get to the “Publish” section for publishing an add-on, and you must first open the Google Cloud Platform for your specific project (apps script file) The G Suite Marketplace SDK must be enabled in the Google Cloud Platform The two ...


1

The FormCreator app was created using Google Apps Script. For more specific details see Develop Add-ons for Google Docs, Sheets and Forms


1

I think a hack is possible for one category at a time. Select the category, scroll down to the last entry (no See More), Ctrl+A, Ctrl +C, then in the top row of a spreadsheet Ctrl+ V, scroll down to the last entry and read off its row number. Currently I make it 221 for Business Tools and 424 for Productivity, for example.


1

I wasn't logged in when I asked this question, but here is the script I am using to achieve this if anyone wants to use it. function CopySheet() { var ss = SpreadsheetApp.getActiveSpreadsheet(); var data = ss.getSheetByName("sheet1").getDataRange().getValues() var newSh = ss.insertSheet(ss.getSheets()).setName(ss.getSheetByName("sheet1").getRange(4,1)....


Only top voted, non community-wiki answers of a minimum length are eligible