/text/scalc/01/12030100.xhp

sorting; sort criteria for database ranges Sort Criteria Specify the sorting options for the selected range.

Ensure that you include any row and column titles in the selection.

Sort by Select the column that you want to use as the primary sort key. Ascending Sorts the selection from the lowest value to the highest value. The sorting rules are given by the locale. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language Settings - Languages. Descending Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language Settings - Languages. Then by Select the column that you want to use as the secondary sort key. Ascending Sorts the selection from the lowest value to the highest value. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. Descending Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. Then by Select the column that you want to use as the third sort key. Ascending Sorts the selection from the lowest value to the highest value. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. Descending Sorts the selection from the highest value to the lowest value. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. Sort Ascending/Descending Sorts the selection from the highest to the lowest value, or from the lowest to the highest value. Number fields are sorted by size and text fields by the order of the characters. You can define the sort rules on Data - Sort - Options. You define the default on %PRODUCTNAME - PreferencesTools - Options - Language settings - Languages. Icons on the Standard toolbar