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