You are here

Home » API reference » Loft Data Grids 7.2 » TextData.php

class PHPExcel_Calculation_TextData in Loft Data Grids 7.2

Same name and namespace in other branches
  1. 6.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php \PHPExcel_Calculation_TextData

PHPExcel_Calculation_TextData

@category PHPExcel @package PHPExcel_Calculation @copyright Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)

Hierarchy

Expanded class hierarchy of PHPExcel_Calculation_TextData

21 string references to 'PHPExcel_Calculation_TextData'
TextDataTest::testCHAR in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/TextDataTest.php
@dataProvider providerCHAR
TextDataTest::testCLEAN in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/TextDataTest.php
@dataProvider providerCLEAN
TextDataTest::testCODE in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/TextDataTest.php
@dataProvider providerCODE
TextDataTest::testCONCATENATE in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/TextDataTest.php
@dataProvider providerCONCATENATE
TextDataTest::testDOLLAR in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Calculation/TextDataTest.php
@dataProvider providerDOLLAR

... See full list

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Calculation/TextData.php, line 46

View source 
class PHPExcel_Calculation_TextData {
  private static $_invalidChars = Null;
  private static function _uniord($c) {
    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()

  /**
   * CHARACTER
   *
   * @param	string	$character	Value
   * @return	int
   */
  public static function CHARACTER($character) {
    $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));
    }
  }

  /**
   * TRIMNONPRINTABLE
   *
   * @param	mixed	$stringValue	Value to check
   * @return	string
   */
  public static function TRIMNONPRINTABLE($stringValue = '') {
    $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, "\0..\37"));
    }
    return NULL;
  }

  //	function TRIMNONPRINTABLE()

  /**
   * TRIMSPACES
   *
   * @param	mixed	$stringValue	Value to check
   * @return	string
   */
  public static function TRIMSPACES($stringValue = '') {
    $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()

  /**
   * ASCIICODE
   *
   * @param	string	$characters		Value
   * @return	int
   */
  public static function ASCIICODE($characters) {
    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()

  /**
   * CONCATENATE
   *
   * @return	string
   */
  public static function CONCATENATE() {

    // 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()

  /**
   * 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)..
   *
   * @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	string
   */
  public static function DOLLAR($value = 0, $decimals = 2) {
    $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()

  /**
   * SEARCHSENSITIVE
   *
   * @param	string	$needle		The string to look for
   * @param	string	$haystack	The string in which to look
   * @param	int		$offset		Offset within $haystack
   * @return	string
   */
  public static function SEARCHSENSITIVE($needle, $haystack, $offset = 1) {
    $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()

  /**
   * SEARCHINSENSITIVE
   *
   * @param	string	$needle		The string to look for
   * @param	string	$haystack	The string in which to look
   * @param	int		$offset		Offset within $haystack
   * @return	string
   */
  public static function SEARCHINSENSITIVE($needle, $haystack, $offset = 1) {
    $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()

  /**
   * FIXEDFORMAT
   *
   * @param	mixed		$value	Value to check
   * @param	integer		$decimals
   * @param	boolean		$no_commas
   * @return	boolean
   */
  public static function FIXEDFORMAT($value, $decimals = 2, $no_commas = FALSE) {
    $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()

  /**
   * LEFT
   *
   * @param	string	$value	Value
   * @param	int		$chars	Number of characters
   * @return	string
   */
  public static function LEFT($value = '', $chars = 1) {
    $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()

  /**
   * MID
   *
   * @param	string	$value	Value
   * @param	int		$start	Start character
   * @param	int		$chars	Number of characters
   * @return	string
   */
  public static function MID($value = '', $start = 1, $chars = null) {
    $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()

  /**
   * RIGHT
   *
   * @param	string	$value	Value
   * @param	int		$chars	Number of characters
   * @return	string
   */
  public static function RIGHT($value = '', $chars = 1) {
    $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()

  /**
   * STRINGLENGTH
   *
   * @param	string	$value	Value
   * @return	string
   */
  public static function STRINGLENGTH($value = '') {
    $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()

  /**
   * LOWERCASE
   *
   * Converts a string value to upper case.
   *
   * @param	string		$mixedCaseString
   * @return	string
   */
  public static function LOWERCASE($mixedCaseString) {
    $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()

  /**
   * UPPERCASE
   *
   * Converts a string value to upper case.
   *
   * @param	string		$mixedCaseString
   * @return	string
   */
  public static function UPPERCASE($mixedCaseString) {
    $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()

  /**
   * PROPERCASE
   *
   * Converts a string value to upper case.
   *
   * @param	string		$mixedCaseString
   * @return	string
   */
  public static function PROPERCASE($mixedCaseString) {
    $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()

  /**
   * 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	string
   */
  public static function REPLACE($oldText = '', $start = 1, $chars = null, $newText) {
    $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()

  /**
   * SUBSTITUTE
   *
   * @param	string	$text		Value
   * @param	string	$fromText	From Value
   * @param	string	$toText		To Value
   * @param	integer	$instance	Instance Number
   * @return	string
   */
  public static function SUBSTITUTE($text = '', $fromText = '', $toText = '', $instance = 0) {
    $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()

  /**
   * RETURNSTRING
   *
   * @param	mixed	$testValue	Value to check
   * @return	boolean
   */
  public static function RETURNSTRING($testValue = '') {
    $testValue = PHPExcel_Calculation_Functions::flattenSingleValue($testValue);
    if (is_string($testValue)) {
      return $testValue;
    }
    return Null;
  }

  //	function RETURNSTRING()

  /**
   * TEXTFORMAT
   *
   * @param	mixed	$value	Value to check
   * @param	string	$format	Format mask to use
   * @return	boolean
   */
  public static function TEXTFORMAT($value, $format) {
    $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()

  /**
   * VALUE
   *
   * @param	mixed	$value	Value to check
   * @return	boolean
   */
  public static function VALUE($value = '') {
    $value = PHPExcel_Calculation_Functions::flattenSingleValue($value);
    if (!is_numeric($value)) {
      $numberValue = str_replace(PHPExcel_Shared_String::getThousandsSeparator(), '', trim($value, " \t\n\r\0\v" . PHPExcel_Shared_String::getCurrencyCode()));
      if (is_numeric($numberValue)) {
        return (double) $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 (double) $value;
  }

}

Members

Namesort descending Modifiers Type Description Overrides
PHPExcel_Calculation_TextData::$_invalidChars private static property
PHPExcel_Calculation_TextData::ASCIICODE public static function * ASCIICODE * *
PHPExcel_Calculation_TextData::CHARACTER public static function * CHARACTER * *
PHPExcel_Calculation_TextData::CONCATENATE public static function * CONCATENATE * *
PHPExcel_Calculation_TextData::DOLLAR public static function * 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).. * *
PHPExcel_Calculation_TextData::FIXEDFORMAT public static function * FIXEDFORMAT * *
PHPExcel_Calculation_TextData::LEFT public static function * LEFT * *
PHPExcel_Calculation_TextData::LOWERCASE public static function * LOWERCASE * * Converts a string value to upper case. * *
PHPExcel_Calculation_TextData::MID public static function * MID * *
PHPExcel_Calculation_TextData::PROPERCASE public static function * PROPERCASE * * Converts a string value to upper case. * *
PHPExcel_Calculation_TextData::REPLACE public static function * REPLACE * *
PHPExcel_Calculation_TextData::RETURNSTRING public static function * RETURNSTRING * *
PHPExcel_Calculation_TextData::RIGHT public static function * RIGHT * *
PHPExcel_Calculation_TextData::SEARCHINSENSITIVE public static function * SEARCHINSENSITIVE * *
PHPExcel_Calculation_TextData::SEARCHSENSITIVE public static function * SEARCHSENSITIVE * *
PHPExcel_Calculation_TextData::STRINGLENGTH public static function * STRINGLENGTH * *
PHPExcel_Calculation_TextData::SUBSTITUTE public static function * SUBSTITUTE * *
PHPExcel_Calculation_TextData::TEXTFORMAT public static function * TEXTFORMAT * *
PHPExcel_Calculation_TextData::TRIMNONPRINTABLE public static function * TRIMNONPRINTABLE * *
PHPExcel_Calculation_TextData::TRIMSPACES public static function * TRIMSPACES * *
PHPExcel_Calculation_TextData::UPPERCASE public static function * UPPERCASE * * Converts a string value to upper case. * *
PHPExcel_Calculation_TextData::VALUE public static function * VALUE * *
PHPExcel_Calculation_TextData::_uniord private static function