3 files changed, 2295 insertions, 2295 deletions
diff --git a/sc/source/filter/xml/XMLStylesExportHelper.cxx b/sc/source/filter/xml/XMLStylesExportHelper.cxx
index c38c01f7efec..bc607c0a2ab0 100644
--- a/sc/source/filter/xml/XMLStylesExportHelper.cxx
+++ b/sc/source/filter/xml/XMLStylesExportHelper.cxx
@@ -1,1245 +1,1245 @@
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
- * Copyright 2008 by Sun Microsystems, Inc.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * $RCSfile: XMLStylesExportHelper.cxx,v $
- * $Revision: 1.52 $
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org 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 version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-// MARKER(update_precomp.py): autogen include statement, do not remove
-#include "precompiled_sc.hxx"
-
-
-// INCLUDE ---------------------------------------------------------------
-#include "XMLStylesExportHelper.hxx"
-#include "global.hxx"
-#include "unonames.hxx"
-#include "XMLConverter.hxx"
-#include "xmlexprt.hxx"
-#include "document.hxx"
-#include "rangeutl.hxx"
-#include <xmloff/xmltoken.hxx>
-#include <xmloff/xmlnmspe.hxx>
-#include <xmloff/XMLEventExport.hxx>
-#include <xmloff/nmspmap.hxx>
-#include <tools/debug.hxx>
-#include <com/sun/star/uno/Reference.h>
-#include <com/sun/star/beans/XPropertySet.hpp>
-#include <com/sun/star/sheet/XSheetCondition.hpp>
-#include <com/sun/star/sheet/TableValidationVisibility.hpp>
-#include <comphelper/extract.hxx>
-#include <sfx2/app.hxx>
-
-#include <algorithm>
-
-using namespace com::sun::star;
-using namespace xmloff::token;
-
-ScMyValidation::ScMyValidation()
-    : sName(),
-    sErrorMessage(),
-    sErrorTitle(),
-    sImputMessage(),
-    sImputTitle(),
-    sFormula1(),
-    sFormula2(),
-    bShowErrorMessage(sal_False),
-    bShowImputMessage(sal_False),
-    bIgnoreBlanks(sal_False)
-{
-}
-
-ScMyValidation::~ScMyValidation()
-{
-}
-
-sal_Bool ScMyValidation::IsEqual(const ScMyValidation& aVal) const
-{
-    if (aVal.bIgnoreBlanks == bIgnoreBlanks &&
-        aVal.bShowImputMessage == bShowImputMessage &&
-        aVal.bShowErrorMessage == bShowErrorMessage &&
-        aVal.aBaseCell.Sheet == aBaseCell.Sheet &&
-        aVal.aBaseCell.Column == aBaseCell.Column &&
-        aVal.aBaseCell.Row == aBaseCell.Row &&
-        aVal.aAlertStyle == aAlertStyle &&
-        aVal.aValidationType == aValidationType &&
-        aVal.aOperator == aOperator &&
-        aVal.sErrorTitle == sErrorTitle &&
-        aVal.sImputTitle == sImputTitle &&
-        aVal.sErrorMessage == sErrorMessage &&
-        aVal.sImputMessage == sImputMessage &&
-        aVal.sFormula1 == sFormula1 &&
-        aVal.sFormula2 == sFormula2)
-        return sal_True;
-    else
-        return sal_False;
-}
-
-ScMyValidationsContainer::ScMyValidationsContainer()
-    : aValidationVec(),
-    sEmptyString(),
-    sERRALSTY(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_ERRALSTY)),
-    sIGNOREBL(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_IGNOREBL)),
-    sSHOWLIST(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_SHOWLIST)),
-    sTYPE(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_TYPE)),
-    sSHOWINP(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_SHOWINP)),
-    sSHOWERR(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_SHOWERR)),
-    sINPTITLE(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_INPTITLE)),
-    sINPMESS(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_INPMESS)),
-    sERRTITLE(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_ERRTITLE)),
-    sERRMESS(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_ERRMESS)),
-    sOnError(RTL_CONSTASCII_USTRINGPARAM("OnError")),
-    sEventType(RTL_CONSTASCII_USTRINGPARAM("EventType")),
-    sStarBasic(RTL_CONSTASCII_USTRINGPARAM("StarBasic")),
-    sScript(RTL_CONSTASCII_USTRINGPARAM("Script")),
-    sLibrary(RTL_CONSTASCII_USTRINGPARAM("Library")),
-    sMacroName(RTL_CONSTASCII_USTRINGPARAM("MacroName"))
-{
-}
-
-ScMyValidationsContainer::~ScMyValidationsContainer()
-{
-}
-
-sal_Bool ScMyValidationsContainer::AddValidation(const uno::Any& aTempAny,
-    sal_Int32& nValidationIndex)
-{
-    sal_Bool bAdded(sal_False);
-    uno::Reference<beans::XPropertySet> xPropertySet(aTempAny, uno::UNO_QUERY);
-    if (xPropertySet.is())
-    {
-        rtl::OUString sErrorMessage;
-        xPropertySet->getPropertyValue(sERRMESS) >>= sErrorMessage;
-        rtl::OUString sErrorTitle;
-        xPropertySet->getPropertyValue(sERRTITLE) >>= sErrorTitle;
-        rtl::OUString sImputMessage;
-        xPropertySet->getPropertyValue(sINPMESS) >>= sImputMessage;
-        rtl::OUString sImputTitle;
-        xPropertySet->getPropertyValue(sINPTITLE) >>= sImputTitle;
-        sal_Bool bShowErrorMessage = ::cppu::any2bool(xPropertySet->getPropertyValue(sSHOWERR));
-        sal_Bool bShowImputMessage = ::cppu::any2bool(xPropertySet->getPropertyValue(sSHOWINP));
-        sheet::ValidationType aValidationType;
-        xPropertySet->getPropertyValue(sTYPE) >>= aValidationType;
-        if (bShowErrorMessage || bShowImputMessage || aValidationType != sheet::ValidationType_ANY ||
-            sErrorMessage.getLength() || sErrorTitle.getLength() || sImputMessage.getLength() || sImputTitle.getLength())
-        {
-            ScMyValidation aValidation;
-            aValidation.sErrorMessage = sErrorMessage;
-            aValidation.sErrorTitle = sErrorTitle;
-            aValidation.sImputMessage = sImputMessage;
-            aValidation.sImputTitle = sImputTitle;
-            aValidation.bShowErrorMessage = bShowErrorMessage;
-            aValidation.bShowImputMessage = bShowImputMessage;
-            aValidation.aValidationType = aValidationType;
-            aValidation.bIgnoreBlanks = ::cppu::any2bool(xPropertySet->getPropertyValue(sIGNOREBL));
-            xPropertySet->getPropertyValue(sSHOWLIST) >>= aValidation.nShowList;
-            xPropertySet->getPropertyValue(sERRALSTY) >>= aValidation.aAlertStyle;
-            uno::Reference<sheet::XSheetCondition> xCondition(xPropertySet, uno::UNO_QUERY);
-            if (xCondition.is())
-            {
-                aValidation.sFormula1 = xCondition->getFormula1();
-                aValidation.sFormula2 = xCondition->getFormula2();
-                aValidation.aOperator = xCondition->getOperator();
-                aValidation.aBaseCell = xCondition->getSourcePosition();
-            }
-            //ScMyValidationRange aValidationRange;
-            sal_Bool bEqualFound(sal_False);
-            sal_Int32 i(0);
-            sal_Int32 nCount(aValidationVec.size());
-            while (i < nCount && !bEqualFound)
-            {
-                bEqualFound = aValidationVec[i].IsEqual(aValidation);
-                if (!bEqualFound)
-                    ++i;
-            }
-            if (bEqualFound)
-                nValidationIndex = i;
-            else
-            {
-                sal_Int32 nNameIndex(nCount + 1);
-                rtl::OUString sCount(rtl::OUString::valueOf(nNameIndex));
-                rtl::OUString sPrefix(RTL_CONSTASCII_USTRINGPARAM("val"));
-                aValidation.sName += sPrefix;
-                aValidation.sName += sCount;
-                aValidationVec.push_back(aValidation);
-                nValidationIndex = nCount;
-                bAdded = sal_True;
-            }
-        }
-    }
-    return bAdded;
-}
-
-rtl::OUString ScMyValidationsContainer::GetCondition(ScXMLExport& rExport, const ScMyValidation& aValidation)
-{
-    rtl::OUString sCondition;
-    if (aValidation.aValidationType != sheet::ValidationType_ANY)
-    {
-        switch (aValidation.aValidationType)
-        {
-            //case sheet::ValidationType_CUSTOM
-            case sheet::ValidationType_DATE :
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-date()"));
-            break;
-            case sheet::ValidationType_DECIMAL :
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-decimal-number()"));
-            break;
-            case sheet::ValidationType_LIST :
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-in-list("));
-                sCondition += aValidation.sFormula1;
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(")"));
-            break;
-            case sheet::ValidationType_TEXT_LEN :
-                if (aValidation.aOperator != sheet::ConditionOperator_BETWEEN &&
-                    aValidation.aOperator != sheet::ConditionOperator_NOT_BETWEEN)
-                    sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length()"));
-            break;
-            case sheet::ValidationType_TIME :
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-time()"));
-            break;
-            case sheet::ValidationType_WHOLE :
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-whole-number()"));
-            break;
-            default:
-            {
-                // added to avoid warnings
-            }
-        }
-        if (aValidation.aValidationType != sheet::ValidationType_LIST &&
-            (aValidation.sFormula1.getLength() ||
-            (aValidation.aOperator == sheet::ConditionOperator_BETWEEN &&
-            aValidation.aOperator == sheet::ConditionOperator_NOT_BETWEEN &&
-            aValidation.sFormula2.getLength())))
-        {
-            if (aValidation.aValidationType != sheet::ValidationType_TEXT_LEN)
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" and "));
-            if (aValidation.aOperator != sheet::ConditionOperator_BETWEEN &&
-                aValidation.aOperator != sheet::ConditionOperator_NOT_BETWEEN)
-            {
-                if (aValidation.aValidationType != sheet::ValidationType_TEXT_LEN)
-                    sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content()"));
-                switch (aValidation.aOperator)
-                {
-                    case sheet::ConditionOperator_EQUAL :
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("="));
-                    break;
-                    case sheet::ConditionOperator_GREATER :
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(">"));
-                    break;
-                    case sheet::ConditionOperator_GREATER_EQUAL :
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(">="));
-                    break;
-                    case sheet::ConditionOperator_LESS :
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("<"));
-                    break;
-                    case sheet::ConditionOperator_LESS_EQUAL :
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("<="));
-                    break;
-                    case sheet::ConditionOperator_NOT_EQUAL :
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("!="));
-                    break;
-                    default:
-                    {
-                        // added to avoid warnings
-                    }
-                }
-                sCondition += aValidation.sFormula1;
-            }
-            else
-            {
-                if (aValidation.aValidationType == sheet::ValidationType_TEXT_LEN)
-                {
-                    if (aValidation.aOperator == sheet::ConditionOperator_BETWEEN)
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-between("));
-                    else
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-not-between("));
-                }
-                else
-                {
-                    if (aValidation.aOperator == sheet::ConditionOperator_BETWEEN)
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-between("));
-                    else
-                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-not-between("));
-                }
-                sCondition += aValidation.sFormula1;
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(","));
-                sCondition += aValidation.sFormula2;
-                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(")"));
-            }
-        }
-        else
-            if (aValidation.aValidationType == sheet::ValidationType_TEXT_LEN)
-                sCondition = rtl::OUString();
-    }
-    if (sCondition.getLength())
-    {
-        const formula::FormulaGrammar::Grammar eGrammar = rExport.GetDocument()->GetStorageGrammar();
-        sal_uInt16 nNamespacePrefix = (eGrammar == formula::FormulaGrammar::GRAM_ODFF ? XML_NAMESPACE_OF : XML_NAMESPACE_OOOC);
-        sCondition = rExport.GetNamespaceMap().GetQNameByKey( nNamespacePrefix, sCondition, sal_False );
-    }
-
-    return sCondition;
-}
-
-rtl::OUString ScMyValidationsContainer::GetBaseCellAddress(ScDocument* pDoc, const table::CellAddress& aCell)
-{
-    rtl::OUString sAddress;
-    ScRangeStringConverter::GetStringFromAddress( sAddress, aCell, pDoc );
-    return sAddress;
-}
-
-void ScMyValidationsContainer::WriteMessage(ScXMLExport& rExport,
-    const rtl::OUString& sTitle, const rtl::OUString& sOUMessage,
-    const sal_Bool bShowMessage, const sal_Bool bIsHelpMessage)
-{
-    if (sTitle.getLength())
-        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_TITLE, sTitle);
-    if (bShowMessage)
-        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY, XML_TRUE);
-    else
-        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY, XML_FALSE);
-    SvXMLElementExport* pMessage(NULL);
-    if (bIsHelpMessage)
-        pMessage = new SvXMLElementExport(rExport, XML_NAMESPACE_TABLE, XML_HELP_MESSAGE, sal_True, sal_True);
-    else
-        pMessage = new SvXMLElementExport(rExport, XML_NAMESPACE_TABLE, XML_ERROR_MESSAGE, sal_True, sal_True);
-    if (sOUMessage.getLength())
-    {
-        sal_Int32 i(0);
-        rtl::OUStringBuffer sTemp;
-        String sMessage(sOUMessage);
-        rtl::OUString sText (sMessage.ConvertLineEnd(LINEEND_LF));
-        sal_Bool bPrevCharWasSpace(sal_True);
-        while(i < sText.getLength())
-        {
-            if ((sText[i] == '\n'))
-            {
-                SvXMLElementExport aElemP(rExport, XML_NAMESPACE_TEXT, XML_P, sal_True, sal_False);
-                rExport.GetTextParagraphExport()->exportText(sTemp.makeStringAndClear(), bPrevCharWasSpace);
-            }
-            else
-                sTemp.append(sText[i]);
-            ++i;
-        }
-        if (sTemp.getLength())
-        {
-            SvXMLElementExport aElemP(rExport, XML_NAMESPACE_TEXT, XML_P, sal_True, sal_False);
-            rExport.GetTextParagraphExport()->exportText(sTemp.makeStringAndClear(), bPrevCharWasSpace);
-        }
-    }
-    if (pMessage)
-        delete pMessage;
-}
-
-void ScMyValidationsContainer::WriteValidations(ScXMLExport& rExport)
-{
-    if (aValidationVec.size())
-    {
-        SvXMLElementExport aElemVs(rExport, XML_NAMESPACE_TABLE, XML_CONTENT_VALIDATIONS, sal_True, sal_True);
-        ScMyValidationVec::iterator aItr(aValidationVec.begin());
-        ScMyValidationVec::iterator aEndItr(aValidationVec.end());
-        while (aItr != aEndItr)
-        {
-            rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_NAME, aItr->sName);
-            rtl::OUString sCondition(GetCondition(rExport, *aItr));
-            if (sCondition.getLength())
-            {
-                rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_CONDITION, sCondition);
-                if (aItr->bIgnoreBlanks)
-                    rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_ALLOW_EMPTY_CELL, XML_TRUE);
-                else
-                    rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_ALLOW_EMPTY_CELL, XML_FALSE);
-                if (aItr->aValidationType == sheet::ValidationType_LIST)
-                {
-                    switch (aItr->nShowList)
-                    {
-                    case sheet::TableValidationVisibility::INVISIBLE:
-                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY_LIST, XML_NO);
-                    break;
-                    case sheet::TableValidationVisibility::UNSORTED:
-                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY_LIST, XML_UNSORTED);
-                    break;
-                    case sheet::TableValidationVisibility::SORTEDASCENDING:
-                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY_LIST, XML_SORTED_ASCENDING);
-                    break;
-                    default:
-                        DBG_ERROR("unknown ListType");
-                    }
-                }
-            }
-            rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_BASE_CELL_ADDRESS, GetBaseCellAddress(rExport.GetDocument(), aItr->aBaseCell));
-            SvXMLElementExport aElemV(rExport, XML_NAMESPACE_TABLE, XML_CONTENT_VALIDATION, sal_True, sal_True);
-            if (aItr->bShowImputMessage || aItr->sImputMessage.getLength() || aItr->sImputTitle.getLength())
-            {
-                WriteMessage(rExport, aItr->sImputTitle, aItr->sImputMessage, aItr->bShowImputMessage, sal_True);
-            }
-            if (aItr->bShowErrorMessage || aItr->sErrorMessage.getLength() || aItr->sErrorTitle.getLength())
-            {
-                switch (aItr->aAlertStyle)
-                {
-                    case sheet::ValidationAlertStyle_INFO :
-                    {
-                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_MESSAGE_TYPE, XML_INFORMATION);
-                        WriteMessage(rExport, aItr->sErrorTitle, aItr->sErrorMessage, aItr->bShowErrorMessage, sal_False);
-                    }
-                    break;
-                    case sheet::ValidationAlertStyle_WARNING :
-                    {
-                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_MESSAGE_TYPE, XML_WARNING);
-                        WriteMessage(rExport, aItr->sErrorTitle, aItr->sErrorMessage, aItr->bShowErrorMessage, sal_False);
-                    }
-                    break;
-                    case sheet::ValidationAlertStyle_STOP :
-                    {
-                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_MESSAGE_TYPE, XML_STOP);
-                        WriteMessage(rExport, aItr->sErrorTitle, aItr->sErrorMessage, aItr->bShowErrorMessage, sal_False);
-                    }
-                    break;
-                    case sheet::ValidationAlertStyle_MACRO :
-                    {
-                        {
-                            //rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_NAME, aItr->sErrorTitle);
-                            if (aItr->bShowErrorMessage)
-                                rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_EXECUTE, XML_TRUE);
-                            else
-                                rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_EXECUTE, XML_FALSE);
-                            SvXMLElementExport aEMElem(rExport, XML_NAMESPACE_TABLE, XML_ERROR_MACRO, sal_True, sal_True);
-                        }
-                        {
-                            // #i47525# for a script URL the type and the property name for the URL
-                            // are both "Script", for a simple macro name the type is "StarBasic"
-                            // and the property name is "MacroName".
-                            bool bScriptURL = SfxApplication::IsXScriptURL( aItr->sErrorTitle );
-
-                            uno::Sequence<beans::PropertyValue> aSeq(3);
-                            beans::PropertyValue* pArr(aSeq.getArray());
-                            pArr[0].Name = sEventType;
-                            pArr[0].Value <<= bScriptURL ? sScript : sStarBasic;
-                            pArr[1].Name = sLibrary;
-                            pArr[1].Value <<= sEmptyString;
-                            pArr[2].Name = bScriptURL ? sScript : sMacroName;
-                            pArr[2].Value <<= aItr->sErrorTitle;
-
-                            // 2) export the sequence
-                            rExport.GetEventExport().ExportSingleEvent( aSeq, sOnError);
-                        }
-                    }
-                    break;
-                    default:
-                    {
-                        // added to avoid warnings
-                    }
-                }
-            }
-            ++aItr;
-        }
-    }
-}
-
-const rtl::OUString& ScMyValidationsContainer::GetValidationName(const sal_Int32 nIndex)
-{
-    DBG_ASSERT( static_cast<size_t>(nIndex) < aValidationVec.size(), "out of range" );
-    return aValidationVec[nIndex].sName;
-}
-
-//==============================================================================
-
-sal_Int32 ScMyDefaultStyles::GetStyleNameIndex(const ScFormatRangeStyles* pCellStyles,
-    const sal_Int32 nTable, const sal_Int32 nPos,
-    const sal_Int32 i, const sal_Bool bRow, sal_Bool& bIsAutoStyle)
-{
-    if (bRow)
-        return pCellStyles->GetStyleNameIndex(nTable, nPos, i,
-                                bIsAutoStyle);
-    else
-        return pCellStyles->GetStyleNameIndex(nTable, i, nPos,
-                                bIsAutoStyle);
-}
-
-void ScMyDefaultStyles::FillDefaultStyles(const sal_Int32 nTable,
-    const sal_Int32 nLastRow, const sal_Int32 nLastCol,
-    const ScFormatRangeStyles* pCellStyles, ScDocument* pDoc,
-    const sal_Bool bRow)
-{
-    if (pDoc)
-    {
-        SCTAB nTab = static_cast<SCTAB>(nTable);
-        sal_Int32 nPos;
-        sal_Int32 nLast;
-        ScMyDefaultStyleList* pDefaults;
-        if (bRow)
-        {
-            pDefaults = pRowDefaults;
-            nLast = nLastRow;
-        }
-        else
-        {
-            pDefaults = pColDefaults;
-            nLast = nLastCol;
-        }
-        sal_Bool bPrevAutoStyle(sal_False);
-        sal_Bool bIsAutoStyle;
-        sal_Bool bResult;
-        sal_Int32 nPrevIndex(0);
-        sal_Int32 nIndex;
-        sal_Int32 nRepeat(0);
-        sal_Int32 nEmptyRepeat(0);
-        for (sal_Int32 i = nLast; i >= 0; --i)
-        {
-            if (bRow)
-            {
-                SCCOL nCol;
-                bResult = pDoc->GetRowDefault(nTab,
-                    static_cast<SCROW>(i), static_cast<SCCOL>(nLastCol), nCol);
-                nPos = static_cast<sal_Int32>(nCol);
-            }
-            else
-            {
-                SCROW nRow;
-                bResult = pDoc->GetColDefault(nTab,
-                    static_cast<SCCOL>(i), static_cast<SCROW>(nLastRow), nRow);
-                nPos = static_cast<sal_Int32>(nRow);
-            }
-            if (bResult)
-            {
-                nEmptyRepeat = 0;
-                if (!nRepeat)
-                {
-                    nPrevIndex = GetStyleNameIndex(pCellStyles, nTab, nPos, i,
-                                                bRow, bPrevAutoStyle);
-                    (*pDefaults)[i].nIndex = nPrevIndex;
-                    (*pDefaults)[i].bIsAutoStyle = bPrevAutoStyle;
-                    nRepeat = 1;
-                }
-                else
-                {
-                    nIndex = GetStyleNameIndex(pCellStyles, nTab, nPos, i,
-                                            bRow, bIsAutoStyle);
-                    if ((nIndex != nPrevIndex) || (bIsAutoStyle != bPrevAutoStyle))
-                    {
-                        nRepeat = 1;
-                        nPrevIndex = GetStyleNameIndex(pCellStyles, nTab, nPos, i,
-                                                bRow, bPrevAutoStyle);
-                        (*pDefaults)[i].nIndex = nPrevIndex;
-                        (*pDefaults)[i].bIsAutoStyle = bPrevAutoStyle;
-                    }
-                    else
-                    {
-                        (*pDefaults)[i].nIndex = nPrevIndex;
-                        (*pDefaults)[i].bIsAutoStyle = bPrevAutoStyle;
-                        ++nRepeat;
-                        if (nRepeat > 1)
-                            (*pDefaults)[i].nRepeat = nRepeat;
-                    }
-                }
-            }
-            else
-            {
-                nRepeat = 0;
-                if (!nEmptyRepeat)
-                    nEmptyRepeat = 1;
-                else
-                {
-                    ++nEmptyRepeat;
-                    if (nEmptyRepeat > 1)
-                        (*pDefaults)[i].nRepeat = nEmptyRepeat;
-                }
-            }
-        }
-    }
-}
-
-void ScMyDefaultStyles::FillDefaultStyles(const sal_Int32 nTable,
-    const sal_Int32 nLastRow, const sal_Int32 nLastCol,
-    const ScFormatRangeStyles* pCellStyles, ScDocument* pDoc)
-{
-    if (pRowDefaults)
-        delete pRowDefaults;
-    pRowDefaults = new ScMyDefaultStyleList(nLastRow + 1);
-     FillDefaultStyles(nTable, nLastRow, nLastCol, pCellStyles, pDoc, sal_True);
-    if (pColDefaults)
-        delete pColDefaults;
-    pColDefaults = new ScMyDefaultStyleList(nLastCol + 1);
-     FillDefaultStyles(nTable, nLastRow, nLastCol, pCellStyles, pDoc, sal_False);
-}
-
-ScMyDefaultStyles::~ScMyDefaultStyles()
-{
-    if (pRowDefaults)
-        delete pRowDefaults;
-    if (pColDefaults)
-        delete pColDefaults;
-}
-
-ScMyRowFormatRange::ScMyRowFormatRange()
-    : nStartColumn(0),
-    nRepeatColumns(0),
-    nRepeatRows(0),
-    nIndex(-1),
-    nValidationIndex(-1),
-    bIsAutoStyle(sal_True)
-{
-}
-
-sal_Bool ScMyRowFormatRange::operator< (const ScMyRowFormatRange& rRange) const
-{
-    return (nStartColumn < rRange.nStartColumn);
-}
-
-ScRowFormatRanges::ScRowFormatRanges()
-    : aRowFormatRanges(),
-    pRowDefaults(NULL),
-    pColDefaults(NULL),
-    nSize(0)
-{
-}
-
-ScRowFormatRanges::ScRowFormatRanges(const ScRowFormatRanges* pRanges)
-    : aRowFormatRanges(pRanges->aRowFormatRanges),
-    pRowDefaults(pRanges->pRowDefaults),
-    pColDefaults(pRanges->pColDefaults),
-    nSize(pRanges->nSize)
-{
-}
-
-ScRowFormatRanges::~ScRowFormatRanges()
-{
-}
-
-void ScRowFormatRanges::Clear()
-{
-    aRowFormatRanges.clear();
-    nSize = 0;
-}
-
-void ScRowFormatRanges::AddRange(const sal_Int32 nPrevStartCol, const sal_Int32 nRepeat, const sal_Int32 nPrevIndex,
-    const sal_Bool bPrevAutoStyle, const ScMyRowFormatRange& rFormatRange)
-{
-    sal_Int32 nIndex(-1);
-    if ((nPrevIndex != rFormatRange.nIndex) ||
-        (bPrevAutoStyle != rFormatRange.bIsAutoStyle))
-        nIndex = rFormatRange.nIndex;
-
-    sal_Bool bInserted(sal_False);
-    if (!aRowFormatRanges.empty())
-    {
-        ScMyRowFormatRange* pRange(&aRowFormatRanges.back());
-        if (pRange)
-        {
-            if ((nPrevStartCol == (pRange->nStartColumn + pRange->nRepeatColumns)) &&
-                (pRange->bIsAutoStyle == rFormatRange.bIsAutoStyle) &&
-                (pRange->nIndex == nIndex) &&
-                (pRange->nValidationIndex == rFormatRange.nValidationIndex))
-            {
-                if (rFormatRange.nRepeatRows < pRange->nRepeatRows)
-                    pRange->nRepeatRows = rFormatRange.nRepeatRows;
-                pRange->nRepeatColumns += nRepeat;
-                bInserted = sal_True;
-            }
-        }
-    }
-    if (!bInserted)
-    {
-        ScMyRowFormatRange aRange;
-        aRange.nStartColumn = nPrevStartCol;
-        aRange.nRepeatColumns = nRepeat;
-        aRange.nRepeatRows = rFormatRange.nRepeatRows;
-        aRange.nValidationIndex = rFormatRange.nValidationIndex;
-        aRange.bIsAutoStyle = rFormatRange.bIsAutoStyle;
-        aRange.nIndex = nIndex;
-        aRowFormatRanges.push_back(aRange);
-        ++nSize;
-    }
-}
-
-void ScRowFormatRanges::AddRange(ScMyRowFormatRange& rFormatRange,
-    const sal_Int32 nRow)
-{
-    DBG_ASSERT(pRowDefaults, "no row defaults");
-    DBG_ASSERT(pColDefaults, "no column defaults");
-    sal_uInt32 nEnd (rFormatRange.nRepeatRows + nRow - 1);
-    sal_Int32 nPrevIndex((*pRowDefaults)[nRow].nIndex);
-    sal_Bool bPrevAutoStyle((*pRowDefaults)[nRow].bIsAutoStyle);
-    sal_uInt32 i(nRow + 1);
-    sal_Bool bReady(sal_False);
-    while ((i < nEnd) && !bReady && (i < pRowDefaults->size()))
-    {
-        if ((nPrevIndex != (*pRowDefaults)[i].nIndex) ||
-            (bPrevAutoStyle != (*pRowDefaults)[i].bIsAutoStyle))
-            bReady = sal_True;
-        else
-            i += (*pRowDefaults)[i].nRepeat;
-    }
-    if (i > nEnd)
-        i = nEnd;
-    if (bReady)
-        rFormatRange.nRepeatRows = i - nRow + 1;
-    if (nPrevIndex == -1)
-    {
-        nPrevIndex = (*pColDefaults)[rFormatRange.nStartColumn].nIndex;
-        bPrevAutoStyle = (*pColDefaults)[rFormatRange.nStartColumn].bIsAutoStyle;
-        sal_uInt32 nPrevStartCol(rFormatRange.nStartColumn);
-        sal_uInt32 nRepeat((*pColDefaults)[rFormatRange.nStartColumn].nRepeat);
-        nEnd = rFormatRange.nStartColumn + rFormatRange.nRepeatColumns;
-        for(i = nPrevStartCol + nRepeat; i < nEnd; i += (*pColDefaults)[i].nRepeat)
-        {
-            DBG_ASSERT(sal_uInt32(nPrevStartCol + nRepeat) <= nEnd, "something wents wrong");
-            if ((nPrevIndex != (*pColDefaults)[i].nIndex) ||
-                (bPrevAutoStyle != (*pColDefaults)[i].bIsAutoStyle))
-            {
-                AddRange(nPrevStartCol, nRepeat, nPrevIndex, bPrevAutoStyle, rFormatRange);
-                nPrevStartCol = i;
-                nRepeat = (*pColDefaults)[i].nRepeat;
-                nPrevIndex = (*pColDefaults)[i].nIndex;
-                bPrevAutoStyle = (*pColDefaults)[i].bIsAutoStyle;
-            }
-            else
-                nRepeat += (*pColDefaults)[i].nRepeat;
-        }
-        if (sal_uInt32(nPrevStartCol + nRepeat) > nEnd)
-            nRepeat = nEnd - nPrevStartCol;
-        AddRange(nPrevStartCol, nRepeat, nPrevIndex, bPrevAutoStyle, rFormatRange);
-    }
-    else if ((nPrevIndex == rFormatRange.nIndex) &&
-        (bPrevAutoStyle == rFormatRange.bIsAutoStyle))
-    {
-        rFormatRange.nIndex = -1;
-        aRowFormatRanges.push_back(rFormatRange);
-        ++nSize;
-    }
-}
-
-sal_Bool ScRowFormatRanges::GetNext(ScMyRowFormatRange& aFormatRange)
-{
-    ScMyRowFormatRangesList::iterator aItr(aRowFormatRanges.begin());
-    if (aItr != aRowFormatRanges.end())
-    {
-        aFormatRange = (*aItr);
-        aRowFormatRanges.erase(aItr);
-        --nSize;
-        return sal_True;
-    }
-    return sal_False;
-}
-
-sal_Int32 ScRowFormatRanges::GetMaxRows()
-{
-    ScMyRowFormatRangesList::iterator aItr(aRowFormatRanges.begin());
-    ScMyRowFormatRangesList::iterator aEndItr(aRowFormatRanges.end());
-    sal_Int32 nMaxRows = MAXROW + 1;
-    if (aItr != aEndItr)
-        while (aItr != aEndItr)
-        {
-            if ((*aItr).nRepeatRows < nMaxRows)
-                nMaxRows = (*aItr).nRepeatRows;
-            ++aItr;
-        }
-    else
-    {
-        DBG_ERROR("no ranges found");
-    }
-    return nMaxRows;
-}
-
-sal_Int32 ScRowFormatRanges::GetSize()
-{
-    return nSize;
-}
-
-void ScRowFormatRanges::Sort()
-{
-    aRowFormatRanges.sort();
-}
-
-// ============================================================================
-ScMyFormatRange::ScMyFormatRange()
-    : nStyleNameIndex(-1),
-    nValidationIndex(-1),
-    bIsAutoStyle(sal_True)
-{
-}
-
-sal_Bool ScMyFormatRange::operator<(const ScMyFormatRange& rRange) const
-{
-    if (aRangeAddress.StartRow < rRange.aRangeAddress.StartRow)
-        return sal_True;
-    else
-        if (aRangeAddress.StartRow == rRange.aRangeAddress.StartRow)
-            return (aRangeAddress.StartColumn < rRange.aRangeAddress.StartColumn);
-        else
-            return sal_False;
-}
-
-ScFormatRangeStyles::ScFormatRangeStyles()
-    : aTables(),
-    aStyleNames(),
-    aAutoStyleNames()
-{
-}
-
-ScFormatRangeStyles::~ScFormatRangeStyles()
-{
-    ScMyOUStringVec::iterator i(aStyleNames.begin());
-    ScMyOUStringVec::iterator endi(aStyleNames.end());
-    while (i != endi)
-    {
-        delete *i;
-        ++i;
-    }
-    i = aAutoStyleNames.begin();
-    endi = aAutoStyleNames.end();
-    while (i != endi)
-    {
-        delete *i;
-        ++i;
-    }
-    ScMyFormatRangeListVec::iterator j(aTables.begin());
-    ScMyFormatRangeListVec::iterator endj(aTables.end());
-    while (j != endj)
-    {
-        delete *j;
-        ++j;
-    }
-}
-
-void ScFormatRangeStyles::AddNewTable(const sal_Int32 nTable)
-{
-    sal_Int32 nSize = aTables.size() - 1;
-    if (nTable > nSize)
-        for (sal_Int32 i = nSize; i < nTable; ++i)
-        {
-            ScMyFormatRangeAddresses* aRangeAddresses(new ScMyFormatRangeAddresses);
-            aTables.push_back(aRangeAddresses);
-        }
-}
-
-sal_Bool ScFormatRangeStyles::AddStyleName(rtl::OUString* rpString, sal_Int32& rIndex, const sal_Bool bIsAutoStyle)
-{
-    if (bIsAutoStyle)
-    {
-        aAutoStyleNames.push_back(rpString);
-        rIndex = aAutoStyleNames.size() - 1;
-        return sal_True;
-    }
-    else
-    {
-        sal_Int32 nCount(aStyleNames.size());
-        sal_Bool bFound(sal_False);
-        sal_Int32 i(nCount - 1);
-        while ((i >= 0) && (!bFound))
-        {
-            if (aStyleNames.at(i)->equals(*rpString))
-                bFound = sal_True;
-            else
-                i--;
-        }
-        if (bFound)
-        {
-            rIndex = i;
-            return sal_False;
-        }
-        else
-        {
-            aStyleNames.push_back(rpString);
-            rIndex = aStyleNames.size() - 1;
-            return sal_True;
-        }
-    }
-}
-
-sal_Int32 ScFormatRangeStyles::GetIndexOfStyleName(const rtl::OUString& rString, const rtl::OUString& rPrefix, sal_Bool& bIsAutoStyle)
-{
-    sal_Int32 nPrefixLength(rPrefix.getLength());
-    rtl::OUString sTemp(rString.copy(nPrefixLength));
-    sal_Int32 nIndex(sTemp.toInt32());
-    if (aAutoStyleNames.at(nIndex - 1)->equals(rString))
-    {
-        bIsAutoStyle = sal_True;
-        return nIndex - 1;
-    }
-    else
-    {
-        sal_Int32 i(0);
-        sal_Bool bFound(sal_False);
-        while (!bFound && static_cast<size_t>(i) < aStyleNames.size())
-        {
-            if (aStyleNames[i]->equals(rString))
-                bFound = sal_True;
-            else
-                ++i;
-        }
-        if (bFound)
-        {
-            bIsAutoStyle = sal_False;
-            return i;
-        }
-        else
-        {
-            i = 0;
-            while (!bFound && static_cast<size_t>(i) < aAutoStyleNames.size())
-            {
-                if (aAutoStyleNames[i]->equals(rString))
-                    bFound = sal_True;
-                else
-                    ++i;
-            }
-            if (bFound)
-            {
-                bIsAutoStyle = sal_True;
-                return i;
-            }
-            else
-                return -1;
-        }
-    }
-}
-
-sal_Int32 ScFormatRangeStyles::GetStyleNameIndex(const sal_Int32 nTable,
-    const sal_Int32 nColumn, const sal_Int32 nRow, sal_Bool& bIsAutoStyle) const
-{
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    ScMyFormatRangeAddresses* pFormatRanges(aTables[nTable]);
-    ScMyFormatRangeAddresses::iterator aItr(pFormatRanges->begin());
-    ScMyFormatRangeAddresses::iterator aEndItr(pFormatRanges->end());
-    while (aItr != aEndItr)
-    {
-        if (((*aItr).aRangeAddress.StartColumn <= nColumn) &&
-            ((*aItr).aRangeAddress.EndColumn >= nColumn) &&
-            ((*aItr).aRangeAddress.StartRow <= nRow) &&
-            ((*aItr).aRangeAddress.EndRow >= nRow))
-        {
-            bIsAutoStyle = aItr->bIsAutoStyle;
-            return (*aItr).nStyleNameIndex;
-        }
-        else
-            ++aItr;
-    }
-    return -1;
-}
-
-sal_Int32 ScFormatRangeStyles::GetStyleNameIndex(const sal_Int32 nTable, const sal_Int32 nColumn, const sal_Int32 nRow,
-    sal_Bool& bIsAutoStyle, sal_Int32& nValidationIndex, sal_Int32& nNumberFormat, const sal_Bool bRemoveRange)
-{
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    ScMyFormatRangeAddresses* pFormatRanges(aTables[nTable]);
-    ScMyFormatRangeAddresses::iterator aItr(pFormatRanges->begin());
-    ScMyFormatRangeAddresses::iterator aEndItr(pFormatRanges->end());
-    while (aItr != aEndItr)
-    {
-        if (((*aItr).aRangeAddress.StartColumn <= nColumn) &&
-            ((*aItr).aRangeAddress.EndColumn >= nColumn) &&
-            ((*aItr).aRangeAddress.StartRow <= nRow) &&
-            ((*aItr).aRangeAddress.EndRow >= nRow))
-        {
-            bIsAutoStyle = aItr->bIsAutoStyle;
-            nValidationIndex = aItr->nValidationIndex;
-            nNumberFormat = aItr->nNumberFormat;
-            if (((*pRowDefaults)[nRow].nIndex != -1))
-            {
-                if (((*pRowDefaults)[nRow].nIndex == (*aItr).nStyleNameIndex) &&
-                    ((*pRowDefaults)[nRow].bIsAutoStyle == (*aItr).bIsAutoStyle))
-                    return -1;
-                else
-                    return (*aItr).nStyleNameIndex;
-            }
-            else if (((*pColDefaults)[nColumn].nIndex != -1) &&
-                ((*pColDefaults)[nColumn].nIndex == (*aItr).nStyleNameIndex) &&
-                ((*pColDefaults)[nColumn].bIsAutoStyle == (*aItr).bIsAutoStyle))
-                return -1;
-            else
-                return (*aItr).nStyleNameIndex;
-        }
-        else
-        {
-            if (bRemoveRange && (*aItr).aRangeAddress.EndRow < nRow)
-                aItr = pFormatRanges->erase(aItr);
-            else
-                ++aItr;
-        }
-    }
-    return -1;
-}
-
-void ScFormatRangeStyles::GetFormatRanges(const sal_Int32 nStartColumn, const sal_Int32 nEndColumn, const sal_Int32 nRow,
-                    const sal_Int32 nTable, ScRowFormatRanges* pRowFormatRanges)
-{
-    sal_Int32 nTotalColumns(nEndColumn - nStartColumn + 1);
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    ScMyFormatRangeAddresses* pFormatRanges(aTables[nTable]);
-    ScMyFormatRangeAddresses::iterator aItr(pFormatRanges->begin());
-    ScMyFormatRangeAddresses::iterator aEndItr(pFormatRanges->end());
-    sal_Int32 nColumns = 0;
-    while (aItr != aEndItr && nColumns < nTotalColumns)
-    {
-#if OSL_DEBUG_LEVEL > 1
-        table::CellRangeAddress aTempRangeAddress((*aItr).aRangeAddress);
-#endif
-        if (((*aItr).aRangeAddress.StartRow <= nRow) &&
-            ((*aItr).aRangeAddress.EndRow >= nRow))
-        {
-            if ((((*aItr).aRangeAddress.StartColumn <= nStartColumn) &&
-                ((*aItr).aRangeAddress.EndColumn >= nStartColumn)) ||
-                (((*aItr).aRangeAddress.StartColumn <= nEndColumn) &&
-                ((*aItr).aRangeAddress.EndColumn >= nEndColumn)) ||
-                (((*aItr).aRangeAddress.StartColumn >= nStartColumn) &&
-                ((*aItr).aRangeAddress.EndColumn <= nEndColumn)))
-            {
-                ScMyRowFormatRange aRange;
-                aRange.nIndex = aItr->nStyleNameIndex;
-                aRange.nValidationIndex = aItr->nValidationIndex;
-                aRange.bIsAutoStyle = aItr->bIsAutoStyle;
-                if ((aItr->aRangeAddress.StartColumn < nStartColumn) &&
-                    (aItr->aRangeAddress.EndColumn >= nStartColumn))
-                {
-                    if (aItr->aRangeAddress.EndColumn >= nEndColumn)
-                        aRange.nRepeatColumns = nTotalColumns;
-                    else
-                        aRange.nRepeatColumns = aItr->aRangeAddress.EndColumn - nStartColumn + 1;
-                    aRange.nStartColumn = nStartColumn;
-                }
-                else if ((aItr->aRangeAddress.StartColumn >= nStartColumn) &&
-                    (aItr->aRangeAddress.EndColumn <= nEndColumn))
-                {
-                    aRange.nRepeatColumns = aItr->aRangeAddress.EndColumn - aItr->aRangeAddress.StartColumn + 1;
-                    aRange.nStartColumn = aItr->aRangeAddress.StartColumn;
-                }
-                else if ((aItr->aRangeAddress.StartColumn >= nStartColumn) &&
-                    (aItr->aRangeAddress.StartColumn <= nEndColumn) &&
-                    (aItr->aRangeAddress.EndColumn > nEndColumn))
-                {
-                    aRange.nRepeatColumns = nEndColumn - aItr->aRangeAddress.StartColumn + 1;
-                    aRange.nStartColumn = aItr->aRangeAddress.StartColumn;
-                }
-                aRange.nRepeatRows = aItr->aRangeAddress.EndRow - nRow + 1;
-                pRowFormatRanges->AddRange(aRange, nRow);
-                nColumns += aRange.nRepeatColumns;
-            }
-            ++aItr;
-        }
-        else
-            if(aItr->aRangeAddress.EndRow < nRow)
-                aItr = pFormatRanges->erase(aItr);
-            else
-                ++aItr;
-    }
-    pRowFormatRanges->Sort();
-}
-
-void ScFormatRangeStyles::AddRangeStyleName(const table::CellRangeAddress aCellRangeAddress,
-    const sal_Int32 nStringIndex, const sal_Bool bIsAutoStyle, const sal_Int32 nValidationIndex,
-    const sal_Int32 nNumberFormat)
-{
-    ScMyFormatRange aFormatRange;
-    aFormatRange.aRangeAddress = aCellRangeAddress;
-    aFormatRange.nStyleNameIndex = nStringIndex;
-    aFormatRange.nValidationIndex = nValidationIndex;
-    aFormatRange.nNumberFormat = nNumberFormat;
-    aFormatRange.bIsAutoStyle = bIsAutoStyle;
-    DBG_ASSERT(static_cast<size_t>(aCellRangeAddress.Sheet) < aTables.size(), "wrong table");
-    ScMyFormatRangeAddresses* pFormatRanges(aTables[aCellRangeAddress.Sheet]);
-    pFormatRanges->push_back(aFormatRange);
-}
-
-rtl::OUString* ScFormatRangeStyles::GetStyleNameByIndex(const sal_Int32 nIndex, const sal_Bool bIsAutoStyle)
-{
-    if (bIsAutoStyle)
-        return aAutoStyleNames[nIndex];
-    else
-        return aStyleNames[nIndex];
-}
-
-void ScFormatRangeStyles::Sort()
-{
-    sal_Int32 nTables = aTables.size();
-    for (sal_Int16 i = 0; i < nTables; ++i)
-        if (!aTables[i]->empty())
-            aTables[i]->sort();
-}
-
-//===========================================================================
-
-ScColumnRowStylesBase::ScColumnRowStylesBase()
-    : aStyleNames()
-{
-}
-
-ScColumnRowStylesBase::~ScColumnRowStylesBase()
-{
-    ScMyOUStringVec::iterator i(aStyleNames.begin());
-    ScMyOUStringVec::iterator endi(aStyleNames.end());
-    while (i != endi)
-    {
-        delete *i;
-        ++i;
-    }
-}
-
-sal_Int32 ScColumnRowStylesBase::AddStyleName(rtl::OUString* pString)
-{
-    aStyleNames.push_back(pString);
-    return aStyleNames.size() - 1;
-}
-
-sal_Int32 ScColumnRowStylesBase::GetIndexOfStyleName(const rtl::OUString& rString, const rtl::OUString& rPrefix)
-{
-    sal_Int32 nPrefixLength(rPrefix.getLength());
-    rtl::OUString sTemp(rString.copy(nPrefixLength));
-    sal_Int32 nIndex(sTemp.toInt32());
-    if (aStyleNames.at(nIndex - 1)->equals(rString))
-        return nIndex - 1;
-    else
-    {
-        sal_Int32 i(0);
-        sal_Bool bFound(sal_False);
-        while (!bFound && static_cast<size_t>(i) < aStyleNames.size())
-        {
-            if (aStyleNames.at(i)->equals(rString))
-                bFound = sal_True;
-            else
-                ++i;
-        }
-        if (bFound)
-            return i;
-        else
-            return -1;
-    }
-}
-
-rtl::OUString* ScColumnRowStylesBase::GetStyleNameByIndex(const sal_Int32 nIndex)
-{
-    if ( nIndex < 0 || nIndex >= sal::static_int_cast<sal_Int32>( aStyleNames.size() ) )
-    {
-        // #123981# should no longer happen, use first style then
-        DBG_ERRORFILE("GetStyleNameByIndex: invalid index");
-        return aStyleNames[0];
-    }
-
-    return aStyleNames[nIndex];
-}
-
-//===========================================================================
-
-ScColumnStyles::ScColumnStyles()
-    : ScColumnRowStylesBase(),
-    aTables()
-{
-}
-
-ScColumnStyles::~ScColumnStyles()
-{
-}
-
-void ScColumnStyles::AddNewTable(const sal_Int32 nTable, const sal_Int32 nFields)
-{
-    sal_Int32 nSize(aTables.size() - 1);
-    if (nTable > nSize)
-        for (sal_Int32 i = nSize; i < nTable; ++i)
-        {
-            ScMyColumnStyleVec aFieldsVec(nFields + 1, ScColumnStyle());
-            aTables.push_back(aFieldsVec);
-        }
-}
-
-sal_Int32 ScColumnStyles::GetStyleNameIndex(const sal_Int32 nTable, const sal_Int32 nField,
-    sal_Bool& bIsVisible)
-{
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    if (static_cast<size_t>(nField) < aTables[nTable].size())
-    {
-        bIsVisible = aTables[nTable][nField].bIsVisible;
-        return aTables[nTable][nField].nIndex;
-    }
-    else
-    {
-        bIsVisible = aTables[nTable][aTables[nTable].size() - 1].bIsVisible;
-        return aTables[nTable][aTables[nTable].size() - 1].nIndex;
-    }
-}
-
-void ScColumnStyles::AddFieldStyleName(const sal_Int32 nTable, const sal_Int32 nField,
-    const sal_Int32 nStringIndex, const sal_Bool bIsVisible)
-{
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    DBG_ASSERT(aTables[nTable].size() >= static_cast<sal_uInt32>(nField), "wrong field");
-    ScColumnStyle aStyle;
-    aStyle.nIndex = nStringIndex;
-    aStyle.bIsVisible = bIsVisible;
-    if (aTables[nTable].size() == static_cast<sal_uInt32>(nField))
-        aTables[nTable].push_back(aStyle);
-    aTables[nTable][nField] = aStyle;
-}
-
-rtl::OUString* ScColumnStyles::GetStyleName(const sal_Int32 nTable, const sal_Int32 nField)
-{
-    sal_Bool bTemp;
-    return GetStyleNameByIndex(GetStyleNameIndex(nTable, nField, bTemp));
-}
-
-//===========================================================================
-
-ScRowStyles::ScRowStyles()
-    : ScColumnRowStylesBase(),
-    aTables()
-{
-}
-
-ScRowStyles::~ScRowStyles()
-{
-}
-
-void ScRowStyles::AddNewTable(const sal_Int32 nTable, const sal_Int32 nFields)
-{
-    sal_Int32 nSize(aTables.size() - 1);
-    if (nTable > nSize)
-        for (sal_Int32 i = nSize; i < nTable; ++i)
-        {
-            ScMysalInt32Vec aFieldsVec(nFields + 1, -1);
-            aTables.push_back(aFieldsVec);
-        }
-}
-
-sal_Int32 ScRowStyles::GetStyleNameIndex(const sal_Int32 nTable, const sal_Int32 nField)
-{
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    if (static_cast<size_t>(nField) < aTables[nTable].size())
-        return aTables[nTable][nField];
-    else
-        return aTables[nTable][aTables[nTable].size() - 1];
-}
-
-void ScRowStyles::AddFieldStyleName(const sal_Int32 nTable, const sal_Int32 nField,
-    const sal_Int32 nStringIndex)
-{
-    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
-    DBG_ASSERT(aTables[nTable].size() >= static_cast<sal_uInt32>(nField), "wrong field");
-    if (aTables[nTable].size() == static_cast<sal_uInt32>(nField))
-        aTables[nTable].push_back(nStringIndex);
-    aTables[nTable][nField] = nStringIndex;
-}
-
-rtl::OUString* ScRowStyles::GetStyleName(const sal_Int32 nTable, const sal_Int32 nField)
-{
-    return GetStyleNameByIndex(GetStyleNameIndex(nTable, nField));
-}
+/*************************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2008 by Sun Microsystems, Inc.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * $RCSfile: XMLStylesExportHelper.cxx,v $
+ * $Revision: 1.52 $
+ *
+ * This file is part of OpenOffice.org.
+ *
+ * OpenOffice.org is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License version 3
+ * only, as published by the Free Software Foundation.
+ *
+ * OpenOffice.org 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 version 3 for more details
+ * (a copy is included in the LICENSE file that accompanied this code).
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * version 3 along with OpenOffice.org.  If not, see
+ * <http://www.openoffice.org/license.html>
+ * for a copy of the LGPLv3 License.
+ *
+ ************************************************************************/
+
+// MARKER(update_precomp.py): autogen include statement, do not remove
+#include "precompiled_sc.hxx"
+
+
+// INCLUDE ---------------------------------------------------------------
+#include "XMLStylesExportHelper.hxx"
+#include "global.hxx"
+#include "unonames.hxx"
+#include "XMLConverter.hxx"
+#include "xmlexprt.hxx"
+#include "document.hxx"
+#include "rangeutl.hxx"
+#include <xmloff/xmltoken.hxx>
+#include <xmloff/xmlnmspe.hxx>
+#include <xmloff/XMLEventExport.hxx>
+#include <xmloff/nmspmap.hxx>
+#include <tools/debug.hxx>
+#include <com/sun/star/uno/Reference.h>
+#include <com/sun/star/beans/XPropertySet.hpp>
+#include <com/sun/star/sheet/XSheetCondition.hpp>
+#include <com/sun/star/sheet/TableValidationVisibility.hpp>
+#include <comphelper/extract.hxx>
+#include <sfx2/app.hxx>
+
+#include <algorithm>
+
+using namespace com::sun::star;
+using namespace xmloff::token;
+
+ScMyValidation::ScMyValidation()
+    : sName(),
+    sErrorMessage(),
+    sErrorTitle(),
+    sImputMessage(),
+    sImputTitle(),
+    sFormula1(),
+    sFormula2(),
+    bShowErrorMessage(sal_False),
+    bShowImputMessage(sal_False),
+    bIgnoreBlanks(sal_False)
+{
+}
+
+ScMyValidation::~ScMyValidation()
+{
+}
+
+sal_Bool ScMyValidation::IsEqual(const ScMyValidation& aVal) const
+{
+    if (aVal.bIgnoreBlanks == bIgnoreBlanks &&
+        aVal.bShowImputMessage == bShowImputMessage &&
+        aVal.bShowErrorMessage == bShowErrorMessage &&
+        aVal.aBaseCell.Sheet == aBaseCell.Sheet &&
+        aVal.aBaseCell.Column == aBaseCell.Column &&
+        aVal.aBaseCell.Row == aBaseCell.Row &&
+        aVal.aAlertStyle == aAlertStyle &&
+        aVal.aValidationType == aValidationType &&
+        aVal.aOperator == aOperator &&
+        aVal.sErrorTitle == sErrorTitle &&
+        aVal.sImputTitle == sImputTitle &&
+        aVal.sErrorMessage == sErrorMessage &&
+        aVal.sImputMessage == sImputMessage &&
+        aVal.sFormula1 == sFormula1 &&
+        aVal.sFormula2 == sFormula2)
+        return sal_True;
+    else
+        return sal_False;
+}
+
+ScMyValidationsContainer::ScMyValidationsContainer()
+    : aValidationVec(),
+    sEmptyString(),
+    sERRALSTY(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_ERRALSTY)),
+    sIGNOREBL(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_IGNOREBL)),
+    sSHOWLIST(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_SHOWLIST)),
+    sTYPE(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_TYPE)),
+    sSHOWINP(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_SHOWINP)),
+    sSHOWERR(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_SHOWERR)),
+    sINPTITLE(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_INPTITLE)),
+    sINPMESS(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_INPMESS)),
+    sERRTITLE(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_ERRTITLE)),
+    sERRMESS(RTL_CONSTASCII_USTRINGPARAM(SC_UNONAME_ERRMESS)),
+    sOnError(RTL_CONSTASCII_USTRINGPARAM("OnError")),
+    sEventType(RTL_CONSTASCII_USTRINGPARAM("EventType")),
+    sStarBasic(RTL_CONSTASCII_USTRINGPARAM("StarBasic")),
+    sScript(RTL_CONSTASCII_USTRINGPARAM("Script")),
+    sLibrary(RTL_CONSTASCII_USTRINGPARAM("Library")),
+    sMacroName(RTL_CONSTASCII_USTRINGPARAM("MacroName"))
+{
+}
+
+ScMyValidationsContainer::~ScMyValidationsContainer()
+{
+}
+
+sal_Bool ScMyValidationsContainer::AddValidation(const uno::Any& aTempAny,
+    sal_Int32& nValidationIndex)
+{
+    sal_Bool bAdded(sal_False);
+    uno::Reference<beans::XPropertySet> xPropertySet(aTempAny, uno::UNO_QUERY);
+    if (xPropertySet.is())
+    {
+        rtl::OUString sErrorMessage;
+        xPropertySet->getPropertyValue(sERRMESS) >>= sErrorMessage;
+        rtl::OUString sErrorTitle;
+        xPropertySet->getPropertyValue(sERRTITLE) >>= sErrorTitle;
+        rtl::OUString sImputMessage;
+        xPropertySet->getPropertyValue(sINPMESS) >>= sImputMessage;
+        rtl::OUString sImputTitle;
+        xPropertySet->getPropertyValue(sINPTITLE) >>= sImputTitle;
+        sal_Bool bShowErrorMessage = ::cppu::any2bool(xPropertySet->getPropertyValue(sSHOWERR));
+        sal_Bool bShowImputMessage = ::cppu::any2bool(xPropertySet->getPropertyValue(sSHOWINP));
+        sheet::ValidationType aValidationType;
+        xPropertySet->getPropertyValue(sTYPE) >>= aValidationType;
+        if (bShowErrorMessage || bShowImputMessage || aValidationType != sheet::ValidationType_ANY ||
+            sErrorMessage.getLength() || sErrorTitle.getLength() || sImputMessage.getLength() || sImputTitle.getLength())
+        {
+            ScMyValidation aValidation;
+            aValidation.sErrorMessage = sErrorMessage;
+            aValidation.sErrorTitle = sErrorTitle;
+            aValidation.sImputMessage = sImputMessage;
+            aValidation.sImputTitle = sImputTitle;
+            aValidation.bShowErrorMessage = bShowErrorMessage;
+            aValidation.bShowImputMessage = bShowImputMessage;
+            aValidation.aValidationType = aValidationType;
+            aValidation.bIgnoreBlanks = ::cppu::any2bool(xPropertySet->getPropertyValue(sIGNOREBL));
+            xPropertySet->getPropertyValue(sSHOWLIST) >>= aValidation.nShowList;
+            xPropertySet->getPropertyValue(sERRALSTY) >>= aValidation.aAlertStyle;
+            uno::Reference<sheet::XSheetCondition> xCondition(xPropertySet, uno::UNO_QUERY);
+            if (xCondition.is())
+            {
+                aValidation.sFormula1 = xCondition->getFormula1();
+                aValidation.sFormula2 = xCondition->getFormula2();
+                aValidation.aOperator = xCondition->getOperator();
+                aValidation.aBaseCell = xCondition->getSourcePosition();
+            }
+            //ScMyValidationRange aValidationRange;
+            sal_Bool bEqualFound(sal_False);
+            sal_Int32 i(0);
+            sal_Int32 nCount(aValidationVec.size());
+            while (i < nCount && !bEqualFound)
+            {
+                bEqualFound = aValidationVec[i].IsEqual(aValidation);
+                if (!bEqualFound)
+                    ++i;
+            }
+            if (bEqualFound)
+                nValidationIndex = i;
+            else
+            {
+                sal_Int32 nNameIndex(nCount + 1);
+                rtl::OUString sCount(rtl::OUString::valueOf(nNameIndex));
+                rtl::OUString sPrefix(RTL_CONSTASCII_USTRINGPARAM("val"));
+                aValidation.sName += sPrefix;
+                aValidation.sName += sCount;
+                aValidationVec.push_back(aValidation);
+                nValidationIndex = nCount;
+                bAdded = sal_True;
+            }
+        }
+    }
+    return bAdded;
+}
+
+rtl::OUString ScMyValidationsContainer::GetCondition(ScXMLExport& rExport, const ScMyValidation& aValidation)
+{
+    rtl::OUString sCondition;
+    if (aValidation.aValidationType != sheet::ValidationType_ANY)
+    {
+        switch (aValidation.aValidationType)
+        {
+            //case sheet::ValidationType_CUSTOM
+            case sheet::ValidationType_DATE :
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-date()"));
+            break;
+            case sheet::ValidationType_DECIMAL :
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-decimal-number()"));
+            break;
+            case sheet::ValidationType_LIST :
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-in-list("));
+                sCondition += aValidation.sFormula1;
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(")"));
+            break;
+            case sheet::ValidationType_TEXT_LEN :
+                if (aValidation.aOperator != sheet::ConditionOperator_BETWEEN &&
+                    aValidation.aOperator != sheet::ConditionOperator_NOT_BETWEEN)
+                    sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length()"));
+            break;
+            case sheet::ValidationType_TIME :
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-time()"));
+            break;
+            case sheet::ValidationType_WHOLE :
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-whole-number()"));
+            break;
+            default:
+            {
+                // added to avoid warnings
+            }
+        }
+        if (aValidation.aValidationType != sheet::ValidationType_LIST &&
+            (aValidation.sFormula1.getLength() ||
+            (aValidation.aOperator == sheet::ConditionOperator_BETWEEN &&
+            aValidation.aOperator == sheet::ConditionOperator_NOT_BETWEEN &&
+            aValidation.sFormula2.getLength())))
+        {
+            if (aValidation.aValidationType != sheet::ValidationType_TEXT_LEN)
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(" and "));
+            if (aValidation.aOperator != sheet::ConditionOperator_BETWEEN &&
+                aValidation.aOperator != sheet::ConditionOperator_NOT_BETWEEN)
+            {
+                if (aValidation.aValidationType != sheet::ValidationType_TEXT_LEN)
+                    sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content()"));
+                switch (aValidation.aOperator)
+                {
+                    case sheet::ConditionOperator_EQUAL :
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("="));
+                    break;
+                    case sheet::ConditionOperator_GREATER :
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(">"));
+                    break;
+                    case sheet::ConditionOperator_GREATER_EQUAL :
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(">="));
+                    break;
+                    case sheet::ConditionOperator_LESS :
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("<"));
+                    break;
+                    case sheet::ConditionOperator_LESS_EQUAL :
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("<="));
+                    break;
+                    case sheet::ConditionOperator_NOT_EQUAL :
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("!="));
+                    break;
+                    default:
+                    {
+                        // added to avoid warnings
+                    }
+                }
+                sCondition += aValidation.sFormula1;
+            }
+            else
+            {
+                if (aValidation.aValidationType == sheet::ValidationType_TEXT_LEN)
+                {
+                    if (aValidation.aOperator == sheet::ConditionOperator_BETWEEN)
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-between("));
+                    else
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-not-between("));
+                }
+                else
+                {
+                    if (aValidation.aOperator == sheet::ConditionOperator_BETWEEN)
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-between("));
+                    else
+                        sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-not-between("));
+                }
+                sCondition += aValidation.sFormula1;
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(","));
+                sCondition += aValidation.sFormula2;
+                sCondition += rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(")"));
+            }
+        }
+        else
+            if (aValidation.aValidationType == sheet::ValidationType_TEXT_LEN)
+                sCondition = rtl::OUString();
+    }
+    if (sCondition.getLength())
+    {
+        const formula::FormulaGrammar::Grammar eGrammar = rExport.GetDocument()->GetStorageGrammar();
+        sal_uInt16 nNamespacePrefix = (eGrammar == formula::FormulaGrammar::GRAM_ODFF ? XML_NAMESPACE_OF : XML_NAMESPACE_OOOC);
+        sCondition = rExport.GetNamespaceMap().GetQNameByKey( nNamespacePrefix, sCondition, sal_False );
+    }
+
+    return sCondition;
+}
+
+rtl::OUString ScMyValidationsContainer::GetBaseCellAddress(ScDocument* pDoc, const table::CellAddress& aCell)
+{
+    rtl::OUString sAddress;
+    ScRangeStringConverter::GetStringFromAddress( sAddress, aCell, pDoc );
+    return sAddress;
+}
+
+void ScMyValidationsContainer::WriteMessage(ScXMLExport& rExport,
+    const rtl::OUString& sTitle, const rtl::OUString& sOUMessage,
+    const sal_Bool bShowMessage, const sal_Bool bIsHelpMessage)
+{
+    if (sTitle.getLength())
+        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_TITLE, sTitle);
+    if (bShowMessage)
+        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY, XML_TRUE);
+    else
+        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY, XML_FALSE);
+    SvXMLElementExport* pMessage(NULL);
+    if (bIsHelpMessage)
+        pMessage = new SvXMLElementExport(rExport, XML_NAMESPACE_TABLE, XML_HELP_MESSAGE, sal_True, sal_True);
+    else
+        pMessage = new SvXMLElementExport(rExport, XML_NAMESPACE_TABLE, XML_ERROR_MESSAGE, sal_True, sal_True);
+    if (sOUMessage.getLength())
+    {
+        sal_Int32 i(0);
+        rtl::OUStringBuffer sTemp;
+        String sMessage(sOUMessage);
+        rtl::OUString sText (sMessage.ConvertLineEnd(LINEEND_LF));
+        sal_Bool bPrevCharWasSpace(sal_True);
+        while(i < sText.getLength())
+        {
+            if ((sText[i] == '\n'))
+            {
+                SvXMLElementExport aElemP(rExport, XML_NAMESPACE_TEXT, XML_P, sal_True, sal_False);
+                rExport.GetTextParagraphExport()->exportText(sTemp.makeStringAndClear(), bPrevCharWasSpace);
+            }
+            else
+                sTemp.append(sText[i]);
+            ++i;
+        }
+        if (sTemp.getLength())
+        {
+            SvXMLElementExport aElemP(rExport, XML_NAMESPACE_TEXT, XML_P, sal_True, sal_False);
+            rExport.GetTextParagraphExport()->exportText(sTemp.makeStringAndClear(), bPrevCharWasSpace);
+        }
+    }
+    if (pMessage)
+        delete pMessage;
+}
+
+void ScMyValidationsContainer::WriteValidations(ScXMLExport& rExport)
+{
+    if (aValidationVec.size())
+    {
+        SvXMLElementExport aElemVs(rExport, XML_NAMESPACE_TABLE, XML_CONTENT_VALIDATIONS, sal_True, sal_True);
+        ScMyValidationVec::iterator aItr(aValidationVec.begin());
+        ScMyValidationVec::iterator aEndItr(aValidationVec.end());
+        while (aItr != aEndItr)
+        {
+            rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_NAME, aItr->sName);
+            rtl::OUString sCondition(GetCondition(rExport, *aItr));
+            if (sCondition.getLength())
+            {
+                rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_CONDITION, sCondition);
+                if (aItr->bIgnoreBlanks)
+                    rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_ALLOW_EMPTY_CELL, XML_TRUE);
+                else
+                    rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_ALLOW_EMPTY_CELL, XML_FALSE);
+                if (aItr->aValidationType == sheet::ValidationType_LIST)
+                {
+                    switch (aItr->nShowList)
+                    {
+                    case sheet::TableValidationVisibility::INVISIBLE:
+                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY_LIST, XML_NO);
+                    break;
+                    case sheet::TableValidationVisibility::UNSORTED:
+                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY_LIST, XML_UNSORTED);
+                    break;
+                    case sheet::TableValidationVisibility::SORTEDASCENDING:
+                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_DISPLAY_LIST, XML_SORTED_ASCENDING);
+                    break;
+                    default:
+                        DBG_ERROR("unknown ListType");
+                    }
+                }
+            }
+            rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_BASE_CELL_ADDRESS, GetBaseCellAddress(rExport.GetDocument(), aItr->aBaseCell));
+            SvXMLElementExport aElemV(rExport, XML_NAMESPACE_TABLE, XML_CONTENT_VALIDATION, sal_True, sal_True);
+            if (aItr->bShowImputMessage || aItr->sImputMessage.getLength() || aItr->sImputTitle.getLength())
+            {
+                WriteMessage(rExport, aItr->sImputTitle, aItr->sImputMessage, aItr->bShowImputMessage, sal_True);
+            }
+            if (aItr->bShowErrorMessage || aItr->sErrorMessage.getLength() || aItr->sErrorTitle.getLength())
+            {
+                switch (aItr->aAlertStyle)
+                {
+                    case sheet::ValidationAlertStyle_INFO :
+                    {
+                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_MESSAGE_TYPE, XML_INFORMATION);
+                        WriteMessage(rExport, aItr->sErrorTitle, aItr->sErrorMessage, aItr->bShowErrorMessage, sal_False);
+                    }
+                    break;
+                    case sheet::ValidationAlertStyle_WARNING :
+                    {
+                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_MESSAGE_TYPE, XML_WARNING);
+                        WriteMessage(rExport, aItr->sErrorTitle, aItr->sErrorMessage, aItr->bShowErrorMessage, sal_False);
+                    }
+                    break;
+                    case sheet::ValidationAlertStyle_STOP :
+                    {
+                        rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_MESSAGE_TYPE, XML_STOP);
+                        WriteMessage(rExport, aItr->sErrorTitle, aItr->sErrorMessage, aItr->bShowErrorMessage, sal_False);
+                    }
+                    break;
+                    case sheet::ValidationAlertStyle_MACRO :
+                    {
+                        {
+                            //rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_NAME, aItr->sErrorTitle);
+                            if (aItr->bShowErrorMessage)
+                                rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_EXECUTE, XML_TRUE);
+                            else
+                                rExport.AddAttribute(XML_NAMESPACE_TABLE, XML_EXECUTE, XML_FALSE);
+                            SvXMLElementExport aEMElem(rExport, XML_NAMESPACE_TABLE, XML_ERROR_MACRO, sal_True, sal_True);
+                        }
+                        {
+                            // #i47525# for a script URL the type and the property name for the URL
+                            // are both "Script", for a simple macro name the type is "StarBasic"
+                            // and the property name is "MacroName".
+                            bool bScriptURL = SfxApplication::IsXScriptURL( aItr->sErrorTitle );
+
+                            uno::Sequence<beans::PropertyValue> aSeq(3);
+                            beans::PropertyValue* pArr(aSeq.getArray());
+                            pArr[0].Name = sEventType;
+                            pArr[0].Value <<= bScriptURL ? sScript : sStarBasic;
+                            pArr[1].Name = sLibrary;
+                            pArr[1].Value <<= sEmptyString;
+                            pArr[2].Name = bScriptURL ? sScript : sMacroName;
+                            pArr[2].Value <<= aItr->sErrorTitle;
+
+                            // 2) export the sequence
+                            rExport.GetEventExport().ExportSingleEvent( aSeq, sOnError);
+                        }
+                    }
+                    break;
+                    default:
+                    {
+                        // added to avoid warnings
+                    }
+                }
+            }
+            ++aItr;
+        }
+    }
+}
+
+const rtl::OUString& ScMyValidationsContainer::GetValidationName(const sal_Int32 nIndex)
+{
+    DBG_ASSERT( static_cast<size_t>(nIndex) < aValidationVec.size(), "out of range" );
+    return aValidationVec[nIndex].sName;
+}
+
+//==============================================================================
+
+sal_Int32 ScMyDefaultStyles::GetStyleNameIndex(const ScFormatRangeStyles* pCellStyles,
+    const sal_Int32 nTable, const sal_Int32 nPos,
+    const sal_Int32 i, const sal_Bool bRow, sal_Bool& bIsAutoStyle)
+{
+    if (bRow)
+        return pCellStyles->GetStyleNameIndex(nTable, nPos, i,
+                                bIsAutoStyle);
+    else
+        return pCellStyles->GetStyleNameIndex(nTable, i, nPos,
+                                bIsAutoStyle);
+}
+
+void ScMyDefaultStyles::FillDefaultStyles(const sal_Int32 nTable,
+    const sal_Int32 nLastRow, const sal_Int32 nLastCol,
+    const ScFormatRangeStyles* pCellStyles, ScDocument* pDoc,
+    const sal_Bool bRow)
+{
+    if (pDoc)
+    {
+        SCTAB nTab = static_cast<SCTAB>(nTable);
+        sal_Int32 nPos;
+        sal_Int32 nLast;
+        ScMyDefaultStyleList* pDefaults;
+        if (bRow)
+        {
+            pDefaults = pRowDefaults;
+            nLast = nLastRow;
+        }
+        else
+        {
+            pDefaults = pColDefaults;
+            nLast = nLastCol;
+        }
+        sal_Bool bPrevAutoStyle(sal_False);
+        sal_Bool bIsAutoStyle;
+        sal_Bool bResult;
+        sal_Int32 nPrevIndex(0);
+        sal_Int32 nIndex;
+        sal_Int32 nRepeat(0);
+        sal_Int32 nEmptyRepeat(0);
+        for (sal_Int32 i = nLast; i >= 0; --i)
+        {
+            if (bRow)
+            {
+                SCCOL nCol;
+                bResult = pDoc->GetRowDefault(nTab,
+                    static_cast<SCROW>(i), static_cast<SCCOL>(nLastCol), nCol);
+                nPos = static_cast<sal_Int32>(nCol);
+            }
+            else
+            {
+                SCROW nRow;
+                bResult = pDoc->GetColDefault(nTab,
+                    static_cast<SCCOL>(i), static_cast<SCROW>(nLastRow), nRow);
+                nPos = static_cast<sal_Int32>(nRow);
+            }
+            if (bResult)
+            {
+                nEmptyRepeat = 0;
+                if (!nRepeat)
+                {
+                    nPrevIndex = GetStyleNameIndex(pCellStyles, nTab, nPos, i,
+                                                bRow, bPrevAutoStyle);
+                    (*pDefaults)[i].nIndex = nPrevIndex;
+                    (*pDefaults)[i].bIsAutoStyle = bPrevAutoStyle;
+                    nRepeat = 1;
+                }
+                else
+                {
+                    nIndex = GetStyleNameIndex(pCellStyles, nTab, nPos, i,
+                                            bRow, bIsAutoStyle);
+                    if ((nIndex != nPrevIndex) || (bIsAutoStyle != bPrevAutoStyle))
+                    {
+                        nRepeat = 1;
+                        nPrevIndex = GetStyleNameIndex(pCellStyles, nTab, nPos, i,
+                                                bRow, bPrevAutoStyle);
+                        (*pDefaults)[i].nIndex = nPrevIndex;
+                        (*pDefaults)[i].bIsAutoStyle = bPrevAutoStyle;
+                    }
+                    else
+                    {
+                        (*pDefaults)[i].nIndex = nPrevIndex;
+                        (*pDefaults)[i].bIsAutoStyle = bPrevAutoStyle;
+                        ++nRepeat;
+                        if (nRepeat > 1)
+                            (*pDefaults)[i].nRepeat = nRepeat;
+                    }
+                }
+            }
+            else
+            {
+                nRepeat = 0;
+                if (!nEmptyRepeat)
+                    nEmptyRepeat = 1;
+                else
+                {
+                    ++nEmptyRepeat;
+                    if (nEmptyRepeat > 1)
+                        (*pDefaults)[i].nRepeat = nEmptyRepeat;
+                }
+            }
+        }
+    }
+}
+
+void ScMyDefaultStyles::FillDefaultStyles(const sal_Int32 nTable,
+    const sal_Int32 nLastRow, const sal_Int32 nLastCol,
+    const ScFormatRangeStyles* pCellStyles, ScDocument* pDoc)
+{
+    if (pRowDefaults)
+        delete pRowDefaults;
+    pRowDefaults = new ScMyDefaultStyleList(nLastRow + 1);
+     FillDefaultStyles(nTable, nLastRow, nLastCol, pCellStyles, pDoc, sal_True);
+    if (pColDefaults)
+        delete pColDefaults;
+    pColDefaults = new ScMyDefaultStyleList(nLastCol + 1);
+     FillDefaultStyles(nTable, nLastRow, nLastCol, pCellStyles, pDoc, sal_False);
+}
+
+ScMyDefaultStyles::~ScMyDefaultStyles()
+{
+    if (pRowDefaults)
+        delete pRowDefaults;
+    if (pColDefaults)
+        delete pColDefaults;
+}
+
+ScMyRowFormatRange::ScMyRowFormatRange()
+    : nStartColumn(0),
+    nRepeatColumns(0),
+    nRepeatRows(0),
+    nIndex(-1),
+    nValidationIndex(-1),
+    bIsAutoStyle(sal_True)
+{
+}
+
+sal_Bool ScMyRowFormatRange::operator< (const ScMyRowFormatRange& rRange) const
+{
+    return (nStartColumn < rRange.nStartColumn);
+}
+
+ScRowFormatRanges::ScRowFormatRanges()
+    : aRowFormatRanges(),
+    pRowDefaults(NULL),
+    pColDefaults(NULL),
+    nSize(0)
+{
+}
+
+ScRowFormatRanges::ScRowFormatRanges(const ScRowFormatRanges* pRanges)
+    : aRowFormatRanges(pRanges->aRowFormatRanges),
+    pRowDefaults(pRanges->pRowDefaults),
+    pColDefaults(pRanges->pColDefaults),
+    nSize(pRanges->nSize)
+{
+}
+
+ScRowFormatRanges::~ScRowFormatRanges()
+{
+}
+
+void ScRowFormatRanges::Clear()
+{
+    aRowFormatRanges.clear();
+    nSize = 0;
+}
+
+void ScRowFormatRanges::AddRange(const sal_Int32 nPrevStartCol, const sal_Int32 nRepeat, const sal_Int32 nPrevIndex,
+    const sal_Bool bPrevAutoStyle, const ScMyRowFormatRange& rFormatRange)
+{
+    sal_Int32 nIndex(-1);
+    if ((nPrevIndex != rFormatRange.nIndex) ||
+        (bPrevAutoStyle != rFormatRange.bIsAutoStyle))
+        nIndex = rFormatRange.nIndex;
+
+    sal_Bool bInserted(sal_False);
+    if (!aRowFormatRanges.empty())
+    {
+        ScMyRowFormatRange* pRange(&aRowFormatRanges.back());
+        if (pRange)
+        {
+            if ((nPrevStartCol == (pRange->nStartColumn + pRange->nRepeatColumns)) &&
+                (pRange->bIsAutoStyle == rFormatRange.bIsAutoStyle) &&
+                (pRange->nIndex == nIndex) &&
+                (pRange->nValidationIndex == rFormatRange.nValidationIndex))
+            {
+                if (rFormatRange.nRepeatRows < pRange->nRepeatRows)
+                    pRange->nRepeatRows = rFormatRange.nRepeatRows;
+                pRange->nRepeatColumns += nRepeat;
+                bInserted = sal_True;
+            }
+        }
+    }
+    if (!bInserted)
+    {
+        ScMyRowFormatRange aRange;
+        aRange.nStartColumn = nPrevStartCol;
+        aRange.nRepeatColumns = nRepeat;
+        aRange.nRepeatRows = rFormatRange.nRepeatRows;
+        aRange.nValidationIndex = rFormatRange.nValidationIndex;
+        aRange.bIsAutoStyle = rFormatRange.bIsAutoStyle;
+        aRange.nIndex = nIndex;
+        aRowFormatRanges.push_back(aRange);
+        ++nSize;
+    }
+}
+
+void ScRowFormatRanges::AddRange(ScMyRowFormatRange& rFormatRange,
+    const sal_Int32 nRow)
+{
+    DBG_ASSERT(pRowDefaults, "no row defaults");
+    DBG_ASSERT(pColDefaults, "no column defaults");
+    sal_uInt32 nEnd (rFormatRange.nRepeatRows + nRow - 1);
+    sal_Int32 nPrevIndex((*pRowDefaults)[nRow].nIndex);
+    sal_Bool bPrevAutoStyle((*pRowDefaults)[nRow].bIsAutoStyle);
+    sal_uInt32 i(nRow + 1);
+    sal_Bool bReady(sal_False);
+    while ((i < nEnd) && !bReady && (i < pRowDefaults->size()))
+    {
+        if ((nPrevIndex != (*pRowDefaults)[i].nIndex) ||
+            (bPrevAutoStyle != (*pRowDefaults)[i].bIsAutoStyle))
+            bReady = sal_True;
+        else
+            i += (*pRowDefaults)[i].nRepeat;
+    }
+    if (i > nEnd)
+        i = nEnd;
+    if (bReady)
+        rFormatRange.nRepeatRows = i - nRow + 1;
+    if (nPrevIndex == -1)
+    {
+        nPrevIndex = (*pColDefaults)[rFormatRange.nStartColumn].nIndex;
+        bPrevAutoStyle = (*pColDefaults)[rFormatRange.nStartColumn].bIsAutoStyle;
+        sal_uInt32 nPrevStartCol(rFormatRange.nStartColumn);
+        sal_uInt32 nRepeat((*pColDefaults)[rFormatRange.nStartColumn].nRepeat);
+        nEnd = rFormatRange.nStartColumn + rFormatRange.nRepeatColumns;
+        for(i = nPrevStartCol + nRepeat; i < nEnd; i += (*pColDefaults)[i].nRepeat)
+        {
+            DBG_ASSERT(sal_uInt32(nPrevStartCol + nRepeat) <= nEnd, "something wents wrong");
+            if ((nPrevIndex != (*pColDefaults)[i].nIndex) ||
+                (bPrevAutoStyle != (*pColDefaults)[i].bIsAutoStyle))
+            {
+                AddRange(nPrevStartCol, nRepeat, nPrevIndex, bPrevAutoStyle, rFormatRange);
+                nPrevStartCol = i;
+                nRepeat = (*pColDefaults)[i].nRepeat;
+                nPrevIndex = (*pColDefaults)[i].nIndex;
+                bPrevAutoStyle = (*pColDefaults)[i].bIsAutoStyle;
+            }
+            else
+                nRepeat += (*pColDefaults)[i].nRepeat;
+        }
+        if (sal_uInt32(nPrevStartCol + nRepeat) > nEnd)
+            nRepeat = nEnd - nPrevStartCol;
+        AddRange(nPrevStartCol, nRepeat, nPrevIndex, bPrevAutoStyle, rFormatRange);
+    }
+    else if ((nPrevIndex == rFormatRange.nIndex) &&
+        (bPrevAutoStyle == rFormatRange.bIsAutoStyle))
+    {
+        rFormatRange.nIndex = -1;
+        aRowFormatRanges.push_back(rFormatRange);
+        ++nSize;
+    }
+}
+
+sal_Bool ScRowFormatRanges::GetNext(ScMyRowFormatRange& aFormatRange)
+{
+    ScMyRowFormatRangesList::iterator aItr(aRowFormatRanges.begin());
+    if (aItr != aRowFormatRanges.end())
+    {
+        aFormatRange = (*aItr);
+        aRowFormatRanges.erase(aItr);
+        --nSize;
+        return sal_True;
+    }
+    return sal_False;
+}
+
+sal_Int32 ScRowFormatRanges::GetMaxRows()
+{
+    ScMyRowFormatRangesList::iterator aItr(aRowFormatRanges.begin());
+    ScMyRowFormatRangesList::iterator aEndItr(aRowFormatRanges.end());
+    sal_Int32 nMaxRows = MAXROW + 1;
+    if (aItr != aEndItr)
+        while (aItr != aEndItr)
+        {
+            if ((*aItr).nRepeatRows < nMaxRows)
+                nMaxRows = (*aItr).nRepeatRows;
+            ++aItr;
+        }
+    else
+    {
+        DBG_ERROR("no ranges found");
+    }
+    return nMaxRows;
+}
+
+sal_Int32 ScRowFormatRanges::GetSize()
+{
+    return nSize;
+}
+
+void ScRowFormatRanges::Sort()
+{
+    aRowFormatRanges.sort();
+}
+
+// ============================================================================
+ScMyFormatRange::ScMyFormatRange()
+    : nStyleNameIndex(-1),
+    nValidationIndex(-1),
+    bIsAutoStyle(sal_True)
+{
+}
+
+sal_Bool ScMyFormatRange::operator<(const ScMyFormatRange& rRange) const
+{
+    if (aRangeAddress.StartRow < rRange.aRangeAddress.StartRow)
+        return sal_True;
+    else
+        if (aRangeAddress.StartRow == rRange.aRangeAddress.StartRow)
+            return (aRangeAddress.StartColumn < rRange.aRangeAddress.StartColumn);
+        else
+            return sal_False;
+}
+
+ScFormatRangeStyles::ScFormatRangeStyles()
+    : aTables(),
+    aStyleNames(),
+    aAutoStyleNames()
+{
+}
+
+ScFormatRangeStyles::~ScFormatRangeStyles()
+{
+    ScMyOUStringVec::iterator i(aStyleNames.begin());
+    ScMyOUStringVec::iterator endi(aStyleNames.end());
+    while (i != endi)
+    {
+        delete *i;
+        ++i;
+    }
+    i = aAutoStyleNames.begin();
+    endi = aAutoStyleNames.end();
+    while (i != endi)
+    {
+        delete *i;
+        ++i;
+    }
+    ScMyFormatRangeListVec::iterator j(aTables.begin());
+    ScMyFormatRangeListVec::iterator endj(aTables.end());
+    while (j != endj)
+    {
+        delete *j;
+        ++j;
+    }
+}
+
+void ScFormatRangeStyles::AddNewTable(const sal_Int32 nTable)
+{
+    sal_Int32 nSize = aTables.size() - 1;
+    if (nTable > nSize)
+        for (sal_Int32 i = nSize; i < nTable; ++i)
+        {
+            ScMyFormatRangeAddresses* aRangeAddresses(new ScMyFormatRangeAddresses);
+            aTables.push_back(aRangeAddresses);
+        }
+}
+
+sal_Bool ScFormatRangeStyles::AddStyleName(rtl::OUString* rpString, sal_Int32& rIndex, const sal_Bool bIsAutoStyle)
+{
+    if (bIsAutoStyle)
+    {
+        aAutoStyleNames.push_back(rpString);
+        rIndex = aAutoStyleNames.size() - 1;
+        return sal_True;
+    }
+    else
+    {
+        sal_Int32 nCount(aStyleNames.size());
+        sal_Bool bFound(sal_False);
+        sal_Int32 i(nCount - 1);
+        while ((i >= 0) && (!bFound))
+        {
+            if (aStyleNames.at(i)->equals(*rpString))
+                bFound = sal_True;
+            else
+                i--;
+        }
+        if (bFound)
+        {
+            rIndex = i;
+            return sal_False;
+        }
+        else
+        {
+            aStyleNames.push_back(rpString);
+            rIndex = aStyleNames.size() - 1;
+            return sal_True;
+        }
+    }
+}
+
+sal_Int32 ScFormatRangeStyles::GetIndexOfStyleName(const rtl::OUString& rString, const rtl::OUString& rPrefix, sal_Bool& bIsAutoStyle)
+{
+    sal_Int32 nPrefixLength(rPrefix.getLength());
+    rtl::OUString sTemp(rString.copy(nPrefixLength));
+    sal_Int32 nIndex(sTemp.toInt32());
+    if (aAutoStyleNames.at(nIndex - 1)->equals(rString))
+    {
+        bIsAutoStyle = sal_True;
+        return nIndex - 1;
+    }
+    else
+    {
+        sal_Int32 i(0);
+        sal_Bool bFound(sal_False);
+        while (!bFound && static_cast<size_t>(i) < aStyleNames.size())
+        {
+            if (aStyleNames[i]->equals(rString))
+                bFound = sal_True;
+            else
+                ++i;
+        }
+        if (bFound)
+        {
+            bIsAutoStyle = sal_False;
+            return i;
+        }
+        else
+        {
+            i = 0;
+            while (!bFound && static_cast<size_t>(i) < aAutoStyleNames.size())
+            {
+                if (aAutoStyleNames[i]->equals(rString))
+                    bFound = sal_True;
+                else
+                    ++i;
+            }
+            if (bFound)
+            {
+                bIsAutoStyle = sal_True;
+                return i;
+            }
+            else
+                return -1;
+        }
+    }
+}
+
+sal_Int32 ScFormatRangeStyles::GetStyleNameIndex(const sal_Int32 nTable,
+    const sal_Int32 nColumn, const sal_Int32 nRow, sal_Bool& bIsAutoStyle) const
+{
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    ScMyFormatRangeAddresses* pFormatRanges(aTables[nTable]);
+    ScMyFormatRangeAddresses::iterator aItr(pFormatRanges->begin());
+    ScMyFormatRangeAddresses::iterator aEndItr(pFormatRanges->end());
+    while (aItr != aEndItr)
+    {
+        if (((*aItr).aRangeAddress.StartColumn <= nColumn) &&
+            ((*aItr).aRangeAddress.EndColumn >= nColumn) &&
+            ((*aItr).aRangeAddress.StartRow <= nRow) &&
+            ((*aItr).aRangeAddress.EndRow >= nRow))
+        {
+            bIsAutoStyle = aItr->bIsAutoStyle;
+            return (*aItr).nStyleNameIndex;
+        }
+        else
+            ++aItr;
+    }
+    return -1;
+}
+
+sal_Int32 ScFormatRangeStyles::GetStyleNameIndex(const sal_Int32 nTable, const sal_Int32 nColumn, const sal_Int32 nRow,
+    sal_Bool& bIsAutoStyle, sal_Int32& nValidationIndex, sal_Int32& nNumberFormat, const sal_Bool bRemoveRange)
+{
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    ScMyFormatRangeAddresses* pFormatRanges(aTables[nTable]);
+    ScMyFormatRangeAddresses::iterator aItr(pFormatRanges->begin());
+    ScMyFormatRangeAddresses::iterator aEndItr(pFormatRanges->end());
+    while (aItr != aEndItr)
+    {
+        if (((*aItr).aRangeAddress.StartColumn <= nColumn) &&
+            ((*aItr).aRangeAddress.EndColumn >= nColumn) &&
+            ((*aItr).aRangeAddress.StartRow <= nRow) &&
+            ((*aItr).aRangeAddress.EndRow >= nRow))
+        {
+            bIsAutoStyle = aItr->bIsAutoStyle;
+            nValidationIndex = aItr->nValidationIndex;
+            nNumberFormat = aItr->nNumberFormat;
+            if (((*pRowDefaults)[nRow].nIndex != -1))
+            {
+                if (((*pRowDefaults)[nRow].nIndex == (*aItr).nStyleNameIndex) &&
+                    ((*pRowDefaults)[nRow].bIsAutoStyle == (*aItr).bIsAutoStyle))
+                    return -1;
+                else
+                    return (*aItr).nStyleNameIndex;
+            }
+            else if (((*pColDefaults)[nColumn].nIndex != -1) &&
+                ((*pColDefaults)[nColumn].nIndex == (*aItr).nStyleNameIndex) &&
+                ((*pColDefaults)[nColumn].bIsAutoStyle == (*aItr).bIsAutoStyle))
+                return -1;
+            else
+                return (*aItr).nStyleNameIndex;
+        }
+        else
+        {
+            if (bRemoveRange && (*aItr).aRangeAddress.EndRow < nRow)
+                aItr = pFormatRanges->erase(aItr);
+            else
+                ++aItr;
+        }
+    }
+    return -1;
+}
+
+void ScFormatRangeStyles::GetFormatRanges(const sal_Int32 nStartColumn, const sal_Int32 nEndColumn, const sal_Int32 nRow,
+                    const sal_Int32 nTable, ScRowFormatRanges* pRowFormatRanges)
+{
+    sal_Int32 nTotalColumns(nEndColumn - nStartColumn + 1);
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    ScMyFormatRangeAddresses* pFormatRanges(aTables[nTable]);
+    ScMyFormatRangeAddresses::iterator aItr(pFormatRanges->begin());
+    ScMyFormatRangeAddresses::iterator aEndItr(pFormatRanges->end());
+    sal_Int32 nColumns = 0;
+    while (aItr != aEndItr && nColumns < nTotalColumns)
+    {
+#if OSL_DEBUG_LEVEL > 1
+        table::CellRangeAddress aTempRangeAddress((*aItr).aRangeAddress);
+#endif
+        if (((*aItr).aRangeAddress.StartRow <= nRow) &&
+            ((*aItr).aRangeAddress.EndRow >= nRow))
+        {
+            if ((((*aItr).aRangeAddress.StartColumn <= nStartColumn) &&
+                ((*aItr).aRangeAddress.EndColumn >= nStartColumn)) ||
+                (((*aItr).aRangeAddress.StartColumn <= nEndColumn) &&
+                ((*aItr).aRangeAddress.EndColumn >= nEndColumn)) ||
+                (((*aItr).aRangeAddress.StartColumn >= nStartColumn) &&
+                ((*aItr).aRangeAddress.EndColumn <= nEndColumn)))
+            {
+                ScMyRowFormatRange aRange;
+                aRange.nIndex = aItr->nStyleNameIndex;
+                aRange.nValidationIndex = aItr->nValidationIndex;
+                aRange.bIsAutoStyle = aItr->bIsAutoStyle;
+                if ((aItr->aRangeAddress.StartColumn < nStartColumn) &&
+                    (aItr->aRangeAddress.EndColumn >= nStartColumn))
+                {
+                    if (aItr->aRangeAddress.EndColumn >= nEndColumn)
+                        aRange.nRepeatColumns = nTotalColumns;
+                    else
+                        aRange.nRepeatColumns = aItr->aRangeAddress.EndColumn - nStartColumn + 1;
+                    aRange.nStartColumn = nStartColumn;
+                }
+                else if ((aItr->aRangeAddress.StartColumn >= nStartColumn) &&
+                    (aItr->aRangeAddress.EndColumn <= nEndColumn))
+                {
+                    aRange.nRepeatColumns = aItr->aRangeAddress.EndColumn - aItr->aRangeAddress.StartColumn + 1;
+                    aRange.nStartColumn = aItr->aRangeAddress.StartColumn;
+                }
+                else if ((aItr->aRangeAddress.StartColumn >= nStartColumn) &&
+                    (aItr->aRangeAddress.StartColumn <= nEndColumn) &&
+                    (aItr->aRangeAddress.EndColumn > nEndColumn))
+                {
+                    aRange.nRepeatColumns = nEndColumn - aItr->aRangeAddress.StartColumn + 1;
+                    aRange.nStartColumn = aItr->aRangeAddress.StartColumn;
+                }
+                aRange.nRepeatRows = aItr->aRangeAddress.EndRow - nRow + 1;
+                pRowFormatRanges->AddRange(aRange, nRow);
+                nColumns += aRange.nRepeatColumns;
+            }
+            ++aItr;
+        }
+        else
+            if(aItr->aRangeAddress.EndRow < nRow)
+                aItr = pFormatRanges->erase(aItr);
+            else
+                ++aItr;
+    }
+    pRowFormatRanges->Sort();
+}
+
+void ScFormatRangeStyles::AddRangeStyleName(const table::CellRangeAddress aCellRangeAddress,
+    const sal_Int32 nStringIndex, const sal_Bool bIsAutoStyle, const sal_Int32 nValidationIndex,
+    const sal_Int32 nNumberFormat)
+{
+    ScMyFormatRange aFormatRange;
+    aFormatRange.aRangeAddress = aCellRangeAddress;
+    aFormatRange.nStyleNameIndex = nStringIndex;
+    aFormatRange.nValidationIndex = nValidationIndex;
+    aFormatRange.nNumberFormat = nNumberFormat;
+    aFormatRange.bIsAutoStyle = bIsAutoStyle;
+    DBG_ASSERT(static_cast<size_t>(aCellRangeAddress.Sheet) < aTables.size(), "wrong table");
+    ScMyFormatRangeAddresses* pFormatRanges(aTables[aCellRangeAddress.Sheet]);
+    pFormatRanges->push_back(aFormatRange);
+}
+
+rtl::OUString* ScFormatRangeStyles::GetStyleNameByIndex(const sal_Int32 nIndex, const sal_Bool bIsAutoStyle)
+{
+    if (bIsAutoStyle)
+        return aAutoStyleNames[nIndex];
+    else
+        return aStyleNames[nIndex];
+}
+
+void ScFormatRangeStyles::Sort()
+{
+    sal_Int32 nTables = aTables.size();
+    for (sal_Int16 i = 0; i < nTables; ++i)
+        if (!aTables[i]->empty())
+            aTables[i]->sort();
+}
+
+//===========================================================================
+
+ScColumnRowStylesBase::ScColumnRowStylesBase()
+    : aStyleNames()
+{
+}
+
+ScColumnRowStylesBase::~ScColumnRowStylesBase()
+{
+    ScMyOUStringVec::iterator i(aStyleNames.begin());
+    ScMyOUStringVec::iterator endi(aStyleNames.end());
+    while (i != endi)
+    {
+        delete *i;
+        ++i;
+    }
+}
+
+sal_Int32 ScColumnRowStylesBase::AddStyleName(rtl::OUString* pString)
+{
+    aStyleNames.push_back(pString);
+    return aStyleNames.size() - 1;
+}
+
+sal_Int32 ScColumnRowStylesBase::GetIndexOfStyleName(const rtl::OUString& rString, const rtl::OUString& rPrefix)
+{
+    sal_Int32 nPrefixLength(rPrefix.getLength());
+    rtl::OUString sTemp(rString.copy(nPrefixLength));
+    sal_Int32 nIndex(sTemp.toInt32());
+    if (aStyleNames.at(nIndex - 1)->equals(rString))
+        return nIndex - 1;
+    else
+    {
+        sal_Int32 i(0);
+        sal_Bool bFound(sal_False);
+        while (!bFound && static_cast<size_t>(i) < aStyleNames.size())
+        {
+            if (aStyleNames.at(i)->equals(rString))
+                bFound = sal_True;
+            else
+                ++i;
+        }
+        if (bFound)
+            return i;
+        else
+            return -1;
+    }
+}
+
+rtl::OUString* ScColumnRowStylesBase::GetStyleNameByIndex(const sal_Int32 nIndex)
+{
+    if ( nIndex < 0 || nIndex >= sal::static_int_cast<sal_Int32>( aStyleNames.size() ) )
+    {
+        // #123981# should no longer happen, use first style then
+        DBG_ERRORFILE("GetStyleNameByIndex: invalid index");
+        return aStyleNames[0];
+    }
+
+    return aStyleNames[nIndex];
+}
+
+//===========================================================================
+
+ScColumnStyles::ScColumnStyles()
+    : ScColumnRowStylesBase(),
+    aTables()
+{
+}
+
+ScColumnStyles::~ScColumnStyles()
+{
+}
+
+void ScColumnStyles::AddNewTable(const sal_Int32 nTable, const sal_Int32 nFields)
+{
+    sal_Int32 nSize(aTables.size() - 1);
+    if (nTable > nSize)
+        for (sal_Int32 i = nSize; i < nTable; ++i)
+        {
+            ScMyColumnStyleVec aFieldsVec(nFields + 1, ScColumnStyle());
+            aTables.push_back(aFieldsVec);
+        }
+}
+
+sal_Int32 ScColumnStyles::GetStyleNameIndex(const sal_Int32 nTable, const sal_Int32 nField,
+    sal_Bool& bIsVisible)
+{
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    if (static_cast<size_t>(nField) < aTables[nTable].size())
+    {
+        bIsVisible = aTables[nTable][nField].bIsVisible;
+        return aTables[nTable][nField].nIndex;
+    }
+    else
+    {
+        bIsVisible = aTables[nTable][aTables[nTable].size() - 1].bIsVisible;
+        return aTables[nTable][aTables[nTable].size() - 1].nIndex;
+    }
+}
+
+void ScColumnStyles::AddFieldStyleName(const sal_Int32 nTable, const sal_Int32 nField,
+    const sal_Int32 nStringIndex, const sal_Bool bIsVisible)
+{
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    DBG_ASSERT(aTables[nTable].size() >= static_cast<sal_uInt32>(nField), "wrong field");
+    ScColumnStyle aStyle;
+    aStyle.nIndex = nStringIndex;
+    aStyle.bIsVisible = bIsVisible;
+    if (aTables[nTable].size() == static_cast<sal_uInt32>(nField))
+        aTables[nTable].push_back(aStyle);
+    aTables[nTable][nField] = aStyle;
+}
+
+rtl::OUString* ScColumnStyles::GetStyleName(const sal_Int32 nTable, const sal_Int32 nField)
+{
+    sal_Bool bTemp;
+    return GetStyleNameByIndex(GetStyleNameIndex(nTable, nField, bTemp));
+}
+
+//===========================================================================
+
+ScRowStyles::ScRowStyles()
+    : ScColumnRowStylesBase(),
+    aTables()
+{
+}
+
+ScRowStyles::~ScRowStyles()
+{
+}
+
+void ScRowStyles::AddNewTable(const sal_Int32 nTable, const sal_Int32 nFields)
+{
+    sal_Int32 nSize(aTables.size() - 1);
+    if (nTable > nSize)
+        for (sal_Int32 i = nSize; i < nTable; ++i)
+        {
+            ScMysalInt32Vec aFieldsVec(nFields + 1, -1);
+            aTables.push_back(aFieldsVec);
+        }
+}
+
+sal_Int32 ScRowStyles::GetStyleNameIndex(const sal_Int32 nTable, const sal_Int32 nField)
+{
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    if (static_cast<size_t>(nField) < aTables[nTable].size())
+        return aTables[nTable][nField];
+    else
+        return aTables[nTable][aTables[nTable].size() - 1];
+}
+
+void ScRowStyles::AddFieldStyleName(const sal_Int32 nTable, const sal_Int32 nField,
+    const sal_Int32 nStringIndex)
+{
+    DBG_ASSERT(static_cast<size_t>(nTable) < aTables.size(), "wrong table");
+    DBG_ASSERT(aTables[nTable].size() >= static_cast<sal_uInt32>(nField), "wrong field");
+    if (aTables[nTable].size() == static_cast<sal_uInt32>(nField))
+        aTables[nTable].push_back(nStringIndex);
+    aTables[nTable][nField] = nStringIndex;
+}
+
+rtl::OUString* ScRowStyles::GetStyleName(const sal_Int32 nTable, const sal_Int32 nField)
+{
+    return GetStyleNameByIndex(GetStyleNameIndex(nTable, nField));
+}
diff --git a/sc/source/filter/xml/xmlcvali.cxx b/sc/source/filter/xml/xmlcvali.cxx
index 0d78a79a5eea..d8d8eb0d7cc2 100644
--- a/sc/source/filter/xml/xmlcvali.cxx
+++ b/sc/source/filter/xml/xmlcvali.cxx
@@ -1,788 +1,788 @@
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
- * Copyright 2008 by Sun Microsystems, Inc.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * $RCSfile: xmlcvali.cxx,v $
- * $Revision: 1.27 $
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org 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 version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-// MARKER(update_precomp.py): autogen include statement, do not remove
-#include "precompiled_sc.hxx"
-
-
-
-// INCLUDE ---------------------------------------------------------------
-
-#include "xmlcvali.hxx"
-#include "xmlimprt.hxx"
-#include "xmlconti.hxx"
-#include "document.hxx"
-#include "XMLConverter.hxx"
-
-#include <xmloff/xmltkmap.hxx>
-#include <xmloff/nmspmap.hxx>
-#include <xmloff/xmltoken.hxx>
-#include <xmloff/xmlnmspe.hxx>
-#include <xmloff/XMLEventsImportContext.hxx>
-#include <com/sun/star/sheet/TableValidationVisibility.hpp>
-#include <tools/debug.hxx>
-
-using namespace com::sun::star;
-using namespace xmloff::token;
-
-class ScXMLContentValidationContext : public SvXMLImportContext
-{
-    rtl::OUString      sName;
-    rtl::OUString      sHelpTitle;
-    rtl::OUString      sHelpMessage;
-    rtl::OUString      sErrorTitle;
-    rtl::OUString      sErrorMessage;
-    rtl::OUString      sErrorMessageType;
-    rtl::OUString      sBaseCellAddress;
-    rtl::OUString      sCondition;
-    formula::FormulaGrammar::Grammar eGrammar;
-    sal_Int16          nShowList;
-    sal_Bool           bAllowEmptyCell;
-    sal_Bool           bDisplayHelp;
-    sal_Bool           bDisplayError;
-
-    SvXMLImportContextRef           xEventContext;
-
-    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
-    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
-
-    void GetAlertStyle(const rtl::OUString& sMessageType, com::sun::star::sheet::ValidationAlertStyle& aAlertStyle);
-    void SetFormulas(const rtl::OUString& sFormulas, rtl::OUString& sFormula1, rtl::OUString& sFormula2) const;
-    void GetCondition(const rtl::OUString& sCondition, rtl::OUString& sFormula1, rtl::OUString& sFormula2,
-        com::sun::star::sheet::ValidationType& aValidationType,
-        com::sun::star::sheet::ConditionOperator& aOperator);
-
-public:
-
-    ScXMLContentValidationContext( ScXMLImport& rImport, USHORT nPrfx,
-                        const ::rtl::OUString& rLName,
-                        const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList);
-
-    virtual ~ScXMLContentValidationContext();
-
-    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
-                                     const ::rtl::OUString& rLocalName,
-                                     const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
-
-    virtual void EndElement();
-
-    void SetHelpMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage, const sal_Bool bDisplay);
-    void SetErrorMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage, const rtl::OUString& sMessageType, const sal_Bool bDisplay);
-    void SetErrorMacro(const sal_Bool bExecute);
-};
-
-class ScXMLHelpMessageContext : public SvXMLImportContext
-{
-    rtl::OUString   sTitle;
-    rtl::OUStringBuffer sMessage;
-    sal_Int32       nParagraphCount;
-    sal_Bool        bDisplay;
-
-    ScXMLContentValidationContext* pValidationContext;
-
-    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
-    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
-
-public:
-
-    ScXMLHelpMessageContext( ScXMLImport& rImport, USHORT nPrfx,
-                        const ::rtl::OUString& rLName,
-                        const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
-                        ScXMLContentValidationContext* pValidationContext);
-
-    virtual ~ScXMLHelpMessageContext();
-
-    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
-                                     const ::rtl::OUString& rLocalName,
-                                     const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
-
-    virtual void EndElement();
-};
-
-class ScXMLErrorMessageContext : public SvXMLImportContext
-{
-    rtl::OUString   sTitle;
-    rtl::OUStringBuffer sMessage;
-    rtl::OUString   sMessageType;
-    sal_Int32       nParagraphCount;
-    sal_Bool        bDisplay;
-
-    ScXMLContentValidationContext* pValidationContext;
-
-    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
-    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
-
-public:
-
-    ScXMLErrorMessageContext( ScXMLImport& rImport, USHORT nPrfx,
-                        const ::rtl::OUString& rLName,
-                        const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
-                        ScXMLContentValidationContext* pValidationContext);
-
-    virtual ~ScXMLErrorMessageContext();
-
-    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
-                                     const ::rtl::OUString& rLocalName,
-                                     const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
-
-    virtual void EndElement();
-};
-
-class ScXMLErrorMacroContext : public SvXMLImportContext
-{
-    rtl::OUString   sName;
-    sal_Bool        bExecute;
-
-    ScXMLContentValidationContext*  pValidationContext;
-
-    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
-    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
-
-public:
-
-    ScXMLErrorMacroContext( ScXMLImport& rImport, USHORT nPrfx,
-                        const ::rtl::OUString& rLName,
-                        const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
-                        ScXMLContentValidationContext* pValidationContext);
-
-    virtual ~ScXMLErrorMacroContext();
-
-    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
-                                     const ::rtl::OUString& rLocalName,
-                                     const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
-    virtual void EndElement();
-};
-
-//------------------------------------------------------------------
-
-ScXMLContentValidationsContext::ScXMLContentValidationsContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ ) :
-    SvXMLImportContext( rImport, nPrfx, rLName )
-{
-    // here are no attributes
-}
-
-ScXMLContentValidationsContext::~ScXMLContentValidationsContext()
-{
-}
-
-SvXMLImportContext *ScXMLContentValidationsContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
-{
-    SvXMLImportContext *pContext = 0;
-
-    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationsElemTokenMap();
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-        case XML_TOK_CONTENT_VALIDATION:
-            pContext = new ScXMLContentValidationContext( GetScImport(), nPrefix, rLName, xAttrList);
-        break;
-    }
-
-    if( !pContext )
-        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
-
-    return pContext;
-}
-
-void ScXMLContentValidationsContext::EndElement()
-{
-}
-
-ScXMLContentValidationContext::ScXMLContentValidationContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList) :
-    SvXMLImportContext( rImport, nPrfx, rLName ),
-    sName(),
-    sHelpTitle(),
-    sHelpMessage(),
-    sErrorTitle(),
-    sErrorMessage(),
-    sErrorMessageType(),
-    sBaseCellAddress(),
-    sCondition(),
-    nShowList(sheet::TableValidationVisibility::UNSORTED),
-    bAllowEmptyCell(sal_True),
-    bDisplayHelp(sal_False),
-    bDisplayError(sal_False)
-{
-    const formula::FormulaGrammar::Grammar eStorageGrammar = eGrammar = GetScImport().GetDocument()->GetStorageGrammar();
-    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
-    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationAttrTokenMap();
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName );
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-            case XML_TOK_CONTENT_VALIDATION_NAME:
-                sName = sValue;
-            break;
-            case XML_TOK_CONTENT_VALIDATION_CONDITION:
-                {
-                    sal_uInt16 nCondPrefix = GetImport().GetNamespaceMap().
-                            _GetKeyByAttrName( sValue, &sCondition, sal_False );
-
-                    if (!ScXMLImport::IsAcceptedFormulaNamespace( nCondPrefix,
-                                sValue, eGrammar, eStorageGrammar))
-                        sCondition = sValue;
-                }
-            break;
-            case XML_TOK_CONTENT_VALIDATION_BASE_CELL_ADDRESS:
-                sBaseCellAddress = sValue;
-            break;
-            case XML_TOK_CONTENT_VALIDATION_ALLOW_EMPTY_CELL:
-                if (IsXMLToken(sValue, XML_FALSE))
-                    bAllowEmptyCell = sal_False;
-            break;
-            case XML_TOK_CONTENT_VALIDATION_DISPLAY_LIST:
-            {
-                if (IsXMLToken(sValue, XML_NO))
-                {
-                    nShowList = sheet::TableValidationVisibility::INVISIBLE;
-                }
-                else if (IsXMLToken(sValue, XML_UNSORTED))
-                {
-                    nShowList = sheet::TableValidationVisibility::UNSORTED;
-                }
-                else if (IsXMLToken(sValue, XML_SORTED_ASCENDING))
-                {
-                    nShowList = sheet::TableValidationVisibility::SORTEDASCENDING;
-                }
-            }
-            break;
-        }
-    }
-}
-
-ScXMLContentValidationContext::~ScXMLContentValidationContext()
-{
-}
-
-SvXMLImportContext *ScXMLContentValidationContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
-{
-    SvXMLImportContext *pContext = 0;
-
-    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationElemTokenMap();
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-        case XML_TOK_CONTENT_VALIDATION_ELEM_HELP_MESSAGE:
-            pContext = new ScXMLHelpMessageContext( GetScImport(), nPrefix, rLName, xAttrList, this);
-        break;
-        case XML_TOK_CONTENT_VALIDATION_ELEM_ERROR_MESSAGE:
-            pContext = new ScXMLErrorMessageContext( GetScImport(), nPrefix, rLName, xAttrList, this);
-        break;
-        case XML_TOK_CONTENT_VALIDATION_ELEM_ERROR_MACRO:
-            pContext = new ScXMLErrorMacroContext( GetScImport(), nPrefix, rLName, xAttrList, this);
-        break;
-        case XML_TOK_CONTENT_VALIDATION_ELEM_EVENT_LISTENERS:
-            pContext = new XMLEventsImportContext( GetImport(), nPrefix, rLName );
-            xEventContext = pContext;
-        break;
-    }
-
-    if( !pContext )
-        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
-
-    return pContext;
-}
-
-void ScXMLContentValidationContext::GetAlertStyle(const rtl::OUString& sMessageType, com::sun::star::sheet::ValidationAlertStyle& aAlertStyle)
-{
-    if (IsXMLToken(sMessageType, XML_MACRO))
-        aAlertStyle = sheet::ValidationAlertStyle_MACRO;
-    else if (IsXMLToken(sMessageType, XML_STOP))
-        aAlertStyle = sheet::ValidationAlertStyle_STOP;
-    else if (IsXMLToken(sMessageType, XML_WARNING))
-        aAlertStyle = sheet::ValidationAlertStyle_WARNING;
-    else if (IsXMLToken(sMessageType, XML_INFORMATION))
-        aAlertStyle = sheet::ValidationAlertStyle_INFO;
-    else    // don't leave uninitialized
-        aAlertStyle = sheet::ValidationAlertStyle_STOP;
-}
-
-void ScXMLContentValidationContext::SetFormulas(const rtl::OUString& sFormulas, rtl::OUString& sFormula1, rtl::OUString& sFormula2) const
-{
-    sal_Int32 i = 0;
-    sal_Bool bString = sal_False;
-    sal_Int32 nBrakes = 0;
-    while ((sFormulas[i] != ',' || nBrakes > 0 || bString) && i < sFormulas.getLength())
-    {
-        if (sFormulas[i] == '(')
-            ++nBrakes;
-        if (sFormulas[i] == ')')
-            --nBrakes;
-        if (sFormulas[i] == '"')
-            bString = !bString;
-        ++i;
-    }
-    if (sFormulas[i] == ',')
-    {
-        sFormula1 = sFormulas.copy(0, i);
-        sFormula2 = sFormulas.copy(i + 1);
-    }
-}
-
-void ScXMLContentValidationContext::GetCondition(const rtl::OUString& sTempCondition, rtl::OUString& sFormula1, rtl::OUString& sFormula2,
-        com::sun::star::sheet::ValidationType& aValidationType,
-        com::sun::star::sheet::ConditionOperator& aOperator)
-{
-    aValidationType = sheet::ValidationType_ANY;    // #b6343997# default if no condition is given
-    aOperator = sheet::ConditionOperator_NONE;
-
-    rtl::OUString sLocalCondition(sTempCondition);
-    if (sLocalCondition.getLength())
-    {
-        // ToDo: erase all blanks in the condition, but not in formulas or strings
-        rtl::OUString scell_content(RTL_CONSTASCII_USTRINGPARAM("cell_content"));
-        rtl::OUString scell_content_is_date(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-date"));
-        rtl::OUString scell_content_is_time(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-time"));
-        rtl::OUString scell_content_is_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-between"));
-        rtl::OUString scell_content_is_in_list(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-in-list"));
-        rtl::OUString scell_content_text_length(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length"));
-        rtl::OUString scell_content_is_not_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-not-between"));
-        rtl::OUString scell_content_is_whole_number(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-whole-number"));
-        rtl::OUString scell_content_is_decimal_number(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-decimal-number"));
-        rtl::OUString scell_content_text_length_is_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-between"));
-        rtl::OUString scell_content_text_length_is_not_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-not-between"));
-        sal_Int32 i = 0;
-        sal_Bool bAnd(sal_True);
-        while (sLocalCondition[i] != '(' && i < sLocalCondition.getLength())
-            ++i;
-        if (sLocalCondition[i] == '(')
-        {
-            if (i != scell_content_text_length.getLength() &&
-                i != scell_content_text_length_is_between.getLength() &&
-                i != scell_content_text_length_is_not_between.getLength() &&
-                i != scell_content_is_in_list.getLength())
-            {
-                if (i == scell_content_is_time.getLength())
-                {
-                    rtl::OUString sTemp = sLocalCondition.copy(0, i);
-                    if (sTemp == scell_content_is_time)
-                        aValidationType = sheet::ValidationType_TIME;
-                    else
-                        aValidationType = sheet::ValidationType_DATE;
-                }
-                else if (i == scell_content_is_whole_number.getLength())
-                    aValidationType = sheet::ValidationType_WHOLE;
-                else if (i == scell_content_is_decimal_number.getLength())
-                    aValidationType = sheet::ValidationType_DECIMAL;
-                sLocalCondition = sLocalCondition.copy(i + 2);
-                rtl::OUString sTemp = sLocalCondition.copy(0, 5);
-                if (sTemp.compareToAscii(" and ") == 0)
-                    sLocalCondition = sLocalCondition.copy(5);
-                else
-                    bAnd = sal_False;
-            }
-            if (sLocalCondition.getLength() && bAnd)
-            {
-                i = 0;
-                while (sLocalCondition[i] != '(' && i < sLocalCondition.getLength())
-                    ++i;
-                if (sLocalCondition[i] == '(')
-                {
-                    rtl::OUString sTemp = sLocalCondition.copy(0, i);
-                    sLocalCondition = sLocalCondition.copy(i + 1);
-                    if (i == scell_content_is_between.getLength() ||
-                        i == scell_content_text_length_is_between.getLength())
-                    {
-                        if (sTemp == scell_content_is_in_list)
-                        {
-                            aValidationType = sheet::ValidationType_LIST;
-                            sFormula1 = sLocalCondition.copy(0, sLocalCondition.getLength() - 1);
-                            aOperator = sheet::ConditionOperator_EQUAL;
-                        }
-                        else
-                        {
-                            if (i == scell_content_text_length_is_between.getLength())
-                                aValidationType = sheet::ValidationType_TEXT_LEN;
-                            aOperator = sheet::ConditionOperator_BETWEEN;
-                            sLocalCondition = sLocalCondition.copy(0, sLocalCondition.getLength() - 1);
-                            SetFormulas(sLocalCondition, sFormula1, sFormula2);
-                        }
-                    }
-                    else if (i == scell_content_is_not_between.getLength() ||
-                        i == scell_content_text_length_is_not_between.getLength())
-                    {
-                        if (i == scell_content_text_length_is_not_between.getLength())
-                            aValidationType = sheet::ValidationType_TEXT_LEN;
-                        aOperator = sheet::ConditionOperator_NOT_BETWEEN;
-                        sLocalCondition = sLocalCondition.copy(0, sLocalCondition.getLength() - 1);
-                        SetFormulas(sLocalCondition, sFormula1, sFormula2);
-                    }
-                    else if (i == scell_content.getLength() ||
-                        i == scell_content_text_length.getLength())
-                    {
-                        if (i == scell_content_text_length.getLength())
-                            aValidationType = sheet::ValidationType_TEXT_LEN;
-                        sLocalCondition = sLocalCondition.copy(1);
-                        switch (sLocalCondition[0])
-                        {
-                            case '<' :
-                            {
-                                if (sLocalCondition[1] == '=')
-                                {
-                                    aOperator = sheet::ConditionOperator_LESS_EQUAL;
-                                    sLocalCondition = sLocalCondition.copy(2);
-                                }
-                                else
-                                {
-                                    aOperator = sheet::ConditionOperator_LESS;
-                                    sLocalCondition = sLocalCondition.copy(1);
-                                }
-                            }
-                            break;
-                            case '>' :
-                            {
-                                if (sLocalCondition[1] == '=')
-                                {
-                                    aOperator = sheet::ConditionOperator_GREATER_EQUAL;
-                                    sLocalCondition = sLocalCondition.copy(2);
-                                }
-                                else
-                                {
-                                    aOperator = sheet::ConditionOperator_GREATER;
-                                    sLocalCondition = sLocalCondition.copy(1);
-                                }
-                            }
-                            break;
-                            case '=' :
-                            {
-                                aOperator = sheet::ConditionOperator_EQUAL;
-                                sLocalCondition = sLocalCondition.copy(1);
-                            }
-                            break;
-                            case '!' :
-                            {
-                                aOperator = sheet::ConditionOperator_NOT_EQUAL;
-                                sLocalCondition = sLocalCondition.copy(1);
-                            }
-                            break;
-                        }
-                        sFormula1 = sLocalCondition;
-                    }
-                }
-            }
-        }
-    }
-
-    // a validation type (date, integer) without a condition isn't possible
-    if ( aOperator == sheet::ConditionOperator_NONE )
-        aValidationType = sheet::ValidationType_ANY;
-}
-
-void ScXMLContentValidationContext::EndElement()
-{
-    // #i36650# event-listeners element moved up one level
-    if (xEventContext.Is())
-    {
-        rtl::OUString sOnError(RTL_CONSTASCII_USTRINGPARAM("OnError"));
-        XMLEventsImportContext* pEvents =
-            (XMLEventsImportContext*)&xEventContext;
-        uno::Sequence<beans::PropertyValue> aValues;
-        pEvents->GetEventSequence( sOnError, aValues );
-
-        sal_Int32 nLength = aValues.getLength();
-        for( sal_Int32 i = 0; i < nLength; i++ )
-        {
-            // #i47525# must allow "MacroName" or "Script"
-            if ( aValues[i].Name.equalsAsciiL( "MacroName", sizeof("MacroName")-1 ) ||
-                 aValues[i].Name.equalsAsciiL( "Script", sizeof("Script")-1 ) )
-            {
-                aValues[i].Value >>= sErrorTitle;
-                break;
-            }
-        }
-    }
-
-    ScMyImportValidation aValidation;
-    aValidation.eGrammar = eGrammar;
-    aValidation.sName = sName;
-    aValidation.sBaseCellAddress = sBaseCellAddress;
-    aValidation.sImputTitle = sHelpTitle;
-    aValidation.sImputMessage = sHelpMessage;
-    aValidation.sErrorTitle = sErrorTitle;
-    aValidation.sErrorMessage = sErrorMessage;
-    GetCondition(sCondition, aValidation.sFormula1, aValidation.sFormula2, aValidation.aValidationType, aValidation.aOperator);
-    GetAlertStyle(sErrorMessageType, aValidation.aAlertStyle);
-    aValidation.bShowErrorMessage = bDisplayError;
-    aValidation.bShowImputMessage = bDisplayHelp;
-    aValidation.bIgnoreBlanks = bAllowEmptyCell;
-    aValidation.nShowList = nShowList;
-    GetScImport().AddValidation(aValidation);
-}
-
-void ScXMLContentValidationContext::SetHelpMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage, const sal_Bool bDisplay)
-{
-    sHelpTitle = sTitle;
-    sHelpMessage = sMessage;
-    bDisplayHelp = bDisplay;
-}
-
-void ScXMLContentValidationContext::SetErrorMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage,
-    const rtl::OUString& sMessageType, const sal_Bool bDisplay)
-{
-    sErrorTitle = sTitle;
-    sErrorMessage = sMessage;
-    sErrorMessageType = sMessageType;
-    bDisplayError = bDisplay;
-}
-
-void ScXMLContentValidationContext::SetErrorMacro(const sal_Bool bExecute)
-{
-    sErrorMessageType = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("macro"));
-    bDisplayError = bExecute;
-}
-
-ScXMLHelpMessageContext::ScXMLHelpMessageContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
-                                      ScXMLContentValidationContext* pTempValidationContext) :
-    SvXMLImportContext( rImport, nPrfx, rLName ),
-    sTitle(),
-    sMessage(),
-    nParagraphCount(0),
-    bDisplay(sal_False)
-{
-    pValidationContext = pTempValidationContext;
-    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
-    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationHelpMessageAttrTokenMap();
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName );
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-            case XML_TOK_HELP_MESSAGE_ATTR_TITLE:
-                sTitle = sValue;
-            break;
-            case XML_TOK_HELP_MESSAGE_ATTR_DISPLAY:
-                bDisplay = IsXMLToken(sValue, XML_TRUE);
-            break;
-        }
-    }
-}
-
-ScXMLHelpMessageContext::~ScXMLHelpMessageContext()
-{
-}
-
-SvXMLImportContext *ScXMLHelpMessageContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
-{
-    SvXMLImportContext *pContext = 0;
-
-    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationMessageElemTokenMap();
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-        case XML_TOK_P:
-        {
-            if(nParagraphCount)
-                sMessage.append(static_cast<sal_Unicode>('\n'));
-            ++nParagraphCount;
-            pContext = new ScXMLContentContext( GetScImport(), nPrefix, rLName, xAttrList, sMessage);
-        }
-        break;
-    }
-
-    if( !pContext )
-        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
-
-    return pContext;
-}
-
-void ScXMLHelpMessageContext::EndElement()
-{
-    pValidationContext->SetHelpMessage(sTitle, sMessage.makeStringAndClear(), bDisplay);
-}
-
-ScXMLErrorMessageContext::ScXMLErrorMessageContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
-                                      ScXMLContentValidationContext* pTempValidationContext) :
-    SvXMLImportContext( rImport, nPrfx, rLName ),
-    sTitle(),
-    sMessage(),
-    sMessageType(),
-    nParagraphCount(0),
-    bDisplay(sal_False)
-{
-    pValidationContext = pTempValidationContext;
-    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
-    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationErrorMessageAttrTokenMap();
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName );
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-            case XML_TOK_ERROR_MESSAGE_ATTR_TITLE:
-                sTitle = sValue;
-            break;
-            case XML_TOK_ERROR_MESSAGE_ATTR_MESSAGE_TYPE:
-                sMessageType = sValue;
-            break;
-            case XML_TOK_ERROR_MESSAGE_ATTR_DISPLAY:
-                bDisplay = IsXMLToken(sValue, XML_TRUE);
-            break;
-        }
-    }
-}
-
-ScXMLErrorMessageContext::~ScXMLErrorMessageContext()
-{
-}
-
-SvXMLImportContext *ScXMLErrorMessageContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
-{
-    SvXMLImportContext *pContext = 0;
-
-    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationMessageElemTokenMap();
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-        case XML_TOK_P:
-        {
-            if(nParagraphCount)
-                sMessage.append(static_cast<sal_Unicode>('\n'));
-            ++nParagraphCount;
-            pContext = new ScXMLContentContext( GetScImport(), nPrefix, rLName, xAttrList, sMessage);
-        }
-        break;
-    }
-
-    if( !pContext )
-        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
-
-    return pContext;
-}
-
-void ScXMLErrorMessageContext::EndElement()
-{
-    pValidationContext->SetErrorMessage(sTitle, sMessage.makeStringAndClear(), sMessageType, bDisplay);
-}
-
-ScXMLErrorMacroContext::ScXMLErrorMacroContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
-                                      ScXMLContentValidationContext* pTempValidationContext) :
-    SvXMLImportContext( rImport, nPrfx, rLName ),
-    sName(),
-    bExecute(sal_False)
-{
-    pValidationContext = pTempValidationContext;
-    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
-    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationErrorMacroAttrTokenMap();
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName );
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-            case XML_TOK_ERROR_MACRO_ATTR_NAME:
-                sName = sValue;
-            break;
-            case XML_TOK_ERROR_MACRO_ATTR_EXECUTE:
-                bExecute = IsXMLToken(sValue, XML_TRUE);
-            break;
-        }
-    }
-}
-
-ScXMLErrorMacroContext::~ScXMLErrorMacroContext()
-{
-}
-
-SvXMLImportContext *ScXMLErrorMacroContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ )
-{
-    SvXMLImportContext *pContext = NULL;
-
-    if ((nPrefix == XML_NAMESPACE_SCRIPT) && IsXMLToken(rLName, XML_EVENTS))
-    {
-        pContext = new XMLEventsImportContext(GetImport(), nPrefix, rLName);
-    }
-    if (!pContext)
-        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
-
-    return pContext;
-}
-
-void ScXMLErrorMacroContext::EndElement()
-{
-    pValidationContext->SetErrorMacro( bExecute );
-}
+/*************************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2008 by Sun Microsystems, Inc.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * $RCSfile: xmlcvali.cxx,v $
+ * $Revision: 1.27 $
+ *
+ * This file is part of OpenOffice.org.
+ *
+ * OpenOffice.org is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License version 3
+ * only, as published by the Free Software Foundation.
+ *
+ * OpenOffice.org 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 version 3 for more details
+ * (a copy is included in the LICENSE file that accompanied this code).
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * version 3 along with OpenOffice.org.  If not, see
+ * <http://www.openoffice.org/license.html>
+ * for a copy of the LGPLv3 License.
+ *
+ ************************************************************************/
+
+// MARKER(update_precomp.py): autogen include statement, do not remove
+#include "precompiled_sc.hxx"
+
+
+
+// INCLUDE ---------------------------------------------------------------
+
+#include "xmlcvali.hxx"
+#include "xmlimprt.hxx"
+#include "xmlconti.hxx"
+#include "document.hxx"
+#include "XMLConverter.hxx"
+
+#include <xmloff/xmltkmap.hxx>
+#include <xmloff/nmspmap.hxx>
+#include <xmloff/xmltoken.hxx>
+#include <xmloff/xmlnmspe.hxx>
+#include <xmloff/XMLEventsImportContext.hxx>
+#include <com/sun/star/sheet/TableValidationVisibility.hpp>
+#include <tools/debug.hxx>
+
+using namespace com::sun::star;
+using namespace xmloff::token;
+
+class ScXMLContentValidationContext : public SvXMLImportContext
+{
+    rtl::OUString      sName;
+    rtl::OUString      sHelpTitle;
+    rtl::OUString      sHelpMessage;
+    rtl::OUString      sErrorTitle;
+    rtl::OUString      sErrorMessage;
+    rtl::OUString      sErrorMessageType;
+    rtl::OUString      sBaseCellAddress;
+    rtl::OUString      sCondition;
+    formula::FormulaGrammar::Grammar eGrammar;
+    sal_Int16          nShowList;
+    sal_Bool           bAllowEmptyCell;
+    sal_Bool           bDisplayHelp;
+    sal_Bool           bDisplayError;
+
+    SvXMLImportContextRef           xEventContext;
+
+    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
+    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
+
+    void GetAlertStyle(const rtl::OUString& sMessageType, com::sun::star::sheet::ValidationAlertStyle& aAlertStyle);
+    void SetFormulas(const rtl::OUString& sFormulas, rtl::OUString& sFormula1, rtl::OUString& sFormula2) const;
+    void GetCondition(const rtl::OUString& sCondition, rtl::OUString& sFormula1, rtl::OUString& sFormula2,
+        com::sun::star::sheet::ValidationType& aValidationType,
+        com::sun::star::sheet::ConditionOperator& aOperator);
+
+public:
+
+    ScXMLContentValidationContext( ScXMLImport& rImport, USHORT nPrfx,
+                        const ::rtl::OUString& rLName,
+                        const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList);
+
+    virtual ~ScXMLContentValidationContext();
+
+    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
+                                     const ::rtl::OUString& rLocalName,
+                                     const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
+
+    virtual void EndElement();
+
+    void SetHelpMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage, const sal_Bool bDisplay);
+    void SetErrorMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage, const rtl::OUString& sMessageType, const sal_Bool bDisplay);
+    void SetErrorMacro(const sal_Bool bExecute);
+};
+
+class ScXMLHelpMessageContext : public SvXMLImportContext
+{
+    rtl::OUString   sTitle;
+    rtl::OUStringBuffer sMessage;
+    sal_Int32       nParagraphCount;
+    sal_Bool        bDisplay;
+
+    ScXMLContentValidationContext* pValidationContext;
+
+    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
+    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
+
+public:
+
+    ScXMLHelpMessageContext( ScXMLImport& rImport, USHORT nPrfx,
+                        const ::rtl::OUString& rLName,
+                        const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
+                        ScXMLContentValidationContext* pValidationContext);
+
+    virtual ~ScXMLHelpMessageContext();
+
+    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
+                                     const ::rtl::OUString& rLocalName,
+                                     const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
+
+    virtual void EndElement();
+};
+
+class ScXMLErrorMessageContext : public SvXMLImportContext
+{
+    rtl::OUString   sTitle;
+    rtl::OUStringBuffer sMessage;
+    rtl::OUString   sMessageType;
+    sal_Int32       nParagraphCount;
+    sal_Bool        bDisplay;
+
+    ScXMLContentValidationContext* pValidationContext;
+
+    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
+    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
+
+public:
+
+    ScXMLErrorMessageContext( ScXMLImport& rImport, USHORT nPrfx,
+                        const ::rtl::OUString& rLName,
+                        const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
+                        ScXMLContentValidationContext* pValidationContext);
+
+    virtual ~ScXMLErrorMessageContext();
+
+    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
+                                     const ::rtl::OUString& rLocalName,
+                                     const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
+
+    virtual void EndElement();
+};
+
+class ScXMLErrorMacroContext : public SvXMLImportContext
+{
+    rtl::OUString   sName;
+    sal_Bool        bExecute;
+
+    ScXMLContentValidationContext*  pValidationContext;
+
+    const ScXMLImport& GetScImport() const { return (const ScXMLImport&)GetImport(); }
+    ScXMLImport& GetScImport() { return (ScXMLImport&)GetImport(); }
+
+public:
+
+    ScXMLErrorMacroContext( ScXMLImport& rImport, USHORT nPrfx,
+                        const ::rtl::OUString& rLName,
+                        const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
+                        ScXMLContentValidationContext* pValidationContext);
+
+    virtual ~ScXMLErrorMacroContext();
+
+    virtual SvXMLImportContext *CreateChildContext( USHORT nPrefix,
+                                     const ::rtl::OUString& rLocalName,
+                                     const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList );
+    virtual void EndElement();
+};
+
+//------------------------------------------------------------------
+
+ScXMLContentValidationsContext::ScXMLContentValidationsContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ ) :
+    SvXMLImportContext( rImport, nPrfx, rLName )
+{
+    // here are no attributes
+}
+
+ScXMLContentValidationsContext::~ScXMLContentValidationsContext()
+{
+}
+
+SvXMLImportContext *ScXMLContentValidationsContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
+{
+    SvXMLImportContext *pContext = 0;
+
+    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationsElemTokenMap();
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+        case XML_TOK_CONTENT_VALIDATION:
+            pContext = new ScXMLContentValidationContext( GetScImport(), nPrefix, rLName, xAttrList);
+        break;
+    }
+
+    if( !pContext )
+        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
+
+    return pContext;
+}
+
+void ScXMLContentValidationsContext::EndElement()
+{
+}
+
+ScXMLContentValidationContext::ScXMLContentValidationContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList) :
+    SvXMLImportContext( rImport, nPrfx, rLName ),
+    sName(),
+    sHelpTitle(),
+    sHelpMessage(),
+    sErrorTitle(),
+    sErrorMessage(),
+    sErrorMessageType(),
+    sBaseCellAddress(),
+    sCondition(),
+    nShowList(sheet::TableValidationVisibility::UNSORTED),
+    bAllowEmptyCell(sal_True),
+    bDisplayHelp(sal_False),
+    bDisplayError(sal_False)
+{
+    const formula::FormulaGrammar::Grammar eStorageGrammar = eGrammar = GetScImport().GetDocument()->GetStorageGrammar();
+    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
+    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationAttrTokenMap();
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName );
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+            case XML_TOK_CONTENT_VALIDATION_NAME:
+                sName = sValue;
+            break;
+            case XML_TOK_CONTENT_VALIDATION_CONDITION:
+                {
+                    sal_uInt16 nCondPrefix = GetImport().GetNamespaceMap().
+                            _GetKeyByAttrName( sValue, &sCondition, sal_False );
+
+                    if (!ScXMLImport::IsAcceptedFormulaNamespace( nCondPrefix,
+                                sValue, eGrammar, eStorageGrammar))
+                        sCondition = sValue;
+                }
+            break;
+            case XML_TOK_CONTENT_VALIDATION_BASE_CELL_ADDRESS:
+                sBaseCellAddress = sValue;
+            break;
+            case XML_TOK_CONTENT_VALIDATION_ALLOW_EMPTY_CELL:
+                if (IsXMLToken(sValue, XML_FALSE))
+                    bAllowEmptyCell = sal_False;
+            break;
+            case XML_TOK_CONTENT_VALIDATION_DISPLAY_LIST:
+            {
+                if (IsXMLToken(sValue, XML_NO))
+                {
+                    nShowList = sheet::TableValidationVisibility::INVISIBLE;
+                }
+                else if (IsXMLToken(sValue, XML_UNSORTED))
+                {
+                    nShowList = sheet::TableValidationVisibility::UNSORTED;
+                }
+                else if (IsXMLToken(sValue, XML_SORTED_ASCENDING))
+                {
+                    nShowList = sheet::TableValidationVisibility::SORTEDASCENDING;
+                }
+            }
+            break;
+        }
+    }
+}
+
+ScXMLContentValidationContext::~ScXMLContentValidationContext()
+{
+}
+
+SvXMLImportContext *ScXMLContentValidationContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
+{
+    SvXMLImportContext *pContext = 0;
+
+    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationElemTokenMap();
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+        case XML_TOK_CONTENT_VALIDATION_ELEM_HELP_MESSAGE:
+            pContext = new ScXMLHelpMessageContext( GetScImport(), nPrefix, rLName, xAttrList, this);
+        break;
+        case XML_TOK_CONTENT_VALIDATION_ELEM_ERROR_MESSAGE:
+            pContext = new ScXMLErrorMessageContext( GetScImport(), nPrefix, rLName, xAttrList, this);
+        break;
+        case XML_TOK_CONTENT_VALIDATION_ELEM_ERROR_MACRO:
+            pContext = new ScXMLErrorMacroContext( GetScImport(), nPrefix, rLName, xAttrList, this);
+        break;
+        case XML_TOK_CONTENT_VALIDATION_ELEM_EVENT_LISTENERS:
+            pContext = new XMLEventsImportContext( GetImport(), nPrefix, rLName );
+            xEventContext = pContext;
+        break;
+    }
+
+    if( !pContext )
+        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
+
+    return pContext;
+}
+
+void ScXMLContentValidationContext::GetAlertStyle(const rtl::OUString& sMessageType, com::sun::star::sheet::ValidationAlertStyle& aAlertStyle)
+{
+    if (IsXMLToken(sMessageType, XML_MACRO))
+        aAlertStyle = sheet::ValidationAlertStyle_MACRO;
+    else if (IsXMLToken(sMessageType, XML_STOP))
+        aAlertStyle = sheet::ValidationAlertStyle_STOP;
+    else if (IsXMLToken(sMessageType, XML_WARNING))
+        aAlertStyle = sheet::ValidationAlertStyle_WARNING;
+    else if (IsXMLToken(sMessageType, XML_INFORMATION))
+        aAlertStyle = sheet::ValidationAlertStyle_INFO;
+    else    // don't leave uninitialized
+        aAlertStyle = sheet::ValidationAlertStyle_STOP;
+}
+
+void ScXMLContentValidationContext::SetFormulas(const rtl::OUString& sFormulas, rtl::OUString& sFormula1, rtl::OUString& sFormula2) const
+{
+    sal_Int32 i = 0;
+    sal_Bool bString = sal_False;
+    sal_Int32 nBrakes = 0;
+    while ((sFormulas[i] != ',' || nBrakes > 0 || bString) && i < sFormulas.getLength())
+    {
+        if (sFormulas[i] == '(')
+            ++nBrakes;
+        if (sFormulas[i] == ')')
+            --nBrakes;
+        if (sFormulas[i] == '"')
+            bString = !bString;
+        ++i;
+    }
+    if (sFormulas[i] == ',')
+    {
+        sFormula1 = sFormulas.copy(0, i);
+        sFormula2 = sFormulas.copy(i + 1);
+    }
+}
+
+void ScXMLContentValidationContext::GetCondition(const rtl::OUString& sTempCondition, rtl::OUString& sFormula1, rtl::OUString& sFormula2,
+        com::sun::star::sheet::ValidationType& aValidationType,
+        com::sun::star::sheet::ConditionOperator& aOperator)
+{
+    aValidationType = sheet::ValidationType_ANY;    // #b6343997# default if no condition is given
+    aOperator = sheet::ConditionOperator_NONE;
+
+    rtl::OUString sLocalCondition(sTempCondition);
+    if (sLocalCondition.getLength())
+    {
+        // ToDo: erase all blanks in the condition, but not in formulas or strings
+        rtl::OUString scell_content(RTL_CONSTASCII_USTRINGPARAM("cell_content"));
+        rtl::OUString scell_content_is_date(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-date"));
+        rtl::OUString scell_content_is_time(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-time"));
+        rtl::OUString scell_content_is_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-between"));
+        rtl::OUString scell_content_is_in_list(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-in-list"));
+        rtl::OUString scell_content_text_length(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length"));
+        rtl::OUString scell_content_is_not_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-not-between"));
+        rtl::OUString scell_content_is_whole_number(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-whole-number"));
+        rtl::OUString scell_content_is_decimal_number(RTL_CONSTASCII_USTRINGPARAM("cell-content-is-decimal-number"));
+        rtl::OUString scell_content_text_length_is_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-between"));
+        rtl::OUString scell_content_text_length_is_not_between(RTL_CONSTASCII_USTRINGPARAM("cell-content-text-length-is-not-between"));
+        sal_Int32 i = 0;
+        sal_Bool bAnd(sal_True);
+        while (sLocalCondition[i] != '(' && i < sLocalCondition.getLength())
+            ++i;
+        if (sLocalCondition[i] == '(')
+        {
+            if (i != scell_content_text_length.getLength() &&
+                i != scell_content_text_length_is_between.getLength() &&
+                i != scell_content_text_length_is_not_between.getLength() &&
+                i != scell_content_is_in_list.getLength())
+            {
+                if (i == scell_content_is_time.getLength())
+                {
+                    rtl::OUString sTemp = sLocalCondition.copy(0, i);
+                    if (sTemp == scell_content_is_time)
+                        aValidationType = sheet::ValidationType_TIME;
+                    else
+                        aValidationType = sheet::ValidationType_DATE;
+                }
+                else if (i == scell_content_is_whole_number.getLength())
+                    aValidationType = sheet::ValidationType_WHOLE;
+                else if (i == scell_content_is_decimal_number.getLength())
+                    aValidationType = sheet::ValidationType_DECIMAL;
+                sLocalCondition = sLocalCondition.copy(i + 2);
+                rtl::OUString sTemp = sLocalCondition.copy(0, 5);
+                if (sTemp.compareToAscii(" and ") == 0)
+                    sLocalCondition = sLocalCondition.copy(5);
+                else
+                    bAnd = sal_False;
+            }
+            if (sLocalCondition.getLength() && bAnd)
+            {
+                i = 0;
+                while (sLocalCondition[i] != '(' && i < sLocalCondition.getLength())
+                    ++i;
+                if (sLocalCondition[i] == '(')
+                {
+                    rtl::OUString sTemp = sLocalCondition.copy(0, i);
+                    sLocalCondition = sLocalCondition.copy(i + 1);
+                    if (i == scell_content_is_between.getLength() ||
+                        i == scell_content_text_length_is_between.getLength())
+                    {
+                        if (sTemp == scell_content_is_in_list)
+                        {
+                            aValidationType = sheet::ValidationType_LIST;
+                            sFormula1 = sLocalCondition.copy(0, sLocalCondition.getLength() - 1);
+                            aOperator = sheet::ConditionOperator_EQUAL;
+                        }
+                        else
+                        {
+                            if (i == scell_content_text_length_is_between.getLength())
+                                aValidationType = sheet::ValidationType_TEXT_LEN;
+                            aOperator = sheet::ConditionOperator_BETWEEN;
+                            sLocalCondition = sLocalCondition.copy(0, sLocalCondition.getLength() - 1);
+                            SetFormulas(sLocalCondition, sFormula1, sFormula2);
+                        }
+                    }
+                    else if (i == scell_content_is_not_between.getLength() ||
+                        i == scell_content_text_length_is_not_between.getLength())
+                    {
+                        if (i == scell_content_text_length_is_not_between.getLength())
+                            aValidationType = sheet::ValidationType_TEXT_LEN;
+                        aOperator = sheet::ConditionOperator_NOT_BETWEEN;
+                        sLocalCondition = sLocalCondition.copy(0, sLocalCondition.getLength() - 1);
+                        SetFormulas(sLocalCondition, sFormula1, sFormula2);
+                    }
+                    else if (i == scell_content.getLength() ||
+                        i == scell_content_text_length.getLength())
+                    {
+                        if (i == scell_content_text_length.getLength())
+                            aValidationType = sheet::ValidationType_TEXT_LEN;
+                        sLocalCondition = sLocalCondition.copy(1);
+                        switch (sLocalCondition[0])
+                        {
+                            case '<' :
+                            {
+                                if (sLocalCondition[1] == '=')
+                                {
+                                    aOperator = sheet::ConditionOperator_LESS_EQUAL;
+                                    sLocalCondition = sLocalCondition.copy(2);
+                                }
+                                else
+                                {
+                                    aOperator = sheet::ConditionOperator_LESS;
+                                    sLocalCondition = sLocalCondition.copy(1);
+                                }
+                            }
+                            break;
+                            case '>' :
+                            {
+                                if (sLocalCondition[1] == '=')
+                                {
+                                    aOperator = sheet::ConditionOperator_GREATER_EQUAL;
+                                    sLocalCondition = sLocalCondition.copy(2);
+                                }
+                                else
+                                {
+                                    aOperator = sheet::ConditionOperator_GREATER;
+                                    sLocalCondition = sLocalCondition.copy(1);
+                                }
+                            }
+                            break;
+                            case '=' :
+                            {
+                                aOperator = sheet::ConditionOperator_EQUAL;
+                                sLocalCondition = sLocalCondition.copy(1);
+                            }
+                            break;
+                            case '!' :
+                            {
+                                aOperator = sheet::ConditionOperator_NOT_EQUAL;
+                                sLocalCondition = sLocalCondition.copy(1);
+                            }
+                            break;
+                        }
+                        sFormula1 = sLocalCondition;
+                    }
+                }
+            }
+        }
+    }
+
+    // a validation type (date, integer) without a condition isn't possible
+    if ( aOperator == sheet::ConditionOperator_NONE )
+        aValidationType = sheet::ValidationType_ANY;
+}
+
+void ScXMLContentValidationContext::EndElement()
+{
+    // #i36650# event-listeners element moved up one level
+    if (xEventContext.Is())
+    {
+        rtl::OUString sOnError(RTL_CONSTASCII_USTRINGPARAM("OnError"));
+        XMLEventsImportContext* pEvents =
+            (XMLEventsImportContext*)&xEventContext;
+        uno::Sequence<beans::PropertyValue> aValues;
+        pEvents->GetEventSequence( sOnError, aValues );
+
+        sal_Int32 nLength = aValues.getLength();
+        for( sal_Int32 i = 0; i < nLength; i++ )
+        {
+            // #i47525# must allow "MacroName" or "Script"
+            if ( aValues[i].Name.equalsAsciiL( "MacroName", sizeof("MacroName")-1 ) ||
+                 aValues[i].Name.equalsAsciiL( "Script", sizeof("Script")-1 ) )
+            {
+                aValues[i].Value >>= sErrorTitle;
+                break;
+            }
+        }
+    }
+
+    ScMyImportValidation aValidation;
+    aValidation.eGrammar = eGrammar;
+    aValidation.sName = sName;
+    aValidation.sBaseCellAddress = sBaseCellAddress;
+    aValidation.sImputTitle = sHelpTitle;
+    aValidation.sImputMessage = sHelpMessage;
+    aValidation.sErrorTitle = sErrorTitle;
+    aValidation.sErrorMessage = sErrorMessage;
+    GetCondition(sCondition, aValidation.sFormula1, aValidation.sFormula2, aValidation.aValidationType, aValidation.aOperator);
+    GetAlertStyle(sErrorMessageType, aValidation.aAlertStyle);
+    aValidation.bShowErrorMessage = bDisplayError;
+    aValidation.bShowImputMessage = bDisplayHelp;
+    aValidation.bIgnoreBlanks = bAllowEmptyCell;
+    aValidation.nShowList = nShowList;
+    GetScImport().AddValidation(aValidation);
+}
+
+void ScXMLContentValidationContext::SetHelpMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage, const sal_Bool bDisplay)
+{
+    sHelpTitle = sTitle;
+    sHelpMessage = sMessage;
+    bDisplayHelp = bDisplay;
+}
+
+void ScXMLContentValidationContext::SetErrorMessage(const rtl::OUString& sTitle, const rtl::OUString& sMessage,
+    const rtl::OUString& sMessageType, const sal_Bool bDisplay)
+{
+    sErrorTitle = sTitle;
+    sErrorMessage = sMessage;
+    sErrorMessageType = sMessageType;
+    bDisplayError = bDisplay;
+}
+
+void ScXMLContentValidationContext::SetErrorMacro(const sal_Bool bExecute)
+{
+    sErrorMessageType = rtl::OUString(RTL_CONSTASCII_USTRINGPARAM("macro"));
+    bDisplayError = bExecute;
+}
+
+ScXMLHelpMessageContext::ScXMLHelpMessageContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
+                                      ScXMLContentValidationContext* pTempValidationContext) :
+    SvXMLImportContext( rImport, nPrfx, rLName ),
+    sTitle(),
+    sMessage(),
+    nParagraphCount(0),
+    bDisplay(sal_False)
+{
+    pValidationContext = pTempValidationContext;
+    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
+    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationHelpMessageAttrTokenMap();
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName );
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+            case XML_TOK_HELP_MESSAGE_ATTR_TITLE:
+                sTitle = sValue;
+            break;
+            case XML_TOK_HELP_MESSAGE_ATTR_DISPLAY:
+                bDisplay = IsXMLToken(sValue, XML_TRUE);
+            break;
+        }
+    }
+}
+
+ScXMLHelpMessageContext::~ScXMLHelpMessageContext()
+{
+}
+
+SvXMLImportContext *ScXMLHelpMessageContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
+{
+    SvXMLImportContext *pContext = 0;
+
+    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationMessageElemTokenMap();
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+        case XML_TOK_P:
+        {
+            if(nParagraphCount)
+                sMessage.append(static_cast<sal_Unicode>('\n'));
+            ++nParagraphCount;
+            pContext = new ScXMLContentContext( GetScImport(), nPrefix, rLName, xAttrList, sMessage);
+        }
+        break;
+    }
+
+    if( !pContext )
+        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
+
+    return pContext;
+}
+
+void ScXMLHelpMessageContext::EndElement()
+{
+    pValidationContext->SetHelpMessage(sTitle, sMessage.makeStringAndClear(), bDisplay);
+}
+
+ScXMLErrorMessageContext::ScXMLErrorMessageContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
+                                      ScXMLContentValidationContext* pTempValidationContext) :
+    SvXMLImportContext( rImport, nPrfx, rLName ),
+    sTitle(),
+    sMessage(),
+    sMessageType(),
+    nParagraphCount(0),
+    bDisplay(sal_False)
+{
+    pValidationContext = pTempValidationContext;
+    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
+    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationErrorMessageAttrTokenMap();
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName );
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+            case XML_TOK_ERROR_MESSAGE_ATTR_TITLE:
+                sTitle = sValue;
+            break;
+            case XML_TOK_ERROR_MESSAGE_ATTR_MESSAGE_TYPE:
+                sMessageType = sValue;
+            break;
+            case XML_TOK_ERROR_MESSAGE_ATTR_DISPLAY:
+                bDisplay = IsXMLToken(sValue, XML_TRUE);
+            break;
+        }
+    }
+}
+
+ScXMLErrorMessageContext::~ScXMLErrorMessageContext()
+{
+}
+
+SvXMLImportContext *ScXMLErrorMessageContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
+{
+    SvXMLImportContext *pContext = 0;
+
+    const SvXMLTokenMap& rTokenMap = GetScImport().GetContentValidationMessageElemTokenMap();
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+        case XML_TOK_P:
+        {
+            if(nParagraphCount)
+                sMessage.append(static_cast<sal_Unicode>('\n'));
+            ++nParagraphCount;
+            pContext = new ScXMLContentContext( GetScImport(), nPrefix, rLName, xAttrList, sMessage);
+        }
+        break;
+    }
+
+    if( !pContext )
+        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
+
+    return pContext;
+}
+
+void ScXMLErrorMessageContext::EndElement()
+{
+    pValidationContext->SetErrorMessage(sTitle, sMessage.makeStringAndClear(), sMessageType, bDisplay);
+}
+
+ScXMLErrorMacroContext::ScXMLErrorMacroContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList,
+                                      ScXMLContentValidationContext* pTempValidationContext) :
+    SvXMLImportContext( rImport, nPrfx, rLName ),
+    sName(),
+    bExecute(sal_False)
+{
+    pValidationContext = pTempValidationContext;
+    sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
+    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetContentValidationErrorMacroAttrTokenMap();
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName );
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+            case XML_TOK_ERROR_MACRO_ATTR_NAME:
+                sName = sValue;
+            break;
+            case XML_TOK_ERROR_MACRO_ATTR_EXECUTE:
+                bExecute = IsXMLToken(sValue, XML_TRUE);
+            break;
+        }
+    }
+}
+
+ScXMLErrorMacroContext::~ScXMLErrorMacroContext()
+{
+}
+
+SvXMLImportContext *ScXMLErrorMacroContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ )
+{
+    SvXMLImportContext *pContext = NULL;
+
+    if ((nPrefix == XML_NAMESPACE_SCRIPT) && IsXMLToken(rLName, XML_EVENTS))
+    {
+        pContext = new XMLEventsImportContext(GetImport(), nPrefix, rLName);
+    }
+    if (!pContext)
+        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
+
+    return pContext;
+}
+
+void ScXMLErrorMacroContext::EndElement()
+{
+    pValidationContext->SetErrorMacro( bExecute );
+}
diff --git a/sc/source/filter/xml/xmlnexpi.cxx b/sc/source/filter/xml/xmlnexpi.cxx
index 249522c1a9bc..3f822d5274c6 100644
--- a/sc/source/filter/xml/xmlnexpi.cxx
+++ b/sc/source/filter/xml/xmlnexpi.cxx
@@ -1,262 +1,262 @@
-/*************************************************************************
- *
- * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
- * 
- * Copyright 2008 by Sun Microsystems, Inc.
- *
- * OpenOffice.org - a multi-platform office productivity suite
- *
- * $RCSfile: xmlnexpi.cxx,v $
- * $Revision: 1.18 $
- *
- * This file is part of OpenOffice.org.
- *
- * OpenOffice.org is free software: you can redistribute it and/or modify
- * it under the terms of the GNU Lesser General Public License version 3
- * only, as published by the Free Software Foundation.
- *
- * OpenOffice.org 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 version 3 for more details
- * (a copy is included in the LICENSE file that accompanied this code).
- *
- * You should have received a copy of the GNU Lesser General Public License
- * version 3 along with OpenOffice.org.  If not, see
- * <http://www.openoffice.org/license.html>
- * for a copy of the LGPLv3 License.
- *
- ************************************************************************/
-
-// MARKER(update_precomp.py): autogen include statement, do not remove
-#include "precompiled_sc.hxx"
-
-
-
-// INCLUDE ---------------------------------------------------------------
-#include <rtl/ustrbuf.hxx>
-
-#include "xmlnexpi.hxx"
-#include "xmlimprt.hxx"
-#include "xmlcelli.hxx"
-#include "docuno.hxx"
-#include "global.hxx"
-#include "document.hxx"
-#include "XMLConverter.hxx"
-
-#include <xmloff/xmltkmap.hxx>
-#include <xmloff/nmspmap.hxx>
-
-using namespace com::sun::star;
-
-//------------------------------------------------------------------
-
-ScXMLNamedExpressionsContext::ScXMLNamedExpressionsContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ ) :
-    SvXMLImportContext( rImport, nPrfx, rLName )
-{
-/*  sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName );
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetNamedRangeAttrTokenMap();
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-        }
-    }*/
-    rImport.LockSolarMutex();
-}
-
-ScXMLNamedExpressionsContext::~ScXMLNamedExpressionsContext()
-{
-    GetScImport().UnlockSolarMutex();
-}
-
-SvXMLImportContext *ScXMLNamedExpressionsContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
-{
-    SvXMLImportContext *pContext(0);
-
-    const SvXMLTokenMap& rTokenMap(GetScImport().GetNamedExpressionsElemTokenMap());
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-    case XML_TOK_NAMED_EXPRESSIONS_NAMED_RANGE:
-        pContext = new ScXMLNamedRangeContext( GetScImport(), nPrefix,
-                                                      rLName, xAttrList//,
-                                                      //this
-                                                      );
-        break;
-    case XML_TOK_NAMED_EXPRESSIONS_NAMED_EXPRESSION:
-        pContext = new ScXMLNamedExpressionContext( GetScImport(), nPrefix,
-                                                      rLName, xAttrList//,
-                                                      //this
-                                                      );
-        break;
-    }
-
-    if( !pContext )
-        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
-
-    return pContext;
-}
-
-void ScXMLNamedExpressionsContext::EndElement()
-{
-    // happends in ScXMLImport::EndDocument()
-    // because it has to be set after the Database Ranges
-}
-
-ScXMLNamedRangeContext::ScXMLNamedRangeContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList) :
-    SvXMLImportContext( rImport, nPrfx, rLName )
-{
-    ScMyNamedExpression* pNamedExpression(new ScMyNamedExpression);
-    // A simple table:cell-range-address is not a formula expression, stored
-    // without [] brackets but with dot, .A1
-    pNamedExpression->eGrammar = formula::FormulaGrammar::mergeToGrammar(
-            GetScImport().GetDocument()->GetStorageGrammar(),
-            formula::FormulaGrammar::CONV_OOO);
-    sal_Int16 nAttrCount(xAttrList.is() ? xAttrList->getLength() : 0);
-    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetNamedRangeAttrTokenMap();
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix(GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName ));
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-            case XML_TOK_NAMED_RANGE_ATTR_NAME :
-            {
-                pNamedExpression->sName = sValue;
-            }
-            break;
-            case XML_TOK_NAMED_RANGE_ATTR_CELL_RANGE_ADDRESS :
-            {
-                pNamedExpression->sContent = sValue;
-            }
-            break;
-            case XML_TOK_NAMED_RANGE_ATTR_BASE_CELL_ADDRESS :
-            {
-                pNamedExpression->sBaseCellAddress = sValue;
-            }
-            break;
-            case XML_TOK_NAMED_RANGE_ATTR_RANGE_USABLE_AS :
-            {
-                pNamedExpression->sRangeType = sValue;
-            }
-            break;
-        }
-    }
-    pNamedExpression->bIsExpression = sal_False;
-    GetScImport().AddNamedExpression(pNamedExpression);
-}
-
-ScXMLNamedRangeContext::~ScXMLNamedRangeContext()
-{
-}
-
-SvXMLImportContext *ScXMLNamedRangeContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ )
-{
-/*  const SvXMLTokenMap& rTokenMap = GetScImport().GetTableElemTokenMap();
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-    }*/
-    return new SvXMLImportContext( GetImport(), nPrefix, rLName );
-}
-
-void ScXMLNamedRangeContext::EndElement()
-{
-}
-
-ScXMLNamedExpressionContext::ScXMLNamedExpressionContext( ScXMLImport& rImport,
-                                      USHORT nPrfx,
-                                      const ::rtl::OUString& rLName,
-                                      const ::com::sun::star::uno::Reference<
-                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList) :
-    SvXMLImportContext( rImport, nPrfx, rLName )
-{
-    ScMyNamedExpression* pNamedExpression(new ScMyNamedExpression);
-    const formula::FormulaGrammar::Grammar eStorageGrammar = pNamedExpression->eGrammar =
-        GetScImport().GetDocument()->GetStorageGrammar();
-    sal_Int16 nAttrCount(xAttrList.is() ? xAttrList->getLength() : 0);
-    const SvXMLTokenMap& rAttrTokenMap(GetScImport().GetNamedExpressionAttrTokenMap());
-    for( sal_Int16 i=0; i < nAttrCount; ++i )
-    {
-        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
-        rtl::OUString aLocalName;
-        USHORT nPrefix(GetScImport().GetNamespaceMap().GetKeyByAttrName(
-                                            sAttrName, &aLocalName ));
-        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
-
-        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
-        {
-            case XML_TOK_NAMED_EXPRESSION_ATTR_NAME :
-            {
-                pNamedExpression->sName = sValue;
-            }
-            break;
-            case XML_TOK_NAMED_EXPRESSION_ATTR_EXPRESSION :
-            {
-                rtl::OUString sFormula;
-                sal_uInt16 nFormulaPrefix = GetImport().GetNamespaceMap().
-                    _GetKeyByAttrName( sValue, &sFormula, sal_False );
-
-                if (ScXMLImport::IsAcceptedFormulaNamespace( nFormulaPrefix,
-                            sValue, pNamedExpression->eGrammar,
-                            eStorageGrammar))
-                    pNamedExpression->sContent = sFormula;
-                else
-                    pNamedExpression->sContent = sValue;
-            }
-            break;
-            case XML_TOK_NAMED_EXPRESSION_ATTR_BASE_CELL_ADDRESS :
-            {
-                pNamedExpression->sBaseCellAddress = sValue;
-            }
-            break;
-        }
-    }
-    pNamedExpression->bIsExpression = sal_True;
-    GetScImport().AddNamedExpression(pNamedExpression);
-}
-
-ScXMLNamedExpressionContext::~ScXMLNamedExpressionContext()
-{
-}
-
-SvXMLImportContext *ScXMLNamedExpressionContext::CreateChildContext( USHORT nPrefix,
-                                            const ::rtl::OUString& rLName,
-                                            const ::com::sun::star::uno::Reference<
-                                        ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ )
-{
-/*  const SvXMLTokenMap& rTokenMap = GetScImport().GetTableElemTokenMap();
-    switch( rTokenMap.Get( nPrefix, rLName ) )
-    {
-    }*/
-    return new SvXMLImportContext( GetImport(), nPrefix, rLName );;
-}
-
-void ScXMLNamedExpressionContext::EndElement()
-{
-}
-
+/*************************************************************************
+ *
+ * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
+ *
+ * Copyright 2008 by Sun Microsystems, Inc.
+ *
+ * OpenOffice.org - a multi-platform office productivity suite
+ *
+ * $RCSfile: xmlnexpi.cxx,v $
+ * $Revision: 1.18 $
+ *
+ * This file is part of OpenOffice.org.
+ *
+ * OpenOffice.org is free software: you can redistribute it and/or modify
+ * it under the terms of the GNU Lesser General Public License version 3
+ * only, as published by the Free Software Foundation.
+ *
+ * OpenOffice.org 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 version 3 for more details
+ * (a copy is included in the LICENSE file that accompanied this code).
+ *
+ * You should have received a copy of the GNU Lesser General Public License
+ * version 3 along with OpenOffice.org.  If not, see
+ * <http://www.openoffice.org/license.html>
+ * for a copy of the LGPLv3 License.
+ *
+ ************************************************************************/
+
+// MARKER(update_precomp.py): autogen include statement, do not remove
+#include "precompiled_sc.hxx"
+
+
+
+// INCLUDE ---------------------------------------------------------------
+#include <rtl/ustrbuf.hxx>
+
+#include "xmlnexpi.hxx"
+#include "xmlimprt.hxx"
+#include "xmlcelli.hxx"
+#include "docuno.hxx"
+#include "global.hxx"
+#include "document.hxx"
+#include "XMLConverter.hxx"
+
+#include <xmloff/xmltkmap.hxx>
+#include <xmloff/nmspmap.hxx>
+
+using namespace com::sun::star;
+
+//------------------------------------------------------------------
+
+ScXMLNamedExpressionsContext::ScXMLNamedExpressionsContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ ) :
+    SvXMLImportContext( rImport, nPrfx, rLName )
+{
+/*  sal_Int16 nAttrCount = xAttrList.is() ? xAttrList->getLength() : 0;
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName );
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetNamedRangeAttrTokenMap();
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+        }
+    }*/
+    rImport.LockSolarMutex();
+}
+
+ScXMLNamedExpressionsContext::~ScXMLNamedExpressionsContext()
+{
+    GetScImport().UnlockSolarMutex();
+}
+
+SvXMLImportContext *ScXMLNamedExpressionsContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                          ::com::sun::star::xml::sax::XAttributeList>& xAttrList )
+{
+    SvXMLImportContext *pContext(0);
+
+    const SvXMLTokenMap& rTokenMap(GetScImport().GetNamedExpressionsElemTokenMap());
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+    case XML_TOK_NAMED_EXPRESSIONS_NAMED_RANGE:
+        pContext = new ScXMLNamedRangeContext( GetScImport(), nPrefix,
+                                                      rLName, xAttrList//,
+                                                      //this
+                                                      );
+        break;
+    case XML_TOK_NAMED_EXPRESSIONS_NAMED_EXPRESSION:
+        pContext = new ScXMLNamedExpressionContext( GetScImport(), nPrefix,
+                                                      rLName, xAttrList//,
+                                                      //this
+                                                      );
+        break;
+    }
+
+    if( !pContext )
+        pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName );
+
+    return pContext;
+}
+
+void ScXMLNamedExpressionsContext::EndElement()
+{
+    // happends in ScXMLImport::EndDocument()
+    // because it has to be set after the Database Ranges
+}
+
+ScXMLNamedRangeContext::ScXMLNamedRangeContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList) :
+    SvXMLImportContext( rImport, nPrfx, rLName )
+{
+    ScMyNamedExpression* pNamedExpression(new ScMyNamedExpression);
+    // A simple table:cell-range-address is not a formula expression, stored
+    // without [] brackets but with dot, .A1
+    pNamedExpression->eGrammar = formula::FormulaGrammar::mergeToGrammar(
+            GetScImport().GetDocument()->GetStorageGrammar(),
+            formula::FormulaGrammar::CONV_OOO);
+    sal_Int16 nAttrCount(xAttrList.is() ? xAttrList->getLength() : 0);
+    const SvXMLTokenMap& rAttrTokenMap = GetScImport().GetNamedRangeAttrTokenMap();
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix(GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName ));
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+            case XML_TOK_NAMED_RANGE_ATTR_NAME :
+            {
+                pNamedExpression->sName = sValue;
+            }
+            break;
+            case XML_TOK_NAMED_RANGE_ATTR_CELL_RANGE_ADDRESS :
+            {
+                pNamedExpression->sContent = sValue;
+            }
+            break;
+            case XML_TOK_NAMED_RANGE_ATTR_BASE_CELL_ADDRESS :
+            {
+                pNamedExpression->sBaseCellAddress = sValue;
+            }
+            break;
+            case XML_TOK_NAMED_RANGE_ATTR_RANGE_USABLE_AS :
+            {
+                pNamedExpression->sRangeType = sValue;
+            }
+            break;
+        }
+    }
+    pNamedExpression->bIsExpression = sal_False;
+    GetScImport().AddNamedExpression(pNamedExpression);
+}
+
+ScXMLNamedRangeContext::~ScXMLNamedRangeContext()
+{
+}
+
+SvXMLImportContext *ScXMLNamedRangeContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ )
+{
+/*  const SvXMLTokenMap& rTokenMap = GetScImport().GetTableElemTokenMap();
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+    }*/
+    return new SvXMLImportContext( GetImport(), nPrefix, rLName );
+}
+
+void ScXMLNamedRangeContext::EndElement()
+{
+}
+
+ScXMLNamedExpressionContext::ScXMLNamedExpressionContext( ScXMLImport& rImport,
+                                      USHORT nPrfx,
+                                      const ::rtl::OUString& rLName,
+                                      const ::com::sun::star::uno::Reference<
+                                      ::com::sun::star::xml::sax::XAttributeList>& xAttrList) :
+    SvXMLImportContext( rImport, nPrfx, rLName )
+{
+    ScMyNamedExpression* pNamedExpression(new ScMyNamedExpression);
+    const formula::FormulaGrammar::Grammar eStorageGrammar = pNamedExpression->eGrammar =
+        GetScImport().GetDocument()->GetStorageGrammar();
+    sal_Int16 nAttrCount(xAttrList.is() ? xAttrList->getLength() : 0);
+    const SvXMLTokenMap& rAttrTokenMap(GetScImport().GetNamedExpressionAttrTokenMap());
+    for( sal_Int16 i=0; i < nAttrCount; ++i )
+    {
+        const rtl::OUString& sAttrName(xAttrList->getNameByIndex( i ));
+        rtl::OUString aLocalName;
+        USHORT nPrefix(GetScImport().GetNamespaceMap().GetKeyByAttrName(
+                                            sAttrName, &aLocalName ));
+        const rtl::OUString& sValue(xAttrList->getValueByIndex( i ));
+
+        switch( rAttrTokenMap.Get( nPrefix, aLocalName ) )
+        {
+            case XML_TOK_NAMED_EXPRESSION_ATTR_NAME :
+            {
+                pNamedExpression->sName = sValue;
+            }
+            break;
+            case XML_TOK_NAMED_EXPRESSION_ATTR_EXPRESSION :
+            {
+                rtl::OUString sFormula;
+                sal_uInt16 nFormulaPrefix = GetImport().GetNamespaceMap().
+                    _GetKeyByAttrName( sValue, &sFormula, sal_False );
+
+                if (ScXMLImport::IsAcceptedFormulaNamespace( nFormulaPrefix,
+                            sValue, pNamedExpression->eGrammar,
+                            eStorageGrammar))
+                    pNamedExpression->sContent = sFormula;
+                else
+                    pNamedExpression->sContent = sValue;
+            }
+            break;
+            case XML_TOK_NAMED_EXPRESSION_ATTR_BASE_CELL_ADDRESS :
+            {
+                pNamedExpression->sBaseCellAddress = sValue;
+            }
+            break;
+        }
+    }
+    pNamedExpression->bIsExpression = sal_True;
+    GetScImport().AddNamedExpression(pNamedExpression);
+}
+
+ScXMLNamedExpressionContext::~ScXMLNamedExpressionContext()
+{
+}
+
+SvXMLImportContext *ScXMLNamedExpressionContext::CreateChildContext( USHORT nPrefix,
+                                            const ::rtl::OUString& rLName,
+                                            const ::com::sun::star::uno::Reference<
+                                        ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ )
+{
+/*  const SvXMLTokenMap& rTokenMap = GetScImport().GetTableElemTokenMap();
+    switch( rTokenMap.Get( nPrefix, rLName ) )
+    {
+    }*/
+    return new SvXMLImportContext( GetImport(), nPrefix, rLName );;
+}
+
+void ScXMLNamedExpressionContext::EndElement()
+{
+}
+