4.4.5 Sort Columns by Labels


This tool sorts columns by values in worksheet label row, and you can use values in multiple column label rows for nested sort.

Origin provides two methods to open this dialog:

  • Right-click on the selected worksheet columns and select Sort Columns by Labels in the context menu.
  • Select Worksheet:Sort Columns by Labels in the main menu, when the worksheet is active.
Sort Columns by Labels 01.png

In this dialog, you can choose a column label row in the Available Labels panel and click the Ascending or Descending button to add it as a criteria to the Nested Sort Criteria panel, and you can customize the format etc. later. You can add more than one criteria.

If there are missing values in the selected worksheet label rows, you can either define them as the smallest or biggest value by choosing the corresponding radio button.

Available Labels

Show the available label rows in this panel, including: Long Name, Units, Comments, Parameters, Sampling Interval and User Defined parameters.

Nested Sort Criteria

Select the labels in the Available Labels panel and click the Ascending Ascending Button.png or Descending Descending Button.png button to add in the Nested Sort Criteria panel.

Also, when you add the labels to the Nested Sort Criteria panel, you can specify the rows format.

Note:

  1. It can not reorder the label in Nested Sort Criteria panel. If you want to reorder them, you need to remove and add them again.
  2. For added labels, to modify the sorting order, select the label row in the Available Labels panel, and click on the Ascending or Descending button to change the order.

Row Format

Row labels can be text, numbers, time and date. So sort by such values, row format must be set correctly.

  • To add label row with correct format, click on the triangle button Row Format Button 2.png next to the format button Row Format Button.png to choose the format in the flyout menu. Then add the row label to the Nested Sort Criteria. Click on the format button Row Format Button.png will also open the Row Format dialog.
  • To modify the row format in Nested Sort Criteria, click on the button Row Format Button 3.png under the Format column to open the Row Format dialog.
Sort Columns by Labels 02.png
Format Specifies the format of the label rows: Text, Numeric, Time or Date.
Display When choose Time or Date format, this drop-down list is shown. Determines how the data in the column is displayed.
Custom Display When the Custom Display is selected in the Display drop-down list, this combo box is shown. And you can customize the date or time format.

Missing Value as

You can set the missing value in the labels as the smallest or the largest value when sort the columns.

Sort

You can sort either the Selected Columns or Entire Worksheet.

Note: If you do not select any column, and open this dialog by selecting Worksheet:Sort Columns by Labels in the main menu, Entire Worksheet is chosen by default and this option is grayed out.