Google Sheets no longer working, black rectangle, alert dialog

[nmalinoski]

Within the past few days, Google Sheets has become inaccessible. The header, toolbar, and function bar will load, but, instead of the spreadsheet displaying, there's just a small, black rectangle. The following console errors and one warning (the last item) occur, and the site pops an alert that says "A server error occurred. Please press 'Reload' in your browser.":

Code: Select all

Content Security Policy: Couldn’t process unknown directive ‘require-trusted-types-for’  
(unknown)

Content Security Policy: Ignoring “'unsafe-inline'” within script-src: ‘strict-dynamic’ specified  
(unknown)

Content Security Policy: Ignoring “https:” within script-src: ‘strict-dynamic’ specified  
(unknown)

Content Security Policy: Ignoring “http:” within script-src: ‘strict-dynamic’ specified  
(unknown)

NS_ERROR_UNEXPECTED:   
2077684337-waffle_js_prod_core.js:1921

Hitting OK results in another alert dialog that reads "This error has been reported to Google and we'll look into it as soon as possible. Please reload this page to continue.", and triggers these additional errors:

Code: Select all

Content Security Policy: Ignoring ‘x-frame-options’ because of ‘frame-ancestors’ directive.  
(unknown)

Content Security Policy: Couldn’t process unknown directive ‘require-trusted-types-for’  
(unknown)

Content Security Policy: Ignoring “'unsafe-inline'” within script-src: nonce-source or hash-source specified  
(unknown)

Hitting OK again triggers the following warning (first one) and errors, then brings back the initial "A server error occurred. ..." dialog:

Code: Select all

uncaught exception: CustomError: Error in protected function: Class$obf_1037: One of the milestone managers callbacks threw an exception, disabling the manager permanently  
(unknown)
	c https://docs.google.com/static/spreadsheets2/client/js/2077684337-waffle_js_prod_core.js:3364:339

Content Security Policy: Couldn’t process unknown directive ‘require-trusted-types-for’  
(unknown)

Content Security Policy: Ignoring “'unsafe-inline'” within script-src: ‘strict-dynamic’ specified  
(unknown)

Content Security Policy: Ignoring “https:” within script-src: ‘strict-dynamic’ specified  
(unknown)

Content Security Policy: Ignoring “http:” within script-src: ‘strict-dynamic’ specified  
(unknown)

uncaught exception: CustomError: Error in protected function: a.getTransform is not a function  
(unknown)

[FranklinDM]

This is a known issue: see Issue #1810 (UXP).

[adoxa]

Here's a Modify HTTP Response workaround.

Code: Select all

[["/waffle_js_prod_ritzmain\\.js$/",["=a.getTransform(),e=C8g(a,D8g());a.setTransform(d)",",e=C8g(a,D8g())"]]]]

It worked with the sheet I tested, I don't guarantee it will work with all sheets; it may also break after an update.

[Tordenflesk]

Here's a Modify HTTP Response workaround.

Code: Select all

[["/waffle_js_prod_ritzmain\\.js$/",["=a.getTransform(),e=C8g(a,D8g());a.setTransform(d)",",e=C8g(a,D8g())"]]]]

It worked with the sheet I tested, I don't guarantee it will work with all sheets; it may also break after an update.

Attempting this fix in WF Classic gives me this error:

[adoxa]

Oops, sorry.

Code: Select all

[["docs.google.com",["/waffle_js_prod_ritzmain\\.js$/",["=a.getTransform(),e=C8g(a,D8g());a.setTransform(d)",",e=C8g(a,D8g())"]]]]

[Moonchild]

I'm prioritizing this, will tackle Issue #1810 (UXP) in the coming days that should address the getTransform/setTransform issue with a DOMMatrix.

[Tordenflesk]

Oops, sorry.

Code: Select all

[["docs.google.com",["/waffle_js_prod_ritzmain\\.js$/",["=a.getTransform(),e=C8g(a,D8g());a.setTransform(d)",",e=C8g(a,D8g())"]]]]

Didn't do much for me, and no obvious error in the console.

[adoxa]

Still works for me (Basilisk 2024.08.16; test sheet).

[Moonchild]

If they are not using google.com but a localized google domain, then the filter needs to be adjusted.

[thosrtanner]

Just run across this. I see the UXP ticket is marked fixed, which is great, but is there any eta for this being released?

[Nigaikaze]

is there any eta for this being released?

That UXP issue is tagged for 33.4.0, which according to the release engineering page is scheduled to be released on Oct. 8th.

[thosrtanner]

any chance of a patch for 33.3 cos I do occasionally have to use google sheets

[moonbat]

any chance of a patch for 33.3 cos I do occasionally have to use google sheets

Is it that hard to use a different browser in the meantime?