displaySorting

Type: Integer

Availability: Read or write at run time only

The displaySorting property of the JadeTableSheet class displays a sorting indicator after the text in the fixed row cells of a table to indicate an ascending or descending sort order for the column. The image for the sorting indicator is an up or down arrow.

The property is ignored if the sheet does not have a fixed row or the cells in the fixed row already contain a picture.

The values for displaySorting and their effects are summarized in the following table.

Table Class Constant	Value	Description
DisplaySorting_None	0	Default value, which indicates no sorting indicator is displayed.
DisplaySorting_First	1	First sort column displays a sorting indicator in the cell in the first fixed row, depending on the sortAsc property for the column.
DisplaySorting_AllColumns	2	Displays a sorting indicator for all sort columns.
DisplaySorting_Numbers	3	Displays a sorting indicator for all sort columns where the image includes an integer that indicates the sort preference in the range 1 through 6.

When display sorting is specified:

The spacing of the image from the text varies, depending on the space available, and it is in the range 3 through 15 pixels.
The arrow is displayed after any cell text and the image takes precedence over the text.
The picture is displayed as if the stretch property is set to Stretch_None_Picture_First (2) and the cell text is displayed as if the partialTextIndication property is set to true.

Note that the display is based on the value of the sortAsc property for the cell, regardless of how the table is actually sorted. If the cell has no text, the arrow is centered; otherwise the cell and arrow are displayed according to the effective alignment property of the cell.

Setting the value of the displaySorting property affects the size of a column that has the autoSize property set, to allow for the size of the sorting indicator. If you change the width of a column, the size of the image does not change and any text in the cell is truncated, if necessary.

The code fragment in the following example shows the use of the displaySorting property.

table1.sortColumn[1] := 1;
table1.sortColumn[2] := 3;
table1.sortAsc[2] := false;
table1.accessSheet(1).displaySorting := Table.DisplaySorting_AllColumns;