function PHPExcel_Writer_Excel5_Parser::_initializeHashes in Loft Data Grids 6.2
Same name and namespace in other branches
- 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Writer/Excel5/Parser.php \PHPExcel_Writer_Excel5_Parser::_initializeHashes()
* Initialize the ptg and function hashes. * * @access private
1 call to PHPExcel_Writer_Excel5_Parser::_initializeHashes()
- PHPExcel_Writer_Excel5_Parser::__construct in vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel5/ Parser.php - * The class constructor *
File
- vendor/
phpoffice/ phpexcel/ Classes/ PHPExcel/ Writer/ Excel5/ Parser.php, line 139
Class
- PHPExcel_Writer_Excel5_Parser
- PHPExcel_Writer_Excel5_Parser
Code
function _initializeHashes() {
// The Excel ptg indices
$this->ptg = array(
'ptgExp' => 0x1,
'ptgTbl' => 0x2,
'ptgAdd' => 0x3,
'ptgSub' => 0x4,
'ptgMul' => 0x5,
'ptgDiv' => 0x6,
'ptgPower' => 0x7,
'ptgConcat' => 0x8,
'ptgLT' => 0x9,
'ptgLE' => 0xa,
'ptgEQ' => 0xb,
'ptgGE' => 0xc,
'ptgGT' => 0xd,
'ptgNE' => 0xe,
'ptgIsect' => 0xf,
'ptgUnion' => 0x10,
'ptgRange' => 0x11,
'ptgUplus' => 0x12,
'ptgUminus' => 0x13,
'ptgPercent' => 0x14,
'ptgParen' => 0x15,
'ptgMissArg' => 0x16,
'ptgStr' => 0x17,
'ptgAttr' => 0x19,
'ptgSheet' => 0x1a,
'ptgEndSheet' => 0x1b,
'ptgErr' => 0x1c,
'ptgBool' => 0x1d,
'ptgInt' => 0x1e,
'ptgNum' => 0x1f,
'ptgArray' => 0x20,
'ptgFunc' => 0x21,
'ptgFuncVar' => 0x22,
'ptgName' => 0x23,
'ptgRef' => 0x24,
'ptgArea' => 0x25,
'ptgMemArea' => 0x26,
'ptgMemErr' => 0x27,
'ptgMemNoMem' => 0x28,
'ptgMemFunc' => 0x29,
'ptgRefErr' => 0x2a,
'ptgAreaErr' => 0x2b,
'ptgRefN' => 0x2c,
'ptgAreaN' => 0x2d,
'ptgMemAreaN' => 0x2e,
'ptgMemNoMemN' => 0x2f,
'ptgNameX' => 0x39,
'ptgRef3d' => 0x3a,
'ptgArea3d' => 0x3b,
'ptgRefErr3d' => 0x3c,
'ptgAreaErr3d' => 0x3d,
'ptgArrayV' => 0x40,
'ptgFuncV' => 0x41,
'ptgFuncVarV' => 0x42,
'ptgNameV' => 0x43,
'ptgRefV' => 0x44,
'ptgAreaV' => 0x45,
'ptgMemAreaV' => 0x46,
'ptgMemErrV' => 0x47,
'ptgMemNoMemV' => 0x48,
'ptgMemFuncV' => 0x49,
'ptgRefErrV' => 0x4a,
'ptgAreaErrV' => 0x4b,
'ptgRefNV' => 0x4c,
'ptgAreaNV' => 0x4d,
'ptgMemAreaNV' => 0x4e,
'ptgMemNoMemN' => 0x4f,
'ptgFuncCEV' => 0x58,
'ptgNameXV' => 0x59,
'ptgRef3dV' => 0x5a,
'ptgArea3dV' => 0x5b,
'ptgRefErr3dV' => 0x5c,
'ptgAreaErr3d' => 0x5d,
'ptgArrayA' => 0x60,
'ptgFuncA' => 0x61,
'ptgFuncVarA' => 0x62,
'ptgNameA' => 0x63,
'ptgRefA' => 0x64,
'ptgAreaA' => 0x65,
'ptgMemAreaA' => 0x66,
'ptgMemErrA' => 0x67,
'ptgMemNoMemA' => 0x68,
'ptgMemFuncA' => 0x69,
'ptgRefErrA' => 0x6a,
'ptgAreaErrA' => 0x6b,
'ptgRefNA' => 0x6c,
'ptgAreaNA' => 0x6d,
'ptgMemAreaNA' => 0x6e,
'ptgMemNoMemN' => 0x6f,
'ptgFuncCEA' => 0x78,
'ptgNameXA' => 0x79,
'ptgRef3dA' => 0x7a,
'ptgArea3dA' => 0x7b,
'ptgRefErr3dA' => 0x7c,
'ptgAreaErr3d' => 0x7d,
);
// Thanks to Michael Meeks and Gnumeric for the initial arg values.
//
// The following hash was generated by "function_locale.pl" in the distro.
// Refer to function_locale.pl for non-English function names.
//
// The array elements are as follow:
// ptg: The Excel function ptg code.
// args: The number of arguments that the function takes:
// >=0 is a fixed number of arguments.
// -1 is a variable number of arguments.
// class: The reference, value or array class of the function args.
// vol: The function is volatile.
//
$this->_functions = array(
// function ptg args class vol
'COUNT' => array(
0,
-1,
0,
0,
),
'IF' => array(
1,
-1,
1,
0,
),
'ISNA' => array(
2,
1,
1,
0,
),
'ISERROR' => array(
3,
1,
1,
0,
),
'SUM' => array(
4,
-1,
0,
0,
),
'AVERAGE' => array(
5,
-1,
0,
0,
),
'MIN' => array(
6,
-1,
0,
0,
),
'MAX' => array(
7,
-1,
0,
0,
),
'ROW' => array(
8,
-1,
0,
0,
),
'COLUMN' => array(
9,
-1,
0,
0,
),
'NA' => array(
10,
0,
0,
0,
),
'NPV' => array(
11,
-1,
1,
0,
),
'STDEV' => array(
12,
-1,
0,
0,
),
'DOLLAR' => array(
13,
-1,
1,
0,
),
'FIXED' => array(
14,
-1,
1,
0,
),
'SIN' => array(
15,
1,
1,
0,
),
'COS' => array(
16,
1,
1,
0,
),
'TAN' => array(
17,
1,
1,
0,
),
'ATAN' => array(
18,
1,
1,
0,
),
'PI' => array(
19,
0,
1,
0,
),
'SQRT' => array(
20,
1,
1,
0,
),
'EXP' => array(
21,
1,
1,
0,
),
'LN' => array(
22,
1,
1,
0,
),
'LOG10' => array(
23,
1,
1,
0,
),
'ABS' => array(
24,
1,
1,
0,
),
'INT' => array(
25,
1,
1,
0,
),
'SIGN' => array(
26,
1,
1,
0,
),
'ROUND' => array(
27,
2,
1,
0,
),
'LOOKUP' => array(
28,
-1,
0,
0,
),
'INDEX' => array(
29,
-1,
0,
1,
),
'REPT' => array(
30,
2,
1,
0,
),
'MID' => array(
31,
3,
1,
0,
),
'LEN' => array(
32,
1,
1,
0,
),
'VALUE' => array(
33,
1,
1,
0,
),
'TRUE' => array(
34,
0,
1,
0,
),
'FALSE' => array(
35,
0,
1,
0,
),
'AND' => array(
36,
-1,
0,
0,
),
'OR' => array(
37,
-1,
0,
0,
),
'NOT' => array(
38,
1,
1,
0,
),
'MOD' => array(
39,
2,
1,
0,
),
'DCOUNT' => array(
40,
3,
0,
0,
),
'DSUM' => array(
41,
3,
0,
0,
),
'DAVERAGE' => array(
42,
3,
0,
0,
),
'DMIN' => array(
43,
3,
0,
0,
),
'DMAX' => array(
44,
3,
0,
0,
),
'DSTDEV' => array(
45,
3,
0,
0,
),
'VAR' => array(
46,
-1,
0,
0,
),
'DVAR' => array(
47,
3,
0,
0,
),
'TEXT' => array(
48,
2,
1,
0,
),
'LINEST' => array(
49,
-1,
0,
0,
),
'TREND' => array(
50,
-1,
0,
0,
),
'LOGEST' => array(
51,
-1,
0,
0,
),
'GROWTH' => array(
52,
-1,
0,
0,
),
'PV' => array(
56,
-1,
1,
0,
),
'FV' => array(
57,
-1,
1,
0,
),
'NPER' => array(
58,
-1,
1,
0,
),
'PMT' => array(
59,
-1,
1,
0,
),
'RATE' => array(
60,
-1,
1,
0,
),
'MIRR' => array(
61,
3,
0,
0,
),
'IRR' => array(
62,
-1,
0,
0,
),
'RAND' => array(
63,
0,
1,
1,
),
'MATCH' => array(
64,
-1,
0,
0,
),
'DATE' => array(
65,
3,
1,
0,
),
'TIME' => array(
66,
3,
1,
0,
),
'DAY' => array(
67,
1,
1,
0,
),
'MONTH' => array(
68,
1,
1,
0,
),
'YEAR' => array(
69,
1,
1,
0,
),
'WEEKDAY' => array(
70,
-1,
1,
0,
),
'HOUR' => array(
71,
1,
1,
0,
),
'MINUTE' => array(
72,
1,
1,
0,
),
'SECOND' => array(
73,
1,
1,
0,
),
'NOW' => array(
74,
0,
1,
1,
),
'AREAS' => array(
75,
1,
0,
1,
),
'ROWS' => array(
76,
1,
0,
1,
),
'COLUMNS' => array(
77,
1,
0,
1,
),
'OFFSET' => array(
78,
-1,
0,
1,
),
'SEARCH' => array(
82,
-1,
1,
0,
),
'TRANSPOSE' => array(
83,
1,
1,
0,
),
'TYPE' => array(
86,
1,
1,
0,
),
'ATAN2' => array(
97,
2,
1,
0,
),
'ASIN' => array(
98,
1,
1,
0,
),
'ACOS' => array(
99,
1,
1,
0,
),
'CHOOSE' => array(
100,
-1,
1,
0,
),
'HLOOKUP' => array(
101,
-1,
0,
0,
),
'VLOOKUP' => array(
102,
-1,
0,
0,
),
'ISREF' => array(
105,
1,
0,
0,
),
'LOG' => array(
109,
-1,
1,
0,
),
'CHAR' => array(
111,
1,
1,
0,
),
'LOWER' => array(
112,
1,
1,
0,
),
'UPPER' => array(
113,
1,
1,
0,
),
'PROPER' => array(
114,
1,
1,
0,
),
'LEFT' => array(
115,
-1,
1,
0,
),
'RIGHT' => array(
116,
-1,
1,
0,
),
'EXACT' => array(
117,
2,
1,
0,
),
'TRIM' => array(
118,
1,
1,
0,
),
'REPLACE' => array(
119,
4,
1,
0,
),
'SUBSTITUTE' => array(
120,
-1,
1,
0,
),
'CODE' => array(
121,
1,
1,
0,
),
'FIND' => array(
124,
-1,
1,
0,
),
'CELL' => array(
125,
-1,
0,
1,
),
'ISERR' => array(
126,
1,
1,
0,
),
'ISTEXT' => array(
127,
1,
1,
0,
),
'ISNUMBER' => array(
128,
1,
1,
0,
),
'ISBLANK' => array(
129,
1,
1,
0,
),
'T' => array(
130,
1,
0,
0,
),
'N' => array(
131,
1,
0,
0,
),
'DATEVALUE' => array(
140,
1,
1,
0,
),
'TIMEVALUE' => array(
141,
1,
1,
0,
),
'SLN' => array(
142,
3,
1,
0,
),
'SYD' => array(
143,
4,
1,
0,
),
'DDB' => array(
144,
-1,
1,
0,
),
'INDIRECT' => array(
148,
-1,
1,
1,
),
'CALL' => array(
150,
-1,
1,
0,
),
'CLEAN' => array(
162,
1,
1,
0,
),
'MDETERM' => array(
163,
1,
2,
0,
),
'MINVERSE' => array(
164,
1,
2,
0,
),
'MMULT' => array(
165,
2,
2,
0,
),
'IPMT' => array(
167,
-1,
1,
0,
),
'PPMT' => array(
168,
-1,
1,
0,
),
'COUNTA' => array(
169,
-1,
0,
0,
),
'PRODUCT' => array(
183,
-1,
0,
0,
),
'FACT' => array(
184,
1,
1,
0,
),
'DPRODUCT' => array(
189,
3,
0,
0,
),
'ISNONTEXT' => array(
190,
1,
1,
0,
),
'STDEVP' => array(
193,
-1,
0,
0,
),
'VARP' => array(
194,
-1,
0,
0,
),
'DSTDEVP' => array(
195,
3,
0,
0,
),
'DVARP' => array(
196,
3,
0,
0,
),
'TRUNC' => array(
197,
-1,
1,
0,
),
'ISLOGICAL' => array(
198,
1,
1,
0,
),
'DCOUNTA' => array(
199,
3,
0,
0,
),
'USDOLLAR' => array(
204,
-1,
1,
0,
),
'FINDB' => array(
205,
-1,
1,
0,
),
'SEARCHB' => array(
206,
-1,
1,
0,
),
'REPLACEB' => array(
207,
4,
1,
0,
),
'LEFTB' => array(
208,
-1,
1,
0,
),
'RIGHTB' => array(
209,
-1,
1,
0,
),
'MIDB' => array(
210,
3,
1,
0,
),
'LENB' => array(
211,
1,
1,
0,
),
'ROUNDUP' => array(
212,
2,
1,
0,
),
'ROUNDDOWN' => array(
213,
2,
1,
0,
),
'ASC' => array(
214,
1,
1,
0,
),
'DBCS' => array(
215,
1,
1,
0,
),
'RANK' => array(
216,
-1,
0,
0,
),
'ADDRESS' => array(
219,
-1,
1,
0,
),
'DAYS360' => array(
220,
-1,
1,
0,
),
'TODAY' => array(
221,
0,
1,
1,
),
'VDB' => array(
222,
-1,
1,
0,
),
'MEDIAN' => array(
227,
-1,
0,
0,
),
'SUMPRODUCT' => array(
228,
-1,
2,
0,
),
'SINH' => array(
229,
1,
1,
0,
),
'COSH' => array(
230,
1,
1,
0,
),
'TANH' => array(
231,
1,
1,
0,
),
'ASINH' => array(
232,
1,
1,
0,
),
'ACOSH' => array(
233,
1,
1,
0,
),
'ATANH' => array(
234,
1,
1,
0,
),
'DGET' => array(
235,
3,
0,
0,
),
'INFO' => array(
244,
1,
1,
1,
),
'DB' => array(
247,
-1,
1,
0,
),
'FREQUENCY' => array(
252,
2,
0,
0,
),
'ERROR.TYPE' => array(
261,
1,
1,
0,
),
'REGISTER.ID' => array(
267,
-1,
1,
0,
),
'AVEDEV' => array(
269,
-1,
0,
0,
),
'BETADIST' => array(
270,
-1,
1,
0,
),
'GAMMALN' => array(
271,
1,
1,
0,
),
'BETAINV' => array(
272,
-1,
1,
0,
),
'BINOMDIST' => array(
273,
4,
1,
0,
),
'CHIDIST' => array(
274,
2,
1,
0,
),
'CHIINV' => array(
275,
2,
1,
0,
),
'COMBIN' => array(
276,
2,
1,
0,
),
'CONFIDENCE' => array(
277,
3,
1,
0,
),
'CRITBINOM' => array(
278,
3,
1,
0,
),
'EVEN' => array(
279,
1,
1,
0,
),
'EXPONDIST' => array(
280,
3,
1,
0,
),
'FDIST' => array(
281,
3,
1,
0,
),
'FINV' => array(
282,
3,
1,
0,
),
'FISHER' => array(
283,
1,
1,
0,
),
'FISHERINV' => array(
284,
1,
1,
0,
),
'FLOOR' => array(
285,
2,
1,
0,
),
'GAMMADIST' => array(
286,
4,
1,
0,
),
'GAMMAINV' => array(
287,
3,
1,
0,
),
'CEILING' => array(
288,
2,
1,
0,
),
'HYPGEOMDIST' => array(
289,
4,
1,
0,
),
'LOGNORMDIST' => array(
290,
3,
1,
0,
),
'LOGINV' => array(
291,
3,
1,
0,
),
'NEGBINOMDIST' => array(
292,
3,
1,
0,
),
'NORMDIST' => array(
293,
4,
1,
0,
),
'NORMSDIST' => array(
294,
1,
1,
0,
),
'NORMINV' => array(
295,
3,
1,
0,
),
'NORMSINV' => array(
296,
1,
1,
0,
),
'STANDARDIZE' => array(
297,
3,
1,
0,
),
'ODD' => array(
298,
1,
1,
0,
),
'PERMUT' => array(
299,
2,
1,
0,
),
'POISSON' => array(
300,
3,
1,
0,
),
'TDIST' => array(
301,
3,
1,
0,
),
'WEIBULL' => array(
302,
4,
1,
0,
),
'SUMXMY2' => array(
303,
2,
2,
0,
),
'SUMX2MY2' => array(
304,
2,
2,
0,
),
'SUMX2PY2' => array(
305,
2,
2,
0,
),
'CHITEST' => array(
306,
2,
2,
0,
),
'CORREL' => array(
307,
2,
2,
0,
),
'COVAR' => array(
308,
2,
2,
0,
),
'FORECAST' => array(
309,
3,
2,
0,
),
'FTEST' => array(
310,
2,
2,
0,
),
'INTERCEPT' => array(
311,
2,
2,
0,
),
'PEARSON' => array(
312,
2,
2,
0,
),
'RSQ' => array(
313,
2,
2,
0,
),
'STEYX' => array(
314,
2,
2,
0,
),
'SLOPE' => array(
315,
2,
2,
0,
),
'TTEST' => array(
316,
4,
2,
0,
),
'PROB' => array(
317,
-1,
2,
0,
),
'DEVSQ' => array(
318,
-1,
0,
0,
),
'GEOMEAN' => array(
319,
-1,
0,
0,
),
'HARMEAN' => array(
320,
-1,
0,
0,
),
'SUMSQ' => array(
321,
-1,
0,
0,
),
'KURT' => array(
322,
-1,
0,
0,
),
'SKEW' => array(
323,
-1,
0,
0,
),
'ZTEST' => array(
324,
-1,
0,
0,
),
'LARGE' => array(
325,
2,
0,
0,
),
'SMALL' => array(
326,
2,
0,
0,
),
'QUARTILE' => array(
327,
2,
0,
0,
),
'PERCENTILE' => array(
328,
2,
0,
0,
),
'PERCENTRANK' => array(
329,
-1,
0,
0,
),
'MODE' => array(
330,
-1,
2,
0,
),
'TRIMMEAN' => array(
331,
2,
0,
0,
),
'TINV' => array(
332,
2,
1,
0,
),
'CONCATENATE' => array(
336,
-1,
1,
0,
),
'POWER' => array(
337,
2,
1,
0,
),
'RADIANS' => array(
342,
1,
1,
0,
),
'DEGREES' => array(
343,
1,
1,
0,
),
'SUBTOTAL' => array(
344,
-1,
0,
0,
),
'SUMIF' => array(
345,
-1,
0,
0,
),
'COUNTIF' => array(
346,
2,
0,
0,
),
'COUNTBLANK' => array(
347,
1,
0,
0,
),
'ISPMT' => array(
350,
4,
1,
0,
),
'DATEDIF' => array(
351,
3,
1,
0,
),
'DATESTRING' => array(
352,
1,
1,
0,
),
'NUMBERSTRING' => array(
353,
2,
1,
0,
),
'ROMAN' => array(
354,
-1,
1,
0,
),
'GETPIVOTDATA' => array(
358,
-1,
0,
0,
),
'HYPERLINK' => array(
359,
-1,
1,
0,
),
'PHONETIC' => array(
360,
1,
0,
0,
),
'AVERAGEA' => array(
361,
-1,
0,
0,
),
'MAXA' => array(
362,
-1,
0,
0,
),
'MINA' => array(
363,
-1,
0,
0,
),
'STDEVPA' => array(
364,
-1,
0,
0,
),
'VARPA' => array(
365,
-1,
0,
0,
),
'STDEVA' => array(
366,
-1,
0,
0,
),
'VARA' => array(
367,
-1,
0,
0,
),
'BAHTTEXT' => array(
368,
1,
0,
0,
),
);
}