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

Public Member Functions

 setUp ()
 
 testCHAR ()
 @dataProvider providerCHAR More...
 
 providerCHAR ()
 
 testCODE ()
 @dataProvider providerCODE More...
 
 providerCODE ()
 
 testCONCATENATE ()
 @dataProvider providerCONCATENATE More...
 
 providerCONCATENATE ()
 
 testLEFT ()
 @dataProvider providerLEFT More...
 
 providerLEFT ()
 
 testMID ()
 @dataProvider providerMID More...
 
 providerMID ()
 
 testRIGHT ()
 @dataProvider providerRIGHT More...
 
 providerRIGHT ()
 
 testLOWER ()
 @dataProvider providerLOWER More...
 
 providerLOWER ()
 
 testUPPER ()
 @dataProvider providerUPPER More...
 
 providerUPPER ()
 
 testPROPER ()
 @dataProvider providerPROPER More...
 
 providerPROPER ()
 
 testLEN ()
 @dataProvider providerLEN More...
 
 providerLEN ()
 
 testSEARCH ()
 @dataProvider providerSEARCH More...
 
 providerSEARCH ()
 
 testFIND ()
 @dataProvider providerFIND More...
 
 providerFIND ()
 
 testREPLACE ()
 @dataProvider providerREPLACE More...
 
 providerREPLACE ()
 
 testSUBSTITUTE ()
 @dataProvider providerSUBSTITUTE More...
 
 providerSUBSTITUTE ()
 
 testTRIM ()
 @dataProvider providerTRIM More...
 
 providerTRIM ()
 
 testCLEAN ()
 @dataProvider providerCLEAN More...
 
 providerCLEAN ()
 
 testDOLLAR ()
 @dataProvider providerDOLLAR More...
 
 providerDOLLAR ()
 
 testFIXED ()
 @dataProvider providerFIXED More...
 
 providerFIXED ()
 
 testT ()
 @dataProvider providerT More...
 
 providerT ()
 
 testTEXT ()
 @dataProvider providerTEXT More...
 
 providerTEXT ()
 
 testVALUE ()
 @dataProvider providerVALUE More...
 
 providerVALUE ()
 

Detailed Description

Definition at line 6 of file TextDataTest.php.

Member Function Documentation

◆ providerCHAR()

TextDataTest::providerCHAR ( )

Definition at line 31 of file TextDataTest.php.

32 {
33 return new testDataFileIterator('rawTestData/Calculation/TextData/CHAR.data');
34 }

◆ providerCLEAN()

TextDataTest::providerCLEAN ( )

Definition at line 271 of file TextDataTest.php.

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

◆ providerCODE()

TextDataTest::providerCODE ( )

Definition at line 47 of file TextDataTest.php.

48 {
49 return new testDataFileIterator('rawTestData/Calculation/TextData/CODE.data');
50 }

◆ providerCONCATENATE()

TextDataTest::providerCONCATENATE ( )

Definition at line 63 of file TextDataTest.php.

64 {
65 return new testDataFileIterator('rawTestData/Calculation/TextData/CONCATENATE.data');
66 }

◆ providerDOLLAR()

TextDataTest::providerDOLLAR ( )

Definition at line 287 of file TextDataTest.php.

288 {
289 return new testDataFileIterator('rawTestData/Calculation/TextData/DOLLAR.data');
290 }

◆ providerFIND()

TextDataTest::providerFIND ( )

Definition at line 207 of file TextDataTest.php.

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

◆ providerFIXED()

TextDataTest::providerFIXED ( )

Definition at line 303 of file TextDataTest.php.

304 {
305 return new testDataFileIterator('rawTestData/Calculation/TextData/FIXED.data');
306 }

◆ providerLEFT()

TextDataTest::providerLEFT ( )

Definition at line 79 of file TextDataTest.php.

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

◆ providerLEN()

TextDataTest::providerLEN ( )

Definition at line 175 of file TextDataTest.php.

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

◆ providerLOWER()

TextDataTest::providerLOWER ( )

Definition at line 127 of file TextDataTest.php.

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

◆ providerMID()

TextDataTest::providerMID ( )

Definition at line 95 of file TextDataTest.php.

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

◆ providerPROPER()

TextDataTest::providerPROPER ( )

Definition at line 159 of file TextDataTest.php.

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

◆ providerREPLACE()

TextDataTest::providerREPLACE ( )

Definition at line 223 of file TextDataTest.php.

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

◆ providerRIGHT()

TextDataTest::providerRIGHT ( )

Definition at line 111 of file TextDataTest.php.

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

◆ providerSEARCH()

TextDataTest::providerSEARCH ( )

Definition at line 191 of file TextDataTest.php.

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

◆ providerSUBSTITUTE()

TextDataTest::providerSUBSTITUTE ( )

Definition at line 239 of file TextDataTest.php.

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

◆ providerT()

TextDataTest::providerT ( )

Definition at line 319 of file TextDataTest.php.

320 {
321 return new testDataFileIterator('rawTestData/Calculation/TextData/T.data');
322 }

◆ providerTEXT()

TextDataTest::providerTEXT ( )

Definition at line 340 of file TextDataTest.php.

341 {
342 return new testDataFileIterator('rawTestData/Calculation/TextData/TEXT.data');
343 }

◆ providerTRIM()

TextDataTest::providerTRIM ( )

Definition at line 255 of file TextDataTest.php.

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

◆ providerUPPER()

TextDataTest::providerUPPER ( )

Definition at line 143 of file TextDataTest.php.

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

◆ providerVALUE()

TextDataTest::providerVALUE ( )

Definition at line 360 of file TextDataTest.php.

361 {
362 return new testDataFileIterator('rawTestData/Calculation/TextData/VALUE.data');
363 }

◆ setUp()

TextDataTest::setUp ( )

Definition at line 9 of file TextDataTest.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:

◆ testCHAR()

TextDataTest::testCHAR ( )

@dataProvider providerCHAR

Definition at line 23 of file TextDataTest.php.

24 {
25 $args = func_get_args();
26 $expectedResult = array_pop($args);
27 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','CHARACTER'),$args);
28 $this->assertEquals($expectedResult, $result);
29 }
$result
$result
Definition: CleanUpTest.php:463

References $result.

◆ testCLEAN()

TextDataTest::testCLEAN ( )

@dataProvider providerCLEAN

Definition at line 263 of file TextDataTest.php.

264 {
265 $args = func_get_args();
266 $expectedResult = array_pop($args);
267 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','TRIMNONPRINTABLE'),$args);
268 $this->assertEquals($expectedResult, $result);
269 }

References $result.

◆ testCODE()

TextDataTest::testCODE ( )

@dataProvider providerCODE

Definition at line 39 of file TextDataTest.php.

40 {
41 $args = func_get_args();
42 $expectedResult = array_pop($args);
43 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','ASCIICODE'),$args);
44 $this->assertEquals($expectedResult, $result);
45 }

References $result.

◆ testCONCATENATE()

TextDataTest::testCONCATENATE ( )

@dataProvider providerCONCATENATE

Definition at line 55 of file TextDataTest.php.

56 {
57 $args = func_get_args();
58 $expectedResult = array_pop($args);
59 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','CONCATENATE'),$args);
60 $this->assertEquals($expectedResult, $result);
61 }

References $result.

◆ testDOLLAR()

TextDataTest::testDOLLAR ( )

@dataProvider providerDOLLAR

Definition at line 279 of file TextDataTest.php.

280 {
281 $args = func_get_args();
282 $expectedResult = array_pop($args);
283 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','DOLLAR'),$args);
284 $this->assertEquals($expectedResult, $result);
285 }

References $result.

◆ testFIND()

TextDataTest::testFIND ( )

@dataProvider providerFIND

Definition at line 199 of file TextDataTest.php.

200 {
201 $args = func_get_args();
202 $expectedResult = array_pop($args);
203 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','SEARCHSENSITIVE'),$args);
204 $this->assertEquals($expectedResult, $result);
205 }

References $result.

◆ testFIXED()

TextDataTest::testFIXED ( )

@dataProvider providerFIXED

Definition at line 295 of file TextDataTest.php.

296 {
297 $args = func_get_args();
298 $expectedResult = array_pop($args);
299 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','FIXEDFORMAT'),$args);
300 $this->assertEquals($expectedResult, $result);
301 }

References $result.

◆ testLEFT()

TextDataTest::testLEFT ( )

@dataProvider providerLEFT

Definition at line 71 of file TextDataTest.php.

72 {
73 $args = func_get_args();
74 $expectedResult = array_pop($args);
75 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','LEFT'),$args);
76 $this->assertEquals($expectedResult, $result);
77 }

References $result.

◆ testLEN()

TextDataTest::testLEN ( )

@dataProvider providerLEN

Definition at line 167 of file TextDataTest.php.

168 {
169 $args = func_get_args();
170 $expectedResult = array_pop($args);
171 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','STRINGLENGTH'),$args);
172 $this->assertEquals($expectedResult, $result);
173 }

References $result.

◆ testLOWER()

TextDataTest::testLOWER ( )

@dataProvider providerLOWER

Definition at line 119 of file TextDataTest.php.

120 {
121 $args = func_get_args();
122 $expectedResult = array_pop($args);
123 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','LOWERCASE'),$args);
124 $this->assertEquals($expectedResult, $result);
125 }

