Spread Windows Forms 18 Product Documentation

Sort Dialog

You can sort rows or columns using the Sort dialog of the Spread Designer. To open this dialog, from the Data menu, select the Sort icon. In the Sort dialog, as shown in the figure, select what to sort and the order of sorting. When done, click OK.

Sort Dialog in Spread Designer

This dialog has the following items:

Item	Description
Sort by	Set whether to sort by content in rows or columns (Sorting by rows moves rows based on columns as keys; sorting by columns moves columns based on rows as keys)
1st Key	Set the first sort key (column or row on which to sort first)
2nd Key	Set the second sort key (column or row on which to sort second)
3rd Key	Set the third sort key (column or row on which to sort third)
Move Entire Rows Move Entire Columns	Select to move entire rows or columns when sorting instead of moving just the data in the selected rows or columns

For more information on the sort settings, refer to Managing Data on a Sheet in the Developer’s Guide.

For more information on how to do this in code, refer to the SortInfo class.

Sort Dialog

See Also