Skip to content

Instantly share code, notes, and snippets.

View DarrenCattle's full-sized avatar

Darren Cattle DarrenCattle

View GitHub Profile
var jq = document.createElement('script');
jq.src = '//ajax.googleapis.com/ajax/libs/jquery/1/jquery.min.js';
document.getElementsByTagName('head')[0].appendChild(jq);
var b, engine;
jq.onload = function () {
var ballscript = document.createElement('script');
ballscript.src = 'https://rawgit.com/austinpray/pro-grid-utils/master/ball_mod.js';
document.getElementsByTagName('head')[0].appendChild(ballscript);
ballscript.onload = function () {
b = new ball();
@clupasq
clupasq / subByColor.js
Created September 10, 2013 06:52
SumByColor v1.1 - Added methods for Foreground Color - replaced the deprecated getBackgroundColor() with getBackground()
function getBackgroundColor(rangeSpecification) {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
return sheet.getRange(rangeSpecification).getBackground();
}
function getForegroundColor(rangeSpecification) {
var sheet = SpreadsheetApp.getActiveSpreadsheet();
return sheet.getRange(rangeSpecification).getFontColor();
}