|
|
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
|