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