Excel Client:Style sheet Editor: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
No edit summary |
No edit summary |
||
| (6 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
The Style Sheet Editor allows you to create style sheets. You can save your style sheets to reuse again later. | The [[Excel Client]] Style Sheet Editor allows you to create style sheets. You can save your style sheets to reuse again later. | ||
[[Image:EC Style Sheet Editor.jpg|thumb|center|Excel Client, Style Sheet Editor]] | [[Image:EC Style Sheet Editor.jpg|thumb|center|Excel Client, Style Sheet Editor]] | ||
| Line 7: | Line 7: | ||
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): | 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): | ||
{| | {| class="wikitable" width="100%" | ||
|- | |- | ||
|width={{{breite|25%}}}|Vertical axis | |width={{{breite|25%}}}|Vertical axis | ||
| Line 29: | Line 29: | ||
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 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. | ||
{| | {| class="wikitable" width="100%" | ||
|- | |- | ||
|[[image:EC FE Bereich General1.jpg]] | |[[image:EC FE Bereich General1.jpg]] | ||
| 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). | ||
|} | |} | ||
| Line 72: | Line 71: | ||
[[Image:EC FE ExStyleSheet2.jpg|thumb|center|Excel Client, “Sun set” Style Sheet ]] | [[Image:EC FE ExStyleSheet2.jpg|thumb|center|Excel Client, “Sun set” Style Sheet ]] | ||
To apply a newly created style sheet to your data definition, click the “Apply” button | 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”. | ||
| Line 78: | Line 77: | ||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client|Style sheet Editor]][[Category:Excel_Client_Dialogues|Style sheet Editor]] | [[Category:Excel_Client|Style sheet Editor]][[Category:Excel_Client_Dialogues|Style sheet Editor]] | ||
[[Category:Enterprise_Edition| | [[Category:Enterprise_Edition|Style sheet Editor]][[Category:Enterprise Edition Objects|Style sheet Editor]] | ||
[[de:Enterprise_Edition:Formatvorlageneditor]] | |||
Latest revision as of 09:38, 6 March 2012
The Excel Client 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”.
