Skip to main content
Announcements
Defect acknowledgement with Nprinting Engine May 2022 SR2, please READ HERE
cancel
Showing results for 
Search instead for 
Did you mean: 
EladKushmaro
Contributor III
Contributor III

Excel format default right to left layout

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.

Labels (1)
1 Solution

Accepted Solutions
Frank_S
Support
Support

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...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

3 Replies
Frank_S
Support
Support

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...

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
EladKushmaro
Contributor III
Contributor III
Author

Thanks Frank, cell by cell reporting made it correctly.

Elad.

Frank_S
Support
Support

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-Repo...

Kind regards,..

 

Please remember hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!