| <!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)_Case sensitive</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-323: CoreFunction(Filter-)Standard Filter)_Case sensitive <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 09:34:08</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 input below data to A1:C24.</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">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="18">feb</td> |
| <td align="LEFT">B</td> |
| <td align="RIGHT">2100</td> |
| </tr> |
| <tr> |
| <td align="LEFT" height="18">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="18">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></td><td><p>The 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></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>Pop up 'Standard Filter' dialog</p> |
| <p></p> |
| <p></p></td></tr><tr><td width="5">4</td><td><p>Set the Filtering options in 'Field name', 'Condition' and 'Value'.say : Field name='Month'; Condition='='; Value='Feb'</p></td><td><p> </p> |
| <p> </p></td></tr><tr><td width="5">5</td><td><p>Click 'More' button and check the radio button 'Case sensitive'</p> |
| <p></p> |
| <actions><!--[CDATA[</p--></actions></td><td><p>Distinguishes between uppercase and lowercase letters when filtering the data</p> |
| <p></p> |
| <p></p></td></tr><tr><td width="5">7</td><td><p>Check "Copy results to" check-box and specify a place for the new data then click OK button</p></td><td><p>Filtered data will be copied to new place. Rows which have 'Feb' should be shown, rows which have 'feb' should not be shown</p></td></tr><tr><td width="5">8</td><td><p>Repeat Step3 - Step7 set Value='feb' then Click 'OK' button</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> </actions></p></td><td><p>Filtered data will be copied to new place. Rows which have 'feb' should be shown, rows which have 'Feb' should not be shown</p></td></tr><tr><td width="5">9</td><td><p>Repeat Step3 - Step7, clear the 'Case sensitive' check-box</p> |
| <p> </p> |
| <p><actions><!--[CDATA[</p--> |
| </actions></p></td><td><p>Both items of 'Feb' and 'feb' will be shown</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> |