| /************************************************************** |
| * |
| * 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 |
| * |
| * Unless required by applicable law or agreed to in writing, |
| * software distributed under the License is distributed on an |
| * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY |
| * KIND, either express or implied. See the License for the |
| * specific language governing permissions and limitations |
| * under the License. |
| * |
| *************************************************************/ |
| |
| |
| |
| #include "oox/xls/ooxformulaparser.hxx" |
| |
| #include <com/sun/star/uno/XComponentContext.hpp> |
| #include "oox/xls/formulaparser.hxx" |
| |
| namespace oox { |
| namespace xls { |
| |
| // ============================================================================ |
| |
| using namespace ::com::sun::star::lang; |
| using namespace ::com::sun::star::sheet; |
| using namespace ::com::sun::star::table; |
| using namespace ::com::sun::star::uno; |
| |
| using ::rtl::OUString; |
| |
| // ============================================================================ |
| |
| class OOXMLFormulaParserImpl : private FormulaFinalizer |
| { |
| public: |
| explicit OOXMLFormulaParserImpl( const Reference< XMultiServiceFactory >& rxModelFactory ); |
| |
| Sequence< FormulaToken > parseFormula( const OUString& rFormula, const CellAddress& rReferencePos ); |
| |
| protected: |
| virtual const FunctionInfo* resolveBadFuncName( const OUString& rTokenData ) const; |
| |
| private: |
| ApiParserWrapper maApiParser; |
| }; |
| |
| // ---------------------------------------------------------------------------- |
| |
| OOXMLFormulaParserImpl::OOXMLFormulaParserImpl( const Reference< XMultiServiceFactory >& rxModelFactory ) : |
| FormulaFinalizer( OpCodeProvider( rxModelFactory, FILTER_OOXML, BIFF_UNKNOWN, true ) ), |
| maApiParser( rxModelFactory, *this ) |
| { |
| } |
| |
| Sequence< FormulaToken > OOXMLFormulaParserImpl::parseFormula( const OUString& rFormula, const CellAddress& rReferencePos ) |
| { |
| return finalizeTokenArray( maApiParser.parseFormula( rFormula, rReferencePos ) ); |
| } |
| |
| const FunctionInfo* OOXMLFormulaParserImpl::resolveBadFuncName( const OUString& rTokenData ) const |
| { |
| /* Try to parse calls to library functions. The format of such a function |
| call is assumed to be |
| "'<path-to-office-install>\Library\<libname>'!<funcname>". */ |
| |
| // the string has to start with an apostroph (followed by the library URL) |
| if( (rTokenData.getLength() >= 6) && (rTokenData[ 0 ] == '\'') ) |
| { |
| // library URL and function name are separated by an exclamation mark |
| sal_Int32 nExclamPos = rTokenData.lastIndexOf( '!' ); |
| if( (1 < nExclamPos) && (nExclamPos + 1 < rTokenData.getLength()) && (rTokenData[ nExclamPos - 1 ] == '\'') ) |
| { |
| // find the last backslash that separates library path and name |
| sal_Int32 nFileSep = rTokenData.lastIndexOf( '\\', nExclamPos - 2 ); |
| if( nFileSep > 1 ) |
| { |
| // find preceding backslash that separates the last directory name |
| sal_Int32 nDirSep = rTokenData.lastIndexOf( '\\', nFileSep - 1 ); |
| // function library is located in a directory called 'library' |
| if( (nDirSep > 0) && rTokenData.matchIgnoreAsciiCaseAsciiL( RTL_CONSTASCII_STRINGPARAM( "\\LIBRARY\\" ), nDirSep ) ) |
| { |
| // try to find a function info for the function name |
| OUString aFuncName = rTokenData.copy( nExclamPos + 1 ).toAsciiUpperCase(); |
| const FunctionInfo* pFuncInfo = getFuncInfoFromOoxFuncName( aFuncName ); |
| if( pFuncInfo && (pFuncInfo->meFuncLibType != FUNCLIB_UNKNOWN) ) |
| { |
| // check that the name of the library matches |
| OUString aLibName = rTokenData.copy( nFileSep + 1, nExclamPos - nFileSep - 2 ); |
| if( pFuncInfo->meFuncLibType == getFuncLibTypeFromLibraryName( aLibName ) ) |
| return pFuncInfo; |
| } |
| } |
| } |
| } |
| } |
| return 0; |
| } |
| |
| // ============================================================================ |
| |
| class OOXMLFormulaPrinterImpl : public OpCodeProvider |
| { |
| public: |
| explicit OOXMLFormulaPrinterImpl( const Reference< XMultiServiceFactory >& rxModelFactory ); |
| |
| private: |
| ApiParserWrapper maApiParser; |
| }; |
| |
| // ---------------------------------------------------------------------------- |
| |
| OOXMLFormulaPrinterImpl::OOXMLFormulaPrinterImpl( const Reference< XMultiServiceFactory >& rxModelFactory ) : |
| OpCodeProvider( rxModelFactory, FILTER_OOXML, BIFF_UNKNOWN, false ), |
| maApiParser( rxModelFactory, *this ) |
| { |
| } |
| |
| // ============================================================================ |
| |
| Sequence< OUString > OOXMLFormulaParser_getSupportedServiceNames() |
| { |
| Sequence< OUString > aServiceNames( 1 ); |
| aServiceNames[ 0 ] = CREATE_OUSTRING( "com.sun.star.sheet.FilterFormulaParser" ); |
| return aServiceNames; |
| } |
| |
| OUString OOXMLFormulaParser_getImplementationName() |
| { |
| return CREATE_OUSTRING( "com.sun.star.comp.oox.xls.FormulaParser" ); |
| } |
| |
| Reference< XInterface > SAL_CALL OOXMLFormulaParser_createInstance( const Reference< XComponentContext >& ) throw( Exception ) |
| { |
| return static_cast< ::cppu::OWeakObject* >( new OOXMLFormulaParser ); |
| } |
| |
| // ============================================================================ |
| |
| OOXMLFormulaParser::OOXMLFormulaParser() |
| { |
| } |
| |
| OOXMLFormulaParser::~OOXMLFormulaParser() |
| { |
| } |
| |
| // com.sun.star.lang.XServiceInfo interface ----------------------------------- |
| |
| OUString SAL_CALL OOXMLFormulaParser::getImplementationName() throw( RuntimeException ) |
| { |
| return OOXMLFormulaParser_getImplementationName(); |
| } |
| |
| sal_Bool SAL_CALL OOXMLFormulaParser::supportsService( const OUString& rService ) throw( RuntimeException ) |
| { |
| const Sequence< OUString > aServices( OOXMLFormulaParser_getSupportedServiceNames() ); |
| const OUString* pArray = aServices.getConstArray(); |
| const OUString* pArrayEnd = pArray + aServices.getLength(); |
| return ::std::find( pArray, pArrayEnd, rService ) != pArrayEnd; |
| } |
| |
| Sequence< OUString > SAL_CALL OOXMLFormulaParser::getSupportedServiceNames() throw( RuntimeException ) |
| { |
| return OOXMLFormulaParser_getSupportedServiceNames(); |
| } |
| |
| // com.sun.star.lang.XInitialization interface -------------------------------- |
| |
| void SAL_CALL OOXMLFormulaParser::initialize( const Sequence< Any >& rArgs ) throw( Exception, RuntimeException ) |
| { |
| OSL_ENSURE( rArgs.hasElements(), "OOXMLFormulaParser::initialize - missing arguments" ); |
| if( !rArgs.hasElements() ) |
| throw RuntimeException(); |
| mxComponent.set( rArgs[ 0 ], UNO_QUERY_THROW ); |
| } |
| |
| // com.sun.star.sheet.XFilterFormulaParser interface -------------------------- |
| |
| OUString SAL_CALL OOXMLFormulaParser::getSupportedNamespace() throw( RuntimeException ) |
| { |
| return CREATE_OUSTRING( "http://schemas.microsoft.com/office/excel/formula" ); |
| } |
| |
| // com.sun.star.sheet.XFormulaParser interface -------------------------------- |
| |
| Sequence< FormulaToken > SAL_CALL OOXMLFormulaParser::parseFormula( |
| const OUString& rFormula, const CellAddress& rReferencePos ) throw( RuntimeException ) |
| { |
| if( !mxParserImpl ) |
| { |
| Reference< XMultiServiceFactory > xModelFactory( mxComponent, UNO_QUERY_THROW ); |
| mxParserImpl.reset( new OOXMLFormulaParserImpl( xModelFactory ) ); |
| } |
| return mxParserImpl->parseFormula( rFormula, rReferencePos ); |
| } |
| |
| OUString SAL_CALL OOXMLFormulaParser::printFormula( |
| const Sequence< FormulaToken >& /*rTokens*/, const CellAddress& /*rReferencePos*/ ) throw( RuntimeException ) |
| { |
| // not implemented |
| throw RuntimeException(); |
| } |
| |
| // ============================================================================ |
| |
| } // namespace xls |
| } // namespace oox |