|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|
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:|
Select the cell range that you want to calculate subtotals for. (The contents in the first row will be regarded as column labels)
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.
In the 'Group by' combo box select a column label which will used to group the data.
In the 'Calculate subtotals for' box, select a check box of the column labels which contains numbers that you want to subtotal.
In the 'Use function' box, select a function .
Click 'OK' button.
The subtotal result is displayed in hierarchy according to the 1st group option specified.
Delete rows of source data, and check the results of subtotals.
The results will be recalculated and refreshed automatically. They are correct.
Undo and Redo it.
It works correctly.
|Feature first available at which release:|
|Automation script name:|