ShareScan 5.4 SP1 (and 6.1): Creating Excel files results in misformatted pages
When using a connector in ShareScan 5.4 SP1 (and 6.1), and saving as file type Excel, the resulting file has a misformatted second page and beyond.
This issue has been resolved with the following hotfix:
ShareScan 5.4 SP 1 Hotfix 4301 (SS54SP1_HF4301)
To obtain this hotfix, please open a support ticket with Technical Support.
Please go through the following steps:
Please note that the solution requires Database Lookup Exender license. If DLE is not present at the licenses you can not use the solution.
The Actual Issue Addressed: ShareScan does not always detect layout of spreadsheet documents correctly with the default settings. The result is that if the File Format Option is Excel (.xls or .xlsx), then the output document may be incorrect. Typically only a part of the spreadsheet appears on Sheet1 and the rest of the document, not detected as part of the spreadsheet, is placed on a second sheet called "Overview" A Generic Problem is Also Addressed with this Hotfix: The purpose of this hotfix is also to introduce the possibility of specifying a setting (.sts) file to be used with a given connector profile. This can be done via a Database Lookup Extender (DLE) profile. This enhancement allows us to fine tune the document creation behavior in cases where the default settings do not yield optimal results. If a particular issue can be resolved by using such a settings file, support will receive it from development and can provide it for the customer. Solution: Two settings files are provided with this hotfix. Both of them creates correct Excel output, the difference is in the formatting of the output document. The customer can decide which one is optimal for them. In order to use a setting file with a connector profile, follow the steps below: 1. Copy the setting file to the "
DocumentLayoutSpreadsheetFormatted.sts (110 KB)