PhpOffice\PhpSpreadsheetTests\Calculation\TextDataTest

Complexity

Total Complexity

45

Size/Duplication

Total Lines	374
Duplicated Lines	0 %

Importance

Changes

0

45 Methods

Rating	Name	Duplication	Size	Complexity
A	testFIND()	0	4	1
A	testCLEAN()	0	4	1
A	providerSUBSTITUTE()	0	3	1
A	testPROPER()	0	4	1
A	testFIXED()	0	4	1
A	providerTEXT()	0	3	1
A	providerFIXED()	0	3	1
A	providerUPPER()	0	3	1
A	testT()	0	4	1
A	providerPROPER()	0	3	1
A	providerREPLACE()	0	3	1
A	providerCLEAN()	0	3	1
A	testLEFT()	0	4	1
A	providerLOWER()	0	3	1
A	providerDOLLAR()	0	3	1
A	testLEN()	0	4	1
A	providerFIND()	0	3	1
A	providerT()	0	3	1
A	providerTRIM()	0	3	1
A	providerRIGHT()	0	3	1
A	providerCHAR()	0	3	1
A	testMID()	0	4	1
A	testSUBSTITUTE()	0	4	1
A	testSEARCH()	0	4	1
A	providerLEN()	0	3	1
A	providerSEARCH()	0	3	1
A	providerMID()	0	3	1
A	testDOLLAR()	0	4	1
A	testTRIM()	0	4	1
A	setUp()	0	3	1
A	testUPPER()	0	4	1
A	testCHAR()	0	4	1
A	testRIGHT()	0	4	1
A	providerVALUE()	0	3	1
A	providerLEFT()	0	3	1
A	testREPLACE()	0	4	1
A	providerCODE()	0	3	1
A	testLOWER()	0	4	1
A	providerCONCATENATE()	0	3	1
A	testCODE()	0	4	1
A	testCONCATENATE()	0	4	1
A	testVALUE()	0	8	1
A	testTEXT()	0	9	1
A	testEXACT()	0	8	1
A	providerEXACT()	0	3	1

<?php

namespace PhpOffice\PhpSpreadsheetTests\Calculation;

use PhpOffice\PhpSpreadsheet\Calculation\Calculation;
use PhpOffice\PhpSpreadsheet\Calculation\Functions;
use PhpOffice\PhpSpreadsheet\Calculation\TextData;
use PhpOffice\PhpSpreadsheet\Shared\StringHelper;
use PHPUnit\Framework\TestCase;

class TextDataTest extends TestCase
{
    public function setUp()
    {
        Functions::setCompatibilityMode(Functions::COMPATIBILITY_EXCEL);
    }

