Custom FormulasContainer-Bound Versus Standalone ScriptsGetting Started with the Spreadsheet ServiceA Note About AuthorizationOpening the Active SheetThe Range ClassCreating a RangeReturning the Data RangeGetting the Values of a RangeWriting Values to a RangeReturning Selected DataReading and Writing for Partial RangesReading Attributes from a RangeWriting Attributes to a RangeInserting and Deleting Rows and ColumnsOpening Other SheetsIterating All SheetsGetting a Sheet by Name or IndexOpening Other WorkbooksCreating a Standalone ScriptAccessing Multiple WorkbooksWorking with Multiple WorkbooksUpdating SheetsShowing MessagesToastShowing Messages with ButtonsGetting InputGetting and Setting PropertiesDocument, User, or Script?Setting Properties in the RegistrySetting Properties Using the Properties ServiceChanging SettingsCustom FormulasCopy/Paste PortNative PortArguments to Custom FormulasPerformanceDocumentation and AutocompleteAdding Functions to MenusTablesConverting Values to an ObjectEmulating Tables in Apps ScriptListObject