class PHPExcel_Cell_DataType in Loft Data Grids 7.2

PHPExcel_Cell_DataType

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

Hierarchy

• class \PHPExcel_Cell_DataType

1 string reference to 'PHPExcel_Cell_DataType'

DataTypeTest::testGetErrorCodes in vendor/phpoffice/phpexcel/unitTests/Classes/PHPExcel/Cell/DataTypeTest.php

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DataType.php, line 36

class PHPExcel_Cell_DataType {

  /* Data types */
  const TYPE_STRING2 = 'str';
  const TYPE_STRING = 's';
  const TYPE_FORMULA = 'f';
  const TYPE_NUMERIC = 'n';
  const TYPE_BOOL = 'b';
  const TYPE_NULL = 'null';
  const TYPE_INLINE = 'inlineStr';
  const TYPE_ERROR = 'e';

  /**
   * List of error codes
   *
   * @var array
   */
  private static $_errorCodes = array(
    '#NULL!' => 0,
    '#DIV/0!' => 1,
    '#VALUE!' => 2,
    '#REF!' => 3,
    '#NAME?' => 4,
    '#NUM!' => 5,
    '#N/A' => 6,
  );

  /**
   * Get list of error codes
   *
   * @return array
   */
  public static function getErrorCodes() {
    return self::$_errorCodes;
  }

  /**
   * DataType for value
   *
   * @deprecated  Replaced by PHPExcel_Cell_IValueBinder infrastructure, will be removed in version 1.8.0
   * @param       mixed  $pValue
   * @return      string
   */
  public static function dataTypeForValue($pValue = null) {
    return PHPExcel_Cell_DefaultValueBinder::dataTypeForValue($pValue);
  }

  /**
   * Check a string that it satisfies Excel requirements
   *
   * @param  mixed  Value to sanitize to an Excel string
   * @return mixed  Sanitized value
   */
  public static function checkString($pValue = null) {
    if ($pValue instanceof PHPExcel_RichText) {

      // TODO: Sanitize Rich-Text string (max. character count is 32,767)
      return $pValue;
    }

    // string must never be longer than 32,767 characters, truncate if necessary
    $pValue = PHPExcel_Shared_String::Substring($pValue, 0, 32767);

    // we require that newline is represented as "\n" in core, not as "\r\n" or "\r"
    $pValue = str_replace(array(
      "\r\n",
      "\r",
    ), "\n", $pValue);
    return $pValue;
  }

  /**
   * Check a value that it is a valid error code
   *
   * @param  mixed   Value to sanitize to an Excel error code
   * @return string  Sanitized value
   */
  public static function checkErrorCode($pValue = null) {
    $pValue = (string) $pValue;
    if (!array_key_exists($pValue, self::$_errorCodes)) {
      $pValue = '#NULL!';
    }
    return $pValue;
  }

}

Members

Name	Modifiers	Type	Description	Overrides
PHPExcel_Cell_DataType::$_errorCodes	private static	property	List of error codes
PHPExcel_Cell_DataType::checkErrorCode	public static	function	Check a value that it is a valid error code
PHPExcel_Cell_DataType::checkString	public static	function	Check a string that it satisfies Excel requirements
PHPExcel_Cell_DataType::dataTypeForValue Deprecated	public static	function	DataType for value
PHPExcel_Cell_DataType::getErrorCodes	public static	function	Get list of error codes
PHPExcel_Cell_DataType::TYPE_BOOL		constant
PHPExcel_Cell_DataType::TYPE_ERROR		constant
PHPExcel_Cell_DataType::TYPE_FORMULA		constant
PHPExcel_Cell_DataType::TYPE_INLINE		constant
PHPExcel_Cell_DataType::TYPE_NULL		constant
PHPExcel_Cell_DataType::TYPE_NUMERIC		constant
PHPExcel_Cell_DataType::TYPE_STRING		constant
PHPExcel_Cell_DataType::TYPE_STRING2		constant