|
|
Number formatter in chart labels |
Status: Standard |
- |
|
- File / New / Spreadsheet
- Create cell range A2:E5 with random values
- Insert Chart (Type of your choose) using Toolbar
- Insert / Data Labels ...
- Check Show Value as number
- Press Number format...
- From this point use the Numberformatter testcase (see References)
|
|
|
Combination of value and percentage display as data point label |
Status: Standard |
- |
|
- File / New / Spreadsheet
- Create cell range B2:E5 with random values
- Toolbar Formatting press Button Number format: currency
- Insert Pie Subtype Exploded Pie Chart Chart using Toolbar
- Insert / Data Labels ...
- Check Show Value as number
- Check Show number as percentage
- Leave the Dialog by using ok
- Check if the combination of value and percentage are used for each Datapoint.
- File / Save as...{Name of your choice}
- use OpenDocument Spreadsheet (.ods) as target file format
- File / Reload the saved file
- Check, if all settings are unmodified
|
|
|
Space, Comma, Semicolon and New Line (simple) |
Status: Standard |
- |
|
1. File / New / Spreadsheet
2. Create cell range A1:C3 with random values
3. Insert Column normal Chart using Toolbar
4. Insert / Data Labels ...
5. Check the Show Value as number
6. Check if the Separator Listbox are not available
6. Uncheck the Show Value as number
7. Check the Show Value as percentage
8. Check if the Separator Listbox are not available
9. Check additional the Show Value as number
10. Check if the Separator Listbox are available
11. Uncheck the Show Value as percentage
12. Check if the Separator Listbox are not available
13. Check the Show category
14. Check if the Separator Listbox are available
15. Check if the entrys Space, Comma, Semicolon and New Line are visible/available
16. Leave the Dialog by using ok.
|
|
|
Space, Comma, Semicolon and New Line (complex) |
Status: Standard |
- |
|
- File / New / Spreadsheet
- Create cell range A1:C3 with random values
- Insert Column normal Chart using Toolbar
- Insert / Data Labels ...
- Check Show Value as number
- Check Show number as percentage
- Choose in the Separator Listbox the entry Space
- Check, if the Space as Separator is set for all DataPoints
- Insert / Data Labels ...
- Check Show Category
- Choose in the Separator Listbox the entry Semicolon
- Check, if the Semicolon as Separator is set for all DataPoints between the Value as number, number as percentage and the category
- Insert / Data Labels ...
- Check Show Legend Key
- Choose in the Separator Listbox the entry New Line
- Check, if a New Line as Separator is set for all DataPoints between the Value as number, number as percentage and the category incl. the Legend Key
- File / Save as...{Name of your choice}
- use OpenDocument Spreadsheet (.ods) as target file format
- File / Reload the saved file
- Check, if all settings are unmodified
|
|
|
Placement of Data Labels |
Status: Preliminary |
- |
|
- File / New / Spreadsheet
- Create cell range A1:C3 with random values
- Insert Column normal Chart using Toolbar
- Insert / Data Labels...
- Check Show category
- Check if the list entrys for placement are: above, below, center, outside, inside and near origin
- Choose center
- Check if center will be set
- choose near origin
- Check if near origin will be set
- Leave the Dialog by using ok
- Format / Charttype...
- Switch over to Charttype XY (Scatter)
- Insert / Data Labels...
- Check Show category
- Check if the list entrys for placement are: above, below, left, right and center
- choose below
- Check if below will be set
- Leave the Dialog by using ok
- Format / Charttype...
- Switch over to Charttype Pie
- Insert / Data Labels...
- Check Show category
- Check if the list entrys for placement are: Best Fit, outside, inside and center
- Choose the Option Best Fit
- Check if Best Fit will be set
- Leave the Dialog by using ok
- File / Save as... {Name of your choice}
- Use OpenDocument Spreadsheet (.ods) as target file format
- File / Reload the saved file
- Check if the settings for placement are Best Fit
|
|
|
Automatic positions for labels on pie segments |
Status: Standard |
- |
|
- File / Open
- Enter the name of the test document (PieBestFit_TestDocument) in the File Name field.
- Open the document by using the Button Open
- Check for the charts in the first row if:
- the two labels on top of the pie do not overlap
- each of the two is moved besides a bit
- each is connected with a line to its according piece
- Check for the charts in the second row if:
- the three labels on top of the pie do not overlap
- The central label is not moved
- The both moved outer labels are connected with a line to the according pieces
- Check for the charts in the third row if:
- the four labels on top of the pie do not overlap
- each of the two central labels is moved besides a bit
- All four moved labels are connected with a line to their according piece
- The color of the line is identical to the label color
- Check for the charts in the fourth row if:
- the five labels on the right side do not overlap
- The central label (0.7%) has not moved compared to outside position
- Check for the charts in the fifth row if:
- K is not overlapping with J
- B is not overlapping with C
- E, F and G are not overlapping
- Leave the test document without saving
|