3 Replies Latest reply: Jan 31, 2018 9:37 AM by Matus Kelemen RSS

    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 ?

        • Re: nprinting date formatting bug
          Ruggero Piccoli

          Excel Keep Source Format.png



          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,



          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
            Matus Kelemen

            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