Spreading Issue, Smart View Installation, and HsSpread.dll

In some cases, spreading is not working as expected.

Oracle Smart View for Office is not automatically spreading data from the YearTotal or Quarter level down to the months. Data is spread automatically when entering values into forms on the web, but the same functionality is not working in Smart View.

The issue may be due to the dynamic link library, HsSpread.dll, not being registered correctly, which can happen when Smart View is installed by a non-admin user.

This issue affects Planning 18.02.67+ and Planning Modules 17.12.54 and later.

To fix this issue, Oracle recommends the following:

• Uninstall Smart View and reinstall as the Windows administrator. See Reinstall Smart View as Administrator.

• If the spreading issue persists after reinstalling Smart View as the administrator, then manually register the HsSpread.dll file. See Register HsSpread.dll.

Reinstall Smart View as Administrator

To reinstall Smart View as administrator, perform these steps:

1. Uninstall Smart View.

   See Uninstalling Smart View for more information.

2. Reinstall Smart View by right-clicking SmartView.exe and selecting Run as administrator.

   See Installing from My Oracle Support or Oracle Technical Resources for more information.

3. Launch Excel, open a form or ad hoc grid, and verify that spreading is working.

   If the spreading issue persists, complete the steps in Register HsSpread.dll.

Register HsSpread.dll

To register the HsSpread.dll with Windows:

1. Start a Windows command prompt as administrator.

2. Switch to the bin folder in your Smart View installation.

   The default location is Oracle\SmartView\bin.

3. Run the following command:

   C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe /codebase HsSpread.dll

4. In the command prompt, check for any errors in the output.

5. Test the spreading functionality.

   If the issue persists, contact Oracle Support.