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

From Apache OpenOffice Wiki
Jump to: navigation, search
(Sortingbuttons detect columnheaders)
(Sortingbuttons detect columnheaders)
Line 38: Line 38:
 
|-
 
|-
 
|
 
|
Spalte 1
+
List has column headers. Whole range is selected. Check behaviour of toolbar button.
 
|
 
|
 
* UNDO
 
* UNDO
Line 46: Line 46:
 
|-
 
|-
 
|
 
|
Spalte 1
+
 
 
|
 
|
 
* Close document
 
* Close document
Line 52: Line 52:
 
|-
 
|-
 
|
 
|
Spalte 1
+
List has '''no''' column headers. Check behaviour of toolbar buttons.
 
|
 
|
* In column A enter: 9; 3; 4; 6; 2
+
* In column A enter: 5; 3; 4; 6; 2
* In column B enter: k; s; d; f; g
+
* In column B enter: e; s; d; f; g
 
* Select cell A3
 
* Select cell A3
 
* Press toolbarbutton for ascending sorting
 
* Press toolbarbutton for ascending sorting
* Verify that cell A1 still contains "Number" and B1 "Misc"
+
* Verify that cell A1 no longer contains "5" and B1 no longer contains "e"
 
|-
 
|-
 
|
 
|
Spalte 1
+
List has '''no''' column headers. Check presetting of option "Range contains column labels" in sort dialog
 
|
 
|
 
* UNDO
 
* UNDO
 
* Select cell B3
 
* Select cell B3
* Press toolbar button for ascending sorting
+
* Open sort dialog by DATA - SORT
* Verify that cell A1 still contains "Number" and B1 "Misc"
+
* Switch to tabpage Options
 +
* Verify that option "Range contains column labels" is '''not''' set
 
|-
 
|-
 
|
 
|
Spalte 1
+
List has column headers of same data type as the list entries but of different format.
 
|
 
|
 
* UNDO
 
* UNDO
* Select Range A1:B5
+
* In cells A1 and B1 change the typeface to "bold"
* Press toolbarbutton for descending sorting
+
* Select cell A3
* Verify that cell A1 still contains "Number" and B1 "Misc"
+
* Press toolbarbutton for ascending sorting
 +
* Verify that cell A1 still contains "5" 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 "5" and B1 still contains "e"
 +
|-
 +
|
 +
 
 +
|
 
* Close document
 
* Close document
 
|}
 
|}

Revision as of 09:19, 11 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

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

List has column headers. Whole range is selected. Check behaviour of toolbar button.

  • UNDO
  • 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

List has column headers of same data type as the list entries but of different format.

  • UNDO
  • In cells A1 and B1 change the typeface to "bold"
  • Select cell A3
  • Press toolbarbutton for ascending sorting
  • Verify that cell A1 still contains "5" 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 "5" and B1 still contains "e"
  • Close document

Sorting default to selected column

Issue #7277

Stable sorting

Issue #20491

Personal tools