AutoFilterTest Class Reference

Inheritance diagram for AutoFilterTest:

Collaboration diagram for AutoFilterTest:

Public Member Functions
	setUp ()
	testToString ()
	testGetParent ()
	testSetParent ()
	testGetRange ()
	testSetRange ()
	testClearRange ()
	testSetRangeInvalidRange ()
	PHPExcel_Exception More...
	testGetColumnsEmpty ()
	testGetColumnOffset ()
	testGetInvalidColumnOffset ()
	PHPExcel_Exception More...
	testSetColumnWithString ()
	testSetInvalidColumnWithString ()
	PHPExcel_Exception More...
	testSetColumnWithColumnObject ()
	testSetInvalidColumnWithObject ()
	PHPExcel_Exception More...
	testSetColumnWithInvalidDataType ()
	PHPExcel_Exception More...
	testGetColumns ()
	testGetColumn ()
	testGetColumnByOffset ()
	testGetColumnIfNotSet ()
	testGetColumnWithoutRangeSet ()
	PHPExcel_Exception More...
	testClearRangeWithExistingColumns ()
	testSetRangeWithExistingColumns ()
	testClone ()

Private Attributes
	$_testInitialRange = 'H2:O256'
	$_testAutoFilterObject

Detailed Description

Definition at line 4 of file AutoFilterTest.php.

Member Function Documentation

setUp()

AutoFilterTest::setUp

(

)

Definition at line 11 of file AutoFilterTest.php.

References defined.

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

        $this->_mockWorksheetObject = $this->getMockBuilder('PHPExcel_Worksheet')
                ->disableOriginalConstructor()
                ->getMock();
        $this->_mockCacheController = $this->getMockBuilder('PHPExcel_CachedObjectStorage_Memory')
                ->disableOriginalConstructor()
                ->getMock();
        $this->_mockWorksheetObject->expects($this->any())
            ->method('getCellCacheController')
            ->will($this->returnValue($this->_mockCacheController));

                $this->_testAutoFilterObject = new PHPExcel_Worksheet_AutoFilter(
                        $this->_testInitialRange,
                        $this->_mockWorksheetObject
                );
    }

testClearRange()

AutoFilterTest::testClearRange

(

)

Definition at line 82 of file AutoFilterTest.php.

References $result.

        {
                $expectedResult = '';

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterObject->setRange();
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);

                //      Result should be a clear range
                $result = $this->_testAutoFilterObject->getRange();
                $this->assertEquals($expectedResult, $result);
        }

testClearRangeWithExistingColumns()

AutoFilterTest::testClearRangeWithExistingColumns

(

)

Definition at line 275 of file AutoFilterTest.php.

References $result, and array.

        {
                $expectedResult = '';

                $columnIndexes = array('L','M','N');
                foreach($columnIndexes as $columnIndex) {
                        $this->_testAutoFilterObject->setColumn($columnIndex);
                }

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterObject->setRange();
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);

                //      Range should be cleared
                $result = $this->_testAutoFilterObject->getRange();
                $this->assertEquals($expectedResult, $result);

                //      Column array should be cleared
                $result = $this->_testAutoFilterObject->getColumns();
                $this->assertInternalType('array', $result);
                $this->assertEquals(0, count($result));
        }

testClone()

AutoFilterTest::testClone

(

)

Definition at line 328 of file AutoFilterTest.php.

References $_testAutoFilterObject, $result, and array.

        {
                $columnIndexes = array('L','M');

                foreach($columnIndexes as $columnIndex) {
                        $this->_testAutoFilterObject->setColumn($columnIndex);
                }

                $result = clone $this->_testAutoFilterObject;
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);
        }

testGetColumn()

AutoFilterTest::testGetColumn

(

)

Definition at line 224 of file AutoFilterTest.php.

References $result, and array.

        {
                $columnIndexes = array('L','M');

                foreach($columnIndexes as $columnIndex) {
                        $this->_testAutoFilterObject->setColumn($columnIndex);
                }

                //      If we request a specific column by its column ID, we should
                //      get a PHPExcel_Worksheet_AutoFilter_Column object returned
                foreach($columnIndexes as $columnIndex) {
                        $result = $this->_testAutoFilterObject->getColumn($columnIndex);
                        $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
                }
        }

testGetColumnByOffset()

AutoFilterTest::testGetColumnByOffset

(

)

Definition at line 240 of file AutoFilterTest.php.

References $result, and array.

        {
                $columnIndexes = array( 0 => 'H',
                                                                3 => 'K',
                                                                5 => 'M'
                                                          );

                //      If we request a specific column by its offset, we should
                //      get a PHPExcel_Worksheet_AutoFilter_Column object returned
                foreach($columnIndexes as $columnIndex => $columnID) {
                        $result = $this->_testAutoFilterObject->getColumnByOffset($columnIndex);
                        $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
                        $this->assertEquals($result->getColumnIndex(),$columnID);
                }
        }

