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