You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@openoffice.apache.org by bu...@apache.org on 2018/04/02 23:06:14 UTC
svn commit: r1027767 [2/2] - in /websites/staging/ooo-site/trunk: cgi-bin/
content/ content/qa/testcase/ManualTesting/
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/343_Extend_Text_Cell_Properties_Numbers_Format_code_Color.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/343_Extend_Text_Cell_Properties_Numbers_Format_code_Color.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/343_Extend_Text_Cell_Properties_Numbers_Format_code_Color.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,143 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Format code_Color</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-283: (Extend) Text * Cell Properties_Numbers_Format code_Color <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ format code. Number Format Codes
+Number format codes can consist of up to three sections separated by a
+semicolon. 1. In a number format code with two sections, the first
+section applies to positive values and zero, and the second section
+applies to negative values. 2. In a number format code with three
+sections, the first, the second, and the third section applies to
+positive values, negative values, and the value zero respectively. 3.
+User can also assign conditions to the three sections, so that the
+format is only applied if a condition is met. Color
+To set the color of a section of a number format code, insert one of the
+ following color names in square brackets (()): CYAN, BLACK, MAGENTA,
+WHITE, GREEN, BLUE, RED, YELLOW
+Format Code Entered Content Number Format
+#.00;(RED)-#.00;(BLUE)0.00 0.325
+ -1.622
+ 0 .33
+ -1.62
+ 0.00 1. Use zero (0) or the number sign (#) as placeholders in number
+format code to represent numbers. 2. Use question mark (?) to represent
+the number of digits to include in the numerator and the denominator of a
+ fraction. 3. If a number contains more digits to the right of the
+decimal delimiter than there are placeholders in the format, the number
+is rounded off accordingly. If a number contains more digits to the left
+ of the decimal delimiter than there are placeholders in the format,
+then entire number is displayed. 4. Guide for using placeholders when
+creating a number format code. Guide
+Placeholders Purpose Brief
+# Represents numbers. Only displays significant digits, does not display
+ extra zeros. 0 Represents numbers. Fills the rest digits of number with
+ zeros if fewer digits in the number than in the number format. ?
+Represents the number of digits to include in the numerator and the
+denominator of a fraction. Fractions that do not fit the pattern that
+user defined are displayed as floating point numbers. Examples
+Format Code Number Format
+####.#;-000.0 3456.78 as 3456.8 and 20.02 as 20
+ -1 as -001.0 and -12345.234 as -12345.2
+#.000 9.9 as 9.900 and 10.2345 as 10.235
+#.0# 3 as 3.0 and 1234.567 as 1234.57
+# ???/??? 5.75 as 5 3/4 and 6.3 as 6 3/10
+#.##;(0.##);0.0 0.5 as .5 and 10.2 as 10.2
+ -.5 as (0.5) and -3 as (3.)
+ 0 as 0.0</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Enter a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General as default, and Format code field is disabled.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed, default format in format list is selected, and related format code displays in Format code field.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Enter your format code (including specific colors), into Format code field.</p>
+<p>** Please refer to description for details.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Customized format code is entered, and preview in preview field should update properly.</p>
+<p>1. If the customized one is not duplicated with any pre-defined one, then Add button and Edit Comment button will be enabled.</p>
+<p>2. If the customized one is duplicated with any pre-defined one, then related pre-defined format is selected.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Make sure the customized format code is not duplicated with any pre-defined one, and click Add button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New format is added into format list of related category.</p>
+<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>New format should be properly applied.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Repeat steps 2 to 7 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Enter a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Apply a customized format via dialog.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific format should be properly applied.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Repeat steps 9 and 10 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly. Customized format codes should not be removed when perform undo.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">15</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/344_Extend_Text_Cell_Properties_Numbers_Format_code_Decimal_places.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/344_Extend_Text_Cell_Properties_Numbers_Format_code_Decimal_places.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/344_Extend_Text_Cell_Properties_Numbers_Format_code_Decimal_places.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,136 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Format code_Decimal places</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-284: (Extend) Text * Cell Properties_Numbers_Format code_Decimal places <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ format code. Number Format Codes
+Number format codes can consist of up to three sections separated by a
+semicolon. 1. In a number format code with two sections, the first
+section applies to positive values and zero, and the second section
+applies to negative values. 2. In a number format code with three
+sections, the first, the second, and the third section applies to
+positive values, negative values, and the value zero respectively. 3.
+User can also assign conditions to the three sections, so that the
+format is only applied if a condition is met. Decimal Places and
+Significant Digits
+1. Use zero (0) or the number sign (#) as placeholders in number format
+code to represent numbers. 2. Use question mark (?) to represent the
+number of digits to include in the numerator and the denominator of a
+fraction. 3. If a number contains more digits to the right of the
+decimal delimiter than there are placeholders in the format, the number
+is rounded off accordingly. If a number contains more digits to the left
+ of the decimal delimiter than there are placeholders in the format,
+then entire number is displayed. 4. Guide for using placeholders when
+creating a number format code. Guide
+Placeholders Purpose Brief
+# Represents numbers. Only displays significant digits, does not display
+ extra zeros. 0 Represents numbers. Fills the rest digits of number with
+ zeros if fewer digits in the number than in the number format. ?
+Represents the number of digits to include in the numerator and the
+denominator of a fraction. Fractions that do not fit the pattern that
+user defined are displayed as floating point numbers. Examples
+Format Code Number Format
+####.#;-000.0 3456.78 as 3456.8 and 20.02 as 20
+ -1 as -001.0 and -12345.234 as -12345.2
+#.000 9.9 as 9.900 and 10.2345 as 10.235
+#.0# 3 as 3.0 and 1234.567 as 1234.57
+# ???/??? 5.75 as 5 3/4 and 6.3 as 6 3/10
+#.##;(0.##);0.0 0.5 as .5 and 10.2 as 10.2
+ -.5 as (0.5) and -3 as (3.)
+ 0 as 0.0</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Enter a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General as default, and Format code field is disabled.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed, default format in format list is selected, and related format code displays in Format code field.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Enter your format code (using #/0/?) into Format code field.</p>
+<p>** Please refer to description for details.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Customized format code is entered, and preview in preview field should update properly.</p>
+<p>1. If the customized one is not duplicated with any pre-defined one, then Add button and Edit Comment button will be enabled.</p>
+<p>2. If the customized one is duplicated with any pre-defined one, then related pre-defined format is selected.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Make sure the customized format code is not duplicated with any pre-defined one, and click Add button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New format is added into format list of related category.</p>
+<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>New format should be properly applied.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Repeat steps 2 to 7 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Enter a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Apply a customized format via dialog.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific format should be properly applied.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Repeat steps 9 and 10 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly. Customized format codes should not be removed when perform undo.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">15</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/345_Extend_Text_Cell_Properties_Numbers_Format_code_Use_native_characters.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/345_Extend_Text_Cell_Properties_Numbers_Format_code_Use_native_characters.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/345_Extend_Text_Cell_Properties_Numbers_Format_code_Use_native_characters.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,147 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Format code_Use native characters_****</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-285: (Extend) Text * Cell Properties_Numbers_Format code_Use native characters_**** <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ format code. Number Format Codes
+Number format codes can consist of up to three sections separated by a
+semicolon. 1. In a number format code with two sections, the first
+section applies to positive values and zero, and the second section
+applies to negative values. 2. In a number format code with three
+sections, the first, the second, and the third section applies to
+positive values, negative values, and the value zero respectively. 3.
+User can also assign conditions to the three sections, so that the
+format is only applied if a condition is met. Displays Numbers Using
+Native Characters
+To display numbers using native number characters, use a (NatNum1),
+(NatNum2), ..., (NatNum11) modifier at the beginning of a number format
+codes. The (NatNum1) modifier always uses a one to one character mapping
+ to convert numbers to a string that matches the native number format
+code of the corresponding locale. The other modifiers produce different
+results if they are used with different locales. A locale can be the
+language and the territory for which the format code is defined, or a
+modifier such as ($-yyy) that follows the native number modifier. In
+this case, yyy is the hexadecimal MS-LCID that is also used in currency
+format codes. For example, to display a number using Japanese short
+Kanji characters in an English US locale, use this format code:
+(NatNum1)($-411)0.00. 1. Use zero (0) or the number sign (#) as
+placeholders in number format code to represent numbers. 2. Use question
+ mark (?) to represent the number of digits to include in the numerator
+and the denominator of a fraction. 3. If a number contains more digits
+to the right of the decimal delimiter than there are placeholders in the
+ format, the number is rounded off accordingly. If a number contains
+more digits to the left of the decimal delimiter than there are
+placeholders in the format, then entire number is displayed. 4. Guide
+for using placeholders when creating a number format code. Guide
+Placeholders Purpose Brief
+# Represents numbers. Only displays significant digits, does not display
+ extra zeros. 0 Represents numbers. Fills the rest digits of number with
+ zeros if fewer digits in the number than in the number format. ?
+Represents the number of digits to include in the numerator and the
+denominator of a fraction. Fractions that do not fit the pattern that
+user defined are displayed as floating point numbers. Examples
+Format Code Number Format
+####.#;-000.0 3456.78 as 3456.8 and 20.02 as 20
+ -1 as -001.0 and -12345.234 as -12345.2
+#.000 9.9 as 9.900 and 10.2345 as 10.235
+#.0# 3 as 3.0 and 1234.567 as 1234.57
+# ???/??? 5.75 as 5 3/4 and 6.3 as 6 3/10
+#.##;(0.##);0.0 0.5 as .5 and 10.2 as 10.2
+ -.5 as (0.5) and -3 as (3.)
+ 0 as 0.0</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Enter a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General as default, and Format code field is disabled.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed, default format in format list is selected, and related format code displays in Format code field.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Enter your format code (display number using native characters), into Format code field.</p>
+<p>** Please refer to description for details.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Customized format code is entered, and preview in preview field should update properly.</p>
+<p>1. If the customized one is not duplicated with any pre-defined one, then Add button and Edit Comment button will be enabled.</p>
+<p>2. If the customized one is duplicated with any pre-defined one, then related pre-defined format is selected.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Make sure the customized format code is not duplicated with any pre-defined one, and click Add button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New format is added into format list of related category.</p>
+<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>New format should be properly applied.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Repeat steps 2 to 7 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Enter a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Apply a customized format via dialog.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific format should be properly applied.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Repeat steps 9 and 10 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly. Customized format codes should not be removed when perform undo.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">15</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/346_Extend_Text_Cell_Properties_Numbers_Language.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/346_Extend_Text_Cell_Properties_Numbers_Language.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/346_Extend_Text_Cell_Properties_Numbers_Language.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,97 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Language</title>
+<link type="text/css" rel="stylesheet" href="tl_documents.css">
+<style type="text/css" media="print">.notprintable { display:none;}</style>
+<style></style>
+<!--#include virtual="/scripts/google-analytics.js" -->
+<!--#include virtual="/scripts/entourage.js" -->
+</head>
+<body>
+<!--#include virtual="/brand.html" -->
+ <div id="topbara">
+ <!--#include virtual="/topnav.html" -->
+ <div id="breadcrumbsa"><a href="/">home</a> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-286: (Extend) Text * Cell Properties_Numbers_Language <span style="font-size: 80%;">[Version : 1]</span></th></tr>
+<tr><td width="20%" valign="top"><span class="label">Author:</span></td><td colspan="2">undefined - 24/10/2012 14:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ language. 1. Default category is General. 2. All other controls in the
+dialog are grayed out when category is General.</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Input a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General by default.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Language list is enabled, and default format is selected.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Select an option from Language list.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Language is changed, available formats in format list should update, and default format is selected.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Select an option from format list.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific format is select, and preview in preview field should update properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Repeat steps 5 and 6 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Repeat steps 4 to 7 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Click OK button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific format should be applied properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Repeat steps 2 to 9 several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/347_Extend_Text_Cell_Properties_Numbers_Negative_numbers_red.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/347_Extend_Text_Cell_Properties_Numbers_Negative_numbers_red.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/347_Extend_Text_Cell_Properties_Numbers_Negative_numbers_red.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,95 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Negative numbers red</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-287: (Extend) Text * Cell Properties_Numbers_Negative numbers red <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ negative numbers red. 1. Negative numbers red is enable when category
+is one of Number, Percent, and Currency. 2. Negative numbers red is
+checked by default when category is Currency. 3. Negative numbers will
+display in red if Negative numbers red is checked on.</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Input numbers (including positive, negative, whole number, decimal, etc.) into some cells, then select the cells.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog, and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General by default, and Negative numbers red check box should be disabled.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Negative numbers red check box is enabled only when category is Number, Percent or Currency.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Change category to Number, Percent or Currency.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed, default format in format list is selected, and Negative numbers red check box is enabled.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Check on Negative numbers red check box.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Check box is checked, and preview in preview field should update properly.</p>
+<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>Specified number format should be applied properly, negative should display in red.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Select some of the cells, and check off Negative numbers red check box in dialog.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Selected negative should display in default color.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Repeat steps 2 to 8 several times, try different categories (Number/Percent/Currency).</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/348_Extend_Text_Cell_Properties_Numbers_Percent.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/348_Extend_Text_Cell_Properties_Numbers_Percent.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/348_Extend_Text_Cell_Properties_Numbers_Percent.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,96 @@
+<!--#include virtual="/doctype.html" -->
+<html>
+<head>
+<link href="/css/ooo.css" rel="stylesheet" type="text/css">
+
+<meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Print Test Case: (Extend) Text * Cell Properties_Numbers_Percent</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-288: (Extend) Text * Cell Properties_Numbers_Percent <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ percent. 1. Default category is General. 2. All other controls in the
+dialog are grayed out when category is General.</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Input a decimal into one cell, then select the cell.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General as default.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category to Percent.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed, default percent format is selected, and preview in preview field should update properly.</p>
+<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>Default percent format should be applied properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Repeat steps 3 to 5 several times, select some other options in Format list.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific percent format should be applied properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">8</td><td><p>Input a decimal into another cell, then repeat steps 3 to 5.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Select the two cells mentioned in steps 2 and 7.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General, once percent formats of two cells are different.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Change category to Percent, and specify a format, then click OK button.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Specific percent format should be applied to selected cells.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/349_Extend_Text_Cell_Properties_Numbers_Text_Enter_numbers_first.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/349_Extend_Text_Cell_Properties_Numbers_Text_Enter_numbers_first.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/349_Extend_Text_Cell_Properties_Numbers_Text_Enter_numbers_first.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,101 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Text_Enter numbers first</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-289: (Extend) Text * Cell Properties_Numbers_Text_Enter numbers first <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ text. 1. When numbers are formatted as text, they cannot be used in
+calculations or formulas. 2. If you have already entered numbers in
+cells and, afterwards, changed the format of the cells to Text, the
+numbers remain numbers and won't be converted. Only numbers entered
+after you specify that they are text, or numbers which are edited,
+become text. 3. Any numbers subsequently entered into the formatted
+range are interpreted as text. The display of these 'numbers' is
+left-justified, just as with other texts.</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Input numbers into a cell range, say enter 1, 2, 3 into cell A1, A2, A3 respectively.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Input a formula into another cell, refers to cells mentioned in step 2, say input =sum(A1:A3) into A4.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Select one cell mentioned in step 2.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Enter 'Format Cells' dialog and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General as default.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Change category to Text.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed.</p>
+<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>Number in the selected cell remains number, it won't be converted to text. And the formula result should not update.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Enter a number into the selected cell again, and press Enter.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>The entered number is formatted as text, it should be left-justified, and the formula result should update properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Select the cell again, and change the category back to General via 'Format Cells' dialog.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Content in the selected cell remains text, it won't be converted to number. And the formula result should not update.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Repeat step 8.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Content in the selected cell is formatted as number, and the formula result should update properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">14</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>
Added: websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/350_Extend_Text_Cell_Properties_Numbers_Thousands_separator.html
==============================================================================
--- websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/350_Extend_Text_Cell_Properties_Numbers_Thousands_separator.html (added)
+++ websites/staging/ooo-site/trunk/content/qa/testcase/ManualTesting/350_Extend_Text_Cell_Properties_Numbers_Thousands_separator.html Mon Apr 2 23:06:14 2018
@@ -0,0 +1,99 @@
+<!--#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: (Extend) Text * Cell Properties_Numbers_Thousands separator</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> » <a href="/qa/">qa</a> » <a href="/qa/testcase/">testcase</a> » <a href="/qa/testcase/ManualTesting/">ManualTesting</a></div>
+ </div>
+ <div id="clear"></div>
+
+
+ <div id="content">
+
+
+ <p> </p><div> <table class="tc" style="margin-left: 0;" width="90%"><tbody><tr><th colspan="3">Test Case AOOTest-290: (Extend) Text * Cell Properties_Numbers_Thousands separator <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:21:16</td></tr>
+<tr><td colspan="3"><span class="label">Summary:</span><br><p>To verify
+that text * cell properties can be applied/modified properly - numbers -
+ thousands separator. 1. Thousands separator is enable when category is
+one of Number, Percent, and Currency. 2. Thousands separator is checked
+by default when category is Currency. 3. A separator will be inserted
+between thousands if Thousands separator is checked, and the type of
+separator depends on the language settings.</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 spreadsheet.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>New spreadsheet is created.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">3</td><td><p>Input numbers into some cells, then select the cells.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">4</td><td><p>Enter 'Format Cells' dialog, and active Numbers tab.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category should be General by default, and Thousands separator check box should be disabled.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">5</td><td><p>Change category several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Thousands separator check box is enabled only when category is Number, Percent or Currency.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">6</td><td><p>Change category to Number, Percent or Currency.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Category is changed,
+default format in format list is selected, and Thousands separator check
+ box is enabled. and Thousands separator check box is enabled or not, it
+ depends on which format is the default.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">7</td><td><p>Check on Thousands separator check box.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Check box is checked, preview in preview field should update properly.</p>
+<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>Specified number format should be applied properly, proper separator is inserted between thousands.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">9</td><td><p>Select some of the cells, and check off Thousands separator check box in dialog.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Separators should not be removed.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">10</td><td><p>Repeat steps 2 to 8 several times, try different categories (Number/Percent/Currency).</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Ditto.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">11</td><td><p>Undo several times, then redo several times.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>Undo and redo should perform properly.</p>
+<p></p>
+<p></p></td></tr><tr><td width="5">12</td><td><p>Save and close file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p></p>
+<p></p></td></tr><tr><td width="5">13</td><td><p>Open the file.</p>
+<p></p>
+ <actions><!--[CDATA[</p--></actions></td><td><p>File should be saved properly.</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>
+
+ </div>
+<!--#include virtual="/footer.html" -->
+</body>
+</html>