sc/source/ui/dbgui/PivotLayoutDialog.cxx

   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
  12 #include "PivotLayoutTreeList.hxx"
  13 #include "PivotLayoutDialog.hxx"
  14 #include <reffact.hxx>
  15 #include <svtools/treelistentry.hxx>
  16
  17 #include "rangeutl.hxx"
  18 #include "uiitems.hxx"
  19 #include "dputil.hxx"
  20
  21 #include <vector>
  22
  23 #include <com/sun/star/sheet/DataPilotFieldOrientation.hpp>
  24 #include <com/sun/star/sheet/DataPilotFieldSortMode.hpp>
  25
  26 using namespace css::uno;
  27 using namespace css::sheet;
  28
  29 ScItemValue::ScItemValue(OUString const & aName, SCCOL nColumn, sal_uInt16 nFunctionMask) :
  30     maName(aName),
  31     maFunctionData(nColumn, nFunctionMask),
  32     mpOriginalItemValue(this)
  33 {}
  34
  35 ScItemValue::ScItemValue(ScItemValue* pInputItemValue) :
  36     maName(pInputItemValue->maName),
  37     maFunctionData(pInputItemValue->maFunctionData),
  38     mpOriginalItemValue(this)
  39 {}
  40
  41 ScItemValue::~ScItemValue()
  42 {}
  43
  44 namespace
  45 {
  46
  47 ScRange lclGetRangeForNamedRange(OUString const & aName, ScDocument* pDocument)
  48 {
  49     ScRange aInvalidRange(ScAddress::INITIALIZE_INVALID);
  50     ScRangeName* pRangeName = pDocument->GetRangeName();
  51     if (pRangeName == NULL)
  52         return aInvalidRange;
  53
  54     const ScRangeData* pData = pRangeName->findByUpperName(aName.toAsciiUpperCase());
  55     if (pData == NULL)
  56         return aInvalidRange;
  57
  58     ScRange aRange;
  59     if (pData->IsReference(aRange))
  60         return aRange;
  61
  62     return aInvalidRange;
  63 }
  64
  65 }
  66
  67 ScPivotLayoutDialog::ScPivotLayoutDialog(
  68                             SfxBindings* pSfxBindings, SfxChildWindow* pChildWindow, vcl::Window* pParent,
  69                             ScViewData* pViewData, const ScDPObject* pPivotTableObject, bool bNewPivotTable) :
  70     ScAnyRefDlg           (pSfxBindings, pChildWindow, pParent, "PivotTableLayout", "modules/scalc/ui/pivottablelayoutdialog.ui"),
  71     maPivotTableObject    (*pPivotTableObject),
  72     mpPreviouslyFocusedListBox(NULL),
  73     mpCurrentlyFocusedListBox(NULL),
  74     mpViewData            (pViewData),
  75     mpDocument            (pViewData->GetDocument()),
  76     mbNewPivotTable       (bNewPivotTable),
  77     mpActiveEdit          (NULL),
  78     maAddressDetails      (mpDocument->GetAddressConvention(), 0, 0),
  79     mbDialogLostFocus     (false)
  80 {
  81     Link<> aLink;
  82
  83     get(mpListBoxField,    "listbox-fields");
  84     get(mpListBoxPage,     "listbox-page");
  85     get(mpListBoxColumn,   "listbox-column");
  86     get(mpListBoxRow,      "listbox-row");
  87     get(mpListBoxData,     "listbox-data");
  88
  89     get(mpCheckIgnoreEmptyRows,     "check-ignore-empty-rows");
  90     get(mpCheckTotalColumns,        "check-total-columns");
  91     get(mpCheckAddFilter,           "check-add-filter");
  92     get(mpCheckIdentifyCategories,  "check-identify-categories");
  93     get(mpCheckTotalRows,           "check-total-rows");
  94     get(mpCheckDrillToDetail,       "check-drill-to-details");
  95
  96     get(mpBtnOK,  "ok");
  97     get(mpBtnCancel,  "cancel");
  98
  99     get(mpSourceRadioNamedRange, "source-radio-named-range");
 100     get(mpSourceRadioSelection,  "source-radio-selection");
 101     get(mpSourceListBox,         "source-list");
 102     get(mpSourceEdit,            "source-edit");
 103     get(mpSourceButton,          "source-button");
 104
 105     get(mpDestinationRadioNewSheet,   "destination-radio-new-sheet");
 106     get(mpDestinationRadioNamedRange, "destination-radio-named-range");
 107     get(mpDestinationRadioSelection,  "destination-radio-selection");
 108     get(mpDestinationListBox,         "destination-list");
 109     get(mpDestinationEdit,            "destination-edit");
 110     get(mpDestinationButton,          "destination-button");
 111
 112     // Source UI
 113     aLink = LINK(this, ScPivotLayoutDialog, ToggleSource);
 114     mpSourceRadioNamedRange->SetToggleHdl(aLink);
 115     mpSourceRadioSelection->SetToggleHdl(aLink);
 116
 117     mpSourceEdit->SetReferences(this, mpSourceRadioSelection);
 118     mpSourceButton->SetReferences(this, mpSourceEdit);
 119
 120     aLink = LINK(this, ScPivotLayoutDialog, GetFocusHandler);
 121     mpSourceEdit->SetGetFocusHdl(aLink);
 122     mpSourceButton->SetGetFocusHdl(aLink);
 123
 124     aLink = LINK(this, ScPivotLayoutDialog, LoseFocusHandler);
 125     mpSourceEdit->SetLoseFocusHdl(aLink);
 126     mpSourceButton->SetLoseFocusHdl(aLink);
 127
 128     mpSourceEdit->SetModifyHdl(LINK(this, ScPivotLayoutDialog, SourceEditModified));
 129     mpSourceListBox->SetSelectHdl(LINK(this, ScPivotLayoutDialog, SourceEditModified));
 130
 131     // Destination UI
 132     aLink = LINK(this, ScPivotLayoutDialog, ToggleDestination);
 133     mpDestinationRadioNewSheet->SetToggleHdl(aLink);
 134     mpDestinationRadioNamedRange->SetToggleHdl(aLink);
 135     mpDestinationRadioSelection->SetToggleHdl(aLink);
 136
 137     mpDestinationEdit->SetReferences(this, mpDestinationRadioNewSheet);
 138     mpDestinationButton->SetReferences(this, mpDestinationEdit);
 139
 140     aLink = LINK(this, ScPivotLayoutDialog, GetFocusHandler);
 141     mpDestinationEdit->SetGetFocusHdl(aLink);
 142     mpDestinationButton->SetGetFocusHdl(aLink);
 143
 144     aLink = LINK(this, ScPivotLayoutDialog, LoseFocusHandler);
 145     mpDestinationEdit->SetLoseFocusHdl(aLink);
 146     mpDestinationButton->SetLoseFocusHdl(aLink);
 147
 148     // Buttons
 149     mpBtnCancel->SetClickHdl(LINK(this, ScPivotLayoutDialog, CancelClicked));
 150     mpBtnOK->SetClickHdl(LINK(this, ScPivotLayoutDialog, OKClicked));
 151
 152     // Initialize Data
 153     maPivotTableObject.FillOldParam(maPivotParameters);
 154     maPivotTableObject.FillLabelData(maPivotParameters);
 155
 156     mpListBoxField->Setup (this);
 157     mpListBoxPage->Setup  (this, ScPivotLayoutTreeList::PAGE_LIST);
 158     mpListBoxColumn->Setup(this, ScPivotLayoutTreeList::COLUMN_LIST);
 159     mpListBoxRow->Setup   (this, ScPivotLayoutTreeList::ROW_LIST);
 160     mpListBoxData->Setup  (this);
 161
 162     FillValuesToListBoxes();
 163
 164     // Initialize Options
 165     const ScDPSaveData* pSaveData = maPivotTableObject.GetSaveData();
 166     if (pSaveData == NULL)
 167     {
 168         mpCheckAddFilter->Check(false);
 169         mpCheckDrillToDetail->Check(false);
 170     }
 171     else
 172     {
 173         mpCheckAddFilter->Check(pSaveData->GetFilterButton());
 174         mpCheckDrillToDetail->Check(pSaveData->GetDrillDown());
 175     }
 176
 177     mpCheckIgnoreEmptyRows->Check(maPivotParameters.bIgnoreEmptyRows);
 178     mpCheckIdentifyCategories->Check(maPivotParameters.bDetectCategories);
 179     mpCheckTotalColumns->Check(maPivotParameters.bMakeTotalCol);
 180     mpCheckTotalRows->Check(maPivotParameters.bMakeTotalRow);
 181
 182     SetupSource();
 183     SetupDestination();
 184 }
 185
 186 ScPivotLayoutDialog::~ScPivotLayoutDialog()
 187 {
 188     disposeOnce();
 189 }
 190
 191 void ScPivotLayoutDialog::dispose()
 192 {
 193     mpPreviouslyFocusedListBox.clear();
 194     mpCurrentlyFocusedListBox.clear();
 195     mpListBoxField.clear();
 196     mpListBoxPage.clear();
 197     mpListBoxColumn.clear();
 198     mpListBoxRow.clear();
 199     mpListBoxData.clear();
 200     mpCheckIgnoreEmptyRows.clear();
 201     mpCheckTotalColumns.clear();
 202     mpCheckAddFilter.clear();
 203     mpCheckIdentifyCategories.clear();
 204     mpCheckTotalRows.clear();
 205     mpCheckDrillToDetail.clear();
 206     mpSourceRadioNamedRange.clear();
 207     mpSourceRadioSelection.clear();
 208     mpSourceListBox.clear();
 209     mpSourceEdit.clear();
 210     mpSourceButton.clear();
 211     mpDestinationRadioNewSheet.clear();
 212     mpDestinationRadioNamedRange.clear();
 213     mpDestinationRadioSelection.clear();
 214     mpDestinationListBox.clear();
 215     mpDestinationEdit.clear();
 216     mpDestinationButton.clear();
 217     mpBtnOK.clear();
 218     mpBtnCancel.clear();
 219     mpActiveEdit.clear();
 220     ScAnyRefDlg::dispose();
 221 }
 222
 223 void ScPivotLayoutDialog::SetupSource()
 224 {
 225     mpSourceListBox->Clear();
 226
 227     ScRange aSourceRange;
 228     OUString sSourceNamedRangeName;
 229
 230     if (maPivotTableObject.GetSheetDesc())
 231     {
 232         const ScSheetSourceDesc* pSheetSourceDesc = maPivotTableObject.GetSheetDesc();
 233         aSourceRange = pSheetSourceDesc->GetSourceRange();
 234
 235         if(!aSourceRange.IsValid())
 236         {
 237             // Source is probably a DB Range
 238             mpSourceRadioNamedRange->Disable();
 239             mpSourceRadioSelection->Disable();
 240             ToggleSource(NULL);
 241             return;
 242         }
 243         else
 244         {
 245             OUString aSourceRangeName = aSourceRange.Format(SCR_ABS_3D, mpDocument, maAddressDetails);
 246             mpSourceEdit->SetText(aSourceRangeName);
 247         }
 248     }
 249     else
 250     {
 251         mpSourceRadioNamedRange->Disable();
 252         mpSourceRadioSelection->Disable();
 253         ToggleSource(NULL);
 254         return;
 255     }
 256
 257     // Setup Named Ranges
 258     bool bIsNamedRange = false;
 259
 260     ScAreaNameIterator aIterator(mpDocument);
 261     OUString aEachName;
 262     ScRange aEachRange;
 263
 264     while (aIterator.Next(aEachName, aEachRange))
 265     {
 266         if (!aIterator.WasDBName())
 267         {
 268             mpSourceListBox->InsertEntry(aEachName);
 269             if (aEachRange == aSourceRange)
 270             {
 271                 sSourceNamedRangeName = aEachName;
 272                 bIsNamedRange = true;
 273             }
 274         }
 275     }
 276
 277     if (bIsNamedRange)
 278     {
 279         mpSourceListBox->SelectEntry(sSourceNamedRangeName, true);
 280         mpSourceRadioNamedRange->Check(true);
 281     }
 282     else
 283     {
 284         mpSourceListBox->SelectEntryPos(0, true);
 285         mpSourceRadioSelection->Check(true);
 286     }
 287
 288     // If entries - select first entry, otherwise disable the radio button.
 289     if (mpSourceListBox->GetEntryCount() <= 0)
 290         mpSourceRadioNamedRange->Disable();
 291
 292     ToggleSource(NULL);
 293 }
 294
 295 void ScPivotLayoutDialog::SetupDestination()
 296 {
 297     mpDestinationListBox->Clear();
 298
 299     // Fill up named ranges
 300     ScAreaNameIterator aIterator(mpDocument);
 301     OUString aName;
 302     ScRange aRange;
 303
 304     while (aIterator.Next(aName, aRange))
 305     {
 306         if (!aIterator.WasDBName())
 307         {
 308             mpDestinationListBox->InsertEntry(aName);
 309         }
 310     }
 311
 312     // If entries - select first entry, otherwise disable the radio button.
 313     if (mpDestinationListBox->GetEntryCount() > 0)
 314         mpDestinationListBox->SelectEntryPos(0, true);
 315     else
 316         mpDestinationRadioNamedRange->Disable();
 317
 318     //
 319     if (mbNewPivotTable)
 320     {
 321         mpDestinationRadioNewSheet->Check(true);
 322     }
 323     else
 324     {
 325         if (maPivotParameters.nTab != MAXTAB + 1)
 326         {
 327             ScAddress aAddress(maPivotParameters.nCol, maPivotParameters.nRow, maPivotParameters.nTab);
 328             OUString aAddressString = aAddress.Format(SCA_VALID | SCA_TAB_3D | SCA_COL_ABSOLUTE | SCA_ROW_ABSOLUTE | SCA_TAB_ABSOLUTE, mpDocument, maAddressDetails);
 329             mpDestinationEdit->SetText(aAddressString);
 330             mpDestinationRadioSelection->Check(true);
 331         }
 332     }
 333
 334     ToggleDestination(NULL);
 335 }
 336
 337 void ScPivotLayoutDialog::FillValuesToListBoxes()
 338 {
 339     mpListBoxField->FillLabelFields(maPivotParameters.maLabelArray);
 340     mpListBoxData->FillDataField(maPivotParameters.maDataFields);
 341     mpListBoxColumn->FillFields(maPivotParameters.maColFields);
 342     mpListBoxRow->FillFields(maPivotParameters.maRowFields);
 343     mpListBoxPage->FillFields(maPivotParameters.maPageFields);
 344 }
 345
 346 void ScPivotLayoutDialog::SetActive()
 347 {
 348     if (mbDialogLostFocus)
 349     {
 350         mbDialogLostFocus = false;
 351         if(mpActiveEdit != nullptr)
 352         {
 353             mpActiveEdit->GrabFocus();
 354             if (mpActiveEdit == mpSourceEdit)
 355                 UpdateSourceRange();
 356         }
 357     }
 358     else
 359     {
 360         GrabFocus();
 361     }
 362
 363     RefInputDone();
 364 }
 365
 366 void ScPivotLayoutDialog::SetReference(const ScRange& rReferenceRange, ScDocument* pDocument)
 367 {
 368     if (!mbDialogLostFocus)
 369         return;
 370
 371     if (mpActiveEdit == nullptr)
 372         return;
 373
 374     if (rReferenceRange.aStart != rReferenceRange.aEnd)
 375         RefInputStart(mpActiveEdit);
 376
 377     OUString aReferenceString = rReferenceRange.Format(SCR_ABS_3D, pDocument, maAddressDetails);
 378
 379     if (mpActiveEdit == mpSourceEdit)
 380     {
 381         mpSourceEdit->SetRefString(aReferenceString);
 382     }
 383     else if (mpActiveEdit == mpDestinationEdit)
 384     {
 385         mpDestinationEdit->SetRefString(aReferenceString);
 386     }
 387 }
 388
 389 bool ScPivotLayoutDialog::IsRefInputMode() const
 390 {
 391     return mbDialogLostFocus;
 392 }
 393
 394 void ScPivotLayoutDialog::ItemInserted(ScItemValue* pItemValue, ScPivotLayoutTreeList::SvPivotTreeListType eType)
 395 {
 396     if (pItemValue == NULL)
 397         return;
 398
 399     switch (eType)
 400     {
 401         case ScPivotLayoutTreeList::ROW_LIST:
 402         case ScPivotLayoutTreeList::COLUMN_LIST:
 403         case ScPivotLayoutTreeList::PAGE_LIST:
 404         {
 405             mpListBoxRow->RemoveEntryForItem(pItemValue);
 406             mpListBoxColumn->RemoveEntryForItem(pItemValue);
 407             mpListBoxPage->RemoveEntryForItem(pItemValue);
 408         }
 409         case ScPivotLayoutTreeList::LABEL_LIST:
 410         {
 411             mpListBoxRow->RemoveEntryForItem(pItemValue);
 412             mpListBoxColumn->RemoveEntryForItem(pItemValue);
 413             mpListBoxPage->RemoveEntryForItem(pItemValue);
 414             mpListBoxData->RemoveEntryForItem(pItemValue);
 415         }
 416         break;
 417         default:
 418             break;
 419     }
 420 }
 421
 422 void ScPivotLayoutDialog::UpdateSourceRange()
 423 {
 424     if (!maPivotTableObject.GetSheetDesc())
 425        return;
 426
 427     ScSheetSourceDesc aSourceSheet = *maPivotTableObject.GetSheetDesc();
 428
 429     if (mpSourceRadioNamedRange->IsChecked())
 430     {
 431         OUString aEntryString = mpSourceListBox->GetSelectEntry();
 432         ScRange aSourceRange = lclGetRangeForNamedRange(aEntryString, mpDocument);
 433         if (!aSourceRange.IsValid() || aSourceSheet.GetSourceRange() == aSourceRange)
 434             return;
 435         aSourceSheet.SetRangeName(aEntryString);
 436     }
 437     else if (mpSourceRadioSelection->IsChecked())
 438     {
 439         OUString aSourceString = mpSourceEdit->GetText();
 440         ScRange aSourceRange;
 441         sal_uInt16 nResult = aSourceRange.Parse(aSourceString, mpDocument, maAddressDetails);
 442
 443         bool bIsValid = (nResult & SCA_VALID) == SCA_VALID; // aSourceString is valid
 444
 445         mpSourceEdit->SetRefValid(true);
 446
 447         if (bIsValid)
 448         {
 449             ScRefAddress aStart;
 450             ScRefAddress aEnd;
 451
 452             ConvertDoubleRef(mpDocument, aSourceString, 1, aStart, aEnd, maAddressDetails);
 453             aSourceRange.aStart = aStart.GetAddress();
 454             aSourceRange.aEnd = aEnd.GetAddress();
 455         }
 456         else
 457         {
 458             aSourceRange = lclGetRangeForNamedRange(aSourceString, mpDocument);
 459         }
 460
 461         if (!aSourceRange.IsValid())
 462         {
 463             mpSourceEdit->SetRefValid(false);
 464             return;
 465         }
 466
 467         if (aSourceSheet.GetSourceRange() == aSourceRange)
 468                 return;
 469
 470         aSourceSheet.SetSourceRange(aSourceRange);
 471         if (aSourceSheet.CheckSourceRange() != 0)
 472         {
 473             mpSourceEdit->SetRefValid(false);
 474             return;
 475         }
 476     }
 477     else
 478     {
 479         return;
 480     }
 481
 482     maPivotTableObject.SetSheetDesc(aSourceSheet);
 483     maPivotTableObject.FillOldParam(maPivotParameters);
 484     maPivotTableObject.FillLabelData(maPivotParameters);
 485
 486     FillValuesToListBoxes();
 487 }
 488
 489 bool ScPivotLayoutDialog::ApplyChanges()
 490 {
 491     ScDPSaveData aSaveData;
 492     ApplySaveData(aSaveData);
 493     ApplyLabelData(aSaveData);
 494
 495     ScRange aDestinationRange;
 496     bool bToNewSheet = false;
 497
 498     if (!GetDestination(aDestinationRange, bToNewSheet))
 499         return false;
 500
 501     SetDispatcherLock(false);
 502     SwitchToDocument();
 503
 504     sal_uInt16 nWhichPivot = SC_MOD()->GetPool().GetWhich(SID_PIVOT_TABLE);
 505     ScPivotItem aPivotItem(nWhichPivot, &aSaveData, &aDestinationRange, bToNewSheet);
 506     mpViewData->GetViewShell()->SetDialogDPObject(&maPivotTableObject);
 507
 508     SfxDispatcher* pDispatcher = GetBindings().GetDispatcher();
 509     SfxCallMode nCallMode = SfxCallMode::SLOT | SfxCallMode::RECORD;
 510     const SfxPoolItem* pResult = pDispatcher->Execute(SID_PIVOT_TABLE, nCallMode, &aPivotItem, NULL, 0);
 511
 512     if (pResult != NULL)
 513     {
 514         const SfxBoolItem* pItem = reinterpret_cast<const SfxBoolItem*>(pResult);
 515         if (pItem)
 516         {
 517             return pItem->GetValue();
 518         }
 519     }
 520
 521     SetDispatcherLock(true);
 522     return true;
 523 }
 524
 525 void ScPivotLayoutDialog::ApplySaveData(ScDPSaveData& rSaveData)
 526 {
 527     rSaveData.SetIgnoreEmptyRows(mpCheckIgnoreEmptyRows->IsChecked());
 528     rSaveData.SetRepeatIfEmpty(mpCheckIdentifyCategories->IsChecked());
 529     rSaveData.SetColumnGrand(mpCheckTotalColumns->IsChecked());
 530     rSaveData.SetRowGrand(mpCheckTotalRows->IsChecked());
 531     rSaveData.SetFilterButton(mpCheckAddFilter->IsChecked());
 532     rSaveData.SetDrillDown(mpCheckDrillToDetail->IsChecked());
 533
 534     Reference<XDimensionsSupplier> xSource = maPivotTableObject.GetSource();
 535
 536     ScPivotFieldVector aPageFieldVector;
 537     mpListBoxPage->PushEntriesToPivotFieldVector(aPageFieldVector);
 538     ScDPObject::ConvertOrientation(rSaveData, aPageFieldVector, DataPilotFieldOrientation_PAGE,
 539                                    xSource, maPivotParameters.maLabelArray);
 540
 541     ScPivotFieldVector aColFieldVector;
 542     mpListBoxColumn->PushEntriesToPivotFieldVector(aColFieldVector);
 543     ScDPObject::ConvertOrientation(rSaveData, aColFieldVector, DataPilotFieldOrientation_COLUMN,
 544                                    xSource, maPivotParameters.maLabelArray);
 545
 546     ScPivotFieldVector aRowFieldVector;
 547     mpListBoxRow->PushEntriesToPivotFieldVector(aRowFieldVector);
 548     ScDPObject::ConvertOrientation(rSaveData, aRowFieldVector, DataPilotFieldOrientation_ROW,
 549                                    xSource, maPivotParameters.maLabelArray);
 550
 551     ScPivotFieldVector aDataFieldVector;
 552     mpListBoxData->PushEntriesToPivotFieldVector(aDataFieldVector);
 553     ScDPObject::ConvertOrientation(rSaveData, aDataFieldVector, DataPilotFieldOrientation_DATA,
 554                                    xSource, maPivotParameters.maLabelArray,
 555                                    &aColFieldVector, &aRowFieldVector, &aPageFieldVector);
 556 }
 557
 558 void ScPivotLayoutDialog::ApplyLabelData(ScDPSaveData& rSaveData)
 559 {
 560     ScDPLabelDataVector::const_iterator it;
 561     ScDPLabelDataVector& rLabelDataVector = GetLabelDataVector();
 562
 563     for (it = rLabelDataVector.begin(); it != rLabelDataVector.end(); ++it)
 564     {
 565         const ScDPLabelData& pLabelData = *it;
 566
 567         OUString aUnoName = ScDPUtil::createDuplicateDimensionName(pLabelData.maName, pLabelData.mnDupCount);
 568         ScDPSaveDimension* pSaveDimensions = rSaveData.GetExistingDimensionByName(aUnoName);
 569
 570         if (pSaveDimensions == NULL)
 571             continue;
 572
 573         pSaveDimensions->SetUsedHierarchy(pLabelData.mnUsedHier);
 574         pSaveDimensions->SetShowEmpty(pLabelData.mbShowAll);
 575         pSaveDimensions->SetRepeatItemLabels(pLabelData.mbRepeatItemLabels);
 576         pSaveDimensions->SetSortInfo(&pLabelData.maSortInfo);
 577         pSaveDimensions->SetLayoutInfo(&pLabelData.maLayoutInfo);
 578         pSaveDimensions->SetAutoShowInfo(&pLabelData.maShowInfo);
 579
 580         bool bManualSort = (pLabelData.maSortInfo.Mode == DataPilotFieldSortMode::MANUAL);
 581
 582         std::vector<ScDPLabelData::Member>::const_iterator itMember;
 583         for (itMember = pLabelData.maMembers.begin(); itMember != pLabelData.maMembers.end(); ++itMember)
 584         {
 585             const ScDPLabelData::Member& rLabelMember = *itMember;
 586             ScDPSaveMember* pMember = pSaveDimensions->GetMemberByName(rLabelMember.maName);
 587
 588             if (bManualSort || !rLabelMember.mbVisible || !rLabelMember.mbShowDetails)
 589             {
 590                 pMember->SetIsVisible(rLabelMember.mbVisible);
 591                 pMember->SetShowDetails(rLabelMember.mbShowDetails);
 592             }
 593         }
 594     }
 595 }
 596
 597 bool ScPivotLayoutDialog::GetDestination(ScRange& aDestinationRange, bool& bToNewSheet)
 598 {
 599     bToNewSheet = false;
 600
 601     if (mpDestinationRadioNamedRange->IsChecked())
 602     {
 603         OUString aName = mpDestinationListBox->GetSelectEntry();
 604         aDestinationRange = lclGetRangeForNamedRange(aName, mpDocument);
 605         if (!aDestinationRange.IsValid())
 606             return false;
 607     }
 608     else if (mpDestinationRadioSelection->IsChecked())
 609     {
 610         ScAddress aAddress;
 611         aAddress.Parse(mpDestinationEdit->GetText(), mpDocument, maAddressDetails);
 612         aDestinationRange = ScRange(aAddress);
 613     }
 614     else
 615     {
 616         bToNewSheet = true;
 617         aDestinationRange = ScRange(maPivotParameters.nCol, maPivotParameters.nRow, maPivotParameters.nTab);
 618     }
 619     return true;
 620 }
 621
 622 ScItemValue* ScPivotLayoutDialog::GetItem(SCCOL nColumn)
 623 {
 624     return mpListBoxField->GetItem(nColumn);
 625 }
 626
 627 bool ScPivotLayoutDialog::IsDataElement(SCCOL nColumn)
 628 {
 629     return mpListBoxField->IsDataElement(nColumn);
 630 }
 631
 632 ScDPLabelData* ScPivotLayoutDialog::GetLabelData(SCCOL nColumn)
 633 {
 634     return &maPivotParameters.maLabelArray[nColumn];
 635 }
 636
 637 void ScPivotLayoutDialog::PushDataFieldNames(std::vector<ScDPName>& rDataFieldNames)
 638 {
 639     return mpListBoxData->PushDataFieldNames(rDataFieldNames);
 640 }
 641
 642 bool ScPivotLayoutDialog::Close()
 643 {
 644     return DoClose( ScPivotLayoutWrapper::GetChildWindowId() );
 645 }
 646
 647 IMPL_LINK( ScPivotLayoutDialog, OKClicked, PushButton*, /*pButton*/ )
 648 {
 649     ApplyChanges();
 650     Close();
 651     return 0;
 652 }
 653
 654 IMPL_LINK( ScPivotLayoutDialog, CancelClicked, PushButton*, /*pButton*/ )
 655 {
 656     Close();
 657     return 0;
 658 }
 659
 660 IMPL_LINK(ScPivotLayoutDialog, GetFocusHandler, Control*, pCtrl)
 661 {
 662     mpActiveEdit = NULL;
 663
 664     if (pCtrl == (Control*) mpSourceEdit  ||
 665         pCtrl == (Control*) mpSourceButton)
 666     {
 667         mpActiveEdit = mpSourceEdit;
 668     }
 669     else if (pCtrl == (Control*) mpDestinationEdit  ||
 670              pCtrl == (Control*) mpDestinationButton)
 671     {
 672         mpActiveEdit = mpDestinationEdit;
 673     }
 674
 675     if (mpActiveEdit)
 676         mpActiveEdit->SetSelection(Selection(0, SELECTION_MAX));
 677
 678     return 0;
 679 }
 680
 681 IMPL_LINK_NOARG(ScPivotLayoutDialog, LoseFocusHandler)
 682 {
 683     mbDialogLostFocus = !IsActive();
 684     return 0;
 685 }
 686
 687 IMPL_LINK_NOARG(ScPivotLayoutDialog, SourceEditModified)
 688 {
 689     UpdateSourceRange();
 690     return 0;
 691 }
 692
 693 IMPL_LINK_NOARG(ScPivotLayoutDialog, ToggleSource)
 694 {
 695     bool bNamedRange = mpSourceRadioNamedRange->IsChecked();
 696     bool bSelection = mpSourceRadioSelection->IsChecked();
 697     mpSourceListBox->Enable(bNamedRange);
 698     mpSourceButton->Enable(bSelection);
 699     mpSourceEdit->Enable(bSelection);
 700     UpdateSourceRange();
 701     return 0;
 702 }
 703
 704 IMPL_LINK_NOARG(ScPivotLayoutDialog, ToggleDestination)
 705 {
 706     bool bNamedRange = mpDestinationRadioNamedRange->IsChecked();
 707     bool bSelection = mpDestinationRadioSelection->IsChecked();
 708     mpDestinationListBox->Enable(bNamedRange);
 709     mpDestinationButton->Enable(bSelection);
 710     mpDestinationEdit->Enable(bSelection);
 711     return 0;
 712 }
 713
 714 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */