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.
You can show several types of hidden data from Microsoft Word, Excel, and PowerPoint documents, each of which has a corresponding
Hidden Data Type | Default Behavior | Configuration API Flag |
---|---|---|
Microsoft Word | ||
Comments1Word 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. | Shown2Shown 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
|
Comments | Hidden | KVCFG_SS_SHOWCOMMENTS
|
Formulas | Calculated value | KVCFG_SS_SHOWFORMULA
|
Microsoft PowerPoint | ||
Hidden slides | Shown | KVCFG_PG_HIDEHIDDENSLIDE
|
Comments | Shown3Shown by default in Microsoft PowerPoint 97 to 2000 documents. | KVCFG_PG_HIDECOMMENT
|
Comments slide | Hidden | KVCFG_PG_SHOWCOMMENTSSLIDE 4This setting affects PowerPoint 2003 and 2007 only.
|
Slide notes5PowerPoint 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 KVHTMLConfig().
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
Open the formats_e.ini
file in a text editor.
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
configuration API flag overrides the setting in formats_e.ini
.
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
Open the formats_e.ini
file in a text editor.
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
configuration API flag overrides the setting in formats_e.ini
.
|