Excel.Interfaces.TableSortLoadOptions interface

Manages sorting operations on Table objects.

Remarks

[ 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

Specifies the current conditions used to last sort the table.

matchCase

Specifies if the casing impacts the last sort of the table.

method

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

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

Specifies the current conditions used to last sort the table.

fields?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

matchCase

Specifies if the casing impacts the last sort of the table.

matchCase?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]

method

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

method?: boolean;

Property Value

boolean

Remarks

[ API set: ExcelApi 1.2 ]