Language:

The Free and Open Productivity Suite
Apache OpenOffice 4.1.7 released

 

Test Case AOOTest-289: (Extend) Text * Cell Properties_Numbers_Text_Enter numbers first [Version : 1]
Author:undefined - 24/10/2012 14:21:16
Summary:

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.

Preconditions:

#:Step actions:Expected Results:
1

Expected results

2

New a spreadsheet.

New spreadsheet is created.

3

Input numbers into a cell range, say enter 1, 2, 3 into cell A1, A2, A3 respectively.

4

Input a formula into another cell, refers to cells mentioned in step 2, say input =sum(A1:A3) into A4.

5

Select one cell mentioned in step 2.

6

Enter 'Format Cells' dialog and active Numbers tab.

Category should be General as default.

7

Change category to Text.

Category is changed.

8

Click OK button.

Number in the selected cell remains number, it won't be converted to text. And the formula result should not update.

9

Enter a number into the selected cell again, and press Enter.

The entered number is formatted as text, it should be left-justified, and the formula result should update properly.

10

Select the cell again, and change the category back to General via 'Format Cells' dialog.

Content in the selected cell remains text, it won't be converted to number. And the formula result should not update.

11

Repeat step 8.

Content in the selected cell is formatted as number, and the formula result should update properly.

12

Undo several times, then redo several times.

Undo and redo should perform properly.

13

Save and close file.

14

Open the file.

File should be saved properly.

Execution type:Manual
Importance:Medium
Test Focus:
Feature first available at which release:
Automation script name:
Testsuite set:
Requirements None
Keywords: None

Apache Events

Apache Software Foundation

Copyright & License | Privacy | Contact Us | Donate | Thanks

Apache and the Apache feather logo are trademarks of The Apache Software Foundation. OpenOffice, OpenOffice.org and the seagull logo are registered trademarks of The Apache Software Foundation. Other names appearing on the site may be trademarks of their respective owners.