Excel.Interfaces.TableSortLoadOptions interface

Manages sorting operations on Table objects.

Remarks

[ API set: ExcelApi 1.2 ]

Properties

$all

Specifying $all for the load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 load options loads all the scalar properties (such as Range.address) but not the navigational properties (such as 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 ]