References $result.

◆ testMID()

TextDataTest::testMID ( )

@dataProvider providerMID

Definition at line 87 of file TextDataTest.php.

88 {
89 $args = func_get_args();
90 $expectedResult = array_pop($args);
91 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','MID'),$args);
92 $this->assertEquals($expectedResult, $result);
93 }

References $result.

◆ testPROPER()

TextDataTest::testPROPER ( )

@dataProvider providerPROPER

Definition at line 151 of file TextDataTest.php.

152 {
153 $args = func_get_args();
154 $expectedResult = array_pop($args);
155 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','PROPERCASE'),$args);
156 $this->assertEquals($expectedResult, $result);
157 }

References $result.

◆ testREPLACE()

TextDataTest::testREPLACE ( )

@dataProvider providerREPLACE

Definition at line 215 of file TextDataTest.php.

216 {
217 $args = func_get_args();
218 $expectedResult = array_pop($args);
219 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','REPLACE'),$args);
220 $this->assertEquals($expectedResult, $result);
221 }

References $result.

◆ testRIGHT()

TextDataTest::testRIGHT ( )

@dataProvider providerRIGHT

Definition at line 103 of file TextDataTest.php.

104 {
105 $args = func_get_args();
106 $expectedResult = array_pop($args);
107 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','RIGHT'),$args);
108 $this->assertEquals($expectedResult, $result);
109 }

References $result.

◆ testSEARCH()

TextDataTest::testSEARCH ( )

@dataProvider providerSEARCH

Definition at line 183 of file TextDataTest.php.

184 {
185 $args = func_get_args();
186 $expectedResult = array_pop($args);
187 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','SEARCHINSENSITIVE'),$args);
188 $this->assertEquals($expectedResult, $result);
189 }

References $result.

◆ testSUBSTITUTE()

TextDataTest::testSUBSTITUTE ( )

@dataProvider providerSUBSTITUTE

Definition at line 231 of file TextDataTest.php.

232 {
233 $args = func_get_args();
234 $expectedResult = array_pop($args);
235 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','SUBSTITUTE'),$args);
236 $this->assertEquals($expectedResult, $result);
237 }

References $result.

◆ testT()

TextDataTest::testT ( )

@dataProvider providerT

Definition at line 311 of file TextDataTest.php.

312 {
313 $args = func_get_args();
314 $expectedResult = array_pop($args);
315 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','RETURNSTRING'),$args);
316 $this->assertEquals($expectedResult, $result);
317 }

References $result.

◆ testTEXT()

TextDataTest::testTEXT ( )

@dataProvider providerTEXT

Definition at line 327 of file TextDataTest.php.

328 {
329 // Enforce decimal and thousands separator values to UK/US, and currency code to USD
330 call_user_func(array('PHPExcel_Shared_String','setDecimalSeparator'),'.');
331 call_user_func(array('PHPExcel_Shared_String','setThousandsSeparator'),',');
332 call_user_func(array('PHPExcel_Shared_String','setCurrencyCode'),'$');
333
334 $args = func_get_args();
335 $expectedResult = array_pop($args);
336 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','TEXTFORMAT'),$args);
337 $this->assertEquals($expectedResult, $result);
338 }

References $result.

◆ testTRIM()

TextDataTest::testTRIM ( )

@dataProvider providerTRIM

Definition at line 247 of file TextDataTest.php.

248 {
249 $args = func_get_args();
250 $expectedResult = array_pop($args);
251 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','TRIMSPACES'),$args);
252 $this->assertEquals($expectedResult, $result);
253 }

References $result.

◆ testUPPER()

TextDataTest::testUPPER ( )

@dataProvider providerUPPER

Definition at line 135 of file TextDataTest.php.

136 {
137 $args = func_get_args();
138 $expectedResult = array_pop($args);
139 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','UPPERCASE'),$args);
140 $this->assertEquals($expectedResult, $result);
141 }

References $result.

◆ testVALUE()

TextDataTest::testVALUE ( )

@dataProvider providerVALUE

Definition at line 348 of file TextDataTest.php.

349 {
350 call_user_func(array('PHPExcel_Shared_String','setDecimalSeparator'),'.');
351 call_user_func(array('PHPExcel_Shared_String','setThousandsSeparator'),' ');
352 call_user_func(array('PHPExcel_Shared_String','setCurrencyCode'),'$');
353
354 $args = func_get_args();
355 $expectedResult = array_pop($args);
356 $result = call_user_func_array(array('PHPExcel_Calculation_TextData','VALUE'),$args);
357 $this->assertEquals($expectedResult, $result, NULL, 1E-8);
358 }

References $result.

The documentation for this class was generated from the following file: