sc/source/ui/StatisticsDialogs/TableFillingAndNavigationTools.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 <boost/scoped_ptr.hpp>
  12
  13 #include <editeng/editobj.hxx>
  14 #include <editeng/wghtitem.hxx>
  15 #include <editeng/eeitem.hxx>
  16
  17 #include "editutil.hxx"
  18
  19 #include "TableFillingAndNavigationTools.hxx"
  20
  21 FormulaTemplate::FormulaTemplate(ScDocument* aDocument, ScAddress::Details aAddressDetails) :
  22     mDocument(aDocument),
  23     mAddressDetails(aAddressDetails)
  24 {}
  25
  26 void FormulaTemplate::setTemplate(OUString aTemplate)
  27 {
  28     mTemplate = aTemplate;
  29 }
  30
  31 void FormulaTemplate::setTemplate(const char* aTemplate)
  32 {
  33     mTemplate = OUString::createFromAscii(aTemplate);
  34 }
  35
  36 OUString& FormulaTemplate::getTemplate()
  37 {
  38     return mTemplate;
  39 }
  40
  41 void FormulaTemplate::applyRange(OUString aVariable, ScRange aRange)
  42 {
  43     OUString aString = aRange.Format(SCR_ABS, mDocument, mAddressDetails);
  44     mTemplate = mTemplate.replaceAll(aVariable, aString);
  45 }
  46
  47 void FormulaTemplate::applyRangeList(OUString aVariable, ScRangeList aRangeList)
  48 {
  49     OUString aString;
  50     aRangeList.Format(aString, SCR_ABS, mDocument);
  51     mTemplate = mTemplate.replaceAll(aVariable, aString);
  52 }
  53
  54 void FormulaTemplate::applyAddress(OUString aVariable, ScAddress aAddress)
  55 {
  56     OUString aString = aAddress.Format(SCR_ABS, mDocument, mAddressDetails);
  57     mTemplate = mTemplate.replaceAll(aVariable, aString);
  58 }
  59
  60 void FormulaTemplate::applyString(OUString aVariable, OUString aValue)
  61 {
  62     mTemplate = mTemplate.replaceAll(aVariable, aValue);
  63 }
  64
  65 void FormulaTemplate::applyNumber(OUString aVariable, sal_Int32 aValue)
  66 {
  67     mTemplate = mTemplate.replaceAll(aVariable, OUString::number(aValue));
  68 }
  69
  70 AddressWalker::AddressWalker(ScAddress aInitialAddress, bool aTrackRange) :
  71     mCurrentAddress(aInitialAddress),
  72     mMinimumAddress(aInitialAddress),
  73     mMaximumAddress(aInitialAddress),
  74     mTrackRange(aTrackRange)
  75 {
  76     mAddressStack.push_back(mCurrentAddress);
  77 }
  78
  79 void AddressWalker::resetColumn()
  80 {
  81     mCurrentAddress.SetCol(mAddressStack.back().Col());
  82 }
  83
  84 void AddressWalker::resetRow()
  85 {
  86     mCurrentAddress.SetRow(mAddressStack.back().Row());
  87 }
  88
  89 void AddressWalker::reset()
  90 {
  91     mCurrentAddress = mAddressStack.back();
  92 }
  93
  94 ScAddress AddressWalker::current(SCCOL aRelCol, SCROW aRelRow, SCTAB aRelTab)
  95 {
  96     return ScAddress(
  97             mCurrentAddress.Col() + aRelCol,
  98             mCurrentAddress.Row() + aRelRow,
  99             mCurrentAddress.Tab() + aRelTab);
 100 }
 101
 102 void AddressWalker::nextColumn()
 103 {
 104     mCurrentAddress.IncCol();
 105
 106     if (mTrackRange)
 107     {
 108         if(mMaximumAddress.Col() < mCurrentAddress.Col())
 109             mMaximumAddress.SetCol(mCurrentAddress.Col());
 110     }
 111 }
 112
 113 void AddressWalker::nextRow()
 114 {
 115     mCurrentAddress.IncRow();
 116     if (mTrackRange)
 117     {
 118         if(mMaximumAddress.Row() < mCurrentAddress.Row())
 119             mMaximumAddress.SetRow(mCurrentAddress.Row());
 120     }
 121 }
 122
 123 void AddressWalker::push(SCCOL aRelativeCol, SCROW aRelativeRow, SCTAB aRelativeTab)
 124 {
 125     mCurrentAddress = current(aRelativeCol, aRelativeRow, aRelativeTab);
 126     mAddressStack.push_back(mCurrentAddress);
 127 }
 128
 129 void AddressWalker::pop()
 130 {
 131     mCurrentAddress = mAddressStack.back();
 132     mAddressStack.pop_back();
 133 }
 134
 135 AddressWalkerWriter::AddressWalkerWriter(ScAddress aInitialAddress, ScDocShell* pDocShell, ScDocument* pDocument,
 136         formula::FormulaGrammar::Grammar eGrammar ) :
 137     AddressWalker(aInitialAddress, true),
 138     mpDocShell(pDocShell),
 139     mpDocument(pDocument),
 140     meGrammar(eGrammar)
 141 {}
 142
 143 void AddressWalkerWriter::writeFormula(OUString aFormula)
 144 {
 145     mpDocShell->GetDocFunc().SetFormulaCell(mCurrentAddress,
 146             new ScFormulaCell(mpDocument, mCurrentAddress, aFormula, meGrammar), true);
 147 }
 148
 149 void AddressWalkerWriter::writeString(OUString aString)
 150 {
 151     mpDocShell->GetDocFunc().SetStringCell(mCurrentAddress, aString, true);
 152 }
 153
 154 void AddressWalkerWriter::writeString(const char* aCharArray)
 155 {
 156     writeString(OUString::createFromAscii(aCharArray));
 157 }
 158
 159 void AddressWalkerWriter::writeBoldString(OUString aString)
 160 {
 161     ScFieldEditEngine& rEngine = mpDocument->GetEditEngine();
 162     rEngine.SetText(aString);
 163     SfxItemSet aItemSet = rEngine.GetEmptyItemSet();
 164     SvxWeightItem aWeight(WEIGHT_BOLD, EE_CHAR_WEIGHT);
 165     aItemSet.Put(aWeight);
 166     rEngine.QuickSetAttribs(aItemSet, ESelection(0, 0, 0, aString.getLength()) );
 167     boost::scoped_ptr<EditTextObject> pEditText(rEngine.CreateTextObject());
 168     mpDocShell->GetDocFunc().SetEditCell(mCurrentAddress, *pEditText, true);
 169 }
 170
 171 void AddressWalkerWriter::writeValue(double aValue)
 172 {
 173     mpDocShell->GetDocFunc().SetValueCell(mCurrentAddress, aValue, true);
 174 }
 175
 176 // DataCellIterator
 177
 178 DataCellIterator::DataCellIterator(ScRange aInputRange, bool aByColumn) :
 179     mInputRange(aInputRange),
 180     mByColumn(aByColumn)
 181 {
 182     if(aByColumn)
 183         mCol = aInputRange.aStart.Col();
 184     else
 185         mRow = aInputRange.aStart.Row();
 186 }
 187
 188 DataCellIterator::~DataCellIterator()
 189 {}
 190
 191 bool DataCellIterator::hasNext()
 192 {
 193     if(mByColumn)
 194         return mCol <= mInputRange.aEnd.Col();
 195     else
 196         return mRow <= mInputRange.aEnd.Row();
 197 }
 198
 199 void DataCellIterator::next()
 200 {
 201     if(mByColumn)
 202         mCol++;
 203     else
 204         mRow++;
 205 }
 206
 207 ScAddress DataCellIterator::get()
 208 {
 209     return getRelative(0);
 210 }
 211
 212 ScAddress DataCellIterator::getRelative(int aDelta)
 213 {
 214     if(mByColumn)
 215     {
 216         SCCOL aNewColumn = mCol + aDelta;
 217         if(aNewColumn < mInputRange.aStart.Col() || aNewColumn > mInputRange.aEnd.Col())
 218         {
 219             ScAddress aResult;
 220             aResult.SetInvalid();
 221             return aResult;
 222         }
 223         return ScAddress(aNewColumn, mInputRange.aStart.Row(), mInputRange.aStart.Tab());
 224     }
 225     else
 226     {
 227         SCROW aNewRow = mRow + aDelta;
 228         if(aNewRow < mInputRange.aStart.Row() || aNewRow > mInputRange.aEnd.Row())
 229         {
 230             ScAddress aResult;
 231             aResult.SetInvalid();
 232             return aResult;
 233         }
 234         return ScAddress(mInputRange.aStart.Col(), aNewRow, mInputRange.aStart.Tab());
 235     }
 236 }
 237
 238 // DataRangeIterator
 239
 240 DataRangeIterator::DataRangeIterator(ScRange aInputRange) :
 241     mInputRange(aInputRange),
 242     mIndex(0)
 243 {}
 244
 245 DataRangeIterator::~DataRangeIterator()
 246 {}
 247
 248 sal_Int32 DataRangeIterator::index()
 249 {
 250     return mIndex;
 251 }
 252
 253 // DataRangeByColumnIterator
 254
 255 DataRangeByColumnIterator::DataRangeByColumnIterator(ScRange aInputRange) :
 256     DataRangeIterator(aInputRange),
 257     mCol(aInputRange.aStart.Col())
 258 {}
 259
 260 bool DataRangeByColumnIterator::hasNext()
 261 {
 262     return mCol <= mInputRange.aEnd.Col();
 263 }
 264
 265 void DataRangeByColumnIterator::next()
 266 {
 267     mCol++;
 268     mIndex++;
 269 }
 270
 271 ScRange DataRangeByColumnIterator::get()
 272 {
 273     return ScRange(
 274         ScAddress(mCol, mInputRange.aStart.Row(), mInputRange.aStart.Tab()),
 275         ScAddress(mCol, mInputRange.aEnd.Row(),   mInputRange.aEnd.Tab())
 276     );
 277 }
 278
 279 void DataRangeByColumnIterator::reset()
 280 {
 281     mCol = mInputRange.aStart.Col();
 282 }
 283
 284 DataCellIterator DataRangeByColumnIterator::iterateCells()
 285 {
 286     return DataCellIterator(get(), false);
 287 }
 288
 289 // DataRangeByRowIterator
 290
 291 DataRangeByRowIterator::DataRangeByRowIterator(ScRange aInputRange) :
 292     DataRangeIterator(aInputRange),
 293     mRow(aInputRange.aStart.Row())
 294 {}
 295
 296 bool DataRangeByRowIterator::hasNext()
 297 {
 298     return mRow <= mInputRange.aEnd.Row();
 299 }
 300
 301 void DataRangeByRowIterator::next()
 302 {
 303     mRow++;
 304     mIndex++;
 305 }
 306
 307 ScRange DataRangeByRowIterator::get()
 308 {
 309     return ScRange(
 310         ScAddress(mInputRange.aStart.Col(), mRow, mInputRange.aStart.Tab()),
 311         ScAddress(mInputRange.aEnd.Col(),   mRow, mInputRange.aEnd.Tab())
 312     );
 313 }
 314
 315 void DataRangeByRowIterator::reset()
 316 {
 317     mRow = mInputRange.aStart.Row();
 318 }
 319
 320 DataCellIterator DataRangeByRowIterator::iterateCells()
 321 {
 322     return DataCellIterator(get(), true);
 323 }
 324
 325 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */