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