testGetColumnIfNotSet()

AutoFilterTest::testGetColumnIfNotSet

(

)

Definition at line 256 of file AutoFilterTest.php.

References $result.

        {
                //      If we request a specific column by its column ID, we should
                //      get a PHPExcel_Worksheet_AutoFilter_Column object returned
                $result = $this->_testAutoFilterObject->getColumn('K');
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result);
        }

testGetColumnOffset()

AutoFilterTest::testGetColumnOffset

(

)

Definition at line 113 of file AutoFilterTest.php.

References $result, and array.

        {
                $columnIndexes = array( 'H' => 0,
                                                                'K' => 3,
                                                                'M' => 5
                                                          );

                //      If we request a specific column by its column ID, we should get an
                //      integer returned representing the column offset within the range
                foreach($columnIndexes as $columnIndex => $columnOffset) {
                        $result = $this->_testAutoFilterObject->getColumnOffset($columnIndex);
                        $this->assertEquals($columnOffset, $result);
                }
        }

testGetColumns()

AutoFilterTest::testGetColumns

(

)

Definition at line 205 of file AutoFilterTest.php.

References $result, and array.

        {
                $columnIndexes = array('L','M');

                foreach($columnIndexes as $columnIndex) {
                        $this->_testAutoFilterObject->setColumn($columnIndex);
                }

                $result = $this->_testAutoFilterObject->getColumns();
                //      Result should be an array of PHPExcel_Worksheet_AutoFilter_Column
                //      objects for each column we set indexed by the column ID
                $this->assertInternalType('array', $result);
                $this->assertEquals(count($columnIndexes), count($result));
                foreach($columnIndexes as $columnIndex) {
                        $this->assertArrayHasKey($columnIndex,$result);
                        $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result[$columnIndex]);
                }
        }

testGetColumnsEmpty()

AutoFilterTest::testGetColumnsEmpty

(

)

Definition at line 105 of file AutoFilterTest.php.

References $result.

        {
                //      There should be no columns yet defined
                $result = $this->_testAutoFilterObject->getColumns();
                $this->assertInternalType('array', $result);
                $this->assertEquals(0, count($result));
        }

testGetColumnWithoutRangeSet()

AutoFilterTest::testGetColumnWithoutRangeSet

(

)

PHPExcel_Exception

Definition at line 267 of file AutoFilterTest.php.

References $result.

        {
                //      Clear the range
                $result = $this->_testAutoFilterObject->setRange();

                $result = $this->_testAutoFilterObject->getColumn('A');
        }

testGetInvalidColumnOffset()

AutoFilterTest::testGetInvalidColumnOffset

(

)

PHPExcel_Exception

Definition at line 131 of file AutoFilterTest.php.

References $result.

        {
                $invalidColumn = 'G';

                $result = $this->_testAutoFilterObject->getColumnOffset($invalidColumn);
        }

testGetParent()

AutoFilterTest::testGetParent

(

)

Definition at line 43 of file AutoFilterTest.php.

References $result.

        {
                $result = $this->_testAutoFilterObject->getParent();
                $this->assertInstanceOf('PHPExcel_Worksheet', $result);
        }

testGetRange()

AutoFilterTest::testGetRange

(

)

Definition at line 56 of file AutoFilterTest.php.

References $_testInitialRange, and $result.

        {
                $expectedResult = $this->_testInitialRange;

                //      Result should be the active autofilter range
                $result = $this->_testAutoFilterObject->getRange();
                $this->assertEquals($expectedResult, $result);
        }

testSetColumnWithColumnObject()

AutoFilterTest::testSetColumnWithColumnObject

(

)

Definition at line 165 of file AutoFilterTest.php.

References $result.

        {
                $expectedResult = 'M';
                $columnObject = new PHPExcel_Worksheet_AutoFilter_Column($expectedResult);

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterObject->setColumn($columnObject);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);

                $result = $this->_testAutoFilterObject->getColumns();
                //      Result should be an array of PHPExcel_Worksheet_AutoFilter_Column
                //      objects for each column we set indexed by the column ID
                $this->assertInternalType('array', $result);
                $this->assertEquals(1, count($result));
                $this->assertArrayHasKey($expectedResult,$result);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result[$expectedResult]);
        }

testSetColumnWithInvalidDataType()

AutoFilterTest::testSetColumnWithInvalidDataType

(

)

PHPExcel_Exception

Definition at line 197 of file AutoFilterTest.php.

References $result.

        {
                $invalidColumn = 123.456;
                $columnObject = new PHPExcel_Worksheet_AutoFilter_Column($invalidColumn);

                $result = $this->_testAutoFilterObject->setColumn($invalidColumn);
        }

