InformAction Forums

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:



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.

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.

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?

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?

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

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

Please check latest development build 2.6.8.25rc1, thanks.

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