Difference between revisions of "User:Stefanw/Werkstatt/Testcases Sorting"

From Apache OpenOffice Wiki
Jump to: navigation, search
 
(11 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
{{UserStefanw}}
 
{{UserStefanw}}
  
−
Tests für die neuen Features zum Sortieren in Calc
+
Test Cases for new sorting features in Calc
 +
 
 +
[[User:Stefanw|Stefan Weigel]] 12:09, 11 December 2008 (CET)
 +
 
 +
__FORCETOC__
  
 
==Sortingbuttons detect columnheaders==
 
==Sortingbuttons detect columnheaders==
Line 27: Line 31:
 
* Press toolbar button for ascending sorting
 
* Press toolbar button for ascending sorting
 
* Verify that cell A1 still contains "Number" and B1 "Misc"
 
* 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
 
List has column headers. One single cell is selected. Check presetting of option "Range contains column labels" in sort dialog
 
|
 
|
−
* UNDO
 
 
* Select cell A3
 
* Select cell A3
 
* Open sort dialog by DATA - SORT
 
* Open sort dialog by DATA - SORT
 
* Switch to tabpage Options
 
* Switch to tabpage Options
 
* Verify that option "Range contains column labels" is set
 
* Verify that option "Range contains column labels" is set
 +
* Cancel dialog
 
|-
 
|-
 
|
 
|
 
List has column headers. Whole range is selected. Check behaviour of toolbar button.
 
List has column headers. Whole range is selected. Check behaviour of toolbar button.
 
|
 
|
−
* UNDO
 
 
* Select Range A1:B5
 
* Select Range A1:B5
 
* Press toolbarbutton for descending sorting
 
* Press toolbarbutton for descending sorting
Line 59: Line 63:
 
* Press toolbarbutton for ascending sorting
 
* Press toolbarbutton for ascending sorting
 
* Verify that cell A1 no longer contains "5" and B1 no longer contains "e"
 
* 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
 
List has '''no''' column headers. Check presetting of option "Range contains column labels" in sort dialog
 
|
 
|
−
* UNDO
 
 
* Select cell B3
 
* Select cell B3
 
* Open sort dialog by DATA - SORT
 
* Open sort dialog by DATA - SORT
 
* Switch to tabpage Options
 
* Switch to tabpage Options
 
* Verify that option "Range contains column labels" is '''not''' set
 
* Verify that option "Range contains column labels" is '''not''' set
 +
* Cancel dialog
 
|-
 
|-
 
|
 
|
Line 76: Line 81:
 
|-
 
|-
 
|
 
|
−
List has column headers of same data type as the list entries but of different style.
+
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 A enter: t; p; x; u; r
Line 84: Line 89:
 
* Press toolbarbutton for ascending sorting
 
* Press toolbarbutton for ascending sorting
 
* Verify that cell A1 still contains "t" and B1 still contains "e"
 
* 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.
 
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"
 
* In cells A1 and B1 apply style "Heading"
 
* Select cell A3
 
* Select cell A3
Line 102: Line 107:
 
==Sorting default to selected column==
 
==Sorting default to selected column==
 
[http://de.openoffice.org/issues/show_bug.cgi?id=7277 Issue #7277]
 
[http://de.openoffice.org/issues/show_bug.cgi?id=7277 Issue #7277]
 +
 +
{| class="wikitable"
 +
|-
 +
! width="20%" | 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==
 
==Stable sorting==
 
[http://de.openoffice.org/issues/show_bug.cgi?id=20491 Issue #20491]
 
[http://de.openoffice.org/issues/show_bug.cgi?id=20491 Issue #20491]
 +
 +
{| class="wikitable"
 +
|-
 +
! What the hell means "stable sorting" ? ;-)
 +
|-
 +
|
 +
* [http://en.wikipedia.org/wiki/Stable_sorting#Stability Wikipedia english]
 +
* [http://de.wikipedia.org/wiki/Stabiles_Sortierverfahren Wikipedia german]
 +
|}
 +
 +
 +
{| class="wikitable"
 +
|-
 +
! width="20%" | Situation !! Steps
 +
|-
 +
|
 +
 +
|
 +
* Open document [[Image: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 [[Image: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 [[Image: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
 +
|}

Latest revision as of 17:09, 28 December 2008

Der Inhalt dieser Seite steht unter der Lizenz Creative Commons Namensnennung - Weitergabe unter gleichen Bedingungen 3.0 Deutschland.
Bilder und Dateien können abweichende Lizenzen haben!





User-Bereich von Stefan Weigel

Seiten im User-Bereich:

Tipps

Archiv

Seiten von Stefan im OOo-Wiki:

Marketing

Makro

Dokumente

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" ? ;-)


Situation Steps

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

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

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
Retrieved from "https://wiki.openoffice.org/w/index.php?title=User:Stefanw/Werkstatt/Testcases_Sorting&oldid=105717"
Personal tools