    /**
     * @dataProvider providerCHAR
     *
     * @param mixed $expectedResult
     */
    public function testCHAR($expectedResult, ...$args)
    {
        $result = TextData::CHARACTER(...$args);

$args is expanded, but the parameter $character of PhpOffice\PhpSpreadsheet\Calculation\TextData::CHARACTER() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerCHAR()
    {
        return require 'data/Calculation/TextData/CHAR.php';
    }

    /**
     * @dataProvider providerCODE
     *
     * @param mixed $expectedResult
     */
    public function testCODE($expectedResult, ...$args)
    {
        $result = TextData::ASCIICODE(...$args);

$args is expanded, but the parameter $characters of PhpOffice\PhpSpreadsheet\Calculation\TextData::ASCIICODE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerCODE()
    {
        return require 'data/Calculation/TextData/CODE.php';
    }

    /**
     * @dataProvider providerCONCATENATE
     *
     * @param mixed $expectedResult
     */
    public function testCONCATENATE($expectedResult, ...$args)
    {
        $result = TextData::CONCATENATE(...$args);
        self::assertEquals($expectedResult, $result);
    }

    public function providerCONCATENATE()
    {
        return require 'data/Calculation/TextData/CONCATENATE.php';
    }

    /**
     * @dataProvider providerLEFT
     *
     * @param mixed $expectedResult
     */
    public function testLEFT($expectedResult, ...$args)
    {
        $result = TextData::LEFT(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::LEFT() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerLEFT()
    {
        return require 'data/Calculation/TextData/LEFT.php';
    }

    /**
     * @dataProvider providerMID
     *
     * @param mixed $expectedResult
     */
    public function testMID($expectedResult, ...$args)
    {
        $result = TextData::MID(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::MID() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerMID()
    {
        return require 'data/Calculation/TextData/MID.php';
    }

    /**
     * @dataProvider providerRIGHT
     *
     * @param mixed $expectedResult
     */
    public function testRIGHT($expectedResult, ...$args)
    {
        $result = TextData::RIGHT(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::RIGHT() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerRIGHT()
    {
        return require 'data/Calculation/TextData/RIGHT.php';
    }

    /**
     * @dataProvider providerLOWER
     *
     * @param mixed $expectedResult
     */
    public function testLOWER($expectedResult, ...$args)
    {
        $result = TextData::LOWERCASE(...$args);

$args is expanded, but the parameter $mixedCaseString of PhpOffice\PhpSpreadsheet\Calculation\TextData::LOWERCASE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerLOWER()
    {
        return require 'data/Calculation/TextData/LOWER.php';
    }

    /**
     * @dataProvider providerUPPER
     *
     * @param mixed $expectedResult
     */
    public function testUPPER($expectedResult, ...$args)
    {
        $result = TextData::UPPERCASE(...$args);

$args is expanded, but the parameter $mixedCaseString of PhpOffice\PhpSpreadsheet\Calculation\TextData::UPPERCASE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerUPPER()
    {
        return require 'data/Calculation/TextData/UPPER.php';
    }

    /**
     * @dataProvider providerPROPER
     *
     * @param mixed $expectedResult
     */
    public function testPROPER($expectedResult, ...$args)
    {
        $result = TextData::PROPERCASE(...$args);

$args is expanded, but the parameter $mixedCaseString of PhpOffice\PhpSpreadsheet\Calculation\TextData::PROPERCASE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerPROPER()
    {
        return require 'data/Calculation/TextData/PROPER.php';
    }

    /**
     * @dataProvider providerLEN
     *
     * @param mixed $expectedResult
     */
    public function testLEN($expectedResult, ...$args)
    {
        $result = TextData::STRINGLENGTH(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::STRINGLENGTH() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerLEN()
    {
        return require 'data/Calculation/TextData/LEN.php';
    }

    /**
     * @dataProvider providerSEARCH
     *
     * @param mixed $expectedResult
     */
    public function testSEARCH($expectedResult, ...$args)
    {
        $result = TextData::SEARCHINSENSITIVE(...$args);
        self::assertEquals($expectedResult, $result);
    }

    public function providerSEARCH()
    {
        return require 'data/Calculation/TextData/SEARCH.php';
    }

    /**
     * @dataProvider providerFIND
     *
     * @param mixed $expectedResult
     */
    public function testFIND($expectedResult, ...$args)
    {
        $result = TextData::SEARCHSENSITIVE(...$args);
        self::assertEquals($expectedResult, $result);
    }

    public function providerFIND()
    {
        return require 'data/Calculation/TextData/FIND.php';
    }

    /**
     * @dataProvider providerREPLACE
     *
     * @param mixed $expectedResult
     */
    public function testREPLACE($expectedResult, ...$args)
    {
        $result = TextData::REPLACE(...$args);
        self::assertEquals($expectedResult, $result);
    }

    public function providerREPLACE()
    {
        return require 'data/Calculation/TextData/REPLACE.php';
    }

    /**
     * @dataProvider providerSUBSTITUTE
     *
     * @param mixed $expectedResult
     */
    public function testSUBSTITUTE($expectedResult, ...$args)
    {
        $result = TextData::SUBSTITUTE(...$args);

$args is expanded, but the parameter $text of PhpOffice\PhpSpreadsheet\Calculation\TextData::SUBSTITUTE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerSUBSTITUTE()
    {
        return require 'data/Calculation/TextData/SUBSTITUTE.php';
    }

    /**
     * @dataProvider providerTRIM
     *
     * @param mixed $expectedResult
     */
    public function testTRIM($expectedResult, ...$args)
    {
        $result = TextData::TRIMSPACES(...$args);

$args is expanded, but the parameter $stringValue of PhpOffice\PhpSpreadsheet\Calculation\TextData::TRIMSPACES() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerTRIM()
    {
        return require 'data/Calculation/TextData/TRIM.php';
    }

    /**
     * @dataProvider providerCLEAN
     *
     * @param mixed $expectedResult
     */
    public function testCLEAN($expectedResult, ...$args)
    {
        $result = TextData::TRIMNONPRINTABLE(...$args);

$args is expanded, but the parameter $stringValue of PhpOffice\PhpSpreadsheet\Calculation\TextData::TRIMNONPRINTABLE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerCLEAN()
    {
        return require 'data/Calculation/TextData/CLEAN.php';
    }

    /**
     * @dataProvider providerDOLLAR
     *
     * @param mixed $expectedResult
     */
    public function testDOLLAR($expectedResult, ...$args)
    {
        $result = TextData::DOLLAR(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::DOLLAR() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerDOLLAR()
    {
        return require 'data/Calculation/TextData/DOLLAR.php';
    }

    /**
     * @dataProvider providerFIXED
     *
     * @param mixed $expectedResult
     */
    public function testFIXED($expectedResult, ...$args)
    {
        $result = TextData::FIXEDFORMAT(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::FIXEDFORMAT() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerFIXED()
    {
        return require 'data/Calculation/TextData/FIXED.php';
    }

    /**
     * @dataProvider providerT
     *
     * @param mixed $expectedResult
     */
    public function testT($expectedResult, ...$args)
    {
        $result = TextData::RETURNSTRING(...$args);

$args is expanded, but the parameter $testValue of PhpOffice\PhpSpreadsheet\Calculation\TextData::RETURNSTRING() does not expect variable arguments.

        self::assertEquals($expectedResult, $result);
    }

    public function providerT()
    {
        return require 'data/Calculation/TextData/T.php';
    }

    /**
     * @dataProvider providerTEXT
     *
     * @param mixed $expectedResult
     */
    public function testTEXT($expectedResult, ...$args)
    {
        //    Enforce decimal and thousands separator values to UK/US, and currency code to USD
        StringHelper::setDecimalSeparator('.');
        StringHelper::setThousandsSeparator(',');
        StringHelper::setCurrencyCode('$');

        $result = TextData::TEXTFORMAT(...$args);
        self::assertEquals($expectedResult, $result);
    }

    public function providerTEXT()
    {
        return require 'data/Calculation/TextData/TEXT.php';
    }

    /**
     * @dataProvider providerVALUE
     *
     * @param mixed $expectedResult
     */
    public function testVALUE($expectedResult, ...$args)
    {
        StringHelper::setDecimalSeparator('.');
        StringHelper::setThousandsSeparator(' ');
        StringHelper::setCurrencyCode('$');

        $result = TextData::VALUE(...$args);

$args is expanded, but the parameter $value of PhpOffice\PhpSpreadsheet\Calculation\TextData::VALUE() does not expect variable arguments.

        self::assertEquals($expectedResult, $result, null, 1E-8);
    }

    public function providerVALUE()
    {
        return require 'data/Calculation/TextData/VALUE.php';
    }

    /**
     * @dataProvider providerEXACT
     *
     * @param mixed $expectedResult
     * @param array $args
     */
    public function testEXACT($expectedResult, ...$args)
    {
        StringHelper::setDecimalSeparator('.');
        StringHelper::setThousandsSeparator(' ');
        StringHelper::setCurrencyCode('$');

        $result = TextData::EXACT(...$args);
        self::assertSame($expectedResult, $result, null);
    }

    /**
     * @return array
     */
    public function providerEXACT()
    {
        return require 'data/Calculation/TextData/EXACT.php';
    }
}