class FunctionsTest in Loft Data Grids 7.2

Same name and namespace in other branches

6.2 vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FunctionsTest.php \FunctionsTest

Hierarchy

class \FunctionsTest extends \PHPUnit_Framework_TestCase

Expanded class hierarchy of FunctionsTest

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FunctionsTest.php, line 6

View source

class FunctionsTest extends PHPUnit_Framework_TestCase {
  public function setUp() {
    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);
  }
  public function testDUMMY() {
    $result = PHPExcel_Calculation_Functions::DUMMY();
    $this
      ->assertEquals('#Not Yet Implemented', $result);
  }
  public function testDIV0() {
    $result = PHPExcel_Calculation_Functions::DIV0();
    $this
      ->assertEquals('#DIV/0!', $result);
  }
  public function testNA() {
    $result = PHPExcel_Calculation_Functions::NA();
    $this
      ->assertEquals('#N/A', $result);
  }
  public function testNaN() {
    $result = PHPExcel_Calculation_Functions::NaN();
    $this
      ->assertEquals('#NUM!', $result);
  }
  public function testNAME() {
    $result = PHPExcel_Calculation_Functions::NAME();
    $this
      ->assertEquals('#NAME?', $result);
  }
  public function testREF() {
    $result = PHPExcel_Calculation_Functions::REF();
    $this
      ->assertEquals('#REF!', $result);
  }
  public function testNULL() {
    $result = PHPExcel_Calculation_Functions::NULL();
    $this
      ->assertEquals('#NULL!', $result);
  }
  public function testVALUE() {
    $result = PHPExcel_Calculation_Functions::VALUE();
    $this
      ->assertEquals('#VALUE!', $result);
  }

  /**
   * @dataProvider providerIS_BLANK
   */
  public function testIS_BLANK() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_BLANK',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_BLANK() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_BLANK.data');
  }

  /**
   * @dataProvider providerIS_ERR
   */
  public function testIS_ERR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_ERR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_ERR() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_ERR.data');
  }

  /**
   * @dataProvider providerIS_ERROR
   */
  public function testIS_ERROR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_ERROR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_ERROR() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_ERROR.data');
  }

  /**
   * @dataProvider providerERROR_TYPE
   */
  public function testERROR_TYPE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'ERROR_TYPE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerERROR_TYPE() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/ERROR_TYPE.data');
  }

  /**
   * @dataProvider providerIS_LOGICAL
   */
  public function testIS_LOGICAL() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_LOGICAL',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_LOGICAL() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_LOGICAL.data');
  }

  /**
   * @dataProvider providerIS_NA
   */
  public function testIS_NA() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_NA',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_NA() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_NA.data');
  }

  /**
   * @dataProvider providerIS_NUMBER
   */
  public function testIS_NUMBER() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_NUMBER',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_NUMBER() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_NUMBER.data');
  }

  /**
   * @dataProvider providerIS_TEXT
   */
  public function testIS_TEXT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_TEXT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_TEXT() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_TEXT.data');
  }

  /**
   * @dataProvider providerIS_NONTEXT
   */
  public function testIS_NONTEXT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_NONTEXT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_NONTEXT() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_NONTEXT.data');
  }

  /**
   * @dataProvider providerIS_EVEN
   */
  public function testIS_EVEN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_EVEN',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_EVEN() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_EVEN.data');
  }

  /**
   * @dataProvider providerIS_ODD
   */
  public function testIS_ODD() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'IS_ODD',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerIS_ODD() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/IS_ODD.data');
  }

  /**
   * @dataProvider providerTYPE
   */
  public function testTYPE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'TYPE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerTYPE() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/TYPE.data');
  }

  /**
   * @dataProvider providerN
   */
  public function testN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_Functions',
      'N',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-8);
  }
  public function providerN() {
    return new testDataFileIterator('rawTestData/Calculation/Functions/N.data');
  }

}

Members

Name	Modifiers	Type	Description
FunctionsTest::providerERROR_TYPE	public	function
FunctionsTest::providerIS_BLANK	public	function
FunctionsTest::providerIS_ERR	public	function
FunctionsTest::providerIS_ERROR	public	function
FunctionsTest::providerIS_EVEN	public	function
FunctionsTest::providerIS_LOGICAL	public	function
FunctionsTest::providerIS_NA	public	function
FunctionsTest::providerIS_NONTEXT	public	function
FunctionsTest::providerIS_NUMBER	public	function
FunctionsTest::providerIS_ODD	public	function
FunctionsTest::providerIS_TEXT	public	function
FunctionsTest::providerN	public	function
FunctionsTest::providerTYPE	public	function
FunctionsTest::setUp	public	function
FunctionsTest::testDIV0	public	function
FunctionsTest::testDUMMY	public	function
FunctionsTest::testERROR_TYPE	public	function	@dataProvider providerERROR_TYPE
FunctionsTest::testIS_BLANK	public	function	@dataProvider providerIS_BLANK
FunctionsTest::testIS_ERR	public	function	@dataProvider providerIS_ERR
FunctionsTest::testIS_ERROR	public	function	@dataProvider providerIS_ERROR
FunctionsTest::testIS_EVEN	public	function	@dataProvider providerIS_EVEN
FunctionsTest::testIS_LOGICAL	public	function	@dataProvider providerIS_LOGICAL
FunctionsTest::testIS_NA	public	function	@dataProvider providerIS_NA
FunctionsTest::testIS_NONTEXT	public	function	@dataProvider providerIS_NONTEXT
FunctionsTest::testIS_NUMBER	public	function	@dataProvider providerIS_NUMBER
FunctionsTest::testIS_ODD	public	function	@dataProvider providerIS_ODD
FunctionsTest::testIS_TEXT	public	function	@dataProvider providerIS_TEXT
FunctionsTest::testN	public	function	@dataProvider providerN
FunctionsTest::testNA	public	function
FunctionsTest::testNAME	public	function
FunctionsTest::testNaN	public	function
FunctionsTest::testNULL	public	function
FunctionsTest::testREF	public	function
FunctionsTest::testTYPE	public	function	@dataProvider providerTYPE
FunctionsTest::testVALUE	public	function

You are here

class FunctionsTest in Loft Data Grids 7.2

Hierarchy

File

Members

API Navigation