| Test Case AOOTest-353: 1M Rows_Data-)Subtotals_Page break between groups. [Version : 1] | ||
|---|---|---|
| Author: | undefined - 24/10/2012 14:22:30 | |
| Summary: | ||
| Preconditions: Create a spreadsheet document. | ||
| #: | Step actions: | Expected Results: |
| 1 |
| Expected Results |
| 2 | Input data into a range of cells from row 1048560 to 1048570. The first row of the range is column labels. Select the area in the sheet that you want to calculate subtotals for. | |
| 3 | Click 'Data-) Subtotals'. | The 'Subtotals' dialog appears. |
| 4 | In the 'Group By' box, select the column that you want to add the subtotals to. | |
| 5 | In the 'Calculate subtotals for' box, select the check boxes for the columns containing the values that you want to subtotal. | |
| 6 | In the 'Use function' box, select the function that you want to use to calculate the subtotals. | |
| 7 | Click 'Option' tab page, and select 'Page break between groups' check box. | |
| 8 | Click 'OK' button. | The subtotal result is displayed in hierarchy according to the group options and a blue page break line is inserted after each group of subtotaled data. (However there is no page break between each last subtotaled data of current level and its upper level) |
| Execution type: | Manual | |
| Importance: | Medium | |
| Test Focus: | ||
| Feature first available at which release: | ||
| Automation script name: | ||
| Testsuite set: | ||
| Requirements | None | |
| Keywords: | None | |
