Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,76 @@ +<!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: Sort Options_Direction_Sort columns.</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-344: Sort Options_Direction_Sort columns. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data in one row, for example,</p> +<p>Units 7 27 4 12 3 6</p> +<p>then click Data-)Sort in main menu.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In Options, Select Left to right(sort columns), and check range contains row labels</p> +<p>Select 'Units' in 'Sort by' list and choose 'Ascending'.</p> +<p>then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending from left to right.</p> +<p>For the sample,</p> +<p>Units 3 4 6 7 12 27</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Save and close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort is not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,104 @@ +<!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: Sort Options_Include formats.</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-345: Sort Options_Include formats. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data including format, for example, data with different Currency setting.</p> +<p>Units</p> +<p>$32.00</p> +<p>57.00 â¬</p> +<p>? 74</p> +<p>R$ 50.00</p> +<p>?.?. 27.00</p> +<p>7.00 §â§å§Ã.</p> +<p>(Comments Input data manually and then set different currency locale)</p> +<p>Click Data-)Sort in main menu.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select Units in 'Sort by' list and choose 'Ascending'.</p> +<p>Click Options tab in Sort dialog and check the option 'Include formats' then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending and include its format.</p> +<p>For the sample:</p> +<p>Units</p> +<p>7.00 §â§å§Ã.</p> +<p>?.?. 27.00</p> +<p>$32.00</p> +<p>R$ 50.00</p> +<p>57.00 â¬</p> +<p>? 74</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Copy the original data to another sheet.</p> +<p>Click Data-)Sort in main menu.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Select Units in 'Sort first by' list and choose 'Ascending'.</p> +<p>Click Options tab in Sort dialog and uncheck the option 'Include formats' then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending and without its format.</p> +<p>Each cell preserve the original format.</p> +<p>For the sample:</p> +<p>Units</p> +<p>$7.00</p> +<p>27.00 â¬</p> +<p>? 32</p> +<p>R$ 50.00</p> +<p>?.?. 57.00</p> +<p>74.00 §â§å§Ã.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p>Save and close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data sort is not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,88 @@ +<!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: Sort Options_Language.</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-346: Sort Options_Language. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data, for example, input some Chinese character data.</p> +<p>°ì¹«ÃÃ÷</p> +<p>¶©Ãé»ú</p> +<p>Ãðä</p> +<p>éÃñÃ</p> +<p>èÃú</p> +<p>µç»°</p> +<p>Ãüþ¼Ã</p> +<p>Click Data-)Sort in main menu.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select an item in 'Sort by' list and choose 'Ascending'.</p> +<p>Click Options tab in Sort dialog and in Language section, check the +option 'Chinese(Simplified)' and choose 'Pinyin' then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending and in Pinyin order.</p> +<p>For the sample,</p> +<p>°ì¹«ÃÃ÷</p> +<p>µç»°</p> +<p>¶©Ãé»ú</p> +<p>éÃñÃ</p> +<p>èÃú</p> +<p>Ãüþ¼Ã</p> +<p>Ãðä</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Save and close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data sort is not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,83 @@ +<!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: Sort Options_Multiple sort_data overlap.</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-347: Sort Options_Multiple sort_data overlap. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data into document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Set focus in this data range and click Data-)Sort.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Select an item in 'Sort by' list then choose Ascending.</p> +<p>Click Options tab then change some settings.</p> +<p>Click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted according to the setting.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Input another data into same sheet.</p> +<p>Data1 and data2 are not overlapped.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Set focus in data2 and click Data-)Sort.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p>Select an item in 'Sort by' list then choose Ascending.</p> +<p>Click Options tab then change some settings, for example,</p> +<p>check option 'Copy result to' and set range partially overlap with data1 in step2.</p> +<p>Click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted according to the setting.</p> +<p>Sort result directly overwrite data1 in step2.</p> +<p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p>Save * close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort is not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,85 @@ +<!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: Sort Options_Multiple sort_no data overlap.</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-348: Sort Options_Multiple sort_no data overlap. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data into document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Set focus in this data range and click Data-)Sort.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Select an item in 'Sort by' list then choose Ascending.</p> +<p>Click Options tab then change some settings.</p> +<p>Click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted according to the setting.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Input another data into same sheet.</p> +<p>Data1 and data2 are not overlapped.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Set focus in data2 and click Data-)Sort.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p>Select an item in 'Sort by' list then choose Ascending.</p> +<p>Click Options tab then change some settings.</p> +<p>Click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted according to the setting.</p> +<p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p>Open Sort dialog and check its setting.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify the latter created sort parameter is overwrite the prior sort parameter. </p> +<p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p>Save * close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort result and parameter are not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,80 @@ +<!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: Sort Options_Range contains column labels.</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-349: Sort Options_Range contains column labels. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data then click Data-)Sort in main menu.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select an item in 'Sort by' list and choose 'Ascending'.</p> +<p>Click Options tab and check 'Range contains column labels' then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending.</p> +<p>Verify the first row is considered as column header and not sorted.</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Copy the same data into another sheet.</p> +<p>Click Data-)Sort in main menu.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Select the same item in 'Sort by' list with step3 and choose 'Ascending'.</p> +<p>Click Options tab and uncheck 'Range contains column labels' then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending.</p> +<p>Verify the first row is also sorted in.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p>Save and close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort is not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,72 @@ +<!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: Support_1024Columns(Sort Criteria_Sort first by)</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-350: Support_1024Columns(Sort Criteria_Sort first by) <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data then click Data-)Sort in main menu.</p> +<p>Data range between Column 1000 and Column 1024(Column ALM and Column AMJ).</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select an item in 'Sort by' list and choose 'Ascending' then click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending.</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Save and close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Re-open document and select the data and click Data-)Sort again.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>In Sort dialog, change another item in 'Sort by' list and choose 'Descending' and click OK.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item descending.</p> +<p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,74 @@ +<!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: Support_1024Columns(Sort Options_Multiple settings).</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-351: Support_1024Columns(Sort Options_Multiple settings). <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Result</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Launch application then create a sc document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Input some data then click Data-)Sort in main menu.</p> +<p>Number range between Column 1000 and Column 1024(Column ALM and Column AMJ).</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort dialog pops up.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select an item in 'Sort by' list and choose 'Ascending'.</p> +<p>Click Options tab.</p> +<p>Change some settings, such as 'Case sensitive', 'Copy result to', .etc</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending.</p> +<p>All options settings work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Undo * Redo for several times.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Work correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Save and close document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Reopen document.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Sort is not lost.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">10</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">11</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">12</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">13</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">14</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">15</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">16</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">17</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">18</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">19</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">20</td><td><p></p> + <actions><!--[CDATA[</p--></actions></td><td><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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,45 @@ +<!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: 1M Rows_Data-)Subtotals</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-352: 1M Rows_Data-)Subtotals <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Input data into a range +of cells from row 1048560 to 1048570 . The first row of the range is +column labels. Select the area in the sheet that you want to calculate +subtotals for.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data -) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotals' dialog appears.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group By' box, select the column that you want to add the subtotals to.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select the check boxes for the columns containing the values that you want to subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function that you want to use to calculate the subtotals.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the group options.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,52 @@ +<!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: 1M Rows_Data-)Subtotals_Page break between groups.</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-353: 1M Rows_Data-)Subtotals_Page break between groups. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>Create a spreadsheet document.</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Input data into a range +of cells from row 1048560 to 1048570. The first row of the range is +column labels. Select the area in the sheet that you want to calculate +subtotals for.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotals' dialog appears.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group By' box, select the column that you want to add the subtotals to.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select the check boxes for the columns containing the values that you want to subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function that you want to use to calculate the subtotals.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'Option' tab page, and select 'Page break between groups' check box.</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> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is +displayed in hierarchy according to the group options and a blue page +break line is inserted after each group of subtotaled data. (However +there is no page break between each last subtotaled data of current +level and its upper level)</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,67 @@ +<!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_Calculate subtotals for_No column selected.</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-354: Data-)Subtotals_Calculate subtotals for_No column selected. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch application. + 2.Create a new spreadsheet document. + 3.Insert some data for Subtotals. +Following data as a reference: +Level Code No. Team Name +BS 20 4 B Elle +OS 20 6 C Sweet +BS 20 2 A Chcomic +MS 30 5 A Ally +CS 10 1 A Joker +MS 10 3 B Kevin +</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></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)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog +appears. The current tab page is '1st Group'. The combo box 'Group by' +use the first column label as its default value.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Make sure there is no check box checked in box 'Calculate subtotals for' in any tab page. </p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>There is no subtotal +results. But the data are sorted according to the values in the column +of which label is selected in combo box Group by.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Press Ctrl_Z to Undo it.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>It works successfully.</p> +<p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Repeat step 2,3. </p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Uncheck the 'Pre-sort area according to groups' on 'Options' tab page.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">9</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>There is no subtotal results. And the data are not sorted.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-355_Data-Subtotals_Delete_Subtotals_on_different_subtotal_ranges_in_one_sheet.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-355_Data-Subtotals_Delete_Subtotals_on_different_subtotal_ranges_in_one_sheet.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-355_Data-Subtotals_Delete_Subtotals_on_different_subtotal_ranges_in_one_sheet.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-355_Data-Subtotals_Delete_Subtotals_on_different_subtotal_ranges_in_one_sheet.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,49 @@ +<!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_Delete Subtotals on different subtotal ranges in one sheet.</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-355: Data-)Subtotals_Delete Subtotals on different subtotal ranges in one sheet. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch application. + 2.Create a new spreadsheet document. + 3.Insert more than one ranges of data in one sheet for Subtotals.</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Select a cell range that you want to calculate subtotals for. (The contents in the first row will be regarded as column labels)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data -) Subtotals'. And do subtotal on it.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select another cell range and do subtotal on it.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Repeat step 2 to do subtotal on each data ranges.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Select one range.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Use 'Delete' button on 'Subtotals' dialog to delete subtotal on this range.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result will be deleted correctly.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Use 'Delete' button on 'Subtotals' dialog to delete subtotal on each data range.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result will be deleted one by one. And the layered button bar on left side will disappear at last.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-356_Data-Subtotals_Do_Subtotals_on_multiple_ranges.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-356_Data-Subtotals_Do_Subtotals_on_multiple_ranges.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-356_Data-Subtotals_Do_Subtotals_on_multiple_ranges.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-356_Data-Subtotals_Do_Subtotals_on_multiple_ranges.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,52 @@ +<!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_Do Subtotals on multiple ranges.</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-356: Data-)Subtotals_Do Subtotals on multiple ranges. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch application. + 2.Create a new spreadsheet document. + 3.Insert more than one ranges of data in one sheet for Subtotals. +Following data as a reference: +Level Code No. Team Name +BS 20 4 B Elle +BS 20 6 C Sweet +BS 20 2 A Chcomic +CS 30 5 A Ally +MS 10 1 A Joker +MS 10 3 B Kevin +</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></p></td></tr><tr><td width="5">2</td><td><p>Select a cell range that you want to calculate subtotals for. (The contents in the first row will be regarded as column labels)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'. And do subtotal on it.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>Select another cell range .</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>Repeat step 2.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>Check the layered bar on the left side.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>It is shown correctly.</p> +<p>And all the subtotal data ranges can be folded or unfolded by click the button on the layered bar.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-357_Data-Subtotals_Function_Average.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-357_Data-Subtotals_Function_Average.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-357_Data-Subtotals_Function_Average.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-357_Data-Subtotals_Function_Average.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,63 @@ +<!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_Function Average.</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-357: Data-)Subtotals_Function Average. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch applicaiton. + 2.Create a new spreadsheet document. + 3.Insert some data for Subtotals. +Following data as a reference: +Level Code No. Team Name +BS 20 4 B Elle +BS 20 6 C Sweet +BS 20 2 A Chcomic +CS 30 5 A Ally +MS 10 1 A Joker +MS 10 3 B Kevin +</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></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)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog +appears. The current tab page is '1st Group'. The combo box 'Group by' +use the first column label as its default value.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Average'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(1,...) shown in formula bar.</p> +<p>The function Average returns the average (arithmetic mean) of the arguments. Ignore the characters and blanks. </p> +<p>The result is correct.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-358_Data-Subtotals_Function_Countnumbers_only.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-358_Data-Subtotals_Function_Countnumbers_only.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-358_Data-Subtotals_Function_Countnumbers_only.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-358_Data-Subtotals_Function_Countnumbers_only.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,62 @@ +<!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_Function Count(numbers only).</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-358: Data-)Subtotals_Function Count(numbers only). <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch application. + 2.Create a new spreadsheet document. + 3.Insert some data for Subtotals. + Following data as a reference: +Level Code No. Team Name +BS 20 4 B Elle +BS 20 6 C Sweet +BS 20 2 A Chcomic +CS 30 5 A Ally +MS 10 1 A Joker +MS 10 3 B Kevin +</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></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)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog +appears. The current tab page is '1st Group'. The combo box 'Group by' +use the first column label as its default value.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select a column label which contains numbers or characters to group the data.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Count(numbers only)'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(2,...) shown in formula bar.</p> +<p>The function Count(numbers only) uses COUNT() to get the number of entries in a number field . The result is correct.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-359_Data-Subtotals_Function_Max.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-359_Data-Subtotals_Function_Max.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-359_Data-Subtotals_Function_Max.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-359_Data-Subtotals_Function_Max.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,62 @@ +<!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_Function Max.</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-359: Data-)Subtotals_Function Max. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch Application. + 2.Create a new spreadsheet document. + 3.Insert some data for Subtotals. +Following data as a reference: +Level Code No. Team Name +BS 20 4 B Elle +BS 20 6 C Sweet +BS 20 2 A Chcomic +CS 30 5 A Ally +MS 10 1 A Joker +MS 10 3 B Kevin +</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></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)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog +appears. The current tab page is '1st Group'. The combo box 'Group by' +use the first column label as its default value.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Max'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(4,...) shown in formula bar.</p> +<p>The function Max returns the largest value in a set of values .Ignore characters and blanks. The result is correct.</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> \ No newline at end of file Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-360_Data-Subtotals_Function_Min.html URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-360_Data-Subtotals_Function_Min.html?rev=1828389&view=auto ============================================================================== --- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-360_Data-Subtotals_Function_Min.html (added) +++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-360_Data-Subtotals_Function_Min.html Wed Apr 4 23:02:51 2018 @@ -0,0 +1,62 @@ +<!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_Function Min.</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-360: Data-)Subtotals_Function Min. <span style="font-size: 80%;">[Version : 1]</span></th></tr> +<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</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>1.Launch Application. + 2.Create a new spreadsheet document. + 3.Insert some data for Subtotals. +Following data as a reference: +Level Code No. Team Name +BS 20 4 B Elle +BS 20 6 C Sweet +BS 20 2 A Chcomic +CS 30 5 A Ally +MS 10 1 A Joker +MS 10 3 B Kevin +</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></p> + <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p> +<p></p> +<p></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)</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog +appears. The current tab page is '1st Group'. The combo box 'Group by' +use the first column label as its default value.</p> +<p></p> +<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Min'.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p></p> +<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p> +<p></p> +<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p> +<p></p> + <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(5,...) shown in formula bar.</p> +<p>The function Min returns the smallest value in a set of values .Ignore characters and blanks. The result is correct.</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> \ No newline at end of file