From the drop-down list at the top of the panel, determine what part of the grid to format. See the appropriate section below for formatting options:
The following general formatting options are available to format rows, columns, and data cells in the Grid visualization:
All Grid Fonts: Use the options for standard font formatting to format all the data in the visualization:
Note: You can also format the columns, rows, or cell values separately, using the Column Headers options, Row Headers options, or Values options. If you change the font using the All Grid fonts options, the separate column, row, and value formatting is overwritten.
Show banding: Determine whether or not to apply color banding to rows in the visualization. If this option is selected, rows in the grid are displayed using alternating colors. (Cleared by default)
Padding: Determine whether to display a small, medium, or large amount of padding between values in the grid and each data cell.
Columns: Select one of the following column width options:
Auto Fit to Window (default): The grid's columns stretch to fit the size of the available space in the grid container.
Auto Fit to Contents: The width of the grid's columns is sized to fit the data in the column. All extra space in the grid is removed.
Fixed: Each column is displayed using a fixed width. If you select this option, from the drop-down list, select the column to adjust, then type the width of the column in pixels. You can also select All Columns from the drop-down list, then type the column width that will be used for every column in the grid.
Rows: Select one of the following row height options:
Auto Fit to Contents (default): The height of the grid's rows is sized to fit the data in the row. All extra space in the grid is removed.
Fixed: Each row is displayed using a fixed height. If you select this option, in the Row Height field, type the height of the row in pixels.
You can define additional formatting options, such as showing, merging, and locking the row or column headers; how to display the attribute form names; and determine how null and zero metric values are hidden. To access these options, click More Options. For detailed descriptions of these options, see More Options dialog box.
The following options are available to format the title and background in a Grid visualization:
Title: Use the following options to display and format the visualization’s title:
Show Titlebar: Select to display the visualization’s title.
Use the options for standard font formatting.
Container: Use the following options to format the visualization’s background (the container that holds the visualization):
Fill Color: From the color palette, select the background color of the visualization.
Outer Border: From the drop-down list, select the line style of the visualization’s borders. The default is Thin. From the color palette, select the color of the borders around the visualization.
The following options are available to format the column headers in the Grid visualization.
Font: Use the options for standard font formatting.
Fill Color: Select the background color to use to display the column header.
Horizontal Lines: Select the line style and color to use to display the horizontal borders of the column header.
Vertical Lines: Select the line style and color to use to display the vertical borders of the column header.
Alignment
Select the vertical alignment to use to display the header text. The options are Top, Middle, and Bottom.
Select the horizontal alignment to use to display the header text. The options are Left, Center, Right, and Justify.
Determine whether or not to wrap the header text, by selecting or clearing the Wrap Text check box. Wrapped text displays on multiple lines instead of a single line.
The following options are available to format the row headers in the Grid visualization.
Font: Use the options for standard font formatting.
Fill Color: Select the background color to use to display the row header.
Horizontal Lines Select the line style and color to use to display the horizontal borders of the row header.
Vertical Lines: Select the line style and color to use to display the vertical borders of the row header.
Alignment
Select the vertical alignment to use to display the header text. The options are Top, Middle, and Bottom.
Select the horizontal alignment to use to display the header text. The options are Left, Center, Right, and Justify.
Determine whether or not to wrap the header text, by selecting or clearing the Wrap Text check box. Wrapped text displays on multiple lines instead of a single line.
The following options are available to format the data cells in the Grid visualization:
Font
Select the font type from the first drop-down list.
Apply Bold, Italic, Underline, or Strikethrough formatting to the text, by clicking the appropriate icon.
Select the font size from the drop-down list.
Select the font color from the color palette.
Fill Color: Select the background color to use to display the values.
Horizontal Lines
Border Style: Select the line style to use to display the horizontal borders of the values area.
Border Color: Select the line color to use to display the horizontal borders of the values area.
Vertical Lines
Border Style: Select the line style to use to display the vertical borders of the values area.
Border Color: Select the line color to use to display the vertical borders of the values area.
Alignment
Select the vertical alignment to use to display the values. The options are Top, Middle, and Bottom.
Select the horizontal alignment to use to display the values. The options are Left, Center, Right, and Justify.
Determine whether or not to wrap the values, by selecting or clearing the Wrap Text check box. Wrapped text displays on multiple lines instead of a single line.
_____________________________
Copyright © 2019, Oracle and/or its affiliates. All rights reserved.
Legal Notices