ILIAS  release_5-3 Revision v5.3.23-19-g915713cf615
Public Member Functions
FunctionsTest Class Reference
+ Inheritance diagram for FunctionsTest:
+ Collaboration diagram for FunctionsTest:

Public Member Functions

 setUp ()
 
 testDUMMY ()
 
 testDIV0 ()
 
 testNA ()
 
 testNaN ()
 
 testNAME ()
 
 testREF ()
 
 testNULL ()
 
 testVALUE ()
 
 testIS_BLANK ()
 @dataProvider providerIS_BLANK More...
 
 providerIS_BLANK ()
 
 testIS_ERR ()
 @dataProvider providerIS_ERR More...
 
 providerIS_ERR ()
 
 testIS_ERROR ()
 @dataProvider providerIS_ERROR More...
 
 providerIS_ERROR ()
 
 testERROR_TYPE ()
 @dataProvider providerERROR_TYPE More...
 
 providerERROR_TYPE ()
 
 testIS_LOGICAL ()
 @dataProvider providerIS_LOGICAL More...
 
 providerIS_LOGICAL ()
 
 testIS_NA ()
 @dataProvider providerIS_NA More...
 
 providerIS_NA ()
 
 testIS_NUMBER ()
 @dataProvider providerIS_NUMBER More...
 
 providerIS_NUMBER ()
 
 testIS_TEXT ()
 @dataProvider providerIS_TEXT More...
 
 providerIS_TEXT ()
 
 testIS_NONTEXT ()
 @dataProvider providerIS_NONTEXT More...
 
 providerIS_NONTEXT ()
 
 testIS_EVEN ()
 @dataProvider providerIS_EVEN More...
 
 providerIS_EVEN ()
 
 testIS_ODD ()
 @dataProvider providerIS_ODD More...
 
 providerIS_ODD ()
 
 testTYPE ()
 @dataProvider providerTYPE More...
 
 providerTYPE ()
 
 testN ()
 @dataProvider providerN More...
 
 providerN ()
 

Detailed Description

Definition at line 6 of file FunctionsTest.php.

Member Function Documentation

◆ providerERROR_TYPE()

FunctionsTest::providerERROR_TYPE ( )

Definition at line 127 of file FunctionsTest.php.

128 {
129 return new testDataFileIterator('rawTestData/Calculation/Functions/ERROR_TYPE.data');
130 }

◆ providerIS_BLANK()

FunctionsTest::providerIS_BLANK ( )

Definition at line 79 of file FunctionsTest.php.

80 {
81 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_BLANK.data');
82 }

◆ providerIS_ERR()

FunctionsTest::providerIS_ERR ( )

Definition at line 95 of file FunctionsTest.php.

96 {
97 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_ERR.data');
98 }

◆ providerIS_ERROR()

FunctionsTest::providerIS_ERROR ( )

Definition at line 111 of file FunctionsTest.php.

112 {
113 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_ERROR.data');
114 }

◆ providerIS_EVEN()

FunctionsTest::providerIS_EVEN ( )

Definition at line 223 of file FunctionsTest.php.

224 {
225 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_EVEN.data');
226 }

◆ providerIS_LOGICAL()

FunctionsTest::providerIS_LOGICAL ( )

Definition at line 143 of file FunctionsTest.php.

144 {
145 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_LOGICAL.data');
146 }

◆ providerIS_NA()

FunctionsTest::providerIS_NA ( )

Definition at line 159 of file FunctionsTest.php.

160 {
161 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_NA.data');
162 }

◆ providerIS_NONTEXT()

FunctionsTest::providerIS_NONTEXT ( )

Definition at line 207 of file FunctionsTest.php.

208 {
209 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_NONTEXT.data');
210 }

◆ providerIS_NUMBER()

FunctionsTest::providerIS_NUMBER ( )

Definition at line 175 of file FunctionsTest.php.

176 {
177 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_NUMBER.data');
178 }

◆ providerIS_ODD()

FunctionsTest::providerIS_ODD ( )

Definition at line 239 of file FunctionsTest.php.

240 {
241 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_ODD.data');
242 }

◆ providerIS_TEXT()

FunctionsTest::providerIS_TEXT ( )

Definition at line 191 of file FunctionsTest.php.

192 {
193 return new testDataFileIterator('rawTestData/Calculation/Functions/IS_TEXT.data');
194 }

◆ providerN()

FunctionsTest::providerN ( )

Definition at line 271 of file FunctionsTest.php.

272 {
273 return new testDataFileIterator('rawTestData/Calculation/Functions/N.data');
274 }

