PHPOffice / PhpSpreadsheet

    /**

     * @dataProvider providerTEXT

     */

    public function testTEXT()

    {

        //    Enforce decimal and thousands separator values to UK/US, and currency code to USD

        call_user_func([StringHelper::class, 'setDecimalSeparator'], '.');

        call_user_func([StringHelper::class, 'setThousandsSeparator'], ',');

        call_user_func([StringHelper::class, 'setCurrencyCode'], '$');

        $args = func_get_args();

        $expectedResult = array_pop($args);

        $result = call_user_func_array([TextData::class, 'TEXTFORMAT'], $args);

        $this->assertEquals($expectedResult, $result);

    }

    public function providerTEXT()

    {

    /**

     * @dataProvider providerVALUE

     */

    public function testVALUE()

    {

        call_user_func([StringHelper::class, 'setDecimalSeparator'], '.');

        call_user_func([StringHelper::class, 'setThousandsSeparator'], ' ');

        call_user_func([StringHelper::class, 'setCurrencyCode'], '$');

        $args = func_get_args();

        $expectedResult = array_pop($args);

        $result = call_user_func_array([TextData::class, 'VALUE'], $args);

        $this->assertEquals($expectedResult, $result, null, 1E-8);

    }

    public function providerVALUE()

    {