I do the following on a per project basis.
If you don't have virtualenv installed, install it globally by running pip install virtualenv
from any folder. If that didn't work because you have no pip
try pip3 install virtualenv
instead.
.DS_Store | |
node_modules | |
npm-debug.log | |
yarn.lock | |
package.lock |
I do the following on a per project basis.
If you don't have virtualenv installed, install it globally by running pip install virtualenv
from any folder. If that didn't work because you have no pip
try pip3 install virtualenv
instead.
/** | |
* Returns the URL of a hyperlinked cell, if it's entered with hyperlink command. | |
* Supports ranges | |
* @param {A1} reference Cell reference | |
* @customfunction | |
*/ | |
function linkURL(reference) { | |
var sheet = SpreadsheetApp.getActiveSheet(); | |
var formula = SpreadsheetApp.getActiveRange().getFormula(); | |
var args = formula.match(/=\w+\((.*)\)/i); |