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.