Support for HsGetSheetInfo Function

HsGetSheetInfo is used to retrieve detailed information about the current sheet. This function, already available in Oracle Smart View for Office, can now be used in Oracle Smart View for Office (Mac and Browser).

Applies to: Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Planning, Tax Reporting

In Smart View (Mac and Browser), the following properties or sheet information are supported:

  • Last Retrieved
  • Sheet Type
  • Application
  • Cube
  • URL
  • Server
  • Alias Table
  • Provider

For creating the HsGetSheetInfo function manually, use the following syntax:

HsGetSheetInfo("<propertyname>")

where <propertyname> is any property from the above list.

For example, if you want to display the sheet type of the current sheet, enter =HsGetSheetInfo("Sheet Type") and press Enter. Smart View displays the relevant value—Ad hoc, Form, Multiple grid ad hoc, or Function, as per the type of the sheet.

Business Benefit: Using HsGetSheetInfo, users can know and display detailed information about the sheet in the sheet itself.

Steps to Enable

To use the HsGetSheetInfo function, Service Administrators must create and deploy a new manifest file.

To deploy a new or existing manifest file:

  1. Create a new manifest file or reuse an existing manifest file.
  2. In the Create Manifest File page, make any other selections and modifications, as you require.
  3. Deploy the manifest file to Smart View (Mac and Browser) users.

Key Resources

  • HsGetSheetInfo in Working with Oracle Smart View for Office (Mac and Browser)