◆ providerTYPE()

FunctionsTest::providerTYPE ( )

Definition at line 255 of file FunctionsTest.php.

256 {
257 return new testDataFileIterator('rawTestData/Calculation/Functions/TYPE.data');
258 }

◆ setUp()

FunctionsTest::setUp ( )

Definition at line 9 of file FunctionsTest.php.

10 {
11 if (!defined('PHPEXCEL_ROOT'))
12 {
13 define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
14 }
15 require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');
16
17 PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
18 }
PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL
const COMPATIBILITY_EXCEL
constants
Definition: Functions.php:62
PHPExcel_Calculation_Functions\setCompatibilityMode
static setCompatibilityMode($compatibilityMode)
Definition: Functions.php:116
defined
defined( 'APPLICATION_ENV')||define( 'APPLICATION_ENV'
Definition: bootstrap.php:27

References PHPExcel_Calculation_Functions\COMPATIBILITY_EXCEL, defined, and PHPExcel_Calculation_Functions\setCompatibilityMode().

+ Here is the call graph for this function:

◆ testDIV0()

FunctionsTest::testDIV0 ( )

Definition at line 26 of file FunctionsTest.php.

27 {
28 $result = PHPExcel_Calculation_Functions::DIV0();
29 $this->assertEquals('#DIV/0!', $result);
30 }
$result
$result
Definition: CleanUpTest.php:463
PHPExcel_Calculation_Functions\DIV0
static DIV0()
Definition: Functions.php:201

References $result, and PHPExcel_Calculation_Functions\DIV0().

+ Here is the call graph for this function:

◆ testDUMMY()

FunctionsTest::testDUMMY ( )

Definition at line 20 of file FunctionsTest.php.

21 {
22 $result = PHPExcel_Calculation_Functions::DUMMY();
23 $this->assertEquals('#Not Yet Implemented', $result);
24 }
PHPExcel_Calculation_Functions\DUMMY
static DUMMY()
Definition: Functions.php:189

References $result, and PHPExcel_Calculation_Functions\DUMMY().

+ Here is the call graph for this function:

◆ testERROR_TYPE()

FunctionsTest::testERROR_TYPE ( )

@dataProvider providerERROR_TYPE

Definition at line 119 of file FunctionsTest.php.

120 {
121 $args = func_get_args();
122 $expectedResult = array_pop($args);
123 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','ERROR_TYPE'),$args);
124 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
125 }

References $result.

◆ testIS_BLANK()

FunctionsTest::testIS_BLANK ( )

@dataProvider providerIS_BLANK

Definition at line 71 of file FunctionsTest.php.

72 {
73 $args = func_get_args();
74 $expectedResult = array_pop($args);
75 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_BLANK'),$args);
76 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
77 }

References $result.

◆ testIS_ERR()

FunctionsTest::testIS_ERR ( )

@dataProvider providerIS_ERR

Definition at line 87 of file FunctionsTest.php.

88 {
89 $args = func_get_args();
90 $expectedResult = array_pop($args);
91 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_ERR'),$args);
92 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
93 }

References $result.

◆ testIS_ERROR()

FunctionsTest::testIS_ERROR ( )

@dataProvider providerIS_ERROR

Definition at line 103 of file FunctionsTest.php.

104 {
105 $args = func_get_args();
106 $expectedResult = array_pop($args);
107 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_ERROR'),$args);
108 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
109 }

References $result.

◆ testIS_EVEN()

FunctionsTest::testIS_EVEN ( )

@dataProvider providerIS_EVEN

Definition at line 215 of file FunctionsTest.php.

216 {
217 $args = func_get_args();
218 $expectedResult = array_pop($args);
219 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_EVEN'),$args);
220 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
221 }

References $result.

◆ testIS_LOGICAL()

FunctionsTest::testIS_LOGICAL ( )

@dataProvider providerIS_LOGICAL

Definition at line 135 of file FunctionsTest.php.

136 {
137 $args = func_get_args();
138 $expectedResult = array_pop($args);
139 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_LOGICAL'),$args);
140 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
141 }

References $result.

◆ testIS_NA()

FunctionsTest::testIS_NA ( )

@dataProvider providerIS_NA

Definition at line 151 of file FunctionsTest.php.

152 {
153 $args = func_get_args();
154 $expectedResult = array_pop($args);
155 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_NA'),$args);
156 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
157 }

References $result.

◆ testIS_NONTEXT()

FunctionsTest::testIS_NONTEXT ( )

@dataProvider providerIS_NONTEXT

Definition at line 199 of file FunctionsTest.php.

200 {
201 $args = func_get_args();
202 $expectedResult = array_pop($args);
203 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_NONTEXT'),$args);
204 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
205 }

References $result.

◆ testIS_NUMBER()

FunctionsTest::testIS_NUMBER ( )

@dataProvider providerIS_NUMBER

Definition at line 167 of file FunctionsTest.php.

168 {
169 $args = func_get_args();
170 $expectedResult = array_pop($args);
171 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_NUMBER'),$args);
172 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
173 }

References $result.

◆ testIS_ODD()

FunctionsTest::testIS_ODD ( )

@dataProvider providerIS_ODD

Definition at line 231 of file FunctionsTest.php.

232 {
233 $args = func_get_args();
234 $expectedResult = array_pop($args);
235 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_ODD'),$args);
236 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
237 }

References $result.

◆ testIS_TEXT()

FunctionsTest::testIS_TEXT ( )

@dataProvider providerIS_TEXT

Definition at line 183 of file FunctionsTest.php.

184 {
185 $args = func_get_args();
186 $expectedResult = array_pop($args);
187 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','IS_TEXT'),$args);
188 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
189 }

References $result.

◆ testN()

FunctionsTest::testN ( )

@dataProvider providerN

Definition at line 263 of file FunctionsTest.php.

264 {
265 $args = func_get_args();
266 $expectedResult = array_pop($args);
267 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','N'),$args);
268 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
269 }

References $result.

◆ testNA()

FunctionsTest::testNA ( )

Definition at line 32 of file FunctionsTest.php.

33 {
34 $result = PHPExcel_Calculation_Functions::NA();
35 $this->assertEquals('#N/A', $result);
36 }
PHPExcel_Calculation_Functions\NA
static NA()
Definition: Functions.php:219

References $result, and PHPExcel_Calculation_Functions\NA().

+ Here is the call graph for this function:

◆ testNAME()

FunctionsTest::testNAME ( )

Definition at line 44 of file FunctionsTest.php.

45 {
46 $result = PHPExcel_Calculation_Functions::NAME();
47 $this->assertEquals('#NAME?', $result);
48 }
PHPExcel_Calculation_Functions\NAME
static NAME()
Definition: Functions.php:247

References $result, and PHPExcel_Calculation_Functions\NAME().

+ Here is the call graph for this function:

◆ testNaN()

FunctionsTest::testNaN ( )

Definition at line 38 of file FunctionsTest.php.

39 {
40 $result = PHPExcel_Calculation_Functions::NaN();
41 $this->assertEquals('#NUM!', $result);
42 }
PHPExcel_Calculation_Functions\NaN
static NaN()
Definition: Functions.php:233

References $result, and PHPExcel_Calculation_Functions\NaN().

+ Here is the call graph for this function:

◆ testNULL()

FunctionsTest::testNULL ( )

Definition at line 56 of file FunctionsTest.php.

57 {
58 $result = PHPExcel_Calculation_Functions::NULL();
59 $this->assertEquals('#NULL!', $result);
60 }
PHPExcel_Calculation_Functions\NULL
static NULL()
Definition: Functions.php:275

References $result, and PHPExcel_Calculation_Functions\NULL().

+ Here is the call graph for this function:

◆ testREF()

FunctionsTest::testREF ( )

Definition at line 50 of file FunctionsTest.php.

51 {
52 $result = PHPExcel_Calculation_Functions::REF();
53 $this->assertEquals('#REF!', $result);
54 }
PHPExcel_Calculation_Functions\REF
static REF()
Definition: Functions.php:261

References $result, and PHPExcel_Calculation_Functions\REF().

+ Here is the call graph for this function:

◆ testTYPE()

FunctionsTest::testTYPE ( )

@dataProvider providerTYPE

Definition at line 247 of file FunctionsTest.php.

248 {
249 $args = func_get_args();
250 $expectedResult = array_pop($args);
251 $result = call_user_func_array(array('PHPExcel_Calculation_Functions','TYPE'),$args);
252 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
253 }

References $result.

◆ testVALUE()

FunctionsTest::testVALUE ( )

Definition at line 62 of file FunctionsTest.php.

63 {
64 $result = PHPExcel_Calculation_Functions::VALUE();
65 $this->assertEquals('#VALUE!', $result);
66 }
PHPExcel_Calculation_Functions\VALUE
static VALUE()
Definition: Functions.php:289

References $result, and PHPExcel_Calculation_Functions\VALUE().

+ Here is the call graph for this function:
The documentation for this class was generated from the following file: