The Appearance tab manages settings relating to the look and feel of Vizlib Pivot Table.
TABLE OF CONTENTS
- General
- Alternate States
- Columns / Rows Definition
- Header Cells
- Rows (Left) Cells
- Columns (Right) Cells
- Totals
General
In the General tab (Figure 1), you can choose to show or hide a title, add title details using the expression editors and show or hide the pivot table details.
Figure 1: General
Alternate States
Alternate States has settings related to adding the object to master visualizations (Figure 2). You can find more about alternate states here.
Figure 2: Alternate States
Columns / Rows Definition
Columns / Rows Definition contains several sections which handle the appearance settings for pivot table columns and rows. The Visibility settings (Figure 3) allow you to display or hide measure titles in the pivot table definition panel, showing the components used to construct the pivot table.
Figure 3: Visibility
Definition Styling (Figure 4) controls the background and font color for the definition panel.
Figure 4: Definition Styling
Enabling Button Borders (Figure 5) allows you to choose color, radius and size of borders for the pivot table buttons.
Figure 5: Button Borders
Header Cells
The Header Cells panel controls the appearance of cells in the pivot table header.
Header Settings controls the Header Row Height and sets the Expand Button Position, and Cells Text has settings for Horizontal Alignment and Wrap Text (Figure 6).
Figure 6: Header Settings
Cells Styling allows you to choose a background color and font color, size, family and style. There's also a setting for displaying a shadow with cell text.
Figure 7: Cells Styling
Enabling Borders allows you to set the border color and size.
Figure 8: Borders
Null Cells allows you to set the background and value color for any cells holding a NULL value, as well as letting you define your own Null Symbol (Figure 9).
Figure 9: Null Cells
Rows (Left) Cells
Rows (Left) Cells controls the appearance of cells in the pivot table rows. Column Settings controls the Expand Button Position, and Cells Text has settings for Horizontal Alignment and Wrap Text (Figure 10).
Figure 10: Cells Text
Cells Styling allows you to choose a background color and font color, size, family and style. There's also a setting for displaying a shadow with cell text.
Figure 11: Cells Styling
Enabling Borders allows you to set the border color and size.
Figure 12: Borders
Null Cells allows you to set the background and value color for any cells holding a NULL value.
Figure 13: Null Cells
Columns (Right) Cells
Rows (Left) Cells controls the appearance of cells in the pivot table rows.
Cells Text has settings for text alignment and wrapping within a cell.
Figure 14: Cells Text
Cells Styling allows you to choose a background type, background color and font color, size, family and style. There's also a setting for displaying a shadow with cell text.
Figure 15: Cells Styling
Enabling Borders allows you to set the border color and size.
Figure 16: Cells Text
Null Cells allows you to set the background and value color for any cells holding a NULL value.
Figure 17: Cells Text
Zero Value Cells allows you to set the background and value color for cells holding a ZERO value.
Figure 18: Zero Value Cells
Totals
The Totals settings control the appearance of the cells which display totals for pivot table values.
Position allows you to align the total value within a cell.
Figure 19: Totals Position
Totals Styling allows you to choose a background type, background color and font color, size, family and style.
Figure 20: Total Styling