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
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
|
/*************************************************************************
*
* DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
*
* Copyright 2008 by Sun Microsystems, Inc.
*
* OpenOffice.org - a multi-platform office productivity suite
*
* $RCSfile: imp_op.hxx,v $
* $Revision: 1.43.14.3 $
*
* 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_IMP_OP_HXX
#define SC_IMP_OP_HXX
#include <tools/gen.hxx>
#include "xiroot.hxx"
#include "xistream.hxx"
#include "xistyle.hxx"
#include "flttypes.hxx"
#include "namebuff.hxx"
#include "root.hxx"
#include "otlnbuff.hxx"
#include "colrowst.hxx"
#include "excdefs.hxx"
class SfxItemSet;
class SvStream;
class ScFormulaCell;
class SdrObject;
class ScDocument;
class ScToken;
class _ScRangeListTabs;
class ExcelToSc;
class ImportTyp
{
protected:
CharSet eQuellChar; // Quell-Zeichensatz
ScDocument* pD; // Dokument
public:
ImportTyp( ScDocument*, CharSet eSrc );
virtual ~ImportTyp();
virtual FltError Read( void );
};
class XclImpOutlineDataBuffer : protected XclImpRoot
{
public:
explicit XclImpOutlineDataBuffer( const XclImpRoot& rRoot, SCTAB nScTab );
virtual ~XclImpOutlineDataBuffer();
inline XclImpColRowSettings* GetColRowBuff() const { return mxColRowBuff.get(); }
inline XclImpOutlineBuffer* GetColOutline() const { return mxColOutlineBuff.get(); }
inline XclImpOutlineBuffer* GetRowOutline() const { return mxRowOutlineBuff.get(); }
void Convert();
private:
typedef ScfRef< XclImpOutlineBuffer > XclImpOutlineBfrRef;
typedef ScfRef< XclImpColRowSettings > XclImpColRowSettRef;
XclImpOutlineBfrRef mxColOutlineBuff;
XclImpOutlineBfrRef mxRowOutlineBuff;
XclImpColRowSettRef mxColRowBuff;
SCTAB mnScTab;
};
class ImportExcel : public ImportTyp, protected XclImpRoot
{
protected:
static const double fExcToTwips; // Umrechnung 1/256 Zeichen -> Twips
RootData* pExcRoot;
XclImpStream maStrm; // input stream
XclImpStream& aIn; // input stream
ScfUInt32Vec maSheetOffsets;
NameBuffer* pExtNameBuff; // ... externe Namen (Ind.-Basis=1)
ExcelToSc* pFormConv; // Formel-Konverter
XclImpOutlineBuffer* pColOutlineBuff;
XclImpOutlineBuffer* pRowOutlineBuff;
XclImpColRowSettings* pColRowBuff; // Col/Row-Einstellungen 1 Tabelle
typedef ScfDelList< XclImpOutlineDataBuffer > XclImpOutlineListBuffer;
XclImpOutlineListBuffer* pOutlineListBuffer;
sal_Int16 mnLastRefIdx;
UINT16 nIxfeIndex; // merkt sich Angabe im IXFE-Record
UINT16 nLastXF; // letzter XF in Formula-Record
SCTAB nBdshtTab; // Counter fuer Boundsheet
ScFormulaCell* pLastFormCell; // fuer String-Records
BOOL bTabTruncated; // wenn Bereichsueberschreitung zum
// Abschneiden von Zellen fuehrt
// Record-Funktionen
void ReadFileSharing();
sal_uInt16 ReadXFIndex( bool bBiff2 );
void ReadDimensions();
void ReadBlank();
void ReadInteger();
void ReadNumber();
void ReadLabel();
void ReadBoolErr();
void ReadRk();
void Window1();
void Formula25( void ); // 0x06 -> excform.cxx
void Row25( void ); // 0x08
void Bof2( void ); // 0x09
void Eof( void ); // 0x0A
void DocProtect( void ); // 0x12
void SheetProtect( void ); // 0x12 Sheet Protection
void DocPasssword( void ); // 0x13 document password
void SheetPassword( void ); // 0x13 sheet password
void Externsheet( void ); // 0x17
void WinProtection( void ); // 0x19
void Columndefault( void ); // 0x20
void Array25( void ); // 0x21
void Rec1904( void ); // 0x22
void Externname25( void ); // 0x23
void Colwidth( void ); // 0x24
void Defrowheight2( void ); // 0x25
// void Window1( void ); // 0x3D
void Codepage( void ); // 0x42
void Ixfe( void ); // 0x44
void DefColWidth( void ); // 0x55
void Builtinfmtcnt( void ); // 0x56
void Colinfo( void ); // 0x7D
void Wsbool( void ); // 0x81
void Boundsheet( void ); // 0x85
void Country( void ); // 0x8C
void Hideobj( void ); // 0x8D
void Bundleheader( void ); // 0x8F
void Standardwidth( void ); // 0x99
void Shrfmla( void ); // 0xBC
void Mulrk( void ); // 0xBD
void Mulblank( void ); // 0xBE
void Rstring( void ); // 0xD6
void Cellmerging( void ); // 0xE5
void Olesize( void ); // 0xDE
void ReadUsesElfs(); // 0x0160
void Formula3( void ); // 0x0206 -> excform.cxx
// 0x0207 -> 0x07
void Row34( void ); // 0x0208
void Bof3( void ); // 0x0209
void Array34( void ); // 0x0221
void Externname34( void ); // 0x0223
void Defrowheight345( void ); // 0x0225
void TableOp( void ); // 0x0236
//void Rk( void ); // 0x027E -> 0x7E
void Formula4( void ); // 0x0406 -> excform.cxx
void Bof4( void ); // 0x0409
void Bof5( void ); // 0x0809
// ---------------------------------------------------------------
void Formula( const XclAddress& rXclPos,
UINT16 nXF, UINT16 nFormLen, double &rCurVal, BOOL bShrFmla );
// -> excform.cxx
virtual void EndSheet( void );
void NeueTabelle( void );
const ScTokenArray* ErrorToFormula( BYTE bErrOrVal, BYTE nError,
double& rVal );
virtual void AdjustRowHeight();
virtual void PostDocLoad( void );
public:
ImportExcel( XclImpRootData& rImpData, SvStream& rStrm );
virtual ~ImportExcel( void );
virtual FltError Read( void );
};
#endif
|