Unable To Detect Presence Of Hidden Excel Data, Pivot Tables, Protected Worksheets, Etc., With Content Access 8.4.1 (Doc ID 1603427.1)

Last updated on MAY 02, 2017

Applies to:

Oracle Outside In Technology - Version 8.4.1 and later
Information in this document applies to any platform.

Goal

Content Access (CA) 8.4.1 extracts all Excel text, even when it is hidden. However, there is no indication of hidden text being hidden.  Also, the following information is not provided by Content Access about data in Excel files:

+ hidden rows
+ hidden columns
+ Auto-Filter enabled (whether rows are hidden or not)
+ hidden worksheets
+ very-hidden worksheets
+ protected workbook (structure and/or window)
+ contains Pivot Table
+ protected worksheet
+ revisions (detect presence as well as insert/deletes, like in MS Word)
+ hidden text when text is hidden via formatting: ;;;

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms