You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openoffice.apache.org by bu...@apache.org on 2018/04/04 23:27:23 UTC

svn commit: r1027863 [20/34] - in /websites/staging/ooo-site/trunk: cgi-bin/ content/ content/qa/testcase/ManualTesting/

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-341_Sort_Options_Copy_sort_results_to.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-341_Sort_Options_Copy_sort_results_to.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-341_Sort_Options_Copy_sort_results_to.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,110 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Sort Options_Copy sort results to.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <p>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-341: Sort Options_Copy sort results to.&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.</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 check the option 'Copy results to'.</p>
+<p>Input the target range, for example, '$sheet3.$A4' then click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending and case sensitively.</p>
+<p>And the sort result is inserted into the cell A4 in sheet3.</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>Move focus to another sheet then select a cell range.</p>
+<p>Click Create-)Name-)Define.</p>
+<p>Input a name then click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A named range is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Set focus to the original data.</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">8</td><td><p>Select an item in 'Sort by' list and choose 'Ascending'.</p>
+<p>Click Options tab in Sort dialog and check the option 'Copy results to'.</p>
+<p>Click the little triangle and select the named range in the list.</p>
+<p>Click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending and case sensitively.</p>
+<p>And the sort result is inserted into the predefined range.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</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">10</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">11</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">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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-342_Sort_Options_Custom_sort_order_Predefined_in_preferences_Copy_list_from.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-342_Sort_Options_Custom_sort_order_Predefined_in_preferences_Copy_list_from.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-342_Sort_Options_Custom_sort_order_Predefined_in_preferences_Copy_list_from.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,137 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Sort Options_Custom sort order_Predefined in preferences_Copy list from.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <p>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-342: Sort Options_Custom sort order_Predefined in preferences_Copy list from.&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.Create a sc and input data into cells, for example,
+red
+yellow
+blue
+green
+white
+black
+2.Select the cell range.
+3.Click Tools-)Options-)OpenOffice.org Spreadsheet-)Sort Lists.
+4.Click Copy button.
+5.The color list is copied to Lists field.
+6.Click OK to close Preferences.</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.</p>
+<p>For example,</p>
+<p>Color</p>
+<p>black</p>
+<p>yellow</p>
+<p>blue</p>
+<p>black</p>
+<p>white</p>
+<p>red</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 uncheck the option 'Custom sort order' then click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending in alphabet order.</p>
+<p>For this sample:</p>
+<p>Color</p>
+<p>black</p>
+<p>black</p>
+<p>blue</p>
+<p>red</p>
+<p>white</p>
+<p>yellow</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 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 an item in 'Sort by' list and choose 'Ascending'.</p>
+<p>Click Options tab in Sort dialog and check the option 'Custom sort order'.</p>
+<p>Select 'red,yellow,blue,green,white,black' then click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending in custom order.</p>
+<p>For this sample:</p>
+<p>Color</p>
+<p>red</p>
+<p>yellow</p>
+<p>blue</p>
+<p>white</p>
+<p>black</p>
+<p>black</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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-343_Sort_Options_Custom_sort_order_Predefined_in_preferences_New_list.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-343_Sort_Options_Custom_sort_order_Predefined_in_preferences_New_list.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-343_Sort_Options_Custom_sort_order_Predefined_in_preferences_New_list.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,130 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Sort Options_Custom sort order_Predefined in preferences_New list.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <p>&nbsp;</p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-343: Sort Options_Custom sort order_Predefined in preferences_New list.&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.Click Tools-)Options-)OpenOffice Calc-)Sort Lists.
+2.Click New button.
+3.Input custom order in Entries field, for example, 'red yellow blue green 
+white black', then click Add button.
+4.Click OK to close Options.</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 Applications 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.</p>
+<p>For example,</p>
+<p>Color</p>
+<p>black</p>
+<p>yellow</p>
+<p>blue</p>
+<p>black</p>
+<p>white</p>
+<p>red</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 first by' list and choose 'Ascending'.</p>
+<p>Click Options tab in Sort dialog and uncheck the option 'Custom sort order' then click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending in alphabet order.</p>
+<p>For this sample:</p>
+<p>Color</p>
+<p>black</p>
+<p>black</p>
+<p>blue</p>
+<p>red</p>
+<p>white</p>
+<p>yellow</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 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 an item in 'Sort by' list and choose 'Ascending'.</p>
+<p>Click Options tab in Sort dialog and check the option 'Custom sort order'.</p>
+<p>Select 'red,yellow,blue,green,white,black' then click OK.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify data is sorted by the selected item ascending in custom order.</p>
+<p>For this sample:</p>
+<p>Color</p>
+<p>red</p>
+<p>yellow</p>
+<p>blue</p>
+<p>white</p>
+<p>black</p>
+<p>black</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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-344_Sort_Options_Direction_Sort_columns.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,98 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-345_Sort_Options_Include_formats.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,126 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-346_Sort_Options_Language.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,110 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-347_Sort_Options_Multiple_sort_data_overlap.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,105 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-348_Sort_Options_Multiple_sort_no_data_overlap.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,107 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-349_Sort_Options_Range_contains_column_labels.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,102 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-350_Support_1024ColumnsSort_Criteria_Sort_first_by.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,94 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-351_Support_1024ColumnsSort_Options_Multiple_settings.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,96 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-352_1M_Rows_Data-Subtotals.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,67 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-353_1M_Rows_Data-Subtotals_Page_break_between_groups.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,74 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-354_Data-Subtotals_Calculate_subtotals_for_No_column_selected.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,89 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-355_Data-Subtotals_Delete_Subtotals_on_different_subtotal_ranges_in_one_sheet.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-355_Data-Subtotals_Delete_Subtotals_on_different_subtotal_ranges_in_one_sheet.html (added)
+++ websites/staging/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:27:13 2018
@@ -0,0 +1,71 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<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>
+<!--#include virtual="/scripts/google-analytics.js" --> 
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+  <div id="topbara">
+    <!--#include virtual="/topnav.html" -->
+    <div id="breadcrumbsa"><a href="/">home</a>&nbsp;&raquo;&nbsp;<a href="/qa/">qa</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/">testcase</a>&nbsp;&raquo;&nbsp;<a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+  </div>
+  <div id="clear"></div>
+  
+  
+  <div id="content">
+    
+    
+    <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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>