SortDescriptor

23 Sep 20251 minute to read

Specifies the criteria for sorting in a spreadsheet.

Properties

field string

Specifies the column by which to sort.
This is the name of the column or field on which sorting should be applied.

order SortOrder

Specifies the sort order.

• Ascending: Sorts the data from smallest to largest (A-Z, 1-10).
• Descending: Sorts the data from largest to smallest (Z-A, 10-1).

sortComparer Function

Specifies a function used to customize the sorting logic.
You can use this function to define custom sorting rules beyond basic ascending or descending order.