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                     Window* pParent, ScViewData* pViewData, const OString& rID, const OUString& rUIXMLDescription ) :
  31     ScAnyRefDlg     ( pSfxBindings, pChildWindow, pParent, rID, rUIXMLDescription ),
  32     mViewData       ( pViewData ),
  33     mDocument       ( pViewData->GetDocument() ),
  34     mAddressDetails ( mDocument->GetAddressConvention(), 0, 0 ),
  35     mGroupedBy      ( BY_COLUMN ),
  36     mpActiveEdit    ( NULL ),
  37     mCurrentAddress ( pViewData->GetCurX(), pViewData->GetCurY(), pViewData->GetTabNo() ),
  38     mDialogLostFocus( false )
  39 {
  40     get(mpVariable1RangeLabel,  "variable1-range-label");
  41     get(mpVariable1RangeEdit,   "variable1-range-edit");
  42     get(mpVariable1RangeButton, "variable1-range-button");
  43     mpVariable1RangeEdit->SetReferences(this, mpVariable1RangeLabel);
  44     mpVariable1RangeButton->SetReferences(this, mpVariable1RangeEdit);
  45
  46     get(mpVariable2RangeLabel,  "variable2-range-label");
  47     get(mpVariable2RangeEdit,   "variable2-range-edit");
  48     get(mpVariable2RangeButton, "variable2-range-button");
  49     mpVariable2RangeEdit->SetReferences(this, mpVariable2RangeLabel);
  50     mpVariable2RangeButton->SetReferences(this, mpVariable2RangeEdit);
  51
  52     get(mpOutputRangeLabel,  "output-range-label");
  53     get(mpOutputRangeEdit,   "output-range-edit");
  54     get(mpOutputRangeButton, "output-range-button");
  55     mpOutputRangeEdit->SetReferences(this, mpOutputRangeLabel);
  56     mpOutputRangeButton->SetReferences(this, mpOutputRangeEdit);
  57
  58     get(mpButtonOk,     "ok");
  59
  60     get(mpGroupByColumnsRadio,   "groupedby-columns-radio");
  61     get(mpGroupByRowsRadio,      "groupedby-rows-radio");
  62
  63     Init();
  64     GetRangeFromSelection();
  65 }
  66
  67 ScStatisticsTwoVariableDialog::~ScStatisticsTwoVariableDialog()
  68 {}
  69
  70 void ScStatisticsTwoVariableDialog::Init()
  71 {
  72     mpButtonOk->SetClickHdl( LINK( this, ScStatisticsTwoVariableDialog, OkClicked ) );
  73     mpButtonOk->Enable(false);
  74
  75     Link aLink = LINK( this, ScStatisticsTwoVariableDialog, GetFocusHandler );
  76     mpVariable1RangeEdit->SetGetFocusHdl( aLink );
  77     mpVariable1RangeButton->SetGetFocusHdl( aLink );
  78     mpVariable2RangeEdit->SetGetFocusHdl( aLink );
  79     mpVariable2RangeButton->SetGetFocusHdl( aLink );
  80     mpOutputRangeEdit->SetGetFocusHdl( aLink );
  81     mpOutputRangeButton->SetGetFocusHdl( aLink );
  82
  83     aLink = LINK( this, ScStatisticsTwoVariableDialog, LoseFocusHandler );
  84     mpVariable1RangeEdit->SetLoseFocusHdl( aLink );
  85     mpVariable1RangeButton->SetLoseFocusHdl( aLink );
  86     mpVariable2RangeEdit->SetLoseFocusHdl( aLink );
  87     mpVariable2RangeButton->SetLoseFocusHdl( aLink );
  88     mpOutputRangeEdit->SetLoseFocusHdl( aLink );
  89     mpOutputRangeButton->SetLoseFocusHdl( aLink );
  90
  91     mpOutputRangeEdit->GrabFocus();
  92
  93     mpGroupByColumnsRadio->SetToggleHdl( LINK( this, ScStatisticsTwoVariableDialog, GroupByChanged ) );
  94     mpGroupByRowsRadio->SetToggleHdl( LINK( this, ScStatisticsTwoVariableDialog, GroupByChanged ) );
  95
  96     mpGroupByColumnsRadio->Check(true);
  97     mpGroupByRowsRadio->Check(false);
  98 }
  99
 100 void ScStatisticsTwoVariableDialog::GetRangeFromSelection()
 101 {
 102     OUString aCurrentString;
 103
 104     ScRange aCurrentRange;
 105     mViewData->GetSimpleArea(aCurrentRange);
 106
 107     if (aCurrentRange.aEnd.Col() - aCurrentRange.aStart.Col() == 1)
 108     {
 109         mVariable1Range = aCurrentRange;
 110         mVariable1Range.aEnd.SetCol(mVariable1Range.aStart.Col());
 111         aCurrentString = mVariable1Range.Format(SCR_ABS_3D, mDocument, mAddressDetails);
 112         mpVariable1RangeEdit->SetText(aCurrentString);
 113
 114         mVariable2Range = aCurrentRange;
 115         mVariable2Range.aStart.SetCol(mVariable2Range.aEnd.Col());
 116         aCurrentString = mVariable2Range.Format(SCR_ABS_3D, mDocument, mAddressDetails);
 117         mpVariable2RangeEdit->SetText(aCurrentString);
 118     }
 119     else
 120     {
 121         mVariable1Range = aCurrentRange;
 122         aCurrentString = mVariable1Range.Format(SCR_ABS_3D, mDocument, mAddressDetails);
 123         mpVariable1RangeEdit->SetText(aCurrentString);
 124     }
 125 }
 126
 127 void ScStatisticsTwoVariableDialog::SetActive()
 128 {
 129     if ( mDialogLostFocus )
 130     {
 131         mDialogLostFocus = false;
 132         if( mpActiveEdit )
 133             mpActiveEdit->GrabFocus();
 134     }
 135     else
 136     {
 137         GrabFocus();
 138     }
 139     RefInputDone();
 140 }
 141
 142 void ScStatisticsTwoVariableDialog::SetReference( const ScRange& rReferenceRange, ScDocument* pDocument )
 143 {
 144     if ( mpActiveEdit != NULL )
 145     {
 146         if ( rReferenceRange.aStart != rReferenceRange.aEnd )
 147             RefInputStart( mpActiveEdit );
 148
 149         OUString aReferenceString;
 150
 151         if ( mpActiveEdit == mpVariable1RangeEdit )
 152         {
 153             mVariable1Range = rReferenceRange;
 154             aReferenceString = mVariable1Range.Format(SCR_ABS_3D, pDocument, mAddressDetails);
 155             mpVariable1RangeEdit->SetRefString(aReferenceString);
 156         }
 157         else if ( mpActiveEdit == mpVariable2RangeEdit )
 158         {
 159             mVariable2Range = rReferenceRange;
 160             aReferenceString = mVariable2Range.Format(SCR_ABS_3D, pDocument, mAddressDetails);
 161             mpVariable2RangeEdit->SetRefString(aReferenceString);
 162         }
 163         else if ( mpActiveEdit == mpOutputRangeEdit )
 164         {
 165             mOutputAddress = rReferenceRange.aStart;
 166
 167             sal_uInt16 nFormat = ( mOutputAddress.Tab() == mCurrentAddress.Tab() ) ? SCA_ABS : SCA_ABS_3D;
 168             aReferenceString = mOutputAddress.Format(nFormat, pDocument, pDocument->GetAddressConvention());
 169             mpOutputRangeEdit->SetRefString( aReferenceString );
 170
 171             // Enable OK, Cancel if output range is set
 172             mpButtonOk->Enable(!mpOutputRangeEdit->GetText().isEmpty());
 173         }
 174     }
 175 }
 176
 177 IMPL_LINK( ScStatisticsTwoVariableDialog, OkClicked, PushButton*, /*pButton*/ )
 178 {
 179     CalculateInputAndWriteToOutput();
 180     Close();
 181     return 0;
 182 }
 183
 184 IMPL_LINK( ScStatisticsTwoVariableDialog, GetFocusHandler, Control*, pCtrl )
 185 {
 186     mpActiveEdit = NULL;
 187     if(      pCtrl == mpVariable1RangeEdit
 188           || pCtrl == mpVariable1RangeButton )
 189     {
 190         mpActiveEdit = mpVariable1RangeEdit;
 191     }
 192     else if( pCtrl == mpVariable2RangeEdit
 193           || pCtrl == mpVariable2RangeButton )
 194     {
 195         mpActiveEdit = mpVariable2RangeEdit;
 196     }
 197     else if( pCtrl == mpOutputRangeEdit
 198           || pCtrl == mpOutputRangeButton )
 199     {
 200         mpActiveEdit = mpOutputRangeEdit;
 201     }
 202
 203     if( mpActiveEdit )
 204         mpActiveEdit->SetSelection( Selection( 0, SELECTION_MAX ) );
 205
 206     return 0;
 207 }
 208
 209 IMPL_LINK_NOARG( ScStatisticsTwoVariableDialog, LoseFocusHandler )
 210 {
 211     mDialogLostFocus = !IsActive();
 212     return 0;
 213 }
 214
 215 IMPL_LINK_NOARG( ScStatisticsTwoVariableDialog, GroupByChanged )
 216 {
 217     if (mpGroupByColumnsRadio->IsChecked())
 218         mGroupedBy = BY_COLUMN;
 219     else if (mpGroupByRowsRadio->IsChecked())
 220         mGroupedBy = BY_ROW;
 221
 222     return 0;
 223 }
 224
 225 void ScStatisticsTwoVariableDialog::CalculateInputAndWriteToOutput()
 226 {
 227     OUString aUndo(SC_STRLOAD(RID_STATISTICS_DLGS, GetUndoNameId()));
 228     ScDocShell* pDocShell = mViewData->GetDocShell();
 229     svl::IUndoManager* pUndoManager = pDocShell->GetUndoManager();
 230     pUndoManager->EnterListAction( aUndo, aUndo );
 231
 232     ScRange aOutputRange = ApplyOutput(pDocShell);
 233
 234     pUndoManager->LeaveListAction();
 235     pDocShell->PostPaint( aOutputRange, PAINT_GRID );
 236 }
 237
 238 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */