diff options
Diffstat (limited to 'binfilter/bf_sc/source/filter/xml/sc_XMLCalculationSettingsContext.cxx')
| -rw-r--r-- | binfilter/bf_sc/source/filter/xml/sc_XMLCalculationSettingsContext.cxx | 292 |
1 files changed, 292 insertions, 0 deletions
diff --git a/binfilter/bf_sc/source/filter/xml/sc_XMLCalculationSettingsContext.cxx b/binfilter/bf_sc/source/filter/xml/sc_XMLCalculationSettingsContext.cxx new file mode 100644 index 000000000000..d0776e813ca2 --- /dev/null +++ b/binfilter/bf_sc/source/filter/xml/sc_XMLCalculationSettingsContext.cxx @@ -0,0 +1,292 @@ +/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * 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. + * + ************************************************************************/ + +#ifdef _MSC_VER +#pragma hdrstop +#endif + +// INCLUDE --------------------------------------------------------------- + +#include "XMLCalculationSettingsContext.hxx" +#include "xmlimprt.hxx" +#include "unonames.hxx" +#include "docoptio.hxx" +#include "document.hxx" + +#include <bf_xmloff/xmlnmspe.hxx> +#include <bf_xmloff/xmluconv.hxx> +#include <bf_xmloff/nmspmap.hxx> + +#include <com/sun/star/sheet/XSpreadsheetDocument.hpp> +#include <comphelper/extract.hxx> +namespace binfilter { + +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++ ) + { + ::rtl::OUString sAttrName = xAttrList->getNameByIndex( i ); + ::rtl::OUString aLocalName; + sal_uInt16 nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName( + sAttrName, &aLocalName ); + ::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 <sheet::XSpreadsheetDocument> xSpreadDoc (GetScImport().GetModel(), uno::UNO_QUERY); + if (xSpreadDoc.is()) + { + uno::Reference <beans::XPropertySet> xPropertySet (xSpreadDoc, uno::UNO_QUERY); + if (xPropertySet.is()) + { + uno::Any aAny = ::cppu::bool2any( bCalcAsShown ); + xPropertySet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_CALCASSHOWN)), aAny ); + aAny = ::cppu::bool2any( bIgnoreCase ); + xPropertySet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_IGNORECASE)), aAny ); + aAny = ::cppu::bool2any( bLookUpLabels ); + xPropertySet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_LOOKUPLABELS)), aAny ); + aAny = ::cppu::bool2any( bMatchWholeCell ); + xPropertySet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_MATCHWHOLE)), aAny ); + aAny = ::cppu::bool2any( bUseRegularExpressions ); + xPropertySet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_REGEXENABLED)), aAny ); + aAny = ::cppu::bool2any( bIsIterationEnabled ); + xPropertySet->setPropertyValue(::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_ITERENABLED)), aAny ); + aAny <<= nIterationCount; + xPropertySet->setPropertyValue( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_ITERCOUNT)), aAny); + aAny <<= fIterationEpsilon; + xPropertySet->setPropertyValue( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_ITEREPSILON)), aAny); + aAny <<= aNullDate; + xPropertySet->setPropertyValue( ::rtl::OUString(RTL_CONSTASCII_USTRINGPARAM(SC_UNO_NULLDATE)), aAny); + 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++ ) + { + ::rtl::OUString sAttrName = xAttrList->getNameByIndex( i ); + ::rtl::OUString aLocalName; + sal_uInt16 nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName( + sAttrName, &aLocalName ); + ::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++ ) + { + ::rtl::OUString sAttrName = xAttrList->getNameByIndex( i ); + ::rtl::OUString aLocalName; + sal_uInt16 nPrefix = GetScImport().GetNamespaceMap().GetKeyByAttrName( + sAttrName, &aLocalName ); + ::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() +{ +} +} + +/* vim:set shiftwidth=4 softtabstop=4 expandtab: */ |