1. Designing with Financial Reporting Web Studio for Oracle Enterprise Performance Management Cloud
  2. Designing Reports with Financial Reporting Web Studio
  3. Working With Grids
  4. Formatting Grids
  5. Inheriting Cell Formatting

Inheriting Cell Formatting

When formatting cells in a grid, you can inherit formatting from a cell and apply it to another cell. The following formatting options can be inherited from a cell in a grid:

  • Number

  • Alignment

  • Font

  • Borders and Shading

  • Replacement Text

To inherit cell formatting:

  1. Open a report and select a cell or cells in a grid.
  2. Select Format, and then Cell.
  3. In the Format Cells dialog box, in the Inherit Formatting tab:

    • Select the formatting options to inherit.

      To select all the formatting options under a category, select the check box next to the category. For example, to inherit all number formatting options, select the check box next to Number.

      To select specific formatting options for a category, click Expand button, and then select the specific formatting options. For example, to inherit the Decimal Separator value under Number, expand Number, and then select the check box next to Decimal Separator.

      To inherit all the formatting options, click Select All button

    • Select the rows or columns from which to inherit the formatting.

      You can select the Current Row or Current Column, or you can select a specific row or column number.

  4. Click Apply and then OK.

Note:

You can only inherit from a cell that does not have previously defined inheritance. For example, if you format column A and then inherit formatting into column B, you cannot then inherit formatting from column B into column C. You can, however, format column A, select columns B and C, and inherit formatting for column B and C from column A.

Note:

If you have inherited formatting and then modify the format of the cell to which you inherited formatting, the inheritance you established no longer applies. For example, if you inherit the font name property in cell A4 from cell B4 and you subsequently modify the font name in cell A4, the format inheritance no longer exists. This breaks the formatting link that was previously established between the two cells.