PHPExcel_Calculation_TextData Class Reference

Collaboration diagram for PHPExcel_Calculation_TextData:

Static Public Member Functions
static	CHARACTER ($character)
	CHARACTER. More...
static	TRIMNONPRINTABLE ($stringValue='')
	TRIMNONPRINTABLE. More...
static	TRIMSPACES ($stringValue='')
	TRIMSPACES. More...
static	ASCIICODE ($characters)
	ASCIICODE. More...
static	CONCATENATE ()
	CONCATENATE. More...
static	DOLLAR ($value=0, $decimals=2)
	DOLLAR. More...
static	SEARCHSENSITIVE ($needle, $haystack, $offset=1)
	SEARCHSENSITIVE. More...
static	SEARCHINSENSITIVE ($needle, $haystack, $offset=1)
	SEARCHINSENSITIVE. More...
static	FIXEDFORMAT ($value, $decimals=2, $no_commas=FALSE)
	FIXEDFORMAT. More...
static	LEFT ($value='', $chars=1)
	LEFT. More...
static	MID ($value='', $start=1, $chars=null)
	MID. More...
static	RIGHT ($value='', $chars=1)
	RIGHT. More...
static	STRINGLENGTH ($value='')
	STRINGLENGTH. More...
static	LOWERCASE ($mixedCaseString)
	LOWERCASE. More...
static	UPPERCASE ($mixedCaseString)
	UPPERCASE. More...
static	PROPERCASE ($mixedCaseString)
	PROPERCASE. More...
static	REPLACE ($oldText='', $start=1, $chars=null, $newText)
	REPLACE. More...
static	SUBSTITUTE ($text='', $fromText='', $toText='', $instance=0)
	SUBSTITUTE. More...
static	RETURNSTRING ($testValue='')
	RETURNSTRING. More...
static	TEXTFORMAT ($value, $format)
	TEXTFORMAT. More...
static	VALUE ($value='')
	VALUE. More...

Static Private Member Functions
static	_uniord ($c)

Static Private Attributes
static	$_invalidChars = Null

Detailed Description

Definition at line 46 of file TextData.php.

Member Function Documentation

_uniord()

static PHPExcel_Calculation_TextData::_uniord (   $c )

staticprivate

Definition at line 50 of file TextData.php.

References PHPExcel_Calculation_Functions\VALUE().

                                            {
                if (ord($c{0}) >=0 && ord($c{0}) <= 127)
                        return ord($c{0});
                if (ord($c{0}) >= 192 && ord($c{0}) <= 223)
                        return (ord($c{0})-192)*64 + (ord($c{1})-128);
                if (ord($c{0}) >= 224 && ord($c{0}) <= 239)
                        return (ord($c{0})-224)*4096 + (ord($c{1})-128)*64 + (ord($c{2})-128);
                if (ord($c{0}) >= 240 && ord($c{0}) <= 247)
                        return (ord($c{0})-240)*262144 + (ord($c{1})-128)*4096 + (ord($c{2})-128)*64 + (ord($c{3})-128);
                if (ord($c{0}) >= 248 && ord($c{0}) <= 251)
                        return (ord($c{0})-248)*16777216 + (ord($c{1})-128)*262144 + (ord($c{2})-128)*4096 + (ord($c{3})-128)*64 + (ord($c{4})-128);
                if (ord($c{0}) >= 252 && ord($c{0}) <= 253)
                        return (ord($c{0})-252)*1073741824 + (ord($c{1})-128)*16777216 + (ord($c{2})-128)*262144 + (ord($c{3})-128)*4096 + (ord($c{4})-128)*64 + (ord($c{5})-128);
                if (ord($c{0}) >= 254 && ord($c{0}) <= 255) //error
                        return PHPExcel_Calculation_Functions::VALUE();
                return 0;
        }       //      function _uniord()

Here is the call graph for this function:

ASCIICODE()

static PHPExcel_Calculation_TextData::ASCIICODE (   $characters )

static

ASCIICODE.

Parameters

string

$characters

Value

Returns

int

Definition at line 138 of file TextData.php.

