diff options
Diffstat (limited to 'sc/source/filter/xml/XMLCalculationSettingsContext.cxx')
-rw-r--r-- | sc/source/filter/xml/XMLCalculationSettingsContext.cxx | 276 |
1 files changed, 276 insertions, 0 deletions
diff --git a/sc/source/filter/xml/XMLCalculationSettingsContext.cxx b/sc/source/filter/xml/XMLCalculationSettingsContext.cxx new file mode 100644 index 000000000000..303dc837b157 --- /dev/null +++ b/sc/source/filter/xml/XMLCalculationSettingsContext.cxx @@ -0,0 +1,276 @@ +/************************************************************************* + * + * 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: XMLCalculationSettingsContext.cxx,v $ + * $Revision: 1.16 $ + * + * 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 "XMLCalculationSettingsContext.hxx" +#include "xmlimprt.hxx" +#include "unonames.hxx" +#include "docoptio.hxx" +#include "document.hxx" +#include <xmloff/xmltoken.hxx> +#include <xmloff/xmlnmspe.hxx> +#include <xmloff/xmluconv.hxx> +#include <xmloff/nmspmap.hxx> +#include <com/sun/star/sheet/XSpreadsheetDocument.hpp> +#include <comphelper/extract.hxx> + +using namespace com::sun::star; +using namespace xmloff::token; + +//------------------------------------------------------------------ + +ScXMLCalculationSettingsContext::ScXMLCalculationSettingsContext( 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 ), + fIterationEpsilon(0.001), + nIterationCount(100), + nYear2000(1930), + bIsIterationEnabled(sal_False), + bCalcAsShown(sal_False), + bIgnoreCase(sal_False), + bLookUpLabels(sal_True), + bMatchWholeCell(sal_True), + bUseRegularExpressions(sal_True) +{ + aNullDate.Day = 30; + aNullDate.Month = 12; + aNullDate.Year = 1899; + 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; + sal_uInt16 nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName( + sAttrName, &aLocalName ); + const rtl::OUString& sValue(xAttrList->getValueByIndex( i )); + + if (nPrefix == XML_NAMESPACE_TABLE) + { + if (IsXMLToken(aLocalName, XML_CASE_SENSITIVE)) + { + if (IsXMLToken(sValue, XML_FALSE)) + bIgnoreCase = sal_True; + } + else if (IsXMLToken(aLocalName, XML_PRECISION_AS_SHOWN)) + { + if (IsXMLToken(sValue, XML_TRUE)) + bCalcAsShown = sal_True; + } + else if (IsXMLToken(aLocalName, XML_SEARCH_CRITERIA_MUST_APPLY_TO_WHOLE_CELL)) + { + if (IsXMLToken(sValue, XML_FALSE)) + bMatchWholeCell = sal_False; + } + else if (IsXMLToken(aLocalName, XML_AUTOMATIC_FIND_LABELS)) + { + if (IsXMLToken(sValue, XML_FALSE)) + bLookUpLabels = sal_False; + } + else if (IsXMLToken(aLocalName, XML_NULL_YEAR)) + { + sal_Int32 nTemp; + GetScImport().GetMM100UnitConverter().convertNumber(nTemp, sValue); + nYear2000 = static_cast<sal_uInt16>(nTemp); + } + else if (IsXMLToken(aLocalName, XML_USE_REGULAR_EXPRESSIONS)) + { + if (IsXMLToken(sValue, XML_FALSE)) + bUseRegularExpressions = sal_False; + } + } + } +} + +ScXMLCalculationSettingsContext::~ScXMLCalculationSettingsContext() +{ +} + +SvXMLImportContext *ScXMLCalculationSettingsContext::CreateChildContext( USHORT nPrefix, + const ::rtl::OUString& rLName, + const ::com::sun::star::uno::Reference< + ::com::sun::star::xml::sax::XAttributeList>& xAttrList ) +{ + SvXMLImportContext *pContext = 0; + + if (nPrefix == XML_NAMESPACE_TABLE) + { + if (IsXMLToken(rLName, XML_NULL_DATE)) + pContext = new ScXMLNullDateContext(GetScImport(), nPrefix, rLName, xAttrList, this); + else if (IsXMLToken(rLName, XML_ITERATION)) + pContext = new ScXMLIterationContext(GetScImport(), nPrefix, rLName, xAttrList, this); + } + + if( !pContext ) + pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName ); + + return pContext; +} + +void ScXMLCalculationSettingsContext::EndElement() +{ + if (GetScImport().GetModel().is()) + { + uno::Reference <beans::XPropertySet> xPropertySet (GetScImport().GetModel(), uno::UNO_QUERY); + if (xPropertySet.is()) + { + xPropertySet->setPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_CALCASSHOWN)), uno::makeAny(bCalcAsShown) ); + xPropertySet->setPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_IGNORECASE)), uno::makeAny(bIgnoreCase) ); + xPropertySet->setPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_LOOKUPLABELS)), uno::makeAny(bLookUpLabels) ); + xPropertySet->setPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_MATCHWHOLE)), uno::makeAny(bMatchWholeCell) ); + xPropertySet->setPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_REGEXENABLED)), uno::makeAny(bUseRegularExpressions) ); + xPropertySet->setPropertyValue(rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_ITERENABLED)), uno::makeAny(bIsIterationEnabled) ); + xPropertySet->setPropertyValue( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_ITERCOUNT)), uno::makeAny(nIterationCount) ); + xPropertySet->setPropertyValue( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_ITEREPSILON)), uno::makeAny(fIterationEpsilon) ); + xPropertySet->setPropertyValue( rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_NULLDATE)), uno::makeAny(aNullDate) ); + if (GetScImport().GetDocument()) + { + GetScImport().LockSolarMutex(); + ScDocOptions aDocOptions (GetScImport().GetDocument()->GetDocOptions()); + aDocOptions.SetYear2000(nYear2000); + GetScImport().GetDocument()->SetDocOptions(aDocOptions); + GetScImport().UnlockSolarMutex(); + } + } + } +} + +ScXMLNullDateContext::ScXMLNullDateContext( ScXMLImport& rImport, + USHORT nPrfx, + const ::rtl::OUString& rLName, + const ::com::sun::star::uno::Reference< + ::com::sun::star::xml::sax::XAttributeList>& xAttrList, + ScXMLCalculationSettingsContext* pCalcSet) : + 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; + sal_uInt16 nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName( + sAttrName, &aLocalName ); + const rtl::OUString& sValue(xAttrList->getValueByIndex( i )); + + if (nPrefix == XML_NAMESPACE_TABLE && IsXMLToken(aLocalName, XML_DATE_VALUE)) + { + util::DateTime aDateTime; + GetScImport().GetMM100UnitConverter().convertDateTime(aDateTime, sValue); + util::Date aDate; + aDate.Day = aDateTime.Day; + aDate.Month = aDateTime.Month; + aDate.Year = aDateTime.Year; + pCalcSet->SetNullDate(aDate); + } + } +} + +ScXMLNullDateContext::~ScXMLNullDateContext() +{ +} + +SvXMLImportContext *ScXMLNullDateContext::CreateChildContext( USHORT nPrefix, + const ::rtl::OUString& rLName, + const ::com::sun::star::uno::Reference< + ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ ) +{ + SvXMLImportContext *pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName ); + + return pContext; +} + +void ScXMLNullDateContext::EndElement() +{ +} + +ScXMLIterationContext::ScXMLIterationContext( ScXMLImport& rImport, + USHORT nPrfx, + const ::rtl::OUString& rLName, + const ::com::sun::star::uno::Reference< + ::com::sun::star::xml::sax::XAttributeList>& xAttrList, + ScXMLCalculationSettingsContext* pCalcSet) : + 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; + sal_uInt16 nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName( + sAttrName, &aLocalName ); + const rtl::OUString& sValue(xAttrList->getValueByIndex( i )); + + if (nPrefix == XML_NAMESPACE_TABLE) + { + if (IsXMLToken(aLocalName, XML_STATUS)) + { + if (IsXMLToken(sValue, XML_ENABLE)) + pCalcSet->SetIterationStatus(sal_True); + } + else if (IsXMLToken(aLocalName, XML_STEPS)) + { + sal_Int32 nSteps; + GetScImport().GetMM100UnitConverter().convertNumber(nSteps, sValue); + pCalcSet->SetIterationCount(nSteps); + } + else if (IsXMLToken(aLocalName, XML_MAXIMUM_DIFFERENCE)) + { + double fDif; + GetScImport().GetMM100UnitConverter().convertDouble(fDif, sValue); + pCalcSet->SetIterationEpsilon(fDif); + } + } + } +} + +ScXMLIterationContext::~ScXMLIterationContext() +{ +} + +SvXMLImportContext *ScXMLIterationContext::CreateChildContext( USHORT nPrefix, + const ::rtl::OUString& rLName, + const ::com::sun::star::uno::Reference< + ::com::sun::star::xml::sax::XAttributeList>& /* xAttrList */ ) +{ + SvXMLImportContext *pContext = new SvXMLImportContext( GetImport(), nPrefix, rLName ); + + return pContext; +} + +void ScXMLIterationContext::EndElement() +{ +} |