Excel.Interfaces.TableSortLoadOptions interface

Manages sorting operations on Table objects.

[ API set: ExcelApi 1.2 ]

Properties

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

fields

Represents the current conditions used to last sort the table. Read-only.

[ API set: ExcelApi 1.2 ]

matchCase

Represents whether the casing impacted the last sort of the table. Read-only.

[ API set: ExcelApi 1.2 ]

method

Represents Chinese character ordering method last used to sort the table. Read-only.

[ API set: ExcelApi 1.2 ]

Property Details

$all

Specifying $all for the LoadOptions loads all the scalar properties (e.g.: Range.address) but not the navigational properties (e.g.: Range.format.fill.color).

$all?: boolean;

Property Value

boolean

fields

Represents the current conditions used to last sort the table. Read-only.

[ API set: ExcelApi 1.2 ]

fields?: boolean;

Property Value

boolean

matchCase

Represents whether the casing impacted the last sort of the table. Read-only.

[ API set: ExcelApi 1.2 ]

matchCase?: boolean;

Property Value

boolean

method

Represents Chinese character ordering method last used to sort the table. Read-only.

[ API set: ExcelApi 1.2 ]

method?: boolean;

Property Value

boolean