Can't resize columns in new Google Sheets

Ask for help about NoScript, no registration needed to post
bobbybrown

Can't resize columns in new Google Sheets

Post by bobbybrown »

I cannot drag and resize rows and columns in the new version of Google Sheets (that with a green checkmark in the bottom). I can drag borders between columns, but changes don't keep:

Image

Firefox 28.0, NoScript 2.6.8.24. I am certain the issue stems from NoScript. The bug disappears in browser's safe mode or with only NoScript extension fully disabled, but it remains if I Allow Scripts Globally. I have google-analytics.com blocked, but nothing changes if I white-list it (all the other scripts for Google Sheets are already whitelisted). I have all notifications enabled, and none appear when I load a spreadsheet or try to resize borders. Nothing NoScript related in browser console either.

I can see network exchanges in browser console when I drag borders, and if I reload the page the changes are retained and displayed properly, but not until then.

Don't know if it's a recent issue, I have barely used new Google Sheets since their introduction half a year ago, but I don't recall having such issues when I tried new Sheets several months ago.
Mozilla/5.0 (Windows NT 6.1; rv:28.0) Gecko/20100101 Firefox/28.0
onetimer

Re: Can't resize columns in new Google Sheets

Post by onetimer »

Confirmation / modification:

I see the same behavior, in the same situation: everything allowed except google-analytics.

In addition, I cannot add or delete rows, with a number of methods, including the Sheets menu, right-click context menu, and "add rows" form below the sheet.

Note: the actions actually take place immediately, as seen immediately in another browser, or by fully reloading the page. So the display diverges from the stored data, which is of course a completely blocking issue.

Major difference from above: Temporarily allowing google-analytics fixes the problem immediately. I can flip the problem on and off, as the inverse of google-analytics permission.
Mozilla/5.0 (Macintosh; Intel Mac OS X 10.9; rv:29.0) Gecko/20100101 Firefox/29.0
bobbybrown

Re: Can't resize columns in new Google Sheets

Post by bobbybrown »

onetimer wrote:Major difference from above: Temporarily allowing google-analytics fixes the problem immediately. I can flip the problem on and off, as the inverse of google-analytics permission.
It seems like I didn't reload the page after granting permission to google-analytics, I can confirm all what you've said. Allowing google-analytics fixes this issue, and disallowing it prevents me also from manipulating rows.

Still, it doesn't look like a normal behavior to me. It's a major tracking server, ubiquitous on the web and thus fully deserving to be blocked, and I'm positive that none of google drive apps depended on google-analytics before. I have several spreadsheets in the old version of Google Sheets, and they work perfectly with g-a blocked.

So, is there a chance that it's not an intented behavior and is caused by undesirable side effects of NoScript blocking g-a?
Mozilla/5.0 (Windows NT 6.1; rv:28.0) Gecko/20100101 Firefox/28.0
barbaz
Senior Member
Posts: 11163
Joined: Sat Aug 03, 2013 5:45 pm

Re: Can't resize columns in new Google Sheets

Post by barbaz »

bobbybrown wrote:So, is there a chance that it's not an intented behavior and is caused by undesirable side effects of NoScript blocking g-a?
NoScript is supposed to provide a surrogate script for ga so that when ga is not Allowed, pages don't break like that.

Does this also happen with NoScript 2.6.8.23?
*Always* check the changelogs BEFORE updating that important software!
Mozilla/5.0 (X11; Linux i686; rv:32.0) Gecko/20100101 Firefox/32.0 SeaMonkey/2.29a1
bobbybrown

Re: Can't resize columns in new Google Sheets

Post by bobbybrown »

barbaz wrote:Does this also happen with NoScript 2.6.8.23?
It doesn't! Just reverted to 2.6.8.23, g-a is still in Untrusted, my spreadsheet works fine. I went on AMO and tried out severa latest builds:

2.6.8.24rc2 - ok
2.6.8.24rc3 - ok
2.6.8.24rc4 - fail
2.6.8.24rc5 - fail

Looks like this change in rc4 is at fault:
x [Surrogate] Improved google-analytics.com (ga) surrogate
Mozilla/5.0 (Windows NT 6.1; rv:28.0) Gecko/20100101 Firefox/28.0
barbaz
Senior Member
Posts: 11163
Joined: Sat Aug 03, 2013 5:45 pm

Re: Can't resize columns in new Google Sheets

Post by barbaz »

as a temporary workaround you could try copying the value of about:config -> noscript.surrogate.ga.replacement from noscript 2.6.8.23 and putting that in for the same pref on 2.6.8.24
*Always* check the changelogs BEFORE updating that important software!
Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:29.0) Gecko/20100101 Firefox/29.0 SeaMonkey/2.26
User avatar
Giorgio Maone
Site Admin
Posts: 9557
Joined: Wed Mar 18, 2009 11:22 pm
Location: Palermo - Italy
Contact:

Re: Can't resize columns in new Google Sheets

Post by Giorgio Maone »

Please check latest development build 2.6.8.25rc1, thanks.
Mozilla/5.0 (Windows NT 6.1; WOW64; rv:29.0) Gecko/20100101 Firefox/29.0
bobbybrown

Re: Can't resize columns in new Google Sheets

Post by bobbybrown »

2.6.8.25rc1 - sheets work as intended. Thanks for a swift response!

(btw, it's not that important at all, but mine and Luigi's names got a little mixed up in the credits. :) )
Mozilla/5.0 (Windows NT 6.1; rv:28.0) Gecko/20100101 Firefox/28.0
Post Reply