Qlik Community

Qlik NPrinting Discussions

Discussion Board for collaboration on Qlik NPrinting.

markp201
Contributor III

nprinting date formatting bug

We have some date fields for an excel report.  Since they are numbers, we need either change the column width or use merge/center.

We can change the width because of the detail lines below but when we use merge/center, this format gets dropped in the generated excel file.  Is this a bug ?

Tags (3)
3 Replies
Employee
Employee

Re: nprinting date formatting bug

Excel Keep Source Format.png

Hi,

Did you tried to remove the "Keep source format" flag and applying the Excel formatting rules on the column?

Another way, visible in the screenshot, could be to insert a formatting formula in the source table.

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 as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

mkelemen
Contributor III

Re: nprinting date formatting bug

Hi Mark,

it is not a bug - it is a known limitation

According to November 2017 release notes:

Keep Source Format option does not keep Excel merged cells

Jira issue ID: OP-5545

Excel merged cells are not supported for Qlik NPrinting tags regardless of Keep Source Format

Option.

BR,

  Matus

mkelemen
Contributor III

Re: nprinting date formatting bug

It is actually even worse according to this document.

NPrinting Unsupported QV Items

Merged Cells in NPrinting Excel Report Templates. These will cause reporting failures or unexpected reporting results.

  Matus

Community Browser