1*cdf0e10cSrcweir /*************************************************************************
2*cdf0e10cSrcweir  *
3*cdf0e10cSrcweir  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4*cdf0e10cSrcweir  *
5*cdf0e10cSrcweir  * Copyright 2000, 2010 Oracle and/or its affiliates.
6*cdf0e10cSrcweir  *
7*cdf0e10cSrcweir  * OpenOffice.org - a multi-platform office productivity suite
8*cdf0e10cSrcweir  *
9*cdf0e10cSrcweir  * This file is part of OpenOffice.org.
10*cdf0e10cSrcweir  *
11*cdf0e10cSrcweir  * OpenOffice.org is free software: you can redistribute it and/or modify
12*cdf0e10cSrcweir  * it under the terms of the GNU Lesser General Public License version 3
13*cdf0e10cSrcweir  * only, as published by the Free Software Foundation.
14*cdf0e10cSrcweir  *
15*cdf0e10cSrcweir  * OpenOffice.org is distributed in the hope that it will be useful,
16*cdf0e10cSrcweir  * but WITHOUT ANY WARRANTY; without even the implied warranty of
17*cdf0e10cSrcweir  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
18*cdf0e10cSrcweir  * GNU Lesser General Public License version 3 for more details
19*cdf0e10cSrcweir  * (a copy is included in the LICENSE file that accompanied this code).
20*cdf0e10cSrcweir  *
21*cdf0e10cSrcweir  * You should have received a copy of the GNU Lesser General Public License
22*cdf0e10cSrcweir  * version 3 along with OpenOffice.org.  If not, see
23*cdf0e10cSrcweir  * <http://www.openoffice.org/license.html>
24*cdf0e10cSrcweir  * for a copy of the LGPLv3 License.
25*cdf0e10cSrcweir  *
26*cdf0e10cSrcweir  ************************************************************************/
27*cdf0e10cSrcweir 
28*cdf0e10cSrcweir #include "oox/xls/excelchartconverter.hxx"
29*cdf0e10cSrcweir 
30*cdf0e10cSrcweir #include <com/sun/star/lang/XMultiServiceFactory.hpp>
31*cdf0e10cSrcweir #include <com/sun/star/chart2/data/XDataProvider.hpp>
32*cdf0e10cSrcweir #include <com/sun/star/chart2/data/XDataReceiver.hpp>
33*cdf0e10cSrcweir #include "oox/core/filterbase.hxx"
34*cdf0e10cSrcweir #include "oox/drawingml/chart/datasourcemodel.hxx"
35*cdf0e10cSrcweir #include "oox/helper/containerhelper.hxx"
36*cdf0e10cSrcweir #include "oox/xls/formulaparser.hxx"
37*cdf0e10cSrcweir 
38*cdf0e10cSrcweir namespace oox {
39*cdf0e10cSrcweir namespace xls {
40*cdf0e10cSrcweir 
41*cdf0e10cSrcweir // ============================================================================
42*cdf0e10cSrcweir 
43*cdf0e10cSrcweir using namespace ::com::sun::star::chart2;
44*cdf0e10cSrcweir using namespace ::com::sun::star::chart2::data;
45*cdf0e10cSrcweir using namespace ::com::sun::star::lang;
46*cdf0e10cSrcweir using namespace ::com::sun::star::table;
47*cdf0e10cSrcweir using namespace ::com::sun::star::uno;
48*cdf0e10cSrcweir 
49*cdf0e10cSrcweir using ::oox::drawingml::chart::DataSequenceModel;
50*cdf0e10cSrcweir using ::rtl::OUString;
51*cdf0e10cSrcweir 
52*cdf0e10cSrcweir // ============================================================================
53*cdf0e10cSrcweir 
54*cdf0e10cSrcweir ExcelChartConverter::ExcelChartConverter( const WorkbookHelper& rHelper ) :
55*cdf0e10cSrcweir     WorkbookHelper( rHelper )
56*cdf0e10cSrcweir {
57*cdf0e10cSrcweir }
58*cdf0e10cSrcweir 
59*cdf0e10cSrcweir ExcelChartConverter::~ExcelChartConverter()
60*cdf0e10cSrcweir {
61*cdf0e10cSrcweir }
62*cdf0e10cSrcweir 
63*cdf0e10cSrcweir void ExcelChartConverter::createDataProvider( const Reference< XChartDocument >& rxChartDoc )
64*cdf0e10cSrcweir {
65*cdf0e10cSrcweir     try
66*cdf0e10cSrcweir     {
67*cdf0e10cSrcweir         Reference< XDataReceiver > xDataRec( rxChartDoc, UNO_QUERY_THROW );
68*cdf0e10cSrcweir         Reference< XDataProvider > xDataProv( getBaseFilter().getModelFactory()->createInstance(
69*cdf0e10cSrcweir             CREATE_OUSTRING( "com.sun.star.chart2.data.DataProvider" ) ), UNO_QUERY_THROW );
70*cdf0e10cSrcweir         xDataRec->attachDataProvider( xDataProv );
71*cdf0e10cSrcweir     }
72*cdf0e10cSrcweir     catch( Exception& )
73*cdf0e10cSrcweir     {
74*cdf0e10cSrcweir     }
75*cdf0e10cSrcweir }
76*cdf0e10cSrcweir 
77*cdf0e10cSrcweir Reference< XDataSequence > ExcelChartConverter::createDataSequence(
78*cdf0e10cSrcweir         const Reference< XDataProvider >& rxDataProvider, const DataSequenceModel& rDataSeq )
79*cdf0e10cSrcweir {
80*cdf0e10cSrcweir     Reference< XDataSequence > xDataSeq;
81*cdf0e10cSrcweir     if( rxDataProvider.is() )
82*cdf0e10cSrcweir     {
83*cdf0e10cSrcweir         OUString aRangeRep;
84*cdf0e10cSrcweir         if( rDataSeq.maFormula.getLength() > 0 )
85*cdf0e10cSrcweir         {
86*cdf0e10cSrcweir             // parse the formula string, create a token sequence
87*cdf0e10cSrcweir             FormulaParser& rParser = getFormulaParser();
88*cdf0e10cSrcweir             CellAddress aBaseAddr( getCurrentSheetIndex(), 0, 0 );
89*cdf0e10cSrcweir             ApiTokenSequence aTokens = rParser.importFormula( aBaseAddr, rDataSeq.maFormula );
90*cdf0e10cSrcweir 
91*cdf0e10cSrcweir             // create a range list from the token sequence
92*cdf0e10cSrcweir             ApiCellRangeList aRanges;
93*cdf0e10cSrcweir             rParser.extractCellRangeList( aRanges, aTokens, false );
94*cdf0e10cSrcweir             aRangeRep = rParser.generateApiRangeListString( aRanges );
95*cdf0e10cSrcweir         }
96*cdf0e10cSrcweir         else if( !rDataSeq.maData.empty() )
97*cdf0e10cSrcweir         {
98*cdf0e10cSrcweir             // create a single-row array from constant source data
99*cdf0e10cSrcweir             Matrix< Any > aMatrix( rDataSeq.maData.size(), 1 );
100*cdf0e10cSrcweir             Matrix< Any >::iterator aMIt = aMatrix.begin();
101*cdf0e10cSrcweir             // TODO: how to handle missing values in the map?
102*cdf0e10cSrcweir             for( DataSequenceModel::AnyMap::const_iterator aDIt = rDataSeq.maData.begin(), aDEnd = rDataSeq.maData.end(); aDIt != aDEnd; ++aDIt, ++aMIt )
103*cdf0e10cSrcweir                 *aMIt = aDIt->second;
104*cdf0e10cSrcweir             aRangeRep = FormulaProcessorBase::generateApiArray( aMatrix );
105*cdf0e10cSrcweir         }
106*cdf0e10cSrcweir 
107*cdf0e10cSrcweir         if( aRangeRep.getLength() > 0 ) try
108*cdf0e10cSrcweir         {
109*cdf0e10cSrcweir             // create the data sequence
110*cdf0e10cSrcweir             xDataSeq = rxDataProvider->createDataSequenceByRangeRepresentation( aRangeRep );
111*cdf0e10cSrcweir         }
112*cdf0e10cSrcweir         catch( Exception& )
113*cdf0e10cSrcweir         {
114*cdf0e10cSrcweir             OSL_ENSURE( false, "ExcelChartConverter::createDataSequence - cannot create data sequence" );
115*cdf0e10cSrcweir         }
116*cdf0e10cSrcweir     }
117*cdf0e10cSrcweir     return xDataSeq;
118*cdf0e10cSrcweir }
119*cdf0e10cSrcweir 
120*cdf0e10cSrcweir // ============================================================================
121*cdf0e10cSrcweir 
122*cdf0e10cSrcweir } // namespace xls
123*cdf0e10cSrcweir } // namespace oox
124