SortKey cell (Custom Properties section)

See also       

Evaluates to a string that influences the order in which items in the Custom Properties dialog box and window are listed.

Remarks

The calculation used to compare SortKey values is locale specific and case insensitive. If SortKey values are equal, the custom properties are listed in row order. A custom property with no sort key is listed before custom properties that contain a sort key.

Following is an example of using sort keys to display the custom properties in the Custom Properties dialog box and window in the order: Item Number, Quantity, Price.

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

Row	Label	SortKey
Prop.Item	Item Number	1
Prop.Price	Price	3
Prop.Quan	Quantity	2

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

Cell name:

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

To reference 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