SAP cell styles
SAP standard styles are available after installation of the Add-In. You can modify them in the Styles group on the Home tab in Microsoft Excel. They affect the formatting as described in the following table:
| Style Name | Description |
|---|---|
| SAPDimensionCell | Format for dimension header cells. |
| SAPMemberCell | Format for member cells (non-hierarchical dimensions). |
| SAPHierarchyCell | Format for hierarchical member cells (even levels 0, 2, ...). |
| SAPHierarchyOddCell | Format for hierarchical member cells (odd levels 1, 3, ...) . |
| SAPMemberTotalCell | Format for member total cells. |
| SAPDataCell | Format for data cells. |
| SAPDataTotalCell | Format for data total cells. |
| SAPExceptionLevel1-9 | Format for highlighted cells due to conditional formats (rule priorities 1-9). |
| SAPEmphasized | Format for highlighted data cells (as per query definition). |
| SAPEmphasizedTotal | Format for highlighted total cells (as per query definition). |
| SAPBorder | Format for borders around a crosstab and between
header/member and data cells (format for left border is taken).
After changing this style, for example the color, you have to execute Refresh All in the Analysis ribbon to apply the changes. |
| SAPEditableDataCell | Format for input-ready data cells in planning change mode. |
| SAPEditableDataTotalCell | Format for input-ready total cells in planning change mode. |
| SAPReadonlyDataCell | Format for read-only data cells in planning change mode. |
| SAPReadonlyDataTotalCell | Format for read-only total cells in planning change mode. |
| SAPLockedDataCell | Format for locked data cells in planning change mode. |
| SAPLockedDataTotalCell | Format for locked total cells in planning change mode. |
The following SAP custom styles are not availabe after the installation of the Add-In, but you can create them in the Styles group on the Home tab of Microsoft Excel. They affect the formatting as described in the following table:
| Style Name | Description |
|---|---|
| SAPMemberCellX | Format for member cells on columns (overriding SAPMemberCell). |
| SAPMemberTotalCellX | Format for member total cells on columns (overriding SAPMemberTotalCell). |
| SAPHierarchyCellX | Format for hierarchical member cells on columns, even levels (overriding SAPHierarchyCell). |
| SAPHierarchyOddCellX | Format for hierarchical member cells on columns, odd level (overriding SAPHierarchyOddCell). |
| SAPHierarchyCell0-9 | Format for hierarchical member cells on specific level (overriding SAPHierarchyCell and SAPHierarchyOddCell). |
| SAPHierarchyCell0-9X | Format for hierarchical member cells on specific level on columns (overriding SAPHierarchyCellX and SAPHierarchyOddCellX). |
Example:
The column headings are defined as SAPMemberCell. If you want a different format for these cells than for member cells in rows, you can duplicate the SAPMemberCell, name it SAPMemberCellX and change the format definition. If you save this as style set, the member cells in column headings are displayed in the new defined format. The member cells in rows continue to be displayed as defined in the SAPMemberCell style.
Example:
The standard styles for hierarchies are SAPHierarchyCell and SAPHierarchyCellOdd. With these styles, the hierarchy levels have alternating styles. If you want to have three different styles for the first three hierarchy levels of an hierarchy, create the styles SAPHierarchyCell0, SAPHierarchyCell1 and SAPHierarchyCell2. The system ignores the standard styles and applies the styles for specific styles. If an hierarchy have more than three levels, the levels after level 2 are displayed with the SAPHierarchyCell2 style.