| <!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: CoreFunction(Filter-)Standard Filter)_Copy result to</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-324: CoreFunction(Filter-)Standard Filter)_Copy result to <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 - 12/03/2014 03:00:22</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">2</td><td><p>Create a spreadsheet document then create below data in 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> |
| <p> </p> |
| <p><actions></actions></p></td><td><p>Data successfully created in the new spreadsheet</p> |
| <p> </p> |
| <p> </p></td></tr><tr><td width="5">3</td><td><p>Select the whole data range then Select main menu 'Data->Filter->Standard Filter'</p> |
| <p><actions><!--[CDATA[</p--> </actions></p></td><td><p>Pop up 'Standard Filter' dialog</p></td></tr><tr><td width="5">4</td><td><p>Set the Filtering options in 'Operator', 'Field name', 'Condition' and 'Value' as:</p> |
| <p>Operator Field Name Condition Value</p> |
| <p> |
| -- |
| |
| Month |
| |
| <> |
| Jan</p> |
| <p> AND |
| Product |
| |
| == |
| A<actions><br> |
| </actions></p></td><td><p> </p> |
| <p> </p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button to close 'Standard Filter' dialog</p> |
| <p><actions></actions></p></td><td><p>Results should be displayed at the original area.</p></td></tr><tr><td width="5">8</td><td><p><actions>Click Undo/Redo several times<br> |
| </actions></p></td><td><p>The prevous actions could be undo/redo successfully</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> |