New Case Study:See how Anthropic automated 95% of dependency reviews with Socket.Learn More
Socket
Sign inDemoInstall
Socket

functionfoundry

Package Overview
Dependencies
Maintainers
1
Versions
88
Alerts
File Explorer

Advanced tools

Socket logo

Install Socket

Detect and block malicious and high-risk dependencies

Install

functionfoundry - npm Package Compare versions

Comparing version 0.6.13 to 0.7.0

dist/functionfoundry.js

4

gulpfile.js

@@ -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'])
});

@@ -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.

@@ -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) {

SocketSocket SOC 2 Logo

Product

  • Package Alerts
  • Integrations
  • Docs
  • Pricing
  • FAQ
  • Roadmap
  • Changelog

Packages

npm

Stay in touch

Get open source security insights delivered straight into your inbox.


  • Terms
  • Privacy
  • Security

Made with ⚡️ by Socket Inc