1*b3f79822SAndrew Rist /**************************************************************
2cdf0e10cSrcweir *
3*b3f79822SAndrew Rist * Licensed to the Apache Software Foundation (ASF) under one
4*b3f79822SAndrew Rist * or more contributor license agreements. See the NOTICE file
5*b3f79822SAndrew Rist * distributed with this work for additional information
6*b3f79822SAndrew Rist * regarding copyright ownership. The ASF licenses this file
7*b3f79822SAndrew Rist * to you under the Apache License, Version 2.0 (the
8*b3f79822SAndrew Rist * "License"); you may not use this file except in compliance
9*b3f79822SAndrew Rist * with the License. You may obtain a copy of the License at
10*b3f79822SAndrew Rist *
11*b3f79822SAndrew Rist * http://www.apache.org/licenses/LICENSE-2.0
12*b3f79822SAndrew Rist *
13*b3f79822SAndrew Rist * Unless required by applicable law or agreed to in writing,
14*b3f79822SAndrew Rist * software distributed under the License is distributed on an
15*b3f79822SAndrew Rist * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b3f79822SAndrew Rist * KIND, either express or implied. See the License for the
17*b3f79822SAndrew Rist * specific language governing permissions and limitations
18*b3f79822SAndrew Rist * under the License.
19*b3f79822SAndrew Rist *
20*b3f79822SAndrew Rist *************************************************************/
21*b3f79822SAndrew Rist
22*b3f79822SAndrew Rist
23cdf0e10cSrcweir
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_sc.hxx"
26cdf0e10cSrcweir
27cdf0e10cSrcweir
28cdf0e10cSrcweir
29cdf0e10cSrcweir // INCLUDE ---------------------------------------------------------------
30cdf0e10cSrcweir
31cdf0e10cSrcweir #include "dpoutputgeometry.hxx"
32cdf0e10cSrcweir #include "address.hxx"
33cdf0e10cSrcweir
34cdf0e10cSrcweir #include <vector>
35cdf0e10cSrcweir
36cdf0e10cSrcweir using ::std::vector;
37cdf0e10cSrcweir
ScDPOutputGeometry(const ScRange & rOutRange,bool bShowFilter,ImportType eImportType)38cdf0e10cSrcweir ScDPOutputGeometry::ScDPOutputGeometry(const ScRange& rOutRange, bool bShowFilter, ImportType eImportType) :
39cdf0e10cSrcweir maOutRange(rOutRange),
40cdf0e10cSrcweir mnRowFields(0),
41cdf0e10cSrcweir mnColumnFields(0),
42cdf0e10cSrcweir mnPageFields(0),
43cdf0e10cSrcweir mnDataFields(0),
44cdf0e10cSrcweir meImportType(eImportType),
45cdf0e10cSrcweir mbShowFilter(bShowFilter)
46cdf0e10cSrcweir {
47cdf0e10cSrcweir }
48cdf0e10cSrcweir
~ScDPOutputGeometry()49cdf0e10cSrcweir ScDPOutputGeometry::~ScDPOutputGeometry()
50cdf0e10cSrcweir {
51cdf0e10cSrcweir }
52cdf0e10cSrcweir
setRowFieldCount(sal_uInt32 nCount)53cdf0e10cSrcweir void ScDPOutputGeometry::setRowFieldCount(sal_uInt32 nCount)
54cdf0e10cSrcweir {
55cdf0e10cSrcweir mnRowFields = nCount;
56cdf0e10cSrcweir }
57cdf0e10cSrcweir
setColumnFieldCount(sal_uInt32 nCount)58cdf0e10cSrcweir void ScDPOutputGeometry::setColumnFieldCount(sal_uInt32 nCount)
59cdf0e10cSrcweir {
60cdf0e10cSrcweir mnColumnFields = nCount;
61cdf0e10cSrcweir }
62cdf0e10cSrcweir
setPageFieldCount(sal_uInt32 nCount)63cdf0e10cSrcweir void ScDPOutputGeometry::setPageFieldCount(sal_uInt32 nCount)
64cdf0e10cSrcweir {
65cdf0e10cSrcweir mnPageFields = nCount;
66cdf0e10cSrcweir }
67cdf0e10cSrcweir
setDataFieldCount(sal_uInt32 nCount)68cdf0e10cSrcweir void ScDPOutputGeometry::setDataFieldCount(sal_uInt32 nCount)
69cdf0e10cSrcweir {
70cdf0e10cSrcweir mnDataFields = nCount;
71cdf0e10cSrcweir }
72cdf0e10cSrcweir
getColumnFieldPositions(vector<ScAddress> & rAddrs) const73cdf0e10cSrcweir void ScDPOutputGeometry::getColumnFieldPositions(vector<ScAddress>& rAddrs) const
74cdf0e10cSrcweir {
75cdf0e10cSrcweir vector<ScAddress> aAddrs;
76cdf0e10cSrcweir if (!mnColumnFields)
77cdf0e10cSrcweir {
78cdf0e10cSrcweir rAddrs.swap(aAddrs);
79cdf0e10cSrcweir return;
80cdf0e10cSrcweir }
81cdf0e10cSrcweir
82cdf0e10cSrcweir bool bDataLayout = mnDataFields > 1;
83cdf0e10cSrcweir
84cdf0e10cSrcweir SCROW nCurRow = maOutRange.aStart.Row();
85cdf0e10cSrcweir
86cdf0e10cSrcweir if (mnPageFields)
87cdf0e10cSrcweir {
88cdf0e10cSrcweir SCROW nRowStart = maOutRange.aStart.Row() + mbShowFilter;
89cdf0e10cSrcweir SCROW nRowEnd = nRowStart + static_cast<SCCOL>(mnPageFields-1);
90cdf0e10cSrcweir nCurRow = nRowEnd + 2;
91cdf0e10cSrcweir }
92cdf0e10cSrcweir else if (mbShowFilter)
93cdf0e10cSrcweir nCurRow += 2;
94cdf0e10cSrcweir
95cdf0e10cSrcweir SCROW nRow = nCurRow;
96cdf0e10cSrcweir SCTAB nTab = maOutRange.aStart.Tab();
97cdf0e10cSrcweir SCCOL nColStart = static_cast<SCCOL>(maOutRange.aStart.Col() + mnRowFields + (bDataLayout ? 1 : 0));
98cdf0e10cSrcweir SCCOL nColEnd = nColStart + static_cast<SCCOL>(mnColumnFields-1);
99cdf0e10cSrcweir
100cdf0e10cSrcweir for (SCCOL nCol = nColStart; nCol <= nColEnd; ++nCol)
101cdf0e10cSrcweir aAddrs.push_back(ScAddress(nCol, nRow, nTab));
102cdf0e10cSrcweir rAddrs.swap(aAddrs);
103cdf0e10cSrcweir }
104cdf0e10cSrcweir
getRowFieldPositions(vector<ScAddress> & rAddrs) const105cdf0e10cSrcweir void ScDPOutputGeometry::getRowFieldPositions(vector<ScAddress>& rAddrs) const
106cdf0e10cSrcweir {
107cdf0e10cSrcweir vector<ScAddress> aAddrs;
108cdf0e10cSrcweir if (!mnRowFields)
109cdf0e10cSrcweir {
110cdf0e10cSrcweir rAddrs.swap(aAddrs);
111cdf0e10cSrcweir return;
112cdf0e10cSrcweir }
113cdf0e10cSrcweir
114cdf0e10cSrcweir SCROW nRow = getRowFieldHeaderRow();
115cdf0e10cSrcweir SCTAB nTab = maOutRange.aStart.Tab();
116cdf0e10cSrcweir SCCOL nColStart = maOutRange.aStart.Col();
117cdf0e10cSrcweir SCCOL nColEnd = nColStart + static_cast<SCCOL>(mnRowFields-1);
118cdf0e10cSrcweir
119cdf0e10cSrcweir for (SCCOL nCol = nColStart; nCol <= nColEnd; ++nCol)
120cdf0e10cSrcweir aAddrs.push_back(ScAddress(nCol, nRow, nTab));
121cdf0e10cSrcweir rAddrs.swap(aAddrs);
122cdf0e10cSrcweir }
123cdf0e10cSrcweir
getPageFieldPositions(vector<ScAddress> & rAddrs) const124cdf0e10cSrcweir void ScDPOutputGeometry::getPageFieldPositions(vector<ScAddress>& rAddrs) const
125cdf0e10cSrcweir {
126cdf0e10cSrcweir vector<ScAddress> aAddrs;
127cdf0e10cSrcweir if (!mnPageFields)
128cdf0e10cSrcweir {
129cdf0e10cSrcweir rAddrs.swap(aAddrs);
130cdf0e10cSrcweir return;
131cdf0e10cSrcweir }
132cdf0e10cSrcweir
133cdf0e10cSrcweir SCTAB nTab = maOutRange.aStart.Tab();
134cdf0e10cSrcweir SCCOL nCol = maOutRange.aStart.Col();
135cdf0e10cSrcweir
136cdf0e10cSrcweir SCROW nRowStart = maOutRange.aStart.Row() + mbShowFilter;
137cdf0e10cSrcweir SCROW nRowEnd = nRowStart + static_cast<SCCOL>(mnPageFields-1);
138cdf0e10cSrcweir
139cdf0e10cSrcweir for (SCROW nRow = nRowStart; nRow <= nRowEnd; ++nRow)
140cdf0e10cSrcweir aAddrs.push_back(ScAddress(nCol, nRow, nTab));
141cdf0e10cSrcweir rAddrs.swap(aAddrs);
142cdf0e10cSrcweir }
143cdf0e10cSrcweir
getRowFieldHeaderRow() const144cdf0e10cSrcweir SCROW ScDPOutputGeometry::getRowFieldHeaderRow() const
145cdf0e10cSrcweir {
146cdf0e10cSrcweir SCROW nCurRow = maOutRange.aStart.Row();
147cdf0e10cSrcweir
148cdf0e10cSrcweir if (mnPageFields)
149cdf0e10cSrcweir {
150cdf0e10cSrcweir SCROW nRowStart = maOutRange.aStart.Row() + mbShowFilter;
151cdf0e10cSrcweir SCROW nRowEnd = nRowStart + static_cast<SCCOL>(mnPageFields-1);
152cdf0e10cSrcweir nCurRow = nRowEnd + 2;
153cdf0e10cSrcweir }
154cdf0e10cSrcweir else if (mbShowFilter)
155cdf0e10cSrcweir nCurRow += 2;
156cdf0e10cSrcweir
157cdf0e10cSrcweir if (mnColumnFields)
158cdf0e10cSrcweir nCurRow += static_cast<SCROW>(mnColumnFields);
159cdf0e10cSrcweir else if (mnRowFields)
160cdf0e10cSrcweir ++nCurRow;
161cdf0e10cSrcweir
162cdf0e10cSrcweir return nCurRow;
163cdf0e10cSrcweir }
164cdf0e10cSrcweir
getFieldButtonType(const ScAddress & rPos) const165cdf0e10cSrcweir ScDPOutputGeometry::FieldType ScDPOutputGeometry::getFieldButtonType(const ScAddress& rPos) const
166cdf0e10cSrcweir {
167cdf0e10cSrcweir // We will ignore the table position for now.
168cdf0e10cSrcweir
169cdf0e10cSrcweir bool bExtraTitleRow = (mnColumnFields == 0 && meImportType == ScDPOutputGeometry::XLS);
170cdf0e10cSrcweir bool bDataLayout = mnDataFields > 1;
171cdf0e10cSrcweir
172cdf0e10cSrcweir SCROW nCurRow = maOutRange.aStart.Row();
173cdf0e10cSrcweir
174cdf0e10cSrcweir if (mnPageFields)
175cdf0e10cSrcweir {
176cdf0e10cSrcweir SCCOL nCol = maOutRange.aStart.Col();
177cdf0e10cSrcweir SCROW nRowStart = maOutRange.aStart.Row() + mbShowFilter;
178cdf0e10cSrcweir SCROW nRowEnd = nRowStart + static_cast<SCCOL>(mnPageFields-1);
179cdf0e10cSrcweir if (rPos.Col() == nCol && nRowStart <= rPos.Row() && rPos.Row() <= nRowEnd)
180cdf0e10cSrcweir return Page;
181cdf0e10cSrcweir
182cdf0e10cSrcweir nCurRow = nRowEnd + 2;
183cdf0e10cSrcweir }
184cdf0e10cSrcweir else if (mbShowFilter)
185cdf0e10cSrcweir nCurRow += 2;
186cdf0e10cSrcweir
187cdf0e10cSrcweir if (mnColumnFields)
188cdf0e10cSrcweir {
189cdf0e10cSrcweir SCROW nRow = nCurRow;
190cdf0e10cSrcweir SCCOL nColStart = static_cast<SCCOL>(maOutRange.aStart.Col() + mnRowFields + (bDataLayout ? 1 : 0));
191cdf0e10cSrcweir SCCOL nColEnd = nColStart + static_cast<SCCOL>(mnColumnFields-1);
192cdf0e10cSrcweir if (rPos.Row() == nRow && nColStart <= rPos.Col() && rPos.Col() <= nColEnd)
193cdf0e10cSrcweir return Column;
194cdf0e10cSrcweir
195cdf0e10cSrcweir nCurRow += static_cast<SCROW>(mnColumnFields);
196cdf0e10cSrcweir }
197cdf0e10cSrcweir
198cdf0e10cSrcweir if (bExtraTitleRow)
199cdf0e10cSrcweir ++nCurRow;
200cdf0e10cSrcweir
201cdf0e10cSrcweir if (mnRowFields)
202cdf0e10cSrcweir {
203cdf0e10cSrcweir SCCOL nColStart = maOutRange.aStart.Col();
204cdf0e10cSrcweir SCCOL nColEnd = nColStart + static_cast<SCCOL>(mnRowFields-1);
205cdf0e10cSrcweir if (rPos.Row() == nCurRow && nColStart <= rPos.Col() && rPos.Col() <= nColEnd)
206cdf0e10cSrcweir return Row;
207cdf0e10cSrcweir }
208cdf0e10cSrcweir
209cdf0e10cSrcweir return None;
210cdf0e10cSrcweir }
211