{"id":22,"date":"2019-11-07T15:48:10","date_gmt":"2019-11-07T15:48:10","guid":{"rendered":"http:\/\/blog.rileyjanik.com\/?p=22"},"modified":"2019-12-06T19:34:53","modified_gmt":"2019-12-06T19:34:53","slug":"solved-sharepoint-not-printing-column-formatting-and-colored-overlays","status":"publish","type":"post","link":"https:\/\/blog.rileyjanik.com\/index.php\/2019\/11\/07\/solved-sharepoint-not-printing-column-formatting-and-colored-overlays\/","title":{"rendered":"Solved: SharePoint not printing column formatting and colored overlays"},"content":{"rendered":"\n<p><a href=\"https:\/\/docs.microsoft.com\/en-us\/sharepoint\/dev\/declarative-customization\/column-formatting\">Column formatting<\/a> is one of the greatest and least-known features of a SharePoint list. There is a lot you can do with this handy feature to really make a SharePoint list pop!<\/p>\n\n\n\n<p>Recently, however, I stumbled across what I thought was a limitation of the feature: You can&#8217;t print the formatting! The colored columns show up just fine in the list but when you try to print you get a bland, boring, all-white, Standard SharePoint list. Imagine the frustration of developing custom color-coded columns for a client only to have to explain this limitation. Not cool.<\/p>\n\n\n\n<p>I started researching this topic with little success. I had a hunch that this was related to the CSS <a href=\"https:\/\/www.w3schools.com\/css\/css3_mediaqueries.asp\">print media query<\/a>. Since we&#8217;re using the modern SharePoint experience without the ability to modify CSS, that would have been a big problem.<\/p>\n\n\n\n<p>Thankfully, the answer ended up being an easy to change browser setting! Once I knew what the problem was I was able to locate a number of articles on how to enable the &#8220;print background colors and images&#8221; feature on multiple browsers. Sadly, most of those articles were outdated or just plain wrong. I found an article as recent as September of this year that claimed this feature was unavailable in Chrome. Nonsense!<\/p>\n\n\n\n<p>To enable this feature in chrome, Simply Click on print (Ctrl+P) as you normally would and expand the &#8220;More settings&#8221; section.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" width=\"485\" height=\"437\" src=\"https:\/\/blog.rileyjanik.com\/wp-content\/uploads\/2019\/11\/MoreSettings.png\" alt=\"\" class=\"wp-image-24\" srcset=\"https:\/\/blog.rileyjanik.com\/wp-content\/uploads\/2019\/11\/MoreSettings.png 485w, https:\/\/blog.rileyjanik.com\/wp-content\/uploads\/2019\/11\/MoreSettings-300x270.png 300w\" sizes=\"(max-width: 485px) 85vw, 485px\" \/><\/figure><\/div>\n\n\n\n<p>Next, just make sure to checkmark the &#8220;Background graphics&#8221; box and you should be good to go! Your print preview will reload to show your conditional formatting as you would expect.<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><img loading=\"lazy\" width=\"457\" height=\"471\" src=\"https:\/\/blog.rileyjanik.com\/wp-content\/uploads\/2019\/11\/BGGraphics.png\" alt=\"\" class=\"wp-image-25\" srcset=\"https:\/\/blog.rileyjanik.com\/wp-content\/uploads\/2019\/11\/BGGraphics.png 457w, https:\/\/blog.rileyjanik.com\/wp-content\/uploads\/2019\/11\/BGGraphics-291x300.png 291w\" sizes=\"(max-width: 457px) 85vw, 457px\" \/><\/figure><\/div>\n","protected":false},"excerpt":{"rendered":"<p>Column formatting is one of the greatest and least-known features of a SharePoint list. There is a lot you can do with this handy feature to really make a SharePoint list pop! Recently, however, I stumbled across what I thought was a limitation of the feature: You can&#8217;t print the formatting! The colored columns show &hellip; <a href=\"https:\/\/blog.rileyjanik.com\/index.php\/2019\/11\/07\/solved-sharepoint-not-printing-column-formatting-and-colored-overlays\/\" class=\"more-link\">Continue reading<span class=\"screen-reader-text\"> &#8220;Solved: SharePoint not printing column formatting and colored overlays&#8221;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":23,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[3],"tags":[10,9,8,11],"_links":{"self":[{"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/posts\/22"}],"collection":[{"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/comments?post=22"}],"version-history":[{"count":2,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/posts\/22\/revisions"}],"predecessor-version":[{"id":38,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/posts\/22\/revisions\/38"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/media\/23"}],"wp:attachment":[{"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/media?parent=22"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/categories?post=22"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.rileyjanik.com\/index.php\/wp-json\/wp\/v2\/tags?post=22"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}