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
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
|
/*************************************************************************
*
* 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_XISTYLE_HXX
#define SC_XISTYLE_HXX
#include <list>
#include <tools/mempool.hxx>
#include "rangelst.hxx"
#include "patattr.hxx"
#include "xladdress.hxx"
#include "xlstyle.hxx"
#include "xiroot.hxx"
class ScDocumentPool;
/* ============================================================================
- Buffers for style records (PALETTE, FONT, FORMAT, XF)
and a container for XF indexes for every used cell in a sheet.
============================================================================ */
// PALETTE record - color information =========================================
/** Stores the default colors for the current BIFF version and the contents of
a PALETTE record. */
class XclImpPalette : public XclDefaultPalette
{
public:
explicit XclImpPalette( const XclImpRoot& rRoot );
/** Clears all buffered data, used to set up for a new sheet. */
void Initialize();
/** Returns the RGB color data for a (non-zero-based) Excel palette entry.
@descr First looks for a color read from file, then looks for a default color.
@return The color from current or default palette or COL_AUTO, if nothing else found. */
ColorData GetColorData( sal_uInt16 nXclIndex ) const;
/** Returns the color for a (non-zero-based) Excel palette entry.
@descr First looks for a color read from file, then looks for a default color.
@return The color from current or default palette or COL_AUTO, if nothing else found. */
inline Color GetColor( sal_uInt16 nXclIndex ) const
{ return Color( GetColorData( nXclIndex ) ); }
/** Reads a PALETTE record. */
void ReadPalette( XclImpStream& rStrm );
private:
typedef ::std::vector< ColorData > ColorDataVec;
ColorDataVec maColorTable; /// Colors read from file.
};
// FONT record - font information =============================================
/** Stores all data of an Excel font and provides import of FONT records. */
class XclImpFont : protected XclImpRoot
{
public:
explicit XclImpFont( const XclImpRoot& rRoot );
/** Constructs a font from font data.
@descr Special handling for font style (bold, italic) in font name,
overwrites settings in rFontData. */
explicit XclImpFont( const XclImpRoot& rRoot, const XclFontData& rFontData );
/** Sets all font attributes to used or unused. */
void SetAllUsedFlags( bool bUsed );
/** Sets the passed font data and all used flags to 'used'. */
void SetFontData( const XclFontData& rFontData, bool bHasCharSet );
/** Returns read-only access to font data. */
inline const XclFontData& GetFontData() const { return maData; }
/** Returns true, if the font character set is valid. */
inline bool HasCharSet() const { return mbHasCharSet; }
/** Returns true, if the font contains superscript or subscript. */
inline bool HasEscapement() const { return maData.mnEscapem != EXC_FONTESC_NONE; }
/** Returns the text encoding for strings used with this font. */
rtl_TextEncoding GetFontEncoding() const;
/** Returns true, if this font contains characters for Western scripts. */
inline bool HasWesternChars() const { return mbHasWstrn; }
/** Returns true, if this font contains characters for Asian scripts (CJK). */
inline bool HasAsianChars() const { return mbHasAsian; }
/** Returns true, if this font contains characters for Complex scripts (CTL). */
inline bool HasComplexChars() const { return mbHasCmplx; }
/** Reads a FONT record for all BIFF versions. */
void ReadFont( XclImpStream& rStrm );
/** Reads an EFONT record (BIFF2 font color). */
void ReadEfont( XclImpStream& rStrm );
/** Reads the font block from a CF (conditional format) record. */
void ReadCFFontBlock( XclImpStream& rStrm );
/** Fills all font properties to the item set.
@param rItemSet The destination item set.
@param eType The type of Which-IDs.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet( SfxItemSet& rItemSet, XclFontItemType eType,
bool bSkipPoolDefs = false ) const;
/** Writes all font properties to the passed property set.
@param pFontColor If set, overrides internal stored font color. */
void WriteFontProperties( ScfPropertySet& rPropSet,
XclFontPropSetType eType, const Color* pFontColor = 0 ) const;
private:
/** Reads and sets height and flags. */
void ReadFontData2( XclImpStream& rStrm );
/** Reads and sets height, flags, color, boldness, script, family and charset. */
void ReadFontData5( XclImpStream& rStrm );
/** Reads and sets the font color. */
void ReadFontColor( XclImpStream& rStrm );
/** Reads and sets a byte string as font name. */
void ReadFontName2( XclImpStream& rStrm );
/** Reads and sets a Unicode string as font name. */
void ReadFontName8( XclImpStream& rStrm );
/** Tests whether the font contains CJK or CTL characters.
@descr This is only a weak guess using preselected characters. */
void GuessScriptType();
private:
XclFontData maData; /// All font attributes.
bool mbHasCharSet; /// true = Font contains own character set info.
bool mbHasWstrn; /// true = Font contains Western script characters.
bool mbHasAsian; /// true = Font contains Asian script characters.
bool mbHasCmplx; /// true = Font contains Complex script characters.
bool mbFontNameUsed; /// true = Font name, family, charset used.
bool mbHeightUsed; /// true = Font height used.
bool mbColorUsed; /// true = Color used.
bool mbWeightUsed; /// true = Weight used.
bool mbEscapemUsed; /// true = Escapement type used.
bool mbUnderlUsed; /// true = Underline style used.
bool mbItalicUsed; /// true = Italic used.
bool mbStrikeUsed; /// true = Strikeout used.
bool mbOutlineUsed; /// true = Outlined used.
bool mbShadowUsed; /// true = Shadowed used.
};
// ----------------------------------------------------------------------------
/** Stores the data of all fonts occurred in an Excel file. */
class XclImpFontBuffer : protected XclImpRoot, ScfNoCopy
{
public:
explicit XclImpFontBuffer( const XclImpRoot& rRoot );
/** Clears all buffered data, used to set up for a new sheet. */
void Initialize();
/** Returns the object that stores all contents of a FONT record. */
const XclImpFont* GetFont( sal_uInt16 nFontIndex ) const;
/** Returns the application font data of this file, needed i.e. for column width. */
inline const XclFontData& GetAppFontData() const { return maAppFont; }
/** Reads a FONT record. */
void ReadFont( XclImpStream& rStrm );
/** Reads an EFONT record (BIFF2 font color). */
void ReadEfont( XclImpStream& rStrm );
/** Fills all font properties from a FONT record to the item set.
@param rItemSet The destination item set.
@param eType The type of Which-IDs.
@param nFontIdx The Excel index of the font.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet( SfxItemSet& rItemSet, XclFontItemType eType,
sal_uInt16 nFontIdx, bool bSkipPoolDefs = false ) const;
/** Writes all font properties to the passed property set.
@param pFontColor If set, overrides internal stored font color. */
void WriteFontProperties(
ScfPropertySet& rPropSet, XclFontPropSetType eType,
sal_uInt16 nFontIdx, const Color* pFontColor = 0 ) const;
/** Writes default font properties for form controls to the passed property set. */
void WriteDefaultCtrlFontProperties( ScfPropertySet& rPropSet ) const;
private:
/** Updates the application default font. */
void UpdateAppFont( const XclFontData& rFontData, bool bHasCharSet );
private:
ScfDelList< XclImpFont > maFontList; /// List of all FONT records in the Excel file.
XclFontData maAppFont; /// Application font (for column width).
XclImpFont maFont4; /// Built-in font with index 4.
XclImpFont maCtrlFont; /// BIFF5 default form controls font (Helv,8pt,bold).
};
// FORMAT record - number formats =============================================
/** Stores all user defined number formats occured in the file. */
class XclImpNumFmtBuffer : public XclNumFmtBuffer, protected XclImpRoot
{
public:
explicit XclImpNumFmtBuffer( const XclImpRoot& rRoot );
/** Clears all buffered data, used to set up for a new sheet. */
void Initialize();
/** Reads a FORMAT record. */
void ReadFormat( XclImpStream& rStrm );
/** Creates the number formats in the Calc document. */
void CreateScFormats();
/** Returns the format key with the passed Excel index or NUMBERFORMAT_ENTRY_NOT_FOUND on error. */
ULONG GetScFormat( sal_uInt16 nXclNumFmt ) const;
/** Fills an Excel number format to the passed item set.
@param rItemSet The destination item set.
@param nXclNumFmt The Excel number format index.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet(
SfxItemSet& rItemSet, sal_uInt16 nXclNumFmt,
bool bSkipPoolDefs = false ) const;
/** Fills a Calc number format to the passed item set.
@param rItemSet The destination item set.
@param nScNumFmt The Calc number formatter index of the format.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillScFmtToItemSet(
SfxItemSet& rItemSet, ULONG nScNumFmt,
bool bSkipPoolDefs = false ) const;
private:
typedef ::std::map< sal_uInt16, ULONG > XclImpIndexMap;
XclImpIndexMap maIndexMap; /// Maps Excel format indexes to Calc formats.
sal_uInt16 mnNextXclIdx; /// Index counter for BIFF2-BIFF4.
};
// XF, STYLE record - Cell formatting =========================================
/** Extends the XclCellProt struct for import.
@descr Provides functions to fill from Excel record data and to fill to item sets. */
struct XclImpCellProt : public XclCellProt
{
/** Fills this struct with BIFF2 XF record data. */
void FillFromXF2( sal_uInt8 nNumFmt );
/** Fills this struct with BIFF3-BIFF8 XF record data. */
void FillFromXF3( sal_uInt16 nProt );
/** Inserts items representing this protection style into the item set.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet( SfxItemSet& rItemSet, bool bSkipPoolDefs = false ) const;
};
// ----------------------------------------------------------------------------
/** Extends the XclCellAlign struct for import.
@descr Provides functions to fill from Excel record data and to fill to item sets. */
struct XclImpCellAlign : public XclCellAlign
{
/** Fills this struct with BIFF2 XF record data. */
void FillFromXF2( sal_uInt8 nFlags );
/** Fills this struct with BIFF3 XF record data. */
void FillFromXF3( sal_uInt16 nAlign );
/** Fills this struct with BIFF4 XF record data. */
void FillFromXF4( sal_uInt16 nAlign );
/** Fills this struct with BIFF5/BIFF7 XF record data. */
void FillFromXF5( sal_uInt16 nAlign );
/** Fills this struct with BIFF8 XF record data. */
void FillFromXF8( sal_uInt16 nAlign, sal_uInt16 nMiscAttrib );
/** Inserts items representing this alignment style into the item set.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet( SfxItemSet& rItemSet, const XclImpFont* pFont, bool bSkipPoolDefs = false ) const;
};
// ----------------------------------------------------------------------------
/** Extends the XclCellBorder struct for import.
@descr Provides functions to fill from Excel record data and to fill to item sets. */
struct XclImpCellBorder : public XclCellBorder
{
bool mbLeftUsed; /// true = Left line style used.
bool mbRightUsed; /// true = Right line style used.
bool mbTopUsed; /// true = Top line style used.
bool mbBottomUsed; /// true = Bottom line style used.
bool mbDiagUsed; /// true = Diagonal line style used.
explicit XclImpCellBorder();
/** Sets outer line states and diagonal line states to used or unused. */
void SetUsedFlags( bool bOuterUsed, bool bDiagUsed );
/** Fills this struct with BIFF2 XF record data. */
void FillFromXF2( sal_uInt8 nFlags );
/** Fills this struct with BIFF3/BIFF4 XF record data. */
void FillFromXF3( sal_uInt32 nBorder );
/** Fills this struct with BIFF5/BIFF7 XF record data. */
void FillFromXF5( sal_uInt32 nBorder, sal_uInt32 nArea );
/** Fills this struct with BIFF8 XF record data. */
void FillFromXF8( sal_uInt32 nBorder1, sal_uInt32 nBorder2 );
/** Fills this struct with BIFF8 CF (conditional format) record data. */
void FillFromCF8( sal_uInt16 nLineStyle, sal_uInt32 nLineColor, sal_uInt32 nFlags );
/** Inserts a box item representing this border style into the item set.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet(
SfxItemSet& rItemSet,
const XclImpPalette& rPalette,
bool bSkipPoolDefs = false ) const;
};
// ----------------------------------------------------------------------------
/** Extends the XclCellArea struct for import.
@descr Provides functions to fill from Excel record data and to fill to item sets. */
struct XclImpCellArea : public XclCellArea
{
bool mbForeUsed; /// true = Foreground color used.
bool mbBackUsed; /// true = Background color used.
bool mbPattUsed; /// true = Pattern used.
explicit XclImpCellArea();
/** Sets colors and pattern state to used or unused. */
void SetUsedFlags( bool bUsed );
/** Fills this struct with BIFF2 XF record data. */
void FillFromXF2( sal_uInt8 nFlags );
/** Fills this struct with BIFF3/BIFF4 XF record data. */
void FillFromXF3( sal_uInt16 nArea );
/** Fills this struct with BIFF5/BIFF7 XF record data. */
void FillFromXF5( sal_uInt32 nArea );
/** Fills this struct with BIFF8 XF record data. */
void FillFromXF8( sal_uInt32 nBorder2, sal_uInt16 nArea );
/** Fills this struct with BIFF8 CF (conditional format) record data. */
void FillFromCF8( sal_uInt16 nPattern, sal_uInt16 nColor, sal_uInt32 nFlags );
/** Inserts a brush item representing this area style into the item set.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items. */
void FillToItemSet(
SfxItemSet& rItemSet,
const XclImpPalette& rPalette,
bool bSkipPoolDefs = false ) const;
};
// ----------------------------------------------------------------------------
/** Represents an XF record index with additional information. */
class XclImpXFIndex
{
public:
inline explicit XclImpXFIndex( sal_uInt16 nXFIndex, bool bBoolCell = false ) :
mnXFIndex( nXFIndex ), mbBoolCell( bBoolCell ) {}
inline sal_uInt16 GetXFIndex() const { return mnXFIndex; }
inline bool IsBoolCell() const { return mbBoolCell; }
private:
sal_uInt16 mnXFIndex; /// The XF record index.
bool mbBoolCell; /// true = A Boolean value cell.
};
inline bool operator==( const XclImpXFIndex& rLeft, const XclImpXFIndex& rRight )
{ return (rLeft.GetXFIndex() == rRight.GetXFIndex()) && (rLeft.IsBoolCell() == rRight.IsBoolCell()); }
inline bool operator!=( const XclImpXFIndex& rLeft, const XclImpXFIndex& rRight )
{ return !(rLeft == rRight); }
// ----------------------------------------------------------------------------
/** Contains all data of a XF record and a Calc item set. */
class XclImpXF : public XclXFBase, protected XclImpRoot, ScfNoCopy
{
public:
explicit XclImpXF( const XclImpRoot& rRoot );
virtual ~XclImpXF();
/** Reads an XF record. */
void ReadXF( XclImpStream& rStrm );
inline sal_uInt8 GetHorAlign() const { return maAlignment.mnHorAlign; }
inline sal_uInt8 GetVerAlign() const { return maAlignment.mnVerAlign; }
inline sal_uInt16 GetFontIndex() const { return mnXclFont; }
/** Creates a Calc item set containing an item set with all cell properties.
@param bSkipPoolDefs true = Do not put items equal to pool default; false = Put all items.
@return A read-only reference to the item set stored internally. */
const ScPatternAttr& CreatePattern( bool bSkipPoolDefs = false );
/** Inserts all formatting attributes to the specified area in the Calc document.
@param nForcedNumFmt If not set to NUMBERFORMAT_ENTRY_NOT_FOUND, it will overwrite
the number format of the XF. */
void ApplyPattern(
SCCOL nScCol1, SCROW nScRow1,
SCCOL nScCol2, SCROW nScRow2,
SCTAB nScTab,
ULONG nForceScNumFmt = NUMBERFORMAT_ENTRY_NOT_FOUND );
private:
void ReadXF2( XclImpStream& rStrm );
void ReadXF3( XclImpStream& rStrm );
void ReadXF4( XclImpStream& rStrm );
void ReadXF5( XclImpStream& rStrm );
void ReadXF8( XclImpStream& rStrm );
/** Sets all "attribute used" flags according to the passed mask.
@descr In cell XFs, a set bit represents "used", in style XFs it is a cleared bit.
Therefore mbCellXF must be set correctly before calling this method. */
void SetUsedFlags( sal_uInt8 nUsedFlags );
/** Sets own "attribute used" flags, if attributes are different from passed parent XF. */
void UpdateUsedFlags( const XclImpXF& rParentXF );
private:
typedef ::std::auto_ptr< ScPatternAttr > ScPatternAttrPtr;
ScPatternAttrPtr mpPattern; /// Calc item set.
ScStyleSheet* mpStyleSheet; /// Calc cell style sheet.
XclImpCellProt maProtection; /// Cell protection flags.
XclImpCellAlign maAlignment; /// All alignment attributes.
XclImpCellBorder maBorder; /// Border line style.
XclImpCellArea maArea; /// Background area style.
sal_uInt16 mnXclNumFmt; /// Index to number format.
sal_uInt16 mnXclFont; /// Index to font record.
};
// ----------------------------------------------------------------------------
/** Contains all data of a cell style associated with an XF record. */
class XclImpStyle : protected XclImpRoot
{
public:
explicit XclImpStyle( const XclImpRoot& rRoot );
/** Reads a STYLE record. */
void ReadStyle( XclImpStream& rStrm );
inline const String& GetName() const { return maName; }
inline sal_uInt16 GetXfId() const { return mnXfId; }
inline bool IsBuiltin() const { return mbBuiltin && (mnBuiltinId != EXC_STYLE_USERDEF); }
inline sal_uInt8 GetBuiltinId() const { return mnBuiltinId; }
inline sal_uInt8 GetLevel() const { return mnLevel; }
/** Creates a cell style sheet and inserts it into the Calc document.
@return The pointer to the cell style sheet, or 0, if there is no style sheet. */
ScStyleSheet* CreateStyleSheet();
/** Creates the Calc style sheet, if this is a user-defined style. */
void CreateUserStyle( const String& rFinalName );
private:
String maName; /// Cell style name.
sal_uInt16 mnXfId; /// Formatting for this cell style.
sal_uInt8 mnBuiltinId; /// Identifier for builtin styles.
sal_uInt8 mnLevel; /// Level for builtin column/row styles.
bool mbBuiltin; /// True = builtin style.
bool mbCustom; /// True = customized builtin style.
bool mbHidden; /// True = style not visible in GUI.
String maFinalName; /// Final name used in the Calc document.
ScStyleSheet* mpStyleSheet; /// Calc cell style sheet.
};
// ----------------------------------------------------------------------------
/** Contains all XF records occured in the file.
@descr This class is able to read XF records (BIFF2 - BIFF8) and STYLE records (BIFF8). */
class XclImpXFBuffer : protected XclImpRoot, ScfNoCopy
{
public:
explicit XclImpXFBuffer( const XclImpRoot& rRoot );
/** Clears all buffered data, used to set up for a new sheet. */
void Initialize();
/** Reads an XF record. */
void ReadXF( XclImpStream& rStrm );
/** Reads a STYLE record. */
void ReadStyle( XclImpStream& rStrm );
/** Returns the object that stores all contents of an XF record. */
inline XclImpXF* GetXF( sal_uInt16 nXFIndex ) const
{ return maXFList.GetObject( nXFIndex ); }
/** Returns the index to the Excel font used in the specified XF record. */
sal_uInt16 GetFontIndex( sal_uInt16 nXFIndex ) const;
/** Returns the Excel font used in the specified XF record. */
const XclImpFont* GetFont( sal_uInt16 nXFIndex ) const;
/** Creates all user defined style sheets. */
void CreateUserStyles();
/** Creates a cell style sheet of the passed XF and inserts it into the Calc document.
@return The pointer to the cell style sheet, or 0, if there is no style sheet. */
ScStyleSheet* CreateStyleSheet( sal_uInt16 nXFIndex );
/** Inserts formatting attributes from an XF to the specified area in the Calc document.
@param nForcedNumFmt If not set to NUMBERFORMAT_ENTRY_NOT_FOUND, it will overwrite
the number format of the XF. */
void ApplyPattern(
SCCOL nScCol1, SCROW nScRow1,
SCCOL nScCol2, SCROW nScRow2,
SCTAB nScTab, const XclImpXFIndex& rXFIndex );
private:
typedef ScfDelList< XclImpStyle > XclImpStyleList;
typedef ::std::map< sal_uInt16, XclImpStyle* > XclImpStyleMap;
ScfDelList< XclImpXF > maXFList; /// List of contents of all XF record.
XclImpStyleList maBuiltinStyles; /// List of built-in cell styles.
XclImpStyleList maUserStyles; /// List of user defined cell styles.
XclImpStyleMap maStylesByXf; /// Maps XF records to cell styles.
};
// Buffer for XF indexes in cells =============================================
/** Contains an (encoded) XF index for a range of rows in a single column. */
class XclImpXFRange
{
DECL_FIXEDMEMPOOL_NEWDEL( XclImpXFRange )
public:
SCROW mnScRow1; /// The first row of an equal-formatted range.
SCROW mnScRow2; /// The last row of an equal-formatted range.
XclImpXFIndex maXFIndex; /// Extended XF index.
inline explicit XclImpXFRange( SCROW nScRow, const XclImpXFIndex& rXFIndex );
inline explicit XclImpXFRange( SCROW nFirstScRow, SCROW nLastScRow, const XclImpXFIndex& rXFIndex );
/** Returns true, if nScRow is contained in own row range. */
inline bool Contains( SCROW nScRow ) const;
/** Returns true, if the range has been expanded. */
bool Expand( SCROW nScRow, const XclImpXFIndex& rXFIndex );
/** Returns true, if the range has been expanded. */
bool Expand( const XclImpXFRange& rNextRange );
};
inline XclImpXFRange::XclImpXFRange( SCROW nScRow, const XclImpXFIndex& rXFIndex ) :
mnScRow1( nScRow ),
mnScRow2( nScRow ),
maXFIndex( rXFIndex )
{
}
inline XclImpXFRange::XclImpXFRange( SCROW nFirstScRow, SCROW nLastScRow, const XclImpXFIndex& rXFIndex ) :
mnScRow1( nFirstScRow ),
mnScRow2( nLastScRow ),
maXFIndex( rXFIndex )
{
}
inline bool XclImpXFRange::Contains( SCROW nScRow ) const
{
return (mnScRow1 <= nScRow) && (nScRow <= mnScRow2);
}
// ----------------------------------------------------------------------------
/** Contains the XF indexes for every used cell in a column. */
class XclImpXFRangeColumn : ScfNoCopy
{
public:
inline explicit XclImpXFRangeColumn() {}
/** Returns the first formatted cell range in this column. */
inline XclImpXFRange* First() { return maIndexList.First(); }
/** Returns the next formatted cell range in this column. */
inline XclImpXFRange* Next() { return maIndexList.Next(); }
/** Inserts a single row range into the list. */
void SetDefaultXF( const XclImpXFIndex& rXFIndex );
/** Inserts a new (encoded) XF index (first try to expand the last range). */
void SetXF( SCROW nScRow, const XclImpXFIndex& rXFIndex );
private:
/** Finds the previous and next row range from row position nScRow.
@descr If an XF still exists, it is contained in rpPrevRange. */
void Find(
XclImpXFRange*& rpPrevRange,
XclImpXFRange*& rpNextRange,
ULONG& rnNextIndex,
SCROW nScRow ) const;
/** Tries to concatenate a range with its predecessor.
@descr The ranges must have the same XF index and must not have a gap.
The resulting range has the index nIndex-1. */
void TryConcatPrev( ULONG nIndex );
private:
ScfDelList< XclImpXFRange > maIndexList; /// The list of XF index range.
};
// ----------------------------------------------------------------------------
/** Contains the XF indexes for every used cell in a single sheet. */
class XclImpXFRangeBuffer : protected XclImpRoot, ScfNoCopy
{
public:
explicit XclImpXFRangeBuffer( const XclImpRoot& rRoot );
virtual ~XclImpXFRangeBuffer();
/** Clears all buffered data, used to set up for a new sheet. */
void Initialize();
/** Inserts a new XF index. */
void SetXF( const ScAddress& rScPos, sal_uInt16 nXFIndex );
/** Inserts a new XF index for blank cells. */
void SetBlankXF( const ScAddress& rScPos, sal_uInt16 nXFIndex );
/** Inserts a new XF index for boolean cells. */
void SetBoolXF( const ScAddress& rScPos, sal_uInt16 nXFIndex );
/** Inserts a new XF index for all cells in a row. */
void SetRowDefXF( SCROW nScRow, sal_uInt16 nXFIndex );
/** Inserts a new XF index for all cells in a column. */
void SetColumnDefXF( SCCOL nScCol, sal_uInt16 nXFIndex );
/** Inserts a range of hyperlink cells. */
void SetHyperlink( const XclRange& rXclRange, const String& rUrl );
/** Inserts the first cell of a merged cell range. */
void SetMerge( SCCOL nScCol, SCROW nScRow );
/** Inserts a complete merged cell range. */
void SetMerge( SCCOL nScCol1, SCROW nScRow1, SCCOL nScCol2, SCROW nScRow2 );
/** Applies styles and cell merging to the current sheet in the document. */
void Finalize();
private:
/** Insertion mode of an XF index. */
enum XclImpXFInsertMode
{
xlXFModeCell, /// Filled cell.
xlXFModeBoolCell, /// Cell with a single Boolean value.
xlXFModeBlank, /// Blank cell.
xlXFModeRow /// Row default XF.
};
private:
/** Inserts a new XF index for the specified cell type. */
void SetXF( const ScAddress& rScPos, sal_uInt16 nXFIndex, XclImpXFInsertMode eMode );
/** Copies border of the last cell of the range to the first cell to keep it visible
when the range is merged.
@param nLine
BOX_LINE_RIGHT = copy most-right border of top row;
BOX_LINE_BOTTOM = copy most-bottom border of first column. */
void SetBorderLine( const ScRange& rRange, SCTAB nScTab, USHORT nLine );
private:
typedef ScfRef< XclImpXFRangeColumn > XclImpXFRangeColumnRef;
typedef ::std::vector< XclImpXFRangeColumnRef > XclImpXFRangeColumnVec;
typedef ::std::pair< XclRange, String > XclImpHyperlinkRange;
typedef ::std::list< XclImpHyperlinkRange > XclImpHyperlinkList;
XclImpXFRangeColumnVec maColumns; /// Array of column XF index buffers.
XclImpHyperlinkList maHyperlinks; /// Maps URLs to hyperlink cells.
ScRangeList maMergeList; /// List of merged cell ranges.
};
// ============================================================================
#endif
|