Repositories list

• lookup-reference

  Public archive
  All lookup and reference functions.

  JavaScript

  •1•0•0•1•Updated Aug 28, 2017Aug 28, 2017

• find

  Public
  FIND(find_text, within_text, position)

  JavaScript

  •0•0•0•0•Updated Nov 4, 2015Nov 4, 2015

• upper

  Public
  UPPER(string)

  JavaScript

  •0•0•0•0•Updated Nov 4, 2015Nov 4, 2015

• lower

  Public
  LOWER(string)

  JavaScript

  •0•1•0•0•Updated Nov 4, 2015Nov 4, 2015

• filter

  Public
  FILTER(range, ...filters)

  JavaScript

  •0•0•0•0•Updated Nov 4, 2015Nov 4, 2015

• sort

  Public
  SORT(ref, ...criteria)

  JavaScript

  •0•0•0•0•Updated Nov 4, 2015Nov 4, 2015

• oct2dec

  Public
  OCT2DEC(octalNumber)

  JavaScript

  •1•0•0•0•Updated Oct 27, 2015Oct 27, 2015

• range

  Public
  Represent a range in a sheet

  JavaScript

  •0•0•0•0•Updated Oct 23, 2015Oct 23, 2015

• indirect

  Public
  Returns an cell indirection

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• constants

  Public
  Spreadsheet constants

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• rept

  Public
  Repeat a string a given number of times

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• date

  Public
  DATE(year, month, day)

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• acos

  Public
  ACOS(value)

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• cos

  Public
  COS(value)

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• sin

  Public
  SIN(value)

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• tan

  Public
  TAN(value)

  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• index2row

  Public
  JavaScript

  •0•0•0•0•Updated Oct 22, 2015Oct 22, 2015

• cond

  Public
  COND(...cases) - Like switch case without strange behavior

  JavaScript

  •0•0•0•0•Updated Oct 21, 2015Oct 21, 2015

• ne

  Public
  NE(a, b)

  JavaScript

  •0•0•0•0•Updated Oct 21, 2015Oct 21, 2015

• bin2dec

  Public
  BIN2DEC(value) - Convert a binary string into a number

  JavaScript

  •0•0•0•0•Updated Oct 21, 2015Oct 21, 2015

• address

  Public
  Convert row and column to spreadsheet address

  JavaScript

  •0•0•0•0•Updated Oct 21, 2015Oct 21, 2015

• eq

  Public
  Equal function

  JavaScript

  •0•0•0•0•Updated Oct 20, 2015Oct 20, 2015

• and

  Public
  AND function

  JavaScript

  •

  MIT License

  •0•0•0•0•Updated Oct 20, 2015Oct 20, 2015

• isarray

  Public
  Checks if value is an array.

  JavaScript

  •0•0•0•0•Updated Oct 20, 2015Oct 20, 2015

• isFunction

  Public
  A function to check if a value is a ISFUNCTION

  JavaScript

  •0•0•0•0•Updated Oct 16, 2015Oct 16, 2015

• isref

  Public
  Checks if a value is a valid reference

  JavaScript

  •0•0•0•0•Updated Oct 10, 2015Oct 10, 2015

• cell

  Public
  Represents a cell in a sheet

  JavaScript

  •0•0•0•0•Updated Oct 10, 2015Oct 10, 2015

• index2col

  Public
  JavaScript

  •0•0•0•0•Updated Oct 10, 2015Oct 10, 2015

• address-system

  Public
  The core address system functions

  JavaScript

  •0•1•0•0•Updated Oct 9, 2015Oct 9, 2015

• cellindex

  Public
  JavaScript

  •0•0•0•0•Updated Oct 9, 2015Oct 9, 2015