Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.7 released

 

Test Case AOOTest-366: Data-)Subtotals_Layered buttons on left side bar for subtotal results. [Version : 1]
Author:undefined - 24/10/2012 14:22:30
Last edit by:undefined - 28/01/2014 02:49:53
Preconditions:

1.Launch Application. 2.Create a new spreadsheet document. 3.Insert some data for Subtotals. Following data as a reference:

#: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 'Subtotals' 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 the function 'Sum'.

7

Click 'OK' button.

The subtotal result is displayed in hierarchy according to the 1st group option specified.

There is a bar on the left side with the layered buttons on it.

8

Click the '-' button to fold the data range.

It works successfully.

9

Click the '+' button to unfold the data range.

It works successfully.

10

Click the '1' button on the top of the left side bar.

All layers will be folded. Only the labels of column and the Grand Total are shown.

11

Click the '3' button on the top of the left side bar.

All layers will be unfolded. All data and results are shown.

12

Click the '2' button on the top of the left side bar.

All data layers will be unfolded. Only the labels of column and the subtotal results are shown.

Execution type:Manual
Importance:Medium
Test Focus:
Feature first available at which release:
Automation script name:
Testsuite set:
Requirements None
Keywords: None

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.