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
|
/* -*- 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 <com/sun/star/sheet/DataPilotOutputRangeType.hpp>
#include <com/sun/star/sheet/DataPilotFieldOrientation.hpp>
#include <com/sun/star/uno/Sequence.hxx>
#include <tools/long.hxx>
#include "address.hxx"
#include "dptypes.hxx"
#include "pivot/PivotTableFormats.hxx"
#include "pivot/PivotTableFormatOutput.hxx"
#include <memory>
#include <vector>
namespace com::sun::star::sheet {
struct DataPilotFieldFilter;
struct DataPilotTablePositionData;
struct DataResult;
struct MemberResult;
class XDimensionsSupplier;
}
namespace tools { class Rectangle; }
class ScDocument;
struct ScDPOutLevelData;
class ScDPOutputImpl;
class ScDPObject;
class ScDPOutput
{
private:
ScDocument* mpDocument;
sc::FormatOutput maFormatOutput;
css::uno::Reference<css::sheet::XDimensionsSupplier> mxSource;
ScAddress maStartPos;
std::vector<ScDPOutLevelData> mpColFields;
std::vector<ScDPOutLevelData> mpRowFields;
std::vector<ScDPOutLevelData> mpPageFields;
css::uno::Sequence<css::uno::Sequence<css::sheet::DataResult>> maData;
OUString maDataDescription;
// Number format related parameters
std::unique_ptr<sal_uInt32[]> mpColNumberFormat;
std::unique_ptr<sal_uInt32[]> mpRowNumberFormat;
std::vector<bool> maRowCompactFlags;
sal_Int32 mnColFormatCount;
sal_Int32 mnRowFormatCount;
sal_uInt32 mnSingleNumberFormat;
size_t mnRowDims; // Including empty ones.
// Output geometry related parameters
sal_Int32 mnColCount;
sal_Int32 mnRowCount;
sal_Int32 mnHeaderSize;
SCCOL mnTabStartCol;
SCROW mnTabStartRow;
SCCOL mnMemberStartCol;
SCROW mnMemberStartRow;
SCCOL mnDataStartCol;
SCROW mnDataStartRow;
SCCOL mnTabEndCol;
SCROW mnTabEndRow;
bool mbDoFilter:1;
bool mbResultsError:1;
bool mbSizesValid:1;
bool mbSizeOverflow:1;
bool mbHeaderLayout:1; // true : grid, false : standard
bool mbHasCompactRowField:1; // true: at least one of the row fields has compact layout.
bool mbExpandCollapse:1; // true: show expand/collapse buttons
bool mbHideHeader : 1;
void DataCell( SCCOL nCol, SCROW nRow, SCTAB nTab,
const css::sheet::DataResult& rData );
void HeaderCell( SCCOL nCol, SCROW nRow, SCTAB nTab,
const css::sheet::MemberResult& rData,
bool bColHeader, tools::Long nLevel );
void FieldCell(SCCOL nCol, SCROW nRow, SCTAB nTab, const ScDPOutLevelData& rData, bool bInTable);
void MultiFieldCell(SCCOL nCol, SCROW nRow, SCTAB nTab, bool bRowField);
/// Computes number of columns needed to write row fields.
SCCOL GetColumnsForRowFields() const;
void CalcSizes();
/** Query which sub-area of the table the cell is in. See
css.sheet.DataPilotTablePositionType for the interpretation of the
return value. */
sal_Int32 GetPositionType(const ScAddress& rPos);
/// Returns the range of row fields that are contained by table's row fields column nCol.
void GetRowFieldRange(SCCOL nCol, sal_Int32& nRowFieldStart, sal_Int32& nRowFieldEnd) const;
/// Find row field index from row position in case of compact layout.
sal_Int32 GetRowFieldCompact(SCCOL nColQuery, SCROW nRowQuery) const;
void outputPageFields(SCTAB nTab);
void outputColumnHeaders(SCTAB nTab, ScDPOutputImpl& rOutputImpl);
void outputRowHeader(SCTAB nTab, ScDPOutputImpl& rOutputImpl);
void outputDataResults(SCTAB nTab);
public:
ScDPOutput(ScDocument* pDocument,
css::uno::Reference<css::sheet::XDimensionsSupplier> xSource,
const ScAddress& rPosition, bool bFilter, bool bExpandCollapse,
ScDPObject& rObject, bool bHideHeader);
~ScDPOutput();
void SetPosition( const ScAddress& rPos );
void Output(); //! Refresh?
ScRange GetOutputRange( sal_Int32 nRegionType = css::sheet::DataPilotOutputRangeType::WHOLE );
sal_Int32 GetHeaderRows() const;
bool HasError(); // range overflow or exception from source
void GetPositionData(const ScAddress& rPos, css::sheet::DataPilotTablePositionData& rPosData);
/** Get filtering criteria based on the position of the cell within data
field region. */
bool GetDataResultPositionData(::std::vector< css::sheet::DataPilotFieldFilter >& rFilters, const ScAddress& rPos);
tools::Long GetHeaderDim( const ScAddress& rPos, css::sheet::DataPilotFieldOrientation& rOrient );
bool GetHeaderDrag(
const ScAddress& rPos, bool bMouseLeft, bool bMouseTop, tools::Long nDragDim,
tools::Rectangle& rPosRect, css::sheet::DataPilotFieldOrientation& rOrient, tools::Long& rDimPos );
bool IsFilterButton( const ScAddress& rPos );
void GetMemberResultNames(ScDPUniqueStringSet& rNames, tools::Long nDimension);
void SetHeaderLayout(bool bUseGrid);
bool GetHeaderLayout() const { return mbHeaderLayout;}
void setFormats(sc::PivotTableFormats const& rPivotTableFormats)
{
maFormatOutput.setFormats(rPivotTableFormats);
}
static void GetDataDimensionNames(
OUString& rSourceName, OUString& rGivenName,
const css::uno::Reference< css::uno::XInterface>& xDim );
};
/* vim:set shiftwidth=4 softtabstop=4 expandtab: */
|