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
124
125
126
127
128
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#include "excelvbaproject.hxx"
#include <list>
#include <set>
#include <com/sun/star/beans/XPropertySet.hpp>
#include <com/sun/star/container/XEnumeration.hpp>
#include <com/sun/star/container/XEnumerationAccess.hpp>
#include <com/sun/star/frame/XModel.hpp>
#include <com/sun/star/script/ModuleType.hpp>
#include <com/sun/star/sheet/XSpreadsheetDocument.hpp>
#include <rtl/ustrbuf.hxx>
#include <oox/helper/helper.hxx>
#include <oox/helper/propertyset.hxx>
#include <oox/token/properties.hxx>
namespace oox {
namespace xls {
using namespace ::com::sun::star::container;
using namespace ::com::sun::star::frame;
using namespace ::com::sun::star::script;
using namespace ::com::sun::star::sheet;
using namespace ::com::sun::star::uno;
ExcelVbaProject::ExcelVbaProject( const Reference< XComponentContext >& rxContext, const Reference< XSpreadsheetDocument >& rxDocument ) :
::oox::ole::VbaProject( rxContext, Reference< XModel >( rxDocument, UNO_QUERY ), "Calc" ),
mxDocument( rxDocument )
{
}
// protected ------------------------------------------------------------------
namespace {
struct SheetCodeNameInfo
{
PropertySet maSheetProps; /// Property set of the sheet without codename.
OUString maPrefix; /// Prefix for the codename to be generated.
explicit SheetCodeNameInfo( PropertySet& rSheetProps, const OUString& rPrefix ) :
maSheetProps( rSheetProps ), maPrefix( rPrefix ) {}
};
} // namespace
void ExcelVbaProject::prepareImport()
{
/* Check if the sheets have imported codenames. Generate new unused
codenames if not. */
if( mxDocument.is() ) try
{
// collect existing codenames (do not use them when creating new codenames)
::std::set< OUString > aUsedCodeNames;
// collect sheets without codenames
::std::list< SheetCodeNameInfo > aCodeNameInfos;
// iterate over all imported sheets
Reference< XEnumerationAccess > xSheetsEA( mxDocument->getSheets(), UNO_QUERY_THROW );
Reference< XEnumeration > xSheetsEnum( xSheetsEA->createEnumeration(), UNO_SET_THROW );
// own try/catch for every sheet
while( xSheetsEnum->hasMoreElements() ) try
{
PropertySet aSheetProp( xSheetsEnum->nextElement() );
OUString aCodeName;
aSheetProp.getProperty( aCodeName, PROP_CodeName );
if( !aCodeName.isEmpty() )
{
aUsedCodeNames.insert( aCodeName );
}
else
{
// TODO: once we have chart sheets we need a switch/case on sheet type ('SheetNNN' vs. 'ChartNNN')
aCodeNameInfos.push_back( SheetCodeNameInfo( aSheetProp, "Sheet" ) );
}
}
catch( Exception& )
{
}
// create new codenames if sheets do not have one
for( ::std::list< SheetCodeNameInfo >::iterator aIt = aCodeNameInfos.begin(), aEnd = aCodeNameInfos.end(); aIt != aEnd; ++aIt )
{
// search for an unused codename
sal_Int32 nCounter = 1;
OUString aCodeName;
do
{
aCodeName = aIt->maPrefix + OUString::number( nCounter++ );
}
while( aUsedCodeNames.count( aCodeName ) > 0 );
aUsedCodeNames.insert( aCodeName );
// set codename at sheet
aIt->maSheetProps.setProperty( PROP_CodeName, aCodeName );
// tell base class to create a dummy module
addDummyModule( aCodeName, ModuleType::DOCUMENT );
}
}
catch( Exception& )
{
}
}
} // namespace xls
} // namespace oox
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|