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:
-
Uninstall Smart View.
See Uninstalling Smart View for more information.
-
Reinstall Smart View by right-clicking
SmartView.exe
and selecting Run as administrator.See Installing from My Oracle Support or Oracle Technology Network for more information.
-
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:
-
Start a Windows command prompt as administrator.
-
Switch to the
bin
folder in your Smart View installation.The default location is
Oracle\SmartView\bin
. -
Run the following command:
C:\Windows\Microsoft.NET\Framework\v4.0.30319\regasm.exe /codebase HsSpread.dll
-
In the command prompt, check for any errors in the output.
-
Test the spreading functionality.
If the issue persists, contact Oracle Support.