sc/source/ui/StatisticsDialogs/StatisticsTwoVariableDialog.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  */
  10
  11 #include <sfx2/dispatch.hxx>
  12 #include <svl/zforlist.hxx>
  13 #include <svl/undo.hxx>
  14
  15 #include "formulacell.hxx"
  16 #include "rangelst.hxx"
  17 #include "scitems.hxx"
  18 #include "docsh.hxx"
  19 #include "document.hxx"
  20 #include "uiitems.hxx"
  21 #include "reffact.hxx"
  22 #include "scresid.hxx"
  23 #include "docfunc.hxx"
  24 #include "strload.hxx"
  25
  26 #include "StatisticsTwoVariableDialog.hxx"
  27
  28 ScStatisticsTwoVariableDialog::ScStatisticsTwoVariableDialog(
  29                     SfxBindings* pSfxBindings, SfxChildWindow* pChildWindow,
  30                     vcl::Window* pParent, ScViewData* pViewData, const OUString& rID, const OUString& rUIXMLDescription ) :
  31     ScAnyRefDlg     ( pSfxBindings, pChildWindow, pParent, rID, rUIXMLDescription ),
  32     mViewData       ( pViewData ),
  33     mDocument       ( pViewData->GetDocument() ),
  34     mVariable1Range ( ScAddress::INITIALIZE_INVALID ),
  35     mVariable2Range ( ScAddress::INITIALIZE_INVALID ),
  36     mAddressDetails ( mDocument->GetAddressConvention(), 0, 0 ),
  37     mOutputAddress  ( ScAddress::INITIALIZE_INVALID ),
  38     mGroupedBy      ( BY_COLUMN ),
  39     mpActiveEdit    ( NULL ),
  40     mCurrentAddress ( pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo() ),
  41     mDialogLostFocus( false )
  42 {
  43     get(mpVariable1RangeLabel,  "variable1-range-label");
  44     get(mpVariable1RangeEdit,   "variable1-range-edit");
  45     get(mpVariable1RangeButton, "variable1-range-button");
  46     mpVariable1RangeEdit->SetReferences(this, mpVariable1RangeLabel);
  47     mpVariable1RangeButton->SetReferences(this, mpVariable1RangeEdit);
  48
  49     get(mpVariable2RangeLabel,  "variable2-range-label");
  50     get(mpVariable2RangeEdit,   "variable2-range-edit");
  51     get(mpVariable2RangeButton, "variable2-range-button");
  52     mpVariable2RangeEdit->SetReferences(this, mpVariable2RangeLabel);
  53     mpVariable2RangeButton->SetReferences(this, mpVariable2RangeEdit);
  54
  55     get(mpOutputRangeLabel,  "output-range-label");
  56     get(mpOutputRangeEdit,   "output-range-edit");
  57     get(mpOutputRangeButton, "output-range-button");
  58     mpOutputRangeEdit->SetReferences(this, mpOutputRangeLabel);
  59     mpOutputRangeButton->SetReferences(this, mpOutputRangeEdit);
  60
  61     get(mpButtonOk,     "ok");
  62
  63     get(mpGroupByColumnsRadio,   "groupedby-columns-radio");
  64     get(mpGroupByRowsRadio,      "groupedby-rows-radio");
  65
  66     Init();
  67     GetRangeFromSelection();
  68 }
  69
  70 ScStatisticsTwoVariableDialog::~ScStatisticsTwoVariableDialog()
  71 {
  72     disposeOnce();
  73 }
  74
  75 void ScStatisticsTwoVariableDialog::dispose()
  76 {
  77     mpVariable1RangeLabel.clear();
  78     mpVariable1RangeEdit.clear();
  79     mpVariable1RangeButton.clear();
  80     mpVariable2RangeLabel.clear();
  81     mpVariable2RangeEdit.clear();
  82     mpVariable2RangeButton.clear();
  83     mpOutputRangeLabel.clear();
  84     mpOutputRangeEdit.clear();
  85     mpOutputRangeButton.clear();
  86     mpButtonOk.clear();
  87     mpGroupByColumnsRadio.clear();
  88     mpGroupByRowsRadio.clear();
  89     mpActiveEdit.clear();
  90     ScAnyRefDlg::dispose();
  91 }
  92
  93 void ScStatisticsTwoVariableDialog::Init()
  94 {
  95     mpButtonOk->SetClickHdl( LINK( this, ScStatisticsTwoVariableDialog, OkClicked ) );
  96     mpButtonOk->Enable(false);
  97
  98     Link<> aLink = LINK( this, ScStatisticsTwoVariableDialog, GetFocusHandler );
  99     mpVariable1RangeEdit->SetGetFocusHdl( aLink );
 100     mpVariable1RangeButton->SetGetFocusHdl( aLink );
 101     mpVariable2RangeEdit->SetGetFocusHdl( aLink );
 102     mpVariable2RangeButton->SetGetFocusHdl( aLink );
 103     mpOutputRangeEdit->SetGetFocusHdl( aLink );
 104     mpOutputRangeButton->SetGetFocusHdl( aLink );
 105
 106     aLink = LINK( this, ScStatisticsTwoVariableDialog, LoseFocusHandler );
 107     mpVariable1RangeEdit->SetLoseFocusHdl( aLink );
 108     mpVariable1RangeButton->SetLoseFocusHdl( aLink );
 109     mpVariable2RangeEdit->SetLoseFocusHdl( aLink );
 110     mpVariable2RangeButton->SetLoseFocusHdl( aLink );
 111     mpOutputRangeEdit->SetLoseFocusHdl( aLink );
 112     mpOutputRangeButton->SetLoseFocusHdl( aLink );
 113
 114     aLink = LINK( this, ScStatisticsTwoVariableDialog, RefInputModifyHandler);
 115     mpVariable1RangeEdit->SetModifyHdl( aLink);
 116     mpVariable2RangeEdit->SetModifyHdl( aLink);
 117     mpOutputRangeEdit->SetModifyHdl( aLink);
 118
 119     mpOutputRangeEdit->GrabFocus();
 120
 121     mpGroupByColumnsRadio->SetToggleHdl( LINK( this, ScStatisticsTwoVariableDialog, GroupByChanged ) );
 122     mpGroupByRowsRadio->SetToggleHdl( LINK( this, ScStatisticsTwoVariableDialog, GroupByChanged ) );
 123
 124     mpGroupByColumnsRadio->Check(true);
 125     mpGroupByRowsRadio->Check(false);
 126 }
 127
 128 void ScStatisticsTwoVariableDialog::GetRangeFromSelection()
 129 {
 130     OUString aCurrentString;
 131
 132     ScRange aCurrentRange;
 133     mViewData->GetSimpleArea(aCurrentRange);
 134
 135     if (aCurrentRange.aEnd.Col() - aCurrentRange.aStart.Col() == 1)
 136     {
 137         mVariable1Range = aCurrentRange;
 138         mVariable1Range.aEnd.SetCol(mVariable1Range.aStart.Col());
 139         aCurrentString = mVariable1Range.Format(SCR_ABS_3D, mDocument, mAddressDetails);
 140         mpVariable1RangeEdit->SetText(aCurrentString);
 141
 142         mVariable2Range = aCurrentRange;
 143         mVariable2Range.aStart.SetCol(mVariable2Range.aEnd.Col());
 144         aCurrentString = mVariable2Range.Format(SCR_ABS_3D, mDocument, mAddressDetails);
 145         mpVariable2RangeEdit->SetText(aCurrentString);
 146     }
 147     else
 148     {
 149         mVariable1Range = aCurrentRange;
 150         aCurrentString = mVariable1Range.Format(SCR_ABS_3D, mDocument, mAddressDetails);
 151         mpVariable1RangeEdit->SetText(aCurrentString);
 152     }
 153 }
 154
 155 void ScStatisticsTwoVariableDialog::SetActive()
 156 {
 157     if ( mDialogLostFocus )
 158     {
 159         mDialogLostFocus = false;
 160         if( mpActiveEdit )
 161             mpActiveEdit->GrabFocus();
 162     }
 163     else
 164     {
 165         GrabFocus();
 166     }
 167     RefInputDone();
 168 }
 169
 170 void ScStatisticsTwoVariableDialog::SetReference( const ScRange& rReferenceRange, ScDocument* pDocument )
 171 {
 172     if ( mpActiveEdit != nullptr )
 173     {
 174         if ( rReferenceRange.aStart != rReferenceRange.aEnd )
 175             RefInputStart( mpActiveEdit );
 176
 177         OUString aReferenceString;
 178
 179         if ( mpActiveEdit == mpVariable1RangeEdit )
 180         {
 181             mVariable1Range = rReferenceRange;
 182             aReferenceString = mVariable1Range.Format(SCR_ABS_3D, pDocument, mAddressDetails);
 183             mpVariable1RangeEdit->SetRefString(aReferenceString);
 184         }
 185         else if ( mpActiveEdit == mpVariable2RangeEdit )
 186         {
 187             mVariable2Range = rReferenceRange;
 188             aReferenceString = mVariable2Range.Format(SCR_ABS_3D, pDocument, mAddressDetails);
 189             mpVariable2RangeEdit->SetRefString(aReferenceString);
 190         }
 191         else if ( mpActiveEdit == mpOutputRangeEdit )
 192         {
 193             mOutputAddress = rReferenceRange.aStart;
 194
 195             sal_uInt16 nFormat = ( mOutputAddress.Tab() == mCurrentAddress.Tab() ) ? SCA_ABS : SCA_ABS_3D;
 196             aReferenceString = mOutputAddress.Format(nFormat, pDocument, pDocument->GetAddressConvention());
 197             mpOutputRangeEdit->SetRefString( aReferenceString );
 198         }
 199     }
 200
 201     // Enable OK if all ranges are set.
 202     if (mVariable1Range.IsValid() && mVariable2Range.IsValid() && mOutputAddress.IsValid())
 203         mpButtonOk->Enable();
 204     else
 205         mpButtonOk->Disable();
 206 }
 207
 208 IMPL_LINK( ScStatisticsTwoVariableDialog, OkClicked, PushButton*, /*pButton*/ )
 209 {
 210     CalculateInputAndWriteToOutput();
 211     Close();
 212     return 0;
 213 }
 214
 215 IMPL_LINK( ScStatisticsTwoVariableDialog, GetFocusHandler, Control*, pCtrl )
 216 {
 217     mpActiveEdit = NULL;
 218     if(      pCtrl == mpVariable1RangeEdit
 219           || pCtrl == mpVariable1RangeButton )
 220     {
 221         mpActiveEdit = mpVariable1RangeEdit;
 222     }
 223     else if( pCtrl == mpVariable2RangeEdit
 224           || pCtrl == mpVariable2RangeButton )
 225     {
 226         mpActiveEdit = mpVariable2RangeEdit;
 227     }
 228     else if( pCtrl == mpOutputRangeEdit
 229           || pCtrl == mpOutputRangeButton )
 230     {
 231         mpActiveEdit = mpOutputRangeEdit;
 232     }
 233
 234     if( mpActiveEdit )
 235         mpActiveEdit->SetSelection( Selection( 0, SELECTION_MAX ) );
 236
 237     return 0;
 238 }
 239
 240 IMPL_LINK_NOARG( ScStatisticsTwoVariableDialog, LoseFocusHandler )
 241 {
 242     mDialogLostFocus = !IsActive();
 243     return 0;
 244 }
 245
 246 IMPL_LINK_NOARG( ScStatisticsTwoVariableDialog, GroupByChanged )
 247 {
 248     if (mpGroupByColumnsRadio->IsChecked())
 249         mGroupedBy = BY_COLUMN;
 250     else if (mpGroupByRowsRadio->IsChecked())
 251         mGroupedBy = BY_ROW;
 252
 253     return 0;
 254 }
 255
 256 IMPL_LINK_NOARG( ScStatisticsTwoVariableDialog, RefInputModifyHandler )
 257 {
 258     if ( mpActiveEdit )
 259     {
 260         if ( mpActiveEdit == mpVariable1RangeEdit )
 261         {
 262             ScRangeList aRangeList;
 263             bool bValid = ParseWithNames( aRangeList, mpVariable1RangeEdit->GetText(), mDocument);
 264             const ScRange* pRange = (bValid && aRangeList.size() == 1) ? aRangeList[0] : nullptr;
 265             if (pRange)
 266             {
 267                 mVariable1Range = *pRange;
 268                 // Highlight the resulting range.
 269                 mpVariable1RangeEdit->StartUpdateData();
 270             }
 271             else
 272             {
 273                 mVariable1Range = ScRange( ScAddress::INITIALIZE_INVALID);
 274             }
 275         }
 276         else if ( mpActiveEdit == mpVariable2RangeEdit )
 277         {
 278             ScRangeList aRangeList;
 279             bool bValid = ParseWithNames( aRangeList, mpVariable2RangeEdit->GetText(), mDocument);
 280             const ScRange* pRange = (bValid && aRangeList.size() == 1) ? aRangeList[0] : nullptr;
 281             if (pRange)
 282             {
 283                 mVariable2Range = *pRange;
 284                 // Highlight the resulting range.
 285                 mpVariable2RangeEdit->StartUpdateData();
 286             }
 287             else
 288             {
 289                 mVariable2Range = ScRange( ScAddress::INITIALIZE_INVALID);
 290             }
 291         }
 292         else if ( mpActiveEdit == mpOutputRangeEdit )
 293         {
 294             ScRangeList aRangeList;
 295             bool bValid = ParseWithNames( aRangeList, mpOutputRangeEdit->GetText(), mDocument);
 296             const ScRange* pRange = (bValid && aRangeList.size() == 1) ? aRangeList[0] : nullptr;
 297             if (pRange)
 298             {
 299                 mOutputAddress = pRange->aStart;
 300
 301                 // Crop output range to top left address for Edit field.
 302                 if (pRange->aStart != pRange->aEnd)
 303                 {
 304                     sal_uInt16 nFormat = ( mOutputAddress.Tab() == mCurrentAddress.Tab() ) ? SCA_ABS : SCA_ABS_3D;
 305                     OUString aReferenceString = mOutputAddress.Format(nFormat, mDocument, mDocument->GetAddressConvention());
 306                     mpOutputRangeEdit->SetRefString( aReferenceString );
 307                 }
 308
 309                 // Highlight the resulting range.
 310                 mpOutputRangeEdit->StartUpdateData();
 311             }
 312             else
 313             {
 314                 mOutputAddress = ScAddress( ScAddress::INITIALIZE_INVALID);
 315             }
 316         }
 317     }
 318
 319     // Enable OK if all ranges are set.
 320     if (mVariable1Range.IsValid() && mVariable2Range.IsValid() && mOutputAddress.IsValid())
 321         mpButtonOk->Enable();
 322     else
 323         mpButtonOk->Disable();
 324
 325     return 0;
 326 }
 327
 328 void ScStatisticsTwoVariableDialog::CalculateInputAndWriteToOutput()
 329 {
 330     OUString aUndo(SC_STRLOAD(RID_STATISTICS_DLGS, GetUndoNameId()));
 331     ScDocShell* pDocShell = mViewData->GetDocShell();
 332     svl::IUndoManager* pUndoManager = pDocShell->GetUndoManager();
 333     pUndoManager->EnterListAction( aUndo, aUndo );
 334
 335     ScRange aOutputRange = ApplyOutput(pDocShell);
 336
 337     pUndoManager->LeaveListAction();
 338     pDocShell->PostPaint( aOutputRange, PAINT_GRID );
 339 }
 340
 341 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */