class CellTest in Loft Data Grids 6.2
Same name and namespace in other branches
Hierarchy
- class \CellTest extends \PHPUnit_Framework_TestCase
Expanded class hierarchy of CellTest
File
- vendor/
phpoffice/ phpexcel/ unitTests/ Classes/ PHPExcel/ CellTest.php, line 6
View source
class CellTest extends PHPUnit_Framework_TestCase {
public function setUp() {
if (!defined('PHPEXCEL_ROOT')) {
define('PHPEXCEL_ROOT', APPLICATION_PATH . '/');
}
require_once PHPEXCEL_ROOT . 'PHPExcel/Autoloader.php';
}
/**
* @dataProvider providerColumnString
*/
public function testColumnIndexFromString() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'columnIndexFromString',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerColumnString() {
return new testDataFileIterator('rawTestData/ColumnString.data');
}
public function testColumnIndexFromStringTooLong() {
$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.');
}
public function testColumnIndexFromStringTooShort() {
$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.');
}
/**
* @dataProvider providerColumnIndex
*/
public function testStringFromColumnIndex() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'stringFromColumnIndex',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerColumnIndex() {
return new testDataFileIterator('rawTestData/ColumnIndex.data');
}
/**
* @dataProvider providerCoordinates
*/
public function testCoordinateFromString() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'coordinateFromString',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerCoordinates() {
return new testDataFileIterator('rawTestData/CellCoordinates.data');
}
public function testCoordinateFromStringWithRangeAddress() {
$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.');
}
public function testCoordinateFromStringWithEmptyAddress() {
$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.');
}
public function testCoordinateFromStringWithInvalidAddress() {
$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.');
}
/**
* @dataProvider providerAbsoluteCoordinates
*/
public function testAbsoluteCoordinateFromString() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'absoluteCoordinate',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerAbsoluteCoordinates() {
return new testDataFileIterator('rawTestData/CellAbsoluteCoordinate.data');
}
public function testAbsoluteCoordinateFromStringWithRangeAddress() {
$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.');
}
/**
* @dataProvider providerAbsoluteReferences
*/
public function testAbsoluteReferenceFromString() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'absoluteReference',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerAbsoluteReferences() {
return new testDataFileIterator('rawTestData/CellAbsoluteReference.data');
}
public function testAbsoluteReferenceFromStringWithRangeAddress() {
$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.');
}
/**
* @dataProvider providerSplitRange
*/
public function testSplitRange() {
$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);
}
}
}
public function providerSplitRange() {
return new testDataFileIterator('rawTestData/CellSplitRange.data');
}
/**
* @dataProvider providerBuildRange
*/
public function testBuildRange() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'buildRange',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerBuildRange() {
return new testDataFileIterator('rawTestData/CellBuildRange.data');
}
public function testBuildRangeInvalid() {
$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.');
}
/**
* @dataProvider providerRangeBoundaries
*/
public function testRangeBoundaries() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'rangeBoundaries',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerRangeBoundaries() {
return new testDataFileIterator('rawTestData/CellRangeBoundaries.data');
}
/**
* @dataProvider providerRangeDimension
*/
public function testRangeDimension() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'rangeDimension',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerRangeDimension() {
return new testDataFileIterator('rawTestData/CellRangeDimension.data');
}
/**
* @dataProvider providerGetRangeBoundaries
*/
public function testGetRangeBoundaries() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'getRangeBoundaries',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerGetRangeBoundaries() {
return new testDataFileIterator('rawTestData/CellGetRangeBoundaries.data');
}
/**
* @dataProvider providerExtractAllCellReferencesInRange
*/
public function testExtractAllCellReferencesInRange() {
$args = func_get_args();
$expectedResult = array_pop($args);
$result = call_user_func_array(array(
'PHPExcel_Cell',
'extractAllCellReferencesInRange',
), $args);
$this
->assertEquals($expectedResult, $result);
}
public function providerExtractAllCellReferencesInRange() {
return new testDataFileIterator('rawTestData/CellExtractAllCellReferencesInRange.data');
}
}