References PHPExcel_Calculation_Functions\COMPATIBILITY_OPENOFFICE, PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation_Functions\getCompatibilityMode(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                      {
                if (($characters === NULL) || ($characters === ''))
                        return PHPExcel_Calculation_Functions::VALUE();
                $characters     = PHPExcel_Calculation_Functions::flattenSingleValue($characters);
                if (is_bool($characters)) {
                        if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
                                $characters = (int) $characters;
                        } else {
                                $characters = ($characters) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                        }
                }

                $character = $characters;
                if ((function_exists('mb_strlen')) && (function_exists('mb_substr'))) {
                        if (mb_strlen($characters, 'UTF-8') > 1) { $character = mb_substr($characters, 0, 1, 'UTF-8'); }
                        return self::_uniord($character);
                } else {
                        if (strlen($characters) > 0) { $character = substr($characters, 0, 1); }
                        return ord($character);
                }
        }       //      function ASCIICODE()

Here is the call graph for this function:

CHARACTER()

static PHPExcel_Calculation_TextData::CHARACTER (   $character )

static

CHARACTER.

Parameters

string

$character

Value

Returns

int

Definition at line 74 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\VALUE().

                                                     {
                $character      = PHPExcel_Calculation_Functions::flattenSingleValue($character);

                if ((!is_numeric($character)) || ($character < 0)) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }

                if (function_exists('mb_convert_encoding')) {
                        return mb_convert_encoding('&#'.intval($character).';', 'UTF-8', 'HTML-ENTITIES');
                } else {
                        return chr(intval($character));
                }
        }

Here is the call graph for this function:

CONCATENATE()

static PHPExcel_Calculation_TextData::CONCATENATE ( )

static

CONCATENATE.

Returns

string

Definition at line 166 of file TextData.php.

References PHPExcel_Calculation_Functions\COMPATIBILITY_OPENOFFICE, PHPExcel_Calculation_Functions\flattenArray(), PHPExcel_Calculation_Functions\getCompatibilityMode(), PHPExcel_Calculation\getFALSE(), and PHPExcel_Calculation\getTRUE().

                                             {
                // Return value
                $returnValue = '';

                // Loop through arguments
                $aArgs = PHPExcel_Calculation_Functions::flattenArray(func_get_args());
                foreach ($aArgs as $arg) {
                        if (is_bool($arg)) {
                                if (PHPExcel_Calculation_Functions::getCompatibilityMode() == PHPExcel_Calculation_Functions::COMPATIBILITY_OPENOFFICE) {
                                        $arg = (int) $arg;
                                } else {
                                        $arg = ($arg) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                                }
                        }
                        $returnValue .= $arg;
                }

                // Return
                return $returnValue;
        }       //      function CONCATENATE()

Here is the call graph for this function:

DOLLAR()

static PHPExcel_Calculation_TextData::DOLLAR (   $value = 0,   $decimals = 2  )

static

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)..

Parameters

float	$value	The value to format
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

Returns

string

Definition at line 200 of file TextData.php.

References $mask, PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation_MathTrig\MROUND(), PHPExcel_Calculation_Functions\NaN(), and PHPExcel_Style_NumberFormat\toFormattedString().

                                                                 {
                $value          = PHPExcel_Calculation_Functions::flattenSingleValue($value);
                $decimals       = is_null($decimals) ? 0 : PHPExcel_Calculation_Functions::flattenSingleValue($decimals);

                // Validate parameters
                if (!is_numeric($value) || !is_numeric($decimals)) {
                        return PHPExcel_Calculation_Functions::NaN();
                }
                $decimals = floor($decimals);

                $mask = '$#,##0';
                if ($decimals > 0) {
                        $mask .= '.' . str_repeat('0',$decimals);
                } else {
                        $round = pow(10,abs($decimals));
                        if ($value < 0) { $round = 0-$round; }
                        $value = PHPExcel_Calculation_MathTrig::MROUND($value, $round);
                }

                return PHPExcel_Style_NumberFormat::toFormattedString($value, $mask);

        }       //      function DOLLAR()

Here is the call graph for this function:

FIXEDFORMAT()

static PHPExcel_Calculation_TextData::FIXEDFORMAT (   $value,   $decimals = 2,   $no_commas = FALSE  )

static

FIXEDFORMAT.

Parameters

mixed	$value	Value to check
integer	$decimals
boolean	$no_commas

Returns

boolean

