blob: e16062146331067884d7f3f96eee51b3f4cae5fb (
plain)
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
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*************************************************************************
*
* 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.
*
************************************************************************/
#ifndef SC_EXCIMP8_HXX
#define SC_EXCIMP8_HXX
#include <string.h>
#include <boost/ptr_container/ptr_vector.hpp>
#include "imp_op.hxx"
#include "root.hxx"
#include "excscen.hxx"
#include "excdefs.hxx"
#include "ftools.hxx"
#include "queryparam.hxx"
class ScDBData;
class XclImpStream;
class ImportExcel8 : public ImportExcel
{
public:
ImportExcel8( XclImpRootData& rImpData, SvStream& rStrm );
virtual ~ImportExcel8( void );
virtual FltError Read( void );
void Calccount( void ); // 0x0C
void Precision( void ); // 0x0E
void Delta( void ); // 0x10
void Iteration( void ); // 0x11
void Boundsheet( void ); // 0x85
void FilterMode( void ); // 0x9B
void AutoFilterInfo( void ); // 0x9D
void AutoFilter( void ); // 0x9E
void Scenman( void ); // 0xAE
void Scenario( void ); // 0xAF
void ReadBasic( void ); // 0xD3
void Labelsst( void ); // 0xFD
void Hlink( void ); // 0x01B8
void Codename( sal_Bool bWBGlobals ); // 0x01BA
void SheetProtection( void ); // 0x0867
virtual void EndSheet( void );
virtual void PostDocLoad( void );
private:
void LoadDocumentProperties();
private:
// represents codename ( and associated modules )
// not speficied directly in the binary format
std::vector<rtl::OUString> maAutoGeneratedCodeNames;
ExcScenarioList maScenList;
};
//___________________________________________________________________
// classes AutoFilterData, AutoFilterBuffer
class XclImpAutoFilterData : private ExcRoot
{
private:
ScDBData* pCurrDBData;
ScQueryParam aParam;
ScRange aCriteriaRange;
bool bActive:1;
bool bCriteria:1;
bool bAutoOrAdvanced:1;
void CreateFromDouble( rtl::OUString& rStr, double fVal );
void SetCellAttribs();
void InsertQueryParam();
protected:
public:
XclImpAutoFilterData(
RootData* pRoot,
const ScRange& rRange);
inline bool IsActive() const { return bActive; }
inline bool IsFiltered() const { return bAutoOrAdvanced; }
inline SCTAB Tab() const { return aParam.nTab; }
inline SCCOL StartCol() const { return aParam.nCol1; }
inline SCROW StartRow() const { return aParam.nRow1; }
inline SCCOL EndCol() const { return aParam.nCol2; }
inline SCROW EndRow() const { return aParam.nRow2; }
void ReadAutoFilter( XclImpStream& rStrm );
inline void Activate() { bActive = true; }
void SetAdvancedRange( const ScRange* pRange );
void SetExtractPos( const ScAddress& rAddr );
inline void SetAutoOrAdvanced() { bAutoOrAdvanced = true; }
void Apply();
void CreateScDBData();
void EnableRemoveFilter();
};
class XclImpAutoFilterBuffer
{
public:
void Insert( RootData* pRoot, const ScRange& rRange);
void AddAdvancedRange( const ScRange& rRange );
void AddExtractPos( const ScRange& rRange );
void Apply();
XclImpAutoFilterData* GetByTab( SCTAB nTab );
private:
boost::ptr_vector<XclImpAutoFilterData> maFilters;
};
#endif
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|