Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi guys
I have created an Nprinting report - Excel. In this report I have created a pivot, which works fine, except for the fact that I'm battling to get the column width a fixed number. I have tried
1. Selecting the range of cells I want to format, right click and then "Set Column width''' to 10
2. Right click on the pivot, again, Pivot Table Options, on the Layout and format tab , UNTICK "Autofit Column Width on Update" and Ticked "Preserve cell formatting on update".
Still everytime I run the report these Pivot's lose their formatting and look really cr@p. I include an image of what the output looks like and how it looks within NPrinting, where I have formatted it.
All help appreciated.
Thanks
Few things:
- Nprinting 17.2 is long out of support. It will be hard to test anything and reflect how it should work on your version. I suggest to upgrade!
- In your template on this page you have other objects as well. If they have “keep source format” ticked they could effect column with and not your pivot table.
other than that. I will try to replicate it in my environment and we will see how it goes.
cheers
Hello Lech,
thank you for your reply. Sorry - my mistake, we're on April 2019 version of Nprinting. My bad.
I will have a look and see if any of the other objects have a 'Keep Format' option, thank you.
Much appreciated.