Excel Client:Style sheet Editor: Difference between revisions
From CoPlanner 10
Jump to navigationJump to search
Created page with 'The 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…' |
No edit summary |
||
| Line 9: | Line 9: | ||
{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}} | {| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}} | ||
|- | |- | ||
|width={{{breite|25%}}}| | |width={{{breite|25%}}}|Vertical axis | ||
[[Image:EC FE | [[Image:EC FE Vertical axis.jpg|thumb|center|Excel Client, Vertical axis]] | ||
|width={{{breite|25%}}}| | |width={{{breite|25%}}}|Horizontal axis | ||
[[Image:EC FE | [[Image:EC FE Horizontal axis.jpg|thumb|center|Excel Client, Horizontal axis]] | ||
|width={{{breite|25%}}}|Measure | |width={{{breite|25%}}}|Measure dimension | ||
[[Image:EC | [[Image:EC FE Measure dimension.jpg|thumb|center|Excel Client, Measure dimension]] | ||
|width={{{breite|25%}}}| | |width={{{breite|25%}}}|Data area | ||
[[Image:EC FE | [[Image:EC FE Data area.jpg|thumb|center|Excel Client, Data area ]] | ||
|- | |- | ||
| | |Filter area | ||
[[Image:EC FE | [[Image:EC FE Filter area.jpg|thumb|center|Excel Client, Filter area]] | ||
| | |Filter label | ||
[[Image:EC FE | [[Image:EC FE Filter label.jpg|thumb|center|Excel Client, Filter label]] | ||
| | |Header row bar (only visible if check box under “General” is checked) | ||
[[Image:EC FE | [[Image:EC FE Header row.jpg|thumb|center|Excel Client, Header row]] | ||
|} | |} | ||
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. | |||
{| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}} | {| style=cellspacing="1" cellpadding="5" border="1" width={{{breite|100%}}} | ||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich General1.jpg]] | ||
| | |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. | |||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich General2.jpg]] | ||
| | |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 [[image:Icon_Loeschen.jpg]]. | |||
To save changes to a style sheet, click the Save button [[image:Icon Speichern.jpg]]. | |||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich Color1.jpg]] | ||
| | |The “Colour” group allows you to change the foreground (text) colour and the background colour of the selected region | ||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich Color2.jpg]] | ||
| | |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. | ||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich Border.jpg]] | ||
| | |The “Border” group allows you to define a line colour and a line mode (thickness) for your border. | ||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich Font.jpg]] | ||
| | |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. | ||
|- | |- | ||
|[[image:EC FE Bereich | |[[image:EC FE Bereich general3.jpg]] | ||
| | |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. | |||
'''Row and column header:''' Select this option if you want to display row and column headers. | |||
'''Display header row bar:''' Select this option if you want to display a decorative bar (header bar). | |||
|} | |} | ||
The following are a few examples of predefined style sheets: | |||
[[Image:EC FE | [[Image:EC FE ExStyleSheet1.jpg|thumb|center|Excel Client, “Smaragd” Style Sheet ]] | ||
[[Image:EC FE | [[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 [[image:EC_Icon_Anwenden.jpg]]. If you do not wish to apply the style sheet, click “Cancel” [[image:EC_Icon_Abbrechen.jpg]]. | |||
__NOEDITSECTION__ | __NOEDITSECTION__ | ||
[[Category:Excel_Client| | [[Category:Excel_Client|Style sheet Editor]][[Category:Excel_Client_Dialogues|Style sheet Editor]] | ||
[[Category:Enterprise_Edition|Formatvorlageneditor]][[Category:Enterprise Edition Objekte|Formatvorlageneditor]] | [[Category:Enterprise_Edition|Formatvorlageneditor]][[Category:Enterprise Edition Objekte|Formatvorlageneditor]] | ||
Revision as of 14:59, 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. Row and column header: Select this option if you want to display row and column headers. Display header row bar: Select this option if you want to display a decorative bar (header bar). |
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 File:EC Icon Anwenden.jpg. If you do not wish to apply the style sheet, click “Cancel” File:EC Icon Abbrechen.jpg.
