You are here

FunctionsTest.php in Loft Data Grids 6.2

File

vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/FunctionsTest.php
View source
<?php

require_once 'testDataFileIterator.php';
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');
  }

}

Classes

Namesort descending Description
FunctionsTest