Edit this page

Sorting

This article describes what is sorting and how to work with it through the RadSpreadsheet.

What Is Sorting?

The sorting feature allows the user to arrange the data according to one or more sorting conditions. More than one condition may be applied to each column of the range.

The conditions are applied in order. The range is first sorted according to the first condition. If there are repeating values in the column to which the first condition is applied, the next condition is used to sort these rows.

A brief description of each type of sorting condition can be found in the RadSpreadProcessing section of the documentation here.

Sorting Dialog

The sorting dialog provides access to all sorting functionality. Through it you can add, remove and rearrange all types of sorting conditions. Figure 1 shows the dialog.

Figure 1: Sorting dialog

spreadsheet-features-sorting 001

On top of the dialog shown in Figure 1 you can take advantage of the following options.

  • Add Level: Adds a new sorting condition.
  • Delete Level: Removes the selected sorting condition.
  • Copy Level: Copies the sorting condition.
  • Arrow keys: Arrange the sorting conditions in the order you’d like them to be applied.

The sorted range is the range which was selected when the dialog was open, so you need to select the desired range before opening the dialog.

Adding Values Sort Condition

There are a few ways to add a values sort condition. The sorting dialog allows most control over the process. In order to use the dialog to add a values sort condition, you need to perform the following steps:

  1. Select the range you would like to be sorted.
  2. Open the sorting dialog.
  3. In the Column drop down menu, specify by which column you would like the range to be sorted.
  4. In the Sort On drop down menu, specify "Values".
  5. In the Order drop down menu specify the desired order: Ascending, i.e. Smallest to Largest or Descending, i.e. Largest to Smallest.
  6. Press OK.

Another option to add a values sort condition is to use the sorting buttons next to the button which opens the sort dialog.

Figure 2: Sorting buttons

spreadsheet-features-sorting 002

These buttons in Figure 2 automatically add a values sort condition to the first column of the selected range. If you use the first button the order will be ascending, and for the second - descending.

Adding Custom Sort Condition

You can add a custom sort condition through the sorting dialog. You need to perform the following steps:

  1. Select the range you would like to be sorted.
  2. Open the sorting dialog.
  3. In the Column drop down menu, specify by which column you would like the range to be sorted.
  4. In the Sort On drop down menu, specify "Values".
  5. In the Order drop down menu specify Custom.
  6. These steps will open a new dialog in which you can specify the custom list according to which you'd like to have the values ordered. You can use one of the predefined, or enter your values in the List entries text box as demonstrated on Figure 3 and chose Add.

    Figure 3: Custom Lists Dialog

    spreadsheet-features-sorting 003

  7. Press OK to go back to the sorting dialog.
  8. Press OK to close the dialog and apply the sorting

Adding Color Sort Condition

You can add a fill or fore color sort condition through the sorting dialog by following these steps:

  1. Select the range you would like to be sorted.
  2. Open the sorting dialog.
  3. In the Column drop down menu, specify by which column you would like the range to be sorted.
  4. In the Sort On drop down menu, specify "FillColor" or "FontColor".
  5. Two new drop down menus shown on Figure 4 will appear.

    Figure 4: Sorting Dialog Color Condition

    spreadsheet-features-sorting 004

  • Use the first of the drop down menus to specify the color
  • Use the second of the drop down menus to specify whether rows with this color should be ordered on the top or on the bottom of the sort order.
  • Press OK.