Skip to content

sortfield.md

Latest commit

 

History

History
58 lines (47 loc) · 1.75 KB

sortfield.md

File metadata and controls

58 lines (47 loc) · 1.75 KB
title workbookSortField resource type
description Represents a condition in a sorting operation.
ms.localizationpriority medium
author ruoyingl
ms.subservice excel
doc_type resourcePageType
ms.date 05/15/2024

workbookSortField resource type

Namespace: microsoft.graph

Represents a condition in a sorting operation.

Properties

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.

JSON representation

The following JSON representation shows the resource type.

{
  "ascending": true,
  "color": "string",
  "dataOption": "string",
  "key": 1024,
  "sortOn": "string",
  "icon": { "@odata.type": "microsoft.graph.workbookIcon" }
}