You are here

class MathTrigTest in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/MathTrigTest.php \MathTrigTest

Hierarchy

Expanded class hierarchy of MathTrigTest

File

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

View source
class MathTrigTest 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);
  }

  /**
   * @dataProvider providerATAN2
   */
  public function testATAN2() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'ATAN2',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerATAN2() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/ATAN2.data');
  }

  /**
   * @dataProvider providerCEILING
   */
  public function testCEILING() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'CEILING',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerCEILING() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/CEILING.data');
  }

  /**
   * @dataProvider providerCOMBIN
   */
  public function testCOMBIN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'COMBIN',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerCOMBIN() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/COMBIN.data');
  }

  /**
   * @dataProvider providerEVEN
   */
  public function testEVEN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'EVEN',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerEVEN() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/EVEN.data');
  }

  /**
   * @dataProvider providerODD
   */
  public function testODD() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'ODD',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerODD() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/ODD.data');
  }

  /**
   * @dataProvider providerFACT
   */
  public function testFACT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'FACT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerFACT() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/FACT.data');
  }

  /**
   * @dataProvider providerFACTDOUBLE
   */
  public function testFACTDOUBLE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'FACTDOUBLE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerFACTDOUBLE() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/FACTDOUBLE.data');
  }

  /**
   * @dataProvider providerFLOOR
   */
  public function testFLOOR() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'FLOOR',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerFLOOR() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/FLOOR.data');
  }

  /**
   * @dataProvider providerGCD
   */
  public function testGCD() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'GCD',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerGCD() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/GCD.data');
  }

  /**
   * @dataProvider providerLCM
   */
  public function testLCM() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'LCM',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerLCM() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/LCM.data');
  }

  /**
   * @dataProvider providerINT
   */
  public function testINT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'INT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result);
  }
  public function providerINT() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/INT.data');
  }

  /**
   * @dataProvider providerSIGN
   */
  public function testSIGN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'SIGN',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerSIGN() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/SIGN.data');
  }

  /**
   * @dataProvider providerPOWER
   */
  public function testPOWER() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'POWER',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerPOWER() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/POWER.data');
  }

  /**
   * @dataProvider providerLOG
   */
  public function testLOG() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'LOG_BASE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerLOG() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/LOG.data');
  }

  /**
   * @dataProvider providerMOD
   */
  public function testMOD() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'MOD',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerMOD() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/MOD.data');
  }

  /**
   * @dataProvider providerMDETERM
   */
  public function testMDETERM() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'MDETERM',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerMDETERM() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/MDETERM.data');
  }

  /**
   * @dataProvider providerMINVERSE
   */
  public function testMINVERSE() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'MINVERSE',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerMINVERSE() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/MINVERSE.data');
  }

  /**
   * @dataProvider providerMMULT
   */
  public function testMMULT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'MMULT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerMMULT() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/MMULT.data');
  }

  /**
   * @dataProvider providerMULTINOMIAL
   */
  public function testMULTINOMIAL() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'MULTINOMIAL',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerMULTINOMIAL() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/MULTINOMIAL.data');
  }

  /**
   * @dataProvider providerMROUND
   */
  public function testMROUND() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    PHPExcel_Calculation::setArrayReturnType(PHPExcel_Calculation::RETURN_ARRAY_AS_VALUE);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'MROUND',
    ), $args);
    PHPExcel_Calculation::setArrayReturnType(PHPExcel_Calculation::RETURN_ARRAY_AS_ARRAY);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerMROUND() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/MROUND.data');
  }

  /**
   * @dataProvider providerPRODUCT
   */
  public function testPRODUCT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'PRODUCT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerPRODUCT() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/PRODUCT.data');
  }

  /**
   * @dataProvider providerQUOTIENT
   */
  public function testQUOTIENT() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'QUOTIENT',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerQUOTIENT() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/QUOTIENT.data');
  }

  /**
   * @dataProvider providerROUNDUP
   */
  public function testROUNDUP() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'ROUNDUP',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerROUNDUP() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/ROUNDUP.data');
  }

  /**
   * @dataProvider providerROUNDDOWN
   */
  public function testROUNDDOWN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'ROUNDDOWN',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerROUNDDOWN() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/ROUNDDOWN.data');
  }

  /**
   * @dataProvider providerSERIESSUM
   */
  public function testSERIESSUM() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'SERIESSUM',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerSERIESSUM() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/SERIESSUM.data');
  }

  /**
   * @dataProvider providerSUMSQ
   */
  public function testSUMSQ() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'SUMSQ',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerSUMSQ() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/SUMSQ.data');
  }

  /**
   * @dataProvider providerTRUNC
   */
  public function testTRUNC() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'TRUNC',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerTRUNC() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/TRUNC.data');
  }

  /**
   * @dataProvider providerROMAN
   */
  public function testROMAN() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'ROMAN',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result);
  }
  public function providerROMAN() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/ROMAN.data');
  }

  /**
   * @dataProvider providerSQRTPI
   */
  public function testSQRTPI() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'SQRTPI',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerSQRTPI() {
    return new testDataFileIterator('rawTestData/Calculation/MathTrig/SQRTPI.data');
  }

  /**
   * @dataProvider providerSUMIF
   */
  public function testSUMIF() {
    $args = func_get_args();
    $expectedResult = array_pop($args);
    $result = call_user_func_array(array(
      'PHPExcel_Calculation_MathTrig',
      'SUMIF',
    ), $args);
    $this
      ->assertEquals($expectedResult, $result, NULL, 1.0E-12);
  }
  public function providerSUMIF() {
    return array(
      array(
        array(
          array(
            1,
          ),
          array(
            5,
          ),
          array(
            10,
          ),
        ),
        '>=5',
        15,
      ),
      array(
        array(
          array(
            'text',
          ),
          array(
            2,
          ),
        ),
        '=text',
        array(
          array(
            10,
          ),
          array(
            100,
          ),
        ),
        10,
      ),
      array(
        array(
          array(
            '"text with quotes"',
          ),
          array(
            2,
          ),
        ),
        '="text with quotes"',
        array(
          array(
            10,
          ),
          array(
            100,
          ),
        ),
        10,
      ),
      array(
        array(
          array(
            '"text with quotes"',
          ),
          array(
            '',
          ),
        ),
        '>"',
        // Compare to the single characater " (double quote)
        array(
          array(
            10,
          ),
          array(
            100,
          ),
        ),
        10,
      ),
      array(
        array(
          array(
            '',
          ),
          array(
            'anything',
          ),
        ),
        '>"',
        // Compare to the single characater " (double quote)
        array(
          array(
            10,
          ),
          array(
            100,
          ),
        ),
        100,
      ),
    );
  }

}

