[]
        
(Showing Draft Content)

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.

image

This dialog has the following items:

Item

Description

Add Level

Add another column to sort by

Delete Level

Delete a column to sort by.

Copy Level

Copy a column to sort by.

Column

In the Sort by box, select the first column that you want to sort.

Sort On

Select the type of sort. Do one of the following:

  • To sort by text, number, or date and time, select Cell Values.

  • To sort by format, select Cell ColorFont Color, or Cell Icon.

Order

Select A to Z or Z to A.

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.

See Also

Cell Type Dialog

Conditional Formatting Dialog

Custom File Options Dialog

Go To Cell Dialog

Row Height or Column Width Dialog

Row or Column Insert or Delete Dialogs

Shape Properties Dialog

Shape Shadow Properties Dialog

Sheet Settings Dialog

Sheet Print Settings Dialog

Spread Settings Dialog

Unhide Specific Row or Column Dialogs

Zoom Dialog

BarCode Tab

Color Picker Tab

Name Manager Dialog