PageRenderTime 60ms CodeModel.GetById 13ms RepoModel.GetById 1ms app.codeStats 0ms

/reports/PAL2/PHPExcel-ADODB/system/PHPExcel/PHPExcel/Calculation.php

https://bitbucket.org/egrmotigue/hoes
PHP | 3292 lines | 2619 code | 187 blank | 486 comment | 317 complexity | 8aa71280137796e78e8d4d44a8a34722 MD5 | raw file
Possible License(s): LGPL-2.1, GPL-3.0

Large files files are truncated, but you can click here to view the full file

  1. <?php
  2. /**
  3. * PHPExcel
  4. *
  5. * Copyright (c) 2006 - 2010 PHPExcel
  6. *
  7. * This library is free software; you can redistribute it and/or
  8. * modify it under the terms of the GNU Lesser General Public
  9. * License as published by the Free Software Foundation; either
  10. * version 2.1 of the License, or (at your option) any later version.
  11. *
  12. * This library is distributed in the hope that it will be useful,
  13. * but WITHOUT ANY WARRANTY; without even the implied warranty of
  14. * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
  15. * Lesser General Public License for more details.
  16. *
  17. * You should have received a copy of the GNU Lesser General Public
  18. * License along with this library; if not, write to the Free Software
  19. * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA
  20. *
  21. * @category PHPExcel
  22. * @package PHPExcel_Calculation
  23. * @copyright Copyright (c) 2006 - 2010 PHPExcel (http://www.codeplex.com/PHPExcel)
  24. * @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
  25. * @version 1.7.2, 2010-01-11
  26. */
  27. /** PHPExcel root directory */
  28. if (!defined('PHPEXCEL_ROOT')) {
  29. /**
  30. * @ignore
  31. */
  32. define('PHPEXCEL_ROOT', dirname(__FILE__) . '/../');
  33. }
  34. /** Matrix */
  35. require_once PHPEXCEL_ROOT . 'PHPExcel/Shared/JAMA/Matrix.php';
  36. /** PHPExcel_Calculation_Function */
  37. require_once PHPEXCEL_ROOT . 'PHPExcel/Calculation/Function.php';
  38. /** PHPExcel_Calculation_Functions */
  39. require_once PHPEXCEL_ROOT . 'PHPExcel/Calculation/Functions.php';
  40. /**
  41. * PHPExcel_Calculation (Singleton)
  42. *
  43. * @category PHPExcel
  44. * @package PHPExcel_Calculation
  45. * @copyright Copyright (c) 2006 - 2010 PHPExcel (http://www.codeplex.com/PHPExcel)
  46. */
  47. class PHPExcel_Calculation {
  48. /** Constants */
  49. /** Regular Expressions */
  50. // Numeric operand
  51. const CALCULATION_REGEXP_NUMBER = '[-+]?\d*\.?\d+(e[-+]?\d+)?';
  52. // String operand
  53. const CALCULATION_REGEXP_STRING = '"(?:[^"]|"")*"';
  54. // Opening bracket
  55. const CALCULATION_REGEXP_OPENBRACE = '\(';
  56. // Function
  57. const CALCULATION_REGEXP_FUNCTION = '@?([A-Z][A-Z0-9\.]*)[\s]*\(';
  58. // Cell reference (cell or range of cells, with or without a sheet reference)
  59. const CALCULATION_REGEXP_CELLREF = '(((\w*)|(\'[^\']*\')|(\"[^\"]*\"))!)?\$?([a-z]+)\$?(\d+)';
  60. // Named Range of cells
  61. const CALCULATION_REGEXP_NAMEDRANGE = '(((\w*)|(\'.*\')|(\".*\"))!)?([_A-Z][_A-Z0-9]*)';
  62. // Error
  63. const CALCULATION_REGEXP_ERROR = '\#[A-Z][A-Z0_\/]*[!\?]?';
  64. /** constants */
  65. const RETURN_ARRAY_AS_ERROR = 'error';
  66. const RETURN_ARRAY_AS_VALUE = 'value';
  67. const RETURN_ARRAY_AS_ARRAY = 'array';
  68. private static $returnArrayAsType = self::RETURN_ARRAY_AS_VALUE;
  69. /**
  70. * Instance of this class
  71. *
  72. * @access private
  73. * @var PHPExcel_Calculation
  74. */
  75. private static $_instance;
  76. /**
  77. * Calculation cache
  78. *
  79. * @access private
  80. * @var array
  81. */
  82. private $_calculationCache = array ();
  83. /**
  84. * Calculation cache enabled
  85. *
  86. * @access private
  87. * @var boolean
  88. */
  89. private $_calculationCacheEnabled = true;
  90. /**
  91. * Calculation cache expiration time
  92. *
  93. * @access private
  94. * @var float
  95. */
  96. private $_calculationCacheExpirationTime = 2.5;
  97. /**
  98. * List of operators that can be used within formulae
  99. *
  100. * @access private
  101. * @var array
  102. */
  103. private $_operators = array('+', '-', '*', '/', '^', '&', '%', '~', '>', '<', '=', '>=', '<=', '<>', '|', ':');
  104. /**
  105. * List of binary operators (those that expect two operands)
  106. *
  107. * @access private
  108. * @var array
  109. */
  110. private $_binaryOperators = array('+', '-', '*', '/', '^', '&', '>', '<', '=', '>=', '<=', '<>', '|', ':');
  111. public $suppressFormulaErrors = false;
  112. public $formulaError = null;
  113. public $writeDebugLog = false;
  114. private $debugLogStack = array();
  115. public $debugLog = array();
  116. // Constant conversion from text name/value to actual (datatyped) value
  117. private $_ExcelConstants = array('TRUE' => True,
  118. 'FALSE' => False,
  119. 'NULL' => Null
  120. );
  121. // PHPExcel functions
  122. private $_PHPExcelFunctions = array( // PHPExcel functions
  123. 'ABS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  124. 'functionCall' => 'abs',
  125. 'argumentCount' => '1'
  126. ),
  127. 'ACCRINT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  128. 'functionCall' => 'PHPExcel_Calculation_Functions::ACCRINT',
  129. 'argumentCount' => '4-7'
  130. ),
  131. 'ACCRINTM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  132. 'functionCall' => 'PHPExcel_Calculation_Functions::ACCRINTM',
  133. 'argumentCount' => '3-5'
  134. ),
  135. 'ACOS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  136. 'functionCall' => 'acos',
  137. 'argumentCount' => '1'
  138. ),
  139. 'ACOSH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  140. 'functionCall' => 'acosh',
  141. 'argumentCount' => '1'
  142. ),
  143. 'ADDRESS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  144. 'functionCall' => 'PHPExcel_Calculation_Functions::CELL_ADDRESS',
  145. 'argumentCount' => '2-5'
  146. ),
  147. 'AMORDEGRC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  148. 'functionCall' => 'PHPExcel_Calculation_Functions::AMORDEGRC',
  149. 'argumentCount' => '6,7'
  150. ),
  151. 'AMORLINC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  152. 'functionCall' => 'PHPExcel_Calculation_Functions::AMORLINC',
  153. 'argumentCount' => '6,7'
  154. ),
  155. 'AND' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOGICAL,
  156. 'functionCall' => 'PHPExcel_Calculation_Functions::LOGICAL_AND',
  157. 'argumentCount' => '1+'
  158. ),
  159. 'AREAS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  160. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  161. 'argumentCount' => '1'
  162. ),
  163. 'ASC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  164. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  165. 'argumentCount' => '1'
  166. ),
  167. 'ASIN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  168. 'functionCall' => 'asin',
  169. 'argumentCount' => '1'
  170. ),
  171. 'ASINH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  172. 'functionCall' => 'asinh',
  173. 'argumentCount' => '1'
  174. ),
  175. 'ATAN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  176. 'functionCall' => 'atan',
  177. 'argumentCount' => '1'
  178. ),
  179. 'ATAN2' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  180. 'functionCall' => 'PHPExcel_Calculation_Functions::REVERSE_ATAN2',
  181. 'argumentCount' => '2'
  182. ),
  183. 'ATANH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  184. 'functionCall' => 'atanh',
  185. 'argumentCount' => '1'
  186. ),
  187. 'AVEDEV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  188. 'functionCall' => 'PHPExcel_Calculation_Functions::AVEDEV',
  189. 'argumentCount' => '1+'
  190. ),
  191. 'AVERAGE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  192. 'functionCall' => 'PHPExcel_Calculation_Functions::AVERAGE',
  193. 'argumentCount' => '1+'
  194. ),
  195. 'AVERAGEA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  196. 'functionCall' => 'PHPExcel_Calculation_Functions::AVERAGEA',
  197. 'argumentCount' => '1+'
  198. ),
  199. 'AVERAGEIF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  200. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  201. 'argumentCount' => '2,3'
  202. ),
  203. 'AVERAGEIFS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  204. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  205. 'argumentCount' => '3+'
  206. ),
  207. 'BAHTTEXT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  208. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  209. 'argumentCount' => '1'
  210. ),
  211. 'BESSELI' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  212. 'functionCall' => 'PHPExcel_Calculation_Functions::BESSELI',
  213. 'argumentCount' => '2'
  214. ),
  215. 'BESSELJ' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  216. 'functionCall' => 'PHPExcel_Calculation_Functions::BESSELJ',
  217. 'argumentCount' => '2'
  218. ),
  219. 'BESSELK' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  220. 'functionCall' => 'PHPExcel_Calculation_Functions::BESSELK',
  221. 'argumentCount' => '2'
  222. ),
  223. 'BESSELY' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  224. 'functionCall' => 'PHPExcel_Calculation_Functions::BESSELY',
  225. 'argumentCount' => '2'
  226. ),
  227. 'BETADIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  228. 'functionCall' => 'PHPExcel_Calculation_Functions::BETADIST',
  229. 'argumentCount' => '3-5'
  230. ),
  231. 'BETAINV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  232. 'functionCall' => 'PHPExcel_Calculation_Functions::BETAINV',
  233. 'argumentCount' => '3-5'
  234. ),
  235. 'BIN2DEC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  236. 'functionCall' => 'PHPExcel_Calculation_Functions::BINTODEC',
  237. 'argumentCount' => '1'
  238. ),
  239. 'BIN2HEX' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  240. 'functionCall' => 'PHPExcel_Calculation_Functions::BINTOHEX',
  241. 'argumentCount' => '1,2'
  242. ),
  243. 'BIN2OCT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  244. 'functionCall' => 'PHPExcel_Calculation_Functions::BINTOOCT',
  245. 'argumentCount' => '1,2'
  246. ),
  247. 'BINOMDIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  248. 'functionCall' => 'PHPExcel_Calculation_Functions::BINOMDIST',
  249. 'argumentCount' => '4'
  250. ),
  251. 'CEILING' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  252. 'functionCall' => 'PHPExcel_Calculation_Functions::CEILING',
  253. 'argumentCount' => '2'
  254. ),
  255. 'CELL' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  256. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  257. 'argumentCount' => '1,2'
  258. ),
  259. 'CHAR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  260. 'functionCall' => 'PHPExcel_Calculation_Functions::CHARACTER',
  261. 'argumentCount' => '1'
  262. ),
  263. 'CHIDIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  264. 'functionCall' => 'PHPExcel_Calculation_Functions::CHIDIST',
  265. 'argumentCount' => '2'
  266. ),
  267. 'CHIINV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  268. 'functionCall' => 'PHPExcel_Calculation_Functions::CHIINV',
  269. 'argumentCount' => '2'
  270. ),
  271. 'CHITEST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  272. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  273. 'argumentCount' => '2'
  274. ),
  275. 'CHOOSE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  276. 'functionCall' => 'PHPExcel_Calculation_Functions::CHOOSE',
  277. 'argumentCount' => '2+'
  278. ),
  279. 'CLEAN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  280. 'functionCall' => 'PHPExcel_Calculation_Functions::TRIMNONPRINTABLE',
  281. 'argumentCount' => '1'
  282. ),
  283. 'CODE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  284. 'functionCall' => 'PHPExcel_Calculation_Functions::ASCIICODE',
  285. 'argumentCount' => '1'
  286. ),
  287. 'COLUMN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  288. 'functionCall' => 'PHPExcel_Calculation_Functions::COLUMN',
  289. 'argumentCount' => '-1',
  290. 'passByReference' => array(true)
  291. ),
  292. 'COLUMNS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  293. 'functionCall' => 'PHPExcel_Calculation_Functions::COLUMNS',
  294. 'argumentCount' => '1'
  295. ),
  296. 'COMBIN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  297. 'functionCall' => 'PHPExcel_Calculation_Functions::COMBIN',
  298. 'argumentCount' => '2'
  299. ),
  300. 'COMPLEX' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  301. 'functionCall' => 'PHPExcel_Calculation_Functions::COMPLEX',
  302. 'argumentCount' => '2,3'
  303. ),
  304. 'CONCATENATE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  305. 'functionCall' => 'PHPExcel_Calculation_Functions::CONCATENATE',
  306. 'argumentCount' => '1+'
  307. ),
  308. 'CONFIDENCE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  309. 'functionCall' => 'PHPExcel_Calculation_Functions::CONFIDENCE',
  310. 'argumentCount' => '3'
  311. ),
  312. 'CONVERT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  313. 'functionCall' => 'PHPExcel_Calculation_Functions::CONVERTUOM',
  314. 'argumentCount' => '3'
  315. ),
  316. 'CORREL' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  317. 'functionCall' => 'PHPExcel_Calculation_Functions::CORREL',
  318. 'argumentCount' => '2'
  319. ),
  320. 'COS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  321. 'functionCall' => 'cos',
  322. 'argumentCount' => '1'
  323. ),
  324. 'COSH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  325. 'functionCall' => 'cosh',
  326. 'argumentCount' => '1'
  327. ),
  328. 'COUNT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  329. 'functionCall' => 'PHPExcel_Calculation_Functions::COUNT',
  330. 'argumentCount' => '1+'
  331. ),
  332. 'COUNTA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  333. 'functionCall' => 'PHPExcel_Calculation_Functions::COUNTA',
  334. 'argumentCount' => '1+'
  335. ),
  336. 'COUNTBLANK' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  337. 'functionCall' => 'PHPExcel_Calculation_Functions::COUNTBLANK',
  338. 'argumentCount' => '1'
  339. ),
  340. 'COUNTIF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  341. 'functionCall' => 'PHPExcel_Calculation_Functions::COUNTIF',
  342. 'argumentCount' => '2'
  343. ),
  344. 'COUNTIFS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  345. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  346. 'argumentCount' => '2'
  347. ),
  348. 'COUPDAYBS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  349. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  350. 'argumentCount' => '3,4'
  351. ),
  352. 'COUPDAYS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  353. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  354. 'argumentCount' => '3,4'
  355. ),
  356. 'COUPDAYSNC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  357. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  358. 'argumentCount' => '3,4'
  359. ),
  360. 'COUPNCD' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  361. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  362. 'argumentCount' => '3,4'
  363. ),
  364. 'COUPNUM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  365. 'functionCall' => 'PHPExcel_Calculation_Functions::COUPNUM',
  366. 'argumentCount' => '3,4'
  367. ),
  368. 'COUPPCD' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  369. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  370. 'argumentCount' => '3,4'
  371. ),
  372. 'COVAR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  373. 'functionCall' => 'PHPExcel_Calculation_Functions::COVAR',
  374. 'argumentCount' => '2'
  375. ),
  376. 'CRITBINOM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  377. 'functionCall' => 'PHPExcel_Calculation_Functions::CRITBINOM',
  378. 'argumentCount' => '3'
  379. ),
  380. 'CUBEKPIMEMBER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  381. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  382. 'argumentCount' => '?'
  383. ),
  384. 'CUBEMEMBER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  385. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  386. 'argumentCount' => '?'
  387. ),
  388. 'CUBEMEMBERPROPERTY' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  389. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  390. 'argumentCount' => '?'
  391. ),
  392. 'CUBERANKEDMEMBER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  393. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  394. 'argumentCount' => '?'
  395. ),
  396. 'CUBESET' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  397. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  398. 'argumentCount' => '?'
  399. ),
  400. 'CUBESETCOUNT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  401. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  402. 'argumentCount' => '?'
  403. ),
  404. 'CUBEVALUE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_CUBE,
  405. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  406. 'argumentCount' => '?'
  407. ),
  408. 'CUMIPMT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  409. 'functionCall' => 'PHPExcel_Calculation_Functions::CUMIPMT',
  410. 'argumentCount' => '6'
  411. ),
  412. 'CUMPRINC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  413. 'functionCall' => 'PHPExcel_Calculation_Functions::CUMPRINC',
  414. 'argumentCount' => '6'
  415. ),
  416. 'DATE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  417. 'functionCall' => 'PHPExcel_Calculation_Functions::DATE',
  418. 'argumentCount' => '3'
  419. ),
  420. 'DATEDIF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  421. 'functionCall' => 'PHPExcel_Calculation_Functions::DATEDIF',
  422. 'argumentCount' => '2,3'
  423. ),
  424. 'DATEVALUE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  425. 'functionCall' => 'PHPExcel_Calculation_Functions::DATEVALUE',
  426. 'argumentCount' => '1'
  427. ),
  428. 'DAVERAGE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  429. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  430. 'argumentCount' => '?'
  431. ),
  432. 'DAY' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  433. 'functionCall' => 'PHPExcel_Calculation_Functions::DAYOFMONTH',
  434. 'argumentCount' => '1'
  435. ),
  436. 'DAYS360' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  437. 'functionCall' => 'PHPExcel_Calculation_Functions::DAYS360',
  438. 'argumentCount' => '2,3'
  439. ),
  440. 'DB' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  441. 'functionCall' => 'PHPExcel_Calculation_Functions::DB',
  442. 'argumentCount' => '4,5'
  443. ),
  444. 'DCOUNT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  445. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  446. 'argumentCount' => '?'
  447. ),
  448. 'DCOUNTA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  449. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  450. 'argumentCount' => '?'
  451. ),
  452. 'DDB' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  453. 'functionCall' => 'PHPExcel_Calculation_Functions::DDB',
  454. 'argumentCount' => '4,5'
  455. ),
  456. 'DEC2BIN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  457. 'functionCall' => 'PHPExcel_Calculation_Functions::DECTOBIN',
  458. 'argumentCount' => '1,2'
  459. ),
  460. 'DEC2HEX' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  461. 'functionCall' => 'PHPExcel_Calculation_Functions::DECTOHEX',
  462. 'argumentCount' => '1,2'
  463. ),
  464. 'DEC2OCT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  465. 'functionCall' => 'PHPExcel_Calculation_Functions::DECTOOCT',
  466. 'argumentCount' => '1,2'
  467. ),
  468. 'DEGREES' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  469. 'functionCall' => 'rad2deg',
  470. 'argumentCount' => '1'
  471. ),
  472. 'DELTA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  473. 'functionCall' => 'PHPExcel_Calculation_Functions::DELTA',
  474. 'argumentCount' => '1,2'
  475. ),
  476. 'DEVSQ' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  477. 'functionCall' => 'PHPExcel_Calculation_Functions::DEVSQ',
  478. 'argumentCount' => '1+'
  479. ),
  480. 'DGET' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  481. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  482. 'argumentCount' => '?'
  483. ),
  484. 'DISC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  485. 'functionCall' => 'PHPExcel_Calculation_Functions::DISC',
  486. 'argumentCount' => '4,5'
  487. ),
  488. 'DMAX' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  489. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  490. 'argumentCount' => '?'
  491. ),
  492. 'DMIN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  493. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  494. 'argumentCount' => '?'
  495. ),
  496. 'DOLLAR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  497. 'functionCall' => 'PHPExcel_Calculation_Functions::DOLLAR',
  498. 'argumentCount' => '1,2'
  499. ),
  500. 'DOLLARDE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  501. 'functionCall' => 'PHPExcel_Calculation_Functions::DOLLARDE',
  502. 'argumentCount' => '2'
  503. ),
  504. 'DOLLARFR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  505. 'functionCall' => 'PHPExcel_Calculation_Functions::DOLLARFR',
  506. 'argumentCount' => '2'
  507. ),
  508. 'DPRODUCT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  509. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  510. 'argumentCount' => '?'
  511. ),
  512. 'DSTDEV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  513. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  514. 'argumentCount' => '?'
  515. ),
  516. 'DSTDEVP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  517. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  518. 'argumentCount' => '?'
  519. ),
  520. 'DSUM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  521. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  522. 'argumentCount' => '?'
  523. ),
  524. 'DURATION' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  525. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  526. 'argumentCount' => '5,6'
  527. ),
  528. 'DVAR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  529. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  530. 'argumentCount' => '?'
  531. ),
  532. 'DVARP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATABASE,
  533. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  534. 'argumentCount' => '?'
  535. ),
  536. 'EDATE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  537. 'functionCall' => 'PHPExcel_Calculation_Functions::EDATE',
  538. 'argumentCount' => '2'
  539. ),
  540. 'EFFECT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  541. 'functionCall' => 'PHPExcel_Calculation_Functions::EFFECT',
  542. 'argumentCount' => '2'
  543. ),
  544. 'EOMONTH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  545. 'functionCall' => 'PHPExcel_Calculation_Functions::EOMONTH',
  546. 'argumentCount' => '2'
  547. ),
  548. 'ERF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  549. 'functionCall' => 'PHPExcel_Calculation_Functions::ERF',
  550. 'argumentCount' => '1,2'
  551. ),
  552. 'ERFC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  553. 'functionCall' => 'PHPExcel_Calculation_Functions::ERFC',
  554. 'argumentCount' => '1'
  555. ),
  556. 'ERROR.TYPE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  557. 'functionCall' => 'PHPExcel_Calculation_Functions::ERROR_TYPE',
  558. 'argumentCount' => '1'
  559. ),
  560. 'EVEN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  561. 'functionCall' => 'PHPExcel_Calculation_Functions::EVEN',
  562. 'argumentCount' => '1'
  563. ),
  564. 'EXACT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  565. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  566. 'argumentCount' => '2'
  567. ),
  568. 'EXP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  569. 'functionCall' => 'exp',
  570. 'argumentCount' => '1'
  571. ),
  572. 'EXPONDIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  573. 'functionCall' => 'PHPExcel_Calculation_Functions::EXPONDIST',
  574. 'argumentCount' => '3'
  575. ),
  576. 'FACT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  577. 'functionCall' => 'PHPExcel_Calculation_Functions::FACT',
  578. 'argumentCount' => '1'
  579. ),
  580. 'FACTDOUBLE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  581. 'functionCall' => 'PHPExcel_Calculation_Functions::FACTDOUBLE',
  582. 'argumentCount' => '1'
  583. ),
  584. 'FALSE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOGICAL,
  585. 'functionCall' => 'PHPExcel_Calculation_Functions::LOGICAL_FALSE',
  586. 'argumentCount' => '0'
  587. ),
  588. 'FDIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  589. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  590. 'argumentCount' => '3'
  591. ),
  592. 'FIND' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  593. 'functionCall' => 'PHPExcel_Calculation_Functions::SEARCHSENSITIVE',
  594. 'argumentCount' => '2,3'
  595. ),
  596. 'FINDB' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  597. 'functionCall' => 'PHPExcel_Calculation_Functions::SEARCHSENSITIVE',
  598. 'argumentCount' => '2,3'
  599. ),
  600. 'FINV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  601. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  602. 'argumentCount' => '3'
  603. ),
  604. 'FISHER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  605. 'functionCall' => 'PHPExcel_Calculation_Functions::FISHER',
  606. 'argumentCount' => '1'
  607. ),
  608. 'FISHERINV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  609. 'functionCall' => 'PHPExcel_Calculation_Functions::FISHERINV',
  610. 'argumentCount' => '1'
  611. ),
  612. 'FIXED' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  613. 'functionCall' => 'PHPExcel_Calculation_Functions::FIXEDFORMAT',
  614. 'argumentCount' => '1-3'
  615. ),
  616. 'FLOOR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  617. 'functionCall' => 'PHPExcel_Calculation_Functions::FLOOR',
  618. 'argumentCount' => '2'
  619. ),
  620. 'FORECAST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  621. 'functionCall' => 'PHPExcel_Calculation_Functions::FORECAST',
  622. 'argumentCount' => '3'
  623. ),
  624. 'FREQUENCY' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  625. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  626. 'argumentCount' => '2'
  627. ),
  628. 'FTEST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  629. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  630. 'argumentCount' => '2'
  631. ),
  632. 'FV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  633. 'functionCall' => 'PHPExcel_Calculation_Functions::FV',
  634. 'argumentCount' => '3-5'
  635. ),
  636. 'FVSCHEDULE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  637. 'functionCall' => 'PHPExcel_Calculation_Functions::FVSCHEDULE',
  638. 'argumentCount' => '2'
  639. ),
  640. 'GAMMADIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  641. 'functionCall' => 'PHPExcel_Calculation_Functions::GAMMADIST',
  642. 'argumentCount' => '4'
  643. ),
  644. 'GAMMAINV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  645. 'functionCall' => 'PHPExcel_Calculation_Functions::GAMMAINV',
  646. 'argumentCount' => '3'
  647. ),
  648. 'GAMMALN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  649. 'functionCall' => 'PHPExcel_Calculation_Functions::GAMMALN',
  650. 'argumentCount' => '1'
  651. ),
  652. 'GCD' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  653. 'functionCall' => 'PHPExcel_Calculation_Functions::GCD',
  654. 'argumentCount' => '1+'
  655. ),
  656. 'GEOMEAN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  657. 'functionCall' => 'PHPExcel_Calculation_Functions::GEOMEAN',
  658. 'argumentCount' => '1+'
  659. ),
  660. 'GESTEP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  661. 'functionCall' => 'PHPExcel_Calculation_Functions::GESTEP',
  662. 'argumentCount' => '1,2'
  663. ),
  664. 'GETPIVOTDATA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  665. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  666. 'argumentCount' => '2+'
  667. ),
  668. 'GROWTH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  669. 'functionCall' => 'PHPExcel_Calculation_Functions::GROWTH',
  670. 'argumentCount' => '1-4'
  671. ),
  672. 'HARMEAN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  673. 'functionCall' => 'PHPExcel_Calculation_Functions::HARMEAN',
  674. 'argumentCount' => '1+'
  675. ),
  676. 'HEX2BIN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  677. 'functionCall' => 'PHPExcel_Calculation_Functions::HEXTOBIN',
  678. 'argumentCount' => '1,2'
  679. ),
  680. 'HEX2DEC' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  681. 'functionCall' => 'PHPExcel_Calculation_Functions::HEXTODEC',
  682. 'argumentCount' => '1'
  683. ),
  684. 'HEX2OCT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  685. 'functionCall' => 'PHPExcel_Calculation_Functions::HEXTOOCT',
  686. 'argumentCount' => '1,2'
  687. ),
  688. 'HLOOKUP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  689. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  690. 'argumentCount' => '3,4'
  691. ),
  692. 'HOUR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_DATE_AND_TIME,
  693. 'functionCall' => 'PHPExcel_Calculation_Functions::HOUROFDAY',
  694. 'argumentCount' => '1'
  695. ),
  696. 'HYPERLINK' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  697. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  698. 'argumentCount' => '1,2'
  699. ),
  700. 'HYPGEOMDIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  701. 'functionCall' => 'PHPExcel_Calculation_Functions::HYPGEOMDIST',
  702. 'argumentCount' => '4'
  703. ),
  704. 'IF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOGICAL,
  705. 'functionCall' => 'PHPExcel_Calculation_Functions::STATEMENT_IF',
  706. 'argumentCount' => '1-3'
  707. ),
  708. 'IFERROR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOGICAL,
  709. 'functionCall' => 'PHPExcel_Calculation_Functions::STATEMENT_IFERROR',
  710. 'argumentCount' => '2'
  711. ),
  712. 'IMABS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  713. 'functionCall' => 'PHPExcel_Calculation_Functions::IMABS',
  714. 'argumentCount' => '1'
  715. ),
  716. 'IMAGINARY' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  717. 'functionCall' => 'PHPExcel_Calculation_Functions::IMAGINARY',
  718. 'argumentCount' => '1'
  719. ),
  720. 'IMARGUMENT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  721. 'functionCall' => 'PHPExcel_Calculation_Functions::IMARGUMENT',
  722. 'argumentCount' => '1'
  723. ),
  724. 'IMCONJUGATE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  725. 'functionCall' => 'PHPExcel_Calculation_Functions::IMCONJUGATE',
  726. 'argumentCount' => '1'
  727. ),
  728. 'IMCOS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  729. 'functionCall' => 'PHPExcel_Calculation_Functions::IMCOS',
  730. 'argumentCount' => '1'
  731. ),
  732. 'IMDIV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  733. 'functionCall' => 'PHPExcel_Calculation_Functions::IMDIV',
  734. 'argumentCount' => '2'
  735. ),
  736. 'IMEXP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  737. 'functionCall' => 'PHPExcel_Calculation_Functions::IMEXP',
  738. 'argumentCount' => '1'
  739. ),
  740. 'IMLN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  741. 'functionCall' => 'PHPExcel_Calculation_Functions::IMLN',
  742. 'argumentCount' => '1'
  743. ),
  744. 'IMLOG10' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  745. 'functionCall' => 'PHPExcel_Calculation_Functions::IMLOG10',
  746. 'argumentCount' => '1'
  747. ),
  748. 'IMLOG2' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  749. 'functionCall' => 'PHPExcel_Calculation_Functions::IMLOG2',
  750. 'argumentCount' => '1'
  751. ),
  752. 'IMPOWER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  753. 'functionCall' => 'PHPExcel_Calculation_Functions::IMPOWER',
  754. 'argumentCount' => '2'
  755. ),
  756. 'IMPRODUCT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  757. 'functionCall' => 'PHPExcel_Calculation_Functions::IMPRODUCT',
  758. 'argumentCount' => '1+'
  759. ),
  760. 'IMREAL' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  761. 'functionCall' => 'PHPExcel_Calculation_Functions::IMREAL',
  762. 'argumentCount' => '1'
  763. ),
  764. 'IMSIN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  765. 'functionCall' => 'PHPExcel_Calculation_Functions::IMSIN',
  766. 'argumentCount' => '1'
  767. ),
  768. 'IMSQRT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  769. 'functionCall' => 'PHPExcel_Calculation_Functions::IMSQRT',
  770. 'argumentCount' => '1'
  771. ),
  772. 'IMSUB' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  773. 'functionCall' => 'PHPExcel_Calculation_Functions::IMSUB',
  774. 'argumentCount' => '2'
  775. ),
  776. 'IMSUM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_ENGINEERING,
  777. 'functionCall' => 'PHPExcel_Calculation_Functions::IMSUM',
  778. 'argumentCount' => '1+'
  779. ),
  780. 'INDEX' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  781. 'functionCall' => 'PHPExcel_Calculation_Functions::INDEX',
  782. 'argumentCount' => '1-4'
  783. ),
  784. 'INDIRECT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  785. 'functionCall' => 'PHPExcel_Calculation_Functions::INDIRECT',
  786. 'argumentCount' => '1,2',
  787. 'passCellReference'=> true
  788. ),
  789. 'INFO' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  790. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  791. 'argumentCount' => '1'
  792. ),
  793. 'INT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  794. 'functionCall' => 'PHPExcel_Calculation_Functions::INTVALUE',
  795. 'argumentCount' => '1'
  796. ),
  797. 'INTERCEPT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  798. 'functionCall' => 'PHPExcel_Calculation_Functions::INTERCEPT',
  799. 'argumentCount' => '2'
  800. ),
  801. 'INTRATE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  802. 'functionCall' => 'PHPExcel_Calculation_Functions::INTRATE',
  803. 'argumentCount' => '4,5'
  804. ),
  805. 'IPMT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  806. 'functionCall' => 'PHPExcel_Calculation_Functions::IPMT',
  807. 'argumentCount' => '4-6'
  808. ),
  809. 'IRR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  810. 'functionCall' => 'PHPExcel_Calculation_Functions::IRR',
  811. 'argumentCount' => '1,2'
  812. ),
  813. 'ISBLANK' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  814. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_BLANK',
  815. 'argumentCount' => '1'
  816. ),
  817. 'ISERR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  818. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_ERR',
  819. 'argumentCount' => '1'
  820. ),
  821. 'ISERROR' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  822. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_ERROR',
  823. 'argumentCount' => '1'
  824. ),
  825. 'ISEVEN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  826. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_EVEN',
  827. 'argumentCount' => '1'
  828. ),
  829. 'ISLOGICAL' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  830. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_LOGICAL',
  831. 'argumentCount' => '1'
  832. ),
  833. 'ISNA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  834. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_NA',
  835. 'argumentCount' => '1'
  836. ),
  837. 'ISNONTEXT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  838. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_NONTEXT',
  839. 'argumentCount' => '1'
  840. ),
  841. 'ISNUMBER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  842. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_NUMBER',
  843. 'argumentCount' => '1'
  844. ),
  845. 'ISODD' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  846. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_ODD',
  847. 'argumentCount' => '1'
  848. ),
  849. 'ISPMT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  850. 'functionCall' => 'PHPExcel_Calculation_Functions::ISPMT',
  851. 'argumentCount' => '4'
  852. ),
  853. 'ISREF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  854. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  855. 'argumentCount' => '1'
  856. ),
  857. 'ISTEXT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_INFORMATION,
  858. 'functionCall' => 'PHPExcel_Calculation_Functions::IS_TEXT',
  859. 'argumentCount' => '1'
  860. ),
  861. 'JIS' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  862. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  863. 'argumentCount' => '1'
  864. ),
  865. 'KURT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  866. 'functionCall' => 'PHPExcel_Calculation_Functions::KURT',
  867. 'argumentCount' => '1+'
  868. ),
  869. 'LARGE' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  870. 'functionCall' => 'PHPExcel_Calculation_Functions::LARGE',
  871. 'argumentCount' => '2'
  872. ),
  873. 'LCM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  874. 'functionCall' => 'PHPExcel_Calculation_Functions::LCM',
  875. 'argumentCount' => '1+'
  876. ),
  877. 'LEFT' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  878. 'functionCall' => 'PHPExcel_Calculation_Functions::LEFT',
  879. 'argumentCount' => '1,2'
  880. ),
  881. 'LEFTB' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  882. 'functionCall' => 'PHPExcel_Calculation_Functions::LEFT',
  883. 'argumentCount' => '1,2'
  884. ),
  885. 'LEN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  886. 'functionCall' => 'PHPExcel_Calculation_Functions::STRINGLENGTH',
  887. 'argumentCount' => '1'
  888. ),
  889. 'LENB' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  890. 'functionCall' => 'PHPExcel_Calculation_Functions::STRINGLENGTH',
  891. 'argumentCount' => '1'
  892. ),
  893. 'LINEST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  894. 'functionCall' => 'PHPExcel_Calculation_Functions::LINEST',
  895. 'argumentCount' => '1-4'
  896. ),
  897. 'LN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  898. 'functionCall' => 'log',
  899. 'argumentCount' => '1'
  900. ),
  901. 'LOG' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  902. 'functionCall' => 'PHPExcel_Calculation_Functions::LOG_BASE',
  903. 'argumentCount' => '1,2'
  904. ),
  905. 'LOG10' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  906. 'functionCall' => 'log10',
  907. 'argumentCount' => '1'
  908. ),
  909. 'LOGEST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  910. 'functionCall' => 'PHPExcel_Calculation_Functions::LOGEST',
  911. 'argumentCount' => '1-4'
  912. ),
  913. 'LOGINV' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  914. 'functionCall' => 'PHPExcel_Calculation_Functions::LOGINV',
  915. 'argumentCount' => '3'
  916. ),
  917. 'LOGNORMDIST' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  918. 'functionCall' => 'PHPExcel_Calculation_Functions::LOGNORMDIST',
  919. 'argumentCount' => '3'
  920. ),
  921. 'LOOKUP' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  922. 'functionCall' => 'PHPExcel_Calculation_Functions::LOOKUP',
  923. 'argumentCount' => '2,3'
  924. ),
  925. 'LOWER' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEXT_AND_DATA,
  926. 'functionCall' => 'PHPExcel_Calculation_Functions::LOWERCASE',
  927. 'argumentCount' => '1'
  928. ),
  929. 'MATCH' => array('category' => PHPExcel_Calculation_Function::CATEGORY_LOOKUP_AND_REFERENCE,
  930. 'functionCall' => 'PHPExcel_Calculation_Functions::MATCH',
  931. 'argumentCount' => '2,3'
  932. ),
  933. 'MAX' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  934. 'functionCall' => 'PHPExcel_Calculation_Functions::MAX',
  935. 'argumentCount' => '1+'
  936. ),
  937. 'MAXA' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  938. 'functionCall' => 'PHPExcel_Calculation_Functions::MAXA',
  939. 'argumentCount' => '1+'
  940. ),
  941. 'MAXIF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  942. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  943. 'argumentCount' => '2+'
  944. ),
  945. 'MDETERM' => array('category' => PHPExcel_Calculation_Function::CATEGORY_MATH_AND_TRIG,
  946. 'functionCall' => 'PHPExcel_Calculation_Functions::MDETERM',
  947. 'argumentCount' => '1'
  948. ),
  949. 'MDURATION' => array('category' => PHPExcel_Calculation_Function::CATEGORY_FINANCIAL,
  950. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  951. 'argumentCount' => '5,6'
  952. ),
  953. 'MEDIAN' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  954. 'functionCall' => 'PHPExcel_Calculation_Functions::MEDIAN',
  955. 'argumentCount' => '1+'
  956. ),
  957. 'MEDIANIF' => array('category' => PHPExcel_Calculation_Function::CATEGORY_STATISTICAL,
  958. 'functionCall' => 'PHPExcel_Calculation_Functions::DUMMY',
  959. 'argumentCount' => '2+'
  960. ),
  961. 'MID' => array('category' => PHPExcel_Calculation_Function::CATEGORY_TEX

Large files files are truncated, but you can click here to view the full file