Pretty much all queries start off as:
SpreadsheetApp.getActiveSheet()
getRange(row, column, numRows, numColumns)
Rupert Manfredi rupertsworld
rupertsworld
/ sheets-apps-script-api.md
Created
April 21, 2021 12:48
Notes on the Google Sheets Apps Script API
rupertsworld
/ one-char-string-match.js
Created
December 3, 2018 05:56
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| const strings = [ | |
| 'abcde', | |
| 'fghij', | |
| 'klmnop', | |
| 'klnmpo', | |
| 'axcde' | |
| ]; | |
| const strlen = strings[0].length; |
rupertsworld
/ Simplified Docs (for Stylus)
Last active
November 25, 2018 01:54
A simplified interface for Google Docs with lots of whitespace and a focus on content. For use with the Stylus Chrome plugin.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .docs-material #docs-toolbar-wrapper { | |
| border: none; | |
| box-shadow: none; | |
| } | |
| .docs-material .goog-toolbar-separator.goog-inline-block { | |
| visibility: hidden; | |
| } | |
| .navigation-widget-hat { |
rupertsworld
/ compress-toolbar.css
Created
August 23, 2017 05:02
Compress top toolbar for CodeAnywhere (Stylish CSS)
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| .splitter-strech.region-north.layout-fit { | |
| bottom: calc(100% - 29px) !important; | |
| } | |
| .splitter-strech.region-north.layout-fit > .vbox > div + div { | |
| height: 26px !important; | |
| top: -30px !important; | |
| position: relative !important; | |
| left: 40% !important; | |
| } |