| Test Case AOOTest-377: AOO4.0;Data-)Subtotals_Recalculate and refresh results when data rows deleted. [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 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 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 | In the 'Group by' combo box select a column label which will used to group the data. | |
| 5 | In the 'Calculate subtotals for' box, select a check box of the column labels which contains numbers that you want to subtotal. | |
| 6 | In the 'Use function' box, select a function . | |
| 7 | Click 'OK' button. | The subtotal result is displayed in hierarchy according to the 1st group option specified. |
| 8 | Delete rows of source data, and check the results of subtotals. | The results will be recalculated and refreshed automatically. They are correct. |
| 9 | Undo and Redo it. | It works correctly. |
| Execution type: | Manual | |
| Importance: | Medium | |
| Test Focus: | ||
| Feature first available at which release: | ||
| Automation script name: | ||
| Testsuite set: | ||
| Requirements | None | |
| Keywords: | None | |
