sc/source/ui/miscdlgs/datastreamdlg.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 #include <datastreamdlg.hxx>
  11
  12 #include <sfx2/filedlghelper.hxx>
  13 #include <svtools/inettbc.hxx>
  14 #include <vcl/layout.hxx>
  15 #include <address.hxx>
  16 #include <docsh.hxx>
  17
  18 namespace sc {
  19
  20 DataStreamDlg::DataStreamDlg(ScDocShell *pDocShell, Window* pParent)
  21     : ModalDialog(pParent, "DataStreamDialog", "modules/scalc/ui/datastreams.ui")
  22     , mpDocShell(pDocShell)
  23 {
  24     get(m_pCbUrl, "url");
  25     get(m_pBtnBrowse, "browse");
  26     get(m_pRBDirectData, "directdata");
  27     get(m_pRBScriptData, "scriptdata");
  28     get(m_pRBValuesInLine, "valuesinline");
  29     get(m_pRBAddressValue, "addressvalue");
  30     get(m_pCBRefreshOnEmpty, "refresh_ui");
  31     get(m_pRBDataDown, "datadown");
  32     get(m_pRBRangeDown, "rangedown");
  33     get(m_pRBNoMove, "nomove");
  34     get(m_pRBMaxLimit, "maxlimit");
  35     get(m_pRBUnlimited, "unlimited");
  36     get(m_pEdRange, "range");
  37     get(m_pEdLimit, "limit");
  38     get(m_pBtnOk, "ok");
  39     get(m_pVclFrameLimit, "framelimit");
  40     get(m_pVclFrameMove, "framemove");
  41
  42     m_pCbUrl->SetSelectHdl( LINK( this, DataStreamDlg, UpdateHdl ) );
  43     m_pRBAddressValue->SetClickHdl( LINK( this, DataStreamDlg, UpdateHdl ) );
  44     m_pRBAddressValue->Enable(false);
  45     m_pRBScriptData->Enable(false);
  46     m_pRBDirectData->Hide();
  47     m_pRBScriptData->Hide();
  48     m_pRBNoMove->Hide();
  49     m_pRBValuesInLine->SetClickHdl( LINK( this, DataStreamDlg, UpdateHdl ) );
  50     m_pEdRange->SetModifyHdl( LINK( this, DataStreamDlg, UpdateHdl ) );
  51     m_pBtnBrowse->SetClickHdl( LINK( this, DataStreamDlg, BrowseHdl ) );
  52     UpdateEnable();
  53 }
  54
  55 IMPL_LINK_NOARG(DataStreamDlg, BrowseHdl)
  56 {
  57     sfx2::FileDialogHelper aFileDialog(0, 0);
  58     if ( aFileDialog.Execute() != ERRCODE_NONE )
  59         return 0;
  60
  61     m_pCbUrl->SetText( aFileDialog.GetPath() );
  62     UpdateEnable();
  63     return 0;
  64 }
  65
  66 IMPL_LINK_NOARG(DataStreamDlg, UpdateHdl)
  67 {
  68     UpdateEnable();
  69     return 0;
  70 }
  71
  72 void DataStreamDlg::UpdateEnable()
  73 {
  74     bool bOk = !m_pCbUrl->GetURL().isEmpty();
  75     if (m_pRBAddressValue->IsChecked())
  76     {
  77         m_pVclFrameLimit->Disable();
  78         m_pVclFrameMove->Disable();
  79         m_pEdRange->Disable();
  80     }
  81     else
  82     {
  83         m_pVclFrameLimit->Enable();
  84         m_pVclFrameMove->Enable();
  85         m_pEdRange->Enable();
  86         if (bOk)
  87         {
  88             // Check the given range to make sure it's valid.
  89             ScRange aTest = GetStartRange();
  90             if (!aTest.IsValid())
  91                 bOk = false;
  92         }
  93     }
  94     m_pBtnOk->Enable(bOk);
  95     setOptimalLayoutSize();
  96 }
  97
  98 ScRange DataStreamDlg::GetStartRange()
  99 {
 100     OUString aStr = m_pEdRange->GetText();
 101     ScDocument* pDoc = mpDocShell->GetDocument();
 102     ScRange aRange;
 103     sal_uInt16 nRes = aRange.Parse(aStr, pDoc, pDoc->GetAddressConvention());
 104     if ((nRes & SCA_VALID) != SCA_VALID || !aRange.IsValid())
 105     {
 106         // Invalid range.
 107         aRange.SetInvalid();
 108         return aRange;
 109     }
 110
 111     // Make sure it's only one row tall.
 112     if (aRange.aStart.Row() != aRange.aEnd.Row())
 113         aRange.SetInvalid();
 114
 115     return aRange;
 116 }
 117
 118 void DataStreamDlg::Init( const DataStream& rStrm )
 119 {
 120     m_pCbUrl->SetText(rStrm.GetURL());
 121     ScDocument* pDoc = mpDocShell->GetDocument();
 122
 123     ScRange aRange = rStrm.GetRange();
 124     ScRange aTopRange = aRange;
 125     aTopRange.aEnd.SetRow(aTopRange.aStart.Row());
 126     OUString aStr = aTopRange.Format(SCR_ABS_3D, pDoc, pDoc->GetAddressConvention());
 127     m_pEdRange->SetText(aStr);
 128     SCROW nRows = aRange.aEnd.Row() - aRange.aStart.Row() + 1;
 129
 130     if (aRange.aEnd.Row() == MAXROW)
 131         m_pRBUnlimited->Check();
 132     else
 133     {
 134         m_pRBMaxLimit->Check();
 135         m_pEdLimit->SetText(OUString::number(nRows));
 136     }
 137
 138     DataStream::MoveType eMove = rStrm.GetMove();
 139     switch (eMove)
 140     {
 141         case DataStream::MOVE_DOWN:
 142             m_pRBDataDown->Check();
 143         break;
 144         break;
 145         case DataStream::RANGE_DOWN:
 146             m_pRBRangeDown->Check();
 147         break;
 148         case DataStream::MOVE_UP:
 149         case DataStream::NO_MOVE:
 150         default:
 151             ;
 152     }
 153
 154     m_pCBRefreshOnEmpty->Check(rStrm.IsRefreshOnEmptyLine());
 155
 156     UpdateEnable();
 157 }
 158
 159 void DataStreamDlg::StartStream()
 160 {
 161     ScRange aStartRange = GetStartRange();
 162     if (!aStartRange.IsValid())
 163         // Don't start the stream without a valid range.
 164         return;
 165
 166     sal_Int32 nLimit = 0;
 167     if (m_pRBMaxLimit->IsChecked())
 168         nLimit = m_pEdLimit->GetText().toInt32();
 169     OUString rURL = m_pCbUrl->GetText();
 170     sal_uInt32 nSettings = 0;
 171     if (m_pRBScriptData->IsChecked())
 172        nSettings |= DataStream::SCRIPT_STREAM;
 173     if (m_pRBValuesInLine->IsChecked())
 174        nSettings |= DataStream::VALUES_IN_LINE;
 175
 176     DataStream::MoveType eMove =
 177         m_pRBRangeDown->IsChecked() ? DataStream::RANGE_DOWN : DataStream::MOVE_DOWN;
 178
 179     DataStream* pStream = DataStream::Set(mpDocShell, rURL, aStartRange, nLimit, eMove, nSettings);
 180     pStream->SetRefreshOnEmptyLine(m_pCBRefreshOnEmpty->IsChecked());
 181     DataStream::MakeToolbarVisible();
 182     pStream->StartImport();
 183 }
 184
 185 }
 186
 187 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */