User:Stefanw/Werkstatt/Testcases Sorting

User-Bereich von Stefan Weigel

Seiten im User-Bereich: Startseite Werkstatt Deutsche Downloadseite 3.1.1 Release Blockers Date Issue Calc Testcases Sorting DD Issues Calc Anwenderfrühstück OOo-Info-Tag Passau www.datenpilot.org Vortrag Chemnitz 2010 Vortrag Graz 2010 Linuxwochen Wien 2009 Grazer Linuxtage 2009 Linuxwochen Wien 2008 OOo Conference 2010 Tipps Gleitender Durchschnitt OOo mit VBA steuern Archiv Vorschlag VHS Verzeichnis Neue Interaktive Support-Seiten Screenshots für OOo 3 (deutsch) Kleines Pressepaket Seiten von Stefan im OOo-Wiki: Marketing OOo richtig bewerben Brainstorm Warum OOo Übersetzung Why Ooo YourChoice-Übersetzung YourChoice-Kritik Statistik Mailingliste Ungute Werbung durch Sun Referenzkundenseite Success Story: Buchprojekt Makro Fax mit OOo und Fritz!Fax Timestamp in Calc Dokumente Fortgeschrittene Installation Wissenschaftliche Arbeiten UebersetzungSolver Artikel zum Solver Bearbeiten...

Test Cases for new sorting features in Calc

Stefan Weigel 12:09, 11 December 2008 (CET)

Sortingbuttons detect columnheaders

Issue #22758

Situation	Steps
	Open new Spreadsheet document
List has column headers. One single cell is selected. Check behaviour of toolbar buttons.	In column A enter: Number; 3; 4; 6; 2 In column B enter: Misc; s; d; f; g Select cell A3 Press toolbar button 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" UNDO
List has column headers. One single cell is selected. Check presetting of option "Range contains column labels" in sort dialog	Select cell A3 Open sort dialog by DATA - SORT Switch to tabpage Options Verify that option "Range contains column labels" is set Cancel dialog
List has column headers. Whole range is selected. Check behaviour of toolbar button.	Select Range A1:B5 Press toolbarbutton for descending sorting Verify that cell A1 still contains "Number" and B1 "Misc"
	Close document Open new Spreadsheet document
List has no column headers. Check behaviour of toolbar buttons.	In column A enter: 5; 3; 4; 6; 2 In column B enter: e; s; d; f; g Select cell A3 Press toolbarbutton for ascending sorting Verify that cell A1 no longer contains "5" and B1 no longer contains "e" UNDO
List has no column headers. Check presetting of option "Range contains column labels" in sort dialog	Select cell B3 Open sort dialog by DATA - SORT Switch to tabpage Options Verify that option "Range contains column labels" is not set Cancel dialog
	Close document Open new Spreadsheet document
List has column headers of same data type as the list entries but of different format.	In column A enter: t; p; x; u; r In column B enter: e; s; d; f; g In cells A1 and B1 change the typeface to "bold" Select cell A3 Press toolbarbutton for ascending sorting Verify that cell A1 still contains "t" and B1 still contains "e" UNDO twice
List has column headers of same data type as the list entries but of different style.	In cells A1 and B1 apply style "Heading" Select cell A3 Press toolbarbutton for ascending sorting Verify that cell A1 still contains "t" and B1 still contains "e"
	Close document

Sorting default to selected column

Issue #7277

Situation	Steps
	Open new Spreadsheet document
One single cell is selected. Check behaviour of toolbar buttons.	In column A enter: Number; 3; 4; 6; 2 In column B enter: Misc; s; d; f; g Select cell A3 Press toolbar button for ascending sorting Verify that the sortorder was determined for column A (Number;2;3;4;6) UNDO Select cell B3 Press toolbar button for descending sorting Verify that the sortorder was determined for column B (Misc;s;g;f;d) UNDO
Whole range is selected. Check behaviour of toolbar buttons.	Select Range A1:B5 Move the active cell inside the range to column A by using the TAB key Press toolbar button for ascending sorting Verify that the sortorder was determined for column A (Number;2;3;4;6) UNDO Select range A1:B5 Move the active cell inside the range to column B by using the TAB key Press toolbar button for ascending sorting Verify that the sortorder was determined for column B (Misc;d;f;g;s) UNDO
One single cell is selected. Check presetting of sort criteria in sort dialog.	Select cell A3 Open sort dialog by DATA - SORT Verify that the first sort criteria is set to "Number (ascending)" Cancel dialog Select cell B3 Open sort dialog by DATA - SORT Verify that the first sort criteria is set to "Misc (ascending)" Cancel dialog
Whole range is selected. Check presetting of sort criteria in sort dialog.	Select Range A1:B5 Move the active cell inside the range to column A by using the TAB key Open sort dialog by DATA - SORT Verify that the first sort criteria is set to "Number (ascending)" Cancel dialog Select range A1:B5 Move the active cell inside the range to column B by using the TAB key Open sort dialog by DATA - SORT Verify that the first sort criteria is set to "Misc (ascending)" Cancel dialog
	Close document

Stable sorting

Issue #20491

What the hell means "stable sorting" ? ;-)
Wikipedia english Wikipedia german

Situation	Steps
	Open document File:Testcase-sortorder-issue20491.ods
Must keep sort order of previous sorting using sort dialog.	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 "Salesman(ascending)" as first criteria Choose "Product (ascending)" as second criteria Choose "Sales (ascending)" as third criteria Close dialog by OK Again, open sort dialog by DATA - SORT Switch to tabpage Options Check option "Range contains column labels" Switch to tabpage "Sort Criteria" Choose "Region (ascending)" as first criteria Choose "-undefined-" as second criteria Close dialog by OK Verify that the numbers in column "CheckOrder" are ascending
	Close document Open document File:Testcase-sortorder-issue20491.ods
Must keep sort order of previous sorting using toolbar button. Ascending.	Open document testcase-sortorder-issue20491.ods Select cell E1 ("Sales") and press toolbar button for ascending sorting. Select cell D1 ("Product") and press toolbar button for ascending sorting. Select cell C1 ("Salesman") and press toolbar button for ascending sorting. Select cell B1 ("Region") and press toolbar button for ascending sorting. Verify that the numbers in column "CheckOrder" are ascending
	Close document Open document File:Testcase-sortorder-issue20491.ods
Must keep sort order of previous sorting using toolbar button. Descending.	Open document testcase-sortorder-issue20491.ods Select cell E1 ("Sales") and press toolbar button for descending sorting. Select cell D1 ("Product") and press toolbar button for descending sorting. Select cell C1 ("Salesman") and press toolbar button for descending sorting. Select cell B1 ("Region") and press toolbar button for descending sorting. Verify that the numbers in column "CheckOrder" are descending
	Close document