<?php

namespace PhpOffice\PhpSpreadsheet\Calculation;

use DateTimeInterface;

/**
 * @deprecated 1.18.0
 */
class TextData
{
    /**
     * CHARACTER.
     *
     * @deprecated 1.18.0
     *      Use the character() method in the TextData\CharacterConvert class instead
     * @see TextData\CharacterConvert::character()
     *
     * @param string $character Value
     *
     * @return array|string
     */
    public static function CHARACTER($character)
    {
        return TextData\CharacterConvert::character($character);
    }

    /**
     * TRIMNONPRINTABLE.
     *
     * @deprecated 1.18.0
     *      Use the nonPrintable() method in the TextData\Trim class instead
     * @see TextData\Trim::nonPrintable()
     *
     * @param mixed $stringValue Value to check
     *
     * @return null|array|string
     */
    public static function TRIMNONPRINTABLE($stringValue = '')
    {
        return TextData\Trim::nonPrintable($stringValue);
    }

    /**
     * TRIMSPACES.
     *
     * @deprecated 1.18.0
     *      Use the spaces() method in the TextData\Trim class instead
     * @see TextData\Trim::spaces()
     *
     * @param mixed $stringValue Value to check
     *
     * @return array|string
     */
    public static function TRIMSPACES($stringValue = '')
    {
        return TextData\Trim::spaces($stringValue);
    }

    /**
     * ASCIICODE.
     *
     * @deprecated 1.18.0
     *      Use the code() method in the TextData\CharacterConvert class instead
     * @see TextData\CharacterConvert::code()
     *
     * @param array|string $characters Value
     *
     * @return array|int|string A string if arguments are invalid
     */
    public static function ASCIICODE($characters)
    {
        return TextData\CharacterConvert::code($characters);
    }

    /**
     * CONCATENATE.
     *
     * @deprecated 1.18.0
     *      Use the CONCATENATE() method in the TextData\Concatenate class instead
     * @see TextData\Concatenate::CONCATENATE()
     *
     * @param array $args
     *
     * @return string
     */
    public static function CONCATENATE(...$args)
    {
        return TextData\Concatenate::CONCATENATE(...$args);
    }

    /**
     * DOLLAR.
     *
     * This function converts a number to text using currency format, with the decimals rounded to the specified place.
     * The format used is $#,##0.00_);($#,##0.00)..
     *
     * @deprecated 1.18.0
     *      Use the DOLLAR() method in the TextData\Format class instead
     * @see TextData\Format::DOLLAR()
     *
     * @param float $value The value to format
     * @param int $decimals The number of digits to display to the right of the decimal point.
     *                                    If decimals is negative, number is rounded to the left of the decimal point.
     *                                    If you omit decimals, it is assumed to be 2
     *
     * @return array|string
     */
    public static function DOLLAR($value = 0, $decimals = 2)
    {
        return TextData\Format::DOLLAR($value, $decimals);
    }

    /**
     * FIND.
     *
     * @deprecated 1.18.0
     *      Use the sensitive() method in the TextData\Search class instead
     * @see TextData\Search::sensitive()
     *
     * @param array|string $needle The string to look for
     * @param array|string $haystack The string in which to look
     * @param array|int $offset Offset within $haystack
     *
     * @return array|int|string
     */
    public static function SEARCHSENSITIVE($needle, $haystack, $offset = 1)
    {
        return TextData\Search::sensitive($needle, $haystack, $offset);
    }

    /**
     * SEARCH.
     *
     * @deprecated 1.18.0
     *      Use the insensitive() method in the TextData\Search class instead
     * @see TextData\Search::insensitive()
     *
     * @param array|string $needle The string to look for
     * @param array|string $haystack The string in which to look
     * @param array|int $offset Offset within $haystack
     *
     * @return array|int|string
     */
    public static function SEARCHINSENSITIVE($needle, $haystack, $offset = 1)
    {
        return TextData\Search::insensitive($needle, $haystack, $offset);
    }

    /**
     * FIXEDFORMAT.
     *
     * @deprecated 1.18.0
     *      Use the FIXEDFORMAT() method in the TextData\Format class instead
     * @see TextData\Format::FIXEDFORMAT()
     *
     * @param mixed $value Value to check
     * @param int $decimals
     * @param bool $no_commas
     *
     * @return array|string
     */
    public static function FIXEDFORMAT($value, $decimals = 2, $no_commas = false)
    {
        return TextData\Format::FIXEDFORMAT($value, $decimals, $no_commas);
    }

