Document Properties: Sort

On this property tab the sort order for the values of any field in the document can be configured. The sort order of a field can also be set from the Sort tab of the Properties dialog for different sheet objects.

Select a field in the Fields list to the left, then check one or more of the options to the right. The options are described below.

In the Sort by group the default sort order of the field values in the sheet objects can be set. Changes made in this group will affect fields in sheet objects created after the change. Previously created sheet objects will not be affected.

State Toggles the status whether the sorting procedure of values should be made by selection state. The selected values appear at the top of the list if this option is set. The sort order is: selected, possible, excluded (ascending).
Expression Field values will be sorted according to an arbitrary expression that is entered into the text edit box below this sort option.
Frequency Toggles the status whether the sorting procedure of values should be made by frequency.
Numeric Value Toggles the status whether the sorting procedure of values should be made by numeric value.
Text Toggles the status whether the sorting procedure of values should be made in alphabetical order according to the ASCII standard.
Load Order Toggles the status whether the sorting procedure of values should be made in load order.

The Reset button sort order is sort by state, ascending and sort by Text, A --> Z.

If more than one sort order is specified the sort order will be state, expression, frequency, numeric, text, load order.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?