| <!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: Verify function and Check menu (Auto Fill - Advance Filter)</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-321: Verify function and Check menu (Auto Fill - Advance Filter) <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 - 11/03/2014 07:59:26</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></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><actions>Create a empty spreadsheet document<br> |
| </actions></p></td><td><p>The spreadsheet can be successfully created</p></td></tr><tr><td width="5">2</td><td><p>Input below data into range A1:C24</p> |
| <p> </p> |
| <table rules="NONE" cols="3" frame="VOID" cellspacing="0" border="0"> |
| <colgroup><col width="86"><col width="86"><col width="86"></colgroup> |
| <tbody> |
| <tr> |
| <td align="LEFT" height="17" width="86">Month</td> |
| <td align="LEFT" width="86">Product</td> |
| <td align="LEFT" width="86">Sales</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1200</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1800</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1600</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1200</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1800</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1300</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1900</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">2100</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">2000</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">C</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">C</td> |
| <td align="RIGHT">1700</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1800</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1900</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1400</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">C</td> |
| <td align="RIGHT">1200</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">C</td> |
| <td align="RIGHT">1200</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1800</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1400</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1600</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">C</td> |
| <td align="RIGHT">1300</td> |
| </tr> |
| </tbody> |
| </table></td><td><p>Data can be correctly created</p></td></tr><tr><td width="5">3</td><td><p>Input below data in a empty range of the same sheet</p> |
| <p> </p> |
| <table rules="NONE" cols="2" frame="VOID" cellspacing="0" border="0"> |
| <colgroup><col width="86"><col width="86"></colgroup> |
| <tbody> |
| <tr> |
| <td align="LEFT" height="17" width="86">Month</td> |
| <td align="LEFT" width="86">Sales</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| </tbody> |
| </table> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>Data can be correctly created</p></td></tr><tr><td width="5">4</td><td><p>Focus set to any cell of range A1:C24, click the menu 'Data -> Filter -> Advance Filter'</p> |
| <p><actions><!--[CDATA[</p--> </actions></p></td><td><p>Pop up 'Advance Filter' dialog, and range A1:C24 is selected automatically</p></td></tr><tr><td width="5">6</td><td><p>Select the cell range to define the filter conditions.(the cell range input in step2)</p> |
| <p><actions><!--[CDATA[</p--> </actions></p></td><td><p>Specify that only rows which sales number is 1500 in Jan, Feb, Mar will be displayed.</p></td></tr><tr><td width="5">7</td><td><p>Click 'More' button, then check the 'Copy results to" check-box and specify a place that the result to be copied to, click 'OK'</p></td><td><p>The result copied to the specified place. Result will be:</p> |
| <table frame="VOID" cols="3" rules="NONE" cellspacing="0" border="0"> |
| <colgroup><col width="86"><col width="86"><col width="86"></colgroup> |
| <tbody> |
| <tr> |
| <td align="LEFT" height="17" width="86">Month</td> |
| <td align="LEFT" width="86">Product</td> |
| <td align="LEFT" width="86">Sales</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">A</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Jan</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Feb</td> |
| <td align="LEFT">C</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="17">Mar</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">1500</td> |
| </tr> |
| </tbody> |
| </table> |
| <p> </p></td></tr><tr><td width="5">9</td><td><p>Select column A and apply instant filter from menu "Data -> Filter -> Instant Filter'</p></td><td><p>Instant filter successfully created</p></td></tr><tr><td width="5">10</td><td><p>Click instant filter in cell A1, select 'Jan'</p></td><td><p>Only rows have 'Jan' in month will be displayed</p></td></tr><tr><td width="5">11</td><td><p>Undo and Redo several times </p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>Undo and Redo work well</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> |
