topic Re: Excel format default right to left layout in Qlik NPrinting

Excel format default right to left layout

EladKushmaro — Mon, 03 Apr 2023 13:04:57 GMT

Hi,

Is it possible to create Excel report in Nprinting so it will open in right to left layout (the first column will be on the right)?

Thanks, Elad.

Re: Excel format default right to left layout

Frank_S — Mon, 03 Apr 2023 22:42:38 GMT

Hi @EladKushmaro

Just so you know, you have chosen NPrinting 16.2 as a product label and that version is not supported.

Please update the label if you are actually using a current supported version.

It is not really clear as to what your requirement actually is here.

However, if you need to force a specific layout such as headers in the left column, you may choose to use cell by cell reporting.

This is a much more onerous, methodical 'cell by cell approach but it is possible for your specific use case (assuming I understand your requirement correctly).

Step 1: Choose Cells in template editor

Step 2:choose chart object

Step 3: choose number of rows and charts for report

Step 4: Drag and drop individual cells in to the desired position

Step 5: Preview your report.

Notice and compare original chart against the left position of the field headers for chart "Top 25 Products"

Hope this helps...

Kind regards...

Re: Excel format default right to left layout

EladKushmaro — Tue, 04 Apr 2023 09:56:32 GMT

Thanks Frank, cell by cell reporting made it correctly.

Elad.

Re: Excel format default right to left layout

Frank_S — Tue, 04 Apr 2023 14:11:57 GMT

Great!

Glad it worked. I noticed we don't have steps for this in our help page so I created a "How To" article about this topic.

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-an-NPrinting-Cell-by-Cell-Report/ta-p/2056457

Kind regards,..