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
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
|
/* -*- 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_XESTREAM_HXX
#define SC_XESTREAM_HXX
#include <com/sun/star/beans/NamedValue.hpp>
#include <map>
#include <stack>
#include <string>
#include <oox/core/xmlfilterbase.hxx>
#include <oox/token/tokens.hxx>
#include <sax/fshelper.hxx>
#include "xlstream.hxx"
#include "xestring.hxx"
#include <filter/msfilter/mscodec.hxx>
#include <vector>
/* ============================================================================
Output stream class for Excel export
- CONTINUE record handling
- ByteString and UniString support
============================================================================ */
class XclExpRoot;
class XclExpBiff8Encrypter;
typedef boost::shared_ptr< XclExpBiff8Encrypter > XclExpEncrypterRef;
/** This class is used to export Excel record streams.
@descr An instance is constructed with an SvStream and the maximum size of Excel
record contents (in BIFF5: 2080 bytes, in BIFF8: 8224 bytes).
To start writing a record call StartRecord(). Parameters are the record identifier
and any calculated record size. This is for optimizing the write process: if the real
written data has the same size as the calculated, the stream will not seek back and
update the record size field. But it is not mandatory to calculate a size. Each
record must be closed by calling EndRecord(). This will check (and update) the record
size field.
If some data exceeds the record size limit, a CONTINUE record is started automatically
and the new data will be written to this record.
If specific data pieces must not be splitted, use SetSliceLen(). For instance:
To write a sequence of 16-bit values, where 4 values form a unit and cannot be
split, call SetSliceLen( 8 ) first (4*2 bytes == 8).
To write unicode character arrays, call WriteUnicodeBuffer(). It creates CONTINUE
records and repeats the unicode string flag byte automatically. This function is used
for instance from the class XclExpString which can write complete unicode strings.
*/
class XclExpStream
{
public:
/** Constructs the Excel record export stream.
@param rOutStrm The system output stream to write to.
@param nMaxRecSize The maximum allowed size of record content (depending on BIFF type).
If 0 is passed, the record size will be set automatically, depending on the current BIFF type. */
XclExpStream(
SvStream& rOutStrm,
const XclExpRoot& rRoot,
sal_uInt16 nMaxRecSize = 0 );
~XclExpStream();
/** Returns the filter root data. */
inline const XclExpRoot& GetRoot() const { return mrRoot; }
/** Starts a new record: writes header data, stores calculated record size. */
void StartRecord( sal_uInt16 nRecId, sal_Size nRecSize );
/** Checks and corrects real record length. Must be called everytime a record is finished. */
void EndRecord();
/** Returns the position inside of current record (starts by 0 in every CONTINUE). */
inline sal_uInt16 GetRawRecPos() const { return mnCurrSize; }
/** Returns the maximum size of a record. */
inline sal_uInt16 GetMaxRecSize() const { return mnMaxRecSize; }
/** Sets maximum record size (valid only for current record). */
inline void SetMaxRecSize( sal_uInt16 nMax ) { mnCurrMaxSize = nMax; }
/** Sets maximum size of CONTINUE records (valid only for current record). */
inline void SetMaxContSize( sal_uInt16 nMax ) { mnMaxContSize = nMax; }
/** Sets data slice length. 0 = no slices. */
void SetSliceSize( sal_uInt16 nSize );
XclExpStream& operator<<( sal_Int8 nValue );
XclExpStream& operator<<( sal_uInt8 nValue );
XclExpStream& operator<<( sal_Int16 nValue );
XclExpStream& operator<<( sal_uInt16 nValue );
XclExpStream& operator<<( sal_Int32 nValue );
XclExpStream& operator<<( sal_uInt32 nValue );
XclExpStream& operator<<( float fValue );
XclExpStream& operator<<( double fValue );
/** Writes nBytes bytes from memory. */
sal_Size Write( const void* pData, sal_Size nBytes );
/** Writes a sequence of nBytes zero bytes (respects slice setting). */
void WriteZeroBytes( sal_Size nBytes );
void WriteZeroBytesToRecord( sal_Size nBytes );
/** Copies nBytes bytes from current position of the stream rInStrm.
@descr Omitting the second parameter means: read to end of stream. */
sal_Size CopyFromStream( SvStream& rInStrm, sal_Size nBytes = STREAM_SEEK_TO_END );
// *** unicode string export is realized with helper class XclExpString ***
// (slice length setting has no effect here -> disabled automatically)
/** Writes Unicode buffer as 8/16 bit, repeats nFlags at start of a CONTINUE record. */
void WriteUnicodeBuffer( const ScfUInt16Vec& rBuffer, sal_uInt8 nFlags );
// *** write 8-bit-strings ***
// (slice length setting has no effect here -> disabled automatically)
/** Writes string length field and ByteString buffer. */
void WriteByteString(
const ByteString& rString,
sal_uInt16 nMaxLen = 0x00FF,
bool b16BitCount = false );
/** Writes 8-bit character buffer. */
void WriteCharBuffer( const ScfUInt8Vec& rBuffer );
// *** SvStream access ***
/** Sets position of system stream (only allowed outside of records). */
sal_Size SetSvStreamPos( sal_Size nPos );
/** Returns the absolute position of the system stream. */
inline sal_Size GetSvStreamPos() const { return mrStrm.Tell(); }
void SetEncrypter( XclExpEncrypterRef xEncrypter );
bool HasValidEncrypter() const;
void EnableEncryption( bool bEnable = true );
void DisableEncryption();
private:
/** Writes header data, internal setup. */
void InitRecord( sal_uInt16 nRecId );
/** Rewrites correct record length, if different from calculated. */
void UpdateRecSize();
/** Recalculates mnCurrSize and mnSliceSize. */
void UpdateSizeVars( sal_Size nSize );
/** Writes CONTINUE header, internal setup. */
void StartContinue();
/** Refreshes counter vars, creates CONTINUE records. */
void PrepareWrite( sal_uInt16 nSize );
/** Creates CONTINUE record at end of record.
@return Maximum data block size remaining. */
sal_uInt16 PrepareWrite();
/** Writes a raw sequence of zero bytes. */
void WriteRawZeroBytes( sal_Size nBytes );
private:
SvStream& mrStrm; /// Reference to the system output stream.
const XclExpRoot& mrRoot; /// Filter root data.
bool mbUseEncrypter;
XclExpEncrypterRef mxEncrypter;
// length data
sal_uInt16 mnMaxRecSize; /// Maximum size of record content.
sal_uInt16 mnMaxContSize; /// Maximum size of CONTINUE content.
sal_uInt16 mnCurrMaxSize; /// Current maximum, either mnMaxRecSize or mnMaxContSize.
sal_uInt16 mnMaxSliceSize; /// Maximum size of data slices (parts that cannot be split).
sal_uInt16 mnHeaderSize; /// Record size written in last record header.
sal_uInt16 mnCurrSize; /// Count of bytes already written in current record.
sal_uInt16 mnSliceSize; /// Count of bytes already written in current slice.
sal_Size mnPredictSize; /// Predicted size received from calling function.
// stream position data
sal_Size mnLastSizePos; /// Stream position of size field in current header.
bool mbInRec; /// true = currently writing inside of a record.
};
// ============================================================================
class XclExpBiff8Encrypter
{
public:
explicit XclExpBiff8Encrypter( const XclExpRoot& rRoot );
~XclExpBiff8Encrypter();
bool IsValid() const;
void GetSaltDigest( sal_uInt8 pnSaltDigest[16] ) const;
void GetSalt( sal_uInt8 pnSalt[16] ) const;
void GetDocId( sal_uInt8 pnDocId[16] ) const;
void Encrypt( SvStream& rStrm, sal_uInt8 nData );
void Encrypt( SvStream& rStrm, sal_uInt16 nData );
void Encrypt( SvStream& rStrm, sal_uInt32 nData );
void Encrypt( SvStream& rStrm, sal_Int8 nData );
void Encrypt( SvStream& rStrm, sal_Int16 nData );
void Encrypt( SvStream& rStrm, sal_Int32 nData );
void Encrypt( SvStream& rStrm, float fValue );
void Encrypt( SvStream& rStrm, double fValue );
void EncryptBytes( SvStream& rStrm, ::std::vector<sal_uInt8>& aBytes );
private:
void Init( const ::com::sun::star::uno::Sequence< ::com::sun::star::beans::NamedValue >& aEncryptionData );
sal_uInt32 GetBlockPos( sal_Size nStrmPos ) const;
sal_uInt16 GetOffsetInBlock( sal_Size nStrmPos ) const;
private:
::msfilter::MSCodec_Std97 maCodec; /// Crypto algorithm implementation.
sal_uInt8 mpnDocId[16];
sal_uInt8 mpnSalt[16];
sal_uInt8 mpnSaltDigest[16];
const XclExpRoot& mrRoot;
sal_Size mnOldPos; /// Last known stream position
bool mbValid;
};
// ----------------------------------------------------------------------------
// ============================================================================
// `s.GetChar(0) != 0` needed because some strings on export only contain NULL.
#define XESTRING_TO_PSZ(s) \
(s.Len() && s.GetChar( 0 ) != 0 ? XclXmlUtils::ToOString( s ).getStr() : NULL)
class ScAddress;
class ScDocShell;
class ScDocument;
class ScFormulaCell;
class ScRange;
class ScRangeList;
class ScTokenArray;
struct XclAddress;
struct XclFontData;
struct XclRange;
class XclRangeList;
class XclXmlUtils
{
XclXmlUtils();
~XclXmlUtils();
XclXmlUtils(const XclXmlUtils&);
XclXmlUtils& operator=(const XclXmlUtils&);
public:
static void GetFormulaTypeAndValue( ScFormulaCell& rCell, const char*& sType, ::rtl::OUString& rValue);
static ::rtl::OUString GetStreamName( const char* sStreamDir, const char* sStream, sal_Int32 nId );
static ::rtl::OString ToOString( const Color& rColor );
static ::rtl::OString ToOString( const ::rtl::OUString& s );
static ::rtl::OString ToOString( const ScfUInt16Vec& rBuffer );
static ::rtl::OString ToOString( const String& s );
static ::rtl::OString ToOString( const ScAddress& rRange );
static ::rtl::OString ToOString( const ScRange& rRange );
static ::rtl::OString ToOString( const ScRangeList& rRangeList );
static ::rtl::OString ToOString( const XclAddress& rAddress );
static ::rtl::OString ToOString( const XclExpString& s );
static ::rtl::OString ToOString( const XclRange& rRange );
static ::rtl::OString ToOString( const XclRangeList& rRangeList );
static ::rtl::OUString ToOUString( const char* s );
static ::rtl::OUString ToOUString( const ScfUInt16Vec& rBuffer, sal_Int32 nStart = 0, sal_Int32 nLength = -1 );
static ::rtl::OUString ToOUString( const String& s );
static ::rtl::OUString ToOUString( ScDocument& rDocument, const ScAddress& rAddress, ScTokenArray* pTokenArray );
static ::rtl::OUString ToOUString( const XclExpString& s );
static const char* ToPsz( bool b );
static sax_fastparser::FSHelperPtr WriteElement( sax_fastparser::FSHelperPtr pStream, sal_Int32 nElement, sal_Int32 nValue );
static sax_fastparser::FSHelperPtr WriteElement( sax_fastparser::FSHelperPtr pStream, sal_Int32 nElement, sal_Int64 nValue );
static sax_fastparser::FSHelperPtr WriteElement( sax_fastparser::FSHelperPtr pStream, sal_Int32 nElement, const char* sValue );
static sax_fastparser::FSHelperPtr WriteFontData( sax_fastparser::FSHelperPtr pStream, const XclFontData& rFontData, sal_Int32 nNameId );
};
class XclExpXmlStream : public oox::core::XmlFilterBase
{
public:
XclExpXmlStream( const com::sun::star::uno::Reference< com::sun::star::lang::XMultiServiceFactory >& rSMgr );
virtual ~XclExpXmlStream();
/** Returns the filter root data. */
inline const XclExpRoot& GetRoot() const { return *mpRoot; }
sax_fastparser::FSHelperPtr& GetCurrentStream();
void PushStream( sax_fastparser::FSHelperPtr aStream );
void PopStream();
sax_fastparser::FSHelperPtr GetStreamForPath( const ::rtl::OUString& rPath );
sax_fastparser::FSHelperPtr& WriteAttributes( sal_Int32 nAttribute, ... );
sax_fastparser::FSHelperPtr CreateOutputStream (
const ::rtl::OUString& sFullStream,
const ::rtl::OUString& sRelativeStream,
const ::com::sun::star::uno::Reference< ::com::sun::star::io::XOutputStream >& xParentRelation,
const char* sContentType,
const char* sRelationshipType,
::rtl::OUString* pRelationshipId = NULL );
// ignore
virtual bool exportDocument() throw();
// only needed for import; ignore
virtual bool importDocument() throw();
virtual oox::vml::Drawing* getVmlDrawing();
virtual const oox::drawingml::Theme* getCurrentTheme() const;
virtual const oox::drawingml::table::TableStyleListPtr getTableStyles();
virtual oox::drawingml::chart::ChartConverter& getChartConverter();
private:
virtual ::oox::ole::VbaProject* implCreateVbaProject() const;
virtual ::rtl::OUString implGetImplementationName() const;
ScDocShell *getDocShell();
typedef std::map< ::rtl::OUString,
std::pair< ::rtl::OUString,
sax_fastparser::FSHelperPtr > > XclExpXmlPathToStateMap;
const XclExpRoot* mpRoot;
std::stack< sax_fastparser::FSHelperPtr > maStreams;
XclExpXmlPathToStateMap maOpenedStreamMap;
};
#endif
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|