Excel Client:Style sheet Editor: Difference between revisions
No edit summary |
No edit summary |
||
| Line 60: | Line 60: | ||
|The “General” group does not affect the formatting of a specific region. Rather, it applies to the style sheet in general. | |The “General” group does not affect the formatting of a specific region. Rather, it applies to the style sheet in general. | ||
'''Gridlines:''' Select this option if you want to display gridlines. | '''Gridlines:''' Select this option if you want to display gridlines.<br> | ||
'''Row and column header:''' Select this option if you want to display row and column headers. | '''Row and column header:''' Select this option if you want to display row and column headers.<br> | ||
'''Display header row bar:''' Select this option if you want to display a decorative bar (header bar). | '''Display header row bar:''' Select this option if you want to display a decorative bar (header bar). | ||
|} | |} | ||
Revision as of 15:08, 6 May 2010
The Style Sheet Editor allows you to create style sheets. You can save your style sheets to reuse again later.
A data definition is divided into sections that can be formatted independently of one another.
The data is divided into the following elements (the selected area is shown with a border and can be seen in the “Region” dropdown list):
| Vertical axis
|
Horizontal axis
|
Measure dimension
|
Data area
|
| Filter area
|
Filter label
|
Header row bar (only visible if check box under “General” is checked)
|
The options that are available for use in the options pane on the left side of the window will vary depending on the types of formatting that are possible in your selection.
|
The “General” group shows the name of the style sheet and also contains the Save, Save as, and Delete buttons. The second dropdown list shows the name of the selected region
Note: It is not necessary to save changes to a style sheet in order to apply the changes to a data definition. |
|
To create a new style sheet, click the Save As button. Name your style sheet and click “OK” to confirm the name. To cancel the operation, press the Escape key.
To delete a style sheet, select the style sheet and click the Delete button To save changes to a style sheet, click the Save button |
|
The “Colour” group allows you to change the foreground (text) colour and the background colour of the selected region |
|
The colour dialogue for defining the background colour also contains three colour gradients that can be applied to axis dimensions. The background colour will be applied depending on the level of each element: Level 0 will have the darkest shade, etc. |
|
The “Border” group allows you to define a line colour and a line mode (thickness) for your border. |
|
The “Font” group allows you to customise the font, size, and alignment of your text. You also have the option to set your font style to bold, italic, or underlined. |
|
The “General” group does not affect the formatting of a specific region. Rather, it applies to the style sheet in general.
Gridlines: Select this option if you want to display gridlines. |
The following are a few examples of predefined style sheets:
To apply a newly created style sheet to your data definition, click the “Apply” button. If you do not wish to apply the style sheet, click “Cancel”.
