1*ca5ec200SAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3*ca5ec200SAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4*ca5ec200SAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5*ca5ec200SAndrew Rist  * distributed with this work for additional information
6*ca5ec200SAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7*ca5ec200SAndrew Rist  * to you under the Apache License, Version 2.0 (the
8*ca5ec200SAndrew Rist  * "License"); you may not use this file except in compliance
9*ca5ec200SAndrew Rist  * with the License.  You may obtain a copy of the License at
10*ca5ec200SAndrew Rist  *
11*ca5ec200SAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12*ca5ec200SAndrew Rist  *
13*ca5ec200SAndrew Rist  * Unless required by applicable law or agreed to in writing,
14*ca5ec200SAndrew Rist  * software distributed under the License is distributed on an
15*ca5ec200SAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*ca5ec200SAndrew Rist  * KIND, either express or implied.  See the License for the
17*ca5ec200SAndrew Rist  * specific language governing permissions and limitations
18*ca5ec200SAndrew Rist  * under the License.
19*ca5ec200SAndrew Rist  *
20*ca5ec200SAndrew Rist  *************************************************************/
21*ca5ec200SAndrew Rist 
22*ca5ec200SAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir #include "oox/xls/excelchartconverter.hxx"
25cdf0e10cSrcweir 
26cdf0e10cSrcweir #include <com/sun/star/lang/XMultiServiceFactory.hpp>
27cdf0e10cSrcweir #include <com/sun/star/chart2/data/XDataProvider.hpp>
28cdf0e10cSrcweir #include <com/sun/star/chart2/data/XDataReceiver.hpp>
29cdf0e10cSrcweir #include "oox/core/filterbase.hxx"
30cdf0e10cSrcweir #include "oox/drawingml/chart/datasourcemodel.hxx"
31cdf0e10cSrcweir #include "oox/helper/containerhelper.hxx"
32cdf0e10cSrcweir #include "oox/xls/formulaparser.hxx"
33cdf0e10cSrcweir 
34cdf0e10cSrcweir namespace oox {
35cdf0e10cSrcweir namespace xls {
36cdf0e10cSrcweir 
37cdf0e10cSrcweir // ============================================================================
38cdf0e10cSrcweir 
39cdf0e10cSrcweir using namespace ::com::sun::star::chart2;
40cdf0e10cSrcweir using namespace ::com::sun::star::chart2::data;
41cdf0e10cSrcweir using namespace ::com::sun::star::lang;
42cdf0e10cSrcweir using namespace ::com::sun::star::table;
43cdf0e10cSrcweir using namespace ::com::sun::star::uno;
44cdf0e10cSrcweir 
45cdf0e10cSrcweir using ::oox::drawingml::chart::DataSequenceModel;
46cdf0e10cSrcweir using ::rtl::OUString;
47cdf0e10cSrcweir 
48cdf0e10cSrcweir // ============================================================================
49cdf0e10cSrcweir 
ExcelChartConverter(const WorkbookHelper & rHelper)50cdf0e10cSrcweir ExcelChartConverter::ExcelChartConverter( const WorkbookHelper& rHelper ) :
51cdf0e10cSrcweir     WorkbookHelper( rHelper )
52cdf0e10cSrcweir {
53cdf0e10cSrcweir }
54cdf0e10cSrcweir 
~ExcelChartConverter()55cdf0e10cSrcweir ExcelChartConverter::~ExcelChartConverter()
56cdf0e10cSrcweir {
57cdf0e10cSrcweir }
58cdf0e10cSrcweir 
createDataProvider(const Reference<XChartDocument> & rxChartDoc)59cdf0e10cSrcweir void ExcelChartConverter::createDataProvider( const Reference< XChartDocument >& rxChartDoc )
60cdf0e10cSrcweir {
61cdf0e10cSrcweir     try
62cdf0e10cSrcweir     {
63cdf0e10cSrcweir         Reference< XDataReceiver > xDataRec( rxChartDoc, UNO_QUERY_THROW );
64cdf0e10cSrcweir         Reference< XDataProvider > xDataProv( getBaseFilter().getModelFactory()->createInstance(
65cdf0e10cSrcweir             CREATE_OUSTRING( "com.sun.star.chart2.data.DataProvider" ) ), UNO_QUERY_THROW );
66cdf0e10cSrcweir         xDataRec->attachDataProvider( xDataProv );
67cdf0e10cSrcweir     }
68cdf0e10cSrcweir     catch( Exception& )
69cdf0e10cSrcweir     {
70cdf0e10cSrcweir     }
71cdf0e10cSrcweir }
72cdf0e10cSrcweir 
createDataSequence(const Reference<XDataProvider> & rxDataProvider,const DataSequenceModel & rDataSeq)73cdf0e10cSrcweir Reference< XDataSequence > ExcelChartConverter::createDataSequence(
74cdf0e10cSrcweir         const Reference< XDataProvider >& rxDataProvider, const DataSequenceModel& rDataSeq )
75cdf0e10cSrcweir {
76cdf0e10cSrcweir     Reference< XDataSequence > xDataSeq;
77cdf0e10cSrcweir     if( rxDataProvider.is() )
78cdf0e10cSrcweir     {
79cdf0e10cSrcweir         OUString aRangeRep;
80cdf0e10cSrcweir         if( rDataSeq.maFormula.getLength() > 0 )
81cdf0e10cSrcweir         {
82cdf0e10cSrcweir             // parse the formula string, create a token sequence
83cdf0e10cSrcweir             FormulaParser& rParser = getFormulaParser();
84cdf0e10cSrcweir             CellAddress aBaseAddr( getCurrentSheetIndex(), 0, 0 );
85cdf0e10cSrcweir             ApiTokenSequence aTokens = rParser.importFormula( aBaseAddr, rDataSeq.maFormula );
86cdf0e10cSrcweir 
87cdf0e10cSrcweir             // create a range list from the token sequence
88cdf0e10cSrcweir             ApiCellRangeList aRanges;
89cdf0e10cSrcweir             rParser.extractCellRangeList( aRanges, aTokens, false );
90cdf0e10cSrcweir             aRangeRep = rParser.generateApiRangeListString( aRanges );
91cdf0e10cSrcweir         }
92cdf0e10cSrcweir         else if( !rDataSeq.maData.empty() )
93cdf0e10cSrcweir         {
94cdf0e10cSrcweir             // create a single-row array from constant source data
95cdf0e10cSrcweir             Matrix< Any > aMatrix( rDataSeq.maData.size(), 1 );
96cdf0e10cSrcweir             Matrix< Any >::iterator aMIt = aMatrix.begin();
97cdf0e10cSrcweir             // TODO: how to handle missing values in the map?
98cdf0e10cSrcweir             for( DataSequenceModel::AnyMap::const_iterator aDIt = rDataSeq.maData.begin(), aDEnd = rDataSeq.maData.end(); aDIt != aDEnd; ++aDIt, ++aMIt )
99cdf0e10cSrcweir                 *aMIt = aDIt->second;
100cdf0e10cSrcweir             aRangeRep = FormulaProcessorBase::generateApiArray( aMatrix );
101cdf0e10cSrcweir         }
102cdf0e10cSrcweir 
103cdf0e10cSrcweir         if( aRangeRep.getLength() > 0 ) try
104cdf0e10cSrcweir         {
105cdf0e10cSrcweir             // create the data sequence
106cdf0e10cSrcweir             xDataSeq = rxDataProvider->createDataSequenceByRangeRepresentation( aRangeRep );
107cdf0e10cSrcweir         }
108cdf0e10cSrcweir         catch( Exception& )
109cdf0e10cSrcweir         {
110cdf0e10cSrcweir             OSL_ENSURE( false, "ExcelChartConverter::createDataSequence - cannot create data sequence" );
111cdf0e10cSrcweir         }
112cdf0e10cSrcweir     }
113cdf0e10cSrcweir     return xDataSeq;
114cdf0e10cSrcweir }
115cdf0e10cSrcweir 
116cdf0e10cSrcweir // ============================================================================
117cdf0e10cSrcweir 
118cdf0e10cSrcweir } // namespace xls
119cdf0e10cSrcweir } // namespace oox
120