<?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);
}
}
Discover the Latest in Digital Payments and NFC Technology
Dive into our blog to explore the cutting-edge trends in digital payments and NFC technology. Stay updated on the innovations that are revolutionizing transactions, boosting security, and making payments quicker and more convenient. Learn how these advancements are shaping the future of financial interactions and driving the global transition towards a cashless world.
The Rise of Contactless Payments:...
In recent years, contactless payments have surged in popularity, driven...
Enhancing Payment Security: The Role...
As digital transactions proliferate, ensuring robust payment security is more critical than ever. Two foundational...
The Future of Digital Wallets:...
Digital wallets have fundamentally transformed how we manage money, offering a streamlined, secure, and highly...
In the digital age, privacy concerns have become increasingly paramount, prompting the European Union to enact the General Data Protection Regulation (GDPR) in 2018. Among its many provisions, GDPR sets strict guidelines for the collection and processing of personal data, including the use of cookies on websites. Privacy Policy
