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