Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ?
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.
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
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