Open topic with navigation

# 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.

## 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 parameter in the `Export` class, which you can set to change the default behavior. Hidden data settings lists each data type, its default behavior, and its corresponding configuration parameter.

Hidden data settings

Hidden Data Type | Default Behavior | Configuration API Parameter
--- | --- | ---
Microsoft Word |  |
Comments 1You can also toggle Word comment settings with a configuration parameter in the formats_e.ini file. See “Toggle Word Comment Settings in the formats_e.ini File” on page 135. | Shown2Shown by default in Microsoft Word 97 to 2003 documents. | `CFG_WP_NOCOMMENTS`
Hidden text | Hidden | `CFG_WP_SHOWHIDDENTEXT`
Date field codes | Calculated date | `CFG_WP_SHOWDATEFIELDCODE`
File name field codes | Document file name | `CFG_WP_SHOWFILENAMEFIELDCODE`
Microsoft Excel |  |
Hidden information | Hidden | `CFG_SS_SHOWHIDDENINFOR`
Comments | Hidden | `CFG_SS_SHOWCOMMENTS`
Formulas | Calculated value | `CFG_SS_SHOWFORMULA`
Microsoft PowerPoint |  |
Hidden slides | Shown | `CFG_PG_HIDEHIDDENSLIDE`
Comments | Shown3Shown by default in Microsoft PowerPoint 97 to 2000 documents. | `CFG_PG_HIDECOMMENT`
Comments slide | Hidden | `CFG_PG_SHOWCOMMENTSSLIDE` 4This setting affects PowerPoint 2003 and 2007 only.
Slide notes5You can also toggle PowerPoint slide note settings with a configuration parameter in the formats_e.ini file. See “Toggle PowerPoint Slide Note Settings in the formats_e.ini File” on page 135. | Hidden | `CFG_PG_SHOWSLIDENOTES`

To toggle the display of hidden data

- Use the `setConfigOption` method of the `Export` object, and set the `config` parameter to one of the options listed in Hidden data settings. Setting a hidden data parameter changes the default behavior.

  For example:

      objExport.setConfigOption(Export.CFG_WP_SHOWHIDDENTEXT);

  In this case, the configuration parameter ensures that hidden text in Microsoft Word documents is shown (it is hidden by default).

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

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

The `formats_e.ini` file is in the `install\OS\bin` directory, 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 to `1` to hide comments. For example:

       [Options]
       WP_NOCOMMENTS=1

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

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

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

The `formats_e.ini` file is in the `install\OS\bin` directory, 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 to `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`.

© 2006-2018 EntIT Software LLC, a Micro Focus company | Send documentation feedback to Micro Focus Close Send documentation feedback To open the configured email client on this computer, open an email window. Otherwise, copy the information below to a web mail client, and send this email to swpdl.idoldocsfeedback@microfocus.com. We appreciate your feedback! Product: Topic Title: Help Topic: Feedback:

_FT_HTML5_bannerTitle.htm