Sorting is a tool for organizing data according to selected criteria, which allows information to be arranged in a specific order for convenient analysis and display.
MyOffice Spreadsheet supports two main types of sorting:
Only non-empty cells can be sorted. Characteristics of a non-empty cell:
–Contains any data: text, formulas, or values (numbers, errors, logical values).
–May not contain data but have formatting applied to it, such as fill color or font color formatting.
–The cell contains a space or line break added by the user.
You can sort either a custom range selected on the sheet or a predefined sorting and filtering range. The exception are tables and pivot tables: in tables, the selected range is expanded to the entire table when sorting, except for the header rows; pivot tables have their own sorting mechanism.
Hidden rows are not included in sorting. However, rows in hidden columns are included in sorting if they are within the selected range.
Sorting is reset when you open documents created in third-party editors and containing sorting with unsupported level parameters.