CellTest Class Reference

Inheritance diagram for CellTest:

Collaboration diagram for CellTest:

Public Member Functions
	setUp ()
	testColumnIndexFromString ()
	providerColumnString More...
	providerColumnString ()
	testColumnIndexFromStringTooLong ()
	testColumnIndexFromStringTooShort ()
	testStringFromColumnIndex ()
	providerColumnIndex More...
	providerColumnIndex ()
	testCoordinateFromString ()
	providerCoordinates More...
	providerCoordinates ()
	testCoordinateFromStringWithRangeAddress ()
	testCoordinateFromStringWithEmptyAddress ()
	testCoordinateFromStringWithInvalidAddress ()
	testAbsoluteCoordinateFromString ()
	providerAbsoluteCoordinates More...
	providerAbsoluteCoordinates ()
	testAbsoluteCoordinateFromStringWithRangeAddress ()
	testAbsoluteReferenceFromString ()
	providerAbsoluteReferences More...
	providerAbsoluteReferences ()
	testAbsoluteReferenceFromStringWithRangeAddress ()
	testSplitRange ()
	providerSplitRange More...
	providerSplitRange ()
	testBuildRange ()
	providerBuildRange More...
	providerBuildRange ()
	testBuildRangeInvalid ()
	testRangeBoundaries ()
	providerRangeBoundaries More...
	providerRangeBoundaries ()
	testRangeDimension ()
	providerRangeDimension More...
	providerRangeDimension ()
	testGetRangeBoundaries ()
	providerGetRangeBoundaries More...
	providerGetRangeBoundaries ()
	testExtractAllCellReferencesInRange ()
	providerExtractAllCellReferencesInRange More...
	providerExtractAllCellReferencesInRange ()

Detailed Description

Definition at line 6 of file CellTest.php.

Member Function Documentation

providerAbsoluteCoordinates()

CellTest::providerAbsoluteCoordinates

(

)

Definition at line 136 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellAbsoluteCoordinate.data');
        }

providerAbsoluteReferences()

CellTest::providerAbsoluteReferences

(

)

Definition at line 164 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellAbsoluteReference.data');
        }

providerBuildRange()

CellTest::providerBuildRange

(

)

Definition at line 214 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellBuildRange.data');
        }

providerColumnIndex()

CellTest::providerColumnIndex

(

)

Definition at line 68 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/ColumnIndex.data');
        }

providerColumnString()

CellTest::providerColumnString

(

)

Definition at line 28 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/ColumnString.data');
        }

providerCoordinates()

CellTest::providerCoordinates

(

)

Definition at line 84 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellCoordinates.data');
        }

providerExtractAllCellReferencesInRange()

CellTest::providerExtractAllCellReferencesInRange

(

)

Definition at line 290 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellExtractAllCellReferencesInRange.data');
        }

providerGetRangeBoundaries()

CellTest::providerGetRangeBoundaries

(

)

Definition at line 274 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellGetRangeBoundaries.data');
        }

providerRangeBoundaries()

CellTest::providerRangeBoundaries

(

)

Definition at line 242 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellRangeBoundaries.data');
        }

providerRangeDimension()

CellTest::providerRangeDimension

(

)

Definition at line 258 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellRangeDimension.data');
        }

providerSplitRange()

CellTest::providerSplitRange

(

)

Definition at line 198 of file CellTest.php.

    {
        return new testDataFileIterator('rawTestData/CellSplitRange.data');
        }

setUp()

CellTest::setUp

(

)

Definition at line 9 of file CellTest.php.

References defined.

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

testAbsoluteCoordinateFromString()

CellTest::testAbsoluteCoordinateFromString

(

)

providerAbsoluteCoordinates

Definition at line 128 of file CellTest.php.

References $result, and array.

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

testAbsoluteCoordinateFromStringWithRangeAddress()

CellTest::testAbsoluteCoordinateFromStringWithRangeAddress

(

)

Definition at line 141 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = 'A1:AI2012';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','absoluteCoordinate'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Cell coordinate string can not be a range of cells');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testAbsoluteReferenceFromString()

