The Free and Open Productivity Suite
Released: Apache OpenOffice 4.1.11


Test Case AOOTest-354: Data-)Subtotals_Calculate subtotals for_No column selected. [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 OS 20 6 C Sweet BS 20 2 A Chcomic MS 30 5 A Ally CS 10 1 A Joker MS 10 3 B Kevin

#:Step actions:Expected Results:

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.


Make sure there is no check box checked in box 'Calculate subtotals for' in any tab page.


Click 'OK' button.

There is no subtotal results. But the data are sorted according to the values in the column of which label is selected in combo box Group by.


Press Ctrl_Z to Undo it.

It works successfully.


Repeat step 2,3.


Uncheck the 'Pre-sort area according to groups' on 'Options' tab page.


Click 'OK' button.

There is no subtotal results. And the data are not sorted.

Execution type:Manual
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, 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.