Language

The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11

 

Test Case AOOTest-361: Data-)Subtotals_Function Product. [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 label of a column which contains numbers or characters to group the data.

5

In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.

6

In the 'Use function' box, select the function 'Product'.

7

Click 'OK' button.

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

8

Click the cell that contains the result of subtotal.

There is a formula =SUBTOTAL(6,...) shown in formula bar.

The function Product can multiplies the numbers. Ignore the characters and blanks.

For example, A1=3, A2=4, A3=5 then Product(A1:A3)=60

The result is correct.

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

Apache Software Foundation

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

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