Test Case AOOTest-356: Data-)Subtotals_Do Subtotals on multiple ranges. [Version : 1] | ||
---|---|---|
Author: | undefined - 24/10/2012 14:22:30 | |
Summary: | ||
Preconditions: 1.Launch application. 2.Create a new spreadsheet document. 3.Insert more than one ranges of data in one sheet for Subtotals. Following data as a reference: Level Code No. Team Name BS 20 4 B Elle BS 20 6 C Sweet BS 20 2 A Chcomic CS 30 5 A Ally MS 10 1 A Joker MS 10 3 B Kevin | ||
#: | Step actions: | Expected Results: |
1 |
| Expected Results |
2 | Select a 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'. And do subtotal on it. | The subtotal result is displayed in hierarchy according to the option specified. |
4 | Select another cell range . | |
5 | Repeat step 2. | The subtotal result is displayed in hierarchy according to the option specified. |
6 | Check the layered bar on the left side. | It is shown correctly. And all the subtotal data ranges can be folded or unfolded by click the button on the layered bar. |
Execution type: | Manual | |
Importance: | Medium | |
Test Focus: | ||
Feature first available at which release: | ||
Automation script name: | ||
Testsuite set: | ||
Requirements | None | |
Keywords: | None |