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

 

 

Comments1You 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_SHOWCOMMENTSSLIDE4This 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

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: 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: Note: The KVCFG_PG_SHOWSLIDENOTES configuration API flag overrides the setting in formats_e.ini.

_HP_HTML5_bannerTitle.htm