Export (0) Print
Expand All
Expand Minimize

SortKey Cell (Shape Data Section)

Last modified: June 17, 2011

Applies to: Office 2013 | Visio 2013

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:
© 2014 Microsoft