Microsoft Word, Excel, or 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 exactly which types of hidden data to export.
You can display four types of hidden data from Microsoft Word, Excel, and PowerPoint documents, each of which has a corresponding parameter, which you can change to determine whether to show the hidden data. The table below lists each data type, its default behavior, and its corresponding configuration parameter.
Hidden data type | Default behavior | Configuration API flag |
---|---|---|
Microsoft Word | ||
Comments | Shown1Shown by default in Microsoft Word 97 to 2003 documents. | KVCFG_WP_NOCOMMENTS
|
Hidden text | Hidden | KVCFG_WP_SHOWHIDDENTEXT
|
Date field codes | Hidden | KVCFG_WP_SHOWDATEFIELDCODE
|
File name field codes | Hidden | KVCFG_WP_SHOWFILENAMEFIELDCODE
|
Microsoft Excel | ||
Hidden information | Hidden | KVCFG_SS_SHOWHIDDENINFOR
|
Comments | Hidden | KVCFG_SS_SHOWCOMMENTS
|
Formulas | Hidden | KVCFG_SS_SHOWFORMULA
|
Microsoft PowerPoint | ||
Hidden slides | Shown | KVCFG_PG_HIDEHIDDENSLIDE
|
Comments | Shown2Shown by default in Microsoft PowerPoint 97 to 2000 documents. | KVCFG_PG_HIDECOMMENT
|
Comments slide | Hidden | KVCFG_PG_SHOWCOMMENTSSLIDE 3This setting affects PowerPoint 2003 and 2007 only.
|
Slide notes | Hidden | KVCFG_PG_SHOWSLIDENOTES
|
|