Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
AndersGS
Contributor III
Contributor III

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

1 Solution

Accepted Solutions
Ruggero_Piccoli
Support
Support

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
Ruggero_Piccoli
Support
Support

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.
AndersGS
Contributor III
Contributor III
Author

Thanks Ruggero!