TextDataTest Class Reference

Inheritance diagram for TextDataTest:

Collaboration diagram for TextDataTest:

Public Member Functions
	setUp ()
	testCHAR ()
	providerCHAR More...
	providerCHAR ()
	testCODE ()
	providerCODE More...
	providerCODE ()
	testCONCATENATE ()
	providerCONCATENATE More...
	providerCONCATENATE ()
	testLEFT ()
	providerLEFT More...
	providerLEFT ()
	testMID ()
	providerMID More...
	providerMID ()
	testRIGHT ()
	providerRIGHT More...
	providerRIGHT ()
	testLOWER ()
	providerLOWER More...
	providerLOWER ()
	testUPPER ()
	providerUPPER More...
	providerUPPER ()
	testPROPER ()
	providerPROPER More...
	providerPROPER ()
	testLEN ()
	providerLEN More...
	providerLEN ()
	testSEARCH ()
	providerSEARCH More...
	providerSEARCH ()
	testFIND ()
	providerFIND More...
	providerFIND ()
	testREPLACE ()
	providerREPLACE More...
	providerREPLACE ()
	testSUBSTITUTE ()
	providerSUBSTITUTE More...
	providerSUBSTITUTE ()
	testTRIM ()
	providerTRIM More...
	providerTRIM ()
	testCLEAN ()
	providerCLEAN More...
	providerCLEAN ()
	testDOLLAR ()
	providerDOLLAR More...
	providerDOLLAR ()
	testFIXED ()
	providerFIXED More...
	providerFIXED ()
	testT ()
	providerT More...
	providerT ()
	testTEXT ()
	providerTEXT More...
	providerTEXT ()
	testVALUE ()
	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.

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

providerCLEAN()

TextDataTest::providerCLEAN

(

)

Definition at line 271 of file TextDataTest.php.

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

providerCODE()

TextDataTest::providerCODE

(

)

Definition at line 47 of file TextDataTest.php.

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

providerCONCATENATE()

TextDataTest::providerCONCATENATE

(

)

Definition at line 63 of file TextDataTest.php.

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

providerDOLLAR()

TextDataTest::providerDOLLAR

(

)

Definition at line 287 of file TextDataTest.php.

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

providerFIND()

TextDataTest::providerFIND

(

)

Definition at line 207 of file TextDataTest.php.

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

providerFIXED()

TextDataTest::providerFIXED

(

)

Definition at line 303 of file TextDataTest.php.

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

providerLEFT()

TextDataTest::providerLEFT

(

)

Definition at line 79 of file TextDataTest.php.

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

providerLEN()

TextDataTest::providerLEN

(

)

Definition at line 175 of file TextDataTest.php.

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

providerLOWER()

TextDataTest::providerLOWER

(

)

Definition at line 127 of file TextDataTest.php.

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

providerMID()

TextDataTest::providerMID

(

)

Definition at line 95 of file TextDataTest.php.

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

providerPROPER()

TextDataTest::providerPROPER

(

)

Definition at line 159 of file TextDataTest.php.

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

providerREPLACE()

TextDataTest::providerREPLACE

(

)

Definition at line 223 of file TextDataTest.php.

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

providerRIGHT()

TextDataTest::providerRIGHT

(

)

Definition at line 111 of file TextDataTest.php.

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

providerSEARCH()

TextDataTest::providerSEARCH

(

)

Definition at line 191 of file TextDataTest.php.

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

providerSUBSTITUTE()

TextDataTest::providerSUBSTITUTE

(

)

Definition at line 239 of file TextDataTest.php.

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

providerT()

TextDataTest::providerT

(

)

Definition at line 319 of file TextDataTest.php.

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

providerTEXT()

TextDataTest::providerTEXT

(

)

Definition at line 340 of file TextDataTest.php.

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

providerTRIM()

TextDataTest::providerTRIM

(

)

Definition at line 255 of file TextDataTest.php.

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

providerUPPER()

TextDataTest::providerUPPER

(

)

Definition at line 143 of file TextDataTest.php.

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

providerVALUE()

TextDataTest::providerVALUE

(

)

Definition at line 360 of file TextDataTest.php.

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

