Constant Field Values

Contents

corpus.analyser.*
corpus.doodle.*
corpus.excel.*
corpus.gobbler.*

corpus.analyser.*

corpus.analyser.Analyser

public static final int CLUSTER 8

public static final int COMPRESSION 12

public static final int FORMULA_COM 5

public static final int FORMULACOMPONENT 10

public static final int HEATMAP 9

public static final int METRICS 7

public static final int OCCUPANCY 1

public static final int POWERLAW 11

public static final int TREEDEPTH 6

public static final int VECTOR 3

public static final int VECTOR_MAG 4

public static final int WS_OCCUPANCY 2

corpus.doodle.*

corpus.doodle.RectangleColor

public static final int HORIZONTAL 2

public static final java.lang.String label "corpus.doodle.RectangleColor"

public static final int VERTICAL 1

corpus.excel.*

corpus.excel.Operator

public static final int CARET 8

public static final int COMPARISON 6

public static final int CONCATIONATION 7

public static final int DIVIDE 3

public static final int EXPONENT 5

public static final int MINUS 1

public static final int MODULO 4

public static final int PLUS 0

public static final int TIMES 2

corpus.excel.parser.CellReferenceParser

public static final java.lang.String COL_PATTERN "([A-H][A-Z]|I[A-Z]|[A-Z])"

public static final java.lang.String PATTERN "\\${0,1}([A-H][A-Z]|I[A-Z]|[A-Z])\\${0,1}\\d{1,5}"

public static final java.lang.String ROW_PATTERN "\\d{1,5}"

corpus.excel.parser.IntersectionParser

public static final java.lang.String PATTERN ".+\\s.+"

corpus.excel.parser.OperatorParser

public static final java.lang.String ARITHMATIC_PATTERN "(\\+|-|\\*|/|\\^)"

public static final java.lang.String COMPARRISON_PATTERN "(<=|>=|<|>|!=|=)"

public static final java.lang.String CONCATINATION_PATTERN "(\\&)"

public static final java.lang.String OTHER_PATTERN "(\\%)"

public static final java.lang.String PATTERN "(\\+|-|\\*|/|\\^)|(<=|>=|<|>|!=|=)|(\\&)|(\\%)"

corpus.excel.parser.RangeParser

public static final java.lang.String PATTERN "\\${0,1}([A-H][A-Z]|I[A-Z]|[A-Z])\\${0,1}\\d{1,5}:\\${0,1}([A-H][A-Z]|I[A-Z]|[A-Z])\\${0,1}\\d{1,5}"

corpus.excel.parser.UnionParser

public static final java.lang.String PATTERN ".+,.+"

corpus.excel.parser.VectorParser

public static final java.lang.String COLUMN_PATTERN "([A-H][A-Z]|I[A-Z]|[A-Z]):([A-H][A-Z]|I[A-Z]|[A-Z])"

public static final java.lang.String PATTERN "([A-H][A-Z]|I[A-Z]|[A-Z]):([A-H][A-Z]|I[A-Z]|[A-Z])|\\d{1,5}:\\d{1,5}"

public static final java.lang.String ROW_PATTERN "\\d{1,5}:\\d{1,5}"

corpus.gobbler.*

corpus.gobbler.Gobbler

public static final int GOOGLEAPI 0

public static final int HTTPGET 1

Overview

Package

Class

Tree

Deprecated

Index

Help

Spreadsheet Toolkit

PREV NEXT

FRAMES NO FRAMES

Project Home Page

corpus.analyser.Analyser
`public static final int`	`CLUSTER`	`8`
`public static final int`	`COMPRESSION`	`12`
`public static final int`	`FORMULA_COM`	`5`
`public static final int`	`FORMULACOMPONENT`	`10`
`public static final int`	`HEATMAP`	`9`
`public static final int`	`METRICS`	`7`
`public static final int`	`OCCUPANCY`	`1`
`public static final int`	`POWERLAW`	`11`
`public static final int`	`TREEDEPTH`	`6`
`public static final int`	`VECTOR`	`3`
`public static final int`	`VECTOR_MAG`	`4`
`public static final int`	`WS_OCCUPANCY`	`2`

