sc/source/ui/miscdlgs/linkarea.cxx

   1 /*************************************************************************
   2  *
   3  * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
   4  *
   5  * Copyright 2008 by Sun Microsystems, Inc.
   6  *
   7  * OpenOffice.org - a multi-platform office productivity suite
   8  *
   9  * $RCSfile: linkarea.cxx,v $
  10  * $Revision: 1.17 $
  11  *
  12  * This file is part of OpenOffice.org.
  13  *
  14  * OpenOffice.org is free software: you can redistribute it and/or modify
  15  * it under the terms of the GNU Lesser General Public License version 3
  16  * only, as published by the Free Software Foundation.
  17  *
  18  * OpenOffice.org is distributed in the hope that it will be useful,
  19  * but WITHOUT ANY WARRANTY; without even the implied warranty of
  20  * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  21  * GNU Lesser General Public License version 3 for more details
  22  * (a copy is included in the LICENSE file that accompanied this code).
  23  *
  24  * You should have received a copy of the GNU Lesser General Public License
  25  * version 3 along with OpenOffice.org.  If not, see
  26  * <http://www.openoffice.org/license.html>
  27  * for a copy of the LGPLv3 License.
  28  *
  29  ************************************************************************/
  30
  31 // MARKER(update_precomp.py): autogen include statement, do not remove
  32 #include "precompiled_sc.hxx"
  33
  34 #undef SC_DLLIMPLEMENTATION
  35
  36
  37
  38 //------------------------------------------------------------------
  39
  40 #include <sfx2/app.hxx>
  41 #include <sfx2/docfile.hxx>
  42 #include <sfx2/docfilt.hxx>
  43 #include <sfx2/docinsert.hxx>
  44 #include <sfx2/fcontnr.hxx>
  45 #include <sfx2/filedlghelper.hxx>
  46 #include <svtools/ehdl.hxx>
  47 #include <svtools/sfxecode.hxx>
  48 #include <vcl/waitobj.hxx>
  49
  50 #include "linkarea.hxx"
  51 #include "linkarea.hrc"
  52 #include "scresid.hxx"
  53 #include "sc.hrc"
  54 #include "rangeutl.hxx"
  55 #include "docsh.hxx"
  56 #include "tablink.hxx"
  57
  58 //==================================================================
  59
  60 ScLinkedAreaDlg::ScLinkedAreaDlg( Window* pParent ) :
  61         ModalDialog ( pParent, ScResId( RID_SCDLG_LINKAREA ) ),
  62         //
  63         aFlLocation     ( this, ScResId( FL_LOCATION ) ),
  64         aCbUrl          ( this, ScResId( CB_URL ) ),
  65         aBtnBrowse      ( this, ScResId( BTN_BROWSE ) ),
  66         aTxtHint        ( this, ScResId( FT_HINT ) ),
  67         aFtRanges       ( this, ScResId( FT_RANGES ) ),
  68         aLbRanges       ( this, ScResId( LB_RANGES ) ),
  69         aBtnReload      ( this, ScResId( BTN_RELOAD ) ),
  70         aNfDelay        ( this, ScResId( NF_DELAY ) ),
  71         aFtSeconds      ( this, ScResId( FT_SECONDS ) ),
  72         aBtnOk          ( this, ScResId( BTN_OK ) ),
  73         aBtnCancel      ( this, ScResId( BTN_CANCEL ) ),
  74         aBtnHelp        ( this, ScResId( BTN_HELP ) ),
  75         //
  76     pSourceShell( NULL ),
  77     pDocInserter( NULL )
  78
  79 {
  80         FreeResource();
  81
  82         aCbUrl.SetHelpId( HID_SCDLG_LINKAREAURL );      // SvtURLBox ctor always sets SID_OPENURL
  83         aCbUrl.SetSelectHdl( LINK( this, ScLinkedAreaDlg, FileHdl ) );
  84         aBtnBrowse.SetClickHdl( LINK( this, ScLinkedAreaDlg, BrowseHdl ) );
  85         aLbRanges.SetSelectHdl( LINK( this, ScLinkedAreaDlg, RangeHdl ) );
  86         aBtnReload.SetClickHdl( LINK( this, ScLinkedAreaDlg, ReloadHdl ) );
  87         UpdateEnable();
  88 }
  89
  90 ScLinkedAreaDlg::~ScLinkedAreaDlg()
  91 {
  92         // pSourceShell is deleted by aSourceRef
  93 }
  94
  95 short ScLinkedAreaDlg::Execute()
  96 {
  97         // set parent for file dialog or filter options
  98
  99         Window* pOldDefParent = Application::GetDefDialogParent();
 100         Application::SetDefDialogParent( this );
 101
 102         short nRet = ModalDialog::Execute();
 103
 104         Application::SetDefDialogParent( pOldDefParent );
 105
 106         return nRet;
 107 }
 108
 109 #define FILTERNAME_HTML  "HTML (StarCalc)"
 110 #define FILTERNAME_QUERY "calc_HTML_WebQuery"
 111
 112 IMPL_LINK( ScLinkedAreaDlg, BrowseHdl, PushButton*, EMPTYARG )
 113 {
 114     if ( !pDocInserter )
 115         pDocInserter = new sfx2::DocumentInserter(
 116             0, String::CreateFromAscii( ScDocShell::Factory().GetShortName() ) );
 117     pDocInserter->StartExecuteModal( LINK( this, ScLinkedAreaDlg, DialogClosedHdl ) );
 118     return 0;
 119 }
 120
 121 IMPL_LINK( ScLinkedAreaDlg, FileHdl, ComboBox*, EMPTYARG )
 122 {
 123         String aEntered = aCbUrl.GetURL();
 124         if (pSourceShell)
 125         {
 126                 SfxMedium* pMed = pSourceShell->GetMedium();
 127                 if ( pMed->GetName() == aEntered )
 128                 {
 129                         //      already loaded - nothing to do
 130                         return 0;
 131                 }
 132         }
 133
 134         String aFilter;
 135         String aOptions;
 136         //      get filter name by looking at the file content (bWithContent = TRUE)
 137     // Break operation if any error occured inside.
 138     if (!ScDocumentLoader::GetFilterName( aEntered, aFilter, aOptions, TRUE, TRUE ))
 139         return 0;
 140
 141     // #i53241# replace HTML filter with DataQuery filter
 142     if( aFilter.EqualsAscii( FILTERNAME_HTML ) )
 143         aFilter.AssignAscii( FILTERNAME_QUERY );
 144
 145         LoadDocument( aEntered, aFilter, aOptions );
 146
 147         UpdateSourceRanges();
 148         UpdateEnable();
 149         return 0;
 150 }
 151
 152 void ScLinkedAreaDlg::LoadDocument( const String& rFile, const String& rFilter, const String& rOptions )
 153 {
 154         if ( pSourceShell )
 155         {
 156                 //      unload old document
 157                 pSourceShell->DoClose();
 158                 pSourceShell = NULL;
 159                 aSourceRef.Clear();
 160         }
 161
 162         if ( rFile.Len() )
 163         {
 164                 WaitObject aWait( this );
 165
 166                 String aNewFilter = rFilter;
 167                 String aNewOptions = rOptions;
 168
 169                 SfxErrorContext aEc( ERRCTX_SFX_OPENDOC, rFile );
 170
 171                 ScDocumentLoader aLoader( rFile, aNewFilter, aNewOptions, 0, TRUE );    // with interaction
 172                 pSourceShell = aLoader.GetDocShell();
 173                 if ( pSourceShell )
 174                 {
 175                         ULONG nErr = pSourceShell->GetErrorCode();
 176                         if (nErr)
 177                                 ErrorHandler::HandleError( nErr );              // including warnings
 178
 179                         aSourceRef = pSourceShell;
 180                         aLoader.ReleaseDocRef();        // don't call DoClose in DocLoader dtor
 181                 }
 182         }
 183 }
 184
 185 void ScLinkedAreaDlg::InitFromOldLink( const String& rFile, const String& rFilter,
 186                                                                                 const String& rOptions, const String& rSource,
 187                                                                                 ULONG nRefresh )
 188 {
 189         LoadDocument( rFile, rFilter, rOptions );
 190         if (pSourceShell)
 191         {
 192                 SfxMedium* pMed = pSourceShell->GetMedium();
 193                 aCbUrl.SetText( pMed->GetName() );
 194         }
 195         else
 196                 aCbUrl.SetText( EMPTY_STRING );
 197
 198         UpdateSourceRanges();
 199
 200         xub_StrLen nRangeCount = rSource.GetTokenCount();
 201         for ( xub_StrLen i=0; i<nRangeCount; i++ )
 202         {
 203                 String aRange = rSource.GetToken(i);
 204                 aLbRanges.SelectEntry( aRange );
 205         }
 206
 207         BOOL bDoRefresh = ( nRefresh != 0 );
 208         aBtnReload.Check( bDoRefresh );
 209         if (bDoRefresh)
 210                 aNfDelay.SetValue( nRefresh );
 211
 212         UpdateEnable();
 213 }
 214
 215 IMPL_LINK( ScLinkedAreaDlg, RangeHdl, MultiListBox*, EMPTYARG )
 216 {
 217         UpdateEnable();
 218         return 0;
 219 }
 220
 221 IMPL_LINK( ScLinkedAreaDlg, ReloadHdl, CheckBox*, EMPTYARG )
 222 {
 223     UpdateEnable();
 224     return 0;
 225 }
 226
 227 IMPL_LINK( ScLinkedAreaDlg, DialogClosedHdl, sfx2::FileDialogHelper*, _pFileDlg )
 228 {
 229     if ( _pFileDlg->GetError() != ERRCODE_NONE )
 230         return 0;
 231
 232     SfxMedium* pMed = pDocInserter->CreateMedium();
 233     if ( pMed )
 234     {
 235         WaitObject aWait( this );
 236
 237         // #92296# replace HTML filter with DataQuery filter
 238         const String aHTMLFilterName( RTL_CONSTASCII_USTRINGPARAM( FILTERNAME_HTML ) );
 239         const String aWebQFilterName( RTL_CONSTASCII_USTRINGPARAM( FILTERNAME_QUERY ) );
 240
 241         const SfxFilter* pFilter = pMed->GetFilter();
 242         if( pFilter && (pFilter->GetFilterName() == aHTMLFilterName) )
 243         {
 244             const SfxFilter* pNewFilter =
 245                 ScDocShell::Factory().GetFilterContainer()->GetFilter4FilterName( aWebQFilterName );
 246             if( pNewFilter )
 247                 pMed->SetFilter( pNewFilter );
 248         }
 249
 250         //  ERRCTX_SFX_OPENDOC -> "Fehler beim Laden des Dokumentes"
 251         SfxErrorContext aEc( ERRCTX_SFX_OPENDOC, pMed->GetName() );
 252
 253         if (pSourceShell)
 254             pSourceShell->DoClose();        // deleted when assigning aSourceRef
 255
 256         pMed->UseInteractionHandler( TRUE );    // to enable the filter options dialog
 257
 258         pSourceShell = new ScDocShell;
 259         aSourceRef = pSourceShell;
 260         pSourceShell->DoLoad( pMed );
 261
 262         ULONG nErr = pSourceShell->GetErrorCode();
 263         if (nErr)
 264             ErrorHandler::HandleError( nErr );              // including warnings
 265
 266         if ( !pSourceShell->GetError() )                    // only errors
 267         {
 268             //aCbUrl.SetText( pSourceShell->GetTitle( SFX_TITLE_FULLNAME ) );
 269             aCbUrl.SetText( pMed->GetName() );
 270         }
 271         else
 272         {
 273             pSourceShell->DoClose();
 274             pSourceShell = NULL;
 275             aSourceRef.Clear();
 276
 277             aCbUrl.SetText( EMPTY_STRING );
 278         }
 279     }
 280
 281     UpdateSourceRanges();
 282     UpdateEnable();
 283     return 0;
 284 }
 285
 286 #undef FILTERNAME_HTML
 287 #undef FILTERNAME_QUERY
 288
 289 void ScLinkedAreaDlg::UpdateSourceRanges()
 290 {
 291         aLbRanges.SetUpdateMode( FALSE );
 292
 293         aLbRanges.Clear();
 294         if ( pSourceShell )
 295         {
 296                 ScAreaNameIterator aIter( pSourceShell->GetDocument() );
 297                 ScRange aDummy;
 298                 String aName;
 299                 while ( aIter.Next( aName, aDummy ) )
 300                         aLbRanges.InsertEntry( aName );
 301         }
 302
 303         aLbRanges.SetUpdateMode( TRUE );
 304
 305         if ( aLbRanges.GetEntryCount() == 1 )
 306                 aLbRanges.SelectEntryPos(0);
 307 }
 308
 309 void ScLinkedAreaDlg::UpdateEnable()
 310 {
 311         BOOL bEnable = ( pSourceShell && aLbRanges.GetSelectEntryCount() );
 312         aBtnOk.Enable( bEnable );
 313
 314         BOOL bReload = aBtnReload.IsChecked();
 315         aNfDelay.Enable( bReload );
 316         aFtSeconds.Enable( bReload );
 317 }
 318
 319 String ScLinkedAreaDlg::GetURL()
 320 {
 321         if (pSourceShell)
 322         {
 323                 SfxMedium* pMed = pSourceShell->GetMedium();
 324                 return pMed->GetName();
 325         }
 326         return EMPTY_STRING;
 327 }
 328
 329 String ScLinkedAreaDlg::GetFilter()
 330 {
 331         if (pSourceShell)
 332         {
 333                 SfxMedium* pMed = pSourceShell->GetMedium();
 334                 return pMed->GetFilter()->GetFilterName();
 335         }
 336         return EMPTY_STRING;
 337 }
 338
 339 String ScLinkedAreaDlg::GetOptions()
 340 {
 341         if (pSourceShell)
 342         {
 343                 SfxMedium* pMed = pSourceShell->GetMedium();
 344                 return ScDocumentLoader::GetOptions( *pMed );
 345         }
 346         return EMPTY_STRING;
 347 }
 348
 349 String ScLinkedAreaDlg::GetSource()
 350 {
 351         String aSource;
 352         USHORT nCount = aLbRanges.GetSelectEntryCount();
 353         for (USHORT i=0; i<nCount; i++)
 354         {
 355                 if (i > 0)
 356                         aSource.Append( (sal_Unicode) ';' );
 357                 aSource.Append( aLbRanges.GetSelectEntry( i ) );
 358         }
 359         return aSource;
 360 }
 361
 362 ULONG ScLinkedAreaDlg::GetRefresh()
 363 {
 364         if ( aBtnReload.IsChecked() )
 365         return sal::static_int_cast<ULONG>( aNfDelay.GetValue() );
 366         else
 367                 return 0;       // disabled
 368 }
 369