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

From Apache OpenOffice Wiki
Jump to: navigation, search
(→‎Sorting default to selected column)
(→‎Sortingbuttons detect columnheaders)
Line 27: Line 27:
 
* 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
Line 59: Line 59:
 
* 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
Line 85: Line 85:
 
* 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

Revision as of 10:04, 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

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"
  • 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: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

Retrieved from "https://wiki.openoffice.org/w/index.php?title=User:Stefanw/Werkstatt/Testcases_Sorting&oldid=104369"
Personal tools