corpus.doodle.RectangleColor
`public static final int`	`HORIZONTAL`	`2`
`public static final java.lang.String`	`label`	`"corpus.doodle.RectangleColor"`
`public static final int`	`VERTICAL`	`1`

corpus.excel.Operator
`public static final int`	`CARET`	`8`
`public static final int`	`COMPARISON`	`6`
`public static final int`	`CONCATIONATION`	`7`
`public static final int`	`DIVIDE`	`3`
`public static final int`	`EXPONENT`	`5`
`public static final int`	`MINUS`	`1`
`public static final int`	`MODULO`	`4`
`public static final int`	`PLUS`	`0`
`public static final int`	`TIMES`	`2`

corpus.excel.parser.CellReferenceParser
`public static final java.lang.String`	`COL_PATTERN`	`"([A-H][A-Z]\|I[A-Z]\|[A-Z])"`
`public static final java.lang.String`	`PATTERN`	`"\\${0,1}([A-H][A-Z]\|I[A-Z]\|[A-Z])\\${0,1}\\d{1,5}"`
`public static final java.lang.String`	`ROW_PATTERN`	`"\\d{1,5}"`

corpus.excel.parser.FunctionParser
`public static final java.lang.String`	`P_DATABASE`	`"(DAVERAGE\|DCOUNT\|DCOUNTA\|DGET\|DMAX\|DMIN\|DPRODUCT\|DSTDEV\|DSTDEVP\|DSUM\|DVAR\|DVARP\|GETPIVOTDATA)"`
`public static final java.lang.String`	`P_DATEANDTIME`	`"(DATE\|DATEVALUE\|DAY\|DAYS360\|EDATE\|EOMONTH\|HOUR\|MINUTE\|MONTH\|NETWORKDAYS\|NOW\|SECOND\|TIME\|TIMEVALUE\|TODAY\|WEEKDAY\|WORKDAY\|YEAR\|YEARFRAC)"`
`public static final java.lang.String`	`P_ENGINEERING`	`"(BESSELI\|BESSELJ\|BESSELK\|BESSELY\|BIN2DEC\|BIN2HEX\|BIN2OCT\|COMPLEX\|CONVERT\|DEC2BIN\|DEC2HEX\|DEC2OCT\|DELTA\|ERF\|ERFC\|GESTEP\|HEX2BIN\|HEX2DEC\|HEX2OCT\|IMABS\|IMAGINARY\|IMARGUMENT\|IMCONJUGATE\|IMCOS\|IMDIV\|IMEXP\|IMLN\|IMLOG10\|IMLOG2\|IMPOWER\|IMPRODUCT\|IMREAL\|IMSIN\|IMSQRT\|IMSUB\|IMSUM\|OCT2BIN\|OCT2DEC\|OCT2HEX)"`
`public static final java.lang.String`	`P_FINANCIAL`	`"(ACCRINT\|ACCRINTM\|AMORDEGRC\|AMORLINC\|COUPDAYBS\|COUPDAYS\|COUPDAYSNC\|COUPNCD\|COUPNUM\|COUPPCD\|CUMIPMT\|CUMPRINC\|DB\|DDB\|DISC\|DOLLARDE\|DOLLARFR\|DURATION\|EFFECT\|FV\|FVSCHEDULE\|INTRATE\|IPMT\|IRR\|MDURATION\|MIRR\|NOMINAL\|NPER\|NPV\|ODDFPRICE\|ODDFYIELD\|ODDLPRICE\|ODDLYIELD\|PMT\|PPMT\|PRICE\|PRICEDISC\|PRICEMAT\|PV\|RATE\|RECEIVED\|SLN\|SYD\|TBILLEQ\|TBILLPRICE\|TBILLYIELD\|VDB\|XIRR\|XNPV\|YIELD\|YIELDDISC\|YIELDMAT)"`
`public static final java.lang.String`	`P_INFORMATION`	`"(CELL\|COUNTBLANK\|ERROR.TYPE\|INFO\|ISBLANK\|ISERR\|ISERROR\|ISEVEN\|ISLOGICAL\|ISNA\|ISNONTEXT\|ISNUMBER\|ISODD\|ISREF\|ISTEXT\|N\|NA\|TYPE)"`
`public static final java.lang.String`	`P_LOGICAL`	`"(IF\|AND\|OR\|NOT\|TRUE\|FALSE)"`
`public static final java.lang.String`	`P_LOOKUPANDREFERENCE`	`"(ADDRESS\|AREAS\|CHOOSE\|COLUMN\|COLUMNS\|HLOOKUP\|HYPERLINK\|INDEX\|INDIRECT\|LOOKUP\|MATCH\|OFFSET\|ROW\|ROWS\|TRANSPOSE\|VLOOKUP)"`
`public static final java.lang.String`	`P_MATHANDTRIG`	`"(ABS\|ACOS\|ACOSH\|ASIN\|ASINH\|ATAN\|ATAN2\|ATANH\|CEILING\|COMBIN\|COS\|COSH\|COUNTIF\|DEGREES\|EVEN\|EXP\|FACT\|FACTDOUBLE\|FLOOR\|GCD\|INT\|LCM\|LN\|LOG\|LOG10\|MDETERM\|MINVERSE\|MMULT\|MOD\|MROUND\|MULTINOMIAL\|ODD\|PI\|POWER\|PRODUCT\|QUOTIENT\|RADIANS\|RAND\|RANDBETWEEN\|ROMAN\|ROUND\|ROUNDDOWN\|ROUNDUP\|SERIESSUM\|SIGN\|SIN\|SINH\|SQRT\|SQRTPI\|SUBTOTAL\|SUMIF)\|(SUM\|SUMPRODUCT\|SUMSQ\|SUMX2MY2\|SUMX2PY2\|SUMXMY2\|TAN\|TANH\|TRUN)"`
`public static final java.lang.String`	`P_STATISTICAL`	"(AVEDEV\|AVERAGE\|AVERAGEA\|BETADIST\|BETAINV\|BINOMDIST\|CHIDIST\|CHIINV\|CHITEST\|CONFIDENCE\|CORREL\|COUNT\|COUNTA\|COVAR\|CRITBINOM\|DEVSQ\|EXPONDIST\|FDIST\|FINV\|FISHER\|FISHERINV\|FORECAST\|FREQUENCY\|FTEST\|GAMMADIST\|GAMMAINV\|GAMMALN\|GEOMEAN\|GROWTH\|HARMEAN\|HYPGEOMDIST\|INTERCEPT\|KURT\|LARGE\|LINEST\|LOGEST\|LOGINV\|LOGNORMDIST\|MAX\|MAXA\|MEDIAN\|MIN\|MINA\|MODE\|NEGBINOMDIST\|NORMDIST\|NORMINV\|NORMSDIST\|NORMSINV\|PEARSON\|PERCENTILE\|PERCENTRANK\|PERMUT\|POISSON\|PROB\|QUARTILE\|RANK\|RSQ\|SKEW\|SLOPE\|SMALL\|STANDARDIZE\|STDEV\|STDEVA\|STDEVP\|STDEVPA\|STEYX\|TDIST\|TINV\|TREND\|TRIMMEAN\|TTEST\|VAR\|VARA\|VARP\|VARPA\|WEIBULL\|ZTEST)"
`public static final java.lang.String`	`P_TEXT`	`"(CHAR\|CLEAN\|CODE\|CONCATENATE\|DOLLAR\|EXACT\|FIND\|FIXED\|LEFT\|LEN\|LOWER\|MID\|PROPER\|REPLACE\|REPT\|RIGHT\|SEARCH\|SUBSTITUTE\|T\|TEXT\|TRIM\|UPPER\|VALUE)"`
`public static final java.lang.String`	`PATTERN`	"((IF\|AND\|OR\|NOT\|TRUE\|FALSE)\|(ACCRINT\|ACCRINTM\|AMORDEGRC\|AMORLINC\|COUPDAYBS\|COUPDAYS\|COUPDAYSNC\|COUPNCD\|COUPNUM\|COUPPCD\|CUMIPMT\|CUMPRINC\|DB\|DDB\|DISC\|DOLLARDE\|DOLLARFR\|DURATION\|EFFECT\|FV\|FVSCHEDULE\|INTRATE\|IPMT\|IRR\|MDURATION\|MIRR\|NOMINAL\|NPER\|NPV\|ODDFPRICE\|ODDFYIELD\|ODDLPRICE\|ODDLYIELD\|PMT\|PPMT\|PRICE\|PRICEDISC\|PRICEMAT\|PV\|RATE\|RECEIVED\|SLN\|SYD\|TBILLEQ\|TBILLPRICE\|TBILLYIELD\|VDB\|XIRR\|XNPV\|YIELD\|YIELDDISC\|YIELDMAT)\|(AVEDEV\|AVERAGE\|AVERAGEA\|BETADIST\|BETAINV\|BINOMDIST\|CHIDIST\|CHIINV\|CHITEST\|CONFIDENCE\|CORREL\|COUNT\|COUNTA\|COVAR\|CRITBINOM\|DEVSQ\|EXPONDIST\|FDIST\|FINV\|FISHER\|FISHERINV\|FORECAST\|FREQUENCY\|FTEST\|GAMMADIST\|GAMMAINV\|GAMMALN\|GEOMEAN\|GROWTH\|HARMEAN\|HYPGEOMDIST\|INTERCEPT\|KURT\|LARGE\|LINEST\|LOGEST\|LOGINV\|LOGNORMDIST\|MAX\|MAXA\|MEDIAN\|MIN\|MINA\|MODE\|NEGBINOMDIST\|NORMDIST\|NORMINV\|NORMSDIST\|NORMSINV\|PEARSON\|PERCENTILE\|PERCENTRANK\|PERMUT\|POISSON\|PROB\|QUARTILE\|RANK\|RSQ\|SKEW\|SLOPE\|SMALL\|STANDARDIZE\|STDEV\|STDEVA\|STDEVP\|STDEVPA\|STEYX\|TDIST\|TINV\|TREND\|TRIMMEAN\|TTEST\|VAR\|VARA\|VARP\|VARPA\|WEIBULL\|ZTEST)\|(ABS\|ACOS\|ACOSH\|ASIN\|ASINH\|ATAN\|ATAN2\|ATANH\|CEILING\|COMBIN\|COS\|COSH\|COUNTIF\|DEGREES\|EVEN\|EXP\|FACT\|FACTDOUBLE\|FLOOR\|GCD\|INT\|LCM\|LN\|LOG\|LOG10\|MDETERM\|MINVERSE\|MMULT\|MOD\|MROUND\|MULTINOMIAL\|ODD\|PI\|POWER\|PRODUCT\|QUOTIENT\|RADIANS\|RAND\|RANDBETWEEN\|ROMAN\|ROUND\|ROUNDDOWN\|ROUNDUP\|SERIESSUM\|SIGN\|SIN\|SINH\|SQRT\|SQRTPI\|SUBTOTAL\|SUMIF)\|(SUM\|SUMPRODUCT\|SUMSQ\|SUMX2MY2\|SUMX2PY2\|SUMXMY2\|TAN\|TANH\|TRUN)\|(DAVERAGE\|DCOUNT\|DCOUNTA\|DGET\|DMAX\|DMIN\|DPRODUCT\|DSTDEV\|DSTDEVP\|DSUM\|DVAR\|DVARP\|GETPIVOTDATA)\|(DATE\|DATEVALUE\|DAY\|DAYS360\|EDATE\|EOMONTH\|HOUR\|MINUTE\|MONTH\|NETWORKDAYS\|NOW\|SECOND\|TIME\|TIMEVALUE\|TODAY\|WEEKDAY\|WORKDAY\|YEAR\|YEARFRAC)\|(BESSELI\|BESSELJ\|BESSELK\|BESSELY\|BIN2DEC\|BIN2HEX\|BIN2OCT\|COMPLEX\|CONVERT\|DEC2BIN\|DEC2HEX\|DEC2OCT\|DELTA\|ERF\|ERFC\|GESTEP\|HEX2BIN\|HEX2DEC\|HEX2OCT\|IMABS\|IMAGINARY\|IMARGUMENT\|IMCONJUGATE\|IMCOS\|IMDIV\|IMEXP\|IMLN\|IMLOG10\|IMLOG2\|IMPOWER\|IMPRODUCT\|IMREAL\|IMSIN\|IMSQRT\|IMSUB\|IMSUM\|OCT2BIN\|OCT2DEC\|OCT2HEX)\|(CHAR\|CLEAN\|CODE\|CONCATENATE\|DOLLAR\|EXACT\|FIND\|FIXED\|LEFT\|LEN\|LOWER\|MID\|PROPER\|REPLACE\|REPT\|RIGHT\|SEARCH\|SUBSTITUTE\|T\|TEXT\|TRIM\|UPPER\|VALUE)\|(CELL\|COUNTBLANK\|ERROR.TYPE\|INFO\|ISBLANK\|ISERR\|ISERROR\|ISEVEN\|ISLOGICAL\|ISNA\|ISNONTEXT\|ISNUMBER\|ISODD\|ISREF\|ISTEXT\|N\|NA\|TYPE)\|(ADDRESS\|AREAS\|CHOOSE\|COLUMN\|COLUMNS\|HLOOKUP\|HYPERLINK\|INDEX\|INDIRECT\|LOOKUP\|MATCH\|OFFSET\|ROW\|ROWS\|TRANSPOSE\|VLOOKUP))"

