1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski #include "oox/xls/ooxformulaparser.hxx"
25*b1cdbd2cSJim Jagielski
26*b1cdbd2cSJim Jagielski #include <com/sun/star/uno/XComponentContext.hpp>
27*b1cdbd2cSJim Jagielski #include "oox/xls/formulaparser.hxx"
28*b1cdbd2cSJim Jagielski
29*b1cdbd2cSJim Jagielski namespace oox {
30*b1cdbd2cSJim Jagielski namespace xls {
31*b1cdbd2cSJim Jagielski
32*b1cdbd2cSJim Jagielski // ============================================================================
33*b1cdbd2cSJim Jagielski
34*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::lang;
35*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::sheet;
36*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::table;
37*b1cdbd2cSJim Jagielski using namespace ::com::sun::star::uno;
38*b1cdbd2cSJim Jagielski
39*b1cdbd2cSJim Jagielski using ::rtl::OUString;
40*b1cdbd2cSJim Jagielski
41*b1cdbd2cSJim Jagielski // ============================================================================
42*b1cdbd2cSJim Jagielski
43*b1cdbd2cSJim Jagielski class OOXMLFormulaParserImpl : private FormulaFinalizer
44*b1cdbd2cSJim Jagielski {
45*b1cdbd2cSJim Jagielski public:
46*b1cdbd2cSJim Jagielski explicit OOXMLFormulaParserImpl( const Reference< XMultiServiceFactory >& rxModelFactory );
47*b1cdbd2cSJim Jagielski
48*b1cdbd2cSJim Jagielski Sequence< FormulaToken > parseFormula( const OUString& rFormula, const CellAddress& rReferencePos );
49*b1cdbd2cSJim Jagielski
50*b1cdbd2cSJim Jagielski protected:
51*b1cdbd2cSJim Jagielski virtual const FunctionInfo* resolveBadFuncName( const OUString& rTokenData ) const;
52*b1cdbd2cSJim Jagielski
53*b1cdbd2cSJim Jagielski private:
54*b1cdbd2cSJim Jagielski ApiParserWrapper maApiParser;
55*b1cdbd2cSJim Jagielski };
56*b1cdbd2cSJim Jagielski
57*b1cdbd2cSJim Jagielski // ----------------------------------------------------------------------------
58*b1cdbd2cSJim Jagielski
OOXMLFormulaParserImpl(const Reference<XMultiServiceFactory> & rxModelFactory)59*b1cdbd2cSJim Jagielski OOXMLFormulaParserImpl::OOXMLFormulaParserImpl( const Reference< XMultiServiceFactory >& rxModelFactory ) :
60*b1cdbd2cSJim Jagielski FormulaFinalizer( OpCodeProvider( rxModelFactory, FILTER_OOXML, BIFF_UNKNOWN, true ) ),
61*b1cdbd2cSJim Jagielski maApiParser( rxModelFactory, *this )
62*b1cdbd2cSJim Jagielski {
63*b1cdbd2cSJim Jagielski }
64*b1cdbd2cSJim Jagielski
parseFormula(const OUString & rFormula,const CellAddress & rReferencePos)65*b1cdbd2cSJim Jagielski Sequence< FormulaToken > OOXMLFormulaParserImpl::parseFormula( const OUString& rFormula, const CellAddress& rReferencePos )
66*b1cdbd2cSJim Jagielski {
67*b1cdbd2cSJim Jagielski return finalizeTokenArray( maApiParser.parseFormula( rFormula, rReferencePos ) );
68*b1cdbd2cSJim Jagielski }
69*b1cdbd2cSJim Jagielski
resolveBadFuncName(const OUString & rTokenData) const70*b1cdbd2cSJim Jagielski const FunctionInfo* OOXMLFormulaParserImpl::resolveBadFuncName( const OUString& rTokenData ) const
71*b1cdbd2cSJim Jagielski {
72*b1cdbd2cSJim Jagielski /* Try to parse calls to library functions. The format of such a function
73*b1cdbd2cSJim Jagielski call is assumed to be
74*b1cdbd2cSJim Jagielski "'<path-to-office-install>\Library\<libname>'!<funcname>". */
75*b1cdbd2cSJim Jagielski
76*b1cdbd2cSJim Jagielski // the string has to start with an apostroph (followed by the library URL)
77*b1cdbd2cSJim Jagielski if( (rTokenData.getLength() >= 6) && (rTokenData[ 0 ] == '\'') )
78*b1cdbd2cSJim Jagielski {
79*b1cdbd2cSJim Jagielski // library URL and function name are separated by an exclamation mark
80*b1cdbd2cSJim Jagielski sal_Int32 nExclamPos = rTokenData.lastIndexOf( '!' );
81*b1cdbd2cSJim Jagielski if( (1 < nExclamPos) && (nExclamPos + 1 < rTokenData.getLength()) && (rTokenData[ nExclamPos - 1 ] == '\'') )
82*b1cdbd2cSJim Jagielski {
83*b1cdbd2cSJim Jagielski // find the last backslash that separates library path and name
84*b1cdbd2cSJim Jagielski sal_Int32 nFileSep = rTokenData.lastIndexOf( '\\', nExclamPos - 2 );
85*b1cdbd2cSJim Jagielski if( nFileSep > 1 )
86*b1cdbd2cSJim Jagielski {
87*b1cdbd2cSJim Jagielski // find preceding backslash that separates the last directory name
88*b1cdbd2cSJim Jagielski sal_Int32 nDirSep = rTokenData.lastIndexOf( '\\', nFileSep - 1 );
89*b1cdbd2cSJim Jagielski // function library is located in a directory called 'library'
90*b1cdbd2cSJim Jagielski if( (nDirSep > 0) && rTokenData.matchIgnoreAsciiCaseAsciiL( RTL_CONSTASCII_STRINGPARAM( "\\LIBRARY\\" ), nDirSep ) )
91*b1cdbd2cSJim Jagielski {
92*b1cdbd2cSJim Jagielski // try to find a function info for the function name
93*b1cdbd2cSJim Jagielski OUString aFuncName = rTokenData.copy( nExclamPos + 1 ).toAsciiUpperCase();
94*b1cdbd2cSJim Jagielski const FunctionInfo* pFuncInfo = getFuncInfoFromOoxFuncName( aFuncName );
95*b1cdbd2cSJim Jagielski if( pFuncInfo && (pFuncInfo->meFuncLibType != FUNCLIB_UNKNOWN) )
96*b1cdbd2cSJim Jagielski {
97*b1cdbd2cSJim Jagielski // check that the name of the library matches
98*b1cdbd2cSJim Jagielski OUString aLibName = rTokenData.copy( nFileSep + 1, nExclamPos - nFileSep - 2 );
99*b1cdbd2cSJim Jagielski if( pFuncInfo->meFuncLibType == getFuncLibTypeFromLibraryName( aLibName ) )
100*b1cdbd2cSJim Jagielski return pFuncInfo;
101*b1cdbd2cSJim Jagielski }
102*b1cdbd2cSJim Jagielski }
103*b1cdbd2cSJim Jagielski }
104*b1cdbd2cSJim Jagielski }
105*b1cdbd2cSJim Jagielski }
106*b1cdbd2cSJim Jagielski return 0;
107*b1cdbd2cSJim Jagielski }
108*b1cdbd2cSJim Jagielski
109*b1cdbd2cSJim Jagielski // ============================================================================
110*b1cdbd2cSJim Jagielski
111*b1cdbd2cSJim Jagielski class OOXMLFormulaPrinterImpl : public OpCodeProvider
112*b1cdbd2cSJim Jagielski {
113*b1cdbd2cSJim Jagielski public:
114*b1cdbd2cSJim Jagielski explicit OOXMLFormulaPrinterImpl( const Reference< XMultiServiceFactory >& rxModelFactory );
115*b1cdbd2cSJim Jagielski
116*b1cdbd2cSJim Jagielski private:
117*b1cdbd2cSJim Jagielski ApiParserWrapper maApiParser;
118*b1cdbd2cSJim Jagielski };
119*b1cdbd2cSJim Jagielski
120*b1cdbd2cSJim Jagielski // ----------------------------------------------------------------------------
121*b1cdbd2cSJim Jagielski
OOXMLFormulaPrinterImpl(const Reference<XMultiServiceFactory> & rxModelFactory)122*b1cdbd2cSJim Jagielski OOXMLFormulaPrinterImpl::OOXMLFormulaPrinterImpl( const Reference< XMultiServiceFactory >& rxModelFactory ) :
123*b1cdbd2cSJim Jagielski OpCodeProvider( rxModelFactory, FILTER_OOXML, BIFF_UNKNOWN, false ),
124*b1cdbd2cSJim Jagielski maApiParser( rxModelFactory, *this )
125*b1cdbd2cSJim Jagielski {
126*b1cdbd2cSJim Jagielski }
127*b1cdbd2cSJim Jagielski
128*b1cdbd2cSJim Jagielski // ============================================================================
129*b1cdbd2cSJim Jagielski
OOXMLFormulaParser_getSupportedServiceNames()130*b1cdbd2cSJim Jagielski Sequence< OUString > OOXMLFormulaParser_getSupportedServiceNames()
131*b1cdbd2cSJim Jagielski {
132*b1cdbd2cSJim Jagielski Sequence< OUString > aServiceNames( 1 );
133*b1cdbd2cSJim Jagielski aServiceNames[ 0 ] = CREATE_OUSTRING( "com.sun.star.sheet.FilterFormulaParser" );
134*b1cdbd2cSJim Jagielski return aServiceNames;
135*b1cdbd2cSJim Jagielski }
136*b1cdbd2cSJim Jagielski
OOXMLFormulaParser_getImplementationName()137*b1cdbd2cSJim Jagielski OUString OOXMLFormulaParser_getImplementationName()
138*b1cdbd2cSJim Jagielski {
139*b1cdbd2cSJim Jagielski return CREATE_OUSTRING( "com.sun.star.comp.oox.xls.FormulaParser" );
140*b1cdbd2cSJim Jagielski }
141*b1cdbd2cSJim Jagielski
OOXMLFormulaParser_createInstance(const Reference<XComponentContext> &)142*b1cdbd2cSJim Jagielski Reference< XInterface > SAL_CALL OOXMLFormulaParser_createInstance( const Reference< XComponentContext >& ) throw( Exception )
143*b1cdbd2cSJim Jagielski {
144*b1cdbd2cSJim Jagielski return static_cast< ::cppu::OWeakObject* >( new OOXMLFormulaParser );
145*b1cdbd2cSJim Jagielski }
146*b1cdbd2cSJim Jagielski
147*b1cdbd2cSJim Jagielski // ============================================================================
148*b1cdbd2cSJim Jagielski
OOXMLFormulaParser()149*b1cdbd2cSJim Jagielski OOXMLFormulaParser::OOXMLFormulaParser()
150*b1cdbd2cSJim Jagielski {
151*b1cdbd2cSJim Jagielski }
152*b1cdbd2cSJim Jagielski
~OOXMLFormulaParser()153*b1cdbd2cSJim Jagielski OOXMLFormulaParser::~OOXMLFormulaParser()
154*b1cdbd2cSJim Jagielski {
155*b1cdbd2cSJim Jagielski }
156*b1cdbd2cSJim Jagielski
157*b1cdbd2cSJim Jagielski // com.sun.star.lang.XServiceInfo interface -----------------------------------
158*b1cdbd2cSJim Jagielski
getImplementationName()159*b1cdbd2cSJim Jagielski OUString SAL_CALL OOXMLFormulaParser::getImplementationName() throw( RuntimeException )
160*b1cdbd2cSJim Jagielski {
161*b1cdbd2cSJim Jagielski return OOXMLFormulaParser_getImplementationName();
162*b1cdbd2cSJim Jagielski }
163*b1cdbd2cSJim Jagielski
supportsService(const OUString & rService)164*b1cdbd2cSJim Jagielski sal_Bool SAL_CALL OOXMLFormulaParser::supportsService( const OUString& rService ) throw( RuntimeException )
165*b1cdbd2cSJim Jagielski {
166*b1cdbd2cSJim Jagielski const Sequence< OUString > aServices( OOXMLFormulaParser_getSupportedServiceNames() );
167*b1cdbd2cSJim Jagielski const OUString* pArray = aServices.getConstArray();
168*b1cdbd2cSJim Jagielski const OUString* pArrayEnd = pArray + aServices.getLength();
169*b1cdbd2cSJim Jagielski return ::std::find( pArray, pArrayEnd, rService ) != pArrayEnd;
170*b1cdbd2cSJim Jagielski }
171*b1cdbd2cSJim Jagielski
getSupportedServiceNames()172*b1cdbd2cSJim Jagielski Sequence< OUString > SAL_CALL OOXMLFormulaParser::getSupportedServiceNames() throw( RuntimeException )
173*b1cdbd2cSJim Jagielski {
174*b1cdbd2cSJim Jagielski return OOXMLFormulaParser_getSupportedServiceNames();
175*b1cdbd2cSJim Jagielski }
176*b1cdbd2cSJim Jagielski
177*b1cdbd2cSJim Jagielski // com.sun.star.lang.XInitialization interface --------------------------------
178*b1cdbd2cSJim Jagielski
initialize(const Sequence<Any> & rArgs)179*b1cdbd2cSJim Jagielski void SAL_CALL OOXMLFormulaParser::initialize( const Sequence< Any >& rArgs ) throw( Exception, RuntimeException )
180*b1cdbd2cSJim Jagielski {
181*b1cdbd2cSJim Jagielski OSL_ENSURE( rArgs.hasElements(), "OOXMLFormulaParser::initialize - missing arguments" );
182*b1cdbd2cSJim Jagielski if( !rArgs.hasElements() )
183*b1cdbd2cSJim Jagielski throw RuntimeException();
184*b1cdbd2cSJim Jagielski mxComponent.set( rArgs[ 0 ], UNO_QUERY_THROW );
185*b1cdbd2cSJim Jagielski }
186*b1cdbd2cSJim Jagielski
187*b1cdbd2cSJim Jagielski // com.sun.star.sheet.XFilterFormulaParser interface --------------------------
188*b1cdbd2cSJim Jagielski
getSupportedNamespace()189*b1cdbd2cSJim Jagielski OUString SAL_CALL OOXMLFormulaParser::getSupportedNamespace() throw( RuntimeException )
190*b1cdbd2cSJim Jagielski {
191*b1cdbd2cSJim Jagielski return CREATE_OUSTRING( "http://schemas.microsoft.com/office/excel/formula" );
192*b1cdbd2cSJim Jagielski }
193*b1cdbd2cSJim Jagielski
194*b1cdbd2cSJim Jagielski // com.sun.star.sheet.XFormulaParser interface --------------------------------
195*b1cdbd2cSJim Jagielski
parseFormula(const OUString & rFormula,const CellAddress & rReferencePos)196*b1cdbd2cSJim Jagielski Sequence< FormulaToken > SAL_CALL OOXMLFormulaParser::parseFormula(
197*b1cdbd2cSJim Jagielski const OUString& rFormula, const CellAddress& rReferencePos ) throw( RuntimeException )
198*b1cdbd2cSJim Jagielski {
199*b1cdbd2cSJim Jagielski if( !mxParserImpl )
200*b1cdbd2cSJim Jagielski {
201*b1cdbd2cSJim Jagielski Reference< XMultiServiceFactory > xModelFactory( mxComponent, UNO_QUERY_THROW );
202*b1cdbd2cSJim Jagielski mxParserImpl.reset( new OOXMLFormulaParserImpl( xModelFactory ) );
203*b1cdbd2cSJim Jagielski }
204*b1cdbd2cSJim Jagielski return mxParserImpl->parseFormula( rFormula, rReferencePos );
205*b1cdbd2cSJim Jagielski }
206*b1cdbd2cSJim Jagielski
printFormula(const Sequence<FormulaToken> &,const CellAddress &)207*b1cdbd2cSJim Jagielski OUString SAL_CALL OOXMLFormulaParser::printFormula(
208*b1cdbd2cSJim Jagielski const Sequence< FormulaToken >& /*rTokens*/, const CellAddress& /*rReferencePos*/ ) throw( RuntimeException )
209*b1cdbd2cSJim Jagielski {
210*b1cdbd2cSJim Jagielski // not implemented
211*b1cdbd2cSJim Jagielski throw RuntimeException();
212*b1cdbd2cSJim Jagielski }
213*b1cdbd2cSJim Jagielski
214*b1cdbd2cSJim Jagielski // ============================================================================
215*b1cdbd2cSJim Jagielski
216*b1cdbd2cSJim Jagielski } // namespace xls
217*b1cdbd2cSJim Jagielski } // namespace oox
218