summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--sc/source/core/tool/cellkeytranslator.cxx239
1 files changed, 239 insertions, 0 deletions
diff --git a/sc/source/core/tool/cellkeytranslator.cxx b/sc/source/core/tool/cellkeytranslator.cxx
new file mode 100644
index 000000000000..0ee0d3f178f2
--- /dev/null
+++ b/sc/source/core/tool/cellkeytranslator.cxx
@@ -0,0 +1,239 @@
+/*************************************************************************
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * $RCSfile: cellkeytranslator.cxx,v $
+ *
+ * $Revision: 1.2 $
+ *
+ * last change: $Author: rt $ $Date: 2007-07-24 09:23:06 $
+ *
+ * The Contents of this file are made available subject to
+ * the terms of GNU Lesser General Public License Version 2.1.
+ *
+ *
+ * GNU Lesser General Public License Version 2.1
+ * =============================================
+ * Copyright 2005 by Sun Microsystems, Inc.
+ * 901 San Antonio Road, Palo Alto, CA 94303, USA
+ *
+ * This library is free software; you can redistribute it and/or
+ * modify it under the terms of the GNU Lesser General Public
+ * License version 2.1, as published by the Free Software Foundation.
+ *
+ * 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., 59 Temple Place, Suite 330, Boston,
+ * MA 02111-1307 USA
+ *
+ ************************************************************************/
+
+#include "cellkeytranslator.hxx"
+#include "rtl/ustring.hxx"
+
+using ::com::sun::star::lang::Locale;
+using ::std::list;
+using ::std::hash_map;
+using ::rtl::OUString;
+
+enum LocaleMatch
+{
+ LOCALE_MATCH_NONE = 0,
+ LOCALE_MATCH_LANG,
+ LOCALE_MATCH_LANG_COUNTRY,
+ LOCALE_MATCH_ALL
+};
+
+static LocaleMatch lclLocaleCompare(const Locale& rLocale1, const Locale& rLocale2)
+{
+ LocaleMatch eMatchLevel = LOCALE_MATCH_NONE;
+ if ( !rLocale1.Language.compareTo(rLocale1.Language) )
+ eMatchLevel = LOCALE_MATCH_LANG;
+ else
+ return eMatchLevel;
+
+ if ( !rLocale1.Country.compareTo(rLocale2.Country) )
+ eMatchLevel = LOCALE_MATCH_LANG_COUNTRY;
+ else
+ return eMatchLevel;
+
+ if ( !rLocale1.Variant.compareTo(rLocale2.Variant) )
+ eMatchLevel = LOCALE_MATCH_ALL;
+
+ return eMatchLevel;
+}
+
+ScCellKeyword::ScCellKeyword(const sal_Char* pName, OpCode eOpCode, const Locale& rLocale) :
+ mpName(pName),
+ meOpCode(eOpCode),
+ mrLocale(rLocale)
+{
+}
+
+::std::auto_ptr<ScCellKeywordTranslator> ScCellKeywordTranslator::spInstance(NULL);
+
+static void lclMatchKeyword(String& rName, const ScCellKeywordHashMap& aMap, OpCode eOpCode = ocNone, const Locale* pLocale = NULL)
+{
+ ScCellKeywordHashMap::const_iterator itrEnd = aMap.end();
+ ScCellKeywordHashMap::const_iterator itr = aMap.find(rName);
+
+ if ( itr == itrEnd || itr->second.empty() )
+ // No candidate strings exist. Bail out.
+ return;
+
+ if ( eOpCode == ocNone && !pLocale )
+ {
+ // Since no locale nor opcode matching is needed, simply return
+ // the first item on the list.
+ rName = String::CreateFromAscii( itr->second.front().mpName );
+ return;
+ }
+
+ const sal_Char* aBestMatchName = itr->second.front().mpName;
+ LocaleMatch eLocaleMatchLevel = LOCALE_MATCH_NONE;
+ bool bOpCodeMatched = false;
+
+ list<ScCellKeyword>::const_iterator itrListEnd = itr->second.end();
+ list<ScCellKeyword>::const_iterator itrList = itr->second.begin();
+ for ( ; itrList != itrListEnd; ++itrList )
+ {
+ if ( eOpCode != ocNone && pLocale )
+ {
+ if ( itrList->meOpCode == eOpCode )
+ {
+ LocaleMatch eLevel = lclLocaleCompare(itrList->mrLocale, *pLocale);
+ if ( eLevel == LOCALE_MATCH_ALL )
+ {
+ // Name with matching opcode and locale found.
+ rName = String::CreateFromAscii( itrList->mpName );
+ return;
+ }
+ else if ( eLevel > eLocaleMatchLevel )
+ {
+ // Name with a better matching locale.
+ eLocaleMatchLevel = eLevel;
+ aBestMatchName = itrList->mpName;
+ }
+ else if ( !bOpCodeMatched )
+ // At least the opcode matches.
+ aBestMatchName = itrList->mpName;
+
+ bOpCodeMatched = true;
+ }
+ }
+ else if ( eOpCode != ocNone && !pLocale )
+ {
+ if ( itrList->meOpCode == eOpCode )
+ {
+ // Name with a matching opcode preferred.
+ rName = String::CreateFromAscii( itrList->mpName );
+ return;
+ }
+ }
+ else if ( !eOpCode && pLocale )
+ {
+ LocaleMatch eLevel = lclLocaleCompare(itrList->mrLocale, *pLocale);
+ if ( eLevel == LOCALE_MATCH_ALL )
+ {
+ // Name with matching locale preferred.
+ rName = String::CreateFromAscii( itrList->mpName );
+ return;
+ }
+ else if ( eLevel > eLocaleMatchLevel )
+ {
+ // Name with a better matching locale.
+ eLocaleMatchLevel = eLevel;
+ aBestMatchName = itrList->mpName;
+ }
+ }
+ }
+
+ // No preferred strings found. Return the best matching name.
+ rName = String::CreateFromAscii(aBestMatchName);
+}
+
+void ScCellKeywordTranslator::transKeyword(String& rName, const Locale* pLocale, OpCode eOpCode)
+{
+ if ( !spInstance.get() )
+ spInstance.reset( new ScCellKeywordTranslator );
+
+ lclMatchKeyword(rName, spInstance->maStringNameMap, eOpCode, pLocale);
+}
+
+ScCellKeywordTranslator::ScCellKeywordTranslator()
+{
+ init();
+}
+
+ScCellKeywordTranslator::~ScCellKeywordTranslator()
+{
+}
+
+struct TransItem
+{
+ const sal_Char* from;
+ const sal_Char* to;
+ OpCode func;
+};
+
+void ScCellKeywordTranslator::init()
+{
+ // 1. Keywords must be all uppercase.
+ // 2. Mapping must be <localized string name> to <English string name>.
+
+ // French language locale.
+
+ static const Locale aFr(OUString::createFromAscii("fr"), OUString(), OUString());
+ static const TransItem pFr[] =
+ {
+ // CELL
+ {"ADRESSE", "ADDRESS", ocCell},
+ {"COLONNE", "COL", ocCell},
+ {"CONTENU", "CONTENTS", ocCell},
+ {"COULEUR", "COLOR", ocCell},
+ {"LARGEUR", "WIDTH", ocCell},
+ {"LIGNE", "ROW", ocCell},
+ {"NOMFICHIER", "FILENAME", ocCell},
+ {"PREFIXE", "PREFIX", ocCell},
+ {"PROTEGE", "PROTECT", ocCell},
+
+ // INFO
+ {"NBFICH", "NUMFILE", ocInfo},
+ {"RECALCUL", "RECALC", ocInfo},
+ {"SYSTEXPL", "SYSTEM", ocInfo},
+ {"VERSION", "RELEASE", ocInfo},
+ {"VERSIONSE", "OSVERSION", ocInfo},
+
+ {NULL, NULL, ocNone}
+ };
+ addToMap(pFr, aFr);
+}
+
+void ScCellKeywordTranslator::addToMap(const String& rKey, const sal_Char* pName, const Locale& rLocale, OpCode eOpCode)
+{
+ ScCellKeyword aKeyItem( pName, eOpCode, rLocale );
+
+ ScCellKeywordHashMap::iterator itrEnd = maStringNameMap.end();
+ ScCellKeywordHashMap::iterator itr = maStringNameMap.find(rKey);
+
+ if ( itr == itrEnd )
+ {
+ // New keyword.
+ list<ScCellKeyword> aList;
+ aList.push_back(aKeyItem);
+ maStringNameMap.insert( ScCellKeywordHashMap::value_type(rKey, aList) );
+ }
+ else
+ itr->second.push_back(aKeyItem);
+}
+
+void ScCellKeywordTranslator::addToMap(const TransItem* pItems, const Locale& rLocale)
+{
+ for (sal_uInt16 i = 0; pItems[i].from != NULL; ++i)
+ addToMap(String::CreateFromAscii(pItems[i].from), pItems[i].to, rLocale, pItems[i].func);
+}