/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */ /* * This file is part of the LibreOffice project. * * This Source Code Form is subject to the terms of the Mozilla Public * License, v. 2.0. If a copy of the MPL was not distributed with this * file, You can obtain one at http://mozilla.org/MPL/2.0/. * * This file incorporates work covered by the following license notice: * * Licensed to the Apache Software Foundation (ASF) under one or more * contributor license agreements. See the NOTICE file distributed * with this work for additional information regarding copyright * ownership. The ASF licenses this file to you under the Apache * License, Version 2.0 (the "License"); you may not use this file * except in compliance with the License. You may obtain a copy of * the License at http://www.apache.org/licenses/LICENSE-2.0 . */ #include "tokenuno.hxx" #include #include #include #include #include #include #include #include #include #include "miscuno.hxx" #include "convuno.hxx" #include "unonames.hxx" #include "token.hxx" #include "compiler.hxx" #include "tokenarray.hxx" #include "docsh.hxx" #include "rangeseq.hxx" #include "externalrefmgr.hxx" using namespace ::formula; using namespace ::com::sun::star; static const SfxItemPropertyMapEntry* lcl_GetFormulaParserMap() { static const SfxItemPropertyMapEntry aFormulaParserMap_Impl[] = { {OUString(SC_UNO_COMPILEFAP), 0, getBooleanCppuType(), 0, 0 }, {OUString(SC_UNO_COMPILEENGLISH), 0, getBooleanCppuType(), 0, 0 }, {OUString(SC_UNO_IGNORELEADING), 0, getBooleanCppuType(), 0, 0 }, {OUString(SC_UNO_FORMULACONVENTION), 0, getCppuType(&sheet::AddressConvention::UNSPECIFIED), 0, 0 }, {OUString(SC_UNO_OPCODEMAP), 0, getCppuType((uno::Sequence< sheet::FormulaOpCodeMapEntry >*)0), 0, 0 }, { OUString(), 0, css::uno::Type(), 0, 0 } }; return aFormulaParserMap_Impl; } SC_SIMPLE_SERVICE_INFO( ScFormulaParserObj, "ScFormulaParserObj", SC_SERVICENAME_FORMULAPARS ) ScFormulaParserObj::ScFormulaParserObj(ScDocShell* pDocSh) : mpDocShell( pDocSh ), mnConv( sheet::AddressConvention::UNSPECIFIED ), mbEnglish( false ), mbIgnoreSpaces( true ), mbCompileFAP( false ) { mpDocShell->GetDocument()->AddUnoObject(*this); } ScFormulaParserObj::~ScFormulaParserObj() { if (mpDocShell) mpDocShell->GetDocument()->RemoveUnoObject(*this); } void ScFormulaParserObj::Notify( SfxBroadcaster&, const SfxHint& rHint ) { if ( rHint.ISA( SfxSimpleHint ) && ((const SfxSimpleHint&)rHint).GetId() == SFX_HINT_DYING ) mpDocShell = NULL; } // XFormulaParser void ScFormulaParserObj::SetCompilerFlags( ScCompiler& rCompiler ) const { static const formula::FormulaGrammar::AddressConvention aConvMap[] = { formula::FormulaGrammar::CONV_OOO, // <- AddressConvention::OOO formula::FormulaGrammar::CONV_XL_A1, // <- AddressConvention::XL_A1 formula::FormulaGrammar::CONV_XL_R1C1, // <- AddressConvention::XL_R1C1 formula::FormulaGrammar::CONV_XL_OOX, // <- AddressConvention::XL_OOX formula::FormulaGrammar::CONV_LOTUS_A1 // <- AddressConvention::LOTUS_A1 }; static const sal_Int16 nConvMapCount = sizeof(aConvMap)/sizeof(aConvMap[0]); // If mxOpCodeMap is not empty it overrides mbEnglish, and vice versa. We // don't need to initialize things twice. if (mxOpCodeMap.get()) rCompiler.SetFormulaLanguage( mxOpCodeMap ); else { sal_Int32 nFormulaLanguage = mbEnglish ? sheet::FormulaLanguage::ENGLISH : sheet::FormulaLanguage::NATIVE; ScCompiler::OpCodeMapPtr xMap = rCompiler.GetOpCodeMap( nFormulaLanguage); rCompiler.SetFormulaLanguage( xMap); } formula::FormulaGrammar::AddressConvention eConv = formula::FormulaGrammar::CONV_UNSPECIFIED; if (mnConv >= 0 && mnConv < nConvMapCount) eConv = aConvMap[mnConv]; rCompiler.SetRefConvention( eConv ); rCompiler.SetCompileForFAP(mbCompileFAP); rCompiler.SetExternalLinks( maExternalLinks); } uno::Sequence SAL_CALL ScFormulaParserObj::parseFormula( const OUString& aFormula, const table::CellAddress& rReferencePos ) throw (uno::RuntimeException, std::exception) { SolarMutexGuard aGuard; uno::Sequence aRet; if (mpDocShell) { ScDocument* pDoc = mpDocShell->GetDocument(); ScExternalRefManager::ApiGuard aExtRefGuard(pDoc); ScAddress aRefPos( ScAddress::UNINITIALIZED ); ScUnoConversion::FillScAddress( aRefPos, rReferencePos ); ScCompiler aCompiler( pDoc, aRefPos); aCompiler.SetGrammar(pDoc->GetGrammar()); SetCompilerFlags( aCompiler ); ScTokenArray* pCode = aCompiler.CompileString( aFormula ); (void)ScTokenConversion::ConvertToTokenSequence( *pDoc, aRet, *pCode ); delete pCode; } return aRet; } OUString SAL_CALL ScFormulaParserObj::printFormula( const uno::Sequence& aTokens, const table::CellAddress& rReferencePos ) throw (uno::RuntimeException, std::exception) { SolarMutexGuard aGuard; OUString aRet; if (mpDocShell) { ScDocument* pDoc = mpDocShell->GetDocument(); ScTokenArray aCode; (void)ScTokenConversion::ConvertToTokenArray( *pDoc, aCode, aTokens ); ScAddress aRefPos( ScAddress::UNINITIALIZED ); ScUnoConversion::FillScAddress( aRefPos, rReferencePos ); ScCompiler aCompiler( pDoc, aRefPos, aCode); aCompiler.SetGrammar(pDoc->GetGrammar()); SetCompilerFlags( aCompiler ); OUStringBuffer aBuffer; aCompiler.CreateStringFromTokenArray( aBuffer ); aRet = aBuffer.makeStringAndClear(); } return aRet; } // XPropertySet uno::Reference SAL_CALL ScFormulaParserObj::getPropertySetInfo() throw(uno::RuntimeException, std::exception) { SolarMutexGuard aGuard; static uno::Reference< beans::XPropertySetInfo > aRef(new SfxItemPropertySetInfo( lcl_GetFormulaParserMap() )); return aRef; } void SAL_CALL ScFormulaParserObj::setPropertyValue( const OUString& aPropertyName, const uno::Any& aValue ) throw(beans::UnknownPropertyException, beans::PropertyVetoException, lang::IllegalArgumentException, lang::WrappedTargetException, uno::RuntimeException, std::exception) { SolarMutexGuard aGuard; OUString aString(aPropertyName); if ( aString.equalsAscii( SC_UNO_COMPILEFAP ) ) { aValue >>= mbCompileFAP; } else if ( aString.equalsAscii( SC_UNO_COMPILEENGLISH ) ) { bool bOldEnglish = mbEnglish; if (aValue >>= mbEnglish) { // Need to recreate the symbol map to change English property // because the map is const. So for performance reasons set // CompileEnglish _before_ OpCodeMap! if (mxOpCodeMap.get() && mbEnglish != bOldEnglish) { ScDocument* pDoc = mpDocShell->GetDocument(); ScCompiler aCompiler( pDoc, ScAddress()); aCompiler.SetGrammar(pDoc->GetGrammar()); mxOpCodeMap = aCompiler.CreateOpCodeMap( maOpCodeMapping, mbEnglish); } } else throw lang::IllegalArgumentException(); } else if ( aString.equalsAscii( SC_UNO_FORMULACONVENTION ) ) { aValue >>= mnConv; } else if ( aString.equalsAscii( SC_UNO_IGNORELEADING ) ) { aValue >>= mbIgnoreSpaces; } else if ( aString.equalsAscii( SC_UNO_OPCODEMAP ) ) { if (aValue >>= maOpCodeMapping) { ScDocument* pDoc = mpDocShell->GetDocument(); ScCompiler aCompiler( pDoc, ScAddress()); aCompiler.SetGrammar(pDoc->GetGrammar()); mxOpCodeMap = aCompiler.CreateOpCodeMap( maOpCodeMapping, mbEnglish); } else throw lang::IllegalArgumentException(); } else if ( aString.equalsAscii( SC_UNO_EXTERNALLINKS ) ) { if (!(aValue >>= maExternalLinks)) throw lang::IllegalArgumentException(); } else throw beans::UnknownPropertyException(); } uno::Any SAL_CALL ScFormulaParserObj::getPropertyValue( const OUString& aPropertyName ) throw(beans::UnknownPropertyException, lang::WrappedTargetException, uno::RuntimeException, std::exception) { SolarMutexGuard aGuard; uno::Any aRet; OUString aString(aPropertyName); if ( aString.equalsAscii( SC_UNO_COMPILEFAP ) ) { aRet <<= mbCompileFAP; } else if ( aString.equalsAscii( SC_UNO_COMPILEENGLISH ) ) { aRet <<= mbEnglish; } else if ( aString.equalsAscii( SC_UNO_FORMULACONVENTION ) ) { aRet <<= mnConv; } else if ( aString.equalsAscii( SC_UNO_IGNORELEADING ) ) { aRet <<= mbIgnoreSpaces; } else if ( aString.equalsAscii( SC_UNO_OPCODEMAP ) ) { aRet <<= maOpCodeMapping; } else if ( aString.equalsAscii( SC_UNO_EXTERNALLINKS ) ) { aRet <<= maExternalLinks; } else throw beans::UnknownPropertyException(); return aRet; } SC_IMPL_DUMMY_PROPERTY_LISTENER( ScFormulaParserObj ) static void lcl_ExternalRefToApi( sheet::SingleReference& rAPI, const ScSingleRefData& rRef ) { rAPI.Column = 0; rAPI.Row = 0; rAPI.Sheet = 0; rAPI.RelativeColumn = 0; rAPI.RelativeRow = 0; rAPI.RelativeSheet = 0; sal_Int32 nFlags = 0; if ( rRef.IsColRel() ) { nFlags |= sheet::ReferenceFlags::COLUMN_RELATIVE; rAPI.RelativeColumn = rRef.Col(); } else rAPI.Column = rRef.Col(); if ( rRef.IsRowRel() ) { nFlags |= sheet::ReferenceFlags::ROW_RELATIVE; rAPI.RelativeRow = rRef.Row(); } else rAPI.Row = rRef.Row(); if ( rRef.IsColDeleted() ) nFlags |= sheet::ReferenceFlags::COLUMN_DELETED; if ( rRef.IsRowDeleted() ) nFlags |= sheet::ReferenceFlags::ROW_DELETED; if ( rRef.IsFlag3D() ) nFlags |= sheet::ReferenceFlags::SHEET_3D; if ( rRef.IsRelName() ) nFlags |= sheet::ReferenceFlags::RELATIVE_NAME; rAPI.Flags = nFlags; } static void lcl_SingleRefToApi( sheet::SingleReference& rAPI, const ScSingleRefData& rRef ) { sal_Int32 nFlags = 0; if ( rRef.IsColRel() ) { nFlags |= sheet::ReferenceFlags::COLUMN_RELATIVE; rAPI.RelativeColumn = rRef.Col(); rAPI.Column = 0; } else { rAPI.RelativeColumn = 0; rAPI.Column = rRef.Col(); } if ( rRef.IsRowRel() ) { nFlags |= sheet::ReferenceFlags::ROW_RELATIVE; rAPI.RelativeRow = rRef.Row(); rAPI.Row = 0; } else { rAPI.RelativeRow = 0; rAPI.Row = rRef.Row(); } if ( rRef.IsTabRel() ) { nFlags |= sheet::ReferenceFlags::SHEET_RELATIVE; rAPI.RelativeSheet = rRef.Tab(); rAPI.Sheet = 0; } else { rAPI.RelativeSheet = 0; rAPI.Sheet = rRef.Tab(); } if ( rRef.IsColDeleted() ) nFlags |= sheet::ReferenceFlags::COLUMN_DELETED; if ( rRef.IsRowDeleted() ) nFlags |= sheet::ReferenceFlags::ROW_DELETED; if ( rRef.IsTabDeleted() ) nFlags |= sheet::ReferenceFlags::SHEET_DELETED; if ( rRef.IsFlag3D() ) nFlags |= sheet::ReferenceFlags::SHEET_3D; if ( rRef.IsRelName() ) nFlags |= sheet::ReferenceFlags::RELATIVE_NAME; rAPI.Flags = nFlags; } bool ScTokenConversion::ConvertToTokenArray( ScDocument& rDoc, ScTokenArray& rTokenArray, const uno::Sequence& rSequence ) { return !rTokenArray.Fill(rSequence,rDoc.GetExternalRefManager()); } bool ScTokenConversion::ConvertToTokenSequence( const ScDocument& rDoc, uno::Sequence& rSequence, const ScTokenArray& rTokenArray ) { bool bError = false; sal_Int32 nLen = static_cast(rTokenArray.GetLen()); formula::FormulaToken** pTokens = rTokenArray.GetArray(); if ( pTokens ) { rSequence.realloc(nLen); for (sal_Int32 nPos=0; nPos(rToken).GetSingleRef() ); rAPI.Data <<= aSingleRef; } break; case formula::svDoubleRef: { sheet::ComplexReference aCompRef; lcl_SingleRefToApi( aCompRef.Reference1, static_cast(rToken).GetSingleRef() ); lcl_SingleRefToApi( aCompRef.Reference2, static_cast(rToken).GetSingleRef2() ); rAPI.Data <<= aCompRef; } break; case svIndex: { sheet::NameToken aNameToken; aNameToken.Index = static_cast( rToken.GetIndex() ); aNameToken.Global = static_cast( rToken.IsGlobal() ); rAPI.Data <<= aNameToken; } break; case svMatrix: if (!ScRangeToSequence::FillMixedArray( rAPI.Data, static_cast(rToken).GetMatrix(), true)) rAPI.Data.clear(); break; case svExternalSingleRef: { sheet::SingleReference aSingleRef; lcl_ExternalRefToApi( aSingleRef, static_cast(rToken).GetSingleRef() ); size_t nCacheId; rDoc.GetExternalRefManager()->getCacheTable( rToken.GetIndex(), rToken.GetString().getString(), false, &nCacheId); aSingleRef.Sheet = static_cast< sal_Int32 >( nCacheId ); sheet::ExternalReference aExtRef; aExtRef.Index = rToken.GetIndex(); aExtRef.Reference <<= aSingleRef; rAPI.Data <<= aExtRef; eOpCode = ocPush; } break; case svExternalDoubleRef: { sheet::ComplexReference aComplRef; lcl_ExternalRefToApi( aComplRef.Reference1, static_cast(rToken).GetSingleRef() ); lcl_ExternalRefToApi( aComplRef.Reference2, static_cast(rToken).GetSingleRef2() ); size_t nCacheId; rDoc.GetExternalRefManager()->getCacheTable( rToken.GetIndex(), rToken.GetString().getString(), false, &nCacheId); aComplRef.Reference1.Sheet = static_cast< sal_Int32 >( nCacheId ); // NOTE: This assumes that cached sheets are in consecutive order! aComplRef.Reference2.Sheet = aComplRef.Reference1.Sheet + (static_cast(rToken).GetSingleRef2().Tab() - static_cast(rToken).GetSingleRef().Tab()); sheet::ExternalReference aExtRef; aExtRef.Index = rToken.GetIndex(); aExtRef.Reference <<= aComplRef; rAPI.Data <<= aExtRef; eOpCode = ocPush; } break; case svExternalName: { sheet::ExternalReference aExtRef; aExtRef.Index = rToken.GetIndex(); aExtRef.Reference <<= rToken.GetString().getString(); rAPI.Data <<= aExtRef; eOpCode = ocPush; } break; default: OSL_TRACE( "ScTokenConversion::ConvertToTokenSequence: unhandled token type SvStackVar %d", rToken.GetType()); case svSep: // occurs with ocSep, ocOpen, ocClose, ocArray* case svJump: // occurs with ocIf, ocChose case svMissing: // occurs with ocMissing rAPI.Data.clear(); // no data } rAPI.OpCode = static_cast(eOpCode); //! assuming equal values for the moment } } else rSequence.realloc(0); return !bError; } SAL_WNODEPRECATED_DECLARATIONS_PUSH ScFormulaOpCodeMapperObj::ScFormulaOpCodeMapperObj(::std::auto_ptr _pCompiler) : formula::FormulaOpCodeMapperObj(_pCompiler) { } SAL_WNODEPRECATED_DECLARATIONS_POP /* vim:set shiftwidth=4 softtabstop=4 expandtab: */