Members

Namesort descending Modifiers Type Description Overrides
MathTrigTest::providerATAN2 public function
MathTrigTest::providerCEILING public function
MathTrigTest::providerCOMBIN public function
MathTrigTest::providerEVEN public function
MathTrigTest::providerFACT public function
MathTrigTest::providerFACTDOUBLE public function
MathTrigTest::providerFLOOR public function
MathTrigTest::providerGCD public function
MathTrigTest::providerINT public function
MathTrigTest::providerLCM public function
MathTrigTest::providerLOG public function
MathTrigTest::providerMDETERM public function
MathTrigTest::providerMINVERSE public function
MathTrigTest::providerMMULT public function
MathTrigTest::providerMOD public function
MathTrigTest::providerMROUND public function
MathTrigTest::providerMULTINOMIAL public function
MathTrigTest::providerODD public function
MathTrigTest::providerPOWER public function
MathTrigTest::providerPRODUCT public function
MathTrigTest::providerQUOTIENT public function
MathTrigTest::providerROMAN public function
MathTrigTest::providerROUNDDOWN public function
MathTrigTest::providerROUNDUP public function
MathTrigTest::providerSERIESSUM public function
MathTrigTest::providerSIGN public function
MathTrigTest::providerSQRTPI public function
MathTrigTest::providerSUMIF public function
MathTrigTest::providerSUMSQ public function
MathTrigTest::providerTRUNC public function
MathTrigTest::setUp public function
MathTrigTest::testATAN2 public function @dataProvider providerATAN2
MathTrigTest::testCEILING public function @dataProvider providerCEILING
MathTrigTest::testCOMBIN public function @dataProvider providerCOMBIN
MathTrigTest::testEVEN public function @dataProvider providerEVEN
MathTrigTest::testFACT public function @dataProvider providerFACT
MathTrigTest::testFACTDOUBLE public function @dataProvider providerFACTDOUBLE
MathTrigTest::testFLOOR public function @dataProvider providerFLOOR
MathTrigTest::testGCD public function @dataProvider providerGCD
MathTrigTest::testINT public function @dataProvider providerINT
MathTrigTest::testLCM public function @dataProvider providerLCM
MathTrigTest::testLOG public function @dataProvider providerLOG
MathTrigTest::testMDETERM public function @dataProvider providerMDETERM
MathTrigTest::testMINVERSE public function @dataProvider providerMINVERSE
MathTrigTest::testMMULT public function @dataProvider providerMMULT
MathTrigTest::testMOD public function @dataProvider providerMOD
MathTrigTest::testMROUND public function @dataProvider providerMROUND
MathTrigTest::testMULTINOMIAL public function @dataProvider providerMULTINOMIAL
MathTrigTest::testODD public function @dataProvider providerODD
MathTrigTest::testPOWER public function @dataProvider providerPOWER
MathTrigTest::testPRODUCT public function @dataProvider providerPRODUCT
MathTrigTest::testQUOTIENT public function @dataProvider providerQUOTIENT
MathTrigTest::testROMAN public function @dataProvider providerROMAN
MathTrigTest::testROUNDDOWN public function @dataProvider providerROUNDDOWN
MathTrigTest::testROUNDUP public function @dataProvider providerROUNDUP
MathTrigTest::testSERIESSUM public function @dataProvider providerSERIESSUM
MathTrigTest::testSIGN public function @dataProvider providerSIGN
MathTrigTest::testSQRTPI public function @dataProvider providerSQRTPI
MathTrigTest::testSUMIF public function @dataProvider providerSUMIF
MathTrigTest::testSUMSQ public function @dataProvider providerSUMSQ
MathTrigTest::testTRUNC public function @dataProvider providerTRUNC