blob: d162391c26f3e0a953b358eac1ce888a1ad6f884 (
plain)
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
|
/* -*- 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_TABLEBUFFER_HXX
#define OOX_XLS_TABLEBUFFER_HXX
#include <com/sun/star/table/CellRangeAddress.hpp>
#include "autofilterbuffer.hxx"
#include "workbookhelper.hxx"
namespace oox {
namespace xls {
// ============================================================================
struct TableModel
{
::com::sun::star::table::CellRangeAddress
maRange; /// Original (unchecked) range of the table.
::rtl::OUString maProgName; /// Programmatical name.
::rtl::OUString maDisplayName; /// Display name.
sal_Int32 mnId; /// Unique table identifier.
sal_Int32 mnType; /// Table type (worksheet, query, etc.).
sal_Int32 mnHeaderRows; /// Number of header rows.
sal_Int32 mnTotalsRows; /// Number of totals rows.
explicit TableModel();
};
// ----------------------------------------------------------------------------
class Table : public WorkbookHelper
{
public:
explicit Table( const WorkbookHelper& rHelper );
/** Imports a table definition from the passed attributes. */
void importTable( const AttributeList& rAttribs, sal_Int16 nSheet );
/** Imports a table definition from a TABLE record. */
void importTable( SequenceInputStream& rStrm, sal_Int16 nSheet );
/** Creates a new auto filter and stores it internally. */
inline AutoFilter& createAutoFilter() { return maAutoFilters.createAutoFilter(); }
/** Creates a database range from this tables. */
void finalizeImport();
void applyAutoFilters();
/** Returns the unique table identifier. */
inline sal_Int32 getTableId() const { return maModel.mnId; }
/** Returns the token index used in API token arrays (com.sun.star.sheet.FormulaToken). */
inline sal_Int32 getTokenIndex() const { return mnTokenIndex; }
/** Returns the original display name of the table. */
inline const ::rtl::OUString& getDisplayName() const { return maModel.maDisplayName; }
/** Returns the original (unchecked) total range of the table. */
inline const ::com::sun::star::table::CellRangeAddress& getOriginalRange() const { return maModel.maRange; }
/** Returns the cell range of this table. */
inline const ::com::sun::star::table::CellRangeAddress& getRange() const { return maDestRange; }
/** Returns the number of columns of this table. */
inline sal_Int32 getWidth() const { return maDestRange.EndColumn - maDestRange.StartColumn + 1; }
/** Returns the number of rows of this table. */
inline sal_Int32 getHeight() const { return maDestRange.EndRow - maDestRange.StartRow + 1; }
/** Returns the number of header rows in the table range. */
inline sal_Int32 getHeaderRows() const { return maModel.mnHeaderRows; }
/** Returns the number of totals rows in the table range. */
inline sal_Int32 getTotalsRows() const { return maModel.mnTotalsRows; }
private:
TableModel maModel;
AutoFilterBuffer maAutoFilters; /// Filter settings for this table.
::rtl::OUString maDBRangeName; /// Name of the databae range in the Calc document.
::com::sun::star::table::CellRangeAddress
maDestRange; /// Validated range of the table in the worksheet.
sal_Int32 mnTokenIndex; /// Token index used in API token array.
};
typedef ::boost::shared_ptr< Table > TableRef;
// ============================================================================
class TableBuffer : public WorkbookHelper
{
public:
explicit TableBuffer( const WorkbookHelper& rHelper );
/** Creates a new empty table. */
Table& createTable();
/** Creates database ranges from all imported tables. */
void finalizeImport();
/** Applies autofilters from created database range ( requires finalizeImport to have run before being called */
void applyAutoFilters();
/** Returns a table by its identifier. */
TableRef getTable( sal_Int32 nTableId ) const;
/** Returns a table by its display name. */
TableRef getTable( const ::rtl::OUString& rDispName ) const;
private:
/** Inserts the passed table into the maps according to its identifier and name. */
void insertTableToMaps( const TableRef& rxTable );
private:
typedef RefVector< Table > TableVector;
typedef RefMap< sal_Int32, Table > TableIdMap;
typedef RefMap< ::rtl::OUString, Table > TableNameMap;
TableVector maTables;
TableIdMap maIdTables;
TableNameMap maNameTables;
};
// ============================================================================
} // namespace xls
} // namespace oox
#endif
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|
