6.3 Adding Oracle IRM Fields in Microsoft Excel


To complete this procedure you will need the Seal right, and to see transformed fields in sealed documents you will need the Open right as a minimum. See Section 1.3, "About Rights".


This procedure applies only to content sealed against 11g versions of Oracle IRM Server.

Use the following procedure to add an Oracle IRM field to a cell on a Microsoft Excel spreedsheet:

  1. Open the Microsoft Excel spreadsheet and select the cell in which you want the field to appear.

  2. Select the Insert menu, then select Function.

  3. From the Function category list, select Oracle IRM Add-in.

  4. From the Function name list, select OracleIRM_CustomProp.

  5. Click OK.

  6. In the Name box of the entry panel, enter the full field name.

    For example, to insert the field irm-account-name, enter irm-account-name.

    For the complete list of Oracle IRM fields, see Section 9.1, "List of Oracle IRM Fields".

  7. Click OK.

  8. Seal the Microsoft Excel document.