CellTest::testAbsoluteReferenceFromString

(

)

providerAbsoluteReferences

Definition at line 156 of file CellTest.php.

References $result, and array.

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

testAbsoluteReferenceFromStringWithRangeAddress()

CellTest::testAbsoluteReferenceFromStringWithRangeAddress

(

)

Definition at line 169 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = 'A1:AI2012';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','absoluteReference'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Cell coordinate string can not be a range of cells');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testBuildRange()

CellTest::testBuildRange

(

)

providerBuildRange

Definition at line 206 of file CellTest.php.

References $result, and array.

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

testBuildRangeInvalid()

CellTest::testBuildRangeInvalid

(

)

Definition at line 219 of file CellTest.php.

References $result, and array.

        {
                $cellRange = '';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','buildRange'),$cellRange);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Range does not contain any information');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testColumnIndexFromString()

CellTest::testColumnIndexFromString

(

)

providerColumnString

Definition at line 20 of file CellTest.php.

References $result, and array.

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

testColumnIndexFromStringTooLong()

CellTest::testColumnIndexFromStringTooLong

(

)

Definition at line 33 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = 'ABCD';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','columnIndexFromString'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Column string index can not be longer than 3 characters');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testColumnIndexFromStringTooShort()

CellTest::testColumnIndexFromStringTooShort

(

)

Definition at line 45 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = '';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','columnIndexFromString'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Column string index can not be empty');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testCoordinateFromString()

CellTest::testCoordinateFromString

(

)

providerCoordinates

Definition at line 76 of file CellTest.php.

References $result, and array.

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

testCoordinateFromStringWithEmptyAddress()

CellTest::testCoordinateFromStringWithEmptyAddress

(

)

Definition at line 101 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = '';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','coordinateFromString'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Cell coordinate can not be zero-length string');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testCoordinateFromStringWithInvalidAddress()

CellTest::testCoordinateFromStringWithInvalidAddress

(

)

Definition at line 113 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = 'AI';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','coordinateFromString'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Invalid cell coordinate '.$cellAddress);
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testCoordinateFromStringWithRangeAddress()

CellTest::testCoordinateFromStringWithRangeAddress

(

)

Definition at line 89 of file CellTest.php.

References $result, and array.

        {
                $cellAddress = 'A1:AI2012';
                try {
                        $result = call_user_func(array('PHPExcel_Cell','coordinateFromString'),$cellAddress);
                } catch (PHPExcel_Exception $e) {
                        $this->assertEquals($e->getMessage(), 'Cell coordinate string can not be a range of cells');
                        return;
                }
                $this->fail('An expected exception has not been raised.');
        }

testExtractAllCellReferencesInRange()

CellTest::testExtractAllCellReferencesInRange

(

)

providerExtractAllCellReferencesInRange

Definition at line 282 of file CellTest.php.

References $result, and array.

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

testGetRangeBoundaries()

CellTest::testGetRangeBoundaries

(

)

providerGetRangeBoundaries

Definition at line 266 of file CellTest.php.

References $result, and array.

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

testRangeBoundaries()

CellTest::testRangeBoundaries

(

)

providerRangeBoundaries

Definition at line 234 of file CellTest.php.

References $result, and array.

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

testRangeDimension()

CellTest::testRangeDimension

(

)

providerRangeDimension

Definition at line 250 of file CellTest.php.

References $result, and array.

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

testSplitRange()

CellTest::testSplitRange

(

)

providerSplitRange

Definition at line 184 of file CellTest.php.

References $result, and array.

        {
                $args = func_get_args();
                $expectedResult = array_pop($args);
                $result = call_user_func_array(array('PHPExcel_Cell','splitRange'),$args);
                foreach($result as $key => $split) {
                        if (!is_array($expectedResult[$key])) {
                                $this->assertEquals($expectedResult[$key], $split[0]);
                        } else {
                                $this->assertEquals($expectedResult[$key], $split);
                        }
                }
        }

testStringFromColumnIndex()

CellTest::testStringFromColumnIndex

(

)

providerColumnIndex

Definition at line 60 of file CellTest.php.

References $result, and array.

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

---

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

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