| title | workbookSortField resource type |
|---|---|
| description | Represents a condition in a sorting operation. |
| ms.localizationpriority | medium |
| doc_type | resourcePageType |
| ms.subservice | excel |
| author | ruoyingl |
| ms.date | 08/01/2024 |
Namespace: microsoft.graph
[!INCLUDE beta-disclaimer]
Represents a condition in a sorting operation.
| Property | Type | Description |
|---|---|---|
| ascending | Boolean | Represents whether the sorting is done in an ascending fashion. |
| color | string | Represents the color that is the target of the condition if the sorting is on font or cell color. |
| dataOption | string | Represents additional sorting options for this field. The possible values are: Normal, TextAsNumber. |
| icon | workbookIcon | Represents the icon that is the target of the condition if the sorting is on the cell's icon. |
| key | int | Represents the column (or row, depending on the sort orientation) that the condition is on. Represented as an offset from the first column (or row). |
| sortOn | string | Represents the type of sorting of this condition. The possible values are: Value, CellColor, FontColor, Icon. |
None.
The following JSON representation shows the resource type.
{
"ascending": true,
"color": "string",
"dataOption": "string",
"key": 1024,
"sortOn": "string"
}