    /**
     * LEFT.
     *
     * @deprecated 1.18.0
     *      Use the left() method in the TextData\Extract class instead
     * @see TextData\Extract::left()
     *
     * @param array|string $value Value
     * @param array|int $chars Number of characters
     *
     * @return array|string
     */
    public static function LEFT($value = '', $chars = 1)
    {
        return TextData\Extract::left($value, $chars);
    }

    /**
     * MID.
     *
     * @deprecated 1.18.0
     *      Use the mid() method in the TextData\Extract class instead
     * @see TextData\Extract::mid()
     *
     * @param array|string $value Value
     * @param array|int $start Start character
     * @param array|int $chars Number of characters
     *
     * @return array|string
     */
    public static function MID($value = '', $start = 1, $chars = null)
    {
        return TextData\Extract::mid($value, $start, $chars);
    }

    /**
     * RIGHT.
     *
     * @deprecated 1.18.0
     *      Use the right() method in the TextData\Extract class instead
     * @see TextData\Extract::right()
     *
     * @param array|string $value Value
     * @param array|int $chars Number of characters
     *
     * @return array|string
     */
    public static function RIGHT($value = '', $chars = 1)
    {
        return TextData\Extract::right($value, $chars);
    }

    /**
     * STRINGLENGTH.
     *
     * @deprecated 1.18.0
     *      Use the length() method in the TextData\Text class instead
     * @see TextData\Text::length()
     *
     * @param string $value Value
     *
     * @return array|int
     */
    public static function STRINGLENGTH($value = '')
    {
        return TextData\Text::length($value);
    }

    /**
     * LOWERCASE.
     *
     * Converts a string value to lower case.
     *
     * @deprecated 1.18.0
     *      Use the lower() method in the TextData\CaseConvert class instead
     * @see TextData\CaseConvert::lower()
     *
     * @param array|string $mixedCaseString
     *
     * @return array|string
     */
    public static function LOWERCASE($mixedCaseString)
    {
        return TextData\CaseConvert::lower($mixedCaseString);
    }

    /**
     * UPPERCASE.
     *
     * Converts a string value to upper case.
     *
     * @deprecated 1.18.0
     *      Use the upper() method in the TextData\CaseConvert class instead
     * @see TextData\CaseConvert::upper()
     *
     * @param string $mixedCaseString
     *
     * @return array|string
     */
    public static function UPPERCASE($mixedCaseString)
    {
        return TextData\CaseConvert::upper($mixedCaseString);
    }

    /**
     * PROPERCASE.
     *
     * Converts a string value to proper/title case.
     *
     * @deprecated 1.18.0
     *      Use the proper() method in the TextData\CaseConvert class instead
     * @see TextData\CaseConvert::proper()
     *
     * @param array|string $mixedCaseString
     *
     * @return array|string
     */
    public static function PROPERCASE($mixedCaseString)
    {
        return TextData\CaseConvert::proper($mixedCaseString);
    }

    /**
     * REPLACE.
     *
     * @deprecated 1.18.0
     *      Use the replace() method in the TextData\Replace class instead
     * @see TextData\Replace::replace()
     *
     * @param string $oldText String to modify
     * @param int $start Start character
     * @param int $chars Number of characters
     * @param string $newText String to replace in defined position
     *
     * @return array|string
     */
    public static function REPLACE($oldText, $start, $chars, $newText)
    {
        return TextData\Replace::replace($oldText, $start, $chars, $newText);
    }

    /**
     * SUBSTITUTE.
     *
     * @deprecated 1.18.0
     *      Use the substitute() method in the TextData\Replace class instead
     * @see TextData\Replace::substitute()
     *
     * @param string $text Value
     * @param string $fromText From Value
     * @param string $toText To Value
     * @param int $instance Instance Number
     *
     * @return array|string
     */
    public static function SUBSTITUTE($text = '', $fromText = '', $toText = '', $instance = 0)
    {
        return TextData\Replace::substitute($text, $fromText, $toText, $instance);
    }

    /**
     * RETURNSTRING.
     *
     * @deprecated 1.18.0
     *      Use the test() method in the TextData\Text class instead
     * @see TextData\Text::test()
     *
     * @param mixed $testValue Value to check
     *
     * @return null|array|string
     */
    public static function RETURNSTRING($testValue = '')
    {
        return TextData\Text::test($testValue);
    }

