Steven Zhang stevenqzhang

Updated Specification of Google Spreadsheet: Multiple Hyperlinks to a Cell

Recently, it seems that the specification of Google Spreadsheet was updated. Before this, when a cell has only one hyperlink. In this case, the hyperlink was given to a cell using =HYPERLINK("http://www.google.com/", "Google") as following figure.

But by the recent update, a cell got to be able to have multiple hyperlinks as following figure. In this case, the hyperlinks are set by the RichTextValue object.

[Jasmine][jas] is an excellent framework for JavaScript testing, but I had a tough time coaxing it into cooperation with the Chrome extension I was developing. Jasmine's default testrunner uses an inline script block that listens for window.onload to setup the test environment, but Chrome prohibits extensions from running inline code. Alas, it's not as easy as importing the inline code as a separate file. After a little tinkering, this is what I came up with:

Extension
    ├── html
    ├── js 
    ├── manifest.json
    └── tests
        ├── jasmine
        │   └── lib

│ └── jasmine-1.2.0

	async function getFoo (bar) {
	const baz = 2 * bar;

	const root = await asyncSqrt(baz);

	return 2 * root;
	}

	// Is the same as

	## How to hide API keys from github ##

	1. If you have already pushed commits with sensitive data, follow this guide to remove the sensitive info while
	retaining your commits: https://help.github.com/articles/remove-sensitive-data/

	2. In the terminal, create a config.js file and open it up:

	touch config.js
	atom config.js

	'use strict';

	//npm install gulp gulp-minify-css gulp-uglify gulp-clean gulp-cleanhtml gulp-jshint gulp-strip-debug gulp-zip --save-dev

	var gulp = require('gulp'),
	clean = require('gulp-clean'),
	cleanhtml = require('gulp-cleanhtml'),
	minifycss = require('gulp-minify-css'),
	jshint = require('gulp-jshint'),
	stripdebug = require('gulp-strip-debug'),

	# Note (November 2016):
	# This config is rather outdated and left here for historical reasons, please refer to prerender.io for the latest setup information
	# Serving static html to Googlebot is now considered bad practice as you should be using the escaped fragment crawling protocol

	server {
	listen 80;
	listen [::]:80;
	server_name yourserver.com;

	root /path/to/your/htdocs;

	from sklearn.datasets import load_iris
	from sklearn.ensemble import RandomForestClassifier
	import pandas as pd
	import numpy as np

	iris = load_iris()
	df = pd.DataFrame(iris.data, columns=iris.feature_names)
	df['is_train'] = np.random.uniform(0, 1, len(df)) <= .75
	df['species'] = pd.Factor(iris.target, iris.target_names)
	df.head()