/
home
/
sjslayjy
/
public_html
/
drone
/
vendor
/
phpoffice
/
phpspreadsheet
/
src
/
PhpSpreadsheet
/
Calculation
/
Upload File
HOME
<?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); } }