You are here

DataType.php in Loft Data Grids 6.2

Same filename and directory in other branches
  1. 7.2 vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DataType.php

File

vendor/phpoffice/phpexcel/Classes/PHPExcel/Cell/DataType.php
View source
<?php

/**
 * PHPExcel
 *
 * Copyright (c) 2006 - 2014 PHPExcel
 *
 * This library is free software; you can redistribute it and/or
 * modify it under the terms of the GNU Lesser General Public
 * License as published by the Free Software Foundation; either
 * version 2.1 of the License, or (at your option) any later version.
 *
 * This library is distributed in the hope that it will be useful,
 * but WITHOUT ANY WARRANTY; without even the implied warranty of
 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 * Lesser General Public License for more details.
 *
 * You should have received a copy of the GNU Lesser General Public
 * License along with this library; if not, write to the Free Software
 * Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301  USA
 *
 * @category   PHPExcel
 * @package    PHPExcel_Cell
 * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 * @license    http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt    LGPL
 * @version    ##VERSION##, ##DATE##
 */

/**
 * PHPExcel_Cell_DataType
 *
 * @category   PHPExcel
 * @package    PHPExcel_Cell
 * @copyright  Copyright (c) 2006 - 2014 PHPExcel (http://www.codeplex.com/PHPExcel)
 */
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;
  }

}

Classes

Namesort descending Description
PHPExcel_Cell_DataType PHPExcel_Cell_DataType