Test Case AOOTest-354: Data-)Subtotals_Calculate subtotals for_No column selected. [Version : 1] | ||
---|---|---|
Author: | undefined - 24/10/2012 14:22:30 | |
Summary: | ||
Preconditions: 1.Launch application. 2.Create a new spreadsheet document. 3.Insert some data for Subtotals. Following data as a reference: Level Code No. Team Name BS 20 4 B Elle OS 20 6 C Sweet BS 20 2 A Chcomic MS 30 5 A Ally CS 10 1 A Joker MS 10 3 B Kevin | ||
#: | Step actions: | Expected Results: |
1 |
| Expected Results |
2 | Select the cell range that you want to calculate subtotals for. (The contents in the first row will be regarded as column labels) | |
3 | Click 'Data-) Subtotals'. | The 'Subtotal' dialog appears. The current tab page is '1st Group'. The combo box 'Group by' use the first column label as its default value. |
4 | Make sure there is no check box checked in box 'Calculate subtotals for' in any tab page. | |
5 | Click 'OK' button. | There is no subtotal results. But the data are sorted according to the values in the column of which label is selected in combo box Group by. |
6 | Press Ctrl_Z to Undo it. | It works successfully. |
7 | Repeat step 2,3. | |
8 | Uncheck the 'Pre-sort area according to groups' on 'Options' tab page. | |
9 | Click 'OK' button. | There is no subtotal results. And the data are not sorted. |
Execution type: | Manual | |
Importance: | Medium | |
Test Focus: | ||
Feature first available at which release: | ||
Automation script name: | ||
Testsuite set: | ||
Requirements | None | |
Keywords: | None |