| <!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: create an instant filter with VLOOK formula with the sample file</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-325: create an instant filter with VLOOK formula with the sample file <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:16:42</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 new spreadsheet document and input 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">1200</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><!--[CDATA[</p--> |
| </actions></p></td><td><p>Data successfully created in the spreadsheet</p> |
| <p> </p></td></tr><tr><td width="5">3</td><td><p>Apply standard filter on column B from menu 'Data -> Filter -> AutoFilter'</p> |
| <p> </p> |
| <p><actions></actions></p></td><td><p>Auto Filter successfully apply to column B</p> |
| <p> </p></td></tr><tr><td width="5">4</td><td><p>Select any product from filter drop down list.</p> |
| <p> </p> |
| <p><actions><br> |
| </actions></p></td><td><p>It can work properly without any crash.</p> |
| <p> </p> |
| <p> </p></td></tr><tr><td width="5">5</td><td><p><actions>Save to ODS format, reload and resave to XLS format, reload<br> |
| </actions></p> |
| <p>Then close and reopen from MS Excel</p></td><td><p>The spreadsheet can be successfully load/save to the specified format</p> |
| <p>Excel can also successfully load the XLS file</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> |
