| <!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_Options_Include format.</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-368: Data-)Subtotals_Options_Include format. <span style="font-size: 80%;">[Version : 2]</span></th></tr> |
| <tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 18/03/2014 04:35:23</td></tr> |
| <tr><td width="20%" valign="top"><span class="label">Last edit by:</span></td><td colspan="2">undefined - 03/04/2014 20:52:37</td></tr> |
| <tr><td colspan="3"><span class="label">Summary:</span><br><p>Using the reference file "Subtotals_1_AOOTest-368" as a reference, this is what is generally expected from this testcase:</p> |
| <p>1. Left picure: Cell C2, C4's format is currency; C3, C5's format is number; C6's format is percent </p> |
| <p>2. Picture in middle: Uncheck "Include formats" - Item No.3 is moved |
| from row 4 to row 3, by taking C3's format number while discarding C4's |
| format currency, aka change from "?2.00" to "2". The change of other |
| cells uses the same logic.</p> |
| <p>3. Right picture: Check "Include formats" - Item No.3 is moved from |
| row 4 to row 3 with C4's format currency. The change of other cells uses |
| the same logic.<strong><br> |
| </strong></p> |
| <p><strong> In summary:</strong> "Include formats" means cell's format |
| will be along with cell's data when sorting; Not "Include formats" means |
| cell's format will inherit new position's cell's format when sorting. </p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>1) Install Apache OpenOffice.</p> |
| <p>2) Attached files</p> |
| <p> - Subtotals_1_AOOTest-368 (use as a reference)</p> |
| <p> - AOO_Calc_Subtotal_Formatted_YuXehn.ods (sample spreadsheet) </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>Open sample spreadsheet AOO_Calc_Subtotal_Formatted_YuZhen.ods</p></td><td><p>File opens successfully in AOO</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). In this |
| instance, click on column C</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>Column C should now be highlighted</p> |
| <p> </p></td></tr><tr><td width="5">3</td><td><p>Click 'Data -> Subtotals'.</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> </actions></p></td><td><p>The 'Subtotals' dialog appears. The current tab page is '1st Group'. </p> |
| <p> </p> |
| <p> </p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select "Data"</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>"Data" should now be highlighted.</p> |
| <p> </p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select "Data"</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>Should be able to select "Data"</p> |
| <p> </p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Count'.</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>Should be able to highlight "Count"</p> |
| <p> </p></td></tr><tr><td width="5">7</td><td><p>Make sure the check box 'Include format' is unchecked in tab page 'Options'.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p></p> |
| <p></p></td></tr><tr><td width="5">8</td><td><p>Click 'OK' button.</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>The subtotal result is displayed in hierarchy |
| according to the 1st group option specified. Please refer |
| "Summary" above, item #2 for expected output. Essentially, the |
| data will be sorted according to the 'Group by'option specified.The cell |
| format can't be moved with its original value, the new value moved into |
| the cell inherit the format.</p> |
| <p> </p> |
| <p> </p></td></tr><tr><td width="5">9</td><td><p>Press Ctrl_Z to Undo subtotal.</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>Worksheet is returned to it's original state.</p> |
| <p> </p> |
| <p> </p></td></tr><tr><td width="5">10</td><td><p>Repeat step 2-6.</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p> </p> |
| <p> </p></td></tr><tr><td width="5">11</td><td><p>Check the check box 'Include format' in tab page 'Options'.</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p></p> |
| <p></p></td></tr><tr><td width="5">12</td><td><p>Click 'OK' button.</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>The subtotal result is displayed in hierarchy |
| according to the 1st group option specified. Please refer |
| "Summary" above, item #3 for expected output. Essentially, the |
| data will be sorted according to the 'Group by'option specified. |
| The cell format will be moved with its original value.</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> |
