Skip to main content
Qlik Connect 2024! Seize endless possibilities! LEARN MORE

Can I Apply Word Formatting to my NPrinting Word Reports?

Showing results for 
Search instead for 
Did you mean: 

Can I Apply Word Formatting to my NPrinting Word Reports?

Last Update:

Nov 19, 2015 2:10:19 PM

Updated By:


Created date:

Nov 19, 2015 2:10:19 PM

Description: When creating templates for generating Word reports, you might sometimes want to present information with the formatting as it is in QlikView. This is the default setting. Other times you might want to apply formatting using the tools that Word provides. We are going to deselect Keep Source Formats for the table as a whole and then apply Word provided formatting. Table formatting using tools provided by Word work only if you save your template in .docx format and not if your template is saved in .doc format. Save Word templates in .doc format only if necessary for backward compatibility.

Allow Application of Word Formatting for Whole Chart


After you have added a QlikView object as a table:

  1. Click on the table node
  2. Uncheck the Keep Source Formats box and click on OK at the bottom of the Properties dialog window. If you don't find the Properties windows, right click on the table node and select Properties...
  3. Click on the Toolbar button.
This will cause the contents of all cells in all columns of the table to be exported from QlikView without formatting.

Wrap Text Feature


Checking Wrap Text causes NPrinting to automatically create two lines if the cell is too small. This works only with Keep Source Formats unchecked. Wrap Text is a Table property that affects all columns of the table.

Resulting Unformatted Table


Not very nice. Now, to apply Word formatting.

Apply Word Formatting to Entire Table

Before adding the table to the template:
  1. Select the Insert tab on the toolbar
  2. Select Table
  3. Select the uppermost left cell to insert a 1x1 Table into the template

Add Your Table to the Template

  1. Expand the CH184 - Top 25 Products node by clicking on the '+' to its left if necessary
  2. You can select multiple values by keeping CTRL or SHIFT pressed during the columns selection
  3. "Drag and drop" them into the template. This will create all tags and insert them into a horizontal series of cells.

Set Table to AutoFit Columns

  1. Select the Layout tab in the Table Tools section of the toolbar
  2. Click on AutoFit in the Cell Size section of the toolbar
  3. Select AutoFit Contents

Apply Table Style

After selecting the table:
  1. Select the Design tab in the Table Tools section of the toolbar
  2. Select a general style in the Table Styles section of the toolbar

Prepare to Preview


  1. Click on Save As and save the template
  2. Close



1. Click on Preview in the Actions section of the toolbar.

Inspect Result


Version history
Last update:
‎2015-11-19 05:10 PM
Updated by: