|
|
Sortingbuttons detect columnheaders |
Status: Standard |
- |
|
- Open new Spreadsheet document
- In column A enter: Number; 3; 4; 6; 2
- In column B enter: Misc; s; d; f; g
- Select cell A3
- Press toolbarbutton for descending sorting
- Verify that cell A1 still contains "Number" and B1 "Misc"
- UNDO
- Select cell B3
- Press toolbar button for ascending sorting
- Verify that cell A1 still contains "Number" and B1 "Misc"
- Close document
|
|
|
Sorting default to selected column |
Status: Standard |
- |
|
- Open new Spreadsheet document
- In column A enter: Number; 3; 4; 6; 2
- In column B enter: Misc; s; d; f; g
- Select cell A3
- Press toolbarbutton for descending sorting
- Verify that the sortorder was determined for column A (Number;2;3;4;6)
- UNDO
- Select cell B3
- Press toolbar button for ascending sorting
- Verify that the sortorder was determined for column B (Misc;s;g;f;d)
- Close document
|
|
|
Stable sorting |
Status: Standard |
- |
|
- Load testdocument sortorder.ods
- Select cell A1 and open sort dialog by DATA - SORT
- Switch to tabpage Options
- Check option "Range contains column labels"
- Switch to tabpage "Sort Criteria"
- Choose "Products as first criteria
- Choose "Area" as second criteria
- Close dialog by OK
- Verify that the numbers in column "sort order" are ascending
- UNDO
- Verify that the numbers in "original order" are ascending
- REDO
- Verify that the numbers in column "sort order" are ascending
- Close document
|