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
|
/* -*- 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 .
*/
#pragma once
#include <vector>
#include <map>
#include <o3tl/sorted_vector.hxx>
#include "richstring.hxx"
#include "worksheethelper.hxx"
#include "addressconverter.hxx"
namespace com::sun::star {
namespace util { struct DateTime; }
}
namespace oox::xls {
/** Stores basic data about cell values and formatting. */
struct CellModel
{
ScAddress 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
{
ScRange 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 ScAddress& rCellAddr );
/** Returns true, if the passed cell address is valid for a shared formula. */
bool isValidSharedRef( const ScAddress& 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 );
private:
typedef ::std::map< sal_Int32, ValueRangeVector > ColSpanVectorMap;
ColSpanVectorMap maColSpans; /// Buffered 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 css::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 an ISO 8601 date cell into the sheet. */
void setDateCell( const CellModel& rModel, const OUString& rDateString );
void createSharedFormula(
const ScAddress& rRange,
const ApiTokenSequence& rTokens);
/** Inserts the passed token array as array formula. */
void createArrayFormula(
const ScRange& rRange,
const ApiTokenSequence& rTokens );
/** Sets a multiple table operation to the passed range. */
void createTableOperation(
const ScRange& rRange,
const DataTableModel& rModel );
/** 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 ScRange& rRange );
/** Processes the cell formatting data of the passed cell. */
void setCellFormat( const CellModel& rModel );
/** Final processing after the sheet has been imported. */
void finalizeImport();
/** Sets the passed formula token array into a cell. */
void setCellFormula(
const ScAddress& rCellAddr,
const ApiTokenSequence& rTokens );
private:
/** Creates a formula token array representing the shared formula with the
passed identifier. */
ApiTokenSequence resolveSharedFormula( const ScAddress& rMapKey ) const;
/** Inserts the passed array formula into the sheet. */
void finalizeArrayFormula(
const ScRange& rRange,
const ApiTokenSequence& rTokens ) const;
/** Inserts the passed table operation into the sheet. */
void finalizeTableOperation(
const ScRange& rRange, const DataTableModel& rModel );
/** Writes all cell formatting attributes to the passed cell range list. (depreciates writeXfIdRangeProperties) */
void applyCellMerging( const ScRange& rRange );
void addColXfStyles();
void addColXfStyleProcessRowRanges();
private:
/** Stores cell range address and formula token array of an array formula. */
typedef std::pair< ScRange, ApiTokenSequence > ArrayFormula;
typedef ::std::vector< ArrayFormula > ArrayFormulaVector;
/** Stores cell range address and settings of a table operation. */
typedef std::pair< ScRange, DataTableModel > TableOperation;
/** 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;
struct RowRangeStyle
{
sal_Int32 mnStartRow;
sal_Int32 mnEndRow;
XfIdNumFmtKey mnNumFmt;
};
struct StyleRowRangeComp
{
bool operator() (const RowRangeStyle& lhs, const RowRangeStyle& rhs) const
{
// This end-vs-start comparison is needed by the lower_bound() use
// in SheetDataBuffer::addColXfStyleProcessRowRanges() that searches
// for partially overlapping ranges. In all other places the ranges
// should be non-overlapping, in which case this is the same as the "normal"
// comparison.
return lhs.mnEndRow<rhs.mnStartRow;
}
};
typedef ::o3tl::sorted_vector< RowRangeStyle, StyleRowRangeComp > RowStyles;
typedef ::std::map< sal_Int32, RowStyles > ColStyles;
typedef ::std::vector< RowRangeStyle > TmpRowStyles;
typedef ::std::map< sal_Int32, TmpRowStyles > TmpColStyles;
/** Stores information about a merged cell range. */
struct MergedRange
{
ScRange maRange; /// The formatted cell range.
sal_Int32 mnHorAlign; /// Horizontal alignment in the range.
explicit MergedRange( const ScRange& rRange );
explicit MergedRange( const ScAddress& rAddress, sal_Int32 nHorAlign );
bool tryExpand( const ScAddress& rAddress, sal_Int32 nHorAlign );
};
typedef ::std::vector< MergedRange > MergedRangeVector;
ColStyles maStylesPerColumn; /// Stores cell styles by column ( in row ranges )
CellBlockBuffer maCellBlocks; /// Manages all open cell blocks.
ArrayFormulaVector maArrayFormulas; /// All array formulas in the sheet.
std::vector< TableOperation >
maTableOperations; /// All table operations in the sheet.
::std::map< BinAddress, ApiTokenSequence >
maSharedFormulas; /// Maps shared formula base address to defined name token index.
ScAddress maSharedFmlaAddr; /// Address of a cell containing a pending shared formula.
ScAddress maSharedBaseAddr; /// Base address of the pending shared formula.
XfIdRowRange maXfIdRowRange; /// Cached XF identifier for a range of rows.
std::map< XfIdNumFmtKey, ScRangeList >
maXfIdRangeLists; /// Collected XF identifiers for cell rangelists.
MergedRangeVector maMergedRanges; /// Merged cell ranges.
MergedRangeVector 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 oox::xls
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|