| <!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: (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></head> |
| <body><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> |
| </body></html> |