MathTrigTest.php

Go to the documentation of this file.

<?php


require_once 'testDataFileIterator.php';

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);
        }

        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, 1E-12);
        }

    public function providerATAN2()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/ATAN2.data');
        }

        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, 1E-12);
        }

    public function providerCEILING()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/CEILING.data');
        }

        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, 1E-12);
        }

    public function providerCOMBIN()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/COMBIN.data');
        }

        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, 1E-12);
        }

    public function providerEVEN()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/EVEN.data');
        }

        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, 1E-12);
        }

    public function providerODD()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/ODD.data');
        }

        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, 1E-12);
        }

    public function providerFACT()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/FACT.data');
        }

        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, 1E-12);
        }

    public function providerFACTDOUBLE()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/FACTDOUBLE.data');
        }

        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, 1E-12);
        }

    public function providerFLOOR()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/FLOOR.data');
        }

        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, 1E-12);
        }

    public function providerGCD()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/GCD.data');
        }

        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, 1E-12);
        }

    public function providerLCM()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/LCM.data');
        }

        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');
        }

        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, 1E-12);
        }

    public function providerSIGN()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/SIGN.data');
        }

        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, 1E-12);
        }

    public function providerPOWER()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/POWER.data');
        }

        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, 1E-12);
        }

    public function providerLOG()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/LOG.data');
        }

        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, 1E-12);
        }

    public function providerMOD()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/MOD.data');
        }

        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, 1E-12);
        }

    public function providerMDETERM()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/MDETERM.data');
        }

        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, 1E-12);
        }

    public function providerMINVERSE()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/MINVERSE.data');
        }

        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, 1E-12);
        }

    public function providerMMULT()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/MMULT.data');
        }

        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, 1E-12);
        }

    public function providerMULTINOMIAL()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/MULTINOMIAL.data');
        }

        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, 1E-12);
        }

    public function providerMROUND()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/MROUND.data');
        }

        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, 1E-12);
        }

    public function providerPRODUCT()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/PRODUCT.data');
        }

        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, 1E-12);
        }

    public function providerQUOTIENT()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/QUOTIENT.data');
        }

        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, 1E-12);
        }

    public function providerROUNDUP()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/ROUNDUP.data');
        }

        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, 1E-12);
        }

    public function providerROUNDDOWN()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/ROUNDDOWN.data');
        }

        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, 1E-12);
        }

    public function providerSERIESSUM()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/SERIESSUM.data');
        }

        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, 1E-12);
        }

    public function providerSUMSQ()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/SUMSQ.data');
        }

        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, 1E-12);
        }

    public function providerTRUNC()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/TRUNC.data');
        }

        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');
        }

        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, 1E-12);
        }

    public function providerSQRTPI()
    {
        return new testDataFileIterator('rawTestData/Calculation/MathTrig/SQRTPI.data');
    }

    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, 1E-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
            ),
        );
        }

}