Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

AndersGS
New Contributor II

Separate Header and Cell heights in Excel reports

Hi,

I want to separately adjust the Cell and Header Height in an NPrinting Excel report. I have tried to make the adjustment in the corresponding QlikView Report without succeeding. If trying to adjust the row height in the Excel Template Editor, both Cell and Header Height are adjusted equally.

We are embedding the table as blocks (due to data calculation limitations, preventing an column by column  approach) “Keep Source Formats” box ticked. Output format of the report is pdf.

We are running NPrinting 19 February 2019 SR1 and QlikView 11.20 SR 18.

Thank you

Anders

Tags (1)
1 Solution

Accepted Solutions
Employee
Employee

Re: Separate Header and Cell heights in Excel reports

Hi,

If you insert a table as a single tag in an Excel template, Qlik NPrinting will do its best effort to keep the original format but it could be not completely similar to the original.

If you drag and drop each single column you can add the column header and format them as you prefer. By removing "Keep source format" you can customize the format of the columns by using Excel formatting features.

If your goal is to create a PDF, I would to suggest you to create a PixelPerfect template instead of an Excel. Use Excel template to export the report in Excel format.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

2 Replies
Employee
Employee

Re: Separate Header and Cell heights in Excel reports

Hi,

If you insert a table as a single tag in an Excel template, Qlik NPrinting will do its best effort to keep the original format but it could be not completely similar to the original.

If you drag and drop each single column you can add the column header and format them as you prefer. By removing "Keep source format" you can customize the format of the columns by using Excel formatting features.

If your goal is to create a PDF, I would to suggest you to create a PixelPerfect template instead of an Excel. Use Excel template to export the report in Excel format.

Best Regards,

Ruggero



Best Regards,
Ruggero
---------------------------------------------
When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads with a LIKE if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads with LIKEs if you feel additional info is useful to others.

View solution in original post

AndersGS
New Contributor II

Re: Separate Header and Cell heights in Excel reports

Thanks Ruggero!