Editing Styles 

Use

You edit styles of a planning layout, or create additional styles, in order to achieve an individual structure that is different from the central style for a particular layout.

You include an additional column in a planning layout in which further calculations of the plan data presented in the data column are executed with the help of Microsoft Excel formulas. You want it to be identifiable in the layout that the values have a particular status in this additional column and are not saved in the data basis. To do this, you define an additional style in which you define a different background color for the additional column.

Note that when editing styles, you are only allowed to change the format-specific properties of a template, but not the names of a delivered template. BW-BPS is dependent on the delivered styles being available with the names determined by SAP for the correct processing of planning layouts.

The possibilities offered by Microsoft Excel for the presentation of decimal places and units are overwritten in planning layouts by the corresponding settings in BW-BPS. For more information see Configuring Data Columns.

Procedure

In order to use styles for cell formatting, proceed as follows:

...

       1.      Choose Change Layout in the context menu of a planning layout.

       2.      Choose  Continue until you reach the third step of the layout definition. The worksheet is displayed with the design of the layout

       3.      In the layout, select a cell area whose formatting you want to change

       4.      Choose Format ®Style. A dialog box appears in which the valid styles are displayed for the selected cell range with the current settings.

       5.      Choose Change to edit the style settings. A dialog box appears in which you have access to all formatting settings.

       6.      After you have made the changes, choose OK. You return to the first dialog box.

       7.      You can determine whether you want to create the changed style under a new name as an additional format to the ones which already exist, or whether you want to overwrite the underlying format with the changes. What you decide upon here will affect the layout in different ways:

·         Creating style under a new name: The new style is assigned to the cell area that was selected in the third step. All remaining areas of the layout remain unchanged.

·         Overwriting the underlying format with the changes: All cells of the layout which are assigned to the style adopt the changes you made.

Because of an error in Microsoft Excel 2000, you should avoid creating styles whose names contain other characters than letters or figures. In particular, the underscore “_” leads to problems in style names when saving the template.

       8.      Choose Ok again. The system adopts the changes.

Result

The changes are visible in the layout design and have an effect when calling up the layout to display and enter data.

 

See also:

Formatting Generated Layout in the Preview