functionfoundry
Advanced tools
Comparing version 0.6.13 to 0.7.0
@@ -16,3 +16,3 @@ var gulp = require('gulp'), | ||
.pipe(tape({ | ||
reporter: tapColorize() | ||
// reporter: tapColorize() | ||
})); | ||
@@ -22,3 +22,3 @@ }); | ||
gulp.task('watch', ['build'], function () { | ||
gulp.watch('src/*.js', ['build', 'test']) | ||
gulp.watch('src/*.js', ['build']) | ||
}); |
113
lib/index.js
@@ -6,3 +6,2 @@ 'use strict'; | ||
}); | ||
exports.functions = exports.engineeringFunctions = exports.textFunctions = exports.statisticFunctions = exports.financialFunctions = exports.dateTimeFunctions = exports.mathFunctions = exports.dataFunctions = exports.referenceFunctions = exports.informationFunctions = exports.logicalFunctions = exports.VLOOKUP = exports.UPPER = exports.UNIQUE = exports.TEXT = exports.TAU = exports.TAN = exports.SWITCH = exports.SUM = exports.SORT = exports.SIN = exports.SEARCH = exports.REPT = exports.RANGE = exports.POWER = exports.PMT = exports.PI = exports.OR = exports.OCT2DEC = exports.NOT = exports.NE = exports.N = exports.MULTIPLY = exports.MAX = exports.LTE = exports.LT = exports.LOWER = exports.LOOKUP = exports.ISURL = exports.ISTEXT = exports.ISREF = exports.ISRANGE = exports.ISODD = exports.ISNUMBER = exports.ISNA = exports.ISEVEN = exports.ISERROR = exports.ISEMAIL = exports.ISBLANK = exports.ISARRAY = exports.INDIRECT = exports.INDEX2ROW = exports.INDEX2COL = exports.IN = exports.IFNA = exports.HLOOKUP = exports.GUID = exports.GTE = exports.GT = exports.FLATTEN = exports.FIND = exports.FILTER = exports.EQ = exports.DIVIDE = exports.DEC2BIN = exports.DATEDIF = exports.DATE = exports.COS = exports.COND = exports.CONCATENATE = exports.CLEAN = exports.CHOOSE = exports.CELLINDEX = exports.CELL = exports.BIN2DEC = exports.AND = exports.ADD = exports.ACOS = exports.ABS = undefined; | ||
@@ -72,2 +71,11 @@ var _ABS = require('./ABS'); | ||
var _CHANGED = require('./CHANGED'); | ||
Object.defineProperty(exports, 'CHANGED', { | ||
enumerable: true, | ||
get: function get() { | ||
return _CHANGED.CHANGED; | ||
} | ||
}); | ||
var _CHOOSE = require('./CHOOSE'); | ||
@@ -145,2 +153,11 @@ | ||
var _DIFF = require('./DIFF'); | ||
Object.defineProperty(exports, 'DIFF', { | ||
enumerable: true, | ||
get: function get() { | ||
return _DIFF.DIFF; | ||
} | ||
}); | ||
var _DIVIDE = require('./DIVIDE'); | ||
@@ -621,94 +638,2 @@ | ||
} | ||
}); | ||
var logicalFunctions = exports.logicalFunctions = ['if', 'ifna', 'iferror', 'and', 'eq', 'or', 'xor', 'not', 'lt', 'lte', 'gt', 'gte', 'ne', 'switch', 'choose', 'cond']; | ||
var informationFunctions = exports.informationFunctions = ['isarray', 'isblank', 'isemail', 'iserror', 'iseven', 'isformula', 'islogical', 'isna', 'isnontext', 'isnumber', 'isodd', 'istext', 'isrange', 'isref', 'isurl', 'n', 'na', 'precedents', 'sheet', 'sheets', 'type']; | ||
var referenceFunctions = exports.referenceFunctions = ['indirect', 'isref', 'rows', 'columns', 'range', 'cell', 'cellindex', 'index2addr', 'index2col', 'index2row']; | ||
var dataFunctions = exports.dataFunctions = ['clean', 'sort', 'filter', 'unique']; | ||
var mathFunctions = exports.mathFunctions = ['abs', 'acos', 'acosh', 'acot', 'acoth', 'add', 'aggregate', 'arabic', 'asin', 'asinh', 'atan', 'atan2', 'atanh', 'base', 'ceiling', 'combin', 'combina', 'cos', 'cosh', 'cot', 'coth', 'csc', 'csch', 'decimal', 'degrees', 'divide', 'even', 'exp', 'fact', 'factdouble', 'floor', 'gcd', 'gt', 'gte', 'int', 'lcm', 'log', 'log10', 'lt', 'lte', 'mdeterm', 'minus', 'minverse', 'mmult', 'mod', 'mround', 'multinomial', 'multiply', 'odd', 'pi', 'tau', 'power', 'product', 'quotient', 'radians', 'rand', 'randbetween', 'roman', 'round', 'rounddown', 'roundup', 'sec', 'sech', 'seriessum', 'sign', 'sin', 'sqrt', 'sqrtpi', 'subtotal', 'sum', 'tan']; | ||
var dateTimeFunctions = exports.dateTimeFunctions = ['date', 'datevalue', 'datedif', 'day', 'days360', 'edate', 'eomonth', 'hour', 'isleapyear', 'isoweeknum', 'minute', 'month', 'networkdays', 'now', 'second', 'time', 'timevalue', 'today', 'weekday', 'weeknum', 'workday', 'year', 'yearfrac']; | ||
var financialFunctions = exports.financialFunctions = ['accrintm', 'amorlinc', 'coupdays', 'coupdaysnc', 'coupncd', 'coupnum', 'couppcd', 'cumipmt', 'cumprinc', 'db', 'ddb', 'disc', 'dollarde', 'dollarfr', 'duration', 'effect', 'fv', 'fvschedule', 'intrate', 'irr', 'ipmt', 'mduration', 'mirr', 'nominal', 'nper', 'npv', 'oddfprice', 'oddfyield', 'pmt', 'pv']; | ||
var statisticFunctions = exports.statisticFunctions = ['avedev', 'average', 'averagea', 'averageif', 'averageifs', 'correl', 'count', 'counta', 'countin', 'countblank', 'countif', 'countifs', 'countunique', 'devsq', 'fisher', 'fisherinv', 'forecast', 'frequency', 'gammaln', 'geomean', 'growth', 'harmean', 'intercept', 'kurt', 'large', 'linest', 'logest', 'max', 'maxa', 'median', 'min', 'mina', 'pearson', 'permut', 'permutationa', 'phi', 'prob', 'rsq', 'skew', 'slope', 'small', 'standardize', 'stdeva', 'stdevpa', 'steyx', 'transpose', 'trend', 'trimmean', 'vara', 'varpa']; | ||
var textFunctions = exports.textFunctions = ['asc', 'bahttext', 'clean', 'char', 'code', 'concatenate', 'dbcs', 'dollar', 'exact', 'find', 'fixed', 'left', 'len', 'lower', 'join', 'mid', 'numbervalue', 'pronetic', 'proper', 'replace', 'rept', 'right', 'search', 'split', 'substitute', 't', 'text', 'trim', 'upper', 'value']; | ||
var engineeringFunctions = exports.engineeringFunctions = ['besseli', 'besselj', 'besselk', 'bessely', 'bin2dec', 'bin2hex', 'bin2oct', 'bitand', 'bitlshift', 'bitor', 'bitrshift', 'bitxor', 'complex', 'convert', 'dec2bin', 'dec2hex', 'dec2oct', 'delta', 'erf', 'erfc', 'gestep', 'hex2bin', 'hex2dec', 'hex2oct', 'imabs', 'imaginary', 'imargument', 'imconjugate', 'imcos', 'imcosh', 'imcot', 'imdiv', 'imexp', 'imln', 'imlog19', 'imlog2', 'impower', 'improduct', 'imreal', 'imsec', 'imsech', 'imsin', 'imsinh', 'imsqrt', 'imcsc', 'imcsch', 'imsub', 'imtan', 'oct2bin', 'oct2dec', 'oct2hex']; | ||
var functions = exports.functions = (0, _FLATTEN.FLATTEN)([logicalFunctions, informationFunctions, referenceFunctions, dataFunctions, mathFunctions, dateTimeFunctions, financialFunctions, statisticFunctions, textFunctions, engineeringFunctions]).sort(); | ||
exports.default = { | ||
ABS: _ABS.ABS, | ||
ACOS: _ACOS.ACOS, | ||
ADD: _ADD.ADD, | ||
AND: _AND.AND, | ||
BIN2DEC: _BIN2DEC.BIN2DEC, | ||
CELL: _CELL.CELL, | ||
CELLINDEX: _CELLINDEX.CELLINDEX, | ||
CHOOSE: _CHOOSE.CHOOSE, | ||
CLEAN: _CLEAN.CLEAN, | ||
CONCATENATE: _CONCATENATE.CONCATENATE, | ||
COND: _COND.COND, | ||
COS: _COS.COS, | ||
DATE: _DATE.DATE, | ||
DATEDIF: _DATEDIF.DATEDIF, | ||
DEC2BIN: _DEC2BIN.DEC2BIN, | ||
DIVIDE: _DIVIDE.DIVIDE, | ||
EQ: _EQ.EQ, | ||
FILTER: _FILTER.FILTER, | ||
FIND: _FIND.FIND, | ||
FLATTEN: _FLATTEN.FLATTEN, | ||
GT: _GT.GT, | ||
GTE: _GTE.GTE, | ||
GUID: _GUID.GUID, | ||
HLOOKUP: _HLOOKUP.HLOOKUP, | ||
IFNA: _IFNA.IFNA, | ||
IN: _IN.IN, | ||
INDEX2COL: _INDEX2COL.INDEX2COL, | ||
INDEX2ROW: _INDEX2ROW.INDEX2ROW, | ||
INDIRECT: _INDIRECT.INDIRECT, | ||
ISARRAY: _ISARRAY.ISARRAY, | ||
ISBLANK: _ISBLANK.ISBLANK, | ||
ISEMAIL: _ISEMAIL.ISEMAIL, | ||
ISERROR: _ISERROR.ISERROR, | ||
ISEVEN: _ISEVEN.ISEVEN, | ||
ISNA: _ISNA.ISNA, | ||
ISNUMBER: _ISNUMBER.ISNUMBER, | ||
ISODD: _ISODD.ISODD, | ||
ISRANGE: _ISRANGE.ISRANGE, | ||
ISREF: _ISREF.ISREF, | ||
ISTEXT: _ISTEXT.ISTEXT, | ||
ISURL: _ISURL.ISURL, | ||
LOOKUP: _LOOKUP.LOOKUP, | ||
LOWER: _LOWER.LOWER, | ||
LT: _LT.LT, | ||
LTE: _LTE.LTE, | ||
MAX: _MAX.MAX, | ||
MULTIPLY: _MULTIPLY.MULTIPLY, | ||
N: _N.N, | ||
NE: _NE.NE, | ||
NOT: _NOT.NOT, | ||
OCT2DEC: _OCT2DEC.OCT2DEC, | ||
OR: _OR.OR, | ||
PI: _PI.PI, | ||
PMT: _PMT.PMT, | ||
POWER: _POWER.POWER, | ||
RANGE: _RANGE.RANGE, | ||
REPT: _REPT.REPT, | ||
SEARCH: _SEARCH.SEARCH, | ||
SIN: _SIN.SIN, | ||
SORT: _SORT.SORT, | ||
SUM: _SUM.SUM, | ||
SWITCH: _SWITCH.SWITCH, | ||
TAN: _TAN.TAN, | ||
TAU: _TAU.TAU, | ||
TEXT: _TEXT.TEXT, | ||
UNIQUE: _UNIQUE.UNIQUE, | ||
UPPER: _UPPER.UPPER, | ||
VLOOKUP: _VLOOKUP.VLOOKUP | ||
}; | ||
}); |
"use strict"; | ||
Object.defineProperty(exports, "__esModule", { | ||
value: true | ||
value: true | ||
}); | ||
exports.ISEMAIL = ISEMAIL; | ||
function ISEMAIL(email) { | ||
var re = /^([\w-]+(?:\.[\w-]+)*)@((?:[\w-]+\.)*\w[\w-]{0,66})\.([a-z]{2,6}(?:\.[a-z]{2})?)$/i; | ||
return re.test(email); | ||
// credit to http://stackoverflow.com/questions/46155/validate-email-address-in-javascript | ||
var re = /^(([^<>()[\]\\.,;:\s@"]+(\.[^<>()[\]\\.,;:\s@"]+)*)|(".+"))@((\[[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}\.[0-9]{1,3}])|(([a-zA-Z\-0-9]+\.)+[a-zA-Z]{2,}))$/; | ||
return re.test(email); | ||
}; |
{ | ||
"name": "functionfoundry", | ||
"version": "0.6.13", | ||
"description": "Functions inspired by the spreadsheets", | ||
"version": "0.7.0", | ||
"description": "Modern JavaScript inspired by spreadsheets", | ||
"main": "lib/index.js", | ||
@@ -9,3 +9,3 @@ "jsnext:main": "src/index.js", | ||
"test": "gulp test", | ||
"build": "gulp build" | ||
"build": "gulp build && browserify -g uglifyify ./lib/browserify.js > dist/functionfoundry.js" | ||
}, | ||
@@ -31,2 +31,3 @@ "repository": { | ||
"babel-preset-es2015": "^6.1.2", | ||
"browserify": "^13.0.0", | ||
"eslint": "^1.8.0", | ||
@@ -36,6 +37,6 @@ "gulp": "^3.9.0", | ||
"gulp-tape": "0.0.5", | ||
"gulp-uglify": "^1.5.1", | ||
"tap-colorize": "^1.2.0", | ||
"tape": "^4.2.2" | ||
}, | ||
"dependencies": {} | ||
} | ||
} |
@@ -11,6 +11,7 @@ # functionfoundry | ||
| ------------- | ----------- | | ||
|src| Original JavaScript 2015 source code| | ||
|lib| CommonJS code created by Babel compiler| | ||
|test| Tests using the substack/tape framework| | ||
|src| Original JavaScript 2015 source code | | ||
|lib| CommonJS code created by Babel compiler | | ||
|test| Tests using the substack/tape framework | | ||
|dist| Holds bundle for browsers. Namespace is FunctionFoundry. | | ||
If you want to learn how the function behave then please read the tests. |
491
src/index.js
@@ -8,2 +8,3 @@ export {ABS} from './ABS' | ||
export {CELLINDEX} from './CELLINDEX' | ||
export {CHANGED} from './CHANGED' | ||
export {CHOOSE} from './CHOOSE' | ||
@@ -17,2 +18,3 @@ export {CLEAN} from './CLEAN' | ||
export {DEC2BIN} from './DEC2BIN' | ||
export {DIFF} from './DIFF' | ||
export {DIVIDE} from './DIVIDE' | ||
@@ -71,490 +73,1 @@ export {EQ} from './EQ' | ||
export {VLOOKUP} from './VLOOKUP' | ||
export let logicalFunctions = [ | ||
'if', | ||
'ifna', | ||
'iferror', | ||
'and', | ||
'eq', | ||
'or', | ||
'xor', | ||
'not', | ||
'lt', | ||
'lte', | ||
'gt', | ||
'gte', | ||
'ne', | ||
'switch', | ||
'choose', | ||
'cond' | ||
]; | ||
export let informationFunctions = [ | ||
'isarray', | ||
'isblank', | ||
'isemail', | ||
'iserror', | ||
'iseven', | ||
'isformula', | ||
'islogical', | ||
'isna', | ||
'isnontext', | ||
'isnumber', | ||
'isodd', | ||
'istext', | ||
'isrange', | ||
'isref', | ||
'isurl', | ||
'n', | ||
'na', | ||
'precedents', | ||
'sheet', | ||
'sheets', | ||
'type' | ||
] | ||
export let referenceFunctions = [ | ||
'indirect', | ||
'isref', | ||
'rows', | ||
'columns', | ||
'range', | ||
'cell', | ||
'cellindex', | ||
'index2addr', | ||
'index2col', | ||
'index2row', | ||
]; | ||
export let dataFunctions = [ | ||
'clean', | ||
'sort', | ||
'filter', | ||
'unique', | ||
]; | ||
export let mathFunctions = [ | ||
'abs', | ||
'acos', | ||
'acosh', | ||
'acot', | ||
'acoth', | ||
'add', | ||
'aggregate', | ||
'arabic', | ||
'asin', | ||
'asinh', | ||
'atan', | ||
'atan2', | ||
'atanh', | ||
'base', | ||
'ceiling', | ||
'combin', | ||
'combina', | ||
'cos', | ||
'cosh', | ||
'cot', | ||
'coth', | ||
'csc', | ||
'csch', | ||
'decimal', | ||
'degrees', | ||
'divide', | ||
'even', | ||
'exp', | ||
'fact', | ||
'factdouble', | ||
'floor', | ||
'gcd', | ||
'gt', | ||
'gte', | ||
'int', | ||
'lcm', | ||
'log', | ||
'log10', | ||
'lt', | ||
'lte', | ||
'mdeterm', | ||
'minus', | ||
'minverse', | ||
'mmult', | ||
'mod', | ||
'mround', | ||
'multinomial', | ||
'multiply', | ||
'odd', | ||
'pi', | ||
'tau', | ||
'power', | ||
'product', | ||
'quotient', | ||
'radians', | ||
'rand', | ||
'randbetween', | ||
'roman', | ||
'round', | ||
'rounddown', | ||
'roundup', | ||
'sec', | ||
'sech', | ||
'seriessum', | ||
'sign', | ||
'sin', | ||
'sqrt', | ||
'sqrtpi', | ||
'subtotal', | ||
'sum', | ||
'tan', | ||
]; | ||
export let dateTimeFunctions = [ | ||
'date', | ||
'datevalue', | ||
'datedif', | ||
'day', | ||
'days360', | ||
'edate', | ||
'eomonth', | ||
'hour', | ||
'isleapyear', | ||
'isoweeknum', | ||
'minute', | ||
'month', | ||
'networkdays', | ||
'now', | ||
'second', | ||
'time', | ||
'timevalue', | ||
'today', | ||
'weekday', | ||
'weeknum', | ||
'workday', | ||
'year', | ||
'yearfrac', | ||
]; | ||
export let financialFunctions = [ | ||
'accrintm', | ||
'amorlinc', | ||
'coupdays', | ||
'coupdaysnc', | ||
'coupncd', | ||
'coupnum', | ||
'couppcd', | ||
'cumipmt', | ||
'cumprinc', | ||
'db', | ||
'ddb', | ||
'disc', | ||
'dollarde', | ||
'dollarfr', | ||
'duration', | ||
'effect', | ||
'fv', | ||
'fvschedule', | ||
'intrate', | ||
'irr', | ||
'ipmt', | ||
'mduration', | ||
'mirr', | ||
'nominal', | ||
'nper', | ||
'npv', | ||
'oddfprice', | ||
'oddfyield', | ||
'pmt', | ||
'pv', | ||
]; | ||
export let statisticFunctions = [ | ||
'avedev', | ||
'average', | ||
'averagea', | ||
'averageif', | ||
'averageifs', | ||
'correl', | ||
'count', | ||
'counta', | ||
'countin', | ||
'countblank', | ||
'countif', | ||
'countifs', | ||
'countunique', | ||
'devsq', | ||
'fisher', | ||
'fisherinv', | ||
'forecast', | ||
'frequency', | ||
'gammaln', | ||
'geomean', | ||
'growth', | ||
'harmean', | ||
'intercept', | ||
'kurt', | ||
'large', | ||
'linest', | ||
'logest', | ||
'max', | ||
'maxa', | ||
'median', | ||
'min', | ||
'mina', | ||
'pearson', | ||
'permut', | ||
'permutationa', | ||
'phi', | ||
'prob', | ||
'rsq', | ||
'skew', | ||
'slope', | ||
'small', | ||
'standardize', | ||
'stdeva', | ||
'stdevpa', | ||
'steyx', | ||
'transpose', | ||
'trend', | ||
'trimmean', | ||
'vara', | ||
'varpa', | ||
]; | ||
export let textFunctions = [ | ||
'asc', | ||
'bahttext', | ||
'clean', | ||
'char', | ||
'code', | ||
'concatenate', | ||
'dbcs', | ||
'dollar', | ||
'exact', | ||
'find', | ||
'fixed', | ||
'left', | ||
'len', | ||
'lower', | ||
'join', | ||
'mid', | ||
'numbervalue', | ||
'pronetic', | ||
'proper', | ||
'replace', | ||
'rept', | ||
'right', | ||
'search', | ||
'split', | ||
'substitute', | ||
't', | ||
'text', | ||
'trim', | ||
'upper', | ||
'value', | ||
]; | ||
export let engineeringFunctions = [ | ||
'besseli', | ||
'besselj', | ||
'besselk', | ||
'bessely', | ||
'bin2dec', | ||
'bin2hex', | ||
'bin2oct', | ||
'bitand', | ||
'bitlshift', | ||
'bitor', | ||
'bitrshift', | ||
'bitxor', | ||
'complex', | ||
'convert', | ||
'dec2bin', | ||
'dec2hex', | ||
'dec2oct', | ||
'delta', | ||
'erf', | ||
'erfc', | ||
'gestep', | ||
'hex2bin', | ||
'hex2dec', | ||
'hex2oct', | ||
'imabs', | ||
'imaginary', | ||
'imargument', | ||
'imconjugate', | ||
'imcos', | ||
'imcosh', | ||
'imcot', | ||
'imdiv', | ||
'imexp', | ||
'imln', | ||
'imlog19', | ||
'imlog2', | ||
'impower', | ||
'improduct', | ||
'imreal', | ||
'imsec', | ||
'imsech', | ||
'imsin', | ||
'imsinh', | ||
'imsqrt', | ||
'imcsc', | ||
'imcsch', | ||
'imsub', | ||
'imtan', | ||
'oct2bin', | ||
'oct2dec', | ||
'oct2hex' | ||
] | ||
import {ABS} from './ABS' | ||
import {ACOS} from './ACOS' | ||
import {ADD} from './ADD' | ||
import {AND} from './AND' | ||
import {BIN2DEC} from './BIN2DEC' | ||
import {CELL} from './CELL' | ||
import {CELLINDEX} from './CELLINDEX' | ||
import {CHOOSE} from './CHOOSE' | ||
import {CLEAN} from './CLEAN' | ||
import {CONCATENATE} from './CONCATENATE' | ||
import {COND} from './COND' | ||
import {COS} from './COS' | ||
import {DATE} from './DATE' | ||
import {DATEDIF} from './DATEDIF' | ||
import {DEC2BIN} from './DEC2BIN' | ||
import {DIVIDE} from './DIVIDE' | ||
import {EQ} from './EQ' | ||
import {FILTER} from './FILTER' | ||
import {FIND} from './FIND' | ||
import {FLATTEN} from './FLATTEN' | ||
import {GT} from './GT' | ||
import {GTE} from './GTE' | ||
import {GUID} from './GUID' | ||
import {HLOOKUP} from './HLOOKUP' | ||
import {IFNA} from './IFNA' | ||
import {IN} from './IN' | ||
import {INDEX2COL} from './INDEX2COL' | ||
import {INDEX2ROW} from './INDEX2ROW' | ||
import {INDIRECT} from './INDIRECT' | ||
import {ISARRAY} from './ISARRAY' | ||
import {ISBLANK} from './ISBLANK' | ||
import {ISEMAIL} from './ISEMAIL' | ||
import {ISERROR} from './ISERROR' | ||
import {ISEVEN} from './ISEVEN' | ||
import {ISNA} from './ISNA' | ||
import {ISNUMBER} from './ISNUMBER' | ||
import {ISODD} from './ISODD' | ||
import {ISRANGE} from './ISRANGE' | ||
import {ISREF} from './ISREF' | ||
import {ISTEXT} from './ISTEXT' | ||
import {ISURL} from './ISURL' | ||
import {LOOKUP} from './LOOKUP' | ||
import {LOWER} from './LOWER' | ||
import {LT} from './LT' | ||
import {LTE} from './LTE' | ||
import {MAX} from './MAX' | ||
import {MULTIPLY} from './MULTIPLY' | ||
import {N} from './N' | ||
import {NE} from './NE' | ||
import {NOT} from './NOT' | ||
import {OCT2DEC} from './OCT2DEC' | ||
import {OR} from './OR' | ||
import {PI} from './PI' | ||
import {PMT} from './PMT' | ||
import {POWER} from './POWER' | ||
import {RANGE} from './RANGE' | ||
import {REPT} from './REPT' | ||
import {SEARCH} from './SEARCH' | ||
import {SIN} from './SIN' | ||
import {SORT} from './SORT' | ||
import {SUM} from './SUM' | ||
import {SWITCH} from './SWITCH' | ||
import {TAN} from './TAN' | ||
import {TAU} from './TAU' | ||
import {TEXT} from './TEXT' | ||
import {UNIQUE} from './UNIQUE' | ||
import {UPPER} from './UPPER' | ||
import {VLOOKUP} from './VLOOKUP' | ||
export let functions = FLATTEN([ | ||
logicalFunctions, | ||
informationFunctions, | ||
referenceFunctions, | ||
dataFunctions, | ||
mathFunctions, | ||
dateTimeFunctions, | ||
financialFunctions, | ||
statisticFunctions, | ||
textFunctions, | ||
engineeringFunctions | ||
]).sort() | ||
export default { | ||
ABS, | ||
ACOS, | ||
ADD, | ||
AND, | ||
BIN2DEC, | ||
CELL, | ||
CELLINDEX, | ||
CHOOSE, | ||
CLEAN, | ||
CONCATENATE, | ||
COND, | ||
COS, | ||
DATE, | ||
DATEDIF, | ||
DEC2BIN, | ||
DIVIDE, | ||
EQ, | ||
FILTER, | ||
FIND, | ||
FLATTEN, | ||
GT, | ||
GTE, | ||
GUID, | ||
HLOOKUP, | ||
IFNA, | ||
IN, | ||
INDEX2COL, | ||
INDEX2ROW, | ||
INDIRECT, | ||
ISARRAY, | ||
ISBLANK, | ||
ISEMAIL, | ||
ISERROR, | ||
ISEVEN, | ||
ISNA, | ||
ISNUMBER, | ||
ISODD, | ||
ISRANGE, | ||
ISREF, | ||
ISTEXT, | ||
ISURL, | ||
LOOKUP, | ||
LOWER, | ||
LT, | ||
LTE, | ||
MAX, | ||
MULTIPLY, | ||
N, | ||
NE, | ||
NOT, | ||
OCT2DEC, | ||
OR, | ||
PI, | ||
PMT, | ||
POWER, | ||
RANGE, | ||
REPT, | ||
SEARCH, | ||
SIN, | ||
SORT, | ||
SUM, | ||
SWITCH, | ||
TAN, | ||
TAU, | ||
TEXT, | ||
UNIQUE, | ||
UPPER, | ||
VLOOKUP | ||
} |
import test from 'tape' | ||
import Box from '../src/index' | ||
import * as Box from '../src/index' | ||
@@ -4,0 +4,0 @@ test('index', function(t) { |
Uses eval
Supply chain riskPackage uses dynamic code execution (e.g., eval()), which is a dangerous practice. This can prevent the code from running in certain environments and increases the risk that the code may contain exploits or malicious behavior.
Found 1 instance in 1 package
Dynamic require
Supply chain riskDynamic require can indicate the package is performing dangerous or unsafe dynamic code execution.
Found 1 instance in 1 package
Environment variable access
Supply chain riskPackage accesses environment variables, which may be a sign of credential stuffing or data theft.
Found 1 instance in 1 package
Filesystem access
Supply chain riskAccesses the file system, and could potentially read sensitive data.
Found 1 instance in 1 package
Minified code
QualityThis package contains minified code. This may be harmless in some cases where minified code is included in packaged libraries, however packages on npm should not minify code.
Found 1 instance in 1 package
308856
238
6941
17
12
2
5
3