Source for file DataType.php
Documentation is available at DataType.php
* Copyright (c) 2006 - 2011 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
* @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
* @license http://www.gnu.org/licenses/old-licenses/lgpl-2.1.txt LGPL
* @version 1.7.6, 2011-02-27
* @copyright Copyright (c) 2006 - 2011 PHPExcel (http://www.codeplex.com/PHPExcel)
const TYPE_STRING2 = 'str';
const TYPE_FORMULA = 'f';
const TYPE_NUMERIC = 'n';
const TYPE_INLINE = 'inlineStr';
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 self::$_errorCodes;
* @deprecated Replaced by PHPExcel_Cell_IValueBinder infrastructure
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
// TODO: Sanitize Rich-Text string (max. character count is 32,767)
// string must never be longer than 32,767 characters, truncate if necessary
// 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);
* Check a value that it is a valid error code
* @param mixed Value to sanitize to an Excel error code
* @return string Sanitized value
$pValue = (string) $pValue;
|