Stay organized with collections Save and categorize content based on your preferences.
SortSpecThe sorting specification.
Detailed documentationgetBackgroundColor()
Returns the background color used for sorting, or null if absent.
Color — The background color.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetDataSourceColumn()
Gets the data source column the sort spec acts on. Returns null if this sort spec is not acting on a data source column.
DataSourceColumn — The data source column the sort spec acts on.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetDimensionIndex()
Returns the dimension index or null if not linked to a local filter.
Integer — The dimension index.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetForegroundColor()
Returns the foreground color used for sorting, or null if absent.
Color — The foreground color.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsgetSortOrder()
Returns the sort order.
ReturnSortOrder — The sort order.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsisAscending()
Returns whether the sort order is ascending.
ReturnBoolean — true if the sort order is ascending, or false otherwise.
Scripts that use this method require authorization with one or more of the following scopes:
https://www.googleapis.com/auth/spreadsheets.currentonlyhttps://www.googleapis.com/auth/spreadsheetsExcept as otherwise noted, the content of this page is licensed under the Creative Commons Attribution 4.0 License, and code samples are licensed under the Apache 2.0 License. For details, see the Google Developers Site Policies. Java is a registered trademark of Oracle and/or its affiliates.
Last updated 2024-12-02 UTC.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Missing the information I need","missingTheInformationINeed","thumb-down"],["Too complicated / too many steps","tooComplicatedTooManySteps","thumb-down"],["Out of date","outOfDate","thumb-down"],["Samples / code issue","samplesCodeIssue","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2024-12-02 UTC."],[[["`SortSpec` defines the specifications for sorting data, such as sort order, colors, and the data source."],["It provides methods to retrieve information about the sort specification, including background and foreground colors, sort order, and the data source column being used."],["You can determine if the sort order is ascending using the `isAscending()` method and obtain the dimension index with `getDimensionIndex()`."],["All methods within `SortSpec` require authorization with specific scopes related to spreadsheet access."]]],["SortSpec defines the criteria for sorting data. Key actions include retrieving the background and foreground colors used in sorting, if any. It fetches the data source column being sorted, or returns null if not present. It can retrieve the dimension index if linked to a filter. The sort order itself, along with whether the sorting is ascending, can also be obtained using the methods `getSortOrder()` and `isAscending()` respectively.\n"]]
RetroSearch is an open source project built by @garambo | Open a GitHub Issue
Search and Browse the WWW like it's 1997 | Search results from DuckDuckGo
HTML:
3.2
| Encoding:
UTF-8
| Version:
0.7.4