LibreOffice Module sc (master)  1
dapiuno.cxx
Go to the documentation of this file.
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 #include <algorithm>
21 #include <cmath>
22 
23 #include <svl/hint.hxx>
24 #include <vcl/svapp.hxx>
25 #include <sal/log.hxx>
26 
27 #include <dapiuno.hxx>
28 #include <datauno.hxx>
29 #include <miscuno.hxx>
30 #include <convuno.hxx>
31 #include <docsh.hxx>
32 #include <tabvwsh.hxx>
33 #include <rangeutl.hxx>
34 #include <dpobject.hxx>
35 #include <dpshttab.hxx>
36 #include <dpsdbtab.hxx>
37 #include <dpsave.hxx>
38 #include <dbdocfun.hxx>
39 #include <unonames.hxx>
40 #include <dpdimsave.hxx>
41 #include <hints.hxx>
42 #include <dputil.hxx>
43 #include <globstr.hrc>
44 #include <scresid.hxx>
45 #include <generalfunction.hxx>
46 
47 #include <com/sun/star/container/XNameAccess.hpp>
48 #include <com/sun/star/lang/IndexOutOfBoundsException.hpp>
49 #include <com/sun/star/lang/IllegalArgumentException.hpp>
50 #include <com/sun/star/lang/NullPointerException.hpp>
51 #include <com/sun/star/lang/WrappedTargetRuntimeException.hpp>
52 #include <com/sun/star/sheet/XDimensionsSupplier.hpp>
53 #include <com/sun/star/sheet/XLevelsSupplier.hpp>
54 #include <com/sun/star/sheet/XMembersAccess.hpp>
55 #include <com/sun/star/beans/PropertyAttribute.hpp>
56 #include <com/sun/star/sheet/DataImportMode.hpp>
57 #include <com/sun/star/sheet/DataPilotFieldGroupBy.hpp>
58 #include <com/sun/star/sheet/DataPilotFieldFilter.hpp>
59 #include <com/sun/star/sheet/DataPilotOutputRangeType.hpp>
60 #include <com/sun/star/sheet/DataPilotTablePositionData.hpp>
61 #include <com/sun/star/sheet/GeneralFunction2.hpp>
62 
63 #include <comphelper/extract.hxx>
64 #include <comphelper/propertysequence.hxx>
65 #include <comphelper/sequence.hxx>
66 #include <comphelper/servicehelper.hxx>
67 #include <cppuhelper/exc_hlp.hxx>
68 
69 using namespace com::sun::star;
70 using namespace com::sun::star::sheet;
71 
72 using ::com::sun::star::uno::Any;
73 using ::com::sun::star::uno::Exception;
74 using ::com::sun::star::uno::Reference;
75 using ::com::sun::star::uno::RuntimeException;
76 using ::com::sun::star::uno::Sequence;
77 using ::com::sun::star::uno::UNO_QUERY;
78 using ::com::sun::star::uno::UNO_QUERY_THROW;
79 
80 using ::com::sun::star::container::ElementExistException;
81 using ::com::sun::star::container::NoSuchElementException;
82 using ::com::sun::star::container::XEnumeration;
83 using ::com::sun::star::container::XIndexAccess;
84 using ::com::sun::star::container::XNameAccess;
85 using ::com::sun::star::container::XNamed;
86 
87 using ::com::sun::star::beans::UnknownPropertyException;
88 using ::com::sun::star::beans::XPropertyChangeListener;
89 using ::com::sun::star::beans::XPropertySet;
90 using ::com::sun::star::beans::XPropertySetInfo;
91 using ::com::sun::star::beans::XVetoableChangeListener;
92 
93 using ::com::sun::star::lang::IllegalArgumentException;
94 using ::com::sun::star::lang::IndexOutOfBoundsException;
95 using ::com::sun::star::lang::NullPointerException;
96 
97 using ::com::sun::star::table::CellAddress;
98 using ::com::sun::star::table::CellRangeAddress;
99 
100 namespace {
101 
102 const SfxItemPropertyMapEntry* lcl_GetDataPilotDescriptorBaseMap()
103 {
104  static const SfxItemPropertyMapEntry aDataPilotDescriptorBaseMap_Impl[] =
105  {
106  {u"" SC_UNO_DP_COLGRAND, 0, cppu::UnoType<bool>::get(), 0, 0 },
107  {u"" SC_UNO_DP_DRILLDOWN, 0, cppu::UnoType<bool>::get(), 0, 0 },
108  {u"" SC_UNO_DP_GRANDTOTAL_NAME,0,cppu::UnoType<OUString>::get(), beans::PropertyAttribute::MAYBEVOID, 0 },
109  {u"" SC_UNO_DP_IGNORE_EMPTYROWS, 0, cppu::UnoType<bool>::get(), 0, 0 },
110  {u"" SC_UNO_DP_IMPORTDESC, 0, cppu::UnoType<uno::Sequence<beans::PropertyValue>>::get(), 0, 0 },
111  {u"" SC_UNO_DP_REPEATEMPTY, 0, cppu::UnoType<bool>::get(), 0, 0 },
112  {u"" SC_UNO_DP_ROWGRAND, 0, cppu::UnoType<bool>::get(), 0, 0 },
113  {u"" SC_UNO_DP_SERVICEARG, 0, cppu::UnoType<uno::Sequence<beans::PropertyValue>>::get(), 0, 0 },
114  {u"" SC_UNO_DP_SHOWFILTER, 0, cppu::UnoType<bool>::get(), 0, 0 },
115  {u"" SC_UNO_DP_SOURCESERVICE, 0, cppu::UnoType<OUString>::get(), 0, 0 },
116  { u"", 0, css::uno::Type(), 0, 0 }
117  };
118  return aDataPilotDescriptorBaseMap_Impl;
119 }
120 
121 const SfxItemPropertyMapEntry* lcl_GetDataPilotFieldMap()
122 {
123  using namespace ::com::sun::star::beans::PropertyAttribute;
124  static const SfxItemPropertyMapEntry aDataPilotFieldMap_Impl[] =
125  {
126  {u"" SC_UNONAME_AUTOSHOW, 0, cppu::UnoType<DataPilotFieldAutoShowInfo>::get(), MAYBEVOID, 0 },
127  {u"" SC_UNONAME_FUNCTION, 0, cppu::UnoType<GeneralFunction>::get(), 0, 0 },
128  {u"" SC_UNONAME_FUNCTION2, 0, cppu::UnoType<sal_Int16>::get(), 0, 0 },
129  {u"" SC_UNONAME_GROUPINFO, 0, cppu::UnoType<DataPilotFieldGroupInfo>::get(), MAYBEVOID, 0 },
130  {u"" SC_UNONAME_HASAUTOSHOW, 0, cppu::UnoType<bool>::get(), 0, 0 },
131  {u"" SC_UNONAME_HASLAYOUTINFO,0, cppu::UnoType<bool>::get(), 0, 0 },
132  {u"" SC_UNONAME_HASREFERENCE, 0, cppu::UnoType<bool>::get(), 0, 0 },
133  {u"" SC_UNONAME_HASSORTINFO, 0, cppu::UnoType<bool>::get(), 0, 0 },
134  {u"" SC_UNONAME_ISGROUP, 0, cppu::UnoType<bool>::get(), 0, 0 },
135  {u"" SC_UNONAME_LAYOUTINFO, 0, cppu::UnoType<DataPilotFieldLayoutInfo>::get(), MAYBEVOID, 0 },
136  {u"" SC_UNONAME_ORIENT, 0, cppu::UnoType<DataPilotFieldOrientation>::get(), MAYBEVOID, 0 },
137  {u"" SC_UNONAME_REFERENCE, 0, cppu::UnoType<DataPilotFieldReference>::get(), MAYBEVOID, 0 },
138  {u"" SC_UNONAME_SELPAGE, 0, cppu::UnoType<OUString>::get(), 0, 0 },
139  {u"" SC_UNONAME_SHOWEMPTY, 0, cppu::UnoType<bool>::get(), 0, 0 },
140  {u"" SC_UNONAME_REPEATITEMLABELS, 0, cppu::UnoType<bool>::get(), 0, 0 },
141  {u"" SC_UNONAME_SORTINFO, 0, cppu::UnoType<DataPilotFieldSortInfo>::get(), MAYBEVOID, 0 },
142  {u"" SC_UNONAME_SUBTOTALS, 0, cppu::UnoType<Sequence<GeneralFunction>>::get(), 0, 0 },
143  {u"" SC_UNONAME_SUBTOTALS2, 0, cppu::UnoType<Sequence<sal_Int16>>::get(), 0, 0 },
144  {u"" SC_UNONAME_USESELPAGE, 0, cppu::UnoType<bool>::get(), 0, 0 },
145  { u"", 0, css::uno::Type(), 0, 0 }
146  };
147  return aDataPilotFieldMap_Impl;
148 }
149 
150 const SfxItemPropertyMapEntry* lcl_GetDataPilotItemMap()
151 {
152  static const SfxItemPropertyMapEntry aDataPilotItemMap_Impl[] =
153  {
154  {u"" SC_UNONAME_ISHIDDEN, 0, cppu::UnoType<bool>::get(), 0, 0 },
155  {u"" SC_UNONAME_POS, 0, cppu::UnoType<sal_Int32>::get(), 0, 0 },
156  {u"" SC_UNONAME_SHOWDETAIL, 0, cppu::UnoType<bool>::get(), 0, 0 },
157  { u"", 0, css::uno::Type(), 0, 0 }
158  };
159  return aDataPilotItemMap_Impl;
160 }
161 
162 bool lclCheckValidDouble( double fValue, bool bAuto )
163 {
164  return bAuto || std::isfinite( fValue );
165 }
166 
167 bool lclCheckMinMaxStep( const DataPilotFieldGroupInfo& rInfo )
168 {
169  return
170  lclCheckValidDouble( rInfo.Start, rInfo.HasAutoStart ) &&
171  lclCheckValidDouble( rInfo.End, rInfo.HasAutoEnd ) &&
172  (rInfo.HasAutoStart || rInfo.HasAutoEnd || (rInfo.Start <= rInfo.End)) &&
173  lclCheckValidDouble( rInfo.Step, false ) &&
174  (0.0 <= rInfo.Step);
175 }
176 
177 } // namespace
178 
179 SC_SIMPLE_SERVICE_INFO( ScDataPilotDescriptor, "ScDataPilotDescriptor", "stardiv::one::sheet::DataPilotDescriptor" )
180 SC_SIMPLE_SERVICE_INFO( ScDataPilotFieldObj, "ScDataPilotFieldObj", "com.sun.star.sheet.DataPilotField" )
181 SC_SIMPLE_SERVICE_INFO( ScDataPilotFieldsObj, "ScDataPilotFieldsObj", "com.sun.star.sheet.DataPilotFields" )
182 SC_SIMPLE_SERVICE_INFO( ScDataPilotTableObj, "ScDataPilotTableObj", "com.sun.star.sheet.DataPilotTable" )
183 SC_SIMPLE_SERVICE_INFO( ScDataPilotTablesObj, "ScDataPilotTablesObj", "com.sun.star.sheet.DataPilotTables" )
184 SC_SIMPLE_SERVICE_INFO( ScDataPilotItemsObj, "ScDataPilotItemsObj", "com.sun.star.sheet.DataPilotItems" )
185 SC_SIMPLE_SERVICE_INFO( ScDataPilotItemObj, "ScDataPilotItemObj", "com.sun.star.sheet.DataPilotItem" )
186 
187 SC_SIMPLE_SERVICE_INFO( ScDataPilotFieldGroupsObj, "ScDataPilotFieldGroupsObj", "com.sun.star.sheet.DataPilotFieldGroups" )
188 SC_SIMPLE_SERVICE_INFO( ScDataPilotFieldGroupObj, "ScDataPilotFieldGroupObj", "com.sun.star.sheet.DataPilotFieldGroup" )
189 SC_SIMPLE_SERVICE_INFO( ScDataPilotFieldGroupItemObj, "ScDataPilotFieldGroupItemObj", "com.sun.star.sheet.DataPilotFieldGroupItem" )
190 
191 // name that is used in the API for the data layout field
192 #define SC_DATALAYOUT_NAME "Data"
193 
194 ScGeneralFunction ScDataPilotConversion::FirstFunc( PivotFunc nBits )
195 {
196  if ( nBits & PivotFunc::Sum ) return ScGeneralFunction::SUM;
197  if ( nBits & PivotFunc::Count ) return ScGeneralFunction::COUNT;
198  if ( nBits & PivotFunc::Average ) return ScGeneralFunction::AVERAGE;
199  if ( nBits & PivotFunc::Median ) return ScGeneralFunction::MEDIAN;
200  if ( nBits & PivotFunc::Max ) return ScGeneralFunction::MAX;
201  if ( nBits & PivotFunc::Min ) return ScGeneralFunction::MIN;
202  if ( nBits & PivotFunc::Product ) return ScGeneralFunction::PRODUCT;
203  if ( nBits & PivotFunc::CountNum ) return ScGeneralFunction::COUNTNUMS;
204  if ( nBits & PivotFunc::StdDev ) return ScGeneralFunction::STDEV;
205  if ( nBits & PivotFunc::StdDevP ) return ScGeneralFunction::STDEVP;
206  if ( nBits & PivotFunc::StdVar ) return ScGeneralFunction::VAR;
207  if ( nBits & PivotFunc::StdVarP ) return ScGeneralFunction::VARP;
208  if ( nBits & PivotFunc::Auto ) return ScGeneralFunction::AUTO;
209  return ScGeneralFunction::NONE;
210 }
211 
212 PivotFunc ScDataPilotConversion::FunctionBit( sal_Int16 eFunc )
213 {
214  PivotFunc nRet = PivotFunc::NONE; // 0
215  switch (eFunc)
216  {
217  case GeneralFunction2::SUM: nRet = PivotFunc::Sum; break;
218  case GeneralFunction2::COUNT: nRet = PivotFunc::Count; break;
219  case GeneralFunction2::AVERAGE: nRet = PivotFunc::Average; break;
220  case GeneralFunction2::MEDIAN: nRet = PivotFunc::Median; break;
221  case GeneralFunction2::MAX: nRet = PivotFunc::Max; break;
222  case GeneralFunction2::MIN: nRet = PivotFunc::Min; break;
223  case GeneralFunction2::PRODUCT: nRet = PivotFunc::Product; break;
224  case GeneralFunction2::COUNTNUMS: nRet = PivotFunc::CountNum; break;
225  case GeneralFunction2::STDEV: nRet = PivotFunc::StdDev; break;
226  case GeneralFunction2::STDEVP: nRet = PivotFunc::StdDevP; break;
227  case GeneralFunction2::VAR: nRet = PivotFunc::StdVar; break;
228  case GeneralFunction2::VARP: nRet = PivotFunc::StdVarP; break;
229  case GeneralFunction2::AUTO: nRet = PivotFunc::Auto; break;
230  default:
231  {
232  assert(false);
233  }
234  }
235  return nRet;
236 }
237 
238 void ScDataPilotConversion::FillGroupInfo( DataPilotFieldGroupInfo& rInfo, const ScDPNumGroupInfo& rGroupInfo )
239 {
240  rInfo.HasDateValues = rGroupInfo.mbDateValues;
241  rInfo.HasAutoStart = rGroupInfo.mbAutoStart;
242  rInfo.Start = rGroupInfo.mfStart;
243  rInfo.HasAutoEnd = rGroupInfo.mbAutoEnd;
244  rInfo.End = rGroupInfo.mfEnd;
245  rInfo.Step = rGroupInfo.mfStep;
246 }
247 
248 static ScDPObject* lcl_GetDPObject( ScDocShell* pDocShell, SCTAB nTab, std::u16string_view rName )
249 {
250  if (pDocShell)
251  {
252  ScDocument& rDoc = pDocShell->GetDocument();
253  ScDPCollection* pColl = rDoc.GetDPCollection();
254  if ( pColl )
255  {
256  size_t nCount = pColl->GetCount();
257  for (size_t i=0; i<nCount; ++i)
258  {
259  ScDPObject& rDPObj = (*pColl)[i];
260  if ( rDPObj.GetOutRange().aStart.Tab() == nTab &&
261  rDPObj.GetName() == rName )
262  return &rDPObj;
263  }
264  }
265  }
266  return nullptr; // not found
267 }
268 
269 static OUString lcl_CreatePivotName( ScDocShell* pDocShell )
270 {
271  if (pDocShell)
272  {
273  ScDocument& rDoc = pDocShell->GetDocument();
274  ScDPCollection* pColl = rDoc.GetDPCollection();
275  if ( pColl )
276  return pColl->CreateNewName();
277  }
278  return OUString(); // shouldn't happen
279 }
280 
281 static sal_Int32 lcl_GetObjectIndex( ScDPObject* pDPObj, const ScFieldIdentifier& rFieldId )
282 {
283  // used for items - nRepeat in identifier can be ignored
284  if ( pDPObj )
285  {
286  sal_Int32 nCount = pDPObj->GetDimCount();
287  for ( sal_Int32 nDim = 0; nDim < nCount; ++nDim )
288  {
289  bool bIsDataLayout = false;
290  OUString aDimName( pDPObj->GetDimName( nDim, bIsDataLayout ) );
291  if ( rFieldId.mbDataLayout ? bIsDataLayout : (aDimName == rFieldId.maFieldName) )
292  return nDim;
293  }
294  }
295  return -1; // none
296 }
297 
298 ScDataPilotTablesObj::ScDataPilotTablesObj(ScDocShell* pDocSh, SCTAB nT) :
299  pDocShell( pDocSh ),
300  nTab( nT )
301 {
302  pDocShell->GetDocument().AddUnoObject(*this);
303 }
304 
305 ScDataPilotTablesObj::~ScDataPilotTablesObj()
306 {
307  SolarMutexGuard g;
308 
309  if (pDocShell)
310  pDocShell->GetDocument().RemoveUnoObject(*this);
311 }
312 
313 void ScDataPilotTablesObj::Notify( SfxBroadcaster&, const SfxHint& rHint )
314 {
316 
317  if ( rHint.GetId() == SfxHintId::Dying )
318  {
319  pDocShell = nullptr; // became invalid
320  }
321 }
322 
323 // XDataPilotTables
324 
325 ScDataPilotTableObj* ScDataPilotTablesObj::GetObjectByIndex_Impl( sal_Int32 nIndex )
326 {
327  if (pDocShell)
328  {
329  ScDocument& rDoc = pDocShell->GetDocument();
330  ScDPCollection* pColl = rDoc.GetDPCollection();
331  if ( pColl )
332  {
333  // count tables on this sheet
334  sal_Int32 nFound = 0;
335  size_t nCount = pColl->GetCount();
336  for (size_t i=0; i<nCount; ++i)
337  {
338  ScDPObject& rDPObj = (*pColl)[i];
339  if ( rDPObj.GetOutRange().aStart.Tab() == nTab )
340  {
341  if ( nFound == nIndex )
342  {
343  return new ScDataPilotTableObj( pDocShell, nTab, rDPObj.GetName() );
344  }
345  ++nFound;
346  }
347  }
348  }
349  }
350  return nullptr;
351 }
352 
353 ScDataPilotTableObj* ScDataPilotTablesObj::GetObjectByName_Impl(const OUString& rName)
354 {
355  if (hasByName(rName))
356  return new ScDataPilotTableObj( pDocShell, nTab, rName );
357  return nullptr;
358 }
359 
360 Reference<XDataPilotDescriptor> SAL_CALL ScDataPilotTablesObj::createDataPilotDescriptor()
361 {
362  SolarMutexGuard aGuard;
363  if (pDocShell)
364  return new ScDataPilotDescriptor(pDocShell);
365  return nullptr;
366 }
367 
368 static bool lcl_IsDuplicated(const Reference<XPropertySet>& rDimProps)
369 {
370  try
371  {
372  Any aAny = rDimProps->getPropertyValue( SC_UNO_DP_ORIGINAL );
373  Reference< XNamed > xOriginal( aAny, UNO_QUERY );
374  return xOriginal.is();
375  }
376  catch( Exception& )
377  {
378  }
379  return false;
380 }
381 
382 static OUString lcl_GetOriginalName(const Reference< XNamed >& rDim)
383 {
384  Reference< XNamed > xOriginal;
385 
386  Reference< XPropertySet > xDimProps(rDim, UNO_QUERY);
387  if ( xDimProps.is() )
388  {
389  try
390  {
391  Any aAny = xDimProps->getPropertyValue(SC_UNO_DP_ORIGINAL);
392  aAny >>= xOriginal;
393  }
394  catch( Exception& )
395  {
396  }
397  }
398 
399  if ( !xOriginal.is() )
400  xOriginal = rDim;
401 
402  return xOriginal->getName();
403 }
404 
405 void SAL_CALL ScDataPilotTablesObj::insertNewByName( const OUString& aNewName,
406  const CellAddress& aOutputAddress,
407  const Reference<XDataPilotDescriptor>& xDescriptor )
408 {
409  SolarMutexGuard aGuard;
410  if (!xDescriptor.is()) return;
411 
412  if ( !aNewName.isEmpty() && hasByName( aNewName ) )
413  throw IllegalArgumentException("Name \"" + aNewName + "\" already exists", static_cast<cppu::OWeakObject*>(this), 0);
414 
415  if (!pDocShell)
416  throw RuntimeException("DocShell is null", static_cast<cppu::OWeakObject*>(this));
417 
418  auto pImp = comphelper::getUnoTunnelImplementation<ScDataPilotDescriptorBase>( xDescriptor );
419  if (!pImp)
420  throw RuntimeException("Failed to get ScDataPilotDescriptor", static_cast<cppu::OWeakObject*>(this));
421 
422  ScDPObject* pNewObj = pImp->GetDPObject();
423  if (!pNewObj)
424  throw RuntimeException("Failed to get DPObject", static_cast<cppu::OWeakObject*>(this));
425 
426  ScRange aOutputRange(static_cast<SCCOL>(aOutputAddress.Column), static_cast<SCROW>(aOutputAddress.Row), static_cast<SCTAB>(aOutputAddress.Sheet),
427  static_cast<SCCOL>(aOutputAddress.Column), static_cast<SCROW>(aOutputAddress.Row), static_cast<SCTAB>(aOutputAddress.Sheet));
428  pNewObj->SetOutRange(aOutputRange);
429  OUString aName = aNewName;
430  if (aName.isEmpty())
431  aName = lcl_CreatePivotName( pDocShell );
432  pNewObj->SetName(aName);
433  OUString aTag = xDescriptor->getTag();
434  pNewObj->SetTag(aTag);
435 
436  // todo: handle double fields (for more information see ScDPObject)
437 
438  ScDBDocFunc aFunc(*pDocShell);
439  if (!aFunc.CreatePivotTable(*pNewObj, true, true))
440  throw RuntimeException("Failed to create pivot table", static_cast<cppu::OWeakObject*>(this));
441 }
442 
443 void SAL_CALL ScDataPilotTablesObj::removeByName( const OUString& aName )
444 {
445  SolarMutexGuard aGuard;
446  ScDPObject* pDPObj = lcl_GetDPObject( pDocShell, nTab, aName );
447  if (!pDPObj || !pDocShell)
448  throw RuntimeException(); // no other exceptions specified
449 
450  ScDBDocFunc aFunc(*pDocShell);
451  aFunc.RemovePivotTable(*pDPObj, true, true); // remove - incl. undo etc.
452 
453 }
454 
455 // XEnumerationAccess
456 
457 Reference< XEnumeration > SAL_CALL ScDataPilotTablesObj::createEnumeration()
458 {
459  SolarMutexGuard aGuard;
460  return new ScIndexEnumeration(this, "com.sun.star.sheet.DataPilotTablesEnumeration");
461 }
462 
463 // XIndexAccess
464 
465 sal_Int32 SAL_CALL ScDataPilotTablesObj::getCount()
466 {
467  SolarMutexGuard aGuard;
468  if ( pDocShell )
469  {
470  ScDocument& rDoc = pDocShell->GetDocument();
471  ScDPCollection* pColl = rDoc.GetDPCollection();
472  if ( pColl )
473  {
474  // count tables on this sheet
475 
476  sal_uInt16 nFound = 0;
477  size_t nCount = pColl->GetCount();
478  for (size_t i=0; i<nCount; ++i)
479  {
480  ScDPObject& rDPObj = (*pColl)[i];
481  if ( rDPObj.GetOutRange().aStart.Tab() == nTab )
482  ++nFound;
483  }
484  return nFound;
485  }
486  }
487 
488  return 0;
489 }
490 
491 Any SAL_CALL ScDataPilotTablesObj::getByIndex( sal_Int32 nIndex )
492 {
493  SolarMutexGuard aGuard;
494  Reference<XDataPilotTable2> xTable(GetObjectByIndex_Impl(nIndex));
495  if (!xTable.is())
496  throw IndexOutOfBoundsException();
497  return Any( xTable );
498 }
499 
500 uno::Type SAL_CALL ScDataPilotTablesObj::getElementType()
501 {
502  SolarMutexGuard aGuard;
503  return cppu::UnoType<XDataPilotTable2>::get();
504 }
505 
506 sal_Bool SAL_CALL ScDataPilotTablesObj::hasElements()
507 {
508  SolarMutexGuard aGuard;
509  return ( getCount() != 0 );
510 }
511 
512 // XNameAccess
513 
514 Any SAL_CALL ScDataPilotTablesObj::getByName( const OUString& aName )
515 {
516  SolarMutexGuard aGuard;
517  Reference<XDataPilotTable2> xTable(GetObjectByName_Impl(aName));
518  if (!xTable.is())
519  throw NoSuchElementException();
520  return Any( xTable );
521 }
522 
523 Sequence<OUString> SAL_CALL ScDataPilotTablesObj::getElementNames()
524 {
525  SolarMutexGuard aGuard;
526  if (pDocShell)
527  {
528  ScDocument& rDoc = pDocShell->GetDocument();
529  ScDPCollection* pColl = rDoc.GetDPCollection();
530  if ( pColl )
531  {
532  // count tables on this sheet
533 
534  sal_uInt16 nFound = 0;
535  size_t nCount = pColl->GetCount();
536  size_t i;
537  for (i=0; i<nCount; ++i)
538  {
539  ScDPObject& rDPObj = (*pColl)[i];
540  if ( rDPObj.GetOutRange().aStart.Tab() == nTab )
541  ++nFound;
542  }
543 
544  sal_uInt16 nPos = 0;
545  Sequence<OUString> aSeq(nFound);
546  OUString* pAry = aSeq.getArray();
547  for (i=0; i<nCount; ++i)
548  {
549  ScDPObject& rDPObj = (*pColl)[i];
550  if ( rDPObj.GetOutRange().aStart.Tab() == nTab )
551  pAry[nPos++] = rDPObj.GetName();
552  }
553 
554  return aSeq;
555  }
556  }
557  return Sequence<OUString>(0);
558 }
559 
560 sal_Bool SAL_CALL ScDataPilotTablesObj::hasByName( const OUString& aName )
561 {
562  SolarMutexGuard aGuard;
563  if (pDocShell)
564  {
565  ScDocument& rDoc = pDocShell->GetDocument();
566  ScDPCollection* pColl = rDoc.GetDPCollection();
567  if ( pColl )
568  {
569  size_t nCount = pColl->GetCount();
570  for (size_t i=0; i<nCount; ++i)
571  {
572  ScDPObject& rDPObj = (*pColl)[i];
573  if ( rDPObj.GetOutRange().aStart.Tab() == nTab &&
574  rDPObj.GetName() == aName )
575  return true;
576  }
577  }
578  }
579  return false;
580 }
581 
582 ScDataPilotDescriptorBase::ScDataPilotDescriptorBase(ScDocShell* pDocSh) :
583  maPropSet( lcl_GetDataPilotDescriptorBaseMap() ),
584  pDocShell( pDocSh )
585 {
586  pDocShell->GetDocument().AddUnoObject(*this);
587 }
588 
589 ScDataPilotDescriptorBase::~ScDataPilotDescriptorBase()
590 {
591  SolarMutexGuard g;
592 
593  if (pDocShell)
594  pDocShell->GetDocument().RemoveUnoObject(*this);
595 }
596 
597 void ScDataPilotDescriptorBase::Notify( SfxBroadcaster&, const SfxHint& rHint )
598 {
600 
601  if ( rHint.GetId() == SfxHintId::Dying )
602  {
603  pDocShell = nullptr; // became invalid
604  }
605 }
606 
607 // XDataPilotDescriptor
608 
609 CellRangeAddress SAL_CALL ScDataPilotDescriptorBase::getSourceRange()
610 {
611  SolarMutexGuard aGuard;
612 
613  ScDPObject* pDPObject(GetDPObject());
614  if (!pDPObject)
615  throw RuntimeException("Failed to get DPObject", static_cast<cppu::OWeakObject*>(this));
616 
617  CellRangeAddress aRet;
618  if (pDPObject->IsSheetData())
619  ScUnoConversion::FillApiRange( aRet, pDPObject->GetSheetDesc()->GetSourceRange() );
620  return aRet;
621 }
622 
623 void SAL_CALL ScDataPilotDescriptorBase::setSourceRange( const CellRangeAddress& aSourceRange )
624 {
625  SolarMutexGuard aGuard;
626 
627  ScDPObject* pDPObject = GetDPObject();
628  if (!pDPObject)
629  throw RuntimeException("Failed to get DPObject", static_cast<cppu::OWeakObject*>(this));
630 
631  ScSheetSourceDesc aSheetDesc(&pDocShell->GetDocument());
632  if (pDPObject->IsSheetData())
633  aSheetDesc = *pDPObject->GetSheetDesc();
634 
635  ScRange aRange;
636  ScUnoConversion::FillScRange(aRange, aSourceRange);
637  aSheetDesc.SetSourceRange(aRange);
638  pDPObject->SetSheetDesc( aSheetDesc );
639  SetDPObject( pDPObject );
640 }
641 
642 Reference<XSheetFilterDescriptor> SAL_CALL ScDataPilotDescriptorBase::getFilterDescriptor()
643 {
644  SolarMutexGuard aGuard;
645  return new ScDataPilotFilterDescriptor( pDocShell, this );
646 }
647 
648 Reference<XIndexAccess> SAL_CALL ScDataPilotDescriptorBase::getDataPilotFields()
649 {
650  SolarMutexGuard aGuard;
651  return new ScDataPilotFieldsObj( *this );
652 }
653 
654 Reference<XIndexAccess> SAL_CALL ScDataPilotDescriptorBase::getColumnFields()
655 {
656  SolarMutexGuard aGuard;
657  return new ScDataPilotFieldsObj( *this, DataPilotFieldOrientation_COLUMN );
658 }
659 
660 Reference<XIndexAccess> SAL_CALL ScDataPilotDescriptorBase::getRowFields()
661 {
662  SolarMutexGuard aGuard;
663  return new ScDataPilotFieldsObj( *this, DataPilotFieldOrientation_ROW );
664 }
665 
666 Reference<XIndexAccess> SAL_CALL ScDataPilotDescriptorBase::getPageFields()
667 {
668  SolarMutexGuard aGuard;
669  return new ScDataPilotFieldsObj( *this, DataPilotFieldOrientation_PAGE );
670 }
671 
672 Reference<XIndexAccess> SAL_CALL ScDataPilotDescriptorBase::getDataFields()
673 {
674  SolarMutexGuard aGuard;
675  return new ScDataPilotFieldsObj( *this, DataPilotFieldOrientation_DATA );
676 }
677 
678 Reference<XIndexAccess> SAL_CALL ScDataPilotDescriptorBase::getHiddenFields()
679 {
680  SolarMutexGuard aGuard;
681  return new ScDataPilotFieldsObj( *this, DataPilotFieldOrientation_HIDDEN );
682 }
683 
684 // XPropertySet
685 Reference< XPropertySetInfo > SAL_CALL ScDataPilotDescriptorBase::getPropertySetInfo( )
686 {
687  SolarMutexGuard aGuard;
688  static Reference<XPropertySetInfo> aRef =
689  new SfxItemPropertySetInfo( maPropSet.getPropertyMap() );
690  return aRef;
691 }
692 
693 void SAL_CALL ScDataPilotDescriptorBase::setPropertyValue( const OUString& aPropertyName, const Any& aValue )
694 {
695  SolarMutexGuard aGuard;
696  ScDPObject* pDPObject = GetDPObject();
697  if (!pDPObject)
698  return;
699 
700  ScDPSaveData* pOldData = pDPObject->GetSaveData();
701  OSL_ENSURE(pOldData, "Here should be a SaveData");
702  if ( pOldData )
703  {
704  ScDPSaveData aNewData( *pOldData );
705 
706  if ( aPropertyName == SC_UNO_DP_COLGRAND )
707  {
708  aNewData.SetColumnGrand(::cppu::any2bool( aValue ));
709  }
710  else if ( aPropertyName == SC_UNO_DP_IGNORE_EMPTYROWS )
711  {
712  aNewData.SetIgnoreEmptyRows(::cppu::any2bool( aValue ));
713  }
714  else if ( aPropertyName == SC_UNO_DP_REPEATEMPTY )
715  {
716  aNewData.SetRepeatIfEmpty(::cppu::any2bool( aValue ));
717  }
718  else if ( aPropertyName == SC_UNO_DP_ROWGRAND )
719  {
720  aNewData.SetRowGrand(::cppu::any2bool( aValue ));
721  }
722  else if ( aPropertyName == SC_UNO_DP_SHOWFILTER )
723  {
724  aNewData.SetFilterButton(::cppu::any2bool( aValue ));
725  }
726  else if ( aPropertyName == SC_UNO_DP_DRILLDOWN )
727  {
728  aNewData.SetDrillDown(::cppu::any2bool( aValue ));
729  }
730  else if ( aPropertyName == SC_UNO_DP_GRANDTOTAL_NAME )
731  {
732  OUString aStrVal;
733  if ( aValue >>= aStrVal )
734  aNewData.SetGrandTotalName(aStrVal);
735  }
736  else if ( aPropertyName == SC_UNO_DP_IMPORTDESC )
737  {
738  uno::Sequence<beans::PropertyValue> aArgSeq;
739  if ( aValue >>= aArgSeq )
740  {
741  ScImportSourceDesc aImportDesc(&pDocShell->GetDocument());
742 
743  const ScImportSourceDesc* pOldDesc = pDPObject->GetImportSourceDesc();
744  if (pOldDesc)
745  aImportDesc = *pOldDesc;
746 
747  ScImportParam aParam;
748  ScImportDescriptor::FillImportParam( aParam, aArgSeq );
749 
750  sheet::DataImportMode nNewType = sheet::DataImportMode_NONE;
751  if ( aParam.bImport )
752  {
753  if ( aParam.bSql )
754  nNewType = sheet::DataImportMode_SQL;
755  else if ( aParam.nType == ScDbQuery )
756  nNewType = sheet::DataImportMode_QUERY;
757  else
758  nNewType = sheet::DataImportMode_TABLE;
759  }
760  aImportDesc.nType = nNewType;
761  aImportDesc.aDBName = aParam.aDBName;
762  aImportDesc.aObject = aParam.aStatement;
763  aImportDesc.bNative = aParam.bNative;
764 
765  pDPObject->SetImportDesc( aImportDesc );
766  }
767  }
768  else if ( aPropertyName == SC_UNO_DP_SOURCESERVICE )
769  {
770  OUString aStrVal;
771  if ( aValue >>= aStrVal )
772  {
773  ScDPServiceDesc aServiceDesc("", "", "", "", "");
774 
775  const ScDPServiceDesc* pOldDesc = pDPObject->GetDPServiceDesc();
776  if (pOldDesc)
777  aServiceDesc = *pOldDesc;
778 
779  aServiceDesc.aServiceName = aStrVal;
780 
781  pDPObject->SetServiceData( aServiceDesc );
782  }
783  }
784  else if ( aPropertyName == SC_UNO_DP_SERVICEARG )
785  {
786  uno::Sequence<beans::PropertyValue> aArgSeq;
787  if ( aValue >>= aArgSeq )
788  {
789  ScDPServiceDesc aServiceDesc("", "", "", "", "");
790 
791  const ScDPServiceDesc* pOldDesc = pDPObject->GetDPServiceDesc();
792  if (pOldDesc)
793  aServiceDesc = *pOldDesc;
794 
795  OUString aStrVal;
796  for (const beans::PropertyValue& rProp : std::as_const(aArgSeq))
797  {
798  OUString aPropName(rProp.Name);
799 
800  if (aPropName == SC_UNO_DP_SOURCENAME)
801  {
802  if ( rProp.Value >>= aStrVal )
803  aServiceDesc.aParSource = aStrVal;
804  }
805  else if (aPropName == SC_UNO_DP_OBJECTNAME)
806  {
807  if ( rProp.Value >>= aStrVal )
808  aServiceDesc.aParName = aStrVal;
809  }
810  else if (aPropName == SC_UNO_DP_USERNAME)
811  {
812  if ( rProp.Value >>= aStrVal )
813  aServiceDesc.aParUser = aStrVal;
814  }
815  else if (aPropName == SC_UNO_DP_PASSWORD)
816  {
817  if ( rProp.Value >>= aStrVal )
818  aServiceDesc.aParPass = aStrVal;
819  }
820  }
821 
822  pDPObject->SetServiceData( aServiceDesc );
823  }
824  }
825  else
826  throw UnknownPropertyException(aPropertyName);
827 
828  pDPObject->SetSaveData( aNewData );
829  }
830 
831  SetDPObject(pDPObject);
832 }
833 
834 Any SAL_CALL ScDataPilotDescriptorBase::getPropertyValue( const OUString& aPropertyName )
835 {
836  SolarMutexGuard aGuard;
837  Any aRet;
838 
839  ScDPObject* pDPObject(GetDPObject());
840  if (pDPObject)
841  {
842  ScDPSaveData* pOldData = pDPObject->GetSaveData();
843  OSL_ENSURE(pOldData, "Here should be a SaveData");
844  if ( pOldData )
845  {
846  ScDPSaveData aNewData( *pOldData );
847 
848  if ( aPropertyName == SC_UNO_DP_COLGRAND )
849  {
850  aRet <<= aNewData.GetColumnGrand();
851  }
852  else if ( aPropertyName == SC_UNO_DP_IGNORE_EMPTYROWS )
853  {
854  aRet <<= aNewData.GetIgnoreEmptyRows();
855  }
856  else if ( aPropertyName == SC_UNO_DP_REPEATEMPTY )
857  {
858  aRet <<= aNewData.GetRepeatIfEmpty();
859  }
860  else if ( aPropertyName == SC_UNO_DP_ROWGRAND )
861  {
862  aRet <<= aNewData.GetRowGrand();
863  }
864  else if ( aPropertyName == SC_UNO_DP_SHOWFILTER )
865  {
866  aRet <<= aNewData.GetFilterButton();
867  }
868  else if ( aPropertyName == SC_UNO_DP_DRILLDOWN )
869  {
870  aRet <<= aNewData.GetDrillDown();
871  }
872  else if ( aPropertyName == SC_UNO_DP_GRANDTOTAL_NAME )
873  {
874  const std::optional<OUString> & pGrandTotalName = aNewData.GetGrandTotalName();
875  if (pGrandTotalName)
876  aRet <<= *pGrandTotalName; // same behavior as in ScDPSource
877  }
878  else if ( aPropertyName == SC_UNO_DP_IMPORTDESC )
879  {
880  const ScImportSourceDesc* pImportDesc = pDPObject->GetImportSourceDesc();
881  if ( pImportDesc )
882  {
883  // fill ScImportParam so ScImportDescriptor::FillProperties can be used
884  ScImportParam aParam;
885  aParam.bImport = ( pImportDesc->nType != sheet::DataImportMode_NONE );
886  aParam.aDBName = pImportDesc->aDBName;
887  aParam.aStatement = pImportDesc->aObject;
888  aParam.bNative = pImportDesc->bNative;
889  aParam.bSql = ( pImportDesc->nType == sheet::DataImportMode_SQL );
890  aParam.nType = static_cast<sal_uInt8>(( pImportDesc->nType == sheet::DataImportMode_QUERY ) ? ScDbQuery : ScDbTable);
891 
892  uno::Sequence<beans::PropertyValue> aSeq( ScImportDescriptor::GetPropertyCount() );
893  ScImportDescriptor::FillProperties( aSeq, aParam );
894  aRet <<= aSeq;
895  }
896  else
897  {
898  // empty sequence
899  uno::Sequence<beans::PropertyValue> aEmpty(0);
900  aRet <<= aEmpty;
901  }
902  }
903  else if ( aPropertyName == SC_UNO_DP_SOURCESERVICE )
904  {
905  OUString aServiceName;
906  const ScDPServiceDesc* pServiceDesc = pDPObject->GetDPServiceDesc();
907  if (pServiceDesc)
908  aServiceName = pServiceDesc->aServiceName;
909  aRet <<= aServiceName; // empty string if no ServiceDesc set
910  }
911  else if ( aPropertyName == SC_UNO_DP_SERVICEARG )
912  {
913  const ScDPServiceDesc* pServiceDesc = pDPObject->GetDPServiceDesc();
914  if (pServiceDesc)
915  {
916  uno::Sequence<beans::PropertyValue> aSeq( comphelper::InitPropertySequence({
917  { SC_UNO_DP_SOURCENAME, Any(pServiceDesc->aParSource) },
918  { SC_UNO_DP_OBJECTNAME, Any(pServiceDesc->aParName) },
919  { SC_UNO_DP_USERNAME, Any(pServiceDesc->aParUser) },
920  { SC_UNO_DP_PASSWORD, Any(pServiceDesc->aParPass) }
921  }));
922  aRet <<= aSeq;
923  }
924  else
925  {
926  // empty sequence
927  uno::Sequence<beans::PropertyValue> aEmpty;
928  aRet <<= aEmpty;
929  }
930  }
931  else
932  throw UnknownPropertyException(aPropertyName);
933  }
934  }
935 
936  return aRet;
937 }
938 
939 void SAL_CALL ScDataPilotDescriptorBase::addPropertyChangeListener(
940  const OUString& /* aPropertyName */, const Reference<XPropertyChangeListener >& /* xListener */ )
941 {
942 }
943 
944 void SAL_CALL ScDataPilotDescriptorBase::removePropertyChangeListener(
945  const OUString& /* aPropertyName */, const Reference<XPropertyChangeListener >& /* aListener */ )
946 {
947 }
948 
949 void SAL_CALL ScDataPilotDescriptorBase::addVetoableChangeListener(
950  const OUString& /* PropertyName */, const Reference<XVetoableChangeListener >& /* aListener */ )
951 {
952 }
953 
954 void SAL_CALL ScDataPilotDescriptorBase::removeVetoableChangeListener(
955  const OUString& /* PropertyName */, const Reference<XVetoableChangeListener >& /* aListener */ )
956 {
957 }
958 
959 // XDataPilotDataLayoutFieldSupplier
960 
961 Reference< XDataPilotField > SAL_CALL ScDataPilotDescriptorBase::getDataLayoutField()
962 {
963  SolarMutexGuard aGuard;
964  if( ScDPObject* pDPObject = GetDPObject() )
965  {
966  if( ScDPSaveData* pSaveData = pDPObject->GetSaveData() )
967  {
968  if( pSaveData->GetDataLayoutDimension() )
969  {
970  ScFieldIdentifier aFieldId( SC_DATALAYOUT_NAME, true );
971  return new ScDataPilotFieldObj( *this, aFieldId );
972  }
973  }
974  }
975  return nullptr;
976 }
977 
978 // XUnoTunnel
979 
980 sal_Int64 SAL_CALL ScDataPilotDescriptorBase::getSomething(
981  const Sequence<sal_Int8 >& rId )
982 {
983  if ( isUnoTunnelId<ScDataPilotDescriptorBase>(rId) )
984  {
985  return sal::static_int_cast<sal_Int64>(reinterpret_cast<sal_IntPtr>(this));
986  }
987  return 0;
988 }
989 
990 namespace
991 {
992  class theScDataPilotDescriptorBaseUnoTunnelId : public rtl::Static< UnoTunnelIdInit, theScDataPilotDescriptorBaseUnoTunnelId> {};
993 }
994 
995 const Sequence<sal_Int8>& ScDataPilotDescriptorBase::getUnoTunnelId()
996 {
997  return theScDataPilotDescriptorBaseUnoTunnelId::get().getSeq();
998 }
999 
1000 ScDataPilotTableObj::ScDataPilotTableObj(ScDocShell* pDocSh, SCTAB nT, const OUString& rN) :
1001  ScDataPilotDescriptorBase( pDocSh ),
1002  nTab( nT ),
1003  aName( rN ),
1004  aModifyListeners( 0 )
1005 {
1006 }
1007 
1008 ScDataPilotTableObj::~ScDataPilotTableObj()
1009 {
1010 }
1011 
1012 Any SAL_CALL ScDataPilotTableObj::queryInterface( const uno::Type& rType )
1013 {
1014  // since we manually do resolve the query for XDataPilotTable2
1015  // we also need to do the same for XDataPilotTable
1016  SC_QUERYINTERFACE( XDataPilotTable )
1017  SC_QUERYINTERFACE( XDataPilotTable2 )
1018  SC_QUERYINTERFACE( XModifyBroadcaster )
1019 
1020  return ScDataPilotDescriptorBase::queryInterface( rType );
1021 }
1022 
1023 void SAL_CALL ScDataPilotTableObj::acquire() throw()
1024 {
1025  ScDataPilotDescriptorBase::acquire();
1026 }
1027 
1028 void SAL_CALL ScDataPilotTableObj::release() throw()
1029 {
1030  ScDataPilotDescriptorBase::release();
1031 }
1032 
1033 Sequence< uno::Type > SAL_CALL ScDataPilotTableObj::getTypes()
1034 {
1035  return comphelper::concatSequences(
1036  ScDataPilotDescriptorBase::getTypes(),
1037  Sequence< uno::Type >
1038  {
1039  cppu::UnoType<XDataPilotTable2>::get(),
1040  cppu::UnoType<XModifyBroadcaster>::get()
1041  } );
1042 }
1043 
1044 Sequence<sal_Int8> SAL_CALL ScDataPilotTableObj::getImplementationId()
1045 {
1046  return css::uno::Sequence<sal_Int8>();
1047 }
1048 
1049 ScDPObject* ScDataPilotTableObj::GetDPObject() const
1050 {
1051  return lcl_GetDPObject(GetDocShell(), nTab, aName);
1052 }
1053 
1054 void ScDataPilotTableObj::SetDPObject( ScDPObject* pDPObject )
1055 {
1056  ScDocShell* pDocSh = GetDocShell();
1057  ScDPObject* pDPObj = lcl_GetDPObject(pDocSh, nTab, aName);
1058  if ( pDPObj && pDocSh )
1059  {
1060  ScDBDocFunc aFunc(*pDocSh);
1061  aFunc.DataPilotUpdate( pDPObj, pDPObject, true, true );
1062  }
1063 }
1064 
1065 // "rest of XDataPilotDescriptor"
1066 
1067 OUString SAL_CALL ScDataPilotTableObj::getName()
1068 {
1069  SolarMutexGuard aGuard;
1070  ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName);
1071  if (pDPObj)
1072  return pDPObj->GetName();
1073  return OUString();
1074 }
1075 
1076 void SAL_CALL ScDataPilotTableObj::setName( const OUString& aNewName )
1077 {
1078  SolarMutexGuard aGuard;
1079  ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName);
1080  if (pDPObj)
1081  {
1083 
1084  pDPObj->SetName( aNewName );
1085  aName = aNewName;
1086 
1087  // DataPilotUpdate would do too much (output table is not changed)
1088  GetDocShell()->SetDocumentModified();
1089  }
1090 }
1091 
1092 OUString SAL_CALL ScDataPilotTableObj::getTag()
1093 {
1094  SolarMutexGuard aGuard;
1095  ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName);
1096  if (pDPObj)
1097  return pDPObj->GetTag();
1098  return OUString();
1099 }
1100 
1101 void SAL_CALL ScDataPilotTableObj::setTag( const OUString& aNewTag )
1102 {
1103  SolarMutexGuard aGuard;
1104  ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName);
1105  if (pDPObj)
1106  {
1107  pDPObj->SetTag( aNewTag );
1108 
1109  // DataPilotUpdate would do too much (output table is not changed)
1110  GetDocShell()->SetDocumentModified();
1111  }
1112 }
1113 
1114 // XDataPilotTable
1115 
1116 CellRangeAddress SAL_CALL ScDataPilotTableObj::getOutputRange()
1117 {
1118  SolarMutexGuard aGuard;
1119  CellRangeAddress aRet;
1120  ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName);
1121  if (pDPObj)
1122  {
1123  ScRange aRange(pDPObj->GetOutRange());
1124  aRet.Sheet = aRange.aStart.Tab();
1125  aRet.StartColumn = aRange.aStart.Col();
1126  aRet.StartRow = aRange.aStart.Row();
1127  aRet.EndColumn = aRange.aEnd.Col();
1128  aRet.EndRow = aRange.aEnd.Row();
1129  }
1130  return aRet;
1131 }
1132 
1133 void SAL_CALL ScDataPilotTableObj::refresh()
1134 {
1135  SolarMutexGuard aGuard;
1136  ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName);
1137  if (pDPObj)
1138  {
1139  ScDBDocFunc aFunc(*GetDocShell());
1140  aFunc.RefreshPivotTables(pDPObj, true);
1141  }
1142 }
1143 
1144 Sequence< Sequence<Any> > SAL_CALL ScDataPilotTableObj::getDrillDownData(const CellAddress& aAddr)
1145 {
1146  SolarMutexGuard aGuard;
1147  Sequence< Sequence<Any> > aTabData;
1148  ScAddress aAddr2(static_cast<SCCOL>(aAddr.Column), static_cast<SCROW>(aAddr.Row), aAddr.Sheet);
1149  ScDPObject* pObj = GetDPObject();
1150  if (!pObj)
1151  throw RuntimeException("Failed to get DPObject", static_cast<cppu::OWeakObject*>(this));
1152 
1153  pObj->GetDrillDownData(aAddr2, aTabData);
1154  return aTabData;
1155 }
1156 
1157 DataPilotTablePositionData SAL_CALL ScDataPilotTableObj::getPositionData(const CellAddress& aAddr)
1158 {
1159  SolarMutexGuard aGuard;
1160  DataPilotTablePositionData aPosData;
1161  ScAddress aAddr2(static_cast<SCCOL>(aAddr.Column), static_cast<SCROW>(aAddr.Row), aAddr.Sheet);
1162  ScDPObject* pObj = GetDPObject();
1163  if (!pObj)
1164  throw RuntimeException("Failed to get DPObject", static_cast<cppu::OWeakObject*>(this));
1165 
1166  pObj->GetPositionData(aAddr2, aPosData);
1167  return aPosData;
1168 }
1169 
1170 void SAL_CALL ScDataPilotTableObj::insertDrillDownSheet(const CellAddress& aAddr)
1171 {
1172  SolarMutexGuard aGuard;
1173  ScDPObject* pDPObj = GetDPObject();
1174  if (!pDPObj)
1175  throw RuntimeException("Failed to get DPObject", static_cast<cppu::OWeakObject*>(this));
1176  ScTabViewShell* pViewSh = GetDocShell()->GetBestViewShell();
1177  if (!pViewSh)
1178  throw RuntimeException("Failed to get ViewShell", static_cast<cppu::OWeakObject*>(this));
1179 
1180  Sequence<DataPilotFieldFilter> aFilters;
1181  pDPObj->GetDataFieldPositionData(
1182  ScAddress(static_cast<SCCOL>(aAddr.Column), static_cast<SCROW>(aAddr.Row), aAddr.Sheet), aFilters);
1183  pViewSh->ShowDataPilotSourceData(*pDPObj, aFilters);
1184 }
1185 
1186 CellRangeAddress SAL_CALL ScDataPilotTableObj::getOutputRangeByType( sal_Int32 nType )
1187 {
1188  SolarMutexGuard aGuard;
1189  if (nType < 0 || nType > DataPilotOutputRangeType::RESULT)
1190  throw IllegalArgumentException("nType must be between 0 and " +
1191  OUString::number(DataPilotOutputRangeType::RESULT) + ", got " + OUString::number(nType),
1192  static_cast<cppu::OWeakObject*>(this), 0);
1193 
1194  CellRangeAddress aRet;
1195  if (ScDPObject* pDPObj = lcl_GetDPObject(GetDocShell(), nTab, aName))
1196  ScUnoConversion::FillApiRange( aRet, pDPObj->GetOutputRangeByType( nType ) );
1197  return aRet;
1198 }
1199 
1200 void SAL_CALL ScDataPilotTableObj::addModifyListener( const uno::Reference<util::XModifyListener>& aListener )
1201 {
1202  SolarMutexGuard aGuard;
1203 
1204  aModifyListeners.emplace_back( aListener );
1205 
1206  if ( aModifyListeners.size() == 1 )
1207  {
1208  acquire(); // don't lose this object (one ref for all listeners)
1209  }
1210 }
1211 
1212 void SAL_CALL ScDataPilotTableObj::removeModifyListener( const uno::Reference<util::XModifyListener>& aListener )
1213 {
1214  SolarMutexGuard aGuard;
1215 
1216  rtl::Reference<ScDataPilotTableObj> xSelfHold(this); // in case the listeners have the last ref
1217 
1218  sal_uInt16 nCount = aModifyListeners.size();
1219  for ( sal_uInt16 n=nCount; n--; )
1220  {
1221  uno::Reference<util::XModifyListener>& rObj = aModifyListeners[n];
1222  if ( rObj == aListener )
1223  {
1224  aModifyListeners.erase( aModifyListeners.begin() + n );
1225 
1226  if ( aModifyListeners.empty() )
1227  {
1228  release(); // release the ref for the listeners
1229  }
1230 
1231  break;
1232  }
1233  }
1234 }
1235 
1236 void ScDataPilotTableObj::Notify( SfxBroadcaster& rBC, const SfxHint& rHint )
1237 {
1238  if ( auto pDataPilotHint = dynamic_cast<const ScDataPilotModifiedHint*>(&rHint) )
1239  {
1240  if (pDataPilotHint->GetName() == aName)
1241  Refreshed_Impl();
1242  }
1243  else if ( auto pRefHint = dynamic_cast<const ScUpdateRefHint*>(&rHint) )
1244  {
1245  ScRange aRange( 0, 0, nTab );
1246  ScRangeList aRanges( aRange );
1247  if ( aRanges.UpdateReference( pRefHint->GetMode(), &GetDocShell()->GetDocument(), pRefHint->GetRange(),
1248  pRefHint->GetDx(), pRefHint->GetDy(), pRefHint->GetDz() ) &&
1249  aRanges.size() == 1 )
1250  {
1251  nTab = aRanges.front().aStart.Tab();
1252  }
1253  }
1254 
1255  ScDataPilotDescriptorBase::Notify( rBC, rHint );
1256 }
1257 
1258 void ScDataPilotTableObj::Refreshed_Impl()
1259 {
1260  lang::EventObject aEvent;
1261  aEvent.Source.set(static_cast<cppu::OWeakObject*>(this));
1262 
1263  // the EventObject holds a Ref to this object until after the listener calls
1264 
1265  ScDocument& rDoc = GetDocShell()->GetDocument();
1266  for (const uno::Reference<util::XModifyListener> & xModifyListener : aModifyListeners)
1267  rDoc.AddUnoListenerCall( xModifyListener, aEvent );
1268 }
1269 
1270 ScDataPilotDescriptor::ScDataPilotDescriptor(ScDocShell* pDocSh) :
1271  ScDataPilotDescriptorBase( pDocSh ),
1272  mpDPObject(new ScDPObject(pDocSh ? &pDocSh->GetDocument() : nullptr) )
1273 {
1274  ScDPSaveData aSaveData;
1275  // set defaults like in ScPivotParam constructor
1276  aSaveData.SetColumnGrand( true );
1277  aSaveData.SetRowGrand( true );
1278  aSaveData.SetIgnoreEmptyRows( false );
1279  aSaveData.SetRepeatIfEmpty( false );
1280  mpDPObject->SetSaveData(aSaveData);
1281  ScSheetSourceDesc aSheetDesc(pDocSh ? &pDocSh->GetDocument() : nullptr);
1282  mpDPObject->SetSheetDesc(aSheetDesc);
1283 }
1284 
1285 ScDataPilotDescriptor::~ScDataPilotDescriptor()
1286 {
1287 }
1288 
1289 ScDPObject* ScDataPilotDescriptor::GetDPObject() const
1290 {
1291  return mpDPObject.get();
1292 }
1293 
1294 void ScDataPilotDescriptor::SetDPObject( ScDPObject* pDPObject )
1295 {
1296  if (mpDPObject.get() != pDPObject)
1297  {
1298  mpDPObject.reset( pDPObject );
1299  OSL_FAIL("replace DPObject should not happen");
1300  }
1301 }
1302 
1303 // "rest of XDataPilotDescriptor"
1304 
1305 OUString SAL_CALL ScDataPilotDescriptor::getName()
1306 {
1307  SolarMutexGuard aGuard;
1308  return mpDPObject->GetName();
1309 }
1310 
1311 void SAL_CALL ScDataPilotDescriptor::setName( const OUString& aNewName )
1312 {
1313  SolarMutexGuard aGuard;
1314  mpDPObject->SetName( aNewName );
1315 }
1316 
1317 OUString SAL_CALL ScDataPilotDescriptor::getTag()
1318 {
1319  SolarMutexGuard aGuard;
1320  return mpDPObject->GetTag();
1321 }
1322 
1323 void SAL_CALL ScDataPilotDescriptor::setTag( const OUString& aNewTag )
1324 {
1325  SolarMutexGuard aGuard;
1326  mpDPObject->SetTag( aNewTag );
1327 }
1328 
1329 ScDataPilotChildObjBase::ScDataPilotChildObjBase( ScDataPilotDescriptorBase& rParent ) :
1330  mxParent( &rParent )
1331 {
1332 }
1333 
1334 ScDataPilotChildObjBase::ScDataPilotChildObjBase( ScDataPilotDescriptorBase& rParent, const ScFieldIdentifier& rFieldId ) :
1335  mxParent( &rParent ),
1336  maFieldId( rFieldId )
1337 {
1338 }
1339 
1340 ScDataPilotChildObjBase::~ScDataPilotChildObjBase()
1341 {
1342 }
1343 
1344 ScDPObject* ScDataPilotChildObjBase::GetDPObject() const
1345 {
1346  return mxParent->GetDPObject();
1347 }
1348 
1349 void ScDataPilotChildObjBase::SetDPObject( ScDPObject* pDPObject )
1350 {
1351  mxParent->SetDPObject( pDPObject );
1352 }
1353 
1354 ScDPSaveDimension* ScDataPilotChildObjBase::GetDPDimension( ScDPObject** ppDPObject ) const
1355 {
1356  if( ScDPObject* pDPObj = GetDPObject() )
1357  {
1358  if( ppDPObject ) *ppDPObject = pDPObj;
1359  if( ScDPSaveData* pSaveData = pDPObj->GetSaveData() )
1360  {
1361  if( maFieldId.mbDataLayout )
1362  return pSaveData->GetDataLayoutDimension();
1363 
1364  if( maFieldId.mnFieldIdx == 0 )
1365  return pSaveData->GetDimensionByName( maFieldId.maFieldName );
1366 
1367  // find dimension with specified index (search in duplicated dimensions)
1368  const ScDPSaveData::DimsType& rDims = pSaveData->GetDimensions();
1369 
1370  sal_Int32 nFoundIdx = 0;
1371  for (auto const& it : rDims)
1372  {
1373  if (it->IsDataLayout())
1374  continue;
1375 
1376  OUString aSrcName = ScDPUtil::getSourceDimensionName(it->GetName());
1377  if (aSrcName == maFieldId.maFieldName)
1378  {
1379  if( nFoundIdx == maFieldId.mnFieldIdx )
1380  return it.get();
1381  ++nFoundIdx;
1382  }
1383  }
1384  }
1385  }
1386  return nullptr;
1387 }
1388 
1389 sal_Int32 ScDataPilotChildObjBase::GetMemberCount() const
1390 {
1391  sal_Int32 nRet = 0;
1392  Reference<XNameAccess> xMembersNA = GetMembers();
1393  if (xMembersNA.is())
1394  {
1395  Reference< XIndexAccess > xMembersIA( new ScNameToIndexAccess( xMembersNA ) );
1396  nRet = xMembersIA->getCount();
1397  }
1398  return nRet;
1399 }
1400 
1401 Reference< XMembersAccess > ScDataPilotChildObjBase::GetMembers() const
1402 {
1403  Reference< XMembersAccess > xMembersNA;
1404  if( ScDPObject* pDPObj = GetDPObject() )
1405  pDPObj->GetMembersNA( lcl_GetObjectIndex( pDPObj, maFieldId ), xMembersNA );
1406  return xMembersNA;
1407 }
1408 
1409 ScDocShell* ScDataPilotChildObjBase::GetDocShell() const
1410 {
1411  return mxParent->GetDocShell();
1412 }
1413 
1414 ScDataPilotFieldsObj::ScDataPilotFieldsObj( ScDataPilotDescriptorBase& rParent ) :
1415  ScDataPilotChildObjBase( rParent )
1416 {
1417 }
1418 
1419 ScDataPilotFieldsObj::ScDataPilotFieldsObj( ScDataPilotDescriptorBase& rParent, DataPilotFieldOrientation eOrient ) :
1420  ScDataPilotChildObjBase( rParent ),
1421  maOrient( eOrient )
1422 {
1423 }
1424 
1425 ScDataPilotFieldsObj::~ScDataPilotFieldsObj()
1426 {
1427 }
1428 
1429 static sal_Int32 lcl_GetFieldCount( const Reference<XDimensionsSupplier>& rSource, const Any& rOrient )
1430 {
1431  if (!rSource.is())
1432  throw NullPointerException();
1433 
1434  sal_Int32 nRet = 0;
1435 
1436  Reference<XNameAccess> xDimsName(rSource->getDimensions());
1437  Reference<XIndexAccess> xIntDims(new ScNameToIndexAccess( xDimsName ));
1438  sal_Int32 nIntCount = xIntDims->getCount();
1439  for (sal_Int32 i = 0; i < nIntCount; ++i)
1440  {
1441  Reference<XPropertySet> xDim(xIntDims->getByIndex(i), UNO_QUERY);
1442  const bool bMatch = xDim
1443  && (rOrient.hasValue()
1444  // all fields of the specified orientation, including duplicated
1445  ? (xDim->getPropertyValue(SC_UNO_DP_ORIENTATION) == rOrient)
1446  // count all non-duplicated fields
1447  : !lcl_IsDuplicated(xDim));
1448  if (bMatch)
1449  ++nRet;
1450  }
1451 
1452  return nRet;
1453 }
1454 
1455 static bool lcl_GetFieldDataByIndex( const Reference<XDimensionsSupplier>& rSource,
1456  const Any& rOrient, SCSIZE nIndex, ScFieldIdentifier& rFieldId )
1457 {
1458  if (!rSource.is())
1459  throw NullPointerException();
1460 
1461  bool bOk = false;
1462  SCSIZE nPos = 0;
1463  sal_Int32 nDimIndex = 0;
1464 
1465  Reference<XNameAccess> xDimsName(rSource->getDimensions());
1466  Reference<XIndexAccess> xIntDims(new ScNameToIndexAccess( xDimsName ));
1467  sal_Int32 nIntCount = xIntDims->getCount();
1468  Reference<XPropertySet> xDim;
1469  for (sal_Int32 i = 0; i < nIntCount; ++i)
1470  {
1471  xDim.set(xIntDims->getByIndex(i), UNO_QUERY);
1472  const bool bMatch = xDim
1473  && (rOrient.hasValue()
1474  ? (xDim->getPropertyValue(SC_UNO_DP_ORIENTATION) == rOrient)
1475  : !lcl_IsDuplicated(xDim));
1476  if (bMatch)
1477  {
1478  if (nPos == nIndex)
1479  {
1480  bOk = true;
1481  nDimIndex = i;
1482  break;
1483  }
1484  else
1485  ++nPos;
1486  }
1487  }
1488 
1489  if ( bOk )
1490  {
1491  xDim.set( xIntDims->getByIndex(nDimIndex), UNO_QUERY );
1492  Reference<XNamed> xDimName( xDim, UNO_QUERY );
1493  if ( xDimName.is() )
1494  {
1495  OUString sOriginalName( lcl_GetOriginalName( xDimName ) );
1496  rFieldId.maFieldName = sOriginalName;
1497  rFieldId.mbDataLayout = ScUnoHelpFunctions::GetBoolProperty( xDim,
1498  SC_UNO_DP_ISDATALAYOUT );
1499 
1500  sal_Int32 nRepeat = 0;
1501  if ( rOrient.hasValue() && lcl_IsDuplicated( xDim ) )
1502  {
1503  // find the repeat count
1504  // (this relies on the original dimension always being before the duplicates)
1505 
1506  Reference<XNamed> xPrevName;
1507  for (sal_Int32 i = 0; i < nDimIndex; ++i)
1508  {
1509  xPrevName.set( xIntDims->getByIndex(i), UNO_QUERY );
1510  if ( xPrevName.is() && lcl_GetOriginalName( xPrevName ) == sOriginalName )
1511  ++nRepeat;
1512  }
1513  }
1514  rFieldId.mnFieldIdx = nRepeat;
1515  }
1516  else
1517  bOk = false;
1518  }
1519 
1520  return bOk;
1521 }
1522 
1523 static bool lcl_GetFieldDataByName( ScDPObject* pDPObj, const OUString& rFieldName, ScFieldIdentifier& rFieldId )
1524 {
1525  // "By name" is always the first match.
1526  // The name "Data" always refers to the data layout field.
1527  rFieldId.maFieldName = rFieldName;
1528  rFieldId.mnFieldIdx = 0;
1529  rFieldId.mbDataLayout = rFieldName == SC_DATALAYOUT_NAME;
1530 
1531  pDPObj->GetSource(); // IsDimNameInUse doesn't update source data
1532 
1533  // check if the named field exists (not for data layout)
1534  return rFieldId.mbDataLayout || pDPObj->IsDimNameInUse( rFieldName );
1535 }
1536 
1537 // XDataPilotFields
1538 
1539 ScDataPilotFieldObj* ScDataPilotFieldsObj::GetObjectByIndex_Impl( sal_Int32 nIndex ) const
1540 {
1541  if (ScDPObject* pObj = GetDPObject())
1542  {
1543  ScFieldIdentifier aFieldId;
1544  if (lcl_GetFieldDataByIndex( pObj->GetSource(), maOrient, nIndex, aFieldId ))
1545  return new ScDataPilotFieldObj( *mxParent, aFieldId, maOrient );
1546  }
1547  return nullptr;
1548 }
1549 
1550 ScDataPilotFieldObj* ScDataPilotFieldsObj::GetObjectByName_Impl(const OUString& aName) const
1551 {
1552  if (ScDPObject* pDPObj = GetDPObject())
1553  {
1554  ScFieldIdentifier aFieldId;
1555  if (lcl_GetFieldDataByName( pDPObj, aName, aFieldId ))
1556  return new ScDataPilotFieldObj( *mxParent, aFieldId, maOrient );
1557  }
1558  return nullptr;
1559 }
1560 
1561 // XEnumerationAccess
1562 
1563 Reference<XEnumeration> SAL_CALL ScDataPilotFieldsObj::createEnumeration()
1564 {
1565  SolarMutexGuard aGuard;
1566  return new ScIndexEnumeration(this, "com.sun.star.sheet.DataPilotFieldsEnumeration");
1567 }
1568 
1569 // XIndexAccess
1570 
1571 sal_Int32 SAL_CALL ScDataPilotFieldsObj::getCount()
1572 {
1573  SolarMutexGuard aGuard;
1574  ScDPObject* pDPObj = GetDPObject();
1575  return pDPObj ? lcl_GetFieldCount( pDPObj->GetSource(), maOrient ) : 0;
1576 }
1577 
1578 Any SAL_CALL ScDataPilotFieldsObj::getByIndex( sal_Int32 nIndex )
1579 {
1580  SolarMutexGuard aGuard;
1581  Reference< XPropertySet > xField( GetObjectByIndex_Impl( nIndex ) );
1582  if (!xField.is())
1583  throw IndexOutOfBoundsException();
1584  return Any( xField );
1585 }
1586 
1587 // XElementAccess
1588 
1589 uno::Type SAL_CALL ScDataPilotFieldsObj::getElementType()
1590 {
1591  SolarMutexGuard aGuard;
1592  return cppu::UnoType<XPropertySet>::get();
1593 }
1594 
1595 sal_Bool SAL_CALL ScDataPilotFieldsObj::hasElements()
1596 {
1597  SolarMutexGuard aGuard;
1598  return ( getCount() != 0 );
1599 }
1600 
1601 // XNameAccess
1602 
1603 Any SAL_CALL ScDataPilotFieldsObj::getByName( const OUString& aName )
1604 {
1605  SolarMutexGuard aGuard;
1606  Reference<XPropertySet> xField(GetObjectByName_Impl(aName));
1607  if (!xField.is())
1608  throw NoSuchElementException();
1609  return Any( xField );
1610 }
1611 
1612 Sequence<OUString> SAL_CALL ScDataPilotFieldsObj::getElementNames()
1613 {
1614  SolarMutexGuard aGuard;
1615  if (ScDPObject* pDPObj = GetDPObject())
1616  {
1617  Sequence< OUString > aSeq( lcl_GetFieldCount( pDPObj->GetSource(), maOrient ) );
1618  OUString* pAry = aSeq.getArray();
1619 
1620  const ScDPSaveData::DimsType& rDimensions = pDPObj->GetSaveData()->GetDimensions();
1621  for (auto const& it : rDimensions)
1622  {
1623  if(maOrient.hasValue() && (it->GetOrientation() == maOrient.get< DataPilotFieldOrientation >()))
1624  {
1625  *pAry = it->GetName();
1626  ++pAry;
1627  }
1628  }
1629  return aSeq;
1630  }
1631  return Sequence<OUString>();
1632 }
1633 
1634 sal_Bool SAL_CALL ScDataPilotFieldsObj::hasByName( const OUString& aName )
1635 {
1636  SolarMutexGuard aGuard;
1637 
1638  return GetObjectByName_Impl(aName) != nullptr;
1639 }
1640 
1641 ScDataPilotFieldObj::ScDataPilotFieldObj(
1642  ScDataPilotDescriptorBase& rParent, const ScFieldIdentifier& rFieldId ) :
1643  ScDataPilotChildObjBase( rParent, rFieldId ),
1644  maPropSet( lcl_GetDataPilotFieldMap() )
1645 {
1646 }
1647 
1648 ScDataPilotFieldObj::ScDataPilotFieldObj( ScDataPilotDescriptorBase& rParent,
1649  const ScFieldIdentifier& rFieldId, const Any& rOrient ) :
1650  ScDataPilotChildObjBase( rParent, rFieldId ),
1651  maPropSet( lcl_GetDataPilotFieldMap() ),
1652  maOrient( rOrient )
1653 {
1654 }
1655 
1656 ScDataPilotFieldObj::~ScDataPilotFieldObj()
1657 {
1658 }
1659 
1660 // XNamed
1661 
1662 OUString SAL_CALL ScDataPilotFieldObj::getName()
1663 {
1664  SolarMutexGuard aGuard;
1665  OUString aName;
1666  if( ScDPSaveDimension* pDim = GetDPDimension() )
1667  {
1668  if( pDim->IsDataLayout() )
1669  aName = SC_DATALAYOUT_NAME;
1670  else
1671  {
1672  const std::optional<OUString> & pLayoutName = pDim->GetLayoutName();
1673  if (pLayoutName)
1674  aName = *pLayoutName;
1675  else
1676  aName = pDim->GetName();
1677  } }
1678  return aName;
1679 }
1680 
1681 void SAL_CALL ScDataPilotFieldObj::setName(const OUString& rName)
1682 {
1683  SolarMutexGuard aGuard;
1684  ScDPObject* pDPObj = nullptr;
1685  ScDPSaveDimension* pDim = GetDPDimension( &pDPObj );
1686  if( pDim && !pDim->IsDataLayout() )
1687  {
1688  pDim->SetLayoutName(rName);
1689  SetDPObject( pDPObj );
1690  }
1691 }
1692 
1693 // XPropertySet
1694 
1695 Reference<XPropertySetInfo> SAL_CALL ScDataPilotFieldObj::getPropertySetInfo()
1696 {
1697  SolarMutexGuard aGuard;
1698  static Reference<XPropertySetInfo> aRef(
1699  new SfxItemPropertySetInfo( maPropSet.getPropertyMap() ));
1700  return aRef;
1701 }
1702 
1703 void SAL_CALL ScDataPilotFieldObj::setPropertyValue( const OUString& aPropertyName, const Any& aValue )
1704 {
1705  SolarMutexGuard aGuard;
1706  if ( aPropertyName == SC_UNONAME_FUNCTION )
1707  {
1708  // #i109350# use GetEnumFromAny because it also allows sal_Int32
1709  ScGeneralFunction eFunction = static_cast<ScGeneralFunction>(ScUnoHelpFunctions::GetEnumFromAny( aValue ));
1710  setFunction( eFunction );
1711  }
1712  else if ( aPropertyName == SC_UNONAME_FUNCTION2 )
1713  {
1714  ScGeneralFunction eFunction = static_cast<ScGeneralFunction>(ScUnoHelpFunctions::GetInt16FromAny( aValue ));
1715  setFunction( eFunction );
1716  }
1717  else if ( aPropertyName == SC_UNONAME_SUBTOTALS )
1718  {
1719  uno::Sequence<sheet::GeneralFunction> aSeq;
1720  if( aValue >>= aSeq)
1721  {
1722  std::vector< ScGeneralFunction > aSubTotals(aSeq.getLength());
1723  std::transform(aSeq.begin(), aSeq.end(), aSubTotals.begin(),
1724  [](const sheet::GeneralFunction& rValue) -> ScGeneralFunction {
1725  const int nValAsInt = static_cast<int>(rValue);
1726  return static_cast<ScGeneralFunction>(nValAsInt);
1727  });
1728  setSubtotals( aSubTotals );
1729  }
1730  }
1731  else if ( aPropertyName == SC_UNONAME_SUBTOTALS2 )
1732  {
1733  Sequence< sal_Int16 > aSeq;
1734  if( aValue >>= aSeq )
1735  {
1736  std::vector< ScGeneralFunction > aSubTotals(aSeq.getLength());
1737  std::transform(aSeq.begin(), aSeq.end(), aSubTotals.begin(),
1738  [](sal_Int16 nValue) -> ScGeneralFunction { return static_cast<ScGeneralFunction>(nValue); });
1739  setSubtotals( aSubTotals );
1740  }
1741  }
1742  else if ( aPropertyName == SC_UNONAME_ORIENT )
1743  {
1745  DataPilotFieldOrientation eOrient = static_cast<DataPilotFieldOrientation>(ScUnoHelpFunctions::GetEnumFromAny( aValue ));
1746  setOrientation( eOrient );
1747  }
1748  else if ( aPropertyName == SC_UNONAME_SELPAGE )
1749  {
1750  OUString sCurrentPage;
1751  if (aValue >>= sCurrentPage)
1752  setCurrentPage(sCurrentPage);
1753  }
1754  else if ( aPropertyName == SC_UNONAME_USESELPAGE )
1755  {
1756  setUseCurrentPage(cppu::any2bool(aValue));
1757  }
1758  else if ( aPropertyName == SC_UNONAME_HASAUTOSHOW )
1759  {
1760  if (!cppu::any2bool(aValue))
1761  setAutoShowInfo(nullptr);
1762  }
1763  else if ( aPropertyName == SC_UNONAME_AUTOSHOW )
1764  {
1765  DataPilotFieldAutoShowInfo aInfo;
1766  if (aValue >>= aInfo)
1767  setAutoShowInfo(&aInfo);
1768  }
1769  else if ( aPropertyName == SC_UNONAME_HASLAYOUTINFO )
1770  {
1771  if (!cppu::any2bool(aValue))
1772  setLayoutInfo(nullptr);
1773  }
1774  else if ( aPropertyName == SC_UNONAME_LAYOUTINFO )
1775  {
1776  DataPilotFieldLayoutInfo aInfo;
1777  if (aValue >>= aInfo)
1778  setLayoutInfo(&aInfo);
1779  }
1780  else if ( aPropertyName == SC_UNONAME_HASREFERENCE )
1781  {
1782  if (!cppu::any2bool(aValue))
1783  setReference(nullptr);
1784  }
1785  else if ( aPropertyName == SC_UNONAME_REFERENCE )
1786  {
1787  DataPilotFieldReference aRef;
1788  if (aValue >>= aRef)
1789  setReference(&aRef);
1790  }
1791  else if ( aPropertyName == SC_UNONAME_HASSORTINFO )
1792  {
1793  if (!cppu::any2bool(aValue))
1794  setSortInfo(nullptr);
1795  }
1796  else if ( aPropertyName == SC_UNONAME_SORTINFO )
1797  {
1798  DataPilotFieldSortInfo aInfo;
1799  if (aValue >>= aInfo)
1800  setSortInfo(&aInfo);
1801  }
1802  else if ( aPropertyName == SC_UNONAME_ISGROUP )
1803  {
1804  if (!cppu::any2bool(aValue))
1805  setGroupInfo(nullptr);
1806  }
1807  else if ( aPropertyName == SC_UNONAME_GROUPINFO )
1808  {
1809  DataPilotFieldGroupInfo aInfo;
1810  if (aValue >>= aInfo)
1811  setGroupInfo(&aInfo);
1812  }
1813  else if ( aPropertyName == SC_UNONAME_SHOWEMPTY )
1814  {
1815  setShowEmpty(cppu::any2bool(aValue));
1816  }
1817  else if ( aPropertyName == SC_UNONAME_REPEATITEMLABELS )
1818  {
1819  setRepeatItemLabels(cppu::any2bool(aValue));
1820  }
1821  else if (aPropertyName == SC_UNONAME_NAME)
1822  {
1823  OUString sName;
1824  if (aValue >>= sName)
1825  setName(sName);
1826  }
1827 }
1828 
1829 Any SAL_CALL ScDataPilotFieldObj::getPropertyValue( const OUString& aPropertyName )
1830 {
1831  SolarMutexGuard aGuard;
1832  Any aRet;
1833 
1834  if ( aPropertyName == SC_UNONAME_FUNCTION )
1835  {
1836  sheet::GeneralFunction eVal;
1837  sal_Int16 nFunction = getFunction();
1838  if (nFunction == sheet::GeneralFunction2::MEDIAN)
1839  {
1840  eVal = sheet::GeneralFunction_NONE;
1841  }
1842  else
1843  {
1844  eVal = static_cast<sheet::GeneralFunction>(nFunction);
1845  }
1846  aRet <<= eVal;
1847  }
1848  else if ( aPropertyName == SC_UNONAME_FUNCTION2 )
1849  aRet <<= getFunction();
1850  else if ( aPropertyName == SC_UNONAME_SUBTOTALS )
1851  {
1852  const uno::Sequence<sal_Int16> aSeq = getSubtotals();
1853  uno::Sequence<sheet::GeneralFunction> aNewSeq;
1854  aNewSeq.realloc(aSeq.getLength());
1855  std::transform(aSeq.begin(), aSeq.end(), aNewSeq.begin(),
1856  [](sal_Int16 nFunc) -> sheet::GeneralFunction {
1857  if (nFunc == sheet::GeneralFunction2::MEDIAN)
1858  return sheet::GeneralFunction_NONE;
1859  return static_cast<sheet::GeneralFunction>(nFunc);
1860  });
1861  aRet <<= aNewSeq;
1862  }
1863  else if ( aPropertyName == SC_UNONAME_SUBTOTALS2 )
1864  {
1865  aRet <<= getSubtotals();
1866  }
1867  else if ( aPropertyName == SC_UNONAME_ORIENT )
1868  aRet <<= getOrientation();
1869  else if ( aPropertyName == SC_UNONAME_SELPAGE )
1870  aRet <<= OUString();
1871  else if ( aPropertyName == SC_UNONAME_USESELPAGE )
1872  aRet <<= false;
1873  else if ( aPropertyName == SC_UNONAME_HASAUTOSHOW )
1874  aRet <<= (getAutoShowInfo() != nullptr);
1875  else if ( aPropertyName == SC_UNONAME_AUTOSHOW )
1876  {
1877  const DataPilotFieldAutoShowInfo* pInfo = getAutoShowInfo();
1878  if (pInfo)
1879  aRet <<= *pInfo;
1880  }
1881  else if ( aPropertyName == SC_UNONAME_HASLAYOUTINFO )
1882  aRet <<= (getLayoutInfo() != nullptr);
1883  else if ( aPropertyName == SC_UNONAME_LAYOUTINFO )
1884  {
1885  const DataPilotFieldLayoutInfo* pInfo = getLayoutInfo();
1886  if (pInfo)
1887  aRet <<= *pInfo;
1888  }
1889  else if ( aPropertyName == SC_UNONAME_HASREFERENCE )
1890  aRet <<= (getReference() != nullptr);
1891  else if ( aPropertyName == SC_UNONAME_REFERENCE )
1892  {
1893  const DataPilotFieldReference* pRef = getReference();
1894  if (pRef)
1895  aRet <<= *pRef;
1896  }
1897  else if ( aPropertyName == SC_UNONAME_HASSORTINFO )
1898  aRet <<= (getSortInfo() != nullptr);
1899  else if ( aPropertyName == SC_UNONAME_SORTINFO )
1900  {
1901  const DataPilotFieldSortInfo* pInfo = getSortInfo();
1902  if (pInfo)
1903  aRet <<= *pInfo;
1904  }
1905  else if ( aPropertyName == SC_UNONAME_ISGROUP )
1906  aRet <<= hasGroupInfo();
1907  else if ( aPropertyName == SC_UNONAME_GROUPINFO )
1908  {
1909  aRet <<= getGroupInfo();
1910  }
1911  else if ( aPropertyName == SC_UNONAME_SHOWEMPTY )
1912  aRet <<= getShowEmpty();
1913  else if ( aPropertyName == SC_UNONAME_REPEATITEMLABELS )
1914  aRet <<= getRepeatItemLabels();
1915  else if (aPropertyName == SC_UNONAME_NAME)
1916  aRet <<= getName();
1917 
1918  return aRet;
1919 }
1920 
1921 // XDatePilotField
1922 
1923 Reference<XIndexAccess> SAL_CALL ScDataPilotFieldObj::getItems()
1924 {
1925  SolarMutexGuard aGuard;
1926  if (!mxItems.is())
1927  mxItems.set( new ScDataPilotItemsObj( *mxParent, maFieldId ) );
1928  return mxItems;
1929 }
1930 
1931 SC_IMPL_DUMMY_PROPERTY_LISTENER( ScDataPilotFieldObj )
1932 
1933 DataPilotFieldOrientation ScDataPilotFieldObj::getOrientation() const
1934 {
1935  SolarMutexGuard aGuard;
1936  ScDPSaveDimension* pDim = GetDPDimension();
1937  return pDim ? pDim->GetOrientation() : DataPilotFieldOrientation_HIDDEN;
1938 }
1939 
1940 void ScDataPilotFieldObj::setOrientation(DataPilotFieldOrientation eNew)
1941 {
1942  SolarMutexGuard aGuard;
1943  if (maOrient.hasValue() && (eNew == maOrient.get< DataPilotFieldOrientation >()))
1944  return;
1945 
1946  ScDPObject* pDPObj = nullptr;
1947  ScDPSaveDimension* pDim = GetDPDimension( &pDPObj );
1948  if(!pDim)
1949  return;
1950 
1951  ScDPSaveData* pSaveData = pDPObj->GetSaveData();
1952 
1953  /* If the field was taken from getDataPilotFields(), don't reset the
1954  orientation for an existing use, but create a duplicated field
1955  instead (for "Data" orientation only). */
1956  if ( !maOrient.hasValue() && !maFieldId.mbDataLayout &&
1957  (pDim->GetOrientation() != DataPilotFieldOrientation_HIDDEN) &&
1958  (eNew == DataPilotFieldOrientation_DATA) )
1959  {
1960 
1961  ScDPSaveDimension* pNewDim = nullptr;
1962 
1963  // look for existing duplicate with orientation "hidden"
1964 
1965  sal_Int32 nFound = 0;
1966  const ScDPSaveData::DimsType& rDimensions = pSaveData->GetDimensions();
1967  for (auto const& it : rDimensions)
1968  {
1969  if ( !it->IsDataLayout() && (it->GetName() == maFieldId.maFieldName) )
1970  {
1971  if ( it->GetOrientation() == DataPilotFieldOrientation_HIDDEN )
1972  {
1973  pNewDim = it.get(); // use this one
1974  break;
1975  }
1976  else
1977  ++nFound; // count existing non-hidden occurrences
1978  }
1979  }
1980 
1981  if ( !pNewDim ) // if none found, create a new duplicated dimension
1982  pNewDim = &pSaveData->DuplicateDimension( *pDim );
1983 
1984  maFieldId.mnFieldIdx = nFound; // keep accessing the new one
1985  pDim = pNewDim;
1986  }
1987 
1988  pDim->SetOrientation(eNew);
1989 
1990  // move changed field behind all other fields (make it the last field in dimension)
1991  pSaveData->SetPosition( pDim, pSaveData->GetDimensions().size() );
1992 
1993  SetDPObject( pDPObj );
1994 
1995  maOrient <<= eNew; // modifying the same object's orientation again doesn't create another duplicate
1996 }
1997 
1998 sal_Int16 ScDataPilotFieldObj::getFunction() const
1999 {
2000  SolarMutexGuard aGuard;
2001  sal_Int16 eRet = GeneralFunction2::NONE;
2002  if( ScDPSaveDimension* pDim = GetDPDimension() )
2003  {
2004  if( pDim->GetOrientation() != DataPilotFieldOrientation_DATA )
2005  {
2006  // for non-data fields, property Function is the subtotals
2007  tools::Long nSubCount = pDim->GetSubTotalsCount();
2008  if ( nSubCount > 0 )
2009  eRet = static_cast<sal_Int16>(pDim->GetSubTotalFunc(0)); // always use the first one
2010  // else keep NONE
2011  }
2012  else
2013  eRet = static_cast<sal_Int16>(pDim->GetFunction());
2014  }
2015  return eRet;
2016 }
2017 
2018 void ScDataPilotFieldObj::setFunction(ScGeneralFunction eNewFunc)
2019 {
2020  SolarMutexGuard aGuard;
2021  ScDPObject* pDPObj = nullptr;
2022  ScDPSaveDimension* pDim = GetDPDimension( &pDPObj );
2023  if(!pDim)
2024  return;
2025 
2026  if( pDim->GetOrientation() != DataPilotFieldOrientation_DATA )
2027  {
2028  // for non-data fields, property Function is the subtotals
2029  std::vector<ScGeneralFunction> nSubTotalFuncs;
2030  if ( eNewFunc != ScGeneralFunction::NONE )
2031  {
2032  nSubTotalFuncs.push_back( eNewFunc );
2033  }
2034  pDim->SetSubTotals( nSubTotalFuncs );
2035  }
2036  else
2037  pDim->SetFunction( eNewFunc );
2038  SetDPObject( pDPObj );
2039 }
2040 
2041 Sequence< sal_Int16 > ScDataPilotFieldObj::getSubtotals() const
2042 {
2043  SolarMutexGuard aGuard;
2044  Sequence< sal_Int16 > aRet;
2045  if( ScDPSaveDimension* pDim = GetDPDimension() )
2046  {
2047  if( pDim->GetOrientation() != DataPilotFieldOrientation_DATA )
2048  {
2049  // for non-data fields, property Functions is the sequence of subtotals
2050  sal_Int32 nCount = static_cast< sal_Int32 >( pDim->GetSubTotalsCount() );
2051  if ( nCount > 0 )
2052  {
2053  aRet.realloc( nCount );
2054  for( sal_Int32 nIdx = 0; nIdx < nCount; ++nIdx )
2055  aRet[ nIdx ] = static_cast<sal_Int16>(pDim->GetSubTotalFunc( nIdx ));
2056  }
2057  }
2058  }
2059  return aRet;
2060 }
2061 
2062 void ScDataPilotFieldObj::setSubtotals( const std::vector< ScGeneralFunction >& rSubtotals )
2063 {
2064  SolarMutexGuard aGuard;
2065  ScDPObject* pDPObj = nullptr;
2066  ScDPSaveDimension* pDim = GetDPDimension( &pDPObj );
2067  if(!pDim)
2068  return;
2069 
2070  if( pDim->GetOrientation() != DataPilotFieldOrientation_DATA )
2071  {
2072  sal_Int32 nCount = rSubtotals.size();
2073  if( nCount == 1 )
2074  {
2075  // count 1: all values are allowed (including NONE and AUTO)
2076  std::vector<ScGeneralFunction> nTmpFuncs;
2077  if( rSubtotals[ 0 ] != ScGeneralFunction::NONE )
2078  {
2079  nTmpFuncs.push_back( rSubtotals[ 0 ] );
2080  }
2081  pDim->SetSubTotals( nTmpFuncs );
2082  }
2083  else if( nCount > 1 )
2084  {
2085  // set multiple functions, ignore NONE and AUTO in this case
2086  ::std::vector< ScGeneralFunction > aSubt;
2087  for( sal_Int32 nIdx = 0; nIdx < nCount; ++nIdx )
2088  {
2089  ScGeneralFunction eFunc = rSubtotals[ nIdx ];
2090  if( (eFunc != ScGeneralFunction::NONE) && (eFunc != ScGeneralFunction::AUTO) )
2091  {
2092  // do not insert functions twice
2093  if( ::std::find( aSubt.begin(), aSubt.end(), eFunc ) == aSubt.end() )
2094  aSubt.push_back( eFunc );
2095  }
2096  }
2097  // set values from vector to ScDPSaveDimension
2098  pDim->SetSubTotals( aSubt );
2099  }
2100  }
2101  SetDPObject( pDPObj );
2102 }
2103 
2104 void ScDataPilotFieldObj::setCurrentPage( const OUString& rPage )
2105 {
2106  SolarMutexGuard aGuard;
2107  ScDPObject* pDPObj = nullptr;
2108  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2109  {
2110  pDim->SetCurrentPage( &rPage );
2111  SetDPObject( pDPObj );
2112  }
2113 }
2114 
2115 void ScDataPilotFieldObj::setUseCurrentPage( bool bUse )
2116 {
2117  SolarMutexGuard aGuard;
2118  ScDPObject* pDPObj = nullptr;
2119  ScDPSaveDimension* pDim = GetDPDimension( &pDPObj );
2120  if(!pDim)
2121  return;
2122 
2123  if( bUse )
2124  {
2125  /* It is somehow useless to set the property "HasSelectedPage" to
2126  true, because it is still needed to set an explicit page name. */
2127  const OUString aPage;
2128  pDim->SetCurrentPage( &aPage );
2129  }
2130  else
2131  pDim->SetCurrentPage( nullptr );
2132  SetDPObject( pDPObj );
2133 }
2134 
2135 const DataPilotFieldAutoShowInfo* ScDataPilotFieldObj::getAutoShowInfo() const
2136 {
2137  SolarMutexGuard aGuard;
2138  ScDPSaveDimension* pDim = GetDPDimension();
2139  return pDim ? pDim->GetAutoShowInfo() : nullptr;
2140 }
2141 
2142 void ScDataPilotFieldObj::setAutoShowInfo( const DataPilotFieldAutoShowInfo* pInfo )
2143 {
2144  SolarMutexGuard aGuard;
2145  ScDPObject* pDPObj = nullptr;
2146  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2147  {
2148  pDim->SetAutoShowInfo( pInfo );
2149  SetDPObject( pDPObj );
2150  }
2151 }
2152 
2153 const DataPilotFieldLayoutInfo* ScDataPilotFieldObj::getLayoutInfo() const
2154 {
2155  SolarMutexGuard aGuard;
2156  ScDPSaveDimension* pDim = GetDPDimension();
2157  return pDim ? pDim->GetLayoutInfo() : nullptr;
2158 }
2159 
2160 void ScDataPilotFieldObj::setLayoutInfo( const DataPilotFieldLayoutInfo* pInfo )
2161 {
2162  SolarMutexGuard aGuard;
2163  ScDPObject* pDPObj = nullptr;
2164  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2165  {
2166  pDim->SetLayoutInfo( pInfo );
2167  SetDPObject( pDPObj );
2168  }
2169 }
2170 
2171 const DataPilotFieldReference* ScDataPilotFieldObj::getReference() const
2172 {
2173  SolarMutexGuard aGuard;
2174  ScDPSaveDimension* pDim = GetDPDimension();
2175  return pDim ? pDim->GetReferenceValue() : nullptr;
2176 }
2177 
2178 void ScDataPilotFieldObj::setReference( const DataPilotFieldReference* pInfo )
2179 {
2180  SolarMutexGuard aGuard;
2181  ScDPObject* pDPObj = nullptr;
2182  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2183  {
2184  pDim->SetReferenceValue( pInfo );
2185  SetDPObject( pDPObj );
2186  }
2187 }
2188 
2189 const DataPilotFieldSortInfo* ScDataPilotFieldObj::getSortInfo() const
2190 {
2191  SolarMutexGuard aGuard;
2192  ScDPSaveDimension* pDim = GetDPDimension();
2193  return pDim ? pDim->GetSortInfo() : nullptr;
2194 }
2195 
2196 void ScDataPilotFieldObj::setSortInfo( const DataPilotFieldSortInfo* pInfo )
2197 {
2198  SolarMutexGuard aGuard;
2199  ScDPObject* pDPObj = nullptr;
2200  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2201  {
2202  pDim->SetSortInfo( pInfo );
2203  SetDPObject( pDPObj );
2204  }
2205 }
2206 
2207 bool ScDataPilotFieldObj::getShowEmpty() const
2208 {
2209  SolarMutexGuard aGuard;
2210  ScDPSaveDimension* pDim = GetDPDimension();
2211  return pDim && pDim->GetShowEmpty();
2212 }
2213 
2214 void ScDataPilotFieldObj::setShowEmpty( bool bShow )
2215 {
2216  SolarMutexGuard aGuard;
2217  ScDPObject* pDPObj = nullptr;
2218  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2219  {
2220  pDim->SetShowEmpty( bShow );
2221  SetDPObject( pDPObj );
2222  }
2223 }
2224 
2225 bool ScDataPilotFieldObj::getRepeatItemLabels() const
2226 {
2227  SolarMutexGuard aGuard;
2228  ScDPSaveDimension* pDim = GetDPDimension();
2229  return pDim && pDim->GetRepeatItemLabels();
2230 }
2231 
2232 void ScDataPilotFieldObj::setRepeatItemLabels( bool bShow )
2233 {
2234  SolarMutexGuard aGuard;
2235  ScDPObject* pDPObj = nullptr;
2236  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2237  {
2238  pDim->SetRepeatItemLabels( bShow );
2239  SetDPObject( pDPObj );
2240  }
2241 }
2242 
2243 bool ScDataPilotFieldObj::hasGroupInfo() const
2244 {
2245  SolarMutexGuard aGuard;
2246  ScDPObject* pDPObj = nullptr;
2247  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2248  if( const ScDPDimensionSaveData* pDimData = pDPObj->GetSaveData()->GetExistingDimensionData() )
2249  return pDimData->GetNamedGroupDim( pDim->GetName() ) || pDimData->GetNumGroupDim( pDim->GetName() );
2250  return false;
2251 }
2252 
2253 DataPilotFieldGroupInfo ScDataPilotFieldObj::getGroupInfo()
2254 {
2255  SolarMutexGuard aGuard;
2256  DataPilotFieldGroupInfo aInfo;
2257  ScDPObject* pDPObj = nullptr;
2258  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2259  {
2260  if( const ScDPDimensionSaveData* pDimData = pDPObj->GetSaveData()->GetExistingDimensionData() )
2261  {
2262  if( const ScDPSaveGroupDimension* pGroupDim = pDimData->GetNamedGroupDim( pDim->GetName() ) )
2263  {
2264  // grouped by ...
2265  aInfo.GroupBy = pGroupDim->GetDatePart();
2266 
2267  // find source field
2268  try
2269  {
2270  Reference< XNameAccess > xFields( mxParent->getDataPilotFields(), UNO_QUERY_THROW );
2271  aInfo.SourceField.set( xFields->getByName( pGroupDim->GetSourceDimName() ), UNO_QUERY );
2272  }
2273  catch( Exception& )
2274  {
2275  }
2276 
2277  ScDataPilotConversion::FillGroupInfo( aInfo, pGroupDim->GetDateInfo() );
2278  if( pGroupDim->GetDatePart() == 0 )
2279  {
2280  // fill vector of group and group member information
2281  ScFieldGroups aGroups;
2282  for( sal_Int32 nIdx = 0, nCount = pGroupDim->GetGroupCount(); nIdx < nCount; ++nIdx )
2283  {
2284  const ScDPSaveGroupItem& rGroup = pGroupDim->GetGroupByIndex( nIdx );
2285  ScFieldGroup aGroup;
2286  aGroup.maName = rGroup.GetGroupName();
2287  for( sal_Int32 nMemIdx = 0, nMemCount = rGroup.GetElementCount(); nMemIdx < nMemCount; ++nMemIdx )
2288  if (const OUString* pMem = rGroup.GetElementByIndex(nMemIdx))
2289  aGroup.maMembers.push_back( *pMem );
2290  aGroups.push_back( aGroup );
2291  }
2292  aInfo.Groups = new ScDataPilotFieldGroupsObj( aGroups );
2293  }
2294  }
2295  else if( const ScDPSaveNumGroupDimension* pNumGroupDim = pDimData->GetNumGroupDim( pDim->GetName() ) )
2296  {
2297  if (pNumGroupDim->GetDatePart())
2298  {
2299  ScDataPilotConversion::FillGroupInfo( aInfo, pNumGroupDim->GetDateInfo() );
2300  aInfo.GroupBy = pNumGroupDim->GetDatePart();
2301  }
2302  else
2303  {
2304  ScDataPilotConversion::FillGroupInfo( aInfo, pNumGroupDim->GetInfo() );
2305  }
2306  }
2307  }
2308  }
2309  return aInfo;
2310 }
2311 
2312 void ScDataPilotFieldObj::setGroupInfo( const DataPilotFieldGroupInfo* pInfo )
2313 {
2314  SolarMutexGuard aGuard;
2315  ScDPObject* pDPObj = nullptr;
2316  if( /*ScDPSaveDimension* pDim =*/ !GetDPDimension( &pDPObj ) )
2317  return;
2318 
2319  ScDPSaveData* pSaveData = pDPObj->GetSaveData();
2320  if( pInfo && lclCheckMinMaxStep( *pInfo ) )
2321  {
2322  ScDPNumGroupInfo aInfo;
2323  aInfo.mbEnable = true;
2324  aInfo.mbDateValues = pInfo->HasDateValues;
2325  aInfo.mbAutoStart = pInfo->HasAutoStart;
2326  aInfo.mbAutoEnd = pInfo->HasAutoEnd;
2327  aInfo.mfStart = pInfo->Start;
2328  aInfo.mfEnd = pInfo->End;
2329  aInfo.mfStep = pInfo->Step;
2330  Reference< XNamed > xNamed( pInfo->SourceField, UNO_QUERY );
2331  if( xNamed.is() )
2332  {
2333  ScDPSaveGroupDimension aGroupDim( xNamed->getName(), getName() );
2334  if( pInfo->GroupBy )
2335  aGroupDim.SetDateInfo(aInfo, pInfo->GroupBy);
2336  else
2337  {
2338  Reference<XIndexAccess> xIndex(pInfo->Groups, UNO_QUERY);
2339  if (xIndex.is())
2340  {
2341  sal_Int32 nCount(xIndex->getCount());
2342  for(sal_Int32 i = 0; i < nCount; i++)
2343  {
2344  Reference<XNamed> xGroupNamed(xIndex->getByIndex(i), UNO_QUERY);
2345  if (xGroupNamed.is())
2346  {
2347  ScDPSaveGroupItem aItem(xGroupNamed->getName());
2348  Reference<XIndexAccess> xGroupIndex(xGroupNamed, UNO_QUERY);
2349  if (xGroupIndex.is())
2350  {
2351  sal_Int32 nItemCount(xGroupIndex->getCount());
2352  for (sal_Int32 j = 0; j < nItemCount; ++j)
2353  {
2354  Reference<XNamed> xItemNamed(xGroupIndex->getByIndex(j), UNO_QUERY);
2355  if (xItemNamed.is())
2356  aItem.AddElement(xItemNamed->getName());
2357  }
2358  }
2359  aGroupDim.AddGroupItem(aItem);
2360  }
2361  }
2362  }
2363  }
2364 
2365  // get dimension savedata or create new if none
2366  ScDPDimensionSaveData& rDimSaveData = *pSaveData->GetDimensionData();
2367  rDimSaveData.ReplaceGroupDimension( aGroupDim );
2368  }
2369  else // no source field in group info -> numeric group
2370  {
2371  ScDPDimensionSaveData* pDimData = pSaveData->GetDimensionData(); // created if not there
2372 
2373  ScDPSaveNumGroupDimension* pExisting = pDimData->GetNumGroupDimAcc( getName() );
2374  if ( pExisting )
2375  {
2376  if (pInfo->GroupBy)
2377  pExisting->SetDateInfo(aInfo, pInfo->GroupBy);
2378  // modify existing group dimension
2379  pExisting->SetGroupInfo( aInfo );
2380  }
2381  else if (pInfo->GroupBy)
2382  {
2383  // create new group dimension
2384  ScDPSaveNumGroupDimension aNumGroupDim( getName(), aInfo, pInfo->GroupBy );
2385  pDimData->AddNumGroupDimension( aNumGroupDim );
2386  }
2387  else
2388  {
2389  // create new group dimension
2390  ScDPSaveNumGroupDimension aNumGroupDim( getName(), aInfo );
2391  pDimData->AddNumGroupDimension( aNumGroupDim );
2392  }
2393  }
2394  }
2395  else // null passed as argument
2396  {
2397  pSaveData->SetDimensionData( nullptr );
2398  }
2399 
2400  pDPObj->SetSaveData( *pSaveData );
2401  SetDPObject( pDPObj );
2402 }
2403 
2404 // XDataPilotFieldGrouping
2405 Reference< XDataPilotField > SAL_CALL ScDataPilotFieldObj::createNameGroup( const Sequence< OUString >& rItems )
2406 {
2407  SolarMutexGuard aGuard;
2408 
2409  if( !rItems.hasElements() )
2410  throw IllegalArgumentException("rItems is empty", static_cast<cppu::OWeakObject*>(this), 0);
2411 
2412  Reference< XMembersAccess > xMembers = GetMembers();
2413  if (!xMembers.is())
2414  {
2415  SAL_WARN("sc.ui", "Cannot access members of the field object.");
2416  throw RuntimeException("Cannot access members of the field object", static_cast<cppu::OWeakObject*>(this));
2417  }
2418 
2419  for (const OUString& aEntryName : rItems)
2420  {
2421  if (!xMembers->hasByName(aEntryName))
2422  {
2423  SAL_WARN("sc.ui", "There is no member with that name: " + aEntryName + ".");
2424  throw IllegalArgumentException("There is no member with name \"" + aEntryName + "\"", static_cast<cppu::OWeakObject*>(this), 0);
2425  }
2426  }
2427 
2428  Reference< XDataPilotField > xRet;
2429  OUString sNewDim;
2430  ScDPObject* pDPObj = nullptr;
2431  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2432  {
2433  const OUString& aDimName = pDim->GetName();
2434 
2435  ScDPSaveData aSaveData = *pDPObj->GetSaveData();
2436  ScDPDimensionSaveData* pDimData = aSaveData.GetDimensionData(); // created if not there
2437 
2438  // find original base
2439  OUString aBaseDimName( aDimName );
2440  const ScDPSaveGroupDimension* pBaseGroupDim = pDimData->GetNamedGroupDim( aDimName );
2441  if ( pBaseGroupDim )
2442  {
2443  // any entry's SourceDimName is the original base
2444  aBaseDimName = pBaseGroupDim->GetSourceDimName();
2445  }
2446 
2447  // find existing group dimension
2448  // (using the selected dim, can be intermediate group dim)
2449  ScDPSaveGroupDimension* pGroupDimension = pDimData->GetGroupDimAccForBase( aDimName );
2450 
2451  // remove the selected items from their groups
2452  // (empty groups are removed, too)
2453  if ( pGroupDimension )
2454  {
2455  for (const OUString& aEntryName : rItems)
2456  {
2457  if ( pBaseGroupDim )
2458  {
2459  // for each selected (intermediate) group, remove all its items
2460  // (same logic as for adding, below)
2461  const ScDPSaveGroupItem* pBaseGroup = pBaseGroupDim->GetNamedGroup( aEntryName );
2462  if ( pBaseGroup )
2463  pBaseGroup->RemoveElementsFromGroups( *pGroupDimension ); // remove all elements
2464  else
2465  pGroupDimension->RemoveFromGroups( aEntryName );
2466  }
2467  else
2468  pGroupDimension->RemoveFromGroups( aEntryName );
2469  }
2470  }
2471 
2472  std::unique_ptr<ScDPSaveGroupDimension> pNewGroupDim;
2473  if ( !pGroupDimension )
2474  {
2475  // create a new group dimension
2476  sNewDim = pDimData->CreateGroupDimName( aBaseDimName, *pDPObj, false, nullptr );
2477  pNewGroupDim.reset(new ScDPSaveGroupDimension( aBaseDimName, sNewDim ));
2478 
2479  pGroupDimension = pNewGroupDim.get(); // make changes to the new dim if none existed
2480 
2481  if ( pBaseGroupDim )
2482  {
2483  // If it's a higher-order group dimension, pre-allocate groups for all
2484  // non-selected original groups, so the individual base members aren't
2485  // used for automatic groups (this would make the original groups hard
2486  // to find).
2489 
2490  tools::Long nGroupCount = pBaseGroupDim->GetGroupCount();
2491  for ( tools::Long nGroup = 0; nGroup < nGroupCount; nGroup++ )
2492  {
2493  const ScDPSaveGroupItem& rBaseGroup = pBaseGroupDim->GetGroupByIndex( nGroup );
2494 
2495  if (comphelper::findValue(rItems, rBaseGroup.GetGroupName()) == -1)
2496  {
2497  // add an additional group for each item that is not in the selection
2498  ScDPSaveGroupItem aGroup( rBaseGroup.GetGroupName() );
2499  aGroup.AddElementsFromGroup( rBaseGroup );
2500  pGroupDimension->AddGroupItem( aGroup );
2501  }
2502  }
2503  }
2504  }
2505  OUString aGroupDimName = pGroupDimension->GetGroupDimName();
2506 
2507  OUString aGroupName = pGroupDimension->CreateGroupName( ScResId(STR_PIVOT_GROUP) );
2508  ScDPSaveGroupItem aGroup( aGroupName );
2509  for (const OUString& aEntryName : rItems)
2510  {
2511  if ( pBaseGroupDim )
2512  {
2513  // for each selected (intermediate) group, add all its items
2514  const ScDPSaveGroupItem* pBaseGroup = pBaseGroupDim->GetNamedGroup( aEntryName );
2515  if ( pBaseGroup )
2516  aGroup.AddElementsFromGroup( *pBaseGroup );
2517  else
2518  aGroup.AddElement( aEntryName ); // no group found -> automatic group, add the item itself
2519  }
2520  else
2521  aGroup.AddElement( aEntryName ); // no group dimension, add all items directly
2522  }
2523 
2524  pGroupDimension->AddGroupItem( aGroup );
2525 
2526  if ( pNewGroupDim )
2527  {
2528  pDimData->AddGroupDimension( *pNewGroupDim );
2529  pNewGroupDim.reset(); // AddGroupDimension copies the object
2530  // don't access pGroupDimension after here
2531  }
2532  pGroupDimension = nullptr;
2533 
2534  // set orientation
2535  ScDPSaveDimension* pSaveDimension = aSaveData.GetDimensionByName( aGroupDimName );
2536  if ( pSaveDimension->GetOrientation() == DataPilotFieldOrientation_HIDDEN )
2537  {
2538  ScDPSaveDimension* pOldDimension = aSaveData.GetDimensionByName( aDimName );
2539  pSaveDimension->SetOrientation( pOldDimension->GetOrientation() );
2540  aSaveData.SetPosition( pSaveDimension, 0 );
2541  }
2542 
2543  // apply changes
2544  pDPObj->SetSaveData( aSaveData );
2545  ScDBDocFunc(*GetDocShell()).RefreshPivotTableGroups(pDPObj);
2546  }
2547 
2548  // if new grouping field has been created (on first group), return it
2549  if( !sNewDim.isEmpty() )
2550  {
2551  Reference< XNameAccess > xFields(mxParent->getDataPilotFields(), UNO_QUERY);
2552  if (xFields.is())
2553  {
2554  try
2555  {
2556  xRet.set(xFields->getByName(sNewDim), UNO_QUERY);
2557  SAL_WARN_IF(!xRet.is(), "sc.ui", "there is a name, so there should be also a field");
2558  }
2559  catch (const container::NoSuchElementException&)
2560  {
2561  css::uno::Any anyEx = cppu::getCaughtException();
2562  SAL_WARN("sc.ui", "Cannot find field with that name: " + sNewDim + ".");
2563  // Avoid throwing exception that's not specified in the method signature.
2564  throw css::lang::WrappedTargetRuntimeException(
2565  "Cannot find field with name \"" + sNewDim + "\"",
2566  static_cast<cppu::OWeakObject*>(this), anyEx );
2567  }
2568  }
2569  }
2570  return xRet;
2571 }
2572 
2573 Reference < XDataPilotField > SAL_CALL ScDataPilotFieldObj::createDateGroup( const DataPilotFieldGroupInfo& rInfo )
2574 {
2575  SolarMutexGuard aGuard;
2576  using namespace ::com::sun::star::sheet::DataPilotFieldGroupBy;
2577 
2578  if( !rInfo.HasDateValues )
2579  throw IllegalArgumentException("HasDateValues is not set", static_cast<cppu::OWeakObject*>(this), 0);
2580  if( !lclCheckMinMaxStep( rInfo ) )
2581  throw IllegalArgumentException("min/max/step", static_cast<cppu::OWeakObject*>(this), 0);
2582 
2583  // only a single date flag is allowed
2584  if( (rInfo.GroupBy == 0) || (rInfo.GroupBy > YEARS) || ((rInfo.GroupBy & (rInfo.GroupBy - 1)) != 0) )
2585  throw IllegalArgumentException("Invalid GroupBy value: " + OUString::number(rInfo.GroupBy), static_cast<cppu::OWeakObject*>(this), 0);
2586 
2587  // step must be zero, if something else than DAYS is specified
2588  if( rInfo.Step >= ((rInfo.GroupBy == DAYS) ? 32768.0 : 1.0) )
2589  throw IllegalArgumentException("Invalid step value: " + OUString::number(rInfo.Step), static_cast<cppu::OWeakObject*>(this), 0);
2590 
2591  OUString aGroupDimName;
2592  ScDPObject* pDPObj = nullptr;
2593  if( ScDPSaveDimension* pDim = GetDPDimension( &pDPObj ) )
2594  {
2595  ScDPNumGroupInfo aInfo;
2596  aInfo.mbEnable = true;
2597  aInfo.mbDateValues = (rInfo.GroupBy == DAYS) && (rInfo.Step >= 1.0);
2598  aInfo.mbAutoStart = rInfo.HasAutoStart;
2599  aInfo.mbAutoEnd = rInfo.HasAutoEnd;
2600  aInfo.mfStart = rInfo.Start;
2601  aInfo.mfEnd = rInfo.End;
2602  aInfo.mfStep = std::trunc( rInfo.Step );
2603 
2604  // create a local copy of the entire save data (will be written back below)
2605  ScDPSaveData aSaveData = *pDPObj->GetSaveData();
2606  // get or create dimension save data
2607  ScDPDimensionSaveData& rDimData = *aSaveData.GetDimensionData();
2608 
2609  // find source dimension name
2610  const OUString& rDimName = pDim->GetName();
2611  const ScDPSaveGroupDimension* pGroupDim = rDimData.GetNamedGroupDim( rDimName );
2612  OUString aSrcDimName = pGroupDim ? pGroupDim->GetSourceDimName() : rDimName;
2613 
2614  // find a group dimension for the base field, or get numeric grouping
2615  pGroupDim = rDimData.GetFirstNamedGroupDim( aSrcDimName );
2616  const ScDPSaveNumGroupDimension* pNumGroupDim = rDimData.GetNumGroupDim( aSrcDimName );
2617 
2618  // do not group by dates, if named groups or numeric grouping is present
2619  bool bHasNamedGrouping = pGroupDim && !pGroupDim->GetDateInfo().mbEnable;
2620  bool bHasNumGrouping = pNumGroupDim && pNumGroupDim->GetInfo().mbEnable && !pNumGroupDim->GetInfo().mbDateValues && !pNumGroupDim->GetDateInfo().mbEnable;
2621  if( bHasNamedGrouping || bHasNumGrouping )
2622  throw IllegalArgumentException();
2623 
2624  if( aInfo.mbDateValues ) // create day ranges grouping
2625  {
2626  // first remove all named group dimensions
2627  while( pGroupDim )
2628  {
2629  OUString aGroupDimName2 = pGroupDim->GetGroupDimName();
2630  // find next group dimension before deleting this group
2631  pGroupDim = rDimData.GetNextNamedGroupDim( aGroupDimName2 );
2632  // remove from dimension save data
2633  rDimData.RemoveGroupDimension( aGroupDimName2 );
2634  // also remove save data settings for the dimension that no longer exists
2635  aSaveData.RemoveDimensionByName( aGroupDimName2 );
2636  }
2637  // create or replace the number grouping dimension
2638  ScDPSaveNumGroupDimension aNumGroupDim( aSrcDimName, aInfo );
2639  rDimData.ReplaceNumGroupDimension( aNumGroupDim );
2640  }
2641  else // create date grouping
2642  {
2643  // collect all existing date flags
2644  sal_Int32 nDateParts = rDimData.CollectDateParts( aSrcDimName );
2645  if( nDateParts == 0 )
2646  {
2647  // insert numeric group dimension, if no date groups exist yet (or replace day range grouping)
2648  ScDPSaveNumGroupDimension aNumGroupDim( aSrcDimName, aInfo, rInfo.GroupBy );
2649  rDimData.ReplaceNumGroupDimension( aNumGroupDim );
2650  }
2651  else if( (nDateParts & rInfo.GroupBy) == 0 ) // do nothing if date field exists already
2652  {
2653  // create new named group dimension for additional date groups
2654  aGroupDimName = rDimData.CreateDateGroupDimName( rInfo.GroupBy, *pDPObj, true, nullptr );
2655  ScDPSaveGroupDimension aGroupDim( aSrcDimName, aGroupDimName, aInfo, rInfo.GroupBy );
2656  rDimData.AddGroupDimension( aGroupDim );
2657 
2658  // set orientation of new named group dimension
2659  ScDPSaveDimension& rSaveDim = *aSaveData.GetDimensionByName( aGroupDimName );
2660  if( rSaveDim.GetOrientation() == DataPilotFieldOrientation_HIDDEN )
2661  {
2662  ScDPSaveDimension& rOldDim = *aSaveData.GetDimensionByName( aSrcDimName );
2663  rSaveDim.SetOrientation( rOldDim.GetOrientation() );
2664  aSaveData.SetPosition( &rSaveDim, 0 );
2665  }
2666  }
2667  }
2668 
2669  // apply changes
2670  pDPObj->SetSaveData( aSaveData );
2671  ScDBDocFunc(*GetDocShell()).RefreshPivotTableGroups(pDPObj);
2672  }
2673 
2674  // return the UNO object of the new dimension, after writing back saved data
2675  Reference< XDataPilotField > xRet;
2676  if( !aGroupDimName.isEmpty() )
2677  try
2678  {
2679  Reference< XNameAccess > xFields( mxParent->getDataPilotFields(), UNO_QUERY_THROW );
2680  xRet.set( xFields->getByName( aGroupDimName ), UNO_QUERY );
2681  }
2682  catch( Exception& )
2683  {
2684  }
2685  return xRet;
2686 }
2687 
2688 namespace {
2689 
2690 bool lclExtractGroupMembers( ScFieldGroupMembers& rMembers, const Any& rElement )
2691 {
2692  // allow empty value to create a new group
2693  if( !rElement.hasValue() )
2694  return true;
2695 
2696  // try to extract a simple sequence of strings
2697  Sequence< OUString > aSeq;
2698  if( rElement >>= aSeq )
2699  {
2700  if( aSeq.hasElements() )
2701  rMembers.insert( rMembers.end(), aSeq.begin(), aSeq.end() );
2702  return true;
2703  }
2704 
2705  // try to use XIndexAccess providing objects that support XNamed
2706  Reference< XIndexAccess > xItemsIA( rElement, UNO_QUERY );
2707  if( xItemsIA.is() )
2708  {
2709  for( sal_Int32 nIdx = 0, nCount = xItemsIA->getCount(); nIdx < nCount; ++nIdx )
2710  {
2711  try // getByIndex() should not throw, but we cannot be sure
2712  {
2713  Reference< XNamed > xItemName( xItemsIA->getByIndex( nIdx ), UNO_QUERY_THROW );
2714  rMembers.push_back( xItemName->getName() );
2715  }
2716  catch( Exception& )
2717  {
2718  // ignore exceptions, go ahead with next element in the array
2719  }
2720  }
2721  return true;
2722  }
2723 
2724  // nothing valid inside the Any -> return false
2725  return false;
2726 }
2727 
2728 } // namespace
2729 
2730 ScDataPilotFieldGroupsObj::ScDataPilotFieldGroupsObj( const ScFieldGroups& rGroups ) :
2731  maGroups( rGroups )
2732 {
2733 }
2734 
2735 ScDataPilotFieldGroupsObj::~ScDataPilotFieldGroupsObj()
2736 {
2737 }
2738 
2739 // XNameAccess
2740 
2741 Any SAL_CALL ScDataPilotFieldGroupsObj::getByName( const OUString& rName )
2742 {
2743  SolarMutexGuard aGuard;
2744  if( implFindByName( rName ) == maGroups.end() )
2745  throw NoSuchElementException();
2746  return Any( Reference< XNameAccess >( new ScDataPilotFieldGroupObj( *this, rName ) ) );
2747 }
2748 
2749 Sequence< OUString > SAL_CALL ScDataPilotFieldGroupsObj::getElementNames()
2750 {
2751  SolarMutexGuard aGuard;
2752  Sequence< OUString > aSeq;
2753  if( !maGroups.empty() )
2754  {
2755  aSeq.realloc( static_cast< sal_Int32 >( maGroups.size() ) );
2756  OUString* pName = aSeq.getArray();
2757  for( const auto& rGroup : maGroups )
2758  {
2759  *pName = rGroup.maName;
2760  ++pName;
2761  }
2762  }
2763  return aSeq;
2764 }
2765 
2766 sal_Bool SAL_CALL ScDataPilotFieldGroupsObj::hasByName( const OUString& rName )
2767 {
2768  SolarMutexGuard aGuard;
2769  return implFindByName( rName ) != maGroups.end();
2770 }
2771 
2772 // XNameReplace
2773 
2774 void SAL_CALL ScDataPilotFieldGroupsObj::replaceByName( const OUString& rName, const Any& rElement )
2775 {
2776  SolarMutexGuard aGuard;
2777 
2778  if( rName.isEmpty() )
2779  throw IllegalArgumentException("Name is empty", static_cast<cppu::OWeakObject*>(this), 0);
2780 
2781  ScFieldGroups::iterator aIt = implFindByName( rName );
2782  if( aIt == maGroups.end() )
2783  throw NoSuchElementException("Name \"" + rName + "\" not found", static_cast<cppu::OWeakObject*>(this));
2784 
2785  // read all item names provided by the passed object
2786  ScFieldGroupMembers aMembers;
2787  if( !lclExtractGroupMembers( aMembers, rElement ) )
2788  throw IllegalArgumentException("Invalid element object", static_cast<cppu::OWeakObject*>(this), 0);
2789 
2790  // copy and forget, faster than vector assignment
2791  aIt->maMembers.swap( aMembers );
2792 }
2793 
2794 // XNameContainer
2795 
2796 void SAL_CALL ScDataPilotFieldGroupsObj::insertByName( const OUString& rName, const Any& rElement )
2797 {
2798  SolarMutexGuard aGuard;
2799 
2800  if( rName.isEmpty() )
2801  throw IllegalArgumentException("Name is empty", static_cast<cppu::OWeakObject*>(this), 0);
2802 
2803  ScFieldGroups::iterator aIt = implFindByName( rName );
2804  if( aIt != maGroups.end() )
2805  throw ElementExistException("Name \"" + rName + "\" already exists", static_cast<cppu::OWeakObject*>(this));
2806 
2807  // read all item names provided by the passed object
2808  ScFieldGroupMembers aMembers;
2809  if( !lclExtractGroupMembers( aMembers, rElement ) )
2810  throw IllegalArgumentException("Invalid element object", static_cast<cppu::OWeakObject*>(this), 0);
2811 
2812  // create the new entry if no error has been occurred
2813  maGroups.emplace_back();
2814  ScFieldGroup& rGroup = maGroups.back();
2815  rGroup.maName = rName;
2816  rGroup.maMembers.swap( aMembers );
2817 }
2818 
2819 void SAL_CALL ScDataPilotFieldGroupsObj::removeByName( const OUString& rName )
2820 {
2821  SolarMutexGuard aGuard;
2822 
2823  if( rName.isEmpty() )
2824  throw IllegalArgumentException("Name is empty", static_cast<cppu::OWeakObject*>(this), 0);
2825 
2826  ScFieldGroups::iterator aIt = implFindByName( rName );
2827  if( aIt == maGroups.end() )
2828  throw NoSuchElementException("Name \"" + rName + "\" not found", static_cast<cppu::OWeakObject*>(this));
2829 
2830  maGroups.erase( aIt );
2831 }
2832 
2833 // XIndexAccess
2834 
2835 sal_Int32 SAL_CALL ScDataPilotFieldGroupsObj::getCount()
2836 {
2837  SolarMutexGuard aGuard;
2838  return static_cast< sal_Int32 >( maGroups.size() );
2839 }
2840 
2841 Any SAL_CALL ScDataPilotFieldGroupsObj::getByIndex( sal_Int32 nIndex )
2842 {
2843  SolarMutexGuard aGuard;
2844  if ((nIndex < 0) || (nIndex >= static_cast< sal_Int32 >( maGroups.size() )))
2845  throw IndexOutOfBoundsException();
2846  return Any( Reference< XNameAccess >( new ScDataPilotFieldGroupObj( *this, maGroups[ nIndex ].maName ) ) );
2847 }
2848 
2849 // XEnumerationAccess
2850 
2851 Reference<XEnumeration> SAL_CALL ScDataPilotFieldGroupsObj::createEnumeration()
2852 {
2853  SolarMutexGuard aGuard;
2854  return new ScIndexEnumeration( this, "com.sun.star.sheet.DataPilotFieldGroupsEnumeration" );
2855 }
2856 
2857 // XElementAccess
2858 
2859 uno::Type SAL_CALL ScDataPilotFieldGroupsObj::getElementType()
2860 {
2861  SolarMutexGuard aGuard;
2862  return cppu::UnoType<XNameAccess>::get();
2863 }
2864 
2865 sal_Bool SAL_CALL ScDataPilotFieldGroupsObj::hasElements()
2866 {
2867  SolarMutexGuard aGuard;
2868  return !maGroups.empty();
2869 }
2870 
2871 // implementation
2872 
2873 ScFieldGroup& ScDataPilotFieldGroupsObj::getFieldGroup( const OUString& rName )
2874 {
2875  SolarMutexGuard aGuard;
2876  ScFieldGroups::iterator aIt = implFindByName( rName );
2877  if( aIt == maGroups.end() )
2878  throw RuntimeException("Field Group with name \"" + rName + "\" not found", static_cast<cppu::OWeakObject*>(this));
2879  return *aIt;
2880 }
2881 
2882 void ScDataPilotFieldGroupsObj::renameFieldGroup( const OUString& rOldName, const OUString& rNewName )
2883 {
2884  SolarMutexGuard aGuard;
2885  ScFieldGroups::iterator aOldIt = implFindByName( rOldName );
2886  ScFieldGroups::iterator aNewIt = implFindByName( rNewName );
2887  if( aOldIt == maGroups.end() )
2888  throw RuntimeException("Field Group with name \"" + rOldName + "\" not found", static_cast<cppu::OWeakObject*>(this));
2889  // new name must not exist yet
2890  if( (aNewIt != maGroups.end()) && (aNewIt != aOldIt) )
2891  throw RuntimeException("Field Group with name \"" + rOldName + "\" already exists", static_cast<cppu::OWeakObject*>(this));
2892  aOldIt->maName = rNewName;
2893 }
2894 
2895 ScFieldGroups::iterator ScDataPilotFieldGroupsObj::implFindByName( const OUString& rName )
2896 {
2897  return std::find_if(maGroups.begin(), maGroups.end(),
2898  [&rName](const ScFieldGroup& rGroup) { return rGroup.maName == rName; });
2899 }
2900 
2901 namespace {
2902 
2903 OUString lclExtractMember( const Any& rElement )
2904 {
2905  if( rElement.has< OUString >() )
2906  return rElement.get< OUString >();
2907 
2908  Reference< XNamed > xNamed( rElement, UNO_QUERY );
2909  if( xNamed.is() )
2910  return xNamed->getName();
2911 
2912  return OUString();
2913 }
2914 
2915 } // namespace
2916 
2917 ScDataPilotFieldGroupObj::ScDataPilotFieldGroupObj( ScDataPilotFieldGroupsObj& rParent, const OUString& rGroupName ) :
2918  mxParent( &rParent ),
2919  maGroupName( rGroupName )
2920 {
2921 }
2922 
2923 ScDataPilotFieldGroupObj::~ScDataPilotFieldGroupObj()
2924 {
2925 }
2926 
2927 // XNameAccess
2928 
2929 Any SAL_CALL ScDataPilotFieldGroupObj::getByName( const OUString& rName )
2930 {
2931  SolarMutexGuard aGuard;
2932  ScFieldGroupMembers& rMembers = mxParent->getFieldGroup( maGroupName ).maMembers;
2933  ScFieldGroupMembers::iterator aIt = ::std::find( rMembers.begin(), rMembers.end(), rName );
2934  if( aIt == rMembers.end() )
2935  throw NoSuchElementException("Name \"" + rName + "\" not found", static_cast<cppu::OWeakObject*>(this));
2936  return Any( Reference< XNamed >( new ScDataPilotFieldGroupItemObj( *this, *aIt ) ) );
2937 }
2938 
2939 Sequence< OUString > SAL_CALL ScDataPilotFieldGroupObj::getElementNames()
2940 {
2941  SolarMutexGuard aGuard;
2942  return ::comphelper::containerToSequence( mxParent->getFieldGroup( maGroupName ).maMembers );
2943 }
2944 
2945 sal_Bool SAL_CALL ScDataPilotFieldGroupObj::hasByName( const OUString& rName )
2946 {
2947  SolarMutexGuard aGuard;
2948  ScFieldGroupMembers& rMembers = mxParent->getFieldGroup( maGroupName ).maMembers;
2949  return ::std::find( rMembers.begin(), rMembers.end(), rName ) != rMembers.end();
2950 }
2951 
2952 // XNameReplace
2953 
2954 void SAL_CALL ScDataPilotFieldGroupObj::replaceByName( const OUString& rName, const Any& rElement )
2955 {
2956  SolarMutexGuard aGuard;
2957 
2958  // it should be possible to quickly rename an item -> accept string or XNamed
2959  OUString aNewName = lclExtractMember( rElement );
2960  if( rName.isEmpty() || aNewName.isEmpty() )
2961  throw IllegalArgumentException("Name is empty", static_cast<cppu::OWeakObject*>(this), 0);
2962  if( rName == aNewName )
2963  return;
2964 
2965  ScFieldGroupMembers& rMembers = mxParent->getFieldGroup( maGroupName ).maMembers;
2966  ScFieldGroupMembers::iterator aOldIt = ::std::find( rMembers.begin(), rMembers.end(), rName );
2967  ScFieldGroupMembers::iterator aNewIt = ::std::find( rMembers.begin(), rMembers.end(), aNewName );
2968  if( aOldIt == rMembers.end() )
2969  throw NoSuchElementException("Name \"" + rName + "\" not found", static_cast<cppu::OWeakObject*>(this));
2970  if( aNewIt != rMembers.end() )
2971  throw IllegalArgumentException("Name \"" + rName + "\" already exists", static_cast<cppu::OWeakObject*>(this), 0);
2972  *aOldIt = aNewName;
2973 }
2974 
2975 // XNameContainer
2976 
2977 void SAL_CALL ScDataPilotFieldGroupObj::insertByName( const OUString& rName, const Any& /*rElement*/ )
2978 {
2979  SolarMutexGuard aGuard;
2980 
2981  // we will ignore the passed element and just try to insert the name
2982  if( rName.isEmpty() )
2983  throw IllegalArgumentException("Name is empty", static_cast<cppu::OWeakObject*>(this), 0);
2984 
2985  ScFieldGroupMembers& rMembers = mxParent->getFieldGroup( maGroupName ).maMembers;
2986  ScFieldGroupMembers::iterator aIt = ::std::find( rMembers.begin(), rMembers.end(), rName );
2987  if( aIt != rMembers.end() )
2988  throw IllegalArgumentException("Name \"" + rName + "\" already exists", static_cast<cppu::OWeakObject*>(this), 0);
2989  rMembers.push_back( rName );
2990 }
2991 
2992 void SAL_CALL ScDataPilotFieldGroupObj::removeByName( const OUString& rName )
2993 {
2994  SolarMutexGuard aGuard;
2995 
2996  if( rName.isEmpty() )
2997  throw IllegalArgumentException("Name is empty", static_cast<cppu::OWeakObject*>(this), 0);
2998  ScFieldGroupMembers& rMembers = mxParent->getFieldGroup( maGroupName ).maMembers;
2999  ScFieldGroupMembers::iterator aIt = ::std::find( rMembers.begin(), rMembers.end(), rName );
3000  if( aIt == rMembers.end() )
3001  throw NoSuchElementException("Name \"" + rName + "\" not found", static_cast<cppu::OWeakObject*>(this));
3002  rMembers.erase( aIt );
3003 }
3004 
3005 // XIndexAccess
3006 
3007 sal_Int32 SAL_CALL ScDataPilotFieldGroupObj::getCount()
3008 {
3009  SolarMutexGuard aGuard;
3010  return static_cast< sal_Int32 >( mxParent->getFieldGroup( maGroupName ).maMembers.size() );
3011 }
3012 
3013 Any SAL_CALL ScDataPilotFieldGroupObj::getByIndex( sal_Int32 nIndex )
3014 {
3015  SolarMutexGuard aGuard;
3016  ScFieldGroupMembers& rMembers = mxParent->getFieldGroup( maGroupName ).maMembers;
3017  if ((nIndex < 0) || (nIndex >= static_cast< sal_Int32 >( rMembers.size() )))
3018  throw IndexOutOfBoundsException();
3019  return Any( Reference< XNamed >( new ScDataPilotFieldGroupItemObj( *this, rMembers[ nIndex ] ) ) );
3020 }
3021 
3022 // XEnumerationAccess
3023 
3024 Reference< XEnumeration > SAL_CALL ScDataPilotFieldGroupObj::createEnumeration()
3025 {
3026  SolarMutexGuard aGuard;
3027  return new ScIndexEnumeration( this, "com.sun.star.sheet.DataPilotFieldGroupEnumeration" );
3028 }
3029 
3030 // XElementAccess
3031 
3032 uno::Type SAL_CALL ScDataPilotFieldGroupObj::getElementType()
3033 {
3034  SolarMutexGuard aGuard;
3035  return cppu::UnoType<XNamed>::get();
3036 }
3037 
3038 sal_Bool SAL_CALL ScDataPilotFieldGroupObj::hasElements()
3039 {
3040  SolarMutexGuard aGuard;
3041  return !mxParent->getFieldGroup( maGroupName ).maMembers.empty();
3042 }
3043 
3044 // XNamed
3045 
3046 OUString SAL_CALL ScDataPilotFieldGroupObj::getName()
3047 {
3048  SolarMutexGuard aGuard;
3049  return maGroupName;
3050 }
3051 
3052 void SAL_CALL ScDataPilotFieldGroupObj::setName( const OUString& rName )
3053 {
3054  SolarMutexGuard aGuard;
3055  mxParent->renameFieldGroup( maGroupName, rName );
3056  // if call to renameFieldGroup() did not throw, remember the new name
3057  maGroupName = rName;
3058 }
3059 
3060 ScDataPilotFieldGroupItemObj::ScDataPilotFieldGroupItemObj( ScDataPilotFieldGroupObj& rParent, const OUString& rName ) :
3061  mxParent( &rParent ),
3062  maName( rName )
3063 {
3064 }
3065 
3066 ScDataPilotFieldGroupItemObj::~ScDataPilotFieldGroupItemObj()
3067 {
3068 }
3069 
3070 // XNamed
3071 
3072 OUString SAL_CALL ScDataPilotFieldGroupItemObj::getName()
3073 {
3074  SolarMutexGuard aGuard;
3075  return maName;
3076 }
3077 
3078 void SAL_CALL ScDataPilotFieldGroupItemObj::setName( const OUString& rName )
3079 {
3080  SolarMutexGuard aGuard;
3081  mxParent->replaceByName( maName, Any( rName ) );
3082  // if call to replaceByName() did not throw, remember the new name
3083  maName = rName;
3084 }
3085 
3086 ScDataPilotItemsObj::ScDataPilotItemsObj( ScDataPilotDescriptorBase& rParent, const ScFieldIdentifier& rFieldId ) :
3087  ScDataPilotChildObjBase( rParent, rFieldId )
3088 {
3089 }
3090 
3091 ScDataPilotItemsObj::~ScDataPilotItemsObj()
3092 {
3093 }
3094 
3095 // XDataPilotItems
3096 
3097 ScDataPilotItemObj* ScDataPilotItemsObj::GetObjectByIndex_Impl( sal_Int32 nIndex ) const
3098 {
3099  return ((0 <= nIndex) && (nIndex < GetMemberCount())) ?
3100  new ScDataPilotItemObj( *mxParent, maFieldId, nIndex ) : nullptr;
3101 }
3102 
3103 // XNameAccess
3104 
3105 Any SAL_CALL ScDataPilotItemsObj::getByName( const OUString& aName )
3106 {
3107  SolarMutexGuard aGuard;
3108  Reference<XNameAccess> xMembers = GetMembers();
3109  if (xMembers.is())
3110  {
3111  Reference<XIndexAccess> xMembersIndex(new ScNameToIndexAccess( xMembers ));
3112  sal_Int32 nCount = xMembersIndex->getCount();
3113  sal_Int32 nItem = 0;
3114  while (nItem < nCount)
3115  {
3116  Reference<XNamed> xMember(xMembersIndex->getByIndex(nItem), UNO_QUERY);
3117  if (xMember.is() && (aName == xMember->getName()))
3118  {
3119  return Any( Reference< XPropertySet >( GetObjectByIndex_Impl( nItem ) ) );
3120  }
3121  ++nItem;
3122  }
3123  throw NoSuchElementException("Name \"" + aName + "\" not found", static_cast<cppu::OWeakObject*>(this));
3124  }
3125  return Any();
3126 }
3127 
3128 Sequence<OUString> SAL_CALL ScDataPilotItemsObj::getElementNames()
3129 {
3130  SolarMutexGuard aGuard;
3131  Sequence< OUString > aSeq;
3132  if( ScDPObject* pDPObj = GetDPObject() )
3133  pDPObj->GetMemberNames( lcl_GetObjectIndex( pDPObj, maFieldId ), aSeq );
3134  return aSeq;
3135 }
3136 
3137 sal_Bool SAL_CALL ScDataPilotItemsObj::hasByName( const OUString& aName )
3138 {
3139  SolarMutexGuard aGuard;
3140  bool bFound = false;
3141  Reference<XNameAccess> xMembers = GetMembers();
3142  if (xMembers.is())
3143  {
3144  Reference<XIndexAccess> xMembersIndex(new ScNameToIndexAccess( xMembers ));
3145  sal_Int32 nCount = xMembersIndex->getCount();
3146  sal_Int32 nItem = 0;
3147  while (nItem < nCount && !bFound )
3148  {
3149  Reference<XNamed> xMember(xMembersIndex->getByIndex(nItem), UNO_QUERY);
3150  if (xMember.is() && aName == xMember->getName())
3151  bFound = true;
3152  else
3153  nItem++;
3154  }
3155  }
3156  return bFound;
3157 }
3158 
3159 // XEnumerationAccess
3160 
3161 Reference<XEnumeration> SAL_CALL ScDataPilotItemsObj::createEnumeration()
3162 {
3163  SolarMutexGuard aGuard;
3164  return new ScIndexEnumeration(this, "com.sun.star.sheet.DataPilotItemsEnumeration");
3165 }
3166 
3167 // XIndexAccess
3168 
3169 sal_Int32 SAL_CALL ScDataPilotItemsObj::getCount()
3170 {
3171  SolarMutexGuard aGuard;
3172  return GetMemberCount();
3173 }
3174 
3175 Any SAL_CALL ScDataPilotItemsObj::getByIndex( sal_Int32 nIndex )
3176 {
3177  SolarMutexGuard aGuard;
3178  Reference< XPropertySet > xItem( GetObjectByIndex_Impl( nIndex ) );
3179  if (!xItem.is())
3180  throw IndexOutOfBoundsException();
3181  return Any( xItem );
3182 }
3183 
3184 uno::Type SAL_CALL ScDataPilotItemsObj::getElementType()
3185 {
3186  SolarMutexGuard aGuard;
3187  return cppu::UnoType<XPropertySet>::get();
3188 }
3189 
3190 sal_Bool SAL_CALL ScDataPilotItemsObj::hasElements()
3191 {
3192  SolarMutexGuard aGuard;
3193  return ( getCount() != 0 );
3194 }
3195 
3196 ScDataPilotItemObj::ScDataPilotItemObj( ScDataPilotDescriptorBase& rParent, const ScFieldIdentifier& rFieldId, sal_Int32 nIndex ) :
3197  ScDataPilotChildObjBase( rParent, rFieldId ),
3198  maPropSet( lcl_GetDataPilotItemMap() ),
3199  mnIndex( nIndex )
3200 {
3201 }
3202 
3203 ScDataPilotItemObj::~ScDataPilotItemObj()
3204 {
3205 }
3206 
3207  // XNamed
3208 OUString SAL_CALL ScDataPilotItemObj::getName()
3209 {
3210  SolarMutexGuard aGuard;
3211  OUString sRet;
3212  Reference<XNameAccess> xMembers = GetMembers();
3213  if (xMembers.is())
3214  {
3215  Reference<XIndexAccess> xMembersIndex(new ScNameToIndexAccess( xMembers ));
3216  sal_Int32 nCount = xMembersIndex->getCount();
3217  if (mnIndex < nCount)
3218  {
3219  Reference<XNamed> xMember(xMembersIndex->getByIndex(mnIndex), UNO_QUERY);
3220  sRet = xMember->getName();
3221  }
3222  }
3223  return sRet;
3224 }
3225 
3226 void SAL_CALL ScDataPilotItemObj::setName( const OUString& /* aName */ )
3227 {
3228 }
3229 
3230  // XPropertySet
3231 Reference< XPropertySetInfo >
3232  SAL_CALL ScDataPilotItemObj::getPropertySetInfo( )
3233 {
3234  SolarMutexGuard aGuard;
3235  static Reference<XPropertySetInfo> aRef =
3236  new SfxItemPropertySetInfo( maPropSet.getPropertyMap() );
3237  return aRef;
3238 }
3239 
3240 void SAL_CALL ScDataPilotItemObj::setPropertyValue( const OUString& aPropertyName, const Any& aValue )
3241 {
3242  SolarMutexGuard aGuard;
3243  ScDPObject* pDPObj = nullptr;
3244  ScDPSaveDimension* pDim = GetDPDimension( &pDPObj );
3245  if(!pDim)
3246  return;
3247 
3248  Reference<XNameAccess> xMembers = GetMembers();
3249  if( !xMembers.is() )
3250  return;
3251 
3252  Reference<XIndexAccess> xMembersIndex( new ScNameToIndexAccess( xMembers ) );
3253  sal_Int32 nCount = xMembersIndex->getCount();
3254  if( mnIndex >= nCount )
3255  return;
3256 
3257  Reference<XNamed> xMember(xMembersIndex->getByIndex(mnIndex), UNO_QUERY);
3258  OUString sName(xMember->getName());
3259  ScDPSaveMember* pMember = pDim->GetMemberByName(sName);
3260  if (!pMember)
3261  return;
3262 
3263  bool bGetNewIndex = false;
3264  if ( aPropertyName == SC_UNONAME_SHOWDETAIL )
3265  pMember->SetShowDetails(cppu::any2bool(aValue));
3266  else if ( aPropertyName == SC_UNONAME_ISHIDDEN )
3267  pMember->SetIsVisible(!cppu::any2bool(aValue));
3268  else if ( aPropertyName == SC_UNONAME_POS )
3269  {
3270  sal_Int32 nNewPos = 0;
3271  if ( !( aValue >>= nNewPos ) || nNewPos < 0 || nNewPos >= nCount )
3272  throw IllegalArgumentException();
3273 
3274  pDim->SetMemberPosition( sName, nNewPos );
3275  // get new effective index (depends on sorting mode, which isn't modified)
3276  bGetNewIndex = true;
3277 
3278  }
3279  SetDPObject( pDPObj );
3280 
3281  if ( bGetNewIndex ) // after SetDPObject, get the new index
3282  {
3283  Sequence< OUString > aItemNames = xMembers->getElementNames();
3284  sal_Int32 nItemCount = aItemNames.getLength();
3285  for (sal_Int32 nItem=0; nItem<nItemCount; ++nItem)
3286  if (aItemNames[nItem] == sName)
3287  mnIndex = nItem;
3288  }
3289 }
3290 
3291 Any SAL_CALL ScDataPilotItemObj::getPropertyValue( const OUString& aPropertyName )
3292 {
3293  SolarMutexGuard aGuard;
3294  Any aRet;
3295  if( ScDPSaveDimension* pDim = GetDPDimension() )
3296  {
3297  Reference< XNameAccess > xMembers = GetMembers();
3298  if( xMembers.is() )
3299  {
3300  Reference< XIndexAccess > xMembersIndex( new ScNameToIndexAccess( xMembers ) );
3301  sal_Int32 nCount = xMembersIndex->getCount();
3302  if( mnIndex < nCount )
3303  {
3304  Reference< XNamed > xMember( xMembersIndex->getByIndex( mnIndex ), UNO_QUERY );
3305  OUString sName( xMember->getName() );
3306  ScDPSaveMember* pMember = pDim->GetExistingMemberByName( sName );
3307  if ( aPropertyName == SC_UNONAME_SHOWDETAIL )
3308  {
3309  if (pMember && pMember->HasShowDetails())
3310  {
3311  aRet <<= pMember->GetShowDetails();
3312  }
3313  else
3314  {
3315  Reference< XPropertySet > xMemberProps( xMember, UNO_QUERY );
3316  if( xMemberProps.is() )
3317  aRet = xMemberProps->getPropertyValue( SC_UNO_DP_SHOWDETAILS );
3318  else
3319  aRet <<= true;
3320  }
3321  }
3322  else if ( aPropertyName == SC_UNONAME_ISHIDDEN )
3323  {
3324  if (pMember && pMember->HasIsVisible())
3325  {
3326  aRet <<= !pMember->GetIsVisible();
3327  }
3328  else
3329  {
3330  Reference< XPropertySet > xMemberProps( xMember, UNO_QUERY );
3331  if( xMemberProps.is() )
3332  aRet <<= !cppu::any2bool( xMemberProps->getPropertyValue( SC_UNO_DP_ISVISIBLE ) );
3333  else
3334  aRet <<= false;
3335  }
3336  }
3337  else if ( aPropertyName == SC_UNONAME_POS )
3338  {
3339  aRet <<= mnIndex;
3340  }
3341  }
3342  }
3343  }
3344  return aRet;
3345 }
3346 
3347 void SAL_CALL ScDataPilotItemObj::addPropertyChangeListener(
3348  const OUString& /* aPropertyName */, const Reference< XPropertyChangeListener >& /* xListener */ )
3349 {
3350 }
3351 
3352 void SAL_CALL ScDataPilotItemObj::removePropertyChangeListener(
3353  const OUString& /* aPropertyName */, const Reference< XPropertyChangeListener >& /* aListener */ )
3354 {
3355 }
3356 
3357 void SAL_CALL ScDataPilotItemObj::addVetoableChangeListener(
3358  const OUString& /* PropertyName */, const Reference< XVetoableChangeListener >& /* aListener */ )
3359 {
3360 }
3361 
3362 void SAL_CALL ScDataPilotItemObj::removeVetoableChangeListener(
3363  const OUString& /* PropertyName */, const Reference< XVetoableChangeListener >& /* aListener */ )
3364 {
3365 }
3366 
3367 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
lcl_CreatePivotName
static OUString lcl_CreatePivotName(ScDocShell *pDocShell)
Definition: dapiuno.cxx:269
ScDataPilotTablesObj::getByName
virtual css::uno::Any SAL_CALL getByName(const OUString &aName) override
Definition: dapiuno.cxx:514
ScDataPilotTableObj::insertDrillDownSheet
virtual void SAL_CALL insertDrillDownSheet(const css::table::CellAddress &aAddr) override
Definition: dapiuno.cxx:1170
ScDataPilotTablesObj::pDocShell
ScDocShell * pDocShell
Definition: dapiuno.hxx:87
ScDPSaveData::SetRepeatIfEmpty
SC_DLLPUBLIC void SetRepeatIfEmpty(bool bSet)
Definition: dpsave.cxx:998
SC_UNONAME_LAYOUTINFO
#define SC_UNONAME_LAYOUTINFO
Definition: unonames.hxx:267
ScDPSaveData::GetExistingDimensionData
const ScDPDimensionSaveData * GetExistingDimensionData() const
Definition: dpsave.hxx:349
ScDPSaveGroupDimension::GetGroupDimName
const OUString & GetGroupDimName() const
Definition: dpdimsave.hxx:108
ScDataPilotFieldObj::maOrient
css::uno::Any maOrient
Definition: dapiuno.hxx:473
ScDataPilotFieldsObj::hasElements
virtual sal_Bool SAL_CALL hasElements() override
Definition: dapiuno.cxx:1595
ScDataPilotFieldGroupObj::removeByName
virtual void SAL_CALL removeByName(const OUString &Name) override
Definition: dapiuno.cxx:2992
ScRangeList::UpdateReference
bool UpdateReference(UpdateRefMode, const ScDocument *, const ScRange &rWhere, SCCOL nDx, SCROW nDy, SCTAB nDz)
Definition: rangelst.cxx:369
ScDataPilotDescriptorBase::getDataPilotFields
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getDataPilotFields() override
Definition: dapiuno.cxx:648
ScGeneralFunction::AUTO
function is determined automatically.
ScDPObject::IsDimNameInUse
bool IsDimNameInUse(std::u16string_view rName) const
Definition: dpobject.cxx:1172
ScDPSaveData::GetRowGrand
bool GetRowGrand() const
Definition: dpsave.hxx:327
ScDataPilotTableObj::getOutputRangeByType
virtual css::table::CellRangeAddress SAL_CALL getOutputRangeByType(sal_Int32 nType) override
Definition: dapiuno.cxx:1186
ScDataPilotFieldObj::getPropertyValue
virtual css::uno::Any SAL_CALL getPropertyValue(const OUString &PropertyName) override
Definition: dapiuno.cxx:1829
ScDataPilotItemsObj::createEnumeration
virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() override
Definition: dapiuno.cxx:3161
ScDataPilotItemObj::addPropertyChangeListener
virtual void SAL_CALL addPropertyChangeListener(const OUString &aPropertyName, const css::uno::Reference< css::beans::XPropertyChangeListener > &xListener) override
Definition: dapiuno.cxx:3347
ScDataPilotConversion::FirstFunc
static ScGeneralFunction FirstFunc(PivotFunc nBits)
Definition: dapiuno.cxx:194
ScDPDimensionSaveData::ReplaceNumGroupDimension
void ReplaceNumGroupDimension(const ScDPSaveNumGroupDimension &rGroupDim)
Definition: dpdimsave.cxx:598
ScRange::aStart
ScAddress aStart
Definition: address.hxx:500
ScUnoHelpFunctions::GetEnumFromAny
static sal_Int32 GetEnumFromAny(const css::uno::Any &aAny)
Definition: miscuno.cxx:160
ScDBFunc::ShowDataPilotSourceData
void ShowDataPilotSourceData(ScDPObject &rDPObj, const css::uno::Sequence< css::sheet::DataPilotFieldFilter > &rFilters)
Definition: dbfunc3.cxx:2030
ScDPDimensionSaveData
This class has to do with handling exclusively grouped dimensions? TODO: Find out what this class doe...
Definition: dpdimsave.hxx:164
lcl_GetFieldDataByIndex
static bool lcl_GetFieldDataByIndex(const Reference< XDimensionsSupplier > &rSource, const Any &rOrient, SCSIZE nIndex, ScFieldIdentifier &rFieldId)
Definition: dapiuno.cxx:1455
ScDPSaveDimension::GetMemberByName
ScDPSaveMember * GetMemberByName(const OUString &rName)
Get a member object by its name.
Definition: dpsave.cxx:456
ScDataPilotChildObjBase::ScDataPilotChildObjBase
ScDataPilotChildObjBase(ScDataPilotDescriptorBase &rParent)
Definition: dapiuno.cxx:1329
ScDPCollection::GetCount
SC_DLLPUBLIC size_t GetCount() const
Definition: dpobject.cxx:3677
ScImportDescriptor::FillProperties
static void FillProperties(css::uno::Sequence< css::beans::PropertyValue > &rSeq, const ScImportParam &rParam)
Definition: datauno.cxx:164
ScDPSaveDimension::SetOrientation
void SetOrientation(css::sheet::DataPilotFieldOrientation nNew)
Definition: dpsave.cxx:317
ScDataPilotDescriptorBase::addPropertyChangeListener
virtual void SAL_CALL addPropertyChangeListener(const OUString &aPropertyName, const css::uno::Reference< css::beans::XPropertyChangeListener > &xListener) override
Definition: dapiuno.cxx:939
SC_UNO_DP_SERVICEARG
#define SC_UNO_DP_SERVICEARG
Definition: unonames.hxx:628
ScDataPilotDescriptor::mpDPObject
std::unique_ptr< ScDPObject > mpDPObject
Definition: dapiuno.hxx:208
ScDataPilotFieldGroupObj::createEnumeration
virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() override
Definition: dapiuno.cxx:3024
ScDataPilotFieldObj::getPropertySetInfo
virtual css::uno::Reference< css::beans::XPropertySetInfo > SAL_CALL getPropertySetInfo() override
Definition: dapiuno.cxx:1695
ScDPSaveData::GetGrandTotalName
SC_DLLPUBLIC const std::optional< OUString > & GetGrandTotalName() const
Definition: dpsave.cxx:770
ScImportParam::aDBName
OUString aDBName
Definition: global.hxx:457
ScDataPilotFieldGroupItemObj::setName
virtual void SAL_CALL setName(const OUString &aName) override
Definition: dapiuno.cxx:3078
ScDataPilotDescriptorBase::getPageFields
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getPageFields() override
Definition: dapiuno.cxx:666
ScDPSaveDimension::GetOrientation
css::sheet::DataPilotFieldOrientation GetOrientation() const
Definition: dpsave.hxx:203
ScDataPilotTablesObj::createDataPilotDescriptor
virtual css::uno::Reference< css::sheet::XDataPilotDescriptor > SAL_CALL createDataPilotDescriptor() override
Definition: dapiuno.cxx:360
ScDataPilotFieldGroupObj::getCount
virtual sal_Int32 SAL_CALL getCount() override
Definition: dapiuno.cxx:3007
ScDPDimensionSaveData::AddNumGroupDimension
void AddNumGroupDimension(const ScDPSaveNumGroupDimension &rGroupDim)
Definition: dpdimsave.cxx:590
ScDataPilotFieldObj::getAutoShowInfo
const css::sheet::DataPilotFieldAutoShowInfo * getAutoShowInfo() const
Definition: dapiuno.cxx:2135
ScDataPilotTablesObj::getCount
virtual sal_Int32 SAL_CALL getCount() override
Definition: dapiuno.cxx:465
comphelper::findValue
sal_Int32 findValue(const css::uno::Sequence< T1 > &_rList, const T2 &_rValue)
ScDataPilotItemObj::getName
virtual OUString SAL_CALL getName() override
Definition: dapiuno.cxx:3208
ScDPServiceDesc::aParPass
OUString aParPass
Definition: dpobject.hxx:75
ScDataPilotTableObj::acquire
virtual void SAL_CALL acquire() override
Definition: dapiuno.cxx:1023
ScDataPilotDescriptor::getName
virtual OUString SAL_CALL getName() override
Definition: dapiuno.cxx:1305
ScDPObject::GetDimCount
tools::Long GetDimCount()
Definition: dpobject.cxx:1274
ScDataPilotItemsObj::getCount
virtual sal_Int32 SAL_CALL getCount() override
Definition: dapiuno.cxx:3169
ScDataPilotDescriptor::~ScDataPilotDescriptor
virtual ~ScDataPilotDescriptor() override
Definition: dapiuno.cxx:1285
tools::Long
long Long
ScDataPilotFieldObj::setReference
void setReference(const css::sheet::DataPilotFieldReference *pInfo)
Definition: dapiuno.cxx:2178
ScDataPilotFieldObj::getGroupInfo
css::sheet::DataPilotFieldGroupInfo getGroupInfo()
Definition: dapiuno.cxx:2253
ScDPObject::GetDrillDownData
void GetDrillDownData(const ScAddress &rPos, css::uno::Sequence< css::uno::Sequence< css::uno::Any > > &rTableData)
Definition: dpobject.cxx:1157
ScDPDimensionSaveData::AddGroupDimension
void AddGroupDimension(const ScDPSaveGroupDimension &rGroupDim)
Definition: dpdimsave.cxx:564
ScDPSaveDimension::GetLayoutInfo
const css::sheet::DataPilotFieldLayoutInfo * GetLayoutInfo() const
Definition: dpsave.hxx:195
SC_UNONAME_REFERENCE
#define SC_UNONAME_REFERENCE
Definition: unonames.hxx:261
mxParent
WeakReference< XInterface > mxParent
ScDPSaveData::GetDimensionData
SC_DLLPUBLIC ScDPDimensionSaveData * GetDimensionData()
Definition: dpsave.cxx:1195
SC_UNO_DP_COLGRAND
#define SC_UNO_DP_COLGRAND
Definition: unonames.hxx:587
ScDataPilotFieldGroupsObj::getElementType
virtual css::uno::Type SAL_CALL getElementType() override
Definition: dapiuno.cxx:2859
ScDataPilotDescriptorBase::ScDataPilotDescriptorBase
ScDataPilotDescriptorBase(ScDocShell *pDocSh)
Definition: dapiuno.cxx:582
ScDPSaveGroupItem
Classes to save Data Pilot settings that create new dimensions (fields).
Definition: dpdimsave.hxx:47
ScDPSaveGroupItem::GetGroupName
const OUString & GetGroupName() const
Definition: dpdimsave.hxx:66
ScDataPilotFieldGroupItemObj::mxParent
rtl::Reference< ScDataPilotFieldGroupObj > mxParent
Definition: dapiuno.hxx:630
n
sal_Int64 n
ScDocument::GetDPCollection
SC_DLLPUBLIC ScDPCollection * GetDPCollection()
Definition: documen3.cxx:359
ScFieldIdentifier::mnFieldIdx
sal_Int32 mnFieldIdx
Source field name.
Definition: dapiuno.hxx:291
ScDataPilotFieldGroupsObj::getFieldGroup
ScFieldGroup & getFieldGroup(const OUString &rName)
Definition: dapiuno.cxx:2873
ScDPObject::SetOutRange
void SetOutRange(const ScRange &rRange)
Definition: dpobject.cxx:401
ScDPSaveGroupDimension::GetSourceDimName
const OUString & GetSourceDimName() const
Definition: dpdimsave.hxx:109
ScDPDimensionSaveData::RemoveGroupDimension
void RemoveGroupDimension(const OUString &rGroupDimName)
Definition: dpdimsave.cxx:582
SC_UNO_DP_PASSWORD
#define SC_UNO_DP_PASSWORD
Definition: unonames.hxx:634
ScDataPilotFieldGroupObj::getByIndex
virtual css::uno::Any SAL_CALL getByIndex(sal_Int32 Index) override
Definition: dapiuno.cxx:3013
ScDocShell::SetDocumentModified
void SetDocumentModified()
Definition: docsh.cxx:2820
ScDataPilotFieldGroupsObj::hasByName
virtual sal_Bool SAL_CALL hasByName(const OUString &aName) override
Definition: dapiuno.cxx:2766
ScDataPilotFieldGroupItemObj::getName
virtual OUString SAL_CALL getName() override
Definition: dapiuno.cxx:3072
ScDataPilotFieldObj::getOrientation
css::sheet::DataPilotFieldOrientation getOrientation() const
Definition: dapiuno.cxx:1933
ScDataPilotDescriptorBase::setPropertyValue
virtual void SAL_CALL setPropertyValue(const OUString &aPropertyName, const css::uno::Any &aValue) override
Definition: dapiuno.cxx:693
ScDataPilotTablesObj::getElementNames
virtual css::uno::Sequence< OUString > SAL_CALL getElementNames() override
Definition: dapiuno.cxx:523
ScDataPilotDescriptor::GetDPObject
virtual ScDPObject * GetDPObject() const override
Definition: dapiuno.cxx:1289
ScDataPilotFieldGroupsObj::maGroups
ScFieldGroups maGroups
Definition: dapiuno.hxx:548
ScGeneralFunction::COUNTNUMS
numerical values are counted.
SC_UNO_DP_REPEATEMPTY
#define SC_UNO_DP_REPEATEMPTY
Definition: unonames.hxx:605
ScDataPilotChildObjBase::GetDPObject
ScDPObject * GetDPObject() const
Returns the wrapped DataPilot object (calls GetDPObject() at parent).
Definition: dapiuno.cxx:1344
ScGeneralFunction::SUM
sum of all numerical values is calculated.
ScDataPilotFieldGroupObj::hasByName
virtual sal_Bool SAL_CALL hasByName(const OUString &aName) override
Definition: dapiuno.cxx:2945
ScDataPilotTablesObj
DataPilotTables collection per sheet.
Definition: dapiuno.hxx:79
ScDPSaveDimension::IsDataLayout
bool IsDataLayout() const
Definition: dpsave.hxx:143
ScDPObject::SetImportDesc
void SetImportDesc(const ScImportSourceDesc &rDesc)
Definition: dpobject.cxx:438
ScDocument::GetRange
SC_DLLPUBLIC ScRange GetRange(SCTAB nTab, const tools::Rectangle &rMMRect, bool bHiddenAsZero=true) const
Definition: documen3.cxx:1781
ScDataPilotChildObjBase::SetDPObject
void SetDPObject(ScDPObject *pDPObject)
Sets the passed DataPilot object (calls SetDPObject() at parent).
Definition: dapiuno.cxx:1349
ScDataPilotDescriptorBase::getSomething
virtual sal_Int64 SAL_CALL getSomething(const css::uno::Sequence< sal_Int8 > &aIdentifier) override
Definition: dapiuno.cxx:980
ScDataPilotItemObj::getPropertySetInfo
virtual css::uno::Reference< css::beans::XPropertySetInfo > SAL_CALL getPropertySetInfo() override
Definition: dapiuno.cxx:3232
ScDataPilotFieldObj::setName
virtual void SAL_CALL setName(const OUString &aName) override
Definition: dapiuno.cxx:1681
ScDataPilotTableObj::getPositionData
virtual css::sheet::DataPilotTablePositionData SAL_CALL getPositionData(const css::table::CellAddress &aAddr) override
Definition: dapiuno.cxx:1157
ScDPSaveNumGroupDimension::GetDateInfo
const ScDPNumGroupInfo & GetDateInfo() const
Definition: dpdimsave.hxx:154
SC_UNO_DP_IGNORE_EMPTYROWS
#define SC_UNO_DP_IGNORE_EMPTYROWS
Definition: unonames.hxx:623
ScDPServiceDesc::aParSource
OUString aParSource
Definition: dpobject.hxx:72
ScDataPilotFieldGroupsObj::ScDataPilotFieldGroupsObj
ScDataPilotFieldGroupsObj(const ScFieldGroups &rGroups)
Definition: dapiuno.cxx:2730
SC_UNO_DP_GRANDTOTAL_NAME
#define SC_UNO_DP_GRANDTOTAL_NAME
Definition: unonames.hxx:613
SC_UNONAME_GROUPINFO
#define SC_UNONAME_GROUPINFO
Definition: unonames.hxx:269
ScDataPilotFieldObj::setOrientation
void setOrientation(css::sheet::DataPilotFieldOrientation Orientation)
Definition: dapiuno.cxx:1940
SfxHint::GetId
SfxHintId GetId() const
ScDataPilotDescriptorBase::getPropertyValue
virtual css::uno::Any SAL_CALL getPropertyValue(const OUString &PropertyName) override
Definition: dapiuno.cxx:834
ScGeneralFunction::PRODUCT
product of all numerical values is calculated.
ScDataPilotDescriptorBase::getDataLayoutField
virtual css::uno::Reference< css::sheet::XDataPilotField > SAL_CALL getDataLayoutField() override
Definition: dapiuno.cxx:961
ScDataPilotDescriptorBase::~ScDataPilotDescriptorBase
virtual ~ScDataPilotDescriptorBase() override
Definition: dapiuno.cxx:589
ScDataPilotTablesObj::Notify
virtual void Notify(SfxBroadcaster &rBC, const SfxHint &rHint) override
Definition: dapiuno.cxx:313
ScDataPilotFieldObj::setShowEmpty
void setShowEmpty(bool bShow)
Definition: dapiuno.cxx:2214
SC_UNO_DP_ORIGINAL
#define SC_UNO_DP_ORIGINAL
Definition: unonames.hxx:589
ScDataPilotConversion::FillGroupInfo
static void FillGroupInfo(css::sheet::DataPilotFieldGroupInfo &rInfo, const ScDPNumGroupInfo &rGroupInfo)
Definition: dapiuno.cxx:238
ScDPDimensionSaveData::CreateGroupDimName
OUString CreateGroupDimName(const OUString &rSourceName, const ScDPObject &rObject, bool bAllowSource, const ::std::vector< OUString > *pDeletedNames)
Definition: dpdimsave.cxx:712
ScDataPilotFieldGroupObj::getElementNames
virtual css::uno::Sequence< OUString > SAL_CALL getElementNames() override
Definition: dapiuno.cxx:2939
ScDPCollection::CreateNewName
OUString CreateNewName() const
Create a new name that's not yet used by any existing data pilot objects.
Definition: dpobject.cxx:3703
ScDataPilotFieldGroupsObj::replaceByName
virtual void SAL_CALL replaceByName(const OUString &aName, const css::uno::Any &aElement) override
Definition: dapiuno.cxx:2774
exc_hlp.hxx
ScDataPilotFieldsObj::GetObjectByIndex_Impl
ScDataPilotFieldObj * GetObjectByIndex_Impl(sal_Int32 nIndex) const
Definition: dapiuno.cxx:1539
rValue
css::uno::Any const & rValue
ScDPObject::GetTag
const OUString & GetTag() const
Definition: dpobject.hxx:169
ScDataPilotChildObjBase::GetMemberCount
sal_Int32 GetMemberCount() const
Returns the number of members for the field described by maFieldId.
Definition: dapiuno.cxx:1389
ScDataPilotFieldGroupsObj::getByIndex
virtual css::uno::Any SAL_CALL getByIndex(sal_Int32 Index) override
Definition: dapiuno.cxx:2841
ScDataPilotItemObj::setPropertyValue
virtual void SAL_CALL setPropertyValue(const OUString &aPropertyName, const css::uno::Any &aValue) override
Definition: dapiuno.cxx:3240
ScDPDimensionSaveData::GetNamedGroupDim
const ScDPSaveGroupDimension * GetNamedGroupDim(const OUString &rGroupDimName) const
Definition: dpdimsave.cxx:637
ScDataPilotDescriptor::getTag
virtual OUString SAL_CALL getTag() override
Definition: dapiuno.cxx:1317
ScDataPilotDescriptorBase::getRowFields
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getRowFields() override
Definition: dapiuno.cxx:660
ScDBDocFunc::RefreshPivotTables
void RefreshPivotTables(const ScDPObject *pDPObj, bool bApi)
Reload the referenced pivot cache, and refresh all pivot tables that reference the cache...
Definition: dbdocfun.cxx:1607
ScFieldGroup::maName
OUString maName
Definition: dapiuno.hxx:480
ScDataPilotFieldObj::getShowEmpty
bool getShowEmpty() const
Definition: dapiuno.cxx:2207
ScDPObject::GetOutRange
const ScRange & GetOutRange() const
Definition: dpobject.cxx:409
ScDPDimensionSaveData::GetGroupDimAccForBase
ScDPSaveGroupDimension * GetGroupDimAccForBase(const OUString &rBaseDimName)
Definition: dpdimsave.cxx:657
ScDataPilotFieldGroupItemObj::~ScDataPilotFieldGroupItemObj
virtual ~ScDataPilotFieldGroupItemObj() override
Definition: dapiuno.cxx:3066
SC_UNONAME_USESELPAGE
#define SC_UNONAME_USESELPAGE
Definition: unonames.hxx:259
SCSIZE
size_t SCSIZE
size_t typedef to be able to find places where code was changed from USHORT to size_t and is used to ...
Definition: address.hxx:45
cppu::getCaughtException
Any SAL_CALL getCaughtException()
ScFieldGroups
::std::vector< ScFieldGroup > ScFieldGroups
Definition: dapiuno.hxx:484
assert
const BorderLinePrimitive2D *pCandidateB assert(pCandidateA)
ScDPSaveData::RemoveDimensionByName
void RemoveDimensionByName(const OUString &rName)
Definition: dpsave.cxx:898
ScDataPilotFieldObj::setSubtotals
void setSubtotals(const std::vector< ScGeneralFunction > &rFunctions)
Definition: dapiuno.cxx:2062
ScDataPilotFieldsObj::hasByName
virtual sal_Bool SAL_CALL hasByName(const OUString &aName) override
Definition: dapiuno.cxx:1634
nCount
int nCount
ScDataPilotDescriptorBase::removePropertyChangeListener
virtual void SAL_CALL removePropertyChangeListener(const OUString &aPropertyName, const css::uno::Reference< css::beans::XPropertyChangeListener > &aListener) override
Definition: dapiuno.cxx:944
ScDataPilotTableObj::addModifyListener
virtual void SAL_CALL addModifyListener(const css::uno::Reference< css::util::XModifyListener > &aListener) override
Definition: dapiuno.cxx:1200
ScAddress::Tab
SCTAB Tab() const
Definition: address.hxx:271
ScGeneralFunction::VARP
variance is calculated based on the entire population.
ScDPSaveGroupItem::AddElementsFromGroup
void AddElementsFromGroup(const ScDPSaveGroupItem &rGroup)
Definition: dpdimsave.cxx:49
ScDPSaveDimension::SetMemberPosition
void SetMemberPosition(const OUString &rName, sal_Int32 nNewPos)
Definition: dpsave.cxx:468
ScSheetSourceDesc::GetSourceRange
SC_DLLPUBLIC const ScRange & GetSourceRange() const
Get the range that contains the source data.
Definition: dpshttab.cxx:229
PivotFunc
PivotFunc
Definition: dpglobal.hxx:25
ScDataPilotFieldGroupItemObj::ScDataPilotFieldGroupItemObj
ScDataPilotFieldGroupItemObj(ScDataPilotFieldGroupObj &rParent, const OUString &rName)
Definition: dapiuno.cxx:3060
ScDataPilotDescriptorBase::pDocShell
ScDocShell * pDocShell
Definition: dapiuno.hxx:142
ScDPDimensionSaveData::ReplaceGroupDimension
void ReplaceGroupDimension(const ScDPSaveGroupDimension &rGroupDim)
Definition: dpdimsave.cxx:572
ScDataPilotFieldGroupObj::getByName
virtual css::uno::Any SAL_CALL getByName(const OUString &aName) override
Definition: dapiuno.cxx:2929
ScDPSaveData::GetIgnoreEmptyRows
bool GetIgnoreEmptyRows() const
Definition: dpsave.hxx:331
ScDPObject::SetSheetDesc
void SetSheetDesc(const ScSheetSourceDesc &rDesc)
Definition: dpobject.cxx:414
ScFieldIdentifier::mbDataLayout
bool mbDataLayout
Field index (if several fields with same name exist).
Definition: dapiuno.hxx:292
comphelper::InitPropertySequence
css::uno::Sequence< css::beans::PropertyValue > InitPropertySequence(::std::initializer_list< ::std::pair< OUString, css::uno::Any > > vInit)
ScDataPilotFieldObj::mxItems
css::uno::Reference< css::container::XIndexAccess > mxItems
Definition: dapiuno.hxx:471
ScDPSaveNumGroupDimension::SetGroupInfo
void SetGroupInfo(const ScDPNumGroupInfo &rNew)
Definition: dpdimsave.cxx:526
ScDPSaveGroupItem::GetElementCount
size_t GetElementCount() const
Definition: dpdimsave.cxx:73
ScDataPilotFieldObj::getSubtotals
css::uno::Sequence< sal_Int16 > getSubtotals() const
Definition: dapiuno.cxx:2041
sName
const char * sName
ScDPSaveDimension::SetFunction
void SetFunction(ScGeneralFunction nNew)
Definition: dpsave.cxx:343
ScDataPilotFieldGroupsObj::getElementNames
virtual css::uno::Sequence< OUString > SAL_CALL getElementNames() override
Definition: dapiuno.cxx:2749
SC_QUERYINTERFACE
#define SC_QUERYINTERFACE(x)
Definition: miscuno.hxx:87
ScDataPilotTablesObj::createEnumeration
virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() override
Definition: dapiuno.cxx:457
ScDataPilotFieldGroupObj::insertByName
virtual void SAL_CALL insertByName(const OUString &aName, const css::uno::Any &aElement) override
Definition: dapiuno.cxx:2977
ScDPSaveDimension::GetRepeatItemLabels
bool GetRepeatItemLabels() const
Definition: dpsave.hxx:162
ScDataPilotFieldsObj::createEnumeration
virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() override
Definition: dapiuno.cxx:1563
ScGeneralFunction::MAX
maximum value of all numerical values is calculated.
SC_UNO_DP_SOURCENAME
#define SC_UNO_DP_SOURCENAME
Definition: unonames.hxx:631
ScDataPilotDescriptorBase::getFilterDescriptor
virtual css::uno::Reference< css::sheet::XSheetFilterDescriptor > SAL_CALL getFilterDescriptor() override
Definition: dapiuno.cxx:642
ScDataPilotItemsObj::getByName
virtual css::uno::Any SAL_CALL getByName(const OUString &aName) override
Definition: dapiuno.cxx:3105
ScDPObject::SetName
void SetName(const OUString &rNew)
Definition: dpobject.cxx:489
ScDPSaveDimension::SetLayoutName
void SetLayoutName(const OUString &rName)
Definition: dpsave.cxx:379
ScDPServiceDesc::aParUser
OUString aParUser
Definition: dpobject.hxx:74
ScDataPilotTableObj::getDrillDownData
virtual css::uno::Sequence< css::uno::Sequence< css::uno::Any > > SAL_CALL getDrillDownData(const css::table::CellAddress &aAddr) override
Definition: dapiuno.cxx:1144
ScDataPilotFieldObj::setSortInfo
void setSortInfo(const css::sheet::DataPilotFieldSortInfo *pInfo)
Definition: dapiuno.cxx:2196
ScDataPilotFieldObj::setRepeatItemLabels
void setRepeatItemLabels(bool bShow)
Definition: dapiuno.cxx:2232
ScDataPilotConversion::FunctionBit
static PivotFunc FunctionBit(sal_Int16 eFunc)
Definition: dapiuno.cxx:212
ScDPSaveGroupDimension::GetGroupCount
tools::Long GetGroupCount() const
Definition: dpdimsave.cxx:200
ScDPSaveData::GetDrillDown
bool GetDrillDown() const
Definition: dpsave.hxx:343
SC_UNO_DP_IMPORTDESC
#define SC_UNO_DP_IMPORTDESC
Definition: unonames.hxx:626
ScDataPilotDescriptor::ScDataPilotDescriptor
ScDataPilotDescriptor(ScDocShell *pDocSh)
Definition: dapiuno.cxx:1270
ScGeneralFunction::STDEVP
standard deviation is calculated based on the entire population.
ScDataPilotFieldsObj
Collection of all DataPilot fields, or of all fields from a specific dimension.
Definition: dapiuno.hxx:342
ScImportParam::aStatement
OUString aStatement
Definition: global.hxx:458
ScDataPilotChildObjBase::mxParent
rtl::Reference< ScDataPilotDescriptorBase > mxParent
Definition: dapiuno.hxx:325
pName
sal_uInt16 char * pName
Definition: callform.cxx:57
ScDataPilotFieldObj::createDateGroup
virtual css::uno::Reference< css::sheet::XDataPilotField > SAL_CALL createDateGroup(const css::sheet::DataPilotFieldGroupInfo &rInfo) override
Definition: dapiuno.cxx:2573
ScDataPilotFieldGroupsObj::getByName
virtual css::uno::Any SAL_CALL getByName(const OUString &aName) override
Definition: dapiuno.cxx:2741
ScDataPilotFieldGroupsObj::hasElements
virtual sal_Bool SAL_CALL hasElements() override
Definition: dapiuno.cxx:2865
ScDataPilotItemObj::ScDataPilotItemObj
ScDataPilotItemObj(ScDataPilotDescriptorBase &rParent, const ScFieldIdentifier &rFieldId, sal_Int32 nIndex)
Definition: dapiuno.cxx:3196
ScDataPilotDescriptorBase::getDataFields
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getDataFields() override
Definition: dapiuno.cxx:672
ScDPSaveGroupDimension::GetGroupByIndex
const ScDPSaveGroupItem & GetGroupByIndex(tools::Long nIndex) const
Definition: dpdimsave.cxx:205
ScDPSaveDimension::GetSortInfo
const css::sheet::DataPilotFieldSortInfo * GetSortInfo() const
Definition: dpsave.hxx:187
ScDataPilotFieldObj::setCurrentPage
void setCurrentPage(const OUString &sPage)
Definition: dapiuno.cxx:2104
ScDataPilotFieldObj::getRepeatItemLabels
bool getRepeatItemLabels() const
Definition: dapiuno.cxx:2225
ScDataPilotItemObj::addVetoableChangeListener
virtual void SAL_CALL addVetoableChangeListener(const OUString &PropertyName, const css::uno::Reference< css::beans::XVetoableChangeListener > &aListener) override
Definition: dapiuno.cxx:3357
ScDPSaveDimension::SetCurrentPage
void SetCurrentPage(const OUString *pPage)
Definition: dpsave.cxx:426
ScDataPilotItemObj::setName
virtual void SAL_CALL setName(const OUString &aName) override
Definition: dapiuno.cxx:3226
ScDPSaveData::SetDimensionData
SC_DLLPUBLIC void SetDimensionData(const ScDPDimensionSaveData *pNew)
Definition: dpsave.cxx:1202
ScDataPilotFieldsObj::getElementType
virtual css::uno::Type SAL_CALL getElementType() override
Definition: dapiuno.cxx:1589
ScDataPilotChildObjBase::GetDocShell
ScDocShell * GetDocShell() const
Definition: dapiuno.cxx:1409
lcl_IsDuplicated
static bool lcl_IsDuplicated(const Reference< XPropertySet > &rDimProps)
Definition: dapiuno.cxx:368
ScDPSaveGroupItem::GetElementByIndex
const OUString * GetElementByIndex(size_t nIndex) const
Definition: dpdimsave.cxx:78
i
int i
lcl_GetFieldDataByName
static bool lcl_GetFieldDataByName(ScDPObject *pDPObj, const OUString &rFieldName, ScFieldIdentifier &rFieldId)
Definition: dapiuno.cxx:1523
ScDPSaveNumGroupDimension
Represents a group dimension that introduces a new hierarchy for an existing dimension.
Definition: dpdimsave.hxx:136
ScDataPilotFieldGroupsObj::insertByName
virtual void SAL_CALL insertByName(const OUString &aName, const css::uno::Any &aElement) override
Definition: dapiuno.cxx:2796
ScImportDescriptor::GetPropertyCount
static tools::Long GetPropertyCount()
Definition: datauno.hxx:83
ScDataPilotTablesObj::getElementType
virtual css::uno::Type SAL_CALL getElementType() override
Definition: dapiuno.cxx:500
ScGeneralFunction::AVERAGE
average of all numerical values is calculated.
ScDPObject::GetSource
css::uno::Reference< css::sheet::XDimensionsSupplier > const & GetSource()
Definition: dpobject.cxx:515
ScDataPilotTableObj::getOutputRange
virtual css::table::CellRangeAddress SAL_CALL getOutputRange() override
Definition: dapiuno.cxx:1116
ScDataPilotItemObj::~ScDataPilotItemObj
virtual ~ScDataPilotItemObj() override
Definition: dapiuno.cxx:3203
ScDataPilotFieldsObj::getByName
virtual css::uno::Any SAL_CALL getByName(const OUString &aName) override
Definition: dapiuno.cxx:1603
ScDataPilotFieldObj::~ScDataPilotFieldObj
virtual ~ScDataPilotFieldObj() override
Definition: dapiuno.cxx:1656
ScDPDimensionSaveData::GetNextNamedGroupDim
const ScDPSaveGroupDimension * GetNextNamedGroupDim(const OUString &rGroupDimName) const
Definition: dpdimsave.cxx:647
ScDataPilotDescriptorBase::getPropertySetInfo
virtual css::uno::Reference< css::beans::XPropertySetInfo > SAL_CALL getPropertySetInfo() override
Definition: dapiuno.cxx:685
ScDBDocFunc::DataPilotUpdate
bool DataPilotUpdate(ScDPObject *pOldObj, const ScDPObject *pNewObj, bool bRecord, bool bApi, bool bAllowMove=false)
Definition: dbdocfun.cxx:1238
ScDataPilotChildObjBase::maFieldId
ScFieldIdentifier maFieldId
Definition: dapiuno.hxx:326
SC_UNONAME_AUTOSHOW
#define SC_UNONAME_AUTOSHOW
Definition: unonames.hxx:263
ScDPObject::SetSaveData
void SetSaveData(const ScDPSaveData &rData)
Definition: dpobject.cxx:386
ScDataPilotFieldsObj::getByIndex
virtual css::uno::Any SAL_CALL getByIndex(sal_Int32 Index) override
Definition: dapiuno.cxx:1578
ScDPUtil::getSourceDimensionName
static SC_DLLPUBLIC OUString getSourceDimensionName(const OUString &rName)
Definition: dputil.cxx:64
ScDataPilotItemsObj::~ScDataPilotItemsObj
virtual ~ScDataPilotItemsObj() override
Definition: dapiuno.cxx:3091
lcl_GetFieldCount
static sal_Int32 lcl_GetFieldCount(const Reference< XDimensionsSupplier > &rSource, const Any &rOrient)
Definition: dapiuno.cxx:1429
ScDataPilotFieldGroupObj::ScDataPilotFieldGroupObj
ScDataPilotFieldGroupObj(ScDataPilotFieldGroupsObj &rParent, const OUString &rGroupName)
Definition: dapiuno.cxx:2917
ScDPObject::GetName
const OUString & GetName() const
Definition: dpobject.hxx:167
SC_UNO_DP_DRILLDOWN
#define SC_UNO_DP_DRILLDOWN
Definition: unonames.hxx:624
ScDPObject::IsSheetData
bool IsSheetData() const
Definition: dpobject.cxx:484
ScDataPilotFieldGroupObj::hasElements
virtual sal_Bool SAL_CALL hasElements() override
Definition: dapiuno.cxx:3038
ScDPDimensionSaveData::GetNumGroupDimAcc
ScDPSaveNumGroupDimension * GetNumGroupDimAcc(const OUString &rGroupDimName)
Definition: dpdimsave.cxx:688
SC_UNONAME_FUNCTION
#define SC_UNONAME_FUNCTION
Definition: unonames.hxx:254
ScDPSaveData::GetRepeatIfEmpty
bool GetRepeatIfEmpty() const
Definition: dpsave.hxx:335
ScDataPilotFieldObj
Implementation of a single DataPilot field.
Definition: dapiuno.hxx:395
ScDataPilotFieldObj::maPropSet
SfxItemPropertySet maPropSet
Definition: dapiuno.hxx:472
ScRangeList::size
size_t size() const
Definition: rangelst.hxx:90
ScUnoHelpFunctions::GetBoolProperty
static bool GetBoolProperty(const css::uno::Reference< css::beans::XPropertySet > &xProp, const OUString &rName, bool bDefault=false)
Definition: miscuno.cxx:35
ScDPObject::SetTag
void SetTag(const OUString &rNew)
Definition: dpobject.cxx:494
ScImportParam::bNative
bool bNative
Definition: global.hxx:459
SC_UNONAME_SHOWDETAIL
#define SC_UNONAME_SHOWDETAIL
Definition: unonames.hxx:274
u
float u
sal_Bool
unsigned char sal_Bool
ScDataPilotChildObjBase::~ScDataPilotChildObjBase
virtual ~ScDataPilotChildObjBase()
Definition: dapiuno.cxx:1340
ScResId
OUString ScResId(const char *pId)
Definition: scdll.cxx:89
SfxItemPropertySet::getPropertyMap
const SfxItemPropertyMap & getPropertyMap() const
ScDataPilotDescriptorBase::setSourceRange
virtual void SAL_CALL setSourceRange(const css::table::CellRangeAddress &aSourceRange) override
Definition: dapiuno.cxx:623
COUNT
const int COUNT
Definition: sheetevents.cxx:56
ScDataPilotTableObj::aModifyListeners
XModifyListenerArr_Impl aModifyListeners
Definition: dapiuno.hxx:236
ScDataPilotDescriptor::setTag
virtual void SAL_CALL setTag(const OUString &aTag) override
Definition: dapiuno.cxx:1323
ScFieldGroup::maMembers
ScFieldGroupMembers maMembers
Definition: dapiuno.hxx:481
SC_UNONAME_SHOWEMPTY
#define SC_UNONAME_SHOWEMPTY
Definition: unonames.hxx:270
ScDataPilotFieldObj::getLayoutInfo
const css::sheet::DataPilotFieldLayoutInfo * getLayoutInfo() const
Definition: dapiuno.cxx:2153
ScDataPilotItemsObj::hasElements
virtual sal_Bool SAL_CALL hasElements() override
Definition: dapiuno.cxx:3190
SC_UNONAME_HASSORTINFO
#define SC_UNONAME_HASSORTINFO
Definition: unonames.hxx:264
SC_UNONAME_SELPAGE
#define SC_UNONAME_SELPAGE
Definition: unonames.hxx:258
ScDPObject::GetSaveData
ScDPSaveData * GetSaveData() const
Definition: dpobject.hxx:141
SC_UNONAME_ISHIDDEN
#define SC_UNONAME_ISHIDDEN
Definition: unonames.hxx:275
ScDPSaveData::SetIgnoreEmptyRows
SC_DLLPUBLIC void SetIgnoreEmptyRows(bool bSet)
Definition: dpsave.cxx:993
ScDPObject::GetImportSourceDesc
const ScImportSourceDesc * GetImportSourceDesc() const
Definition: dpobject.hxx:157
ScDPSaveGroupDimension::GetDateInfo
const ScDPNumGroupInfo & GetDateInfo() const
Definition: dpdimsave.hxx:112
cppu::UnoType::get
css::uno::Type const & get()
SC_SIMPLE_SERVICE_INFO
#define SC_SIMPLE_SERVICE_INFO(ClassName, ClassNameAscii, ServiceAscii)
Definition: miscuno.hxx:64
ScDataPilotFieldGroupObj::~ScDataPilotFieldGroupObj
virtual ~ScDataPilotFieldGroupObj() override
Definition: dapiuno.cxx:2923
ScDataPilotFieldGroupsObj::~ScDataPilotFieldGroupsObj
virtual ~ScDataPilotFieldGroupsObj() override
Definition: dapiuno.cxx:2735
ScDPObject::GetDPServiceDesc
const ScDPServiceDesc * GetDPServiceDesc() const
Definition: dpobject.hxx:158
ScDataPilotTablesObj::hasElements
virtual sal_Bool SAL_CALL hasElements() override
Definition: dapiuno.cxx:506
ScDPDimensionSaveData::GetFirstNamedGroupDim
const ScDPSaveGroupDimension * GetFirstNamedGroupDim(const OUString &rBaseDimName) const
Definition: dpdimsave.cxx:642
ScDataPilotTablesObj::hasByName
virtual sal_Bool SAL_CALL hasByName(const OUString &aName) override
Definition: dapiuno.cxx:560
ScDataPilotDescriptorBase::removeVetoableChangeListener
virtual void SAL_CALL removeVetoableChangeListener(const OUString &PropertyName, const css::uno::Reference< css::beans::XVetoableChangeListener > &aListener) override
Definition: dapiuno.cxx:954
ScDataPilotFieldGroupObj::mxParent
rtl::Reference< ScDataPilotFieldGroupsObj > mxParent
Definition: dapiuno.hxx:603
ScDataPilotItemsObj::ScDataPilotItemsObj
ScDataPilotItemsObj(ScDataPilotDescriptorBase &rParent, const ScFieldIdentifier &rFieldId)
Definition: dapiuno.cxx:3086
ScDPSaveData::SetFilterButton
SC_DLLPUBLIC void SetFilterButton(bool bSet)
Definition: dpsave.cxx:1003
ScDataPilotTableObj::ScDataPilotTableObj
ScDataPilotTableObj(ScDocShell *pDocSh, SCTAB nT, const OUString &rN)
Definition: dapiuno.cxx:1000
comphelper::concatSequences
css::uno::Sequence< T > concatSequences(const css::uno::Sequence< T > &rS1, const Ss &...rSn)
ScDataPilotTablesObj::ScDataPilotTablesObj
ScDataPilotTablesObj(ScDocShell *pDocSh, SCTAB nT)
Definition: dapiuno.cxx:298
ScDPSaveData::DuplicateDimension
ScDPSaveDimension * DuplicateDimension(std::u16string_view rName)
Definition: dpsave.cxx:885
ScDataPilotFieldGroupsObj::removeByName
virtual void SAL_CALL removeByName(const OUString &Name) override
Definition: dapiuno.cxx:2819
ScDataPilotItemObj::removeVetoableChangeListener
virtual void SAL_CALL removeVetoableChangeListener(const OUString &PropertyName, const css::uno::Reference< css::beans::XVetoableChangeListener > &aListener) override
Definition: dapiuno.cxx:3362
ScDataPilotTableObj::getImplementationId
virtual css::uno::Sequence< sal_Int8 > SAL_CALL getImplementationId() override
Definition: dapiuno.cxx:1044
ScDataPilotTableObj::SetDPObject
virtual void SetDPObject(ScDPObject *pDPObj) override
Definition: dapiuno.cxx:1054
ScDataPilotTableObj::getTypes
virtual css::uno::Sequence< css::uno::Type > SAL_CALL getTypes() override
Definition: dapiuno.cxx:1033
ScDataPilotDescriptorBase::GetDocShell
ScDocShell * GetDocShell() const
Definition: dapiuno.hxx:150
ScDataPilotFieldGroupsObj
Implementation of all grouped items in a DataPilot field.
Definition: dapiuno.hxx:501
ScDataPilotTableObj::setTag
virtual void SAL_CALL setTag(const OUString &aTag) override
Definition: dapiuno.cxx:1101
ScImportSourceDesc::aDBName
OUString aDBName
Definition: dpsdbtab.hxx:36
ScDataPilotTableObj::queryInterface
virtual css::uno::Any SAL_CALL queryInterface(const css::uno::Type &rType) override
Definition: dapiuno.cxx:1012
ScDataPilotFieldObj::getSortInfo
const css::sheet::DataPilotFieldSortInfo * getSortInfo() const
Definition: dapiuno.cxx:2189
ScUnoHelpFunctions::GetInt16FromAny
static sal_Int16 GetInt16FromAny(const css::uno::Any &aAny)
Definition: miscuno.cxx:144
SC_IMPL_DUMMY_PROPERTY_LISTENER
#define SC_IMPL_DUMMY_PROPERTY_LISTENER(ClassName)
Definition: miscuno.hxx:73
ScDataPilotFieldObj::getReference
const css::sheet::DataPilotFieldReference * getReference() const
Definition: dapiuno.cxx:2171
ScDPObject::GetDataFieldPositionData
bool GetDataFieldPositionData(const ScAddress &rPos, css::uno::Sequence< css::sheet::DataPilotFieldFilter > &rFilters)
Definition: dpobject.cxx:1140
ScDPSaveData::GetFilterButton
bool GetFilterButton() const
Definition: dpsave.hxx:339
ScDPSaveData::SetPosition
void SetPosition(ScDPSaveDimension *pDim, tools::Long nNew)
Definition: dpsave.cxx:955
ScImportSourceDesc::nType
css::sheet::DataImportMode nType
Definition: dpsdbtab.hxx:38
ScDPSaveMember::SetShowDetails
SC_DLLPUBLIC void SetShowDetails(bool bSet)
Definition: dpsave.cxx:105
ScImportSourceDesc::aObject
OUString aObject
Definition: dpsdbtab.hxx:37
ScDocument::AddUnoObject
void AddUnoObject(SfxListener &rObject)
Definition: documen3.cxx:892
SC_UNO_DP_ROWGRAND
#define SC_UNO_DP_ROWGRAND
Definition: unonames.hxx:588
ScDataPilotTablesObj::getByIndex
virtual css::uno::Any SAL_CALL getByIndex(sal_Int32 Index) override
Definition: dapiuno.cxx:491
SC_UNO_DP_ORIENTATION
#define SC_UNO_DP_ORIENTATION
Definition: unonames.hxx:592
ScDataPilotFieldsObj::maOrient
css::uno::Any maOrient
Definition: dapiuno.hxx:381
ScDPSaveData::GetColumnGrand
bool GetColumnGrand() const
Definition: dpsave.hxx:323
ScGeneralFunction::MEDIAN
median of all numerical values is calculated.
ScDataPilotDescriptorBase::getUnoTunnelId
static SC_DLLPUBLIC const css::uno::Sequence< sal_Int8 > & getUnoTunnelId()
Definition: dapiuno.cxx:995
ScDPSaveData::SetGrandTotalName
SC_DLLPUBLIC void SetGrandTotalName(const OUString &rName)
Definition: dpsave.cxx:765
ScDPObject::GetDimName
OUString GetDimName(tools::Long nDim, bool &rIsDataLayout, sal_Int32 *pFlags=nullptr)
Definition: dpobject.cxx:1196
ScDataPilotFieldObj::setGroupInfo
void setGroupInfo(const css::sheet::DataPilotFieldGroupInfo *pInfo)
Definition: dapiuno.cxx:2312
ScDPSaveData::SetDrillDown
SC_DLLPUBLIC void SetDrillDown(bool bSet)
Definition: dpsave.cxx:1008
ScDataPilotItemsObj::hasByName
virtual sal_Bool SAL_CALL hasByName(const OUString &aName) override
Definition: dapiuno.cxx:3137
SC_UNONAME_SORTINFO
#define SC_UNONAME_SORTINFO
Definition: unonames.hxx:265
ScDataPilotDescriptorBase::getSourceRange
virtual css::table::CellRangeAddress SAL_CALL getSourceRange() override
Definition: dapiuno.cxx:609
SC_UNONAME_POS
#define SC_UNONAME_POS
Definition: unonames.hxx:159
ScDataPilotTableObj::release
virtual void SAL_CALL release() override
Definition: dapiuno.cxx:1028
ScDBDocFunc::RemovePivotTable
bool RemovePivotTable(ScDPObject &rDPObj, bool bRecord, bool bApi)
Definition: dbdocfun.cxx:1340
ScDataPilotFieldGroupsObj::implFindByName
ScFieldGroups::iterator implFindByName(const OUString &rName)
Definition: dapiuno.cxx:2895
SC_UNONAME_HASAUTOSHOW
#define SC_UNONAME_HASAUTOSHOW
Definition: unonames.hxx:262
SC_UNONAME_SUBTOTALS2
#define SC_UNONAME_SUBTOTALS2
Definition: unonames.hxx:257
ScDataPilotFieldObj::createNameGroup
virtual css::uno::Reference< css::sheet::XDataPilotField > SAL_CALL createNameGroup(const css::uno::Sequence< OUString > &aItems) override
Definition: dapiuno.cxx:2405
SC_UNONAME_SUBTOTALS
#define SC_UNONAME_SUBTOTALS
Definition: unonames.hxx:256
ScDataPilotDescriptorBase::Notify
virtual void Notify(SfxBroadcaster &rBC, const SfxHint &rHint) override
Definition: dapiuno.cxx:597
SC_UNONAME_ORIENT
#define SC_UNONAME_ORIENT
Definition: unonames.hxx:303
ScDataPilotFieldsObj::GetObjectByName_Impl
ScDataPilotFieldObj * GetObjectByName_Impl(const OUString &rName) const
Definition: dapiuno.cxx:1550
ScDPSaveMember::GetShowDetails
bool GetShowDetails() const
Definition: dpsave.hxx:77
ScDataPilotDescriptorBase::maPropSet
SfxItemPropertySet maPropSet
Definition: dapiuno.hxx:141
ScDataPilotFieldsObj::getElementNames
virtual css::uno::Sequence< OUString > SAL_CALL getElementNames() override
Definition: dapiuno.cxx:1612
ScDataPilotFieldObj::getName
virtual OUString SAL_CALL getName() override
Definition: dapiuno.cxx:1662
ScDPSaveData::GetDimensions
const DimsType & GetDimensions() const
Definition: dpsave.hxx:271
ScDataPilotFieldObj::setPropertyValue
virtual void SAL_CALL setPropertyValue(const OUString &aPropertyName, const css::uno::Any &aValue) override
Definition: dapiuno.cxx:1703
ScImportDescriptor::FillImportParam
static void FillImportParam(ScImportParam &rParam, const css::uno::Sequence< css::beans::PropertyValue > &rSeq)
Definition: datauno.cxx:204
ScDPSaveGroupItem::RemoveElementsFromGroups
void RemoveElementsFromGroups(ScDPSaveGroupDimension &rDimension) const
remove this group's elements from their groups in rDimension (rDimension must be a different dimensio...
Definition: dpdimsave.cxx:88
ScImportParam::nType
sal_uInt8 nType
Definition: global.hxx:461
SC_UNO_DP_USERNAME
#define SC_UNO_DP_USERNAME
Definition: unonames.hxx:633
ScFieldGroupMembers
::std::vector< OUString > ScFieldGroupMembers
Definition: dapiuno.hxx:476
SAL_WARN_IF
#define SAL_WARN_IF(condition, area, stream)
sal_uInt8
unsigned char sal_uInt8
ScDPServiceDesc::aParName
OUString aParName
Definition: dpobject.hxx:73
ScDataPilotTablesObj::~ScDataPilotTablesObj
virtual ~ScDataPilotTablesObj() override
Definition: dapiuno.cxx:305
ScDPServiceDesc::aServiceName
OUString aServiceName
Definition: dpobject.hxx:71
ScDataPilotItemObj::getPropertyValue
virtual css::uno::Any SAL_CALL getPropertyValue(const OUString &PropertyName) override
Definition: dapiuno.cxx:3291
ScDataPilotItemsObj::GetObjectByIndex_Impl
ScDataPilotItemObj * GetObjectByIndex_Impl(sal_Int32 nIndex) const
Definition: dapiuno.cxx:3097
ScDPSaveDimension::GetShowEmpty
bool GetShowEmpty() const
Definition: dpsave.hxx:158
ScDataPilotTableObj::Notify
virtual void Notify(SfxBroadcaster &rBC, const SfxHint &rHint) override
Definition: dapiuno.cxx:1236
ScDataPilotTableObj::removeModifyListener
virtual void SAL_CALL removeModifyListener(const css::uno::Reference< css::util::XModifyListener > &aListener) override
Definition: dapiuno.cxx:1212
ScDPObject::SetServiceData
void SetServiceData(const ScDPServiceDesc &rDesc)
Definition: dpobject.cxx:451
ScGeneralFunction
ScGeneralFunction
the css::sheet::GeneralFunction enum is extended by constants in GeneralFunction2, which causes some type-safety issues.
Definition: generalfunction.hxx:29
maName
OUString maName
ScDPSaveGroupDimension::RemoveFromGroups
void RemoveFromGroups(const OUString &rItemName)
Definition: dpdimsave.cxx:211
aName
OUString aName
ScDataPilotTablesObj::removeByName
virtual void SAL_CALL removeByName(const OUString &aName) override
Definition: dapiuno.cxx:443
SC_UNO_DP_ISVISIBLE
#define SC_UNO_DP_ISVISIBLE
Definition: unonames.hxx:602
ScDPSaveData::DimsType
std::vector< std::unique_ptr< ScDPSaveDimension > > DimsType
Definition: dpsave.hxx:239
SC_UNONAME_NAME
#define SC_UNONAME_NAME
Definition: unonames.hxx:231
ScDataPilotDescriptorBase::SetDPObject
virtual void SetDPObject(ScDPObject *pDPObj)=0
ScGeneralFunction::VAR
variance is calculated based on a sample.
ScGeneralFunction::COUNT
all values, including non-numerical values, are counted.
ScDPObject::GetSheetDesc
const ScSheetSourceDesc * GetSheetDesc() const
Definition: dpobject.hxx:156
ScDPSaveGroupDimension
Represents a new group dimension whose dimension ID is higher than the highest source dimension ID...
Definition: dpdimsave.hxx:91
lcl_GetOriginalName
static OUString lcl_GetOriginalName(const Reference< XNamed > &rDim)
Definition: dapiuno.cxx:382
ScGeneralFunction::NONE
nothing is calculated.
ScDataPilotFieldGroupsObj::createEnumeration
virtual css::uno::Reference< css::container::XEnumeration > SAL_CALL createEnumeration() override
Definition: dapiuno.cxx:2851
ScDocument::RemoveUnoObject
void RemoveUnoObject(SfxListener &rObject)
Definition: documen3.cxx:900
ScDataPilotDescriptorBase::GetDPObject
virtual ScDPObject * GetDPObject() const =0
ScDataPilotFieldObj::setFunction
void setFunction(ScGeneralFunction Function)
Definition: dapiuno.cxx:2018
ScDPSaveGroupItem::AddElement
void AddElement(const OUString &rName)
Definition: dpdimsave.cxx:44
ScDataPilotFieldGroupObj::setName
virtual void SAL_CALL setName(const OUString &aName) override
Definition: dapiuno.cxx:3052
nType
QPRO_FUNC_TYPE nType
Definition: qproform.cxx:400
ScDPSaveGroupDimension::GetNamedGroup
const ScDPSaveGroupItem * GetNamedGroup(const OUString &rGroupName) const
Definition: dpdimsave.cxx:183
ScDataPilotFieldsObj::ScDataPilotFieldsObj
ScDataPilotFieldsObj(ScDataPilotDescriptorBase &rParent)
Definition: dapiuno.cxx:1414
ScDPSaveDimension::GetAutoShowInfo
const css::sheet::DataPilotFieldAutoShowInfo * GetAutoShowInfo() const
Definition: dpsave.hxx:191
ScDPSaveNumGroupDimension::SetDateInfo
void SetDateInfo(const ScDPNumGroupInfo &rInfo, sal_Int32 nPart)
Definition: dpdimsave.cxx:531
aSeq
Sequence< sal_Int8 > aSeq
ScDocShell::GetDocument
const ScDocument & GetDocument() const
Definition: docsh.hxx:217
ScDataPilotFieldGroupObj::replaceByName
virtual void SAL_CALL replaceByName(const OUString &aName, const css::uno::Any &aElement) override
Definition: dapiuno.cxx:2954
ScDataPilotItemsObj::getByIndex
virtual css::uno::Any SAL_CALL getByIndex(sal_Int32 Index) override
Definition: dapiuno.cxx:3175
ScDataPilotFieldsObj::~ScDataPilotFieldsObj
virtual ~ScDataPilotFieldsObj() override
Definition: dapiuno.cxx:1425
ScDataPilotFieldGroupObj::getElementType
virtual css::uno::Type SAL_CALL getElementType() override
Definition: dapiuno.cxx:3032
ScDataPilotFieldObj::setAutoShowInfo
void setAutoShowInfo(const css::sheet::DataPilotFieldAutoShowInfo *pInfo)
Definition: dapiuno.cxx:2142
ScDataPilotFieldGroupsObj::getCount
virtual sal_Int32 SAL_CALL getCount() override
Definition: dapiuno.cxx:2835
ScDPDimensionSaveData::CollectDateParts
sal_Int32 CollectDateParts(const OUString &rBaseDimName) const
Definition: dpdimsave.cxx:699
ScDataPilotTableObj::getTag
virtual OUString SAL_CALL getTag() override
Definition: dapiuno.cxx:1092
ScImportParam::bImport
bool bImport
Definition: global.hxx:456
ScDPSaveData::SetColumnGrand
SC_DLLPUBLIC void SetColumnGrand(bool bSet)
Definition: dpsave.cxx:983
ScDataPilotChildObjBase::GetMembers
css::uno::Reference< css::sheet::XMembersAccess > GetMembers() const
Returns the collection of members for the field described by maFieldId.
Definition: dapiuno.cxx:1401
ScDataPilotFieldsObj::getCount
virtual sal_Int32 SAL_CALL getCount() override
Definition: dapiuno.cxx:1571
ScDataPilotDescriptorBase::getHiddenFields
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getHiddenFields() override
Definition: dapiuno.cxx:678
ScDataPilotFieldObj::getItems
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getItems() override
Definition: dapiuno.cxx:1923
ScGeneralFunction::MIN
minimum value of all numerical values is calculated.
SC_UNONAME_FUNCTION2
#define SC_UNONAME_FUNCTION2
Definition: unonames.hxx:255
SC_UNO_DP_SOURCESERVICE
#define SC_UNO_DP_SOURCESERVICE
Definition: unonames.hxx:627
aEntryName
char aEntryName[20]
SC_UNO_DP_SHOWFILTER
#define SC_UNO_DP_SHOWFILTER
Definition: unonames.hxx:625
ScGeneralFunction::STDEV
standard deviation is calculated based on a sample.
ScDPSaveNumGroupDimension::GetInfo
const ScDPNumGroupInfo & GetInfo() const
Definition: dpdimsave.hxx:151
ScDataPilotTablesObj::GetObjectByIndex_Impl
ScDataPilotTableObj * GetObjectByIndex_Impl(sal_Int32 nIndex)
Definition: dapiuno.cxx:325
ScDPSaveData::SetRowGrand
SC_DLLPUBLIC void SetRowGrand(bool bSet)
Definition: dpsave.cxx:988
ScDocument::AddUnoListenerCall
void AddUnoListenerCall(const css::uno::Reference< css::util::XModifyListener > &rListener, const css::lang::EventObject &rEvent)
Definition: documen3.cxx:971
SC_DATALAYOUT_NAME
#define SC_DATALAYOUT_NAME
Definition: dapiuno.cxx:192
ScDataPilotItemsObj::getElementType
virtual css::uno::Type SAL_CALL getElementType() override
Definition: dapiuno.cxx:3184
ScRangeList::front
ScRange & front()
Definition: rangelst.hxx:93
ScUnoConversion::FillApiRange
static void FillApiRange(css::table::CellRangeAddress &rApiRange, const ScRange &rScRange)
Definition: convuno.hxx:88
ScDataPilotTablesObj::insertNewByName
virtual void SAL_CALL insertNewByName(const OUString &aName, const css::table::CellAddress &aOutputAddress, const css::uno::Reference< css::sheet::XDataPilotDescriptor > &xDescriptor) override
Definition: dapiuno.cxx:405
ScDPDimensionSaveData::CreateDateGroupDimName
OUString CreateDateGroupDimName(sal_Int32 nDatePart, const ScDPObject &rObject, bool bAllowSource, const ::std::vector< OUString > *pDeletedNames)
Definition: dpdimsave.cxx:773
SAL_WARN
#define SAL_WARN(area, stream)
lcl_GetObjectIndex
static sal_Int32 lcl_GetObjectIndex(ScDPObject *pDPObj, const ScFieldIdentifier &rFieldId)
Definition: dapiuno.cxx:281
ScDataPilotTableObj::refresh
virtual void SAL_CALL refresh() override
Definition: dapiuno.cxx:1133
ScDataPilotFieldGroupObj::getName
virtual OUString SAL_CALL getName() override
Definition: dapiuno.cxx:3046
SC_UNO_DP_SHOWDETAILS
#define SC_UNO_DP_SHOWDETAILS
Definition: unonames.hxx:603
ScDocShell::GetBestViewShell
ScTabViewShell * GetBestViewShell(bool bOnlyVisible=true)
Definition: docsh4.cxx:2560
SC_UNO_DP_ISDATALAYOUT
#define SC_UNO_DP_ISDATALAYOUT
Definition: unonames.hxx:591
ScDPDimensionSaveData::GetNumGroupDim
const ScDPSaveNumGroupDimension * GetNumGroupDim(const OUString &rGroupDimName) const
Definition: dpdimsave.cxx:652
SC_UNONAME_HASREFERENCE
#define SC_UNONAME_HASREFERENCE
Definition: unonames.hxx:260
ScDataPilotTableObj::setName
virtual void SAL_CALL setName(const OUString &aName) override
Definition: dapiuno.cxx:1076
ScDataPilotDescriptorBase::getColumnFields
virtual css::uno::Reference< css::container::XIndexAccess > SAL_CALL getColumnFields() override
Definition: dapiuno.cxx:654
ScDataPilotFieldObj::setUseCurrentPage
void setUseCurrentPage(bool bUse)
Definition: dapiuno.cxx:2115
mnIndex
int mnIndex
SC_UNO_DP_OBJECTNAME
#define SC_UNO_DP_OBJECTNAME
Definition: unonames.hxx:632
ScDBDocFunc::RefreshPivotTableGroups
void RefreshPivotTableGroups(ScDPObject *pDPObj)
Refresh the group dimensions of all pivot tables referencing the same cache.
Definition: dbdocfun.cxx:1625
ScDataPilotItemObj::maPropSet
SfxItemPropertySet maPropSet
Definition: dapiuno.hxx:719
lcl_GetDPObject
static ScDPObject * lcl_GetDPObject(ScDocShell *pDocShell, SCTAB nTab, std::u16string_view rName)
Definition: dapiuno.cxx:248
ScUnoConversion::FillScRange
static void FillScRange(ScRange &rScRange, const css::table::CellRangeAddress &rApiRange)
Definition: convuno.hxx:80
ScDataPilotItemsObj::getElementNames
virtual css::uno::Sequence< OUString > SAL_CALL getElementNames() override
Definition: dapiuno.cxx:3128
ScDataPilotChildObjBase
Base class of all implementation objects based on a DataPilot descriptor or DataPilot table object...
Definition: dapiuno.hxx:303
ScDataPilotFieldObj::hasGroupInfo
bool hasGroupInfo() const
Definition: dapiuno.cxx:2243
ScDataPilotDescriptor::setName
virtual void SAL_CALL setName(const OUString &aName) override
Definition: dapiuno.cxx:1311
SC_UNONAME_HASLAYOUTINFO
#define SC_UNONAME_HASLAYOUTINFO
Definition: unonames.hxx:266
ScDataPilotTableObj::~ScDataPilotTableObj
virtual ~ScDataPilotTableObj() override
Definition: dapiuno.cxx:1008
ScSheetSourceDesc
This class contains authoritative information on the internal reference used as the data source for d...
Definition: dpshttab.hxx:39
ScDataPilotFieldObj::setLayoutInfo
void setLayoutInfo(const css::sheet::DataPilotFieldLayoutInfo *pInfo)
Definition: dapiuno.cxx:2160
ScDPSaveDimension::SetSubTotals
void SetSubTotals(std::vector< ScGeneralFunction > const &rFuncs)
Definition: dpsave.cxx:322
ScDataPilotFieldObj::ScDataPilotFieldObj
ScDataPilotFieldObj(ScDataPilotDescriptorBase &rParent, const ScFieldIdentifier &rIdent)
Definition: dapiuno.cxx:1641
ScDataPilotTableObj::getName
virtual OUString SAL_CALL getName() override
Definition: dapiuno.cxx:1067
ScDPSaveGroupDimension::AddGroupItem
void AddGroupItem(const ScDPSaveGroupItem &rItem)
Definition: dpdimsave.cxx:149
ScDPSaveData::GetDimensionByName
SC_DLLPUBLIC ScDPSaveDimension * GetDimensionByName(const OUString &rName)
Get a dimension object by its name.
Definition: dpsave.cxx:834
aEvent
AnyEventRef aEvent
SC_UNONAME_ISGROUP
#define SC_UNONAME_ISGROUP
Definition: unonames.hxx:268
ScDataPilotChildObjBase::GetDPDimension
ScDPSaveDimension * GetDPDimension(ScDPObject **ppDPObject=nullptr) const
Returns the DataPilot dimension object related to the field described by maFieldId.
Definition: dapiuno.cxx:1354
ScDataPilotDescriptorBase::addVetoableChangeListener
virtual void SAL_CALL addVetoableChangeListener(const OUString &PropertyName, const css::uno::Reference< css::beans::XVetoableChangeListener > &aListener) override
Definition: dapiuno.cxx:949
ScDataPilotFieldGroupsObj::renameFieldGroup
void renameFieldGroup(const OUString &rOldName, const OUString &rNewName)
Definition: dapiuno.cxx:2882
ScDPSaveDimension::GetReferenceValue
const css::sheet::DataPilotFieldReference * GetReferenceValue() const
Definition: dpsave.hxx:182
nPos
sal_uInt16 nPos
ScDataPilotFieldObj::getFunction
sal_Int16 getFunction() const
Definition: dapiuno.cxx:1998
SCTAB
sal_Int16 SCTAB
Definition: types.hxx:23
ScDPSaveGroupDimension::SetDateInfo
void SetDateInfo(const ScDPNumGroupInfo &rInfo, sal_Int32 nPart)
Definition: dpdimsave.cxx:143
ScDPSaveGroupDimension::CreateGroupName
OUString CreateGroupName(std::u16string_view rPrefix)
Definition: dpdimsave.cxx:154
SC_UNONAME_REPEATITEMLABELS
#define SC_UNONAME_REPEATITEMLABELS
Definition: unonames.hxx:271
cppu::any2bool
bool any2bool(const css::uno::Any &rAny)
nValue
sal_Int16 nValue
ScDataPilotItemObj::removePropertyChangeListener
virtual void SAL_CALL removePropertyChangeListener(const OUString &aPropertyName, const css::uno::Reference< css::beans::XPropertyChangeListener > &aListener) override
Definition: dapiuno.cxx:3352
ScDataPilotDescriptor::SetDPObject
virtual void SetDPObject(ScDPObject *pDPObj) override
Definition: dapiuno.cxx:1294
ScDataPilotTableObj::GetDPObject
virtual ScDPObject * GetDPObject() const override
Definition: dapiuno.cxx:1049
ScDPObject::GetPositionData
void GetPositionData(const ScAddress &rPos, css::sheet::DataPilotTablePositionData &rPosData)
Definition: dpobject.cxx:1134
ScDBDocFunc::CreatePivotTable
bool CreatePivotTable(const ScDPObject &rDPObj, bool bRecord, bool bApi)
Definition: dbdocfun.cxx:1422
ScDataPilotItemObj::mnIndex
sal_Int32 mnIndex
Definition: dapiuno.hxx:720
ScDataPilotTablesObj::GetObjectByName_Impl
ScDataPilotTableObj * GetObjectByName_Impl(const OUString &aName)
Definition: dapiuno.cxx:353
ScFieldIdentifier::maFieldName
OUString maFieldName
Definition: dapiuno.hxx:290
Generated on Thu Jan 14 2021 06:09:22 for LibreOffice Module sc (master) by   doxygen 1.8.10