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
|
/* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
/*
* This file is part of the LibreOffice project.
*
* This Source Code Form is subject to the terms of the Mozilla Public
* License, v. 2.0. If a copy of the MPL was not distributed with this
* file, You can obtain one at http://mozilla.org/MPL/2.0/.
*
* This file incorporates work covered by the following license notice:
*
* Licensed to the Apache Software Foundation (ASF) under one or more
* contributor license agreements. See the NOTICE file distributed
* with this work for additional information regarding copyright
* ownership. The ASF licenses this file to you under the Apache
* License, Version 2.0 (the "License"); you may not use this file
* except in compliance with the License. You may obtain a copy of
* the License at http://www.apache.org/licenses/LICENSE-2.0 .
*/
#ifndef OOX_XLS_SHEETDATABUFFER_HXX
#define OOX_XLS_SHEETDATABUFFER_HXX
#include <list>
#include <map>
#include "richstring.hxx"
#include "worksheethelper.hxx"
namespace com { namespace sun { namespace star {
namespace util { struct DateTime; }
} } }
namespace oox {
namespace xls {
// ============================================================================
/** Stores basic data about cell values and formatting. */
struct CellModel
{
::com::sun::star::table::CellAddress
maCellAddr; /// The address of the current cell.
sal_Int32 mnCellType; /// Data type of the cell value.
sal_Int32 mnXfId; /// XF (cell formatting) identifier.
bool mbShowPhonetic; /// True = show phonetic text.
explicit CellModel();
};
// ----------------------------------------------------------------------------
/** Stores data about cell formulas. */
struct CellFormulaModel
{
::com::sun::star::table::CellRangeAddress
maFormulaRef; /// Formula range for array/shared formulas and data tables.
sal_Int32 mnFormulaType; /// Type of the formula (regular, array, shared, table).
sal_Int32 mnSharedId; /// Identifier of a shared formula (OOXML only).
explicit CellFormulaModel();
/** Returns true, if the passed cell address is valid for an array formula. */
bool isValidArrayRef( const ::com::sun::star::table::CellAddress& rCellAddr );
/** Returns true, if the passed cell address is valid for a shared formula. */
bool isValidSharedRef( const ::com::sun::star::table::CellAddress& rCellAddr );
};
// ----------------------------------------------------------------------------
/** Stores data about table operations. */
struct DataTableModel
{
OUString maRef1; /// First reference cell for table operations.
OUString maRef2; /// Second reference cell for table operations.
bool mb2dTable; /// True = 2-dimensional data table.
bool mbRowTable; /// True = row oriented data table.
bool mbRef1Deleted; /// True = first reference cell deleted.
bool mbRef2Deleted; /// True = second reference cell deleted.
explicit DataTableModel();
};
// ============================================================================
/** Manages all cell blocks currently in use. */
class CellBlockBuffer : public WorksheetHelper
{
public:
explicit CellBlockBuffer( const WorksheetHelper& rHelper );
/** Sets column span information for a row. */
void setColSpans( sal_Int32 nRow, const ValueRangeSet& rColSpans );
/** Inserts all cells of all open cell blocks into the Calc document. */
void finalizeImport();
private:
typedef ::std::map< sal_Int32, ValueRangeVector > ColSpanVectorMap;
ColSpanVectorMap maColSpans; /// Buffereed column spans, mapped by row index.
sal_Int32 mnCurrRow; /// Current row index used for buffered cell import.
};
// ============================================================================
/** Manages the cell contents and cell formatting of a sheet.
*/
class SheetDataBuffer : public WorksheetHelper
{
public:
explicit SheetDataBuffer( const WorksheetHelper& rHelper );
/** Sets column span information for a row. */
void setColSpans( sal_Int32 nRow, const ValueRangeSet& rColSpans );
/** Inserts a blank cell (with formatting) into the sheet. */
void setBlankCell( const CellModel& rModel );
/** Inserts a value cell into the sheet. */
void setValueCell( const CellModel& rModel, double fValue );
/** Inserts a simple string cell into the sheet. */
void setStringCell( const CellModel& rModel, const OUString& rText );
/** Inserts a rich-string cell into the sheet. */
void setStringCell( const CellModel& rModel, const RichStringRef& rxString );
/** Inserts a shared string cell into the sheet. */
void setStringCell( const CellModel& rModel, sal_Int32 nStringId );
/** Inserts a date/time cell into the sheet and adjusts number format. */
void setDateTimeCell( const CellModel& rModel, const ::com::sun::star::util::DateTime& rDateTime );
/** Inserts a boolean cell into the sheet and adjusts number format. */
void setBooleanCell( const CellModel& rModel, bool bValue );
/** Inserts an error cell from the passed error code into the sheet. */
void setErrorCell( const CellModel& rModel, const OUString& rErrorCode );
/** Inserts an error cell from the passed BIFF error code into the sheet. */
void setErrorCell( const CellModel& rModel, sal_uInt8 nErrorCode );
/** Inserts a formula cell into the sheet. */
void setFormulaCell( const CellModel& rModel, const ApiTokenSequence& rTokens );
/** Inserts the passed token array as array formula. */
void createArrayFormula(
const ::com::sun::star::table::CellRangeAddress& rRange,
const ApiTokenSequence& rTokens );
/** Sets a multiple table operation to the passed range. */
void createTableOperation(
const ::com::sun::star::table::CellRangeAddress& rRange,
const DataTableModel& rModel );
/** Creates a named range with a special name for a shared formula with the
specified base address and formula definition (BIFF only). */
void createSharedFormula(
const ::com::sun::star::table::CellAddress& rCellAddr,
const ApiTokenSequence& rTokens );
/** Sets default cell formatting for the specified range of rows. */
void setRowFormat( sal_Int32 nRow, sal_Int32 nXfId, bool bCustomFormat );
/** Merges the cells in the passed cell range. */
void setMergedRange( const ::com::sun::star::table::CellRangeAddress& rRange );
/** Sets a standard number format (constant from com.sun.star.util.NumberFormat) to the specified cell. */
void setStandardNumFmt(
const ::com::sun::star::table::CellAddress& rCellAddr,
sal_Int16 nStdNumFmt );
/** Processes the cell formatting data of the passed cell.
@param nNumFmtId If set, overrides number format of the cell XF. */
void setCellFormat( const CellModel& rModel, sal_Int32 nNumFmtId = -1 );
/** Final processing after the sheet has been imported. */
void finalizeImport();
private:
struct XfIdRowRange;
/** Sets the passed formula token array into a cell. */
void setCellFormula(
const ::com::sun::star::table::CellAddress& rCellAddr,
const ApiTokenSequence& rTokens );
/** Creates a named range with a special name for a shared formula with the
specified base address and formula definition. */
void createSharedFormula( const BinAddress& rMapKey, const ApiTokenSequence& rTokens );
/** Creates a formula token array representing the shared formula with the
passed identifier. */
ApiTokenSequence resolveSharedFormula( const BinAddress& rMapKey ) const;
/** Inserts the passed array formula into the sheet. */
void finalizeArrayFormula(
const ::com::sun::star::table::CellRangeAddress& rRange,
const ApiTokenSequence& rTokens ) const;
/** Inserts the passed table operation into the sheet. */
void finalizeTableOperation(
const ::com::sun::star::table::CellRangeAddress& rRange,
const DataTableModel& rModel ) const;
/** Writes all cell formatting attributes to the passed cell range list. (depreciates writeXfIdRangeProperties) */
void writeXfIdRangeListProperties( sal_Int32 nXfId, sal_Int32 nNumFmtId, const ApiCellRangeList& rRanges ) const;
void applyCellMerging( const ::com::sun::star::table::CellRangeAddress& rRange );
private:
/** Stores cell range address and formula token array of an array formula. */
typedef ::std::pair< ::com::sun::star::table::CellRangeAddress, ApiTokenSequence > ArrayFormula;
typedef ::std::list< ArrayFormula > ArrayFormulaList;
/** Stores cell range address and settings of a table operation. */
typedef ::std::pair< ::com::sun::star::table::CellRangeAddress, DataTableModel > TableOperation;
typedef ::std::list< TableOperation > TableOperationList;
/** Stores information about a range of rows with equal cell formatting. */
struct XfIdRowRange
{
ValueRange maRowRange; /// Indexes of first and last row.
sal_Int32 mnXfId; /// XF identifier for the row range.
explicit XfIdRowRange();
void set( sal_Int32 nRow, sal_Int32 nXfId );
bool tryExpand( sal_Int32 nRow, sal_Int32 nXfId );
};
typedef ::std::pair< sal_Int32, sal_Int32 > XfIdNumFmtKey;
typedef ::std::map< XfIdNumFmtKey, ApiCellRangeList > XfIdRangeListMap;
/** Stores information about a merged cell range. */
struct MergedRange
{
::com::sun::star::table::CellRangeAddress
maRange; /// The formatted cell range.
sal_Int32 mnHorAlign; /// Horizontal alignment in the range.
explicit MergedRange( const ::com::sun::star::table::CellRangeAddress& rRange );
explicit MergedRange( const ::com::sun::star::table::CellAddress& rAddress, sal_Int32 nHorAlign );
bool tryExpand( const ::com::sun::star::table::CellAddress& rAddress, sal_Int32 nHorAlign );
};
typedef ::std::list< MergedRange > MergedRangeList;
CellBlockBuffer maCellBlocks; /// Manages all open cell blocks.
ArrayFormulaList maArrayFormulas; /// All array formulas in the sheet.
TableOperationList maTableOperations; /// All table operations in the sheet.
SharedFormulaMap maSharedFormulas; /// Maps shared formula base address to defined name token index.
::com::sun::star::table::CellAddress
maSharedFmlaAddr; /// Address of a cell containing a pending shared formula.
BinAddress maSharedBaseAddr; /// Base address of the pending shared formula.
XfIdRowRange maXfIdRowRange; /// Cached XF identifier for a range of rows.
XfIdRangeListMap maXfIdRangeLists; /// Collected XF identifiers for cell rangelists.
MergedRangeList maMergedRanges; /// Merged cell ranges.
MergedRangeList maCenterFillRanges; /// Merged cell ranges from 'center across' or 'fill' alignment.
bool mbPendingSharedFmla; /// True = maSharedFmlaAddr and maSharedBaseAddr are valid.
std::map< sal_Int32, std::vector< ValueRange > > maXfIdRowRangeList; /// Cached XF identifiers for a ranges of rows, we try and process rowranges with the same XF id together
};
// ============================================================================
} // namespace xls
} // namespace oox
#endif
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