    /**
     * TEXTFORMAT.
     *
     * @deprecated 1.18.0
     *      Use the TEXTFORMAT() method in the TextData\Format class instead
     * @see TextData\Format::TEXTFORMAT()
     *
     * @param mixed $value Value to check
     * @param string $format Format mask to use
     *
     * @return array|string
     */
    public static function TEXTFORMAT($value, $format)
    {
        return TextData\Format::TEXTFORMAT($value, $format);
    }

    /**
     * VALUE.
     *
     * @deprecated 1.18.0
     *      Use the VALUE() method in the TextData\Format class instead
     * @see TextData\Format::VALUE()
     *
     * @param mixed $value Value to check
     *
     * @return array|DateTimeInterface|float|int|string A string if arguments are invalid
     */
    public static function VALUE($value = '')
    {
        return TextData\Format::VALUE($value);
    }

    /**
     * NUMBERVALUE.
     *
     * @deprecated 1.18.0
     *      Use the NUMBERVALUE() method in the TextData\Format class instead
     * @see TextData\Format::NUMBERVALUE()
     *
     * @param mixed $value Value to check
     * @param string $decimalSeparator decimal separator, defaults to locale defined value
     * @param string $groupSeparator group/thosands separator, defaults to locale defined value
     *
     * @return array|float|string
     */
    public static function NUMBERVALUE($value = '', $decimalSeparator = null, $groupSeparator = null)
    {
        return TextData\Format::NUMBERVALUE($value, $decimalSeparator, $groupSeparator);
    }

    /**
     * Compares two text strings and returns TRUE if they are exactly the same, FALSE otherwise.
     * EXACT is case-sensitive but ignores formatting differences.
     * Use EXACT to test text being entered into a document.
     *
     * @deprecated 1.18.0
     *      Use the exact() method in the TextData\Text class instead
     * @see TextData\Text::exact()
     *
     * @param mixed $value1
     * @param mixed $value2
     *
     * @return array|bool
     */
    public static function EXACT($value1, $value2)
    {
        return TextData\Text::exact($value1, $value2);
    }

    /**
     * TEXTJOIN.
     *
     * @deprecated 1.18.0
     *      Use the TEXTJOIN() method in the TextData\Concatenate class instead
     * @see TextData\Concatenate::TEXTJOIN()
     *
     * @param mixed $delimiter
     * @param mixed $ignoreEmpty
     * @param mixed $args
     *
     * @return array|string
     */
    public static function TEXTJOIN($delimiter, $ignoreEmpty, ...$args)
    {
        return TextData\Concatenate::TEXTJOIN($delimiter, $ignoreEmpty, ...$args);
    }

    /**
     * REPT.
     *
     * Returns the result of builtin function repeat after validating args.
     *
     * @deprecated 1.18.0
     *      Use the builtinREPT() method in the TextData\Concatenate class instead
     * @see TextData\Concatenate::builtinREPT()
     *
     * @param array|string $str Should be numeric
     * @param mixed $number Should be int
     *
     * @return array|string
     */
    public static function builtinREPT($str, $number)
    {
        return TextData\Concatenate::builtinREPT($str, $number);
    }
}

• [D] Database
• [D] DateTimeExcel
• [D] Engine
• [D] Engineering
• [D] Financial
• [D] Information
• [D] Internal
• [D] locale
• [D] Logical
• [D] LookupRef
• [D] MathTrig
• [D] Statistical
• [D] TextData
• [D] Token
• [D] Web
• [F] ArrayEnabled.php
  Delete
• [F] BinaryComparison.php
  Delete
• [F] Calculation.php
  Delete
• [F] Category.php
  Delete
• [F] Database.php
  Delete
• [F] DateTime.php
  Delete
• [F] Engineering.php
  Delete
• [F] Exception.php
  Delete
• [F] ExceptionHandler.php
  Delete
• [F] Financial.php
  Delete
• [F] FormulaParser.php
  Delete
• [F] FormulaToken.php
  Delete
• [F] Functions.php
  Delete
• [F] Logical.php
  Delete
• [F] LookupRef.php
  Delete
• [F] MathTrig.php
  Delete
• [F] Statistical.php
  Delete
• [F] TextData.php
  Delete
• [F] Web.php
  Delete

Developer

• Support

Back to Home page