Line data    Source code

       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 "strload.hxx"
      23             : #include "random.hxx"
      24             : #include "docfunc.hxx"
      25             : #include "StatisticsDialogs.hrc"
      26             : #include "TableFillingAndNavigationTools.hxx"
      27             : 
      28             : #include "MovingAverageDialog.hxx"
      29             : 
      30           0 : ScMovingAverageDialog::ScMovingAverageDialog(
      31             :                     SfxBindings* pSfxBindings, SfxChildWindow* pChildWindow,
      32             :                     Window* pParent, ScViewData* pViewData ) :
      33             :     ScStatisticsInputOutputDialog(
      34             :             pSfxBindings, pChildWindow, pParent, pViewData,
      35           0 :             "MovingAverageDialog", "modules/scalc/ui/movingaveragedialog.ui" )
      36             : {
      37           0 :     get(mpIntervalSpin, "interval-spin");
      38           0 : }
      39             : 
      40           0 : ScMovingAverageDialog::~ScMovingAverageDialog()
      41           0 : {}
      42             : 
      43           0 : bool ScMovingAverageDialog::Close()
      44             : {
      45           0 :     return DoClose( ScMovingAverageDialogWrapper::GetChildWindowId() );
      46             : }
      47             : 
      48           0 : sal_Int16 ScMovingAverageDialog::GetUndoNameId()
      49             : {
      50           0 :     return STR_MOVING_AVERAGE_UNDO_NAME;
      51             : }
      52             : 
      53           0 : ScRange ScMovingAverageDialog::ApplyOutput(ScDocShell* pDocShell)
      54             : {
      55             :     AddressWalkerWriter output(mOutputAddress, pDocShell, mDocument,
      56           0 :             formula::FormulaGrammar::mergeToGrammar( formula::FormulaGrammar::GRAM_ENGLISH, mAddressDetails.eConv));
      57           0 :     FormulaTemplate aTemplate(mDocument, mAddressDetails);
      58             : 
      59           0 :     boost::scoped_ptr<DataRangeIterator> pIterator;
      60           0 :     if (mGroupedBy == BY_COLUMN)
      61           0 :         pIterator.reset(new DataRangeByColumnIterator(mInputRange));
      62             :     else
      63           0 :         pIterator.reset(new DataRangeByRowIterator(mInputRange));
      64             : 
      65           0 :     sal_Int32 aIntervalSize = mpIntervalSpin->GetValue();
      66           0 :     bool aCentral = true;
      67             : 
      68           0 :     for( ; pIterator->hasNext(); pIterator->next() )
      69             :     {
      70           0 :         output.resetRow();
      71             : 
      72             :         // Write label
      73           0 :         if (mGroupedBy == BY_COLUMN)
      74           0 :             aTemplate.setTemplate(SC_STRLOAD(RID_STATISTICS_DLGS, STR_COLUMN_LABEL_TEMPLATE));
      75             :         else
      76           0 :             aTemplate.setTemplate(SC_STRLOAD(RID_STATISTICS_DLGS, STR_ROW_LABEL_TEMPLATE));
      77             : 
      78           0 :         aTemplate.applyNumber("%NUMBER%", pIterator->index() + 1);
      79           0 :         output.writeBoldString(aTemplate.getTemplate());
      80           0 :         output.nextRow();
      81             : 
      82           0 :         DataCellIterator aDataCellIterator = pIterator->iterateCells();
      83             : 
      84           0 :         for (; aDataCellIterator.hasNext(); aDataCellIterator.next())
      85             :         {
      86           0 :             ScAddress aIntervalStart;
      87           0 :             ScAddress aIntervalEnd;
      88             : 
      89           0 :             if (aCentral)
      90             :             {
      91           0 :                 sal_Int32 aHalf = aIntervalSize / 2;
      92           0 :                 sal_Int32 aHalfRemainder = aIntervalSize % 2;
      93           0 :                 aIntervalStart = aDataCellIterator.getRelative(-aHalf);
      94           0 :                 aIntervalEnd = aDataCellIterator.getRelative(aHalf - 1 + aHalfRemainder);
      95             :             }
      96             :             else
      97             :             {
      98           0 :                 aIntervalStart = aDataCellIterator.getRelative(-aIntervalSize);
      99           0 :                 aIntervalEnd = aDataCellIterator.getRelative(0);
     100             :             }
     101             : 
     102           0 :             if(aIntervalStart.IsValid() && aIntervalEnd.IsValid())
     103             :             {
     104           0 :                 aTemplate.setTemplate("=AVERAGE(%RANGE%)");
     105           0 :                 aTemplate.applyRange("%RANGE%", ScRange(aIntervalStart, aIntervalEnd));
     106           0 :                 output.writeFormula(aTemplate.getTemplate());
     107             :             }
     108             :             else
     109             :             {
     110           0 :                 output.writeFormula("=#N/A");
     111             :             }
     112           0 :             output.nextRow();
     113             :         }
     114           0 :         output.nextColumn();
     115           0 :     }
     116           0 :     return ScRange(output.mMinimumAddress, output.mMaximumAddress);
     117         102 : }
     118             : 
     119             : /* vim:set shiftwidth=4 softtabstop=4 expandtab: */