topic nprinting date formatting bug in Qlik NPrinting

nprinting date formatting bug

markp201 — Fri, 26 Jan 2018 19:37:41 GMT

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 ?

Re: nprinting date formatting bug

Ruggero_Piccoli — Wed, 31 Jan 2018 14:05:06 GMT

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.

Re: nprinting date formatting bug

mkelemen — Wed, 31 Jan 2018 14:32:44 GMT

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

Re: nprinting date formatting bug

mkelemen — Wed, 31 Jan 2018 14:37:58 GMT

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