/**
* 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, ".. "));
}
return null;
}
/**
* TRIMNONPRINTABLE
*
* @param mixed $value
* check
* @return string
*/
public static function TRIMNONPRINTABLE($stringValue = '') {
$stringValue = PHPExcel_Calculation_Functions::flattenSingleValue ( $stringValue );
if (is_bool ( $stringValue )) {
$stringValue = ($stringValue) ? 'TRUE' : 'FALSE';
}
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()
