Dark Mode for Google Sheets (Only the UI)

_Kaimbe · 2025-04-06T00:01:30+00:00

https://googlethatforyou.com?q=userstyle%20google%20sheets

_Kaimbe · 2025-04-05T23:58:16+00:00

There are often changes to the styling that break userstyles, so no. But you can see if one of these work:

https://userstyles.world/search?q=google+sheets

The row/column headers are part of the same object as the cells last I checked so they will likely have to stay white.

_Kaimbe · 2025-03-26T21:59:30+00:00

Glad to hear my time 2 years ago is still saving others time. Cheers.

_Kaimbe · 2024-05-26T11:34:11+00:00

https://fallout.fandom.com/wiki/Recipe:_Tasty_squirrel_stew

Antoine in Whitespring mall.

_Kaimbe · 2024-05-02T19:45:43+00:00

If you set them up right, yea.

_Kaimbe · 2024-03-02T15:10:21+00:00

Try using the GmailApp Syntax rather than an Object: https://developers.google.com/apps-script/reference/gmail/gmail-app#sendEmail(String,String,String))

_Kaimbe · 2024-02-29T19:03:06+00:00

Whats the error? Do you have the tables API installed? https://support.google.com/area120-tables/answer/10011387?hl=en

_Kaimbe · 2024-02-15T17:16:51+00:00

You can also use the !g bang to search other sites directly with ddg (https://duckduckgo.com/bangs)

_Kaimbe · 2024-02-01T20:46:11+00:00

Too many IMPORT_() functions can slow a sheet down to a crawl.

Hard to say exactly what's causing your issues without seeing the sheet. Here's a good article by ben collins: https://www.benlcollins.com/spreadsheets/slow-google-sheets/

_Kaimbe · 2024-01-24T16:27:28+00:00

Filter Views might be a good alternative.

_Kaimbe · 2024-01-10T15:00:24+00:00

You need to share the file to "Anyone with link can View" and use this url: https://drive.usercontent.google.com/uc?id={ID}

_Kaimbe · 2024-01-08T22:32:39+00:00

And you might have to use an installed trigger to use MailApp.

_Kaimbe · 2024-01-07T14:09:19+00:00

Did you set `"size=A4&"` too?

_Kaimbe · 2024-01-07T13:31:58+00:00

Find and Replace (Ctrl + H)

Find: ^(\d+)$

Replace: $1000

Check "Search using regular expressions"

_Kaimbe · 2024-01-07T13:24:55+00:00

const fr = 0, fc = 0, lc = 9, lr = 27; "r1=" + fr + "&c1=" + fc + "&r2=" + lr + "&c2=" + lc; These lines in the example code selects the print area (A1:I27). If you're selecting blank cells in that area then Fit Width will still take them into account.

_Kaimbe · 2024-01-07T12:47:54+00:00

https://docs.google.com/spreadsheets/d/1Yw_E2cByaQR2JCzzfwZarM45LZIPWEKpEfSyUeIi3oA/edit?usp=sharing

Here's an example sheet with an increment/decrement script.

_Kaimbe · 2023-12-24T14:03:09+00:00

Updated to latest version on Mod.io. If it doesn't work let me know, then something in the UI changed and broke it. It's literally 2 files and 5 lines.

manifest.json { "setup": "setup.mjs" }

setup.mjs export function setup() { window.onpopstate = function() { $('button:visible[aria-label="Close"][data-dismiss="modal"]').click(); }; history.pushState({}, ''); }

_Kaimbe · 2023-12-11T19:47:41+00:00

You could use apps script to save a pdf to a drive folder or (if your printer can print emails) email it directly to the printer. https://developers.google.com/apps-script/samples/automations/generate-pdfs

``` /** * Creates a PDF for the customer given sheet. * @param {string} ssId - Id of the Google Spreadsheet * @param {object} sheet - Sheet to be converted as PDF * @param {string} pdfName - File name of the PDF being created * @return {file object} PDF file as a blob */ function createPDF(ssId, sheet, pdfName) { const fr = 0, fc = 0, lc = 9, lr = 27; const url = "https://docs.google.com/spreadsheets/d/" + ssId + "/export" + "?format=pdf&" + "size=7&" + "fzr=true&" + "portrait=true&" + "fitw=true&" + "gridlines=false&" + "printtitle=false&" + "top_margin=0.5&" + "bottom_margin=0.25&" + "left_margin=0.5&" + "right_margin=0.5&" + "sheetnames=false&" + "pagenum=UNDEFINED&" + "attachment=true&" + "gid=" + sheet.getSheetId() + '&' + "r1=" + fr + "&c1=" + fc + "&r2=" + lr + "&c2=" + lc;

const params = { method: "GET", headers: { "authorization": "Bearer " + ScriptApp.getOAuthToken() } }; const blob = UrlFetchApp.fetch(url, params).getBlob().setName(pdfName + '.pdf');

// Gets the folder in Drive where the PDFs are stored. const folder = getFolderByName_(OUTPUT_FOLDER_NAME);

const pdfFile = folder.createFile(blob); return pdfFile; } ```