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
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
|
/*************************************************************************
*
* 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 "imp_op.hxx"
#include "root.hxx"
#include "excscen.hxx"
#include "excdefs.hxx"
#include "ftools.hxx"
#include "queryparam.hxx"
class SotStorage;
class ScBaseCell;
class ScRangeList;
class ScDBData;
class ScfSimpleProgressBar;
class XclImpStream;
class ImportExcel8 : public ImportExcel
{
SCTAB mnTab;
protected:
ExcScenarioList aScenList;
BOOL bHasBasic;
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( BOOL bWBGlobals ); // 0x01BA
void SheetProtection( void ); // 0x0867
virtual void EndSheet( void );
virtual void PostDocLoad( void );
public:
ImportExcel8( XclImpRootData& rImpData, SvStream& rStrm );
virtual ~ImportExcel8( void );
virtual FltError Read( void );
};
//___________________________________________________________________
// classes AutoFilterData, AutoFilterBuffer
class XclImpAutoFilterData : private ExcRoot
{
private:
ScDBData* pCurrDBData;
ScQueryParam aParam;
SCSIZE nFirstEmpty;
BOOL bActive;
BOOL bHasConflict;
BOOL bCriteria;
BOOL bAutoOrAdvanced;
ScRange aCriteriaRange;
String aFilterName;
void CreateFromDouble( String& rStr, double fVal );
void SetCellAttribs();
void InsertQueryParam();
void AmendAFName(const BOOL bUseUnNamed);
protected:
public:
XclImpAutoFilterData(
RootData* pRoot,
const ScRange& rRange,
const String& rName );
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( const BOOL bUseUnNamed = FALSE );
void CreateScDBData( const BOOL bUseUnNamed );
void EnableRemoveFilter();
};
class XclImpAutoFilterBuffer : private List
{
private:
using List::Insert;
UINT16 nAFActiveCount;
inline XclImpAutoFilterData* _First() { return (XclImpAutoFilterData*) List::First(); }
inline XclImpAutoFilterData* _Next() { return (XclImpAutoFilterData*) List::Next(); }
inline void Append( XclImpAutoFilterData* pData )
{ List::Insert( pData, LIST_APPEND ); }
protected:
public:
XclImpAutoFilterBuffer();
virtual ~XclImpAutoFilterBuffer();
void Insert( RootData* pRoot, const ScRange& rRange,
const String& rName );
void AddAdvancedRange( const ScRange& rRange );
void AddExtractPos( const ScRange& rRange );
void Apply();
XclImpAutoFilterData* GetByTab( SCTAB nTab );
inline void IncrementActiveAF() { nAFActiveCount++; }
inline BOOL UseUnNamed() { return nAFActiveCount == 1; }
};
#endif
|