google spreadsheet sidebar setWidth not working

Question

Anybody else having trouble with the setWidth function? The example here is "300", but if you change the number, the sidebar is the same width. I've tried a few times on a clean spreadsheet.

https://developers.google.com/apps-script/guides/dialogs#custom_sidebars

Unbeknown

lol, i thought i was going crazy – Impend

Answer 1

Google Scripts now ignore the setWidth() method, and the sidebar width is now fixed at 300px. From the release notes:

In Google Docs and Forms, sidebars now ignore the setWidth() method; they cannot be changed from the default width of 300px. This change was applied to the new version of Sheets in the previous week's release.

Homovec

For those who want the exact link to the release developers.google.com/apps-script/releases/… – Billiards

@gingacodemonkey: updated link to the release notes from Feb 2014 (they changed the capitalization of the anchor) – Doronicum

Answer 2

I created a little workaround for this (although this is only useful if this sheet is something you're using for yourself or internally in a company, but not for deployment to other users)...

I created a bookmark containing the following JS, and run it form my favourites bar whenever I want to widen the sidebar (also, any sidebar opened thereafter in that session will open at the new width):

javascript:void(window.top.document.getElementsByClassName("script-application-sidebar")[0].style.width='500px')

To create the bookmark (this example is for Chrome), right click on your favourites bar, click 'Add Page', and paste the above JS into the URL field. Name it whatever you want, e.g. 'Widen Sidebar'. Just click that whenever the sidebar is visible in your Google Sheet.

Bochum

also you can do it with TamperMonkey script: GM_addStyle('div.script-application-sidebar { width: 700px; }'); make sure to add this in header(instead of + is @): // +match docs.google.com/spreadsheets/d* // +grant GM_addStyle – Magee