testSetColumnWithString()

AutoFilterTest::testSetColumnWithString

(

)

Definition at line 138 of file AutoFilterTest.php.

References $result.

        {
                $expectedResult = 'L';

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterObject->setColumn($expectedResult);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);

                $result = $this->_testAutoFilterObject->getColumns();
                //      Result should be an array of PHPExcel_Worksheet_AutoFilter_Column
                //      objects for each column we set indexed by the column ID
                $this->assertInternalType('array', $result);
                $this->assertEquals(1, count($result));
                $this->assertArrayHasKey($expectedResult,$result);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter_Column', $result[$expectedResult]);
        }

testSetInvalidColumnWithObject()

AutoFilterTest::testSetInvalidColumnWithObject

(

)

PHPExcel_Exception

Definition at line 186 of file AutoFilterTest.php.

References $result.

        {
                $invalidColumn = 'E';
                $columnObject = new PHPExcel_Worksheet_AutoFilter_Column($invalidColumn);

                $result = $this->_testAutoFilterObject->setColumn($invalidColumn);
        }

testSetInvalidColumnWithString()

AutoFilterTest::testSetInvalidColumnWithString

(

)

PHPExcel_Exception

Definition at line 158 of file AutoFilterTest.php.

References $result.

        {
                $invalidColumn = 'A';

                $result = $this->_testAutoFilterObject->setColumn($invalidColumn);
        }

testSetParent()

AutoFilterTest::testSetParent

(

)

Definition at line 49 of file AutoFilterTest.php.

References $result.

        {
                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterObject->setParent($this->_mockWorksheetObject);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);
        }

testSetRange()

AutoFilterTest::testSetRange

(

)

Definition at line 65 of file AutoFilterTest.php.

References $result, and array.

        {
                $ranges = array('G1:J512' => 'Worksheet1!G1:J512',
                                                'K1:N20' => 'K1:N20'
                                           );

                foreach($ranges as $actualRange => $fullRange) {
                        //      Setters return the instance to implement the fluent interface
                        $result = $this->_testAutoFilterObject->setRange($fullRange);
                        $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);

                        //      Result should be the new autofilter range
                        $result = $this->_testAutoFilterObject->getRange();
                        $this->assertEquals($actualRange, $result);
                }
        }

testSetRangeInvalidRange()

AutoFilterTest::testSetRangeInvalidRange

(

)

PHPExcel_Exception

Definition at line 98 of file AutoFilterTest.php.

References $result.

        {
                $expectedResult = 'A1';

                $result = $this->_testAutoFilterObject->setRange($expectedResult);
        }

testSetRangeWithExistingColumns()

AutoFilterTest::testSetRangeWithExistingColumns

(

)

Definition at line 298 of file AutoFilterTest.php.

References $result, and array.

        {
                $expectedResult = 'G1:J512';

                //      These columns should be retained
                $columnIndexes1 = array('I','J');
                foreach($columnIndexes1 as $columnIndex) {
                        $this->_testAutoFilterObject->setColumn($columnIndex);
                }
                //      These columns should be discarded
                $columnIndexes2 = array('K','L','M');
                foreach($columnIndexes2 as $columnIndex) {
                        $this->_testAutoFilterObject->setColumn($columnIndex);
                }

                //      Setters return the instance to implement the fluent interface
                $result = $this->_testAutoFilterObject->setRange($expectedResult);
                $this->assertInstanceOf('PHPExcel_Worksheet_AutoFilter', $result);

                //      Range should be correctly set
                $result = $this->_testAutoFilterObject->getRange();
                $this->assertEquals($expectedResult, $result);

                //      Only columns that existed in the original range and that
                //              still fall within the new range should be retained
                $result = $this->_testAutoFilterObject->getColumns();
                $this->assertInternalType('array', $result);
                $this->assertEquals(count($columnIndexes1), count($result));
        }

testToString()

AutoFilterTest::testToString

(

)

Definition at line 34 of file AutoFilterTest.php.

References $_testAutoFilterObject, $_testInitialRange, and $result.

        {
                $expectedResult = $this->_testInitialRange;

                //      magic __toString should return the active autofilter range
                $result = $this->_testAutoFilterObject;
                $this->assertEquals($expectedResult, $result);
        }

Field Documentation

$_testAutoFilterObject

AutoFilterTest::$_testAutoFilterObject

private

Definition at line 8 of file AutoFilterTest.php.

Referenced by testClone(), and testToString().

$_testInitialRange

AutoFilterTest::$_testInitialRange = 'H2:O256'

private

Definition at line 6 of file AutoFilterTest.php.

Referenced by testGetRange(), and testToString().

---

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

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