You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openoffice.apache.org by ks...@apache.org on 2018/03/30 18:38:37 UTC
svn commit: r1828075 [11/31] -
/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/263_Data-Subtotals_Function_Min.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/263_Data-Subtotals_Function_Min.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/263_Data-Subtotals_Function_Min.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/263_Data-Subtotals_Function_Min.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,62 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Function Min.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-360: Data-)Subtotals_Function Min. <span style="font-size: 80%;">[Version : 1]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p></p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>1.Launch Application.
+ 2.Create a new spreadsheet document.
+ 3.Insert some data for Subtotals.
+Following data as a reference:
+Level Code No. Team Name
+BS 20 4 B Elle
+BS 20 6 C Sweet
+BS 20 2 A Chcomic
+CS 30 5 A Ally
+MS 10 1 A Joker
+MS 10 3 B Kevin
+</p></td></tr><tr><td><span class="label">#:</span></td><td><span class="label">Step actions:</span></td><td><span class="label">Expected Results:</span></td></tr><tr><td width="5">1</td><td><p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">2</td><td><p>Select the cell range
+that you want to calculate subtotals for. (The contents in the first row
+ will be regarded as column labels)</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog
+appears. The current tab page is '1st Group'. The combo box 'Group by'
+use the first column label as its default value.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Min'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(5,...) shown in formula bar.</p>
+<p>The function Min returns the smallest value in a set of values .Ignore characters and blanks. The result is correct.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/264_Data-Subtotals_Function_Product.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/264_Data-Subtotals_Function_Product.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/264_Data-Subtotals_Function_Product.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/264_Data-Subtotals_Function_Product.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,64 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Function Product.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-361: Data-)Subtotals_Function Product. <span style="font-size: 80%;">[Version : 1]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p></p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>1.Launch Application.
+ 2.Create a new spreadsheet document.
+ 3.Insert some data for Subtotals.
+Following data as a reference:
+Level Code No. Team Name
+BS 20 4 B Elle
+BS 20 6 C Sweet
+BS 20 2 A Chcomic
+CS 30 5 A Ally
+MS 10 1 A Joker
+MS 10 3 B Kevin
+</p></td></tr><tr><td><span class="label">#:</span></td><td><span class="label">Step actions:</span></td><td><span class="label">Expected Results:</span></td></tr><tr><td width="5">1</td><td><p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">2</td><td><p>Select the cell range
+that you want to calculate subtotals for. (The contents in the first row
+ will be regarded as column labels)</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog
+appears. The current tab page is '1st Group'. The combo box 'Group by'
+use the first column label as its default value.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Product'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(6,...) shown in formula bar.</p>
+<p>The function Product can multiplies the numbers. Ignore the characters and blanks. </p>
+<p>For example, A1=3, A2=4, A3=5 then Product(A1:A3)=60 </p>
+<p>The result is correct.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/265_Data-Subtotals_Function_StDevPpopulation.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/265_Data-Subtotals_Function_StDevPpopulation.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/265_Data-Subtotals_Function_StDevPpopulation.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/265_Data-Subtotals_Function_StDevPpopulation.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,58 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Function StDevP(population).</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-362: Data-)Subtotals_Function StDevP(population). <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 width="20%" valign="top"><span class="label">Last edit by:</span></td><td colspan="2">undefined - 28/01/2014 02:47:37</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: </p>
+<p><img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdYAAACYCAIAAADWXV+lAAAQuElEQVR4nO2d0aGjOgxEUxcFUQ/V0EyK0X4AwZIlA7lZsKQ5H+9luQ5EE3tiDEgvAgAA8BCvowbz+JKMc7v9ML3LF1/wl/f+7709xnsaXq9XiFAAACtnLPjSoP+JBf+Ww0/Sz0dtMI8HP34AAH/Ags806AEXHxIAcI2/WPB6ZszPjlULrlq+p+HzV+U138k0yoOwHQ6D8gmLBuM4sv2LFZXPpmF6qw3MHbMGxYLNhXcVoo3jsP2l/PCz2Lv8lOwTtHfS0HPff/HZtD28pwFzcQB+x/W14G0AlifGxWvFgtWW/M+FbYwz34n8m9jhexrq9VF20j6Pr2Jv3DSXf7HDaQ30He//Ko3p/Lt4g08M8rdLCttocGYntZ7vifl2+ygAgF/y9SyYb9/HaG3BRst53P8/jtW2+r3WEkf9CQ8bWJ/ZamDA9nB6mUDZrRqm9SEPG1xto4Zv7QEA8Eu+tWA5Jm3ntVqu2xfX/fy3Yd9HOzz+bCRXBBRjUhvIyLUGYq3g5LuqTyga7vsrw282OLOTlp7tPQAAfslzs2B6T8MwTcsf39PwGqdpkCfBv50F8yUA/TOrDcpdtRvwpe2z77InsEqbM9/IpTYnZsEAgP/D95fj/rgWTNtMa78+t0+02hZc7bC5Flw0YLEUK6C6GRUNdDX2Bgfrptd2Wy1ky6n6YYNzbT6vzbVgbQ8AgF/y0B0R+2btvogjCy53+JlIW5+NNdhXC5a7B9jNA+uFQKUB10NrUJ64K151sFshsroza7VEbXCmjb5D/Y4I9rMJLwbgZxxacPfAFAAAbvFowXLCjEVLAIBTPFowsRN7TIEBAG45sGB5YxIAAOTmAQv+7SF9kTx8ggLpFUgevgAWfDfJwycokF6B5OELYMF3kzx8ggLpFUgevgAWfDf
JwycokF6BPfw6J1a+W0KftuDfKu7h+1MUP3gMw8LrI79VB0g3CEsFqtQZr/A3RQoLrh7fCf7tC2DBdyMVZ4/qag8bm8Sx4GyD0PgZDh71B27BRSoXyqXDAiz4brjiVa4EJSmPRRgLTjcIYcHrqzXq9zRoD6wrN+tv3eWz8V28JvE2H3p2a8FcR9aszBDMtfbQj1n47Ww1ZV6Kd/mWJeiR52dw0+20DmAMQlUB/5yzYO07/dKV+qKy4D2xt0iZXRUPKNetinxZ+8SFFw7w0Gv6tOBax6Lde5kyaVp7tGCzl4guKPtl0RmddTu9AxwPwt6/2fOcsGD1O/3OlbpDseBtVBtDmCXhs36rx1m83cdpYpcWrOn42VY58N4mlAWrAcr8kXXUDrqd0QGqQegtrvMcW/Bx7KddqT80C6b1REg/B3rVsw3bgksc9JluLbjScbdetdaDWwu2PnCVE3jtn7oFe+p2ZgcQg1BTIAbnLFj7Tr9wpf7QLXg5EZrKH2A9FfXpWbAPurVgNUfuMM3bhZsrb+yKV/ty3GfLl7NgBzQ6QDUIMQsWba67Un9YFsxujxGLLmeD5SuWnQrA6NKCLR1ZQQutjQfRheLlSl69rnd1LdifAo1BiLVg8Z1+6UrdYVrw+v0XHXyd7c/aCLdefy5Z+vjN7sGC1TMuVcfPJRvS2/Tb63YUxa1MmWUnfMuNvLqHp27X/g0uBqGuQID58AkLJu07/dqV+uLnpuOapy04H8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+4BkLBgAAsPCABf/2kL5IHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9f8LQFV49m8IcL+J/7vNH8IjH7X/FFaZkO2DcXU4EG1UMSV4ZAQPbwldi33uLqkde/0IMF6zkSSD6Vyh6b8ktEA1KTKO5bxdPFERVoMY/NH6HmEAgJt2Aj
Uljw1zs8PN5B/9sfQK2eRA3xZQQ0ID2lWbGVf3EBFWgwj69hOJoFW0MgJrDgkv4seM8DEWTaK4huQM1Mb0QUX4GS9zSM8/FChDUEYvIHC/ZUHeYkPVhwYyWsSGATRfPYBrTnU4QFlzmur60Fh54DH64F74nShAXzV1E06sGCubnq6m5e7N+IAxtQleQsuQXPo5Hb+qshEIcvZ8FB80f3Z8GNixEhumZUA+KJj2HBYkXt6lpwgMmGyR8sOOCpQp8WvFWIkH+KsDIf0oC0Zfvsl+PGl+QjwdkhEJRfzILj0J0FFzNdbV7lv2cGNCDji8FNaSsXZ8Ex+nmDLy3YW3WYk/RgwdZcgYgXlIjRL+MZ0FzN96oSMng049LluCDmYvFqX44Td9Tod0SE8AIiet6C85E8fIIC6RVIHr4AFnw3ycMnKJBegeThC2DBd5M8fIIC6RVIHr4AFnw3ycMnKJBegeThC56xYAAAAAsPWPBvD+mL5OETFEivQPLwBbDgu0kePkGB9AokD18AC76b5OETFEivQPLwBU9bMKpmxABVM3R2XcpurShQ9vQQ/bwBDz/gGL9EDxaMqhneQdUMnV0M/tCxVIAJFKSfNyjD/79j3MNzzP1ZMKpmuANVM3TMbDtcgSofVfQkEUX4/3mMe3CM/iwYVTN8g6oZG/b4ZwoEz0ypUIRvjXGRkac4xypOsaqVC7HRR0KJHiy4sRiMqhnOQNWMnXl8DdOsLYdLC+7aIn5PfRKgX0bYjHQYhk+fGqa3UT5D24hZsHq8g1kwqma4BVUzGPP4YuvihgLZLfgDH+Ob3c7jMM3TUJ5YqV3reGOn9GfBqJrhE1TNkOhL5ERYiGh0gH2ML/K9p2Gc19XJbY1SLZ9hbuxd2z4tGFUznIGqGQosatuClY4e3JX38JtjfB5f41TMhaexWGio5Dm/sTO6s2BUzfAHqmYY8KtH5o8Q7+iy28dDXo6zxrhYBd5eG+UztI0eLKMHCxaga
oYzUDXDZu/f5uW4hVLE3udtf0WEb45xcS8E+5t6t0O9cdW/Z0WftuB8JA+foEB6BZKHL4AF303y8AkKpFcgefgCWPDdJA+foEB6BZKHL4AF303y8AkKpFcgefiCZywYAADAwgMW/NtD+iJ5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzB0xaMqhkxQNUMFV0WQwH59EFYZPhqxZD//WxxN88u92DBqJrhHVTNUNFlIV2B9zS8xnEM0MMPYeFbFUO6scj/TX8WjKoZ7kDVDJWTmdLKv4fo4YcU4dsVQ3JIQT1aMKpm+AZVM1SY19QKaD9cYdnDb6SEWxSp84SraztKldT3NLzGqVgJE6tiZf801ovuoQcLbiwGo2qGM1A1Q0Vk7KoUKPRJ4MHMgq1gF2fYKxDJVzyrZb12WeZgK5LnK7NsdZ/30YMFo2pGEFA1Q6U+m5MKMHmCJwumCxZcLWSp7fWeJme58nU35x39WTCqZvgEVTNU1Oy/XAHtTDC0B19YiOCvzemZsuZ+1oIfN5U+LRhVM5yBqhkq1tWMr04E49C6HKdeS8As+NIOD4/X7n+omuEPVM1QsftrqYA6EXzaFv4vZfhmxRDdQsW67efWKX0t+JQF6/u8jx4suHUOhqoZ/YOqGSq2LEwB3WxDLwgrS+G1Ri0LrXqVdUfEKQtOfkdEPpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8ASz4bpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8wTMWDAAAYOEBC/7tIX2RPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+oA8LVtPmyz8EuVc9Zv/b765Xi55kfDSDiPffVqY0IkpcNYO02NVkDxHpwIKttPmomuGF8rFO7WHRpA8oU5n8mqEpkLVqBpEeOyz46x0eHo8f0k6bj6oZLtGKnmRN02OlejBOBBNWzSAiI3ZY8Nc7PDweO2TrWfgg01
5BbANCyvaC9zQcp+n5NO0jb9cdiPD12CsLFlYRxpk7sOBWj0PVDD+s657qzDenBc/jaxiGeokcVTPEebAWez0LZj0qjAP3bsFluyBGHNyAPnMVWDDLfMhWhZXLITmrZpAdu+K8RZeK48A9WPB5KUMkDI5uQNuQggUzGgokrprRiF2b/Jbb3BvBxtMW3Eibj6oZLsHlOBXbgjNXzWjErq8/LCcTkRz4eQu20+ajaoYXyh/LYnRkvynNkIVQNWMLvxW7cUfEPL7GKZIDd2DBREba/OovMXplSAMyyg6krppBdjWGUoHMVTNasVs3pc1jsHWaPiw4E8nDJyiQXoE/hR9hMZIBC76b5OETFEivwF/CD+fAsODbSR4+QYH0CnwZ/rqsE8uAYcH3kzx8ggLpFUgevuAZCwYAALDwgAX/9pC+SB4+QYH0CiQPXwALvpvk4RMUSK9A8vAFsOC7SR4+QYH0CiQPX/C0BetXOZdb+nke9w/Or4hG7n/yjqH0VTMWqhupdAUyV804uNcs3q1oOz1Y8DAIfdckf7L4wucNrr+NuAYkfjjTP6C8ImUhVM2ABRf0YMHyme/1MfBV82i1M0Ia0DLdHcZRz46WNU2PJgsRqmbAggu6sOCZJTGZR9YX3U97BSEN6D3PslIGklWqshARqma0LXhfd6zzt68nFWUmKLbS9Z6GYRwHT+uVfViwyK+1bGADOMhCMMU2IFiwyrEFZ66aQUSlRFr9V1a8SPFlXi7LmUl0YsG7B6/VBfQzjwi1MyIbECxY5dCCM1fNWDCzAxeFCCeerFZt6TChbS8WvHnwVt+lsfjjUOWSyAYEC1Y5sODMVTM2TpTwfA3TLKvHldS1WnzQjQUv2s/bZLj8SmLVzohsQJbtZr0ct9K24MRVM5Qf7MYsWDi0agMOvaEfC15XGYqKGcXluEC1MyIbUFXgADelER1YcOaqGWytdw24uRZMpTRGUTlY8OHxzClAudZeD2Z+wuGXyAY
kB0D2qhkrTQvOXDWjGNhFsO07ItgVt8/7m1PjvnnagvORPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QuesWAAAAALD1jwbw/pi+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQK7OHrD2effrjC4YMYNU9bMAoXRQKFiwT701/sEThtCJQ4fwD0CNOCvScf+IoeLBiFi2KAwkWc0lC4BNUQ4B069NPJZFpw7MQYJj1YMAoXuQeFi46w03Uq/Tm4GWkWbGUrKs6imFCfDML7n6btdMKXdl1YMAoXeQeFi9qIM+zjWXCgDl9TWbA6xuuiGDw12jC9ZT5hmWrNBX1YMAoXxQAWXLMu9V5aC3Y2j7sKt+BhGF5VSQy9/8gCD8yCvSZL68SCUbgoBLBgi0trwdGvSnELLnP+irzg1a/Sbr28RobZ8RzQiwWjcFEEYMEmV9eCXbnIRaw7Ith6hOEA86jV1oEFlzs8PJ7R/1C4yD8oXGSCy3E75k1p1ay4fsmK2MOC1R0eHs/qfyhc5B4ULiopw2YXnA8s2HsPP8S24G39wSqKsW6s3BYWXO7w8Hhm/0PhIu+gcBGnWM+0FVAux3lykC/I0wHO8LQF5yN5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzBMxYMAABg4VYLBgAA8P+ABQMAwGPAggEA4DFgwQAA8BiwYAAAeAxYMAAAPAYsGAAAHgMWDAAAjwELBgCAx4AFAwDAY/wDnMX5I6sspewAAAAASUVORK5CYII="></p></td></tr><tr><td><span class="label">#:</span></td><td><span class="label">Step actions:</span></td><td><span class="label">Expected Results:</span><
/td></tr><tr><td width="5">1</td><td><p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">2</td><td><p>Select the cell range
+that you want to calculate subtotals for. (The contents in the first row
+ will be regarded as column labels)</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog
+appears. The current tab page is '1st Group'. The combo box 'Group by'
+use the first column label as its default value.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'StDevP(population)'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(8,...) shown in formula bar.</p>
+<p>Calculates standard deviation based on the entire population given as
+ arguments. The standard deviation is a measure of how widely values are
+ dispersed from the average value (the mean).</p>
+<p>Using follow formula:</p>
+<p> ('n' is an integer and n)0)</p>
+<p>The result is correct.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/266_Data-Subtotals_Function_Sum.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/266_Data-Subtotals_Function_Sum.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/266_Data-Subtotals_Function_Sum.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/266_Data-Subtotals_Function_Sum.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,63 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Function Sum.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-363: Data-)Subtotals_Function Sum. <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 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>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(9,...) shown in formula bar.</p>
+<p>The function Sum uses SUM() to add all the numbers in a column. The
+blanks and characters will be ignored. The result is correct.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/267_Data-Subtotals_Function_Varsample.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/267_Data-Subtotals_Function_Varsample.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/267_Data-Subtotals_Function_Varsample.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/267_Data-Subtotals_Function_Varsample.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,57 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Function Var(sample).</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-364: Data-)Subtotals_Function Var(sample). <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 width="20%" valign="top"><span class="label">Last edit by:</span></td><td colspan="2">undefined - 28/01/2014 02:49:10</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:</p>
+<p><img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdYAAACYCAIAAADWXV+lAAAQuElEQVR4nO2d0aGjOgxEUxcFUQ/V0EyK0X4AwZIlA7lZsKQ5H+9luQ5EE3tiDEgvAgAA8BCvowbz+JKMc7v9ML3LF1/wl/f+7709xnsaXq9XiFAAACtnLPjSoP+JBf+Ww0/Sz0dtMI8HP34AAH/Ags806AEXHxIAcI2/WPB6ZszPjlULrlq+p+HzV+U138k0yoOwHQ6D8gmLBuM4sv2LFZXPpmF6qw3MHbMGxYLNhXcVoo3jsP2l/PCz2Lv8lOwTtHfS0HPff/HZtD28pwFzcQB+x/W14G0AlifGxWvFgtWW/M+FbYwz34n8m9jhexrq9VF20j6Pr2Jv3DSXf7HDaQ30He//Ko3p/Lt4g08M8rdLCttocGYntZ7vifl2+ygAgF/y9SyYb9/HaG3BRst53P8/jtW2+r3WEkf9CQ8bWJ/ZamDA9nB6mUDZrRqm9SEPG1xto4Zv7QEA8Eu+tWA5Jm3ntVqu2xfX/fy3Yd9HOzz+bCRXBBRjUhvIyLUGYq3g5LuqTyga7vsrw282OLOTlp7tPQAAfslzs2B6T8MwTcsf39PwGqdpkCfBv50F8yUA/TOrDcpdtRvwpe2z77InsEqbM9/IpTYnZsEAgP/D95fj/rgWTNtMa78+t0+02hZc7bC5Flw0YLEUK6C6GRUNdDX2Bgfrptd2Wy1ky6n6YYNzbT6vzbVgbQ8AgF/y0B0R+2btvogjCy53+JlIW5+NNdhXC5a7B9jNA+uFQKUB10NrUJ64K151sFshsroza7VEbXCmjb5D/Y4I9rMJLwbgZxxacPfAFAAAbvFowXLCjEVLAIBTPFowsRN7TIEBAG45sGB5YxIAAOTmAQv+7SF9kTx8ggLpFUgevgAWfDfJwycokF6B5OELYMF3kzx8ggLpFUgevgAWfDf
JwycokF6BPfw6J1a+W0KftuDfKu7h+1MUP3gMw8LrI79VB0g3CEsFqtQZr/A3RQoLrh7fCf7tC2DBdyMVZ4/qag8bm8Sx4GyD0PgZDh71B27BRSoXyqXDAiz4brjiVa4EJSmPRRgLTjcIYcHrqzXq9zRoD6wrN+tv3eWz8V28JvE2H3p2a8FcR9aszBDMtfbQj1n47Ww1ZV6Kd/mWJeiR52dw0+20DmAMQlUB/5yzYO07/dKV+qKy4D2xt0iZXRUPKNetinxZ+8SFFw7w0Gv6tOBax6Lde5kyaVp7tGCzl4guKPtl0RmddTu9AxwPwt6/2fOcsGD1O/3OlbpDseBtVBtDmCXhs36rx1m83cdpYpcWrOn42VY58N4mlAWrAcr8kXXUDrqd0QGqQegtrvMcW/Bx7KddqT80C6b1REg/B3rVsw3bgksc9JluLbjScbdetdaDWwu2PnCVE3jtn7oFe+p2ZgcQg1BTIAbnLFj7Tr9wpf7QLXg5EZrKH2A9FfXpWbAPurVgNUfuMM3bhZsrb+yKV/ty3GfLl7NgBzQ6QDUIMQsWba67Un9YFsxujxGLLmeD5SuWnQrA6NKCLR1ZQQutjQfRheLlSl69rnd1LdifAo1BiLVg8Z1+6UrdYVrw+v0XHXyd7c/aCLdefy5Z+vjN7sGC1TMuVcfPJRvS2/Tb63YUxa1MmWUnfMuNvLqHp27X/g0uBqGuQID58AkLJu07/dqV+uLnpuOapy04H8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+4BkLBgAAsPCABf/2kL5IHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9f8LQFV49m8IcL+J/7vNH8IjH7X/FFaZkO2DcXU4EG1UMSV4ZAQPbwldi33uLqkde/0IMF6zkSSD6Vyh6b8ktEA1KTKO5bxdPFERVoMY/NH6HmEAgJt2Aj
Uljw1zs8PN5B/9sfQK2eRA3xZQQ0ID2lWbGVf3EBFWgwj69hOJoFW0MgJrDgkv4seM8DEWTaK4huQM1Mb0QUX4GS9zSM8/FChDUEYvIHC/ZUHeYkPVhwYyWsSGATRfPYBrTnU4QFlzmur60Fh54DH64F74nShAXzV1E06sGCubnq6m5e7N+IAxtQleQsuQXPo5Hb+qshEIcvZ8FB80f3Z8GNixEhumZUA+KJj2HBYkXt6lpwgMmGyR8sOOCpQp8WvFWIkH+KsDIf0oC0Zfvsl+PGl+QjwdkhEJRfzILj0J0FFzNdbV7lv2cGNCDji8FNaSsXZ8Ex+nmDLy3YW3WYk/RgwdZcgYgXlIjRL+MZ0FzN96oSMng049LluCDmYvFqX44Td9Tod0SE8AIiet6C85E8fIIC6RVIHr4AFnw3ycMnKJBegeThC2DBd5M8fIIC6RVIHr4AFnw3ycMnKJBegeThC56xYAAAAAsPWPBvD+mL5OETFEivQPLwBbDgu0kePkGB9AokD18AC76b5OETFEivQPLwBU9bMKpmxABVM3R2XcpurShQ9vQQ/bwBDz/gGL9EDxaMqhneQdUMnV0M/tCxVIAJFKSfNyjD/79j3MNzzP1ZMKpmuANVM3TMbDtcgSofVfQkEUX4/3mMe3CM/iwYVTN8g6oZG/b4ZwoEz0ypUIRvjXGRkac4xypOsaqVC7HRR0KJHiy4sRiMqhnOQNWMnXl8DdOsLYdLC+7aIn5PfRKgX0bYjHQYhk+fGqa3UT5D24hZsHq8g1kwqma4BVUzGPP4YuvihgLZLfgDH+Ob3c7jMM3TUJ5YqV3reGOn9GfBqJrhE1TNkOhL5ERYiGh0gH2ML/K9p2Gc19XJbY1SLZ9hbuxd2z4tGFUznIGqGQosatuClY4e3JX38JtjfB5f41TMhaexWGio5Dm/sTO6s2BUzfAHqmYY8KtH5o8Q7+iy28dDXo6zxrhYBd5eG+UztI0eLKMHCxaga
oYzUDXDZu/f5uW4hVLE3udtf0WEb45xcS8E+5t6t0O9cdW/Z0WftuB8JA+foEB6BZKHL4AF303y8AkKpFcgefgCWPDdJA+foEB6BZKHL4AF303y8AkKpFcgefiCZywYAADAwgMW/NtD+iJ5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzB0xaMqhkxQNUMFV0WQwH59EFYZPhqxZD//WxxN88u92DBqJrhHVTNUNFlIV2B9zS8xnEM0MMPYeFbFUO6scj/TX8WjKoZ7kDVDJWTmdLKv4fo4YcU4dsVQ3JIQT1aMKpm+AZVM1SY19QKaD9cYdnDb6SEWxSp84SraztKldT3NLzGqVgJE6tiZf801ovuoQcLbiwGo2qGM1A1Q0Vk7KoUKPRJ4MHMgq1gF2fYKxDJVzyrZb12WeZgK5LnK7NsdZ/30YMFo2pGEFA1Q6U+m5MKMHmCJwumCxZcLWSp7fWeJme58nU35x39WTCqZvgEVTNU1Oy/XAHtTDC0B19YiOCvzemZsuZ+1oIfN5U+LRhVM5yBqhkq1tWMr04E49C6HKdeS8As+NIOD4/X7n+omuEPVM1QsftrqYA6EXzaFv4vZfhmxRDdQsW67efWKX0t+JQF6/u8jx4suHUOhqoZ/YOqGSq2LEwB3WxDLwgrS+G1Ri0LrXqVdUfEKQtOfkdEPpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8ASz4bpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8wTMWDAAAYOEBC/7tIX2RPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+oA8LVtPmyz8EuVc9Zv/b765Xi55kfDSDiPffVqY0IkpcNYO02NVkDxHpwIKttPmomuGF8rFO7WHRpA8oU5n8mqEpkLVqBpEeOyz46x0eHo8f0k6bj6oZLtGKnmRN02OlejBOBBNWzSAiI3ZY8Nc7PDweO2TrWfgg01
5BbANCyvaC9zQcp+n5NO0jb9cdiPD12CsLFlYRxpk7sOBWj0PVDD+s657qzDenBc/jaxiGeokcVTPEebAWez0LZj0qjAP3bsFluyBGHNyAPnMVWDDLfMhWhZXLITmrZpAdu+K8RZeK48A9WPB5KUMkDI5uQNuQggUzGgokrprRiF2b/Jbb3BvBxtMW3Eibj6oZLsHlOBXbgjNXzWjErq8/LCcTkRz4eQu20+ajaoYXyh/LYnRkvynNkIVQNWMLvxW7cUfEPL7GKZIDd2DBREba/OovMXplSAMyyg6krppBdjWGUoHMVTNasVs3pc1jsHWaPiw4E8nDJyiQXoE/hR9hMZIBC76b5OETFEivwF/CD+fAsODbSR4+QYH0CnwZ/rqsE8uAYcH3kzx8ggLpFUgevuAZCwYAALDwgAX/9pC+SB4+QYH0CiQPXwALvpvk4RMUSK9A8vAFsOC7SR4+QYH0CiQPX/C0BetXOZdb+nke9w/Or4hG7n/yjqH0VTMWqhupdAUyV804uNcs3q1oOz1Y8DAIfdckf7L4wucNrr+NuAYkfjjTP6C8ImUhVM2ABRf0YMHyme/1MfBV82i1M0Ia0DLdHcZRz46WNU2PJgsRqmbAggu6sOCZJTGZR9YX3U97BSEN6D3PslIGklWqshARqma0LXhfd6zzt68nFWUmKLbS9Z6GYRwHT+uVfViwyK+1bGADOMhCMMU2IFiwyrEFZ66aQUSlRFr9V1a8SPFlXi7LmUl0YsG7B6/VBfQzjwi1MyIbECxY5dCCM1fNWDCzAxeFCCeerFZt6TChbS8WvHnwVt+lsfjjUOWSyAYEC1Y5sODMVTM2TpTwfA3TLKvHldS1WnzQjQUv2s/bZLj8SmLVzohsQJbtZr0ct9K24MRVM5Qf7MYsWDi0agMOvaEfC15XGYqKGcXluEC1MyIbUFXgADelER1YcOaqGWytdw24uRZMpTRGUTlY8OHxzClAudZeD2Z+wuGXyAY
kB0D2qhkrTQvOXDWjGNhFsO07ItgVt8/7m1PjvnnagvORPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QuesWAAAAALD1jwbw/pi+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQK7OHrD2effrjC4YMYNU9bMAoXRQKFiwT701/sEThtCJQ4fwD0CNOCvScf+IoeLBiFi2KAwkWc0lC4BNUQ4B069NPJZFpw7MQYJj1YMAoXuQeFi46w03Uq/Tm4GWkWbGUrKs6imFCfDML7n6btdMKXdl1YMAoXeQeFi9qIM+zjWXCgDl9TWbA6xuuiGDw12jC9ZT5hmWrNBX1YMAoXxQAWXLMu9V5aC3Y2j7sKt+BhGF5VSQy9/8gCD8yCvSZL68SCUbgoBLBgi0trwdGvSnELLnP+irzg1a/Sbr28RobZ8RzQiwWjcFEEYMEmV9eCXbnIRaw7Ith6hOEA86jV1oEFlzs8PJ7R/1C4yD8oXGSCy3E75k1p1ay4fsmK2MOC1R0eHs/qfyhc5B4ULiopw2YXnA8s2HsPP8S24G39wSqKsW6s3BYWXO7w8Hhm/0PhIu+gcBGnWM+0FVAux3lykC/I0wHO8LQF5yN5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzBMxYMAABg4VYLBgAA8P+ABQMAwGPAggEA4DFgwQAA8BiwYAAAeAxYMAAAPAYsGAAAHgMWDAAAjwELBgCAx4AFAwDAY/wDnMX5I6sspewAAAAASUVORK5CYII="></p>
+<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>Select the cell range
+that you want to calculate subtotals for. (The contents in the first row
+ will be regarded as column labels)</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotal' dialog
+appears. The current tab page is '1st Group'. The combo box 'Group by'
+use the first column label as its default value.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select label of a column which contains numbers or characters to group the data.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select a check box of the column labels that you want to subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Var(sample)'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed in hierarchy according to the 1st group option specified.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click the cell that contains the result of subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>There is a formula =SUBTOTAL(10,...) shown in formula bar.</p>
+<p>Estimates variance based on a sample.</p>
+<p>Using follow formula:</p>
+<p> ('n' is an integer and n)1)</p>
+<p>The result is correct.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/268_Data-Subtotals_Label:Subtotal_on_one_column_not_the_used_for_Group_by.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/268_Data-Subtotals_Label%3ASubtotal_on_one_column_not_the_used_for_Group_by.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/268_Data-Subtotals_Label:Subtotal_on_one_column_not_the_used_for_Group_by.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/268_Data-Subtotals_Label:Subtotal_on_one_column_not_the_used_for_Group_by.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,66 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Label:Subtotal on one column not the used for Group by.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-365: Data-)Subtotals_Label:Subtotal on one column not the used for Group by. <span style="font-size: 80%;">[Version : 1]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p></p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>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 one check box of the column labels which
+contains numbers that you want to subtotal but not the column 'Group
+by'.</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>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is displayed correctly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Check the labels for subtotal results.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The labels' format for each group is {value} {Function} .</p>
+<p>For example, CS Sum. </p>
+<p>The label for whole range is Grand Total.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/269_Data-Subtotals_Layered_buttons_on_left_side_bar_for_subtotal_results.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/269_Data-Subtotals_Layered_buttons_on_left_side_bar_for_subtotal_results.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/269_Data-Subtotals_Layered_buttons_on_left_side_bar_for_subtotal_results.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/269_Data-Subtotals_Layered_buttons_on_left_side_bar_for_subtotal_results.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,69 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Layered buttons on left side bar for subtotal results.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-366: Data-)Subtotals_Layered buttons on left side bar for subtotal results. <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 width="20%" valign="top"><span class="label">Last edit by:</span></td><td colspan="2">undefined - 28/01/2014 02:49:53</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: </p>
+<p><img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdYAAACYCAIAAADWXV+lAAAQuElEQVR4nO2d0aGjOgxEUxcFUQ/V0EyK0X4AwZIlA7lZsKQ5H+9luQ5EE3tiDEgvAgAA8BCvowbz+JKMc7v9ML3LF1/wl/f+7709xnsaXq9XiFAAACtnLPjSoP+JBf+Ww0/Sz0dtMI8HP34AAH/Ags806AEXHxIAcI2/WPB6ZszPjlULrlq+p+HzV+U138k0yoOwHQ6D8gmLBuM4sv2LFZXPpmF6qw3MHbMGxYLNhXcVoo3jsP2l/PCz2Lv8lOwTtHfS0HPff/HZtD28pwFzcQB+x/W14G0AlifGxWvFgtWW/M+FbYwz34n8m9jhexrq9VF20j6Pr2Jv3DSXf7HDaQ30He//Ko3p/Lt4g08M8rdLCttocGYntZ7vifl2+ygAgF/y9SyYb9/HaG3BRst53P8/jtW2+r3WEkf9CQ8bWJ/ZamDA9nB6mUDZrRqm9SEPG1xto4Zv7QEA8Eu+tWA5Jm3ntVqu2xfX/fy3Yd9HOzz+bCRXBBRjUhvIyLUGYq3g5LuqTyga7vsrw282OLOTlp7tPQAAfslzs2B6T8MwTcsf39PwGqdpkCfBv50F8yUA/TOrDcpdtRvwpe2z77InsEqbM9/IpTYnZsEAgP/D95fj/rgWTNtMa78+t0+02hZc7bC5Flw0YLEUK6C6GRUNdDX2Bgfrptd2Wy1ky6n6YYNzbT6vzbVgbQ8AgF/y0B0R+2btvogjCy53+JlIW5+NNdhXC5a7B9jNA+uFQKUB10NrUJ64K151sFshsroza7VEbXCmjb5D/Y4I9rMJLwbgZxxacPfAFAAAbvFowXLCjEVLAIBTPFowsRN7TIEBAG45sGB5YxIAAOTmAQv+7SF9kTx8ggLpFUgevgAWfDfJwycokF6B5OELYMF3kzx8ggLpFUgevgAWfDf
JwycokF6BPfw6J1a+W0KftuDfKu7h+1MUP3gMw8LrI79VB0g3CEsFqtQZr/A3RQoLrh7fCf7tC2DBdyMVZ4/qag8bm8Sx4GyD0PgZDh71B27BRSoXyqXDAiz4brjiVa4EJSmPRRgLTjcIYcHrqzXq9zRoD6wrN+tv3eWz8V28JvE2H3p2a8FcR9aszBDMtfbQj1n47Ww1ZV6Kd/mWJeiR52dw0+20DmAMQlUB/5yzYO07/dKV+qKy4D2xt0iZXRUPKNetinxZ+8SFFw7w0Gv6tOBax6Lde5kyaVp7tGCzl4guKPtl0RmddTu9AxwPwt6/2fOcsGD1O/3OlbpDseBtVBtDmCXhs36rx1m83cdpYpcWrOn42VY58N4mlAWrAcr8kXXUDrqd0QGqQegtrvMcW/Bx7KddqT80C6b1REg/B3rVsw3bgksc9JluLbjScbdetdaDWwu2PnCVE3jtn7oFe+p2ZgcQg1BTIAbnLFj7Tr9wpf7QLXg5EZrKH2A9FfXpWbAPurVgNUfuMM3bhZsrb+yKV/ty3GfLl7NgBzQ6QDUIMQsWba67Un9YFsxujxGLLmeD5SuWnQrA6NKCLR1ZQQutjQfRheLlSl69rnd1LdifAo1BiLVg8Z1+6UrdYVrw+v0XHXyd7c/aCLdefy5Z+vjN7sGC1TMuVcfPJRvS2/Tb63YUxa1MmWUnfMuNvLqHp27X/g0uBqGuQID58AkLJu07/dqV+uLnpuOapy04H8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+4BkLBgAAsPCABf/2kL5IHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9f8LQFV49m8IcL+J/7vNH8IjH7X/FFaZkO2DcXU4EG1UMSV4ZAQPbwldi33uLqkde/0IMF6zkSSD6Vyh6b8ktEA1KTKO5bxdPFERVoMY/NH6HmEAgJt2Aj
Uljw1zs8PN5B/9sfQK2eRA3xZQQ0ID2lWbGVf3EBFWgwj69hOJoFW0MgJrDgkv4seM8DEWTaK4huQM1Mb0QUX4GS9zSM8/FChDUEYvIHC/ZUHeYkPVhwYyWsSGATRfPYBrTnU4QFlzmur60Fh54DH64F74nShAXzV1E06sGCubnq6m5e7N+IAxtQleQsuQXPo5Hb+qshEIcvZ8FB80f3Z8GNixEhumZUA+KJj2HBYkXt6lpwgMmGyR8sOOCpQp8WvFWIkH+KsDIf0oC0Zfvsl+PGl+QjwdkhEJRfzILj0J0FFzNdbV7lv2cGNCDji8FNaSsXZ8Ex+nmDLy3YW3WYk/RgwdZcgYgXlIjRL+MZ0FzN96oSMng049LluCDmYvFqX44Td9Tod0SE8AIiet6C85E8fIIC6RVIHr4AFnw3ycMnKJBegeThC2DBd5M8fIIC6RVIHr4AFnw3ycMnKJBegeThC56xYAAAAAsPWPBvD+mL5OETFEivQPLwBbDgu0kePkGB9AokD18AC76b5OETFEivQPLwBU9bMKpmxABVM3R2XcpurShQ9vQQ/bwBDz/gGL9EDxaMqhneQdUMnV0M/tCxVIAJFKSfNyjD/79j3MNzzP1ZMKpmuANVM3TMbDtcgSofVfQkEUX4/3mMe3CM/iwYVTN8g6oZG/b4ZwoEz0ypUIRvjXGRkac4xypOsaqVC7HRR0KJHiy4sRiMqhnOQNWMnXl8DdOsLYdLC+7aIn5PfRKgX0bYjHQYhk+fGqa3UT5D24hZsHq8g1kwqma4BVUzGPP4YuvihgLZLfgDH+Ob3c7jMM3TUJ5YqV3reGOn9GfBqJrhE1TNkOhL5ERYiGh0gH2ML/K9p2Gc19XJbY1SLZ9hbuxd2z4tGFUznIGqGQosatuClY4e3JX38JtjfB5f41TMhaexWGio5Dm/sTO6s2BUzfAHqmYY8KtH5o8Q7+iy28dDXo6zxrhYBd5eG+UztI0eLKMHCxaga
oYzUDXDZu/f5uW4hVLE3udtf0WEb45xcS8E+5t6t0O9cdW/Z0WftuB8JA+foEB6BZKHL4AF303y8AkKpFcgefgCWPDdJA+foEB6BZKHL4AF303y8AkKpFcgefiCZywYAADAwgMW/NtD+iJ5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzB0xaMqhkxQNUMFV0WQwH59EFYZPhqxZD//WxxN88u92DBqJrhHVTNUNFlIV2B9zS8xnEM0MMPYeFbFUO6scj/TX8WjKoZ7kDVDJWTmdLKv4fo4YcU4dsVQ3JIQT1aMKpm+AZVM1SY19QKaD9cYdnDb6SEWxSp84SraztKldT3NLzGqVgJE6tiZf801ovuoQcLbiwGo2qGM1A1Q0Vk7KoUKPRJ4MHMgq1gF2fYKxDJVzyrZb12WeZgK5LnK7NsdZ/30YMFo2pGEFA1Q6U+m5MKMHmCJwumCxZcLWSp7fWeJme58nU35x39WTCqZvgEVTNU1Oy/XAHtTDC0B19YiOCvzemZsuZ+1oIfN5U+LRhVM5yBqhkq1tWMr04E49C6HKdeS8As+NIOD4/X7n+omuEPVM1QsftrqYA6EXzaFv4vZfhmxRDdQsW67efWKX0t+JQF6/u8jx4suHUOhqoZ/YOqGSq2LEwB3WxDLwgrS+G1Ri0LrXqVdUfEKQtOfkdEPpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8ASz4bpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8wTMWDAAAYOEBC/7tIX2RPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+oA8LVtPmyz8EuVc9Zv/b765Xi55kfDSDiPffVqY0IkpcNYO02NVkDxHpwIKttPmomuGF8rFO7WHRpA8oU5n8mqEpkLVqBpEeOyz46x0eHo8f0k6bj6oZLtGKnmRN02OlejBOBBNWzSAiI3ZY8Nc7PDweO2TrWfgg01
5BbANCyvaC9zQcp+n5NO0jb9cdiPD12CsLFlYRxpk7sOBWj0PVDD+s657qzDenBc/jaxiGeokcVTPEebAWez0LZj0qjAP3bsFluyBGHNyAPnMVWDDLfMhWhZXLITmrZpAdu+K8RZeK48A9WPB5KUMkDI5uQNuQggUzGgokrprRiF2b/Jbb3BvBxtMW3Eibj6oZLsHlOBXbgjNXzWjErq8/LCcTkRz4eQu20+ajaoYXyh/LYnRkvynNkIVQNWMLvxW7cUfEPL7GKZIDd2DBREba/OovMXplSAMyyg6krppBdjWGUoHMVTNasVs3pc1jsHWaPiw4E8nDJyiQXoE/hR9hMZIBC76b5OETFEivwF/CD+fAsODbSR4+QYH0CnwZ/rqsE8uAYcH3kzx8ggLpFUgevuAZCwYAALDwgAX/9pC+SB4+QYH0CiQPXwALvpvk4RMUSK9A8vAFsOC7SR4+QYH0CiQPX/C0BetXOZdb+nke9w/Or4hG7n/yjqH0VTMWqhupdAUyV804uNcs3q1oOz1Y8DAIfdckf7L4wucNrr+NuAYkfjjTP6C8ImUhVM2ABRf0YMHyme/1MfBV82i1M0Ia0DLdHcZRz46WNU2PJgsRqmbAggu6sOCZJTGZR9YX3U97BSEN6D3PslIGklWqshARqma0LXhfd6zzt68nFWUmKLbS9Z6GYRwHT+uVfViwyK+1bGADOMhCMMU2IFiwyrEFZ66aQUSlRFr9V1a8SPFlXi7LmUl0YsG7B6/VBfQzjwi1MyIbECxY5dCCM1fNWDCzAxeFCCeerFZt6TChbS8WvHnwVt+lsfjjUOWSyAYEC1Y5sODMVTM2TpTwfA3TLKvHldS1WnzQjQUv2s/bZLj8SmLVzohsQJbtZr0ct9K24MRVM5Qf7MYsWDi0agMOvaEfC15XGYqKGcXluEC1MyIbUFXgADelER1YcOaqGWytdw24uRZMpTRGUTlY8OHxzClAudZeD2Z+wuGXyAY
kB0D2qhkrTQvOXDWjGNhFsO07ItgVt8/7m1PjvnnagvORPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QuesWAAAAALD1jwbw/pi+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQK7OHrD2effrjC4YMYNU9bMAoXRQKFiwT701/sEThtCJQ4fwD0CNOCvScf+IoeLBiFi2KAwkWc0lC4BNUQ4B069NPJZFpw7MQYJj1YMAoXuQeFi46w03Uq/Tm4GWkWbGUrKs6imFCfDML7n6btdMKXdl1YMAoXeQeFi9qIM+zjWXCgDl9TWbA6xuuiGDw12jC9ZT5hmWrNBX1YMAoXxQAWXLMu9V5aC3Y2j7sKt+BhGF5VSQy9/8gCD8yCvSZL68SCUbgoBLBgi0trwdGvSnELLnP+irzg1a/Sbr28RobZ8RzQiwWjcFEEYMEmV9eCXbnIRaw7Ith6hOEA86jV1oEFlzs8PJ7R/1C4yD8oXGSCy3E75k1p1ay4fsmK2MOC1R0eHs/qfyhc5B4ULiopw2YXnA8s2HsPP8S24G39wSqKsW6s3BYWXO7w8Hhm/0PhIu+gcBGnWM+0FVAux3lykC/I0wHO8LQF5yN5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzBMxYMAABg4VYLBgAA8P+ABQMAwGPAggEA4DFgwQAA8BiwYAAAeAxYMAAAPAYsGAAAHgMWDAAAjwELBgCAx4AFAwDAY/wDnMX5I6sspewAAAAASUVORK5CYII="></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 'Subtotals' 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>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>There is a bar on the left side with the layered buttons on it.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click the '-' button to fold the data range.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>It works successfully.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Click the '+' button to unfold the data range.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>It works successfully.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Click the '1' button on the top of the left side bar.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>All layers will be folded. Only the labels of column and the Grand Total are shown.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Click the '3' button on the top of the left side bar.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>All layers will be unfolded. All data and results are shown.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Click the '2' button on the top of the left side bar.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>All data layers will be unfolded. Only the labels of column and the subtotal results are shown.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/26_Animation-Emphasis-Basic-75_Amount_Transparency_Effect.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/26_Animation-Emphasis-Basic-75_Amount_Transparency_Effect.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/26_Animation-Emphasis-Basic-75_Amount_Transparency_Effect.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/26_Animation-Emphasis-Basic-75_Amount_Transparency_Effect.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,26 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Animation-Emphasis-Basic-75% Amount Transparency Effect</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-1916: Animation-Emphasis-Basic-75% Amount Transparency Effect <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 - 29/11/2013 07:41:47</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>Check OOXML(MS PowerPoint) support with feature 75% Amount Transparency Basic Emphasis Animation Effect in AOO</p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>Need apache.org account to get sample 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>Open
+ the sample document FFCMS2007FFCSD_Animation_Transparency0030.pptx from
+
+svn(https://svn.apache.org/repos/asf/openoffice/test/test-data/ooxml/MS_PowerPoint_2007/animation/emphasis)
+ in MS PowerPoint 2007 ,Play it by main menu (or press F5) and See
+animation effect (see attached :
+FFCMS2007FFCSD_Animation_Transparency0030.avi)</p></td><td></td></tr><tr><td width="5">2</td><td><p>Open it in AOO</p></td><td><p>It can be opened successfully</p></td></tr><tr><td width="5">3</td><td><p>Play it by main menu(or press F5)</p>
+<p>Check the following 75% Amount Transparency Basic Emphasis Animation Effect in step 4 is the same with display in step 1</p></td><td><p>It displays same between MS PowerPoint and AOO Impress</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">Usability</td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/270_Data-Subtotals_No_column_selected_for_Group_by.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/270_Data-Subtotals_No_column_selected_for_Group_by.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/270_Data-Subtotals_No_column_selected_for_Group_by.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/270_Data-Subtotals_No_column_selected_for_Group_by.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,47 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_No column selected for Group by.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-367: Data-)Subtotals_No column selected for Group by. <span style="font-size: 80%;">[Version : 1]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Last edit by:</span></td><td colspan="2">undefined - 28/01/2014 02:50:25</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: </p>
+<p><img alt="" src="data:image/png;base64,iVBORw0KGgoAAAANSUhEUgAAAdYAAACYCAIAAADWXV+lAAAQuElEQVR4nO2d0aGjOgxEUxcFUQ/V0EyK0X4AwZIlA7lZsKQ5H+9luQ5EE3tiDEgvAgAA8BCvowbz+JKMc7v9ML3LF1/wl/f+7709xnsaXq9XiFAAACtnLPjSoP+JBf+Ww0/Sz0dtMI8HP34AAH/Ags806AEXHxIAcI2/WPB6ZszPjlULrlq+p+HzV+U138k0yoOwHQ6D8gmLBuM4sv2LFZXPpmF6qw3MHbMGxYLNhXcVoo3jsP2l/PCz2Lv8lOwTtHfS0HPff/HZtD28pwFzcQB+x/W14G0AlifGxWvFgtWW/M+FbYwz34n8m9jhexrq9VF20j6Pr2Jv3DSXf7HDaQ30He//Ko3p/Lt4g08M8rdLCttocGYntZ7vifl2+ygAgF/y9SyYb9/HaG3BRst53P8/jtW2+r3WEkf9CQ8bWJ/ZamDA9nB6mUDZrRqm9SEPG1xto4Zv7QEA8Eu+tWA5Jm3ntVqu2xfX/fy3Yd9HOzz+bCRXBBRjUhvIyLUGYq3g5LuqTyga7vsrw282OLOTlp7tPQAAfslzs2B6T8MwTcsf39PwGqdpkCfBv50F8yUA/TOrDcpdtRvwpe2z77InsEqbM9/IpTYnZsEAgP/D95fj/rgWTNtMa78+t0+02hZc7bC5Flw0YLEUK6C6GRUNdDX2Bgfrptd2Wy1ky6n6YYNzbT6vzbVgbQ8AgF/y0B0R+2btvogjCy53+JlIW5+NNdhXC5a7B9jNA+uFQKUB10NrUJ64K151sFshsroza7VEbXCmjb5D/Y4I9rMJLwbgZxxacPfAFAAAbvFowXLCjEVLAIBTPFowsRN7TIEBAG45sGB5YxIAAOTmAQv+7SF9kTx8ggLpFUgevgAWfDfJwycokF6B5OELYMF3kzx8ggLpFUgevgAWfDf
JwycokF6BPfw6J1a+W0KftuDfKu7h+1MUP3gMw8LrI79VB0g3CEsFqtQZr/A3RQoLrh7fCf7tC2DBdyMVZ4/qag8bm8Sx4GyD0PgZDh71B27BRSoXyqXDAiz4brjiVa4EJSmPRRgLTjcIYcHrqzXq9zRoD6wrN+tv3eWz8V28JvE2H3p2a8FcR9aszBDMtfbQj1n47Ww1ZV6Kd/mWJeiR52dw0+20DmAMQlUB/5yzYO07/dKV+qKy4D2xt0iZXRUPKNetinxZ+8SFFw7w0Gv6tOBax6Lde5kyaVp7tGCzl4guKPtl0RmddTu9AxwPwt6/2fOcsGD1O/3OlbpDseBtVBtDmCXhs36rx1m83cdpYpcWrOn42VY58N4mlAWrAcr8kXXUDrqd0QGqQegtrvMcW/Bx7KddqT80C6b1REg/B3rVsw3bgksc9JluLbjScbdetdaDWwu2PnCVE3jtn7oFe+p2ZgcQg1BTIAbnLFj7Tr9wpf7QLXg5EZrKH2A9FfXpWbAPurVgNUfuMM3bhZsrb+yKV/ty3GfLl7NgBzQ6QDUIMQsWba67Un9YFsxujxGLLmeD5SuWnQrA6NKCLR1ZQQutjQfRheLlSl69rnd1LdifAo1BiLVg8Z1+6UrdYVrw+v0XHXyd7c/aCLdefy5Z+vjN7sGC1TMuVcfPJRvS2/Tb63YUxa1MmWUnfMuNvLqHp27X/g0uBqGuQID58AkLJu07/dqV+uLnpuOapy04H8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+4BkLBgAAsPCABf/2kL5IHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9f8LQFV49m8IcL+J/7vNH8IjH7X/FFaZkO2DcXU4EG1UMSV4ZAQPbwldi33uLqkde/0IMF6zkSSD6Vyh6b8ktEA1KTKO5bxdPFERVoMY/NH6HmEAgJt2Aj
Uljw1zs8PN5B/9sfQK2eRA3xZQQ0ID2lWbGVf3EBFWgwj69hOJoFW0MgJrDgkv4seM8DEWTaK4huQM1Mb0QUX4GS9zSM8/FChDUEYvIHC/ZUHeYkPVhwYyWsSGATRfPYBrTnU4QFlzmur60Fh54DH64F74nShAXzV1E06sGCubnq6m5e7N+IAxtQleQsuQXPo5Hb+qshEIcvZ8FB80f3Z8GNixEhumZUA+KJj2HBYkXt6lpwgMmGyR8sOOCpQp8WvFWIkH+KsDIf0oC0Zfvsl+PGl+QjwdkhEJRfzILj0J0FFzNdbV7lv2cGNCDji8FNaSsXZ8Ex+nmDLy3YW3WYk/RgwdZcgYgXlIjRL+MZ0FzN96oSMng049LluCDmYvFqX44Td9Tod0SE8AIiet6C85E8fIIC6RVIHr4AFnw3ycMnKJBegeThC2DBd5M8fIIC6RVIHr4AFnw3ycMnKJBegeThC56xYAAAAAsPWPBvD+mL5OETFEivQPLwBbDgu0kePkGB9AokD18AC76b5OETFEivQPLwBU9bMKpmxABVM3R2XcpurShQ9vQQ/bwBDz/gGL9EDxaMqhneQdUMnV0M/tCxVIAJFKSfNyjD/79j3MNzzP1ZMKpmuANVM3TMbDtcgSofVfQkEUX4/3mMe3CM/iwYVTN8g6oZG/b4ZwoEz0ypUIRvjXGRkac4xypOsaqVC7HRR0KJHiy4sRiMqhnOQNWMnXl8DdOsLYdLC+7aIn5PfRKgX0bYjHQYhk+fGqa3UT5D24hZsHq8g1kwqma4BVUzGPP4YuvihgLZLfgDH+Ob3c7jMM3TUJ5YqV3reGOn9GfBqJrhE1TNkOhL5ERYiGh0gH2ML/K9p2Gc19XJbY1SLZ9hbuxd2z4tGFUznIGqGQosatuClY4e3JX38JtjfB5f41TMhaexWGio5Dm/sTO6s2BUzfAHqmYY8KtH5o8Q7+iy28dDXo6zxrhYBd5eG+UztI0eLKMHCxaga
oYzUDXDZu/f5uW4hVLE3udtf0WEb45xcS8E+5t6t0O9cdW/Z0WftuB8JA+foEB6BZKHL4AF303y8AkKpFcgefgCWPDdJA+foEB6BZKHL4AF303y8AkKpFcgefiCZywYAADAwgMW/NtD+iJ5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzB0xaMqhkxQNUMFV0WQwH59EFYZPhqxZD//WxxN88u92DBqJrhHVTNUNFlIV2B9zS8xnEM0MMPYeFbFUO6scj/TX8WjKoZ7kDVDJWTmdLKv4fo4YcU4dsVQ3JIQT1aMKpm+AZVM1SY19QKaD9cYdnDb6SEWxSp84SraztKldT3NLzGqVgJE6tiZf801ovuoQcLbiwGo2qGM1A1Q0Vk7KoUKPRJ4MHMgq1gF2fYKxDJVzyrZb12WeZgK5LnK7NsdZ/30YMFo2pGEFA1Q6U+m5MKMHmCJwumCxZcLWSp7fWeJme58nU35x39WTCqZvgEVTNU1Oy/XAHtTDC0B19YiOCvzemZsuZ+1oIfN5U+LRhVM5yBqhkq1tWMr04E49C6HKdeS8As+NIOD4/X7n+omuEPVM1QsftrqYA6EXzaFv4vZfhmxRDdQsW67efWKX0t+JQF6/u8jx4suHUOhqoZ/YOqGSq2LEwB3WxDLwgrS+G1Ri0LrXqVdUfEKQtOfkdEPpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8ASz4bpKHT1AgvQLJwxfAgu8mefgEBdIrkDx8wTMWDAAAYOEBC/7tIX2RPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+oA8LVtPmyz8EuVc9Zv/b765Xi55kfDSDiPffVqY0IkpcNYO02NVkDxHpwIKttPmomuGF8rFO7WHRpA8oU5n8mqEpkLVqBpEeOyz46x0eHo8f0k6bj6oZLtGKnmRN02OlejBOBBNWzSAiI3ZY8Nc7PDweO2TrWfgg01
5BbANCyvaC9zQcp+n5NO0jb9cdiPD12CsLFlYRxpk7sOBWj0PVDD+s657qzDenBc/jaxiGeokcVTPEebAWez0LZj0qjAP3bsFluyBGHNyAPnMVWDDLfMhWhZXLITmrZpAdu+K8RZeK48A9WPB5KUMkDI5uQNuQggUzGgokrprRiF2b/Jbb3BvBxtMW3Eibj6oZLsHlOBXbgjNXzWjErq8/LCcTkRz4eQu20+ajaoYXyh/LYnRkvynNkIVQNWMLvxW7cUfEPL7GKZIDd2DBREba/OovMXplSAMyyg6krppBdjWGUoHMVTNasVs3pc1jsHWaPiw4E8nDJyiQXoE/hR9hMZIBC76b5OETFEivwF/CD+fAsODbSR4+QYH0CnwZ/rqsE8uAYcH3kzx8ggLpFUgevuAZCwYAALDwgAX/9pC+SB4+QYH0CiQPXwALvpvk4RMUSK9A8vAFsOC7SR4+QYH0CiQPX/C0BetXOZdb+nke9w/Or4hG7n/yjqH0VTMWqhupdAUyV804uNcs3q1oOz1Y8DAIfdckf7L4wucNrr+NuAYkfjjTP6C8ImUhVM2ABRf0YMHyme/1MfBV82i1M0Ia0DLdHcZRz46WNU2PJgsRqmbAggu6sOCZJTGZR9YX3U97BSEN6D3PslIGklWqshARqma0LXhfd6zzt68nFWUmKLbS9Z6GYRwHT+uVfViwyK+1bGADOMhCMMU2IFiwyrEFZ66aQUSlRFr9V1a8SPFlXi7LmUl0YsG7B6/VBfQzjwi1MyIbECxY5dCCM1fNWDCzAxeFCCeerFZt6TChbS8WvHnwVt+lsfjjUOWSyAYEC1Y5sODMVTM2TpTwfA3TLKvHldS1WnzQjQUv2s/bZLj8SmLVzohsQJbtZr0ct9K24MRVM5Qf7MYsWDi0agMOvaEfC15XGYqKGcXluEC1MyIbUFXgADelER1YcOaqGWytdw24uRZMpTRGUTlY8OHxzClAudZeD2Z+wuGXyAY
kB0D2qhkrTQvOXDWjGNhFsO07ItgVt8/7m1PjvnnagvORPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QtgwXeTPHyCAukVSB6+ABZ8N8nDJyiQXoHk4QuesWAAAAALD1jwbw/pi+ThExRIr0Dy8AWw4LtJHj5BgfQKJA9fAAu+m+ThExRIr0Dy8AWw4LtJHj5BgfQK7OHrD2effrjC4YMYNU9bMAoXRQKFiwT701/sEThtCJQ4fwD0CNOCvScf+IoeLBiFi2KAwkWc0lC4BNUQ4B069NPJZFpw7MQYJj1YMAoXuQeFi46w03Uq/Tm4GWkWbGUrKs6imFCfDML7n6btdMKXdl1YMAoXeQeFi9qIM+zjWXCgDl9TWbA6xuuiGDw12jC9ZT5hmWrNBX1YMAoXxQAWXLMu9V5aC3Y2j7sKt+BhGF5VSQy9/8gCD8yCvSZL68SCUbgoBLBgi0trwdGvSnELLnP+irzg1a/Sbr28RobZ8RzQiwWjcFEEYMEmV9eCXbnIRaw7Ith6hOEA86jV1oEFlzs8PJ7R/1C4yD8oXGSCy3E75k1p1ay4fsmK2MOC1R0eHs/qfyhc5B4ULiopw2YXnA8s2HsPP8S24G39wSqKsW6s3BYWXO7w8Hhm/0PhIu+gcBGnWM+0FVAux3lykC/I0wHO8LQF5yN5+AQF0iuQPHwBLPhukodPUCC9AsnDF8CC7yZ5+AQF0iuQPHzBMxYMAABg4VYLBgAA8P+ABQMAwGPAggEA4DFgwQAA8BiwYAAAeAxYMAAAPAYsGAAAHgMWDAAAjwELBgCAx4AFAwDAY/wDnMX5I6sspewAAAAASUVORK5CYII="></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 '-none-' on each 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>In the 'Calculate
+subtotals for' box, make sure there is no check box checked on '1st
+Group','2nd Group' and '3rd Group' tab pages.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>There is no subtotal result displayed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/271_Data-Subtotals_Options_Include_format.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/271_Data-Subtotals_Options_Include_format.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/271_Data-Subtotals_Options_Include_format.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/271_Data-Subtotals_Options_Include_format.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,92 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_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></head>
+<body><p> </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. <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) Install Apache OpenOffice.</p>
+<p>2) Attached files</p>
+<p> - Subtotals_1_AOOTest-368 (use as a reference)</p>
+<p> - 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). In this
+instance, click on column C</p>
+<p> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Column C should now be highlighted</p>
+<p> </p></td></tr><tr><td width="5">3</td><td><p>Click 'Data -> Subtotals'.</p>
+<p> </p>
+<p><actions><!--[CDATA[</p--> </actions></p></td><td><p>The 'Subtotals' dialog appears. The current tab page is '1st Group'. </p>
+<p> </p>
+<p> </p></td></tr><tr><td width="5">4</td><td><p>In the 'Group by' combo box select "Data"</p>
+<p> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>"Data" should now be highlighted.</p>
+<p> </p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select "Data"</p>
+<p> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Should be able to select "Data"</p>
+<p> </p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function 'Count'.</p>
+<p> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Should be able to highlight "Count"</p>
+<p> </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> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>The subtotal result is displayed in hierarchy
+according to the 1st group option specified. Please refer
+"Summary" above, item #2 for expected output. 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> </p>
+<p> </p></td></tr><tr><td width="5">9</td><td><p>Press Ctrl_Z to Undo subtotal.</p>
+<p> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>Worksheet is returned to it's original state.</p>
+<p> </p>
+<p> </p></td></tr><tr><td width="5">10</td><td><p>Repeat step 2-6.</p>
+<p> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p> </p>
+<p> </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> </p>
+<p><actions><!--[CDATA[</p-->
+</actions></p></td><td><p>The subtotal result is displayed in hierarchy
+according to the 1st group option specified. Please refer
+"Summary" above, item #3 for expected output. Essentially, the
+data will be sorted according to the 'Group by'option specified.
+The cell format will be moved with its original value.</p>
+<p> </p>
+<p> </p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/272_Data-Subtotals_Options_Sort:Do_not_sort.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/272_Data-Subtotals_Options_Sort%3ADo_not_sort.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/272_Data-Subtotals_Options_Sort:Do_not_sort.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/272_Data-Subtotals_Options_Sort:Do_not_sort.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,65 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_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></head>
+<body><p> </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. <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"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/273_Data-Subtotals_Page_break_between_groups.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/273_Data-Subtotals_Page_break_between_groups.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/273_Data-Subtotals_Page_break_between_groups.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/273_Data-Subtotals_Page_break_between_groups.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,49 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_Page break between groups.</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style></head>
+<body><p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-370: Data-)Subtotals_Page break between groups. <span style="font-size: 80%;">[Version : 1]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:22:30</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p></p></td></tr><tr><td colspan="3"><span class="label">Preconditions:</span><br><p>Create a spreadsheet document.</p></td></tr><tr><td><span class="label">#:</span></td><td><span class="label">Step actions:</span></td><td><span class="label">Expected Results:</span></td></tr><tr><td width="5">1</td><td><p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Expected Results</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">2</td><td><p>Select the area in the sheet that you want to calculate subtotals for.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Click 'Data-) Subtotals'.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The 'Subtotals' dialog appears.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>In the 'Group By' box, select the column that you want to add the subtotals to.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>In the 'Calculate subtotals for' box, select the check boxes for the columns containing the values that you want to subtotal.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>In the 'Use function' box, select the function that you want to use to calculate the subtotals.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Click 'Option' tab page, and select 'Page break between groups' check box.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Click 'OK' button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The subtotal result is
+displayed in hierarchy according to the group options and a blue page
+break line is inserted after each group of subtotaled data. (However
+there is no page break between each last subtotaled data of current
+level and its upper level)</p>
+<p></p>
+<p></p></td></tr><tr><td width="20%" valign="top"><span class="label">Execution type:</span></td><td colspan="2">Manual</td></tr>
+<tr><td width="20%" valign="top"><span class="label">Importance:</span></td><td colspan="2">Medium</td></tr>
+<tr><td colspan="3"></td></tr><tr><td> Test Focus:</td><td colspan="2"></td></tr>
+<tr><td> Feature first available at which release:</td><td colspan="2"></td></tr>
+<tr><td> Automation script name:</td><td colspan="2"></td></tr>
+<tr><td> Testsuite set:</td><td colspan="2"></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Requirements</span></td><td colspan="2"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file
Added: openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/274_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html
URL: http://svn.apache.org/viewvc/openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/274_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html?rev=1828075&view=auto
==============================================================================
--- openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/274_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html (added)
+++ openoffice/ooo-site/trunk/content/qa/testcase/ManualTesting/274_Data-Subtotals_Recalculates_subtotals_when_source_data_changed.html Fri Mar 30 18:38:29 2018
@@ -0,0 +1,61 @@
+<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
+<html><head>
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: Data-)Subtotals_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></head>
+<body><p> </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. <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"> None<br></td></tr>
+<tr><td width="20%" valign="top"><span class="label">Keywords:</span></td><td colspan="2"> None<br></td></tr>
+</tbody></table>
+</div>
+</body></html>
\ No newline at end of file