| <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> |
| <html><head> |
| <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Label:Subtotal on one column not the used for Group by.</title> |
| <link type="text/css" rel="stylesheet" href="tl_documents.css"> |
| <style type="text/css" media="print">.notprintable { display:none;}</style> |
| <style></style></head> |
| <body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-365: Data-)Subtotals_Label:Subtotal on one column not the used for Group by. <span style="font-size: 80%;">[Version : 1]</span></th></tr> |
| <tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</td></tr> |
| <tr><td colspan="3"><span class="label">Summary:</span><br><p></p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>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 |
| CS 10 3 B Kevin |
| </p></td></tr><tr><td><span class="label">#:</span></td><td><span class="label">Step actions:</span></td><td><span class="label">Expected Results:</span></td></tr><tr><td width="5">1</td><td><p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> |
| <p></p> |
| <p></p></td></tr><tr><td width="5">2</td><td><p>Select the cell range |
| that you want to calculate subtotals for. (The contents in the first row |
| will be regarded as column labels)</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p></p> |
| <p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>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.</p> |
| <p></p> |
| <p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select a column label which will used to group the data.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p></p> |
| <p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate |
| subtotals for' box, select one check box of the column labels which |
| contains numbers that you want to subtotal but not the column 'Group |
| by'.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p></p> |
| <p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Sum'.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p></p> |
| <p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed correctly.</p> |
| <p></p> |
| <p></p></td></tr><tr><td width="5">8</td><td><p>Check the labels for subtotal results.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>The labels' format for each group is {value} {Function} .</p> |
| <p>For example, CS Sum. </p> |
| <p>The label for whole range is Grand Total.</p> |
| <p></p> |
| <p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr> |
| <tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr> |
| <tr><td> Feature first available at which release:</td><td colspan="2"></td></tr> |
| <tr><td> Automation script name:</td><td colspan="2"></td></tr> |
| <tr><td> Testsuite set:</td><td colspan="2"></td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr> |
| </tbody></table> |
| </div> |
| </body></html> |
