User Preferences: Export
The Copying to Clipboard section covers the preferences for copying sheet objects to the Clipboard.
In the Include Caption and Border group it is possible to enter the preferences separately for each of the following sheet object types: List Box, Statistics box, Multi box, Table box, Input box, Current Selections box and Chart for whether to include these layout features or not in the copy process.
It is possible to set a preference for copying tables under Copy Table Format. From the command Copy to Clipboard in the object menu of any QlikView table it is possible to make additional choices regarding what information should be included at export.
- Full Table: If this option is checked, a formatted table complete with its selection status will be copied. This setting is preferable when copying for presentation purposes.
- Data Area Only: If this option is checked, nothing but the raw data will be copied. This is the preferred setting for quickly moving data between documents etc.
- Show Options in Menu: If this option is checked, both alternatives will always be available as a drop-down list from the Copy to Clipboard command.
In the Replace Image as Default group it is possible to specify what is placed in Clipboard when the Cut and Copy commands (Edit menu) are used. Normally only the bitmap image of a sheet object is copied, but for a number of sheet objects further options are available:
- Table for Tables: Check this option to have tables (table boxes, straight tables and pivot tables) copied in table format rather than as an image.
- Values for Charts: Check this option to have charts copied as underlying table values rather than as an image.
- Possible Values for List Boxes: Check this option to have list boxes copied as possible values rather than as an image.
- Text for Buttons: Check this option to have buttons copied as text rather than as an image.
- Text for Text Objects: Check this option to have text objects copied as text rather than as an image.
- Selections for Current Selections Box: Check this option to have current selections boxes copied as text selection stamp rather than as an image.
The Clipboard Zoom setting, which is independent of the current zoom setting of the sheet, determines the size of the copied image. Larger pictures give better picture quality at the cost of increasing size.
In the Selection Stamps in Exports group it is possible to determine whether selection stamps should be included when exporting to the file types specified.
- On HTML Exports: Check to include selection stamps when exporting to HTML files.
- On BIFF Exports: Check to include selection stamps when exporting to BIFF (Excel) files.
In the Default Export Options group it is possible to set defaults for export formatting.
- Number Formatting: The number formatting of numeric data in QlikView may not always be
compatible with other programs due to user defined settings etc. The drop-down offers three choices in Number Formatting
of numeric data that is to be exported.
- Full Formatting: Exports numeric data with its full number format, just as it is shown in the sheet objects of the document.
- No Thousand Separator: Removes any thousand separator from numeric data.
- No Formatting: Removes all number formatting from the data and exports the raw numbers. The decimal separator will be as defined in the system settings (Control Panel).
- Encoding: It is possible to set the default character set for export in new documents. Choose one of these option: ANSI, Unicode or UTF-8.
- Use regional settings for HTML export: With this option the regional settings of the operating system are used for the decimal separator when exporting to HTML. By deselecting this option, a decimal point will be used, regardless of the regional settings.
In the Send to Excel options group it is possible to set defaults for formatting used by the Send to Excel menu command.
- Adjust Excel Palette to Colors in Export: If unchecked, the standard colors of the Excel palette will replace the colors chosen in QlikView. The original colors will be replaced by those that correspond the best to the colors in the standard palette.