sc/source/ui/dbgui/dbnamdlg.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  * This file incorporates work covered by the following license notice:
  10  *
  11  *   Licensed to the Apache Software Foundation (ASF) under one or more
  12  *   contributor license agreements. See the NOTICE file distributed
  13  *   with this work for additional information regarding copyright
  14  *   ownership. The ASF licenses this file to you under the Apache
  15  *   License, Version 2.0 (the "License"); you may not use this file
  16  *   except in compliance with the License. You may obtain a copy of
  17  *   the License at http://www.apache.org/licenses/LICENSE-2.0 .
  18  */
  19
  20 #include <sal/config.h>
  21
  22 #include <cassert>
  23
  24 #include <comphelper/string.hxx>
  25 #include <vcl/msgbox.hxx>
  26
  27 #include "reffact.hxx"
  28 #include "document.hxx"
  29 #include "scresid.hxx"
  30 #include "globstr.hrc"
  31 #include "rangenam.hxx"
  32 #include "globalnames.hxx"
  33 #include "dbnamdlg.hxx"
  34 #include <dbdocfun.hxx>
  35
  36 #define ABS_SREF          SCA_VALID \
  37                         | SCA_COL_ABSOLUTE | SCA_ROW_ABSOLUTE | SCA_TAB_ABSOLUTE
  38 #define ABS_DREF          ABS_SREF \
  39                         | SCA_COL2_ABSOLUTE | SCA_ROW2_ABSOLUTE | SCA_TAB2_ABSOLUTE
  40 #define ABS_DREF3D      ABS_DREF | SCA_TAB_3D
  41
  42 class DBSaveData;
  43
  44 static DBSaveData* pSaveObj = NULL;
  45
  46 #define ERRORBOX(s) ScopedVclPtrInstance<MessageDialog>::Create(this, s)->Execute()
  47
  48 //  class DBSaveData
  49
  50 class DBSaveData
  51 {
  52 public:
  53     DBSaveData( Edit& rEd, CheckBox& rHdr, CheckBox& rTot, CheckBox& rSize, CheckBox& rFmt,
  54                             CheckBox& rStrip, ScRange& rArea )
  55         : rEdAssign(rEd)
  56         , rBtnHeader(rHdr)
  57         , rBtnTotals(rTot)
  58         , rBtnSize(rSize)
  59         , rBtnFormat(rFmt)
  60         , rBtnStrip(rStrip)
  61         , rCurArea(rArea)
  62         , bHeader(false)
  63         , bTotals(false)
  64         , bSize(false)
  65         , bFormat(false)
  66         , bStrip(false)
  67         , bDirty(false)
  68     {
  69     }
  70     void Save();
  71     void Restore();
  72
  73 private:
  74     Edit&       rEdAssign;
  75     CheckBox&   rBtnHeader;
  76     CheckBox&   rBtnTotals;
  77     CheckBox&   rBtnSize;
  78     CheckBox&   rBtnFormat;
  79     CheckBox&   rBtnStrip;
  80     ScRange&    rCurArea;
  81     OUString    aStr;
  82     ScRange     aArea;
  83     bool        bHeader:1;
  84     bool        bTotals:1;
  85     bool        bSize:1;
  86     bool        bFormat:1;
  87     bool        bStrip:1;
  88     bool        bDirty:1;
  89 };
  90
  91 void DBSaveData::Save()
  92 {
  93     aArea   = rCurArea;
  94     aStr    = rEdAssign.GetText();
  95     bHeader = rBtnHeader.IsChecked();
  96     bTotals = rBtnTotals.IsChecked();
  97     bSize   = rBtnSize.IsChecked();
  98     bFormat = rBtnFormat.IsChecked();
  99     bStrip  = rBtnStrip.IsChecked();
 100     bDirty  = true;
 101 }
 102
 103 void DBSaveData::Restore()
 104 {
 105     if ( bDirty )
 106     {
 107         rCurArea = aArea;
 108         rEdAssign.SetText( aStr );
 109         rBtnHeader.Check ( bHeader );
 110         rBtnTotals.Check ( bTotals );
 111         rBtnSize.Check   ( bSize );
 112         rBtnFormat.Check ( bFormat );
 113         rBtnStrip.Check  ( bStrip );
 114         bDirty = false;
 115     }
 116 }
 117
 118 //  class ScDbNameDlg
 119
 120 ScDbNameDlg::ScDbNameDlg(SfxBindings* pB, SfxChildWindow* pCW, vcl::Window* pParent,
 121     ScViewData* ptrViewData)
 122     : ScAnyRefDlg(pB, pCW, pParent,
 123         "DefineDatabaseRangeDialog",
 124             "modules/scalc/ui/definedatabaserangedialog.ui")
 125     , pViewData(ptrViewData)
 126     , pDoc(ptrViewData->GetDocument())
 127     , bRefInputMode(false)
 128     , aAddrDetails(pDoc->GetAddressConvention(), 0, 0)
 129     , aLocalDbCol(*(pDoc->GetDBCollection()))
 130 {
 131     get(m_pEdName, "entry");
 132     m_pEdName->set_height_request(m_pEdName->GetOptimalSize().Height() + m_pEdName->GetTextHeight() * 8);
 133     get(m_pEdAssign, "assign");
 134     get(m_pAssignFrame, "RangeFrame");
 135     m_pEdAssign->SetReferences(this, m_pAssignFrame->get_label_widget());
 136     get(m_pRbAssign, "assignrb");
 137     m_pRbAssign->SetReferences(this, m_pEdAssign);
 138     get(m_pOptions, "Options");
 139     get(m_pBtnHeader, "ContainsColumnLabels");
 140     get(m_pBtnTotals, "ContainsTotalsRow");
 141     get(m_pBtnDoSize, "InsertOrDeleteCells");
 142     get(m_pBtnKeepFmt, "KeepFormatting");
 143     get(m_pBtnStripData, "DontSaveImportedData");
 144     get(m_pFTSource, "Source");
 145     get(m_pFTOperations, "Operations");
 146     get(m_pBtnOk, "ok");
 147     get(m_pBtnCancel, "cancel");
 148     get(m_pBtnAdd, "add");
 149     aStrAdd = m_pBtnAdd->GetText();
 150     aStrModify = get<vcl::Window>("modify")->GetText();
 151     get(m_pBtnRemove, "delete");
 152     aStrInvalid = get<vcl::Window>("invalid")->GetText();
 153
 154     m_pFTSource->SetStyle(m_pFTSource->GetStyle() | WB_NOLABEL);
 155     m_pFTOperations->SetStyle(m_pFTOperations->GetStyle() | WB_NOLABEL);
 156
 157     //  damit die Strings in der Resource bei den FixedTexten bleiben koennen:
 158     aStrSource      = m_pFTSource->GetText();
 159     aStrOperations  = m_pFTOperations->GetText();
 160
 161     pSaveObj = new DBSaveData( *m_pEdAssign, *m_pBtnHeader, *m_pBtnTotals,
 162                         *m_pBtnDoSize, *m_pBtnKeepFmt, *m_pBtnStripData, theCurArea );
 163     Init();
 164 }
 165
 166 ScDbNameDlg::~ScDbNameDlg()
 167 {
 168     disposeOnce();
 169 }
 170
 171 void ScDbNameDlg::dispose()
 172 {
 173     DELETEZ( pSaveObj );
 174     m_pEdName.clear();
 175     m_pAssignFrame.clear();
 176     m_pEdAssign.clear();
 177     m_pRbAssign.clear();
 178     m_pOptions.clear();
 179     m_pBtnHeader.clear();
 180     m_pBtnTotals.clear();
 181     m_pBtnDoSize.clear();
 182     m_pBtnKeepFmt.clear();
 183     m_pBtnStripData.clear();
 184     m_pFTSource.clear();
 185     m_pFTOperations.clear();
 186     m_pBtnOk.clear();
 187     m_pBtnCancel.clear();
 188     m_pBtnAdd.clear();
 189     m_pBtnRemove.clear();
 190     ScAnyRefDlg::dispose();
 191 }
 192
 193 void ScDbNameDlg::Init()
 194 {
 195     m_pBtnHeader->Check( true );       // Default: with column headers
 196     m_pBtnTotals->Check( false );      // Default: without totals row
 197     m_pBtnDoSize->Check( true );
 198     m_pBtnKeepFmt->Check( true );
 199
 200     m_pBtnOk->SetClickHdl      ( LINK( this, ScDbNameDlg, OkBtnHdl ) );
 201     m_pBtnCancel->SetClickHdl  ( LINK( this, ScDbNameDlg, CancelBtnHdl ) );
 202     m_pBtnAdd->SetClickHdl     ( LINK( this, ScDbNameDlg, AddBtnHdl ) );
 203     m_pBtnRemove->SetClickHdl  ( LINK( this, ScDbNameDlg, RemoveBtnHdl ) );
 204     m_pEdName->SetModifyHdl    ( LINK( this, ScDbNameDlg, NameModifyHdl ) );
 205     m_pEdAssign->SetModifyHdl  ( LINK( this, ScDbNameDlg, AssModifyHdl ) );
 206     UpdateNames();
 207
 208     OUString  theAreaStr;
 209
 210     if ( pViewData && pDoc )
 211     {
 212         SCCOL   nStartCol   = 0;
 213         SCROW   nStartRow   = 0;
 214         SCTAB   nStartTab   = 0;
 215         SCCOL   nEndCol     = 0;
 216         SCROW   nEndRow     = 0;
 217         SCTAB   nEndTab     = 0;
 218
 219         ScDBCollection* pDBColl = pDoc->GetDBCollection();
 220         ScDBData*       pDBData = NULL;
 221
 222         pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab,
 223                                   nEndCol,   nEndRow,  nEndTab );
 224
 225         theCurArea = ScRange( ScAddress( nStartCol, nStartRow, nStartTab ),
 226                               ScAddress( nEndCol,   nEndRow,   nEndTab ) );
 227
 228         theAreaStr = theCurArea.Format(ABS_DREF3D, pDoc, aAddrDetails);
 229
 230         if ( pDBColl )
 231         {
 232             // Feststellen, ob definierter DB-Bereich markiert wurde:
 233             pDBData = pDBColl->GetDBAtCursor( nStartCol, nStartRow, nStartTab, true );
 234             if ( pDBData )
 235             {
 236                 ScAddress&  rStart = theCurArea.aStart;
 237                 ScAddress&  rEnd   = theCurArea.aEnd;
 238                 SCCOL nCol1;
 239                 SCCOL  nCol2;
 240                 SCROW  nRow1;
 241                 SCROW  nRow2;
 242                 SCTAB  nTab;
 243
 244                 pDBData->GetArea( nTab, nCol1, nRow1, nCol2, nRow2 );
 245
 246                 if (   (rStart.Tab() == nTab)
 247                     && (rStart.Col() == nCol1) && (rStart.Row() == nRow1)
 248                     && (rEnd.Col()   == nCol2) && (rEnd.Row()   == nRow2 ) )
 249                 {
 250                     OUString aDBName = pDBData->GetName();
 251                     if ( aDBName != STR_DB_LOCAL_NONAME )
 252                         m_pEdName->SetText(aDBName);
 253
 254                     m_pBtnHeader->Check( pDBData->HasHeader() );
 255                     m_pBtnTotals->Check( pDBData->HasTotals() );
 256                     m_pBtnDoSize->Check( pDBData->IsDoSize() );
 257                     m_pBtnKeepFmt->Check( pDBData->IsKeepFmt() );
 258                     m_pBtnStripData->Check( pDBData->IsStripData() );
 259                     SetInfoStrings( pDBData );
 260                 }
 261             }
 262         }
 263     }
 264
 265     m_pEdAssign->SetText( theAreaStr );
 266     m_pEdName->GrabFocus();
 267     bSaved = true;
 268     pSaveObj->Save();
 269     NameModifyHdl( 0 );
 270 }
 271
 272 void ScDbNameDlg::SetInfoStrings( const ScDBData* pDBData )
 273 {
 274     OUStringBuffer aBuf;
 275     aBuf.append(aStrSource);
 276     if (pDBData)
 277     {
 278         aBuf.append(' ');
 279         aBuf.append(pDBData->GetSourceString());
 280     }
 281     m_pFTSource->SetText(aBuf.makeStringAndClear());
 282
 283     aBuf.append(aStrOperations);
 284     if (pDBData)
 285     {
 286         aBuf.append(' ');
 287         aBuf.append(pDBData->GetOperations());
 288     }
 289     m_pFTOperations->SetText(aBuf.makeStringAndClear());
 290 }
 291
 292 // Uebergabe eines mit der Maus selektierten Tabellenbereiches, der dann als
 293 //  neue Selektion im Referenz-Fenster angezeigt wird.
 294
 295 void ScDbNameDlg::SetReference( const ScRange& rRef, ScDocument* pDocP )
 296 {
 297     if ( m_pEdAssign->IsEnabled() )
 298     {
 299         if ( rRef.aStart != rRef.aEnd )
 300             RefInputStart(m_pEdAssign);
 301
 302         theCurArea = rRef;
 303
 304         OUString aRefStr(theCurArea.Format(ABS_DREF3D, pDocP, aAddrDetails));
 305         m_pEdAssign->SetRefString( aRefStr );
 306         m_pOptions->Enable();
 307         m_pBtnAdd->Enable();
 308         bSaved = true;
 309         pSaveObj->Save();
 310     }
 311 }
 312
 313 bool ScDbNameDlg::Close()
 314 {
 315     return DoClose( ScDbNameDlgWrapper::GetChildWindowId() );
 316 }
 317
 318 void ScDbNameDlg::SetActive()
 319 {
 320     m_pEdAssign->GrabFocus();
 321
 322     //  kein NameModifyHdl, weil sonst Bereiche nicht geaendert werden koennen
 323     //  (nach dem Aufziehen der Referenz wuerde der alte Inhalt wieder angezeigt)
 324     //  (der ausgewaehlte DB-Name hat sich auch nicht veraendert)
 325
 326     RefInputDone();
 327 }
 328
 329 void ScDbNameDlg::UpdateNames()
 330 {
 331     typedef ScDBCollection::NamedDBs DBsType;
 332
 333     const DBsType& rDBs = aLocalDbCol.getNamedDBs();
 334
 335     m_pEdName->SetUpdateMode( false );
 336
 337     m_pEdName->Clear();
 338     m_pEdAssign->SetText( EMPTY_OUSTRING );
 339
 340     if (!rDBs.empty())
 341     {
 342         DBsType::const_iterator itr = rDBs.begin(), itrEnd = rDBs.end();
 343         for (; itr != itrEnd; ++itr)
 344             m_pEdName->InsertEntry(itr->GetName());
 345     }
 346     else
 347     {
 348         m_pBtnAdd->SetText( aStrAdd );
 349         m_pBtnAdd->Disable();
 350         m_pBtnRemove->Disable();
 351     }
 352
 353     m_pEdName->SetUpdateMode( true );
 354     m_pEdName->Invalidate();
 355 }
 356
 357 void ScDbNameDlg::UpdateDBData( const OUString& rStrName )
 358 {
 359
 360     const ScDBData* pData = aLocalDbCol.getNamedDBs().findByUpperName(ScGlobal::pCharClass->uppercase(rStrName));
 361
 362     if ( pData )
 363     {
 364         SCCOL nColStart = 0;
 365         SCROW nRowStart = 0;
 366         SCCOL nColEnd    = 0;
 367         SCROW nRowEnd    = 0;
 368         SCTAB nTab       = 0;
 369
 370         pData->GetArea( nTab, nColStart, nRowStart, nColEnd, nRowEnd );
 371         theCurArea = ScRange( ScAddress( nColStart, nRowStart, nTab ),
 372                               ScAddress( nColEnd,   nRowEnd,   nTab ) );
 373         OUString theArea(theCurArea.Format(ABS_DREF3D, pDoc, aAddrDetails));
 374         m_pEdAssign->SetText( theArea );
 375         m_pBtnAdd->SetText( aStrModify );
 376         m_pBtnHeader->Check( pData->HasHeader() );
 377         m_pBtnTotals->Check( pData->HasTotals() );
 378         m_pBtnDoSize->Check( pData->IsDoSize() );
 379         m_pBtnKeepFmt->Check( pData->IsKeepFmt() );
 380         m_pBtnStripData->Check( pData->IsStripData() );
 381         SetInfoStrings( pData );
 382     }
 383
 384     m_pBtnAdd->SetText( aStrModify );
 385     m_pBtnAdd->Enable();
 386     m_pBtnRemove->Enable();
 387     m_pOptions->Enable();
 388 }
 389
 390 bool ScDbNameDlg::IsRefInputMode() const
 391 {
 392     return bRefInputMode;
 393 }
 394
 395 // Handler:
 396
 397 IMPL_LINK_NOARG(ScDbNameDlg, OkBtnHdl)
 398 {
 399     AddBtnHdl( 0 );
 400
 401     // Der View die Aenderungen und die Remove-Liste uebergeben:
 402     // beide werden nur als Referenz uebergeben, so dass an dieser
 403     // Stelle keine Speicherleichen entstehen koennen:
 404     if ( pViewData )
 405     {
 406         ScDBDocFunc aFunc(*pViewData->GetDocShell());
 407         aFunc.ModifyAllDBData(aLocalDbCol, aRemoveList);
 408     }
 409
 410     Close();
 411     return 0;
 412 }
 413
 414 IMPL_LINK_NOARG(ScDbNameDlg, CancelBtnHdl)
 415 {
 416     Close();
 417     return 0;
 418 }
 419
 420 IMPL_LINK_NOARG(ScDbNameDlg, AddBtnHdl)
 421 {
 422     OUString  aNewName = comphelper::string::strip(m_pEdName->GetText(), ' ');
 423     OUString  aNewArea = m_pEdAssign->GetText();
 424
 425     if ( !aNewName.isEmpty() && !aNewArea.isEmpty() )
 426     {
 427         if ( ScRangeData::IsNameValid( aNewName, pDoc ) && aNewName != STR_DB_LOCAL_NONAME )
 428         {
 429             //  weil jetzt editiert werden kann, muss erst geparst werden
 430             ScRange aTmpRange;
 431             OUString aText = m_pEdAssign->GetText();
 432             if ( aTmpRange.ParseAny( aText, pDoc, aAddrDetails ) & SCA_VALID )
 433             {
 434                 theCurArea = aTmpRange;
 435                 ScAddress aStart = theCurArea.aStart;
 436                 ScAddress aEnd   = theCurArea.aEnd;
 437
 438                 ScDBData* pOldEntry = aLocalDbCol.getNamedDBs().findByUpperName(ScGlobal::pCharClass->uppercase(aNewName));
 439                 if (pOldEntry)
 440                 {
 441                     //  Bereich veraendern
 442
 443                     pOldEntry->MoveTo( aStart.Tab(), aStart.Col(), aStart.Row(),
 444                                                         aEnd.Col(), aEnd.Row() );
 445                     pOldEntry->SetByRow( true );
 446                     pOldEntry->SetHeader( m_pBtnHeader->IsChecked() );
 447                     pOldEntry->SetTotals( m_pBtnTotals->IsChecked() );
 448                     pOldEntry->SetDoSize( m_pBtnDoSize->IsChecked() );
 449                     pOldEntry->SetKeepFmt( m_pBtnKeepFmt->IsChecked() );
 450                     pOldEntry->SetStripData( m_pBtnStripData->IsChecked() );
 451                 }
 452                 else
 453                 {
 454                     //  neuen Bereich einfuegen
 455
 456                     ScDBData* pNewEntry = new ScDBData( aNewName, aStart.Tab(),
 457                                                         aStart.Col(), aStart.Row(),
 458                                                         aEnd.Col(), aEnd.Row(),
 459                                                         true, m_pBtnHeader->IsChecked(),
 460                                                         m_pBtnTotals->IsChecked() );
 461                     pNewEntry->SetDoSize( m_pBtnDoSize->IsChecked() );
 462                     pNewEntry->SetKeepFmt( m_pBtnKeepFmt->IsChecked() );
 463                     pNewEntry->SetStripData( m_pBtnStripData->IsChecked() );
 464
 465                     bool ins = aLocalDbCol.getNamedDBs().insert(pNewEntry);
 466                     assert(ins); (void)ins;
 467                 }
 468
 469                 UpdateNames();
 470
 471                 m_pEdName->SetText( EMPTY_OUSTRING );
 472                 m_pEdName->GrabFocus();
 473                 m_pBtnAdd->SetText( aStrAdd );
 474                 m_pBtnAdd->Disable();
 475                 m_pBtnRemove->Disable();
 476                 m_pEdAssign->SetText( EMPTY_OUSTRING );
 477                 m_pBtnHeader->Check( true );       // Default: with column headers
 478                 m_pBtnTotals->Check( false );      // Default: without totals row
 479                 m_pBtnDoSize->Check( false );
 480                 m_pBtnKeepFmt->Check( false );
 481                 m_pBtnStripData->Check( false );
 482                 SetInfoStrings( NULL );     // leer
 483                 theCurArea = ScRange();
 484                 bSaved = true;
 485                 pSaveObj->Save();
 486                 NameModifyHdl( 0 );
 487             }
 488             else
 489             {
 490                 ERRORBOX( aStrInvalid );
 491                 m_pEdAssign->SetSelection( Selection( 0, SELECTION_MAX ) );
 492                 m_pEdAssign->GrabFocus();
 493             }
 494         }
 495         else
 496         {
 497             ERRORBOX( ScGlobal::GetRscString(STR_INVALIDNAME) );
 498             m_pEdName->SetSelection( Selection( 0, SELECTION_MAX ) );
 499             m_pEdName->GrabFocus();
 500         }
 501     }
 502     return 0;
 503 }
 504
 505 namespace {
 506
 507 class FindByName : public ::std::unary_function<ScDBData, bool>
 508 {
 509     const OUString& mrName;
 510 public:
 511     FindByName(const OUString& rName) : mrName(rName) {}
 512     bool operator() (const ScDBData& r) const
 513     {
 514         return r.GetName().equals(mrName);
 515     }
 516 };
 517
 518 }
 519
 520 IMPL_LINK_NOARG(ScDbNameDlg, RemoveBtnHdl)
 521 {
 522     OUString aStrEntry = m_pEdName->GetText();
 523     ScDBCollection::NamedDBs& rDBs = aLocalDbCol.getNamedDBs();
 524     ScDBCollection::NamedDBs::iterator itr =
 525         ::std::find_if(rDBs.begin(), rDBs.end(), FindByName(aStrEntry));
 526
 527     if (itr != rDBs.end())
 528     {
 529         OUString aStrDelMsg = ScGlobal::GetRscString( STR_QUERY_DELENTRY );
 530
 531         OUStringBuffer aBuf;
 532         aBuf.append(aStrDelMsg.getToken(0, '#'));
 533         aBuf.append(aStrEntry);
 534         aBuf.append(aStrDelMsg.getToken(1, '#'));
 535         ScopedVclPtrInstance< QueryBox > aBox(this, WinBits(WB_YES_NO|WB_DEF_YES), aBuf.makeStringAndClear());
 536
 537         if (RET_YES == aBox->Execute())
 538         {
 539             SCTAB nTab;
 540             SCCOL nColStart, nColEnd;
 541             SCROW nRowStart, nRowEnd;
 542             itr->GetArea( nTab, nColStart, nRowStart, nColEnd, nRowEnd );
 543             aRemoveList.push_back(
 544                 ScRange( ScAddress( nColStart, nRowStart, nTab ),
 545                          ScAddress( nColEnd,   nRowEnd,   nTab ) ) );
 546
 547             rDBs.erase(itr);
 548
 549             UpdateNames();
 550
 551             m_pEdName->SetText( EMPTY_OUSTRING );
 552             m_pEdName->GrabFocus();
 553             m_pBtnAdd->SetText( aStrAdd );
 554             m_pBtnAdd->Disable();
 555             m_pBtnRemove->Disable();
 556             m_pEdAssign->SetText( EMPTY_OUSTRING );
 557             theCurArea = ScRange();
 558             m_pBtnHeader->Check( true );       // Default: with column headers
 559             m_pBtnTotals->Check( false );      // Default: without totals row
 560             m_pBtnDoSize->Check( false );
 561             m_pBtnKeepFmt->Check( false );
 562             m_pBtnStripData->Check( false );
 563             SetInfoStrings( NULL );     // leer
 564             bSaved=false;
 565             pSaveObj->Restore();
 566             NameModifyHdl( 0 );
 567         }
 568     }
 569     return 0;
 570 }
 571
 572 IMPL_LINK_NOARG(ScDbNameDlg, NameModifyHdl)
 573 {
 574     OUString  theName     = m_pEdName->GetText();
 575     bool    bNameFound  = (COMBOBOX_ENTRY_NOTFOUND
 576                            != m_pEdName->GetEntryPos( theName ));
 577
 578     if ( theName.isEmpty() )
 579     {
 580         if (m_pBtnAdd->GetText() != aStrAdd)
 581             m_pBtnAdd->SetText( aStrAdd );
 582         m_pBtnAdd->Disable();
 583         m_pBtnRemove->Disable();
 584         m_pAssignFrame->Disable();
 585         m_pOptions->Disable();
 586         //bSaved=sal_False;
 587         //pSaveObj->Restore();
 588         //@BugID 54702 Enablen/Disablen nur noch in Basisklasse
 589         //SFX_APPWINDOW->Disable(sal_False);        //! allgemeine Methode im ScAnyRefDlg
 590         bRefInputMode = false;
 591     }
 592     else
 593     {
 594         if ( bNameFound )
 595         {
 596             if (m_pBtnAdd->GetText() != aStrModify)
 597                 m_pBtnAdd->SetText( aStrModify );
 598
 599             if(!bSaved)
 600             {
 601                 bSaved = true;
 602                 pSaveObj->Save();
 603             }
 604             UpdateDBData( theName );
 605         }
 606         else
 607         {
 608             if (m_pBtnAdd->GetText() != aStrAdd)
 609                 m_pBtnAdd->SetText( aStrAdd );
 610
 611             bSaved=false;
 612             pSaveObj->Restore();
 613
 614             if ( !m_pEdAssign->GetText().isEmpty() )
 615             {
 616                 m_pBtnAdd->Enable();
 617                 m_pOptions->Enable();
 618             }
 619             else
 620             {
 621                 m_pBtnAdd->Disable();
 622                 m_pOptions->Disable();
 623             }
 624             m_pBtnRemove->Disable();
 625         }
 626
 627         m_pAssignFrame->Enable();
 628
 629         //@BugID 54702 Enablen/Disablen nur noch in Basisklasse
 630         //SFX_APPWINDOW->Enable();
 631         bRefInputMode = true;
 632     }
 633     return 0;
 634 }
 635
 636 IMPL_LINK_NOARG(ScDbNameDlg, AssModifyHdl)
 637 {
 638     //  hier parsen fuer Save() etc.
 639
 640     ScRange aTmpRange;
 641     OUString aText = m_pEdAssign->GetText();
 642     if ( aTmpRange.ParseAny( aText, pDoc, aAddrDetails ) & SCA_VALID )
 643         theCurArea = aTmpRange;
 644
 645     if (!aText.isEmpty() && !m_pEdName->GetText().isEmpty())
 646     {
 647         m_pBtnAdd->Enable();
 648         m_pBtnHeader->Enable();
 649         m_pBtnTotals->Enable();
 650         m_pBtnDoSize->Enable();
 651         m_pBtnKeepFmt->Enable();
 652         m_pBtnStripData->Enable();
 653         m_pFTSource->Enable();
 654         m_pFTOperations->Enable();
 655     }
 656     else
 657     {
 658         m_pBtnAdd->Disable();
 659         m_pBtnHeader->Disable();
 660         m_pBtnTotals->Disable();
 661         m_pBtnDoSize->Disable();
 662         m_pBtnKeepFmt->Disable();
 663         m_pBtnStripData->Disable();
 664         m_pFTSource->Disable();
 665         m_pFTOperations->Disable();
 666     }
 667
 668     return 0;
 669 }
 670
 671 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */