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: 
paul_ripley
Creator III
Creator III

N Printing Gridlines showing in PPT

Hello

I have report in QV (see below) and as you can see the £m column doesn't show any gridlines

However, when I import it into Powerpoint N Printing (keeping source formats)  then grid lines appear.

It suggest that somewehere in QV there are actually gridlines.

I can untick Keep Source Formats but the  you lose the Bold formatting on the text eg on Subtotal.

How can I stop these gridlines from appearing?

Many thanks

9 Replies
Lech_Miszkiewicz

Hi Paul,

When you export data to MsOffice you cannot use transparency. It looks like in Qlik your gridlines are colored but transparent. When exportoning transparency is removed but colour stays as it was.

Try to change grid color for this column to white and see how it goes.

We had similar issue here:

Re: Nprint Pivot table formatting issue

cheers

Lech

---------------------------------------------

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.

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
paul_ripley
Creator III
Creator III
Author

Hi Lech

Thanks for your help I will raise it with QV as a bug.

Unfortunately some of my columns have grey shading so that if I turn the gridlines white then the gridlines will show in the grey columns I think (although I am not actually sure how to change gridline colours anyway)

Kind regards

Paul

Lech_Miszkiewicz

Hi Paul

  • This is not a BUG as it is purely MsOffice limitations so you will not win anything by raising a bug case.
  • Second grid line for each column can have different color so you only need to mach the color and make sure that there is no transparency applied on the color for gridline and background.

regards

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
paul_ripley
Creator III
Creator III
Author

OK thanks.

But where do you change the gridline colours in a straight table.  I've already changed the borders to white

Thanks

Paul

Lech_Miszkiewicz

I have given you link in my previous comment... search for "Custom format cell"..

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
paul_ripley
Creator III
Creator III
Author

Ok no I dont think it works

I would expect the columns in the Grey to have the white lines in N Printing but they are still solid grey.

No worries thanks anyway

Lech_Miszkiewicz

are you able to share qvw? Maybe scramble data and reduce data...

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.
paul_ripley
Creator III
Creator III
Author

Hi Lech

I appreciate your time but I think i'll give up.

I don't know how to scramble data etc.

I will just have to work around it.

Thanks a lot for trying to help

Paul

Lech_Miszkiewicz

Just in case you change your mind:

scrambling: https://www.youtube.com/watch?v=_HeuRBLZVWQ

reducing data (around 1:30 min) https://www.youtube.com/watch?v=0NC-IgkIb5w

cheers

Lech

cheers Lech, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful to the problem.