Sort page¶
The Sort page allows you to customize settings related to sort function. If this is checked, fast binary comparison is used to sort. The locale information is ignored when this is checked. If this is checked, stable sort is used. The stable sort maintains the relative order of records. The stable sort is usually slower. If this is checked, case is ignored. If this is checked, corresponding Hiragana and Katakana characters compare as equal. If this is checked, nonspacing combining characters, such as diacritics, dakuten, and handakuten, are ignored. If this is checked, symbols are ignored. If this is checked, the difference between half-width and full-width characters is ignored. The full-width form is a formatting distinction used in Chinese and Japanese scripts. Hyphen and apostrophe are treated as normal characters. This is off by default to ensure that words containing hyphen or apostrophe are matched when sorting by letter. If this is checked, digits are sorted as numbers even when using Sort A to Z or Sort Z to A commands. For example, "2" is sorted before "10". If this is checked, leading non-numeric characters are ignored when using Sort Smallest to Largest or Sort Largest to Smallest commands. If this is checked, full width characters are treated as 2 characters when using Sort Shortest to Longest or Sort Longest to Shortest commands. Compares unquoted strings in cells of CSV documents. For instance, when a cell strings is "a""b", the actual string to compare will be a"b. Inspects only selected strings for sort when vertical selection or multiple selections exist. Groups identical strings when sort by occurrence. Allows digit grouping in numbers. The digit grouping character depends on the locale specified in the Locale drop-down list box. This option affects the Sum and Average values on the status bar and the Number Range expressions for the Search and Filter as well as Sort commands. If this is checked, the cursor moves to the correct position when sorting. Specifies the locale used for the sort. Specifies that the date formats derived from the current locale should be used. If this is not set, a date and/or time format should be specified in the drop down list box below.Fast Binary Comparison (Ignore Locale) checkbox¶
Stable Sort checkbox¶
Ignore case checkbox¶
Do not differentiate between Hiragana and Katakana characters checkbox¶
Ignore nonspacing combining characters, such as diacritics, dakuten, and handakuten checkbox¶
Ignore symbols checkbox¶
Do not differentiate between a half-width and a full-width characters checkbox¶
Treat punctuation marks the same as symbols checkbox¶
Treat digits as numbers checkbox¶
Ignore leading non-numeric characters when sorting numbers/IP addresses checkbox¶
Treat full-width characters as two characters when sorting by length checkbox¶
Compare unquoted strings in cells of CSV documents checkbox¶
Inspect only selected strings when a vertical selection or multiple selections exist checkbox¶
Group identical strings when sorting by occurrence checkbox¶
Allow digit grouping checkbox¶
The cursor moves to the correct position when sorting checkbox¶
Locale drop-down list box¶
Use default date formats drop-down list box¶