setUp()

TextDataTest::setUp

(

)

Definition at line 9 of file TextDataTest.php.

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

    {
        if (!defined('PHPEXCEL_ROOT'))
        {
            define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
        }
        require_once(PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php');

        PHPExcel_Calculation_Functions::setCompatibilityMode(PHPExcel_Calculation_Functions::COMPATIBILITY_EXCEL);
        }

Here is the call graph for this function:

testCHAR()

TextDataTest::testCHAR

(

)

providerCHAR

Definition at line 23 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','CHARACTER'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testCLEAN()

TextDataTest::testCLEAN

(

)

providerCLEAN

Definition at line 263 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','TRIMNONPRINTABLE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testCODE()

TextDataTest::testCODE

(

)

providerCODE

Definition at line 39 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','ASCIICODE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testCONCATENATE()

TextDataTest::testCONCATENATE

(

)

providerCONCATENATE

Definition at line 55 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','CONCATENATE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testDOLLAR()

TextDataTest::testDOLLAR

(

)

providerDOLLAR

Definition at line 279 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','DOLLAR'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testFIND()

TextDataTest::testFIND

(

)

providerFIND

Definition at line 199 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','SEARCHSENSITIVE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testFIXED()

TextDataTest::testFIXED

(

)

providerFIXED

Definition at line 295 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','FIXEDFORMAT'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testLEFT()

TextDataTest::testLEFT

(

)

providerLEFT

Definition at line 71 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','LEFT'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testLEN()

TextDataTest::testLEN

(

)

providerLEN

Definition at line 167 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','STRINGLENGTH'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testLOWER()

TextDataTest::testLOWER

(

)

providerLOWER

Definition at line 119 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','LOWERCASE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testMID()

TextDataTest::testMID

(

)

providerMID

Definition at line 87 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','MID'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testPROPER()

TextDataTest::testPROPER

(

)

providerPROPER

Definition at line 151 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','PROPERCASE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testREPLACE()

TextDataTest::testREPLACE

(

)

providerREPLACE

Definition at line 215 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','REPLACE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testRIGHT()

TextDataTest::testRIGHT

(

)

providerRIGHT

Definition at line 103 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','RIGHT'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testSEARCH()

TextDataTest::testSEARCH

(

)

providerSEARCH

Definition at line 183 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','SEARCHINSENSITIVE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testSUBSTITUTE()

TextDataTest::testSUBSTITUTE

(

)

providerSUBSTITUTE

Definition at line 231 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','SUBSTITUTE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testT()

TextDataTest::testT

(

)

providerT

Definition at line 311 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','RETURNSTRING'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testTEXT()

TextDataTest::testTEXT

(

)

providerTEXT

Definition at line 327 of file TextDataTest.php.

References $result, and array.

        {
                //      Enforce decimal and thousands separator values to UK/US, and currency code to USD
                call_user_func(array('PHPExcel_Shared_String','setDecimalSeparator'),'.');
                call_user_func(array('PHPExcel_Shared_String','setThousandsSeparator'),',');
                call_user_func(array('PHPExcel_Shared_String','setCurrencyCode'),'$');

                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','TEXTFORMAT'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testTRIM()

TextDataTest::testTRIM

(

)

providerTRIM

Definition at line 247 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','TRIMSPACES'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testUPPER()

TextDataTest::testUPPER

(

)

providerUPPER

Definition at line 135 of file TextDataTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','UPPERCASE'),$args);
                $this->assertEquals($expectedResult, $result);
        }

testVALUE()

TextDataTest::testVALUE

(

)

providerVALUE

Definition at line 348 of file TextDataTest.php.

References $result, and array.

        {
                call_user_func(array('PHPExcel_Shared_String','setDecimalSeparator'),'.');
                call_user_func(array('PHPExcel_Shared_String','setThousandsSeparator'),' ');
                call_user_func(array('PHPExcel_Shared_String','setCurrencyCode'),'$');

                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Calculation_TextData','VALUE'),$args);
                $this->assertEquals($expectedResult, $result, NULL, 1E-8);
        }

---

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

• libs/composer/vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/TextDataTest.php