Cell Properties

Use this property sheet to set properties for formula cells or data cells. The properties that are enabled depend on the type of cell you select in a grid.

Table 61. Cell Properties Sheet  

Item

Use

Calculation order

Select one of the following options for specifying order of calculation:

  • Select Use the row formula if your want the row calculation applied to the cell.

  • Select Use the column formula if you want the column calculation applied to the cell.

  • Select Use a custom formula if you want to add a new formula.

Retrieve Cell Documents

For Oracle Essbase and Financial Management databases only, select this function to allow the ability to attach documents in Word, Excel, or PDF to the end of a report as well as insert a footnote into the report to add a description about the attached documents.

Add Related Content

Select Add Related Content to create links to objects in J2EE, Web Analysis, or Financial Reporting, then click Setup to specify the links within Related Content Setup.

XBRL Context

This control is only displayed if you enabled XBRL editing in the Preferences dialog box. Select XBRL Context to modify XBRL context of cells, then perform an action:

  • To exclude XBRL context settings for the selected cells, click None.

  • To revert to the default XBRL context setting of the column, click Use Column Context.

  • To change the XBRL context settings for the selected cell, click Use Cell Context, then click Setup. For information on setting XBRL context, see Managing XBRL Context.

XBRL Unit

This control is only displayed if you enabled XBRL edintin the Preferences dialog. Select XBRL Unit to modify XBRL unit of cells, then perform an action:

  • To exclude XBRL Unit settings for the selected cells, click None.

  • To revert to the default XBRL Unit setting of the column, click Use Column Context.

  • To change the XBRL Unit settings for the selected cell, click Use Cell Context, then click Setup..