KeyView 24.1

# Show Hidden Data

Microsoft Word, Excel, and PowerPoint documents contain hidden information, some of which is shown by default when exported, and some of which is hidden by default. There are several options that allow you to determine which types of hidden data are shown.

NOTE: KeyView does not consider white text on a white background to be hidden text. Export outputs the white text as black text to make it readable.

## Hidden Data in Microsoft Documents

You can show several types of hidden data from Microsoft Word, Excel, and PowerPoint documents, each of which has a corresponding flag in the KVXMLConfig() function, which you can set to change the default behavior. The following table lists each data type, its default behavior, and its corresponding configuration API flag.

Hidden data settings

Hidden Data Type | Default Behavior | Configuration API Flag
--- | --- | ---
Microsoft Word |  |
Comments 1 Word comment settings can also be toggled with a configuration parameter in the formats_e.ini file. See Toggle Word Comment Settings in the formats_e.ini File. | Shown2 Shown by default in documents from Microsoft Word 97 and later. | `KVCFG_WP_NOCOMMENTS`
Hidden text | Hidden | `KVCFG_WP_SHOWHIDDENTEXT`
Date field codes | Calculated date | `KVCFG_WP_SHOWDATEFIELDCODE`
File name field codes | Document file name | `KVCFG_WP_SHOWFILENAMEFIELDCODE`
Microsoft Excel |  |
Hidden information | Hidden | `KVCFG_SS_SHOWHIDDENINFOR`
Notes (previously known as comments) | Hidden | `KVCFG_SS_SHOWCOMMENTS`
Formulas | Calculated value | `KVCFG_SS_SHOWFORMULA`
Microsoft PowerPoint |  |
Hidden slides | Shown | `KVCFG_PG_HIDEHIDDENSLIDE`
Comments | Shown3 Shown by default in Microsoft PowerPoint 97 to 2000 documents. | `KVCFG_PG_HIDECOMMENT`
Comments slide | Hidden | `KVCFG_PG_SHOWCOMMENTSSLIDE` 4 This setting affects PowerPoint 2003 and 2007 only.
Slide notes5 PowerPoint slide note settings can also be toggled with a configuration parameter in the formats_e.ini file. See Toggle PowerPoint Slide Note Settings in the formats_e.ini File. | Hidden | `KVCFG_PG_SHOWSLIDENOTES`

To toggle the display of any type of hidden data

- Use the configuration API and set the third parameter to `TRUE` or `FALSE`:

      (*fpHTMLConfig)(pKVHTML, KVCFG_WP_NOCOMMENTS, TRUE, NULL)

  In this example, comments will not be exported from Word documents.

  NOTE: The third parameter affects the default behavior. To change the default behavior, set it to `TRUE`.

For more information, see KVXMLConfig().

### Toggle Word Comment Settings in the formats_e.ini File

Microsoft Word 97 to 2003 comment settings can also be controlled through a parameter in the `formats_e.ini` file.

The `formats_e.ini` file is in the directory `install\OS\bin`, where `install` is the path name of the Export installation directory and `OS` is the name of the operating system.

To toggle comment output in formats_e.ini

1. Open the `formats_e.ini` file in a text editor.

2. Under `[Options]`, add the `WP_NOCOMMENTS` parameter and set it to `0` to show comments, or `1` to hide comments. For example:

       [Options]
       WP_NOCOMMENTS=1

   NOTE: The `KVCFG_WP_NOCOMMENTS` configuration API flag overrides the setting in `formats_e.ini`.

### Toggle PowerPoint Slide Note Settings in the formats_e.ini File

Microsoft PowerPoint slide note settings can also be controlled through a parameter in the `formats_e.ini` file.

The `formats_e.ini` file is in the directory `install\OS\bin`, where `install` is the path name of the Export installation directory and `OS` is the name of the operating system.

To toggle slide note output in formats_e.ini

1. Open the `formats_e.ini` file in a text editor.

2. Under `[Options]`, add the `ShowSlideNotes` parameter and set it to `1` to show slide notes, or `0` to hide slide notes. For example:

       [Options]
       ShowSlideNotes=1

   NOTE: The `KVCFG_PG_SHOWSLIDENOTES` configuration API flag overrides the setting in `formats_e.ini`.

Copyright 1997-2023 Open Text
Version 24.1 | Last updated December 2023

Send documentation feedback

Close

Send documentation feedback

To send feedback using your default email client, open an email window.

Otherwise, send your feedback and the information below to MFI-swpdl.idoldocsfeedback@opentext.com.

We appreciate your feedback!

Product: IDOL KeyView 24.1

Topic Title: Show Hidden Data