workbookSortField

Azure ADCollaborationContactsDocumentsEmailGraphIdentityMicrosoftOffice 365PresentationsProductivitySpreadsheetsT1Tasks

Properties

Name	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	object	Represents the icon that is the target of the condition if the sorting is on the cell's icon.
key	number	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.
@odata.type	string

View JSON Schema on GitHub

JSON Schema

{
  "$schema": "https://json-schema.org/draft/2020-12/schema",
  "$id": "#/components/schemas/microsoft.graph.workbookSortField",
  "title": "workbookSortField",
  "required": [
    "@odata.type"
  ],
  "type": "object",
  "properties": {
    "ascending": {
      "type": "boolean",
      "description": "Represents whether the sorting is done in an ascending fashion."
    },
    "color": {
      "type": "string",
      "description": "Represents the color that is the target of the condition if the sorting is on font or cell color.",
      "nullable": true
    },
    "dataOption": {
      "type": "string",
      "description": "Represents additional sorting options for this field. The possible values are: Normal, TextAsNumber."
    },
    "icon": {
      "anyOf": [
        {
          "$ref": "#/components/schemas/microsoft.graph.workbookIcon"
        },
        {
          "type": "object",
          "nullable": true
        }
      ],
      "description": "Represents the icon that is the target of the condition if the sorting is on the cell's icon."
    },
    "key": {
      "maximum": 2147483647,
      "minimum": -2147483648,
      "type": "number",
      "description": "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).",
      "format": "int32"
    },
    "sortOn": {
      "type": "string",
      "description": "Represents the type of sorting of this condition. The possible values are: Value, CellColor, FontColor, Icon."
    },
    "@odata.type": {
      "type": "string"
    }
  }
}