Beispiel #1
0
 public function _translateFormulaToLocale($formula)
 {
     if (is_null(self::$functionReplaceFromExcel)) {
         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 (is_null(self::$functionReplaceToLocale)) {
         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);
 }