Cell Properties

Cell Properties icon Cell Properties

Cell properties enable you to change the way the selected range of member header cells and data cells are displayed in the grid.

Table 4-4 Review the Cell Properties

Property Name Descriptions

Number

  

Positive Prefix/Suffix

Specify a prefix and suffix for positive numbers

Negative Prefix/Suffix

Specify a prefix and suffix for negative numbers.

Negative in Red

Displays negative values in red.

Align Prefix/Suffix

Aligns numeric data values in a column based on the prefixes and suffixes defined.

Use Default

Uses the thousands and decimal separators based on the locale specified in User Preferences.

Thousands/Decimal Separator

If Use default is not selected, define thousands and decimal separators for the selected cells.

Decimal Places

Specify the number of decimal places to apply to a number.

Scale Value By

Number to multiply values by for scaling purposes. You can also specify custom scaling.

Font and Alignment

For both member heading and data cells, the Font and Alignment fields enable you to change the font, size, color, and placement of text within a cell, and to reverse the text direction for right-to-left languages. You can also specify an indent from the left cell margin.

Font and Font Size

Use the Font and Size drop down boxes to define the font.

The following default fonts are available:

  • Liberation Sans (Arial)
  • Liberation Serif (Times New Roman)
  • Liberation Mono (Courier New)
  • Albany (Japanese)
  • Albany (Korean)
  • Albany (Simplified Chinese)
  • Albany (Traditional Chinese)

Vertical/Horizontal Alignment

Select the desired vertical and horizontal alignment for the cell content.

Indent

Number of spaces to indent the heading and the associated text, data, and formula cells from the left margin.

Indent by

Indent the row headings of each generation or level of a selected member. Specify the number of spaces to indent the values from the left cell margin. You can specify a reverse indentation (from right to left) by using a negative number. You can indent by Generation, or by Level if all your level zero members are not at the same generation. Select None to remove the indent from the row or column.

Zoom

Use Zoom to enable zooming on the parent member. See Zooming on Parent Members in Grids

Note:

When you select Indent by (generation or level), or Zoom, a Relative Indent field is displayed. Use Relative Indent to adjust the size of the indent of the row member labels. This field displays the current indent in inches or centimeters, depending on your user preference. (See Using the Formatting Tab in Learning About Narrative Reporting ). The default value is .12 inches. You can adjust this value from -1.00 to 1.00 inches. Use negative values to reverse the indent of the row member labels.

Text Character Width

For text cells, the Text Character Width property allows a user to choose between more and less conservative sizing of text in a grid text cell. The property can have a value of Large, Medium, or Small. By default, the property is set to Large. For more information, see Using the Text Character Width Property.

Borders

In Borders, click border to open the border editor. Click top, bottom, left, right, or all to specify a border, and then click the drop down arrow to specify a border style. Click the border color to change it. You can pick a color from the color picker or manually enter an RGB value. You must enable a border (for example, All) in order to specify a style and color. Click OK to accept your changes.

When specifying overlapping borders on adjacent cells via formatting or conditional formatting, where the border width is the same, for example, a cell with a dashed bottom border and the cell below it with a solid top border, Reports will use the same behavior that the browser does for overlapping cell borders.

This behavior is as follows:

  • For vertically adjacent cells (top and bottom cells), the top cell’s bottom border will take precedence over the bottom cell’s top border.

  • For horizontally adjacent cells (left and right cells), the left cell’s right border will take precedence over the right cell’s left border.

Shading

In Shading, click shading to specify a background color for the selected cells. You can pick a color from the color picker or manually enter an RGB value.

Replace Text

Use Replace Text to replace the data value of a selected cell with a text string. For example, you can display "Confidential" in a cell that contains sensitive financial information. The text that you enter will be displayed in grid designer as well as all rendered output.

When you replace zero values, the text replacement is based on the displayed value of zero (which is not necessarily the actual data value). For example, if the data value is ".001" but it is formatted to display with no decimal places, the displayed value for the data is zero and therefore it will be replaced with the text that you specify. You can specify the number of extra decimal places of precision to consider in determining that the value is zero.

Drill through to source

To enable Drill Through to Source, where a file attached to a cell at the data source, such as an Oracle Fusion Cloud Enterprise Performance Management cell file attachment or Essbase Linked Reporting Object (LRO), for the entire grid, set Drill Through to Source to "Show". If set to "Hide", individual cells can still be enabled in Cell Properties. See Working with Drill Through and Cell File Attachments.

Allow Note Input

 For Narrative Reporting deployments in Note Column and Note Row segments, you can restrict or allow Note entry via the Allow Note Input formatting property for specific cells in a Note segment. For more information, see Setting the Allow Note Entry Property

Click Reset to Default to set all cell formatting for the selected cells back to their default settings.