openoffice-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From ksch...@apache.org
Subject svn commit: r1828389 [18/31] - /openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/
Date Wed, 04 Apr 2018 23:03:02 GMT
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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-345: Sort Options_Include formats.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-346: Sort Options_Language.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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)&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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).&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-352: 1M Rows_Data-)Subtotals&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-357: Data-)Subtotals_Function Average.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</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).&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-359: Data-)Subtotals_Function Max.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;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>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-360: Data-)Subtotals_Function Min.&nbsp;<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">&nbsp;None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2">&nbsp;None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file



Mime
View raw message