openoffice-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From build...@apache.org
Subject svn commit: r1027863 [22/34] - in /websites/staging/ooo-site/trunk: cgi-bin/ content/ content/qa/testcase/ManualTesting/
Date Wed, 04 Apr 2018 23:27:23 GMT
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-368_Data-Subtotals_Options_Include_format.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-368_Data-Subtotals_Options_Include_format.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-368_Data-Subtotals_Options_Include_format.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,114 @@
+<!--#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_Options_Include format.</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-368: Data-)Subtotals_Options_Include format.&nbsp;<span style="font-size: 80%;">[Version  : 2]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 18/03/2014 04:35:23</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Last edit by:</span></td><td colspan="2">undefined - 03/04/2014 20:52:37</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>Using the reference file "Subtotals_1_AOOTest-368" as a reference, this is what is generally expected from this testcase:</p>
+<p>1. Left picure: Cell C2, C4's format is currency; C3, C5's format is number; C6's format is percent </p>
+<p>2. Picture in middle: Uncheck "Include formats" - Item No.3 is moved 
+from row 4 to row 3, by taking C3's format number while discarding C4's 
+format currency, aka change from "?2.00" to "2". The change of other 
+cells uses the same logic.</p>
+<p>3. Right picture: Check "Include formats" - Item No.3 is moved from 
+row 4 to row 3 with C4's format currency. The change of other cells uses
+ the same logic.<strong><br>
+</strong></p>
+<p><strong>  In summary:</strong> "Include formats" means cell's format 
+will be along with cell's data when sorting; Not "Include formats" means
+ cell's format will inherit new position's cell's format when sorting. </p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>1)&nbsp; Install Apache OpenOffice.</p>
+<p>2) Attached files</p>
+<p>&nbsp;&nbsp; - Subtotals_1_AOOTest-368 (use as a reference)</p>
+<p>&nbsp;&nbsp; - AOO_Calc_Subtotal_Formatted_YuXehn.ods (sample spreadsheet) </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>Open sample spreadsheet AOO_Calc_Subtotal_Formatted_YuZhen.ods</p></td><td><p>File opens successfully in AOO</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).&nbsp; In this 
+instance, click on column C</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Column C should now be highlighted</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">3</td><td><p>Click 'Data -&gt; Subtotals'.</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p--> </actions></p></td><td><p>The 'Subtotals' dialog appears. The current tab page is '1st Group'. </p>
+<p>&nbsp;</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select "Data"</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>"Data" should now be highlighted.</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select "Data"</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Should be able to select "Data"</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Count'.</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Should be able to highlight "Count"</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">7</td><td><p>Make sure the check box 'Include format' is unchecked in tab page 'Options'.</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>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>The subtotal result is displayed in hierarchy 
+according to the 1st group option specified.&nbsp; Please refer 
+"Summary" above, item #2 for expected output.&nbsp; Essentially, the 
+data will be sorted according to the 'Group by'option specified.The cell
+ format can't be moved with its original value, the new value moved into
+ the cell inherit the format.</p>
+<p>&nbsp;</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">9</td><td><p>Press Ctrl_Z to Undo subtotal.</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Worksheet is returned to it's original state.</p>
+<p>&nbsp;</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">10</td><td><p>Repeat step 2-6.</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>&nbsp;</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">11</td><td><p>Check the check box 'Include format' in tab page 'Options'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Click 'OK' button.</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>The subtotal result is displayed in hierarchy 
+according to the 1st  group option specified.&nbsp; Please refer 
+"Summary" above, item #3 for  expected output.&nbsp; Essentially, the 
+data will be sorted according to the 'Group by'option specified.&nbsp; 
+The cell format will be moved with its original value.</p>
+<p>&nbsp;</p>
+<p>&nbsp;</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-369_Data-Subtotals_Options_Sort:Do_not_sort.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-369_Data-Subtotals_Options_Sort:Do_not_sort.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-369_Data-Subtotals_Options_Sort:Do_not_sort.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,87 @@
+<!--#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_Options_Sort:Do not sort.</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-369: Data-)Subtotals_Options_Sort:Do not sort.&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
+CS	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 will used 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 which contains numbers 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 'Sum'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Shift to tab page 'Options'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The tab page 'Options' appears.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Uncheck the check box 'pre-sort area according to groups'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>All items below label 'Sort' are disabled.</p>
+<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>The subtotal result is displayed correctly. And the data only be grouped, do not be 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-370_Data-Subtotals_Page_break_between_groups.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-370_Data-Subtotals_Page_break_between_groups.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-370_Data-Subtotals_Page_break_between_groups.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_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-370: 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>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-371_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-371_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-371_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,83 @@
+<!--#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_Recalculates subtotals when source data changed.</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-371: Data-)Subtotals_Recalculates subtotals when source data changed.&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 will used 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 which contains numbers 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 a function.</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>Change the values in some source data cells.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The subtotal results will be recalculated and refreshed after that.</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-372_Data-Subtotals_Restore_Defaults.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-372_Data-Subtotals_Restore_Defaults.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-372_Data-Subtotals_Restore_Defaults.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,86 @@
+<!--#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_Restore Defaults.</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-372: Data-)Subtotals_Restore Defaults.&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. 
+</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>Change the setting.(Change the selection or input value or check/uncheck the check box)</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Click the button 'Restore Defaults'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>It will restore the setting to the initial status before you modify it. </p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Shift to the '2nd Group' tab page.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Repeat step 3-4.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>It will restore the setting to the initial status before you modify it. </p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Shift to the '3rd Group' 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>Repeat step 3-4.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>It will restore the setting to the initial status before you modify it.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Shift to the 'Options' tab page.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Repeat step 3-4.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>It will restore the setting to the initial status before you modify it.</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-373_Data-Subtotals_Result_can_be_refreshed_automatically.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-373_Data-Subtotals_Result_can_be_refreshed_automatically.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-373_Data-Subtotals_Result_can_be_refreshed_automatically.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,83 @@
+<!--#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_Result can be refreshed automatically.</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-373: Data-)Subtotals_Result can be refreshed automatically.&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 will used 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 which contains numbers 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 a function .</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>Modify the source data, and check the results of subtotals.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The results will be refreshed automatically. They are 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>
+
+  </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>

Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-374_Data-Subtotals_UIOptionsDefault_Status.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-374_Data-Subtotals_UIOptionsDefault_Status.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-374_Data-Subtotals_UIOptionsDefault_Status.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,72 @@
+<!--#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_UI(Options)Default Status.</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-374: Data-)Subtotals_UI(Options)Default Status.&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
+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 data range. Then select '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">3</td><td><p>Shift to the tab page 'Options'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Verify the default status under Groups.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Only the check box 'Pre-sort area according to groups' is checked. Others are unchecked.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Verify the default status under Sort.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The radio button 'Ascending' is checked as default.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Verify other check boxes 'Include formats' and 'Custom sort order'.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>They are unchecked. And the drop-down list is disabled.</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-376_Support_1024ColumnsData-Subtotals_Page_break_between_groups.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-376_Support_1024ColumnsData-Subtotals_Page_break_between_groups.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-376_Support_1024ColumnsData-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: Support_1024Columns(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-376: Support_1024Columns(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 between Column 1000 and Column 1024(Column ALM and Column AMJ).
+ 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-377_AOO4.0Data-Subtotals_Recalculate_and_refresh_results_when_data_rows_deleted.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-377_AOO4.0Data-Subtotals_Recalculate_and_refresh_results_when_data_rows_deleted.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-377_AOO4.0Data-Subtotals_Recalculate_and_refresh_results_when_data_rows_deleted.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,87 @@
+<!--#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: AOO4.0;Data-)Subtotals_Recalculate and refresh results when data rows deleted.</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-377: AOO4.0;Data-)Subtotals_Recalculate and refresh results when data rows deleted.&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 will used 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 which contains numbers 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 a function .</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>Delete rows of source data, and check the results of subtotals.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The results will be recalculated and refreshed automatically. They are correct.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Undo and Redo it.</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>It works correctly.</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-378_Cell_is_not_locked_after_switch_from_validity_cell_to_source_cells.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-378_Cell_is_not_locked_after_switch_from_validity_cell_to_source_cells.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-378_Cell_is_not_locked_after_switch_from_validity_cell_to_source_cells.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,77 @@
+<!--#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: Cell is not locked after switch from validity cell to source cells</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-378: Cell is not locked after switch from validity cell to source cells&nbsp;<span style="font-size: 80%;">[Version  : 2]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 31/03/2014 10:49:40</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>Open the sample file</p>
+<p>please get it from http://svn.apache.org/repos/asf/openoffice/test/test-data/testlink_samples/AOOTest_378.ods</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p>
+<p>&nbsp;</p></td><td><p>&nbsp;</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">3</td><td><p>On sheet1, select a value for Cell F19 </p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Select F14 (Any cell from Cell F14 to F17)</p>
+<p>&nbsp;</p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>&nbsp;</p>
+<p>&nbsp;</p></td></tr><tr><td width="5">5</td><td><p>Try to enter the edit mode</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify cells in sheet1 are editable</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Repeat several times</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Ditto</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><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="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-379_Cell_will_not_locked_after_switch_from_validity_cell_to_source_cells.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-379_Cell_will_not_locked_after_switch_from_validity_cell_to_source_cells.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-379_Cell_will_not_locked_after_switch_from_validity_cell_to_source_cells.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: Cell will not locked after switch from validity cell to source cells</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-379: Cell will not locked after switch from validity cell to source cells&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>Open the sample file</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>On sheet1, select a value for Cell F19 </p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Select F14 (Any cell from Cell F14 to F17)</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Try to enter the edit mode</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Verify cells in sheet1 are editable</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Repeat several times</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Ditto</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><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-383_Data_-_Validity_-_Criteria_-check_input_field_format_type_Decimal_00055.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-383_Data_-_Validity_-_Criteria_-check_input_field_format_type_Decimal_00055.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-383_Data_-_Validity_-_Criteria_-check_input_field_format_type_Decimal_00055.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,87 @@
+<!--#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 -) Validity -) Criteria -)check input field format/type (Decimal)_00055</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-383: Data -) Validity -) Criteria -)check input field format/type (Decimal)_00055&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>New a sc , select a cell range  and click menu 'Data -) Validity', select Criteria tab</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>select 'Decimal' from 'Allow'</p>
+<p>select 'equal'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Input field 'Value' appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Input 1.55555 into 'Value',click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Validity dialog is closed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Open Validity dialog again,input -2.7846153</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Validity dialog is closed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Open Validity dialog again,input time into 'Value',click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>An information about invalid format appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Input date into 'Value',click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>An information about invalid format appears</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>Input some letters into 'Value',click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>An information about invalid format appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>select 'between' from 'Data'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Input field 'Maximum' * 'Minimum' appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>repeat step 3 to step 8 ,check 'Maximum' * 'Minimum'</p>
+<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="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-384_Data_-_Validity_-_Criteria_-Date_-_not_between_00059.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-384_Data_-_Validity_-_Criteria_-Date_-_not_between_00059.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-384_Data_-_Validity_-_Criteria_-Date_-_not_between_00059.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,123 @@
+<!--#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 -) Validity -) Criteria -)Date -) not between_00059</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-384: Data -) Validity -) Criteria -)Date -) not between_00059&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:31</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>New a sc , select a cell range  and click menu 'Data -) Validity', select Criteria tab</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>select 'Date' from 'Allow'</p>
+<p>select 'not between'</p>
+<p>input '01/01/08' into 'Minimum'</p>
+<p>input '03/01/08' into 'Maximum'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>select 'Error Alert' 
+tab,check 'Show error message when invalid values are entered',input 
+some messages in 'Error message' ,click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Validity dialog is closed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Input '12/31/07' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Input '03/02/08' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Input '01/01/08' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The date you input in step 6 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Input '03/01/08' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The date you input in step 8 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Input '01/02/08' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The date you input in step 10 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Input '02/29/08' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The date you input in step 12 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">15</td><td><p>Input some letters in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">16</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The text you input in step 14 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">17</td><td><p>Input number between 39448 and 39508 (included) in the range,press 'Enter'</p>
+<p>PS: Datevalue('01/01/08')=39448</p>
+<p>    Datevalue('03/01/08')=39508</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">18</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The number you input in step 16 is not accepted</p>
+<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="5">21</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-385_Data_-_Validity_-_Criteria_-Decimal_-_equal_00061.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-385_Data_-_Validity_-_Criteria_-Decimal_-_equal_00061.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-385_Data_-_Validity_-_Criteria_-Decimal_-_equal_00061.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: Data -) Validity -) Criteria -)Decimal -) equal_00061</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-385: Data -) Validity -) Criteria -)Decimal -) equal_00061&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:31</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>New a sc , select a cell range  and click menu 'Data-) Validity', select Criteria tab</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>select 'Decimal' from 'Allow'</p>
+<p>select 'equal'</p>
+<p>input 0.33333333 into 'Value'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>select 'Error Alert' 
+tab,check 'Show error message when invalid values are entered',input 
+some messages in 'Error message' ,click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Validity dialog is closed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Input 0.33333333 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Input '=1/3' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Input 0.3 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The number you input in step 6 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Input 0.333333333 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The number you input in step 8 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Input letters in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The letters you input in step 10 is not accepted</p>
+<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="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-386_Data_-_Validity_-_Criteria_-Text_length_-greater_than_or_equal_00065.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-386_Data_-_Validity_-_Criteria_-Text_length_-greater_than_or_equal_00065.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-386_Data_-_Validity_-_Criteria_-Text_length_-greater_than_or_equal_00065.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,90 @@
+<!--#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 -) Validity -) Criteria -)Text length -)greater than or equal_00065</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-386: Data -) Validity -) Criteria -)Text length -)greater than or equal_00065&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:31</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>New a SC , select a cell range  and click menu 'Data -) Validity', select Criteria tab</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>select 'Text length' from 'Allow'</p>
+<p>select 'greater than or equal to'</p>
+<p>input 10 into 'Minimum'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>select 'Error Alert' 
+tab,check 'Show error message when invalid values are entered',input 
+some messages in 'Error message' ,click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Validity dialog is closed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Input 15 letters in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Input 10 letters in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Input 9 letters in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The text you input in step 6 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Input ' '(a blank) in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The text you input in step 8 is not accepted</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="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-387_Data_-_Validity_-_Criteria_-Time_-_between_through_00:00_00067.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-387_Data_-_Validity_-_Criteria_-Time_-_between_through_00:00_00067.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/AOOTest-387_Data_-_Validity_-_Criteria_-Time_-_between_through_00:00_00067.html Wed Apr  4 23:27:13 2018
@@ -0,0 +1,129 @@
+<!--#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 -) Validity -) Criteria -)Time -) between (through 00:00)_00067</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-387: Data -) Validity -) Criteria -)Time -) between (through 00:00)_00067&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:31</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>New a sc , select a cell range  and click menu 'Data -) Validity', select Criteria tab</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>select 'Time' from 'Allow'</p>
+<p>select 'between'</p>
+<p>input '27:00' into 'Maximum' (next day 3:00)</p>
+<p>input '21:00' into 'Minimum'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>select 'Error Alert' 
+tab,check 'Show error message when invalid values are entered',input 
+some messages in 'Error message' ,click ok</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>Validity dialog is closed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Input '27:00' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Input '21:00' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Input 1.125 in the range,press 'Enter'</p>
+<p>PS : TimeValue('27:00')=1.125</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Input 0.875 in the range,press 'Enter'</p>
+<p>PS : TimeValue('21:00')=0.875</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Input '03:00:01' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The time you input in step 8 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Input '20:59:59' in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The time you input in step 10 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Input 1.126 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The number you input in step 12 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">15</td><td><p>Input 0.874 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">16</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The number you input in step 14 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">17</td><td><p>Input letters in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">18</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The letters you input in step 16 is not accepted</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">19</td><td><p>Input 24:00 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>No message dialog</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">20</td><td><p>Input 12:00 in the range,press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>A stop message dialog appears</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">21</td><td><p>Press 'Enter'</p>
+<p></p>
+	<actions><!--[CDATA[</p--></actions></td><td><p>The time you input in step 19 is not accepted</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>



Mime
View raw message