Line data Source code
1 : /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 : /*
3 : * This file is part of the LibreOffice project.
4 : *
5 : * This Source Code Form is subject to the terms of the Mozilla Public
6 : * License, v. 2.0. If a copy of the MPL was not distributed with this
7 : * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 : *
9 : * This file incorporates work covered by the following license notice:
10 : *
11 : * Licensed to the Apache Software Foundation (ASF) under one or more
12 : * contributor license agreements. See the NOTICE file distributed
13 : * with this work for additional information regarding copyright
14 : * ownership. The ASF licenses this file to you under the Apache
15 : * License, Version 2.0 (the "License"); you may not use this file
16 : * except in compliance with the License. You may obtain a copy of
17 : * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 : */
19 :
20 : #ifndef INCLUDED_SC_SOURCE_FILTER_INC_SHEETDATABUFFER_HXX
21 : #define INCLUDED_SC_SOURCE_FILTER_INC_SHEETDATABUFFER_HXX
22 :
23 : #include <list>
24 : #include <map>
25 : #include "richstring.hxx"
26 : #include "worksheethelper.hxx"
27 :
28 : namespace com { namespace sun { namespace star {
29 : namespace util { struct DateTime; }
30 : } } }
31 :
32 : namespace oox {
33 : namespace xls {
34 :
35 : /** Stores basic data about cell values and formatting. */
36 : struct CellModel
37 : {
38 : ::com::sun::star::table::CellAddress
39 : maCellAddr; /// The address of the current cell.
40 : sal_Int32 mnCellType; /// Data type of the cell value.
41 : sal_Int32 mnXfId; /// XF (cell formatting) identifier.
42 : bool mbShowPhonetic; /// True = show phonetic text.
43 :
44 : explicit CellModel();
45 : };
46 :
47 : /** Stores data about cell formulas. */
48 : struct CellFormulaModel
49 : {
50 : ::com::sun::star::table::CellRangeAddress
51 : maFormulaRef; /// Formula range for array/shared formulas and data tables.
52 : sal_Int32 mnFormulaType; /// Type of the formula (regular, array, shared, table).
53 : sal_Int32 mnSharedId; /// Identifier of a shared formula (OOXML only).
54 :
55 : explicit CellFormulaModel();
56 :
57 : /** Returns true, if the passed cell address is valid for an array formula. */
58 : bool isValidArrayRef( const ::com::sun::star::table::CellAddress& rCellAddr );
59 : /** Returns true, if the passed cell address is valid for a shared formula. */
60 : bool isValidSharedRef( const ::com::sun::star::table::CellAddress& rCellAddr );
61 : };
62 :
63 : /** Stores data about table operations. */
64 284 : struct DataTableModel
65 : {
66 : OUString maRef1; /// First reference cell for table operations.
67 : OUString maRef2; /// Second reference cell for table operations.
68 : bool mb2dTable; /// True = 2-dimensional data table.
69 : bool mbRowTable; /// True = row oriented data table.
70 : bool mbRef1Deleted; /// True = first reference cell deleted.
71 : bool mbRef2Deleted; /// True = second reference cell deleted.
72 :
73 : explicit DataTableModel();
74 : };
75 :
76 : /** Manages all cell blocks currently in use. */
77 260 : class CellBlockBuffer : public WorksheetHelper
78 : {
79 : public:
80 : explicit CellBlockBuffer( const WorksheetHelper& rHelper );
81 :
82 : /** Sets column span information for a row. */
83 : void setColSpans( sal_Int32 nRow, const ValueRangeSet& rColSpans );
84 :
85 : /** Inserts all cells of all open cell blocks into the Calc document. */
86 : void finalizeImport();
87 :
88 : private:
89 : typedef ::std::map< sal_Int32, ValueRangeVector > ColSpanVectorMap;
90 :
91 : ColSpanVectorMap maColSpans; /// Buffereed column spans, mapped by row index.
92 : sal_Int32 mnCurrRow; /// Current row index used for buffered cell import.
93 : };
94 :
95 : /** Manages the cell contents and cell formatting of a sheet.
96 : */
97 260 : class SheetDataBuffer : public WorksheetHelper
98 : {
99 : public:
100 : explicit SheetDataBuffer( const WorksheetHelper& rHelper );
101 :
102 : /** Sets column span information for a row. */
103 : void setColSpans( sal_Int32 nRow, const ValueRangeSet& rColSpans );
104 :
105 : /** Inserts a blank cell (with formatting) into the sheet. */
106 : void setBlankCell( const CellModel& rModel );
107 : /** Inserts a value cell into the sheet. */
108 : void setValueCell( const CellModel& rModel, double fValue );
109 : /** Inserts a simple string cell into the sheet. */
110 : void setStringCell( const CellModel& rModel, const OUString& rText );
111 : /** Inserts a rich-string cell into the sheet. */
112 : void setStringCell( const CellModel& rModel, const RichStringRef& rxString );
113 : /** Inserts a shared string cell into the sheet. */
114 : void setStringCell( const CellModel& rModel, sal_Int32 nStringId );
115 : /** Inserts a date/time cell into the sheet and adjusts number format. */
116 : void setDateTimeCell( const CellModel& rModel, const ::com::sun::star::util::DateTime& rDateTime );
117 : /** Inserts a boolean cell into the sheet and adjusts number format. */
118 : void setBooleanCell( const CellModel& rModel, bool bValue );
119 : /** Inserts an error cell from the passed error code into the sheet. */
120 : void setErrorCell( const CellModel& rModel, const OUString& rErrorCode );
121 : /** Inserts an error cell from the passed BIFF error code into the sheet. */
122 : void setErrorCell( const CellModel& rModel, sal_uInt8 nErrorCode );
123 : /** Inserts a formula cell into the sheet. */
124 : void setFormulaCell( const CellModel& rModel, const ApiTokenSequence& rTokens );
125 : /** Inserts a ISO 8601 date cell into the sheet. */
126 : void setDateCell( const CellModel& rModel, const OUString& rDateString );
127 :
128 : /** Inserts the passed token array as array formula. */
129 : void createArrayFormula(
130 : const ::com::sun::star::table::CellRangeAddress& rRange,
131 : const ApiTokenSequence& rTokens );
132 : /** Sets a multiple table operation to the passed range. */
133 : void createTableOperation(
134 : const ::com::sun::star::table::CellRangeAddress& rRange,
135 : const DataTableModel& rModel );
136 :
137 : /** Sets default cell formatting for the specified range of rows. */
138 : void setRowFormat( sal_Int32 nRow, sal_Int32 nXfId, bool bCustomFormat );
139 : /** Merges the cells in the passed cell range. */
140 : void setMergedRange( const ::com::sun::star::table::CellRangeAddress& rRange );
141 : /** Sets a standard number format (constant from com.sun.star.util.NumberFormat) to the specified cell. */
142 : void setStandardNumFmt(
143 : const ::com::sun::star::table::CellAddress& rCellAddr,
144 : sal_Int16 nStdNumFmt );
145 : /** Processes the cell formatting data of the passed cell.
146 : @param nNumFmtId If set, overrides number format of the cell XF. */
147 : void setCellFormat( const CellModel& rModel, sal_Int32 nNumFmtId = -1 );
148 :
149 : /** Final processing after the sheet has been imported. */
150 : void finalizeImport();
151 :
152 : private:
153 : struct XfIdRowRange;
154 :
155 : /** Sets the passed formula token array into a cell. */
156 : void setCellFormula(
157 : const ::com::sun::star::table::CellAddress& rCellAddr,
158 : const ApiTokenSequence& rTokens );
159 :
160 : /** Creates a formula token array representing the shared formula with the
161 : passed identifier. */
162 : ApiTokenSequence resolveSharedFormula( const BinAddress& rMapKey ) const;
163 :
164 : /** Inserts the passed array formula into the sheet. */
165 : void finalizeArrayFormula(
166 : const ::com::sun::star::table::CellRangeAddress& rRange,
167 : const ApiTokenSequence& rTokens ) const;
168 : /** Inserts the passed table operation into the sheet. */
169 : void finalizeTableOperation(
170 : const ::com::sun::star::table::CellRangeAddress& rRange, const DataTableModel& rModel );
171 :
172 : /** Writes all cell formatting attributes to the passed cell range list. (depreciates writeXfIdRangeProperties) */
173 : void applyCellMerging( const ::com::sun::star::table::CellRangeAddress& rRange );
174 : void addColXfStyle( sal_Int32 nXfId, sal_Int32 nFormatId, const ::com::sun::star::table::CellRangeAddress& rAddress, bool bProcessRowRange = false );
175 : private:
176 : /** Stores cell range address and formula token array of an array formula. */
177 : typedef ::std::pair< ::com::sun::star::table::CellRangeAddress, ApiTokenSequence > ArrayFormula;
178 : typedef ::std::list< ArrayFormula > ArrayFormulaList;
179 :
180 : /** Stores cell range address and settings of a table operation. */
181 : typedef ::std::pair< ::com::sun::star::table::CellRangeAddress, DataTableModel > TableOperation;
182 : typedef ::std::list< TableOperation > TableOperationList;
183 :
184 : /** Stores information about a range of rows with equal cell formatting. */
185 : struct XfIdRowRange
186 : {
187 : ValueRange maRowRange; /// Indexes of first and last row.
188 : sal_Int32 mnXfId; /// XF identifier for the row range.
189 :
190 : explicit XfIdRowRange();
191 : void set( sal_Int32 nRow, sal_Int32 nXfId );
192 : bool tryExpand( sal_Int32 nRow, sal_Int32 nXfId );
193 : };
194 :
195 : typedef ::std::pair< sal_Int32, sal_Int32 > XfIdNumFmtKey;
196 : typedef ::std::map< XfIdNumFmtKey, ApiCellRangeList > XfIdRangeListMap;
197 :
198 : typedef ::std::pair< sal_Int32, sal_Int32 > RowRange;
199 768 : struct RowRangeStyle
200 : {
201 : sal_Int32 mnStartRow;
202 : sal_Int32 mnEndRow;
203 : XfIdNumFmtKey mnNumFmt;
204 : };
205 : struct StyleRowRangeComp
206 : {
207 3720 : bool operator() (const RowRangeStyle& lhs, const RowRangeStyle& rhs) const
208 : {
209 3720 : return lhs.mnEndRow<rhs.mnStartRow;
210 : }
211 : };
212 : typedef ::std::set< RowRangeStyle, StyleRowRangeComp > RowStyles;
213 : typedef ::std::map< sal_Int32, RowStyles > ColStyles;
214 : /** Stores information about a merged cell range. */
215 : struct MergedRange
216 : {
217 : ::com::sun::star::table::CellRangeAddress
218 : maRange; /// The formatted cell range.
219 : sal_Int32 mnHorAlign; /// Horizontal alignment in the range.
220 :
221 : explicit MergedRange( const ::com::sun::star::table::CellRangeAddress& rRange );
222 : explicit MergedRange( const ::com::sun::star::table::CellAddress& rAddress, sal_Int32 nHorAlign );
223 : bool tryExpand( const ::com::sun::star::table::CellAddress& rAddress, sal_Int32 nHorAlign );
224 : };
225 : typedef ::std::list< MergedRange > MergedRangeList;
226 :
227 : ColStyles maStylesPerColumn; /// Stores cell styles by column ( in row ranges )
228 : CellBlockBuffer maCellBlocks; /// Manages all open cell blocks.
229 : ArrayFormulaList maArrayFormulas; /// All array formulas in the sheet.
230 : TableOperationList maTableOperations; /// All table operations in the sheet.
231 : SharedFormulaMap maSharedFormulas; /// Maps shared formula base address to defined name token index.
232 : ::com::sun::star::table::CellAddress
233 : maSharedFmlaAddr; /// Address of a cell containing a pending shared formula.
234 : BinAddress maSharedBaseAddr; /// Base address of the pending shared formula.
235 : XfIdRowRange maXfIdRowRange; /// Cached XF identifier for a range of rows.
236 : XfIdRangeListMap maXfIdRangeLists; /// Collected XF identifiers for cell rangelists.
237 : MergedRangeList maMergedRanges; /// Merged cell ranges.
238 : MergedRangeList maCenterFillRanges; /// Merged cell ranges from 'center across' or 'fill' alignment.
239 : bool mbPendingSharedFmla; /// True = maSharedFmlaAddr and maSharedBaseAddr are valid.
240 : 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
241 : };
242 :
243 : } // namespace xls
244 : } // namespace oox
245 :
246 : #endif
247 :
248 : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|