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