Text options
The following options are available for text export:
Pivot Table Format. Pivot tables can be exported in tab-separated or space-separated format. For space-separated format, you can also control:
- Column Width. Autofit does not wrap any column contents, and each column is as wide as the widest label or value in that column. Custom sets a maximum column width that is applied to all columns in the table, and values that exceed that width wrap onto the next line in that column.
- Row/Column Border Character. Controls the characters used to create row and column borders. To suppress display of row and column borders, enter blank spaces for the values.
Layers in pivot tables. By default, inclusion or exclusion of pivot table layers is controlled by the table properties for each pivot table. You can override this setting and include all layers or exclude all but the currently visible layer. See the topic Table properties: printing for more information.
Include footnotes and captions. Controls the inclusion or exclusion of all pivot table footnotes and captions.
Views of Models. By default, inclusion or exclusion of model views is controlled by the model properties for each model. You can override this setting and include all views or exclude all but the currently visible view. See the topic Model properties for more information. (Note: all model views, including tables, are exported as graphics.)
To set text export options
- Make the Viewer the active window (click anywhere in the window).
- From the
menus choose:
- Select Text as the export format.
- Click Change Options.