{"id":1511,"date":"2018-04-29T09:10:16","date_gmt":"2018-04-29T14:10:16","guid":{"rendered":"http:\/\/www.familytidings.com\/blog\/?p=1511"},"modified":"2018-04-29T09:10:16","modified_gmt":"2018-04-29T14:10:16","slug":"copypaste-broken-in-google-sheets","status":"publish","type":"post","link":"https:\/\/www.familytidings.com\/blog\/?p=1511","title":{"rendered":"Copy+Paste Broken in Google Sheets"},"content":{"rendered":"<p>This had nothing to do with Google Sheets itself, but rather an extension I use called <a href=\"https:\/\/github.com\/jswanner\/DontFuckWithPaste\">Don&#8217;t Fuck with Paste<\/a>. This extension disables copy and paste blocking.\u00c2\u00a0 The extension had a major upgrade a couple months ago that enabled the extension only for sites added to a blacklist.\u00c2\u00a0 The blacklist supports regular expressions to match URLs.\u00c2\u00a0 Unfortunately, a blank expression matches everything and somehow a blank RegEx was in the blacklist&#8211;I don&#8217;t know if this is the default for the extension or if I did it by mistake and I haven&#8217;t tried to find out.\u00c2\u00a0 You can tell if the extension is active for a site if the extension&#8217;s icon is blue rather than grey.\u00c2\u00a0 You can tell if a blank RegEx is in the list by clicking on the icon and looking if there&#8217;s a cancel button next to a blank line:<\/p>\n<p><a href=\"http:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/blank-regex-4.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1519\" src=\"http:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/blank-regex-4.png\" alt=\"\" width=\"564\" height=\"112\" srcset=\"https:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/blank-regex-4.png 564w, https:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/blank-regex-4-300x60.png 300w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n<p>instead of this (the URL displayed will be the one displayed in the current browser tab, but the important thing is that there&#8217;s no X next to it):<\/p>\n<p><a href=\"http:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/no-regex.png\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-1516\" src=\"http:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/no-regex.png\" alt=\"\" width=\"558\" height=\"98\" srcset=\"https:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/no-regex.png 558w, https:\/\/www.familytidings.com\/blog\/wp-content\/uploads\/2018\/04\/no-regex-300x53.png 300w\" sizes=\"auto, (max-width: 558px) 100vw, 558px\" \/><\/a><\/p>\n<p>Clicking the X removed the blank RegEx and turned the extension off for all sites by default, thus fixing Google Sheets.<\/p>\n<h1>On finding extension problems<\/h1>\n<p>When something goofy is broken, the first thing to do is to browse to the site with an Incognito window, which turns off all extensions.\u00c2\u00a0 If the site works in Incognito mode, the problem is due to an extension.\u00c2\u00a0 The next step is to figure out which extension is breaking things.\u00c2\u00a0 If you don&#8217;t have an idea of which extension might be the problem, a binary search is the fastest way:\u00c2\u00a0 Disable the first half of all extensions, reload the page and see if it works.\u00c2\u00a0 If not, re-enable the first half, then disable the second half.\u00c2\u00a0 Keep splitting the groups in half until you find the extension at fault.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>This had nothing to do with Google Sheets itself, but rather an extension I use called Don&#8217;t Fuck with Paste. This extension disables copy and paste blocking.\u00c2\u00a0 The extension had a major upgrade a couple months ago that enabled the extension only for sites added to a blacklist.\u00c2\u00a0 The blacklist supports regular expressions to match [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1511","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1511","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1511"}],"version-history":[{"count":2,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1511\/revisions"}],"predecessor-version":[{"id":1520,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/1511\/revisions\/1520"}],"wp:attachment":[{"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1511"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1511"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.familytidings.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1511"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}