#Orcaflex spreadsheet api disable code#
The code below sets the cell B5 in the first sheet as the current cell. Note:The specified Range must consist of one cell, otherwise this method Removed and the cell becomes the current cell and the active range. If the specified cell is not present in any selected range, then the existing selection is
If the specified cell is present in an already selected range, then that range becomes theĪctive range with the cell as the current cell. Scripts that use this method require authorization with one or more of the following scopes: Sheet - the new active sheet Authorization If true, the most recent selection of the new active sheetīecomes selected again as the new sheet becomes active if false, the new sheetīecomes active without changing the current selection. Logger.log(range.getA1Notation()) Parameters Name Var range = spreadsheet.getActiveSheet().getSelection().getActiveRange() The selection of first sheet is restored, and it logs D4:F4 Switch back to first sheet, and restore its selection. Switch to the second sheet to do some work. tActiveSheet(firstSheet).getRange('D4:F4').activate() Set the first sheet as the active sheet and select the range D4:F4. Var secondSheet = spreadsheet.getSheets() Var firstSheet = spreadsheet.getSheets()
Var spreadsheet = SpreadsheetApp.getActiveSpreadsheet() The Google Sheets UI displays the chosen sheet unless the sheet belongs to a Sets the specified cell as the current cell. SetActiveSpreadsheet(newActiveSpreadsheet) Sets the active sheet in a spreadsheet, with the option to restore the most recent selection Sets the specified list of ranges as the active ranges. Left cell in the range as the current cell. Sets the specified range as the active range, with the top Opens the spreadsheet with the given URL. Opens the spreadsheet that corresponds to the given File object. Returns an instance of the spreadsheet's user-interface environment that allows the script toĪdd features like menus, dialogs, and sidebars.Ĭreates a builder for a conditional formatting rule.Ĭreates a builder for a data validation rule. Returns the current Selection in the spreadsheet. Returns the current (highlighted) cell that is selected in one of the active ranges in theĪctive sheet or null if there is no current cell. Returns the list of active ranges in the active sheet or null if there are no ranges Returns the selected range in the active sheet, or null if there is no active range. Returns the currently active spreadsheet, or null if there is none.
#Orcaflex spreadsheet api disable series#
An enumeration of the types of series used to calculate auto-filled values.Īn enumeration of the possible banding themes.Īn enumeration of conditional formatting boolean criteria.Īn enumeration of the valid styles for setting borders on a Range.Īn enumeration of the possible paste types.Īn enumeration of the possible data execution error codes.Īn enumeration of the possible data execution states.Īn enumeration of the possible data source parameter types.Īn enumeration of possible data source refresh scopes.Īn enumeration of the possible data source types.Īn enumeration representing the data validation criteria that can be set on a range.Īn enumeration of date time grouping rule.Īn enumeration of possible developer metadata location types.Īn enumeration of the possible developer metadata visibilities.Īn enumeration of the possible dimensions of a spreadsheet.Ī enumeration of the possible directions that one can move within a spreadsheet using the arrowĪn enumeration of possible frequency types.Īn enumeration of the positions that the group control toggle can be in.Īn enumeration of conditional format gradient interpolation types.Īn enumeration of the functions that may be used to summarize values in a pivot table.Īn enumeration of the ways that a pivot value may be displayed.Īn enumeration representing the parts of a spreadsheet that can be protected from edits.Īn enumeration of the possible intervals that can be used in spreadsheet recalculation.Īn enumeration of relative date options for calculating a value to be used in date-based BooleanCriteria.Īn enumeration of the different types of sheets that can exist in a spreadsheet.Īn enumeration of the preset delimiters for split text to columns.Īn enumeration of possible theme color types.Īn enumeration of the strategies used for wrapping cells.Ĭreates a new spreadsheet with the given name.Ĭreates a new spreadsheet with the given name and the specified number of rows and columns.Įnables data execution for all types of data sources.Įnables data execution for BigQuery data source.
0 kommentar(er)
