SortKey Cell (Shape Data Section)
Evaluates to a string that influences the order in which items in the Shape Data window are listed.
Remarks
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 |