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...

Tests für die neuen Features zum Sortieren in Calc

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"
List has column headers. One single cell is selected. Check presetting of option "Range contains column labels" in sort dialog	UNDO 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"
List has no column headers. Check presetting of option "Range contains column labels" in sort dialog	UNDO 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"
List has column headers of same data type as the list entries but of different style.	UNDO twice 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:A5 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:A5 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:A5 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:A5 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