N Printing Gridlines showing in PPT

[paul_ripley]

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

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

[paul_ripley]

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

[paul_ripley]

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

[paul_ripley]

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

[paul_ripley]

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