# Testname: Numberformatter
Document Owner: Frank Stecher | Last document change: 09.10.2007 | Status of document: Standard
Valid for version: StarOffice8, StarOffice8 PP1, StarOffice8 PP2, StarOffice8 PP3, StarOffice8 PP4, StarOffice8 PP5, StarOffice8 PP6, StarOffice8 PP7, StarOffice8 PP8, StarOffice8 PP9, StarOffice8 PP10

### Test purpose:

test the general functionality of the Numberformatter

### Known issues:

### Preconditions of test:

If not otherwise mentioned, this test is used with English (USA) locales and the default settings for Tools-Options

### Test documents:

-

### Testcases:

Category | Status: Standard | -
File New Document of your choice Spreadsheet : Context menu, Format Cells... , Numbers Tab Text Document : Insert menu, Table... , Ok, Context Menu, Number format... Draw/Impress : No Number formatterNumberformatter Are there 11 chooseable sections in the Category List Box ? All User-defined Number Percent Currency Date Time Scientific Fraction Boolean Value Text Does the content of the Format List Box change if you select an other category ? Does the content of the Format List Box match to the category choosen, e.g. Currencys are shown if Currency is selected ? Set the category to All and choose a Language from the drop down List Box for Language. Does the Category switch to Number ? Is the first Format set to show up as Bendras if Lithuanian is choosen as language ? Select the entry -1,234 (or -1.234 depending on the locale used) does the checkbox Thousands separator get taged ? Changed the format code to #,##0 (or #.##0) ? Set the Language back to Default and choose the category Currency. Is the fourth entry selected ? Does the Decimal Places Spinfield change to 2 and are the check boxes Negative numbers red and Tousands separator tagged ? If not file an Issue. Change the Language field under Format to $ English (USA) if it is not set to this value yet. Compares the Format String match this one : [$$-409]#,##0.00;[RED]-[$$-409]#,##0.00 If not file an Issue. Change the Language Dropdown list box to show Dutch (Netherlands). Has the content of the format Listbox changed to show also Euro and Netherlands old fl currency values ? If not file an Issue. Reset the Language to Default and change the category to Date. Are the Options Decimal places and so on disabled ? If not file an Issue. Are there Date formats in the format section ? If not file an Issue. Change the Category to Time. Does the Format List box show time formats ? If not, file an Issue. Change the Category to Scientific. Are there two formats shown ? If not file an Issue. Change to the Category Fraction. Are there Fraction formats shown ? If not, file an Issue. Change to Boolean Value. Is there one entry showing in the format section saying TRUE ? If not, file an Issue. Change to Category Text. Is there an @-sign shown in the Format section ? If not file an Issue.
User defined Numberformats | Status: Standard | -
File New Document of your choice Spreadsheet : Context menu, Format Cells... , Numbers Tab Text Document : Insert menu, Table... , Ok, Context Menu, Number format... Draw/Impress : No Number formatter Change to Category User-defined Enter the following Format string into the Format code line : [~jewish]yyyy-mm-dd and click on the green confirmation hook. Did this Icon changed from grey to green as you began typing ? If not file an Issue. Changed the Category from User-defined to Date ? If not file an Issue. Changed the Format Preview from 05/18/03 to 5663-02-21 ? If not, file an Issue. Change back to User-defined and select the Format entered previously. Click on the little note button next to the format code line. Can you enter a comment now into a newly visible line under the format code line ? If not file an Issue. Can you close this line by hitting the note button again and is the comment kept ? If not file an Issue. is the third Icon in the Format Code line (the X) colored Red ? If not file an Issue. Click on the Red X-Icon. Did the Category change to Date and the Format to the default one for the given locale (the third one from top for Englisch (USA)) ? If not file an Issue. Change back to the User-defined category. Is the previously created Number format still available ? If so, file an Issue.
Buttons | Status: Standard | -
File New Document of your choice Spreadsheet : Enter a Zero (0) into A1 an select the cell then. Context menu, Format Cells... , Numbers Tab Text Document : Insert menu, Table... , Ok, Enter a Zero (0) into the first cell of the table and place the curso into this table cell again, Context Menu, Number format... Draw/Impress : No Number formatter Change to Category Date Click on Cancel. Does the Number formatter dialog get closed ? If not file an Issue. Open the Number formatter dialog again. Press the ESC key on the Keyboard. Does the dialog close ? If not file an Issue. Open the Number formatter dialog again. Change to Category Date. Click on Ok. Does the dialog close and shows the cell you have formatted the date 12/30/99 ? If not file an Issue. Open the Number formatter dialog again. Change to Category Time. Press the RETURN Key. Does the dialog close and shows the cell you have formatted the time 12:00:00 AM ? If not file an Issue. Open the Number formatter dialog again. Change to Category Percent. The Format area shows Percent formats. Click on the Reset Button. Does the Category changes back to Time ? If not file an Issue. Open the Number formatter dialog again. Change to Category Percent. The Format area shows Percent formats. Press the Keys ALT+R . Does the Category changes back to Time ? If not file an Issue. Click on the Help Button. Does the Help opens ? If not, file an Issue. Close the Help. Press the ALT+H key, does the Help gets opened ? If not file an Issue.