Definition at line 304 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), and PHPExcel_Calculation_Functions\NaN().

                                                                                      {
                $value          = PHPExcel_Calculation_Functions::flattenSingleValue($value);
                $decimals       = PHPExcel_Calculation_Functions::flattenSingleValue($decimals);
                $no_commas      = PHPExcel_Calculation_Functions::flattenSingleValue($no_commas);

                // Validate parameters
                if (!is_numeric($value) || !is_numeric($decimals)) {
                        return PHPExcel_Calculation_Functions::NaN();
                }
                $decimals = floor($decimals);

                $valueResult = round($value,$decimals);
                if ($decimals < 0) { $decimals = 0; }
                if (!$no_commas) {
                        $valueResult = number_format($valueResult,$decimals);
                }

                return (string) $valueResult;
        }       //      function FIXEDFORMAT()

Here is the call graph for this function:

LEFT()

static PHPExcel_Calculation_TextData::LEFT (   $value = '',   $chars = 1  )

static

LEFT.

Parameters

string	$value	Value
int	$chars	Number of characters

Returns

string

Definition at line 332 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                             {
                $value          = PHPExcel_Calculation_Functions::flattenSingleValue($value);
                $chars          = PHPExcel_Calculation_Functions::flattenSingleValue($chars);

                if ($chars < 0) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }

                if (is_bool($value)) {
                        $value = ($value) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                if (function_exists('mb_substr')) {
                        return mb_substr($value, 0, $chars, 'UTF-8');
                } else {
                        return substr($value, 0, $chars);
                }
        }       //      function LEFT()

Here is the call graph for this function:

LOWERCASE()

static PHPExcel_Calculation_TextData::LOWERCASE (   $mixedCaseString )

static

LOWERCASE.

Converts a string value to upper case.

Parameters

string

$mixedCaseString

Returns

string