corpus.excel.parser.OperatorParser
`public static final java.lang.String`	`ARITHMATIC_PATTERN`	`"(\\+\|-\|\\*\|/\|\\^)"`
`public static final java.lang.String`	`COMPARRISON_PATTERN`	`"(<=\|>=\|<\|>\|!=\|=)"`
`public static final java.lang.String`	`CONCATINATION_PATTERN`	`"(\\&)"`
`public static final java.lang.String`	`OTHER_PATTERN`	`"(\\%)"`
`public static final java.lang.String`	`PATTERN`	`"(\\+\|-\|\\*\|/\|\\^)\|(<=\|>=\|<\|>\|!=\|=)\|(\\&)\|(\\%)"`

corpus.excel.parser.RangeParser
`public static final java.lang.String`	`PATTERN`	`"\\${0,1}([A-H][A-Z]\|I[A-Z]\|[A-Z])\\${0,1}\\d{1,5}:\\${0,1}([A-H][A-Z]\|I[A-Z]\|[A-Z])\\${0,1}\\d{1,5}"`

corpus.excel.parser.UnionParser
`public static final java.lang.String`	`PATTERN`	`".+,.+"`

corpus.excel.parser.VectorParser
`public static final java.lang.String`	`COLUMN_PATTERN`	`"([A-H][A-Z]\|I[A-Z]\|[A-Z]):([A-H][A-Z]\|I[A-Z]\|[A-Z])"`
`public static final java.lang.String`	`PATTERN`	`"([A-H][A-Z]\|I[A-Z]\|[A-Z]):([A-H][A-Z]\|I[A-Z]\|[A-Z])\|\\d{1,5}:\\d{1,5}"`
`public static final java.lang.String`	`ROW_PATTERN`	`"\\d{1,5}:\\d{1,5}"`

corpus.gobbler.Gobbler
`public static final int`	`GOOGLEAPI`	`0`
`public static final int`	`HTTPGET`	`1`