public function _translateFormulaToLocale($formula) { if (self::$functionReplaceFromExcel === NULL) { self::$functionReplaceFromExcel = array(); foreach (array_keys(self::$_localeFunctions) as $excelFunctionName) { self::$functionReplaceFromExcel[] = '/(@?[^\\w\\.])' . preg_quote($excelFunctionName) . '([\\s]*\\()/Ui'; } foreach (array_keys(self::$_localeBoolean) as $excelBoolean) { self::$functionReplaceFromExcel[] = '/(@?[^\\w\\.])' . preg_quote($excelBoolean) . '([^\\w\\.])/Ui'; } } if (self::$functionReplaceToLocale === NULL) { self::$functionReplaceToLocale = array(); foreach (array_values(self::$_localeFunctions) as $localeFunctionName) { self::$functionReplaceToLocale[] = '$1' . trim($localeFunctionName) . '$2'; } foreach (array_values(self::$_localeBoolean) as $localeBoolean) { self::$functionReplaceToLocale[] = '$1' . trim($localeBoolean) . '$2'; } } return self::_translateFormula(self::$functionReplaceFromExcel, self::$functionReplaceToLocale, $formula, ',', self::$_localeArgumentSeparator); }