Definition at line 437 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Shared_String\StrToLower().

                                                           {
                $mixedCaseString        = PHPExcel_Calculation_Functions::flattenSingleValue($mixedCaseString);

                if (is_bool($mixedCaseString)) {
                        $mixedCaseString = ($mixedCaseString) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                return PHPExcel_Shared_String::StrToLower($mixedCaseString);
        }       //      function LOWERCASE()

Here is the call graph for this function:

MID()

static PHPExcel_Calculation_TextData::MID (   $value = '',   $start = 1,   $chars = null  )

static

MID.

Parameters

string	$value	Value
int	$start	Start character
int	$chars	Number of characters

Returns

string

Definition at line 360 of file TextData.php.

References $start, PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                                           {
                $value          = PHPExcel_Calculation_Functions::flattenSingleValue($value);
                $start          = PHPExcel_Calculation_Functions::flattenSingleValue($start);
                $chars          = PHPExcel_Calculation_Functions::flattenSingleValue($chars);

                if (($start < 1) || ($chars < 0)) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }

                if (is_bool($value)) {
                        $value = ($value) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                if (function_exists('mb_substr')) {
                        return mb_substr($value, --$start, $chars, 'UTF-8');
                } else {
                        return substr($value, --$start, $chars);
                }
        }       //      function MID()

Here is the call graph for this function:

PROPERCASE()

static PHPExcel_Calculation_TextData::PROPERCASE (   $mixedCaseString )

static

PROPERCASE.

Converts a string value to upper case.

Parameters

string

$mixedCaseString

Returns

string

Definition at line 475 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Shared_String\StrToTitle().

                                                            {
                $mixedCaseString        = PHPExcel_Calculation_Functions::flattenSingleValue($mixedCaseString);

                if (is_bool($mixedCaseString)) {
                        $mixedCaseString = ($mixedCaseString) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                return PHPExcel_Shared_String::StrToTitle($mixedCaseString);
        }       //      function PROPERCASE()

Here is the call graph for this function:

REPLACE()

static PHPExcel_Calculation_TextData::REPLACE (   $oldText = '',   $start = 1,   $chars = null,   $newText  )

static

REPLACE.

Parameters

string	$oldText	String to modify
int	$start	Start character
int	$chars	Number of characters
string	$newText	String to replace in defined position

Returns

string

Definition at line 495 of file TextData.php.

References $start, and PHPExcel_Calculation_Functions\flattenSingleValue().

                                                                                           {
                $oldText        = PHPExcel_Calculation_Functions::flattenSingleValue($oldText);
                $start          = PHPExcel_Calculation_Functions::flattenSingleValue($start);
                $chars          = PHPExcel_Calculation_Functions::flattenSingleValue($chars);
                $newText        = PHPExcel_Calculation_Functions::flattenSingleValue($newText);

                $left = self::LEFT($oldText,$start-1);
                $right = self::RIGHT($oldText,self::STRINGLENGTH($oldText)-($start+$chars)+1);

                return $left.$newText.$right;
        }       //      function REPLACE()

Here is the call graph for this function:

RETURNSTRING()

static PHPExcel_Calculation_TextData::RETURNSTRING (   $testValue = '' )

static

RETURNSTRING.

Parameters

mixed

$testValue

Value to check

Returns

boolean

Definition at line 561 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue().

                                                             {
                $testValue      = PHPExcel_Calculation_Functions::flattenSingleValue($testValue);

                if (is_string($testValue)) {
                        return $testValue;
                }
                return Null;
        }       //      function RETURNSTRING()

Here is the call graph for this function:

RIGHT()

static PHPExcel_Calculation_TextData::RIGHT (   $value = '',   $chars = 1  )

static

RIGHT.

Parameters

string	$value	Value
int	$chars	Number of characters

Returns

string

Definition at line 388 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                              {
                $value          = PHPExcel_Calculation_Functions::flattenSingleValue($value);
                $chars          = PHPExcel_Calculation_Functions::flattenSingleValue($chars);

                if ($chars < 0) {
                        return PHPExcel_Calculation_Functions::VALUE();
                }

                if (is_bool($value)) {
                        $value = ($value) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                if ((function_exists('mb_substr')) && (function_exists('mb_strlen'))) {
                        return mb_substr($value, mb_strlen($value, 'UTF-8') - $chars, $chars, 'UTF-8');
                } else {
                        return substr($value, strlen($value) - $chars);
                }
        }       //      function RIGHT()

Here is the call graph for this function:

SEARCHINSENSITIVE()

static PHPExcel_Calculation_TextData::SEARCHINSENSITIVE (   $needle,   $haystack,   $offset = 1  )

static

SEARCHINSENSITIVE.

Parameters

string	$needle	The string to look for
string	$haystack	The string in which to look
int	$offset	Offset within $haystack

Returns

string

Definition at line 268 of file TextData.php.

References PHPExcel_Shared_String\CountCharacters(), PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                                              {
                $needle         = PHPExcel_Calculation_Functions::flattenSingleValue($needle);
                $haystack       = PHPExcel_Calculation_Functions::flattenSingleValue($haystack);
                $offset         = PHPExcel_Calculation_Functions::flattenSingleValue($offset);

                if (!is_bool($needle)) {
                        if (is_bool($haystack)) {
                                $haystack = ($haystack) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                        }

                        if (($offset > 0) && (PHPExcel_Shared_String::CountCharacters($haystack) > $offset)) {
                                if (PHPExcel_Shared_String::CountCharacters($needle) == 0) {
                                        return $offset;
                                }
                                if (function_exists('mb_stripos')) {
                                        $pos = mb_stripos($haystack, $needle, --$offset,'UTF-8');
                                } else {
                                        $pos = stripos($haystack, $needle, --$offset);
                                }
                                if ($pos !== false) {
                                        return ++$pos;
                                }
                        }
                }
                return PHPExcel_Calculation_Functions::VALUE();
        }       //      function SEARCHINSENSITIVE()

Here is the call graph for this function:

SEARCHSENSITIVE()

static PHPExcel_Calculation_TextData::SEARCHSENSITIVE (   $needle,   $haystack,   $offset = 1  )

static

SEARCHSENSITIVE.

Parameters

string	$needle	The string to look for
string	$haystack	The string in which to look
int	$offset	Offset within $haystack

Returns

string

Definition at line 232 of file TextData.php.

References PHPExcel_Shared_String\CountCharacters(), PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                                            {
                $needle         = PHPExcel_Calculation_Functions::flattenSingleValue($needle);
                $haystack       = PHPExcel_Calculation_Functions::flattenSingleValue($haystack);
                $offset         = PHPExcel_Calculation_Functions::flattenSingleValue($offset);

                if (!is_bool($needle)) {
                        if (is_bool($haystack)) {
                                $haystack = ($haystack) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                        }

                        if (($offset > 0) && (PHPExcel_Shared_String::CountCharacters($haystack) > $offset)) {
                                if (PHPExcel_Shared_String::CountCharacters($needle) == 0) {
                                        return $offset;
                                }
                                if (function_exists('mb_strpos')) {
                                        $pos = mb_strpos($haystack, $needle, --$offset, 'UTF-8');
                                } else {
                                        $pos = strpos($haystack, $needle, --$offset);
                                }
                                if ($pos !== false) {
                                        return ++$pos;
                                }
                        }
                }
                return PHPExcel_Calculation_Functions::VALUE();
        }       //      function SEARCHSENSITIVE()

Here is the call graph for this function:

STRINGLENGTH()

static PHPExcel_Calculation_TextData::STRINGLENGTH (   $value = '' )

static

STRINGLENGTH.

Parameters

string

$value

Value

Returns

string

Definition at line 414 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), and PHPExcel_Calculation\getTRUE().

                                                         {
                $value          = PHPExcel_Calculation_Functions::flattenSingleValue($value);

                if (is_bool($value)) {
                        $value = ($value) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                if (function_exists('mb_strlen')) {
                        return mb_strlen($value, 'UTF-8');
                } else {
                        return strlen($value);
                }
        }       //      function STRINGLENGTH()

Here is the call graph for this function:

SUBSTITUTE()

static PHPExcel_Calculation_TextData::SUBSTITUTE (   $text = '',   $fromText = '',   $toText = '',   $instance = 0  )

static

SUBSTITUTE.

Parameters

string	$text	Value
string	$fromText	From Value
string	$toText	To Value
integer	$instance	Instance Number

Returns

string

Definition at line 517 of file TextData.php.

References $text, and PHPExcel_Calculation_Functions\flattenSingleValue().

                                                                                                   {
                $text           = PHPExcel_Calculation_Functions::flattenSingleValue($text);
                $fromText       = PHPExcel_Calculation_Functions::flattenSingleValue($fromText);
                $toText         = PHPExcel_Calculation_Functions::flattenSingleValue($toText);
                $instance       = floor(PHPExcel_Calculation_Functions::flattenSingleValue($instance));

                if ($instance == 0) {
                        if(function_exists('mb_str_replace')) {
                                return mb_str_replace($fromText,$toText,$text);
                        } else {
                                return str_replace($fromText,$toText,$text);
                        }
                } else {
                        $pos = -1;
                        while($instance > 0) {
                                if (function_exists('mb_strpos')) {
                                        $pos = mb_strpos($text, $fromText, $pos+1, 'UTF-8');
                                } else {
                                        $pos = strpos($text, $fromText, $pos+1);
                                }
                                if ($pos === false) {
                                        break;
                                }
                                --$instance;
                        }
                        if ($pos !== false) {
                                if (function_exists('mb_strlen')) {
                                        return self::REPLACE($text,++$pos,mb_strlen($fromText, 'UTF-8'),$toText);
                                } else {
                                        return self::REPLACE($text,++$pos,strlen($fromText),$toText);
                                }
                        }
                }

                return $text;
        }       //      function SUBSTITUTE()

Here is the call graph for this function:

TEXTFORMAT()

static PHPExcel_Calculation_TextData::TEXTFORMAT (   $value,   $format  )

static

TEXTFORMAT.

Parameters

mixed	$value	Value to check
string	$format	Format mask to use

Returns

boolean

Definition at line 578 of file TextData.php.

References PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Shared_Date\isDateTimeFormatCode(), and PHPExcel_Style_NumberFormat\toFormattedString().

                                                          {
                $value  = PHPExcel_Calculation_Functions::flattenSingleValue($value);
                $format = PHPExcel_Calculation_Functions::flattenSingleValue($format);

                if ((is_string($value)) && (!is_numeric($value)) && PHPExcel_Shared_Date::isDateTimeFormatCode($format)) {
                        $value = PHPExcel_Calculation_DateTime::DATEVALUE($value);
                }

                return (string) PHPExcel_Style_NumberFormat::toFormattedString($value,$format);
        }       //      function TEXTFORMAT()

Here is the call graph for this function:

TRIMNONPRINTABLE()

static PHPExcel_Calculation_TextData::TRIMNONPRINTABLE (   $stringValue = '' )

static

TRIMNONPRINTABLE.

Parameters

mixed

$stringValue

Value to check

Returns

string

Definition at line 95 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and range.

                                                                   {
                $stringValue    = PHPExcel_Calculation_Functions::flattenSingleValue($stringValue);

                if (is_bool($stringValue)) {
                        return ($stringValue) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                if (self::$_invalidChars == Null) {
                        self::$_invalidChars = range(chr(0),chr(31));
                }

                if (is_string($stringValue) || is_numeric($stringValue)) {
                        return str_replace(self::$_invalidChars, '', trim($stringValue, "\x00..\x1F"));
                }
                return NULL;
        }       //      function TRIMNONPRINTABLE()

Here is the call graph for this function:

TRIMSPACES()

static PHPExcel_Calculation_TextData::TRIMSPACES (   $stringValue = '' )

static

TRIMSPACES.

Parameters

mixed

$stringValue

Value to check

Returns

string

Definition at line 119 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), and PHPExcel_Calculation\getTRUE().

                                                             {
                $stringValue    = PHPExcel_Calculation_Functions::flattenSingleValue($stringValue);
                if (is_bool($stringValue)) {
                        return ($stringValue) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                if (is_string($stringValue) || is_numeric($stringValue)) {
                        return trim(preg_replace('/ +/',' ',trim($stringValue, ' ')), ' ');
                }
                return NULL;
        }       //      function TRIMSPACES()

Here is the call graph for this function:

UPPERCASE()

static PHPExcel_Calculation_TextData::UPPERCASE (   $mixedCaseString )

static

UPPERCASE.

Converts a string value to upper case.

Parameters

string

$mixedCaseString

Returns

string

Definition at line 456 of file TextData.php.

References PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Calculation\getFALSE(), PHPExcel_Calculation\getTRUE(), and PHPExcel_Shared_String\StrToUpper().

                                                           {
                $mixedCaseString        = PHPExcel_Calculation_Functions::flattenSingleValue($mixedCaseString);

                if (is_bool($mixedCaseString)) {
                        $mixedCaseString = ($mixedCaseString) ? PHPExcel_Calculation::getTRUE() : PHPExcel_Calculation::getFALSE();
                }

                return PHPExcel_Shared_String::StrToUpper($mixedCaseString);
        }       //      function UPPERCASE()

Here is the call graph for this function:

VALUE()

static PHPExcel_Calculation_TextData::VALUE (   $value = '' )

static

VALUE.

Parameters

mixed

$value

Value to check

Returns

boolean

Definition at line 595 of file TextData.php.

References PHPExcel_Calculation_DateTime\DATEVALUE(), PHPExcel_Calculation_Functions\flattenSingleValue(), PHPExcel_Shared_String\getCurrencyCode(), PHPExcel_Calculation_Functions\getReturnDateType(), PHPExcel_Shared_String\getThousandsSeparator(), PHPExcel_Calculation_Functions\RETURNDATE_EXCEL, PHPExcel_Calculation_Functions\setReturnDateType(), PHPExcel_Calculation_DateTime\TIMEVALUE(), and PHPExcel_Calculation_Functions\VALUE().

                                                  {
                $value  = PHPExcel_Calculation_Functions::flattenSingleValue($value);

                if (!is_numeric($value)) {
            $numberValue = str_replace(
                PHPExcel_Shared_String::getThousandsSeparator(), 
                '', 
                trim($value, " \t\n\r\0\x0B" . PHPExcel_Shared_String::getCurrencyCode())
            );
            if (is_numeric($numberValue)) {
                return (float) $numberValue;
            }

            $dateSetting = PHPExcel_Calculation_Functions::getReturnDateType();
            PHPExcel_Calculation_Functions::setReturnDateType(PHPExcel_Calculation_Functions::RETURNDATE_EXCEL);

            if (strpos($value, ':') !== false) {
                $timeValue = PHPExcel_Calculation_DateTime::TIMEVALUE($value);
                if ($timeValue !== PHPExcel_Calculation_Functions::VALUE()) {
                    PHPExcel_Calculation_Functions::setReturnDateType($dateSetting);
                    return $timeValue;
                }
            }
                        $dateValue = PHPExcel_Calculation_DateTime::DATEVALUE($value);
            if ($dateValue !== PHPExcel_Calculation_Functions::VALUE()) {
                PHPExcel_Calculation_Functions::setReturnDateType($dateSetting);
                return $dateValue;
            }
            PHPExcel_Calculation_Functions::setReturnDateType($dateSetting);

                        return PHPExcel_Calculation_Functions::VALUE();
                }
                return (float) $value;
        }

Here is the call graph for this function:

Field Documentation

$_invalidChars

PHPExcel_Calculation_TextData::$_invalidChars = Null

staticprivate

Definition at line 48 of file TextData.php.

---

The documentation for this class was generated from the following file:

• libs/composer/vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php