This documentation is archived and is not being maintained.

SortKey Cell (Shape Data Section)

Evaluates to a string that influences the order in which items in the Shape Data window are listed.

The calculation used to compare SortKey values is locale-specific and case insensitive. If SortKey values are equal, the shape data is listed in row order. Shape data that have no sort key are listed after shape data that contain a sort key.

Following is an example of using sort keys to display the shape data in the Shape Data window in the order: Item Number, Quantity, Price.

Row, Label, and SortKey refer to cells in the shape data row. In this case, the shape data rows have been named.

Row

Label

SortKey

Prop.Item

Item Number

1

Prop.Price

Price

3

Prop.Quan

Quantity

2

To get a reference to the SortKey cell by name from another formula, or from a program using the CellsU property, use:

Cell name:

Prop.Name.SortKey where Prop.Name is the name of the custom property row

To get a reference to the SortKey cell by index from a program, use the CellsSRC property with the following arguments:

Section index:

visSectionProp

Row index:

visRowProp + i where i = 0, 1, 2...

Cell index:

visCustPropsSortKey

Show: