sc/source/ui/dbgui/dbnamdlg.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: dbnamdlg.cxx,v $
  10  * $Revision: 1.9.30.2 $
  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 // System - Includes ---------------------------------------------------------
  35
  36
  37
  38 // INCLUDE -------------------------------------------------------------------
  39
  40 #include <vcl/msgbox.hxx>
  41
  42 #include "reffact.hxx"
  43 #include "document.hxx"
  44 #include "scresid.hxx"
  45 #include "globstr.hrc"
  46 #include "dbnamdlg.hrc"
  47 #include "rangenam.hxx"         // IsNameValid
  48
  49 #define _DBNAMDLG_CXX
  50 #include "dbnamdlg.hxx"
  51 #undef _DBNAMDLG_CXX
  52
  53
  54 //============================================================================
  55
  56 #define ABS_SREF                  SCA_VALID \
  57                         | SCA_COL_ABSOLUTE | SCA_ROW_ABSOLUTE | SCA_TAB_ABSOLUTE
  58 #define ABS_DREF                  ABS_SREF \
  59                         | SCA_COL2_ABSOLUTE | SCA_ROW2_ABSOLUTE | SCA_TAB2_ABSOLUTE
  60 #define ABS_SREF3D              ABS_SREF | SCA_TAB_3D
  61 #define ABS_DREF3D              ABS_DREF | SCA_TAB_3D
  62
  63 //----------------------------------------------------------------------------
  64
  65 class DBSaveData;
  66
  67 static DBSaveData* pSaveObj = NULL;
  68
  69 #define ERRORBOX(s) ErrorBox(this,WinBits(WB_OK|WB_DEF_OK),s).Execute()
  70 #define QUERYBOX(m) QueryBox(this,WinBits(WB_YES_NO|WB_DEF_YES),m).Execute()
  71
  72 //============================================================================
  73 //      class DBSaveData
  74
  75 class DBSaveData
  76 {
  77 public:
  78     DBSaveData( Edit& rEd, CheckBox& rHdr, CheckBox& rSize, CheckBox& rFmt,
  79                             CheckBox& rStrip, ScRange& rArea )
  80         : rEdAssign(rEd),
  81           rBtnHeader(rHdr), rBtnSize(rSize), rBtnFormat(rFmt), rBtnStrip(rStrip),
  82           rCurArea(rArea),
  83           bHeader(FALSE), bSize(FALSE), bFormat(FALSE), bDirty(FALSE) {}
  84     void Save();
  85     void Restore();
  86
  87 private:
  88     Edit&               rEdAssign;
  89     CheckBox&   rBtnHeader;
  90     CheckBox&   rBtnSize;
  91     CheckBox&   rBtnFormat;
  92     CheckBox&   rBtnStrip;
  93     ScRange&    rCurArea;
  94     String              aStr;
  95     ScRange             aArea;
  96     BOOL                bHeader:1;
  97     BOOL                bSize:1;
  98     BOOL                bFormat:1;
  99     BOOL                bStrip:1;
 100     BOOL                bDirty:1;
 101 };
 102
 103
 104
 105 //----------------------------------------------------------------------------
 106
 107 void DBSaveData::Save()
 108 {
 109     aArea   = rCurArea;
 110     aStr    = rEdAssign.GetText();
 111     bHeader = rBtnHeader.IsChecked();
 112     bSize   = rBtnSize.IsChecked();
 113     bFormat = rBtnFormat.IsChecked();
 114     bStrip      = rBtnStrip.IsChecked();
 115     bDirty  = TRUE;
 116 }
 117
 118
 119 //----------------------------------------------------------------------------
 120
 121 void DBSaveData::Restore()
 122 {
 123     if ( bDirty )
 124     {
 125         rCurArea = aArea;
 126         rEdAssign.SetText( aStr );
 127         rBtnHeader.Check ( bHeader );
 128         rBtnSize.Check   ( bSize );
 129         rBtnFormat.Check ( bFormat );
 130         rBtnStrip.Check  ( bStrip );
 131         bDirty = FALSE;
 132     }
 133 }
 134
 135
 136 //============================================================================
 137 //      class ScDbNameDlg
 138
 139 //----------------------------------------------------------------------------
 140
 141 ScDbNameDlg::ScDbNameDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent,
 142                           ScViewData*   ptrViewData )
 143
 144     :   ScAnyRefDlg     ( pB, pCW, pParent, RID_SCDLG_DBNAMES ),
 145         //
 146         aFlName         ( this, ScResId( FL_NAME ) ),
 147         aEdName                 ( this, ScResId( ED_NAME ) ),
 148
 149         aFlAssign       ( this, ScResId( FL_ASSIGN ) ),
 150         aEdAssign       ( this, this, ScResId( ED_DBAREA ) ),
 151         aRbAssign               ( this, ScResId( RB_DBAREA ), &aEdAssign, this ),
 152
 153         aFlOptions      ( this, ScResId( FL_OPTIONS ) ),
 154         aBtnHeader              ( this, ScResId( BTN_HEADER ) ),
 155         aBtnDoSize              ( this, ScResId( BTN_SIZE ) ),
 156         aBtnKeepFmt             ( this, ScResId( BTN_FORMAT ) ),
 157         aBtnStripData   ( this, ScResId( BTN_STRIPDATA ) ),
 158         aFTSource               ( this, ScResId( FT_SOURCE ) ),
 159         aFTOperations   ( this, ScResId( FT_OPERATIONS ) ),
 160
 161         aBtnOk                  ( this, ScResId( BTN_OK ) ),
 162         aBtnCancel              ( this, ScResId( BTN_CANCEL ) ),
 163         aBtnHelp                ( this, ScResId( BTN_HELP ) ),
 164         aBtnAdd                 ( this, ScResId( BTN_ADD ) ),
 165         aBtnRemove              ( this, ScResId( BTN_REMOVE ) ),
 166         aBtnMore                ( this, ScResId( BTN_MORE ) ),
 167
 168         aStrAdd                 ( ScResId( STR_ADD ) ),
 169         aStrModify              ( ScResId( STR_MODIFY ) ),
 170         aStrNoName              ( ScGlobal::GetRscString(STR_DB_NONAME) ),
 171         aStrInvalid             ( ScResId( STR_DB_INVALID ) ),
 172         //
 173         pViewData               ( ptrViewData ),
 174         pDoc                    ( ptrViewData->GetDocument() ),
 175         bRefInputMode   ( FALSE ),
 176         aAddrDetails    ( pDoc->GetAddressConvention(), 0, 0 ),
 177         aLocalDbCol             ( *(pDoc->GetDBCollection()) )
 178 {
 179     // WB_NOLABEL can't be set in resource...
 180     aFTSource.SetStyle( aFTSource.GetStyle() | WB_NOLABEL );
 181     aFTOperations.SetStyle( aFTOperations.GetStyle() | WB_NOLABEL );
 182
 183     //  damit die Strings in der Resource bei den FixedTexten bleiben koennen:
 184     aStrSource          = aFTSource.GetText();
 185     aStrOperations      = aFTOperations.GetText();
 186
 187     pSaveObj = new DBSaveData( aEdAssign, aBtnHeader,
 188                         aBtnDoSize, aBtnKeepFmt, aBtnStripData, theCurArea );
 189     Init();
 190     FreeResource();
 191 }
 192
 193
 194 //----------------------------------------------------------------------------
 195
 196 __EXPORT ScDbNameDlg::~ScDbNameDlg()
 197 {
 198     DELETEZ( pSaveObj );
 199
 200     ScRange* pEntry = (ScRange*)aRemoveList.First();
 201     while ( pEntry )
 202     {
 203         aRemoveList.Remove( pEntry );
 204         delete pEntry;
 205         pEntry = (ScRange*)aRemoveList.Next();
 206     }
 207 }
 208
 209
 210 //----------------------------------------------------------------------------
 211
 212 void ScDbNameDlg::Init()
 213 {
 214     aBtnHeader.Check( TRUE );           // Default: mit Spaltenkoepfen
 215
 216     aBtnMore.AddWindow( &aFlOptions );
 217     aBtnMore.AddWindow( &aBtnHeader );
 218     aBtnMore.AddWindow( &aBtnDoSize );
 219     aBtnMore.AddWindow( &aBtnKeepFmt );
 220     aBtnMore.AddWindow( &aBtnStripData );
 221     aBtnMore.AddWindow( &aFTSource );
 222     aBtnMore.AddWindow( &aFTOperations );
 223
 224     String      theAreaStr;
 225     SCCOL       nStartCol       = 0;
 226     SCROW       nStartRow       = 0;
 227     SCTAB       nStartTab       = 0;
 228     SCCOL       nEndCol         = 0;
 229     SCROW       nEndRow         = 0;
 230     SCTAB       nEndTab         = 0;
 231
 232     aBtnOk.SetClickHdl          ( LINK( this, ScDbNameDlg, OkBtnHdl ) );
 233     aBtnCancel.SetClickHdl      ( LINK( this, ScDbNameDlg, CancelBtnHdl ) );
 234     aBtnAdd.SetClickHdl         ( LINK( this, ScDbNameDlg, AddBtnHdl ) );
 235     aBtnRemove.SetClickHdl      ( LINK( this, ScDbNameDlg, RemoveBtnHdl ) );
 236     aEdName.SetModifyHdl        ( LINK( this, ScDbNameDlg, NameModifyHdl ) );
 237     aEdAssign.SetModifyHdl      ( LINK( this, ScDbNameDlg, AssModifyHdl ) );
 238     UpdateNames();
 239
 240     if ( pViewData && pDoc )
 241     {
 242         ScDBCollection* pDBColl = pDoc->GetDBCollection();
 243         ScDBData*               pDBData = NULL;
 244
 245         pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab,
 246                                   nEndCol,       nEndRow,  nEndTab );
 247
 248         theCurArea = ScRange( ScAddress( nStartCol, nStartRow, nStartTab ),
 249                               ScAddress( nEndCol,   nEndRow,   nEndTab ) );
 250
 251         theCurArea.Format( theAreaStr, ABS_DREF3D, pDoc, aAddrDetails );
 252
 253         if ( pDBColl )
 254         {
 255             // Feststellen, ob definierter DB-Bereich markiert wurde:
 256             pDBData = pDBColl->GetDBAtCursor( nStartCol, nStartRow, nStartTab, TRUE );
 257             if ( pDBData )
 258             {
 259                 String          theDbName;
 260                 ScAddress&      rStart = theCurArea.aStart;
 261                 ScAddress&      rEnd   = theCurArea.aEnd;
 262                 SCCOL nCol1;
 263                 SCCOL  nCol2;
 264                 SCROW  nRow1;
 265                 SCROW  nRow2;
 266                 SCTAB  nTab;
 267
 268                 pDBData->GetArea( nTab, nCol1, nRow1, nCol2, nRow2 );
 269
 270                 if (   (rStart.Tab() == nTab)
 271                     && (rStart.Col() == nCol1) && (rStart.Row() == nRow1)
 272                     && (rEnd.Col()   == nCol2) && (rEnd.Row()   == nRow2 ) )
 273                 {
 274                     pDBData->GetName( theDbName );
 275                     if ( theDbName != aStrNoName )
 276                         aEdName.SetText( theDbName );
 277                     else
 278                         aEdName.SetText( EMPTY_STRING );
 279                     aBtnHeader.Check( pDBData->HasHeader() );
 280                     aBtnDoSize.Check( pDBData->IsDoSize() );
 281                     aBtnKeepFmt.Check( pDBData->IsKeepFmt() );
 282                     aBtnStripData.Check( pDBData->IsStripData() );
 283                     SetInfoStrings( pDBData );
 284                 }
 285             }
 286         }
 287     }
 288
 289     aEdAssign.SetText( theAreaStr );
 290     aEdName.GrabFocus();
 291     bSaved=TRUE;
 292     pSaveObj->Save();
 293     NameModifyHdl( 0 );
 294 }
 295
 296
 297 void ScDbNameDlg::SetInfoStrings( const ScDBData* pDBData )
 298 {
 299     String aSource = aStrSource;
 300     if (pDBData)
 301     {
 302         aSource += ' ';
 303         aSource += pDBData->GetSourceString();
 304     }
 305     aFTSource.SetText( aSource );
 306
 307     String aOper = aStrOperations;
 308     if (pDBData)
 309     {
 310         aOper += ' ';
 311         aOper += pDBData->GetOperations();
 312     }
 313     aFTOperations.SetText( aOper );
 314 }
 315
 316 //----------------------------------------------------------------------------
 317 // Uebergabe eines mit der Maus selektierten Tabellenbereiches, der dann als
 318 //  neue Selektion im Referenz-Fenster angezeigt wird.
 319
 320 void ScDbNameDlg::SetReference( const ScRange& rRef, ScDocument* pDocP )
 321 {
 322     if ( aEdAssign.IsEnabled() )
 323     {
 324         if ( rRef.aStart != rRef.aEnd )
 325             RefInputStart( &aEdAssign );
 326
 327         theCurArea = rRef;
 328
 329         String aRefStr;
 330         theCurArea.Format( aRefStr, ABS_DREF3D, pDocP, aAddrDetails );
 331         aEdAssign.SetRefString( aRefStr );
 332         aBtnHeader.Enable();
 333         aBtnDoSize.Enable();
 334         aBtnKeepFmt.Enable();
 335         aBtnStripData.Enable();
 336         aFTSource.Enable();
 337         aFTOperations.Enable();
 338         aBtnAdd.Enable();
 339         bSaved=TRUE;
 340         pSaveObj->Save();
 341     }
 342 }
 343
 344
 345 //----------------------------------------------------------------------------
 346
 347 BOOL __EXPORT ScDbNameDlg::Close()
 348 {
 349     return DoClose( ScDbNameDlgWrapper::GetChildWindowId() );
 350 }
 351
 352 //------------------------------------------------------------------------
 353
 354 void ScDbNameDlg::SetActive()
 355 {
 356     aEdAssign.GrabFocus();
 357
 358     //  kein NameModifyHdl, weil sonst Bereiche nicht geaendert werden koennen
 359     //  (nach dem Aufziehen der Referenz wuerde der alte Inhalt wieder angezeigt)
 360     //  (der ausgewaehlte DB-Name hat sich auch nicht veraendert)
 361
 362     RefInputDone();
 363 }
 364
 365 //------------------------------------------------------------------------
 366
 367 void ScDbNameDlg::UpdateNames()
 368 {
 369     USHORT      nNameCount = aLocalDbCol.GetCount();
 370
 371     aEdName.SetUpdateMode( FALSE );
 372     //-----------------------------------------------------------
 373     aEdName.Clear();
 374     aEdAssign.SetText( EMPTY_STRING );
 375
 376     if ( nNameCount > 0 )
 377     {
 378         ScDBData*       pDbData = NULL;
 379         String          aString;
 380
 381         for ( USHORT i=0; i<nNameCount; i++ )
 382         {
 383             pDbData = (ScDBData*)(aLocalDbCol.At( i ));
 384             if ( pDbData )
 385             {
 386                 pDbData->GetName( aString );
 387                 if ( aString != aStrNoName )
 388                     aEdName.InsertEntry( aString );
 389             }
 390         }
 391     }
 392     else
 393     {
 394         aBtnAdd.SetText( aStrAdd );
 395         aBtnAdd.Disable();
 396         aBtnRemove.Disable();
 397     }
 398     //-----------------------------------------------------------
 399     aEdName.SetUpdateMode( TRUE );
 400     aEdName.Invalidate();
 401 }
 402
 403 //------------------------------------------------------------------------
 404
 405 void ScDbNameDlg::UpdateDBData( const String& rStrName )
 406 {
 407     String              theArea;
 408     USHORT              nAt;
 409     ScDBData*   pData;
 410
 411     aLocalDbCol.SearchName( rStrName, nAt );
 412     pData = (ScDBData*)(aLocalDbCol.At( nAt ));
 413
 414     if ( pData )
 415     {
 416         SCCOL nColStart = 0;
 417         SCROW nRowStart = 0;
 418         SCCOL nColEnd    = 0;
 419         SCROW nRowEnd    = 0;
 420         SCTAB nTab               = 0;
 421
 422         pData->GetArea( nTab, nColStart, nRowStart, nColEnd, nRowEnd );
 423         theCurArea = ScRange( ScAddress( nColStart, nRowStart, nTab ),
 424                               ScAddress( nColEnd,       nRowEnd,   nTab ) );
 425         theCurArea.Format( theArea, ABS_DREF3D, pDoc, aAddrDetails );
 426         aEdAssign.SetText( theArea );
 427         aBtnAdd.SetText( aStrModify );
 428         aBtnHeader.Check( pData->HasHeader() );
 429         aBtnDoSize.Check( pData->IsDoSize() );
 430         aBtnKeepFmt.Check( pData->IsKeepFmt() );
 431         aBtnStripData.Check( pData->IsStripData() );
 432         SetInfoStrings( pData );
 433     }
 434
 435     aBtnAdd.SetText( aStrModify );
 436     aBtnAdd.Enable();
 437     aBtnRemove.Enable();
 438     aBtnHeader.Enable();
 439     aBtnDoSize.Enable();
 440     aBtnKeepFmt.Enable();
 441     aBtnStripData.Enable();
 442     aFTSource.Enable();
 443     aFTOperations.Enable();
 444 }
 445
 446 //------------------------------------------------------------------------
 447
 448
 449 BOOL ScDbNameDlg::IsRefInputMode() const
 450 {
 451     return bRefInputMode;
 452 }
 453
 454 //------------------------------------------------------------------------
 455 // Handler:
 456 // ========
 457
 458 IMPL_LINK( ScDbNameDlg, OkBtnHdl, void *, EMPTYARG )
 459 {
 460     AddBtnHdl( 0 );
 461
 462     // Der View die Aenderungen und die Remove-Liste uebergeben:
 463     // beide werden nur als Referenz uebergeben, so dass an dieser
 464     // Stelle keine Speicherleichen entstehen koennen:
 465     if ( pViewData )
 466         pViewData->GetView()->
 467             NotifyCloseDbNameDlg( aLocalDbCol, aRemoveList );
 468
 469     Close();
 470     return 0;
 471 }
 472
 473 //------------------------------------------------------------------------
 474
 475 IMPL_LINK_INLINE_START( ScDbNameDlg, CancelBtnHdl, void *, EMPTYARG )
 476 {
 477     Close();
 478     return 0;
 479 }
 480 IMPL_LINK_INLINE_END( ScDbNameDlg, CancelBtnHdl, void *, EMPTYARG )
 481
 482 //------------------------------------------------------------------------
 483
 484 IMPL_LINK( ScDbNameDlg, AddBtnHdl, void *, EMPTYARG )
 485 {
 486     String      aNewName = aEdName.GetText();
 487     String      aNewArea = aEdAssign.GetText();
 488
 489     aNewName.EraseLeadingChars( ' ' );
 490     aNewName.EraseTrailingChars( ' ' );
 491
 492     if ( aNewName.Len() > 0 && aNewArea.Len() > 0 )
 493     {
 494         if ( ScRangeData::IsNameValid( aNewName, pDoc ) )
 495         {
 496             //  weil jetzt editiert werden kann, muss erst geparst werden
 497             ScRange aTmpRange;
 498             String aText = aEdAssign.GetText();
 499             if ( aTmpRange.ParseAny( aText, pDoc, aAddrDetails ) & SCA_VALID )
 500             {
 501                 theCurArea = aTmpRange;
 502                 ScAddress aStart = theCurArea.aStart;
 503                 ScAddress aEnd   = theCurArea.aEnd;
 504
 505                 ScDBData* pOldEntry = NULL;
 506                 USHORT nFoundAt = 0;
 507                 if ( aLocalDbCol.SearchName( aNewName, nFoundAt ) )
 508                     pOldEntry = aLocalDbCol[nFoundAt];
 509                 if (pOldEntry)
 510                 {
 511                     //  Bereich veraendern
 512
 513                     pOldEntry->MoveTo( aStart.Tab(), aStart.Col(), aStart.Row(),
 514                                                         aEnd.Col(), aEnd.Row() );
 515                     pOldEntry->SetByRow( TRUE );
 516                     pOldEntry->SetHeader( aBtnHeader.IsChecked() );
 517                     pOldEntry->SetDoSize( aBtnDoSize.IsChecked() );
 518                     pOldEntry->SetKeepFmt( aBtnKeepFmt.IsChecked() );
 519                     pOldEntry->SetStripData( aBtnStripData.IsChecked() );
 520                 }
 521                 else
 522                 {
 523                     //  neuen Bereich einfuegen
 524
 525                     ScDBData* pNewEntry = new ScDBData( aNewName, aStart.Tab(),
 526                                                         aStart.Col(), aStart.Row(),
 527                                                         aEnd.Col(), aEnd.Row(),
 528                                                         TRUE, aBtnHeader.IsChecked() );
 529                     pNewEntry->SetDoSize( aBtnDoSize.IsChecked() );
 530                     pNewEntry->SetKeepFmt( aBtnKeepFmt.IsChecked() );
 531                     pNewEntry->SetStripData( aBtnStripData.IsChecked() );
 532
 533                     if ( !aLocalDbCol.Insert( pNewEntry ) )
 534                         delete pNewEntry;
 535                 }
 536
 537                 UpdateNames();
 538
 539                 aEdName.SetText( EMPTY_STRING );
 540                 aEdName.GrabFocus();
 541                 aBtnAdd.SetText( aStrAdd );
 542                 aBtnAdd.Disable();
 543                 aBtnRemove.Disable();
 544                 aEdAssign.SetText( EMPTY_STRING );
 545                 aBtnHeader.Check( TRUE );               // Default: mit Spaltenkoepfen
 546                 aBtnDoSize.Check( FALSE );
 547                 aBtnKeepFmt.Check( FALSE );
 548                 aBtnStripData.Check( FALSE );
 549                 SetInfoStrings( NULL );         // leer
 550                 theCurArea = ScRange();
 551                 bSaved=TRUE;
 552                 pSaveObj->Save();
 553                 NameModifyHdl( 0 );
 554             }
 555             else
 556             {
 557                 ERRORBOX( aStrInvalid );
 558                 aEdAssign.SetSelection( Selection( 0, SELECTION_MAX ) );
 559                 aEdAssign.GrabFocus();
 560             }
 561         }
 562         else
 563         {
 564             ERRORBOX( ScGlobal::GetRscString(STR_INVALIDNAME) );
 565             aEdName.SetSelection( Selection( 0, SELECTION_MAX ) );
 566             aEdName.GrabFocus();
 567         }
 568     }
 569     return 0;
 570 }
 571
 572 //------------------------------------------------------------------------
 573
 574 IMPL_LINK( ScDbNameDlg, RemoveBtnHdl, void *, EMPTYARG )
 575 {
 576     USHORT               nRemoveAt = 0;
 577     const String aStrEntry = aEdName.GetText();
 578
 579     if ( aLocalDbCol.SearchName( aStrEntry, nRemoveAt ) )
 580     {
 581         String aStrDelMsg = ScGlobal::GetRscString( STR_QUERY_DELENTRY );
 582         String aMsg               = aStrDelMsg.GetToken( 0, '#' );
 583
 584         aMsg += aStrEntry;
 585         aMsg += aStrDelMsg.GetToken( 1, '#' );
 586
 587         if ( RET_YES == QUERYBOX(aMsg) )
 588         {
 589             ScDBData* pEntry = (ScDBData*)aLocalDbCol.At(nRemoveAt);
 590
 591             if ( pEntry )
 592             {
 593                 SCTAB nTab;
 594                 SCCOL nColStart, nColEnd;
 595                 SCROW nRowStart, nRowEnd;
 596                 pEntry->GetArea( nTab, nColStart, nRowStart, nColEnd, nRowEnd );
 597                 aRemoveList.Insert(
 598                     new ScRange( ScAddress( nColStart, nRowStart, nTab ),
 599                                  ScAddress( nColEnd,   nRowEnd,   nTab ) ) );
 600             }
 601             aLocalDbCol.AtFree( nRemoveAt );
 602
 603             UpdateNames();
 604
 605             aEdName.SetText( EMPTY_STRING );
 606             aEdName.GrabFocus();
 607             aBtnAdd.SetText( aStrAdd );
 608             aBtnAdd.Disable();
 609             aBtnRemove.Disable();
 610             aEdAssign.SetText( EMPTY_STRING );
 611             theCurArea = ScRange();
 612             aBtnHeader.Check( TRUE );           // Default: mit Spaltenkoepfen
 613             aBtnDoSize.Check( FALSE );
 614             aBtnKeepFmt.Check( FALSE );
 615             aBtnStripData.Check( FALSE );
 616             SetInfoStrings( NULL );             // leer
 617             bSaved=FALSE;
 618             pSaveObj->Restore();
 619             NameModifyHdl( 0 );
 620         }
 621     }
 622     return 0;
 623 }
 624
 625 //------------------------------------------------------------------------
 626
 627 IMPL_LINK( ScDbNameDlg, NameModifyHdl, void *, EMPTYARG )
 628 {
 629     String      theName         = aEdName.GetText();
 630     BOOL        bNameFound  = (COMBOBOX_ENTRY_NOTFOUND
 631                            != aEdName.GetEntryPos( theName ));
 632
 633     if ( theName.Len() == 0 )
 634     {
 635         if ( aBtnAdd.GetText() != aStrAdd )
 636             aBtnAdd.SetText( aStrAdd );
 637         aBtnAdd         .Disable();
 638         aBtnRemove      .Disable();
 639         aFlAssign   .Disable();
 640         aBtnHeader      .Disable();
 641         aBtnDoSize      .Disable();
 642         aBtnKeepFmt     .Disable();
 643         aBtnStripData.Disable();
 644         aFTSource       .Disable();
 645         aFTOperations.Disable();
 646         aEdAssign       .Disable();
 647         aRbAssign       .Disable();
 648         //bSaved=FALSE;
 649         //pSaveObj->Restore();
 650         //@BugID 54702 Enablen/Disablen nur noch in Basisklasse
 651         //SFX_APPWINDOW->Disable(FALSE);                //! allgemeine Methode im ScAnyRefDlg
 652         bRefInputMode = FALSE;
 653     }
 654     else
 655     {
 656         if ( bNameFound )
 657         {
 658             if ( aBtnAdd.GetText() != aStrModify )
 659                 aBtnAdd.SetText( aStrModify );
 660
 661             if(!bSaved)
 662             {
 663                 bSaved=TRUE;
 664                 pSaveObj->Save();
 665             }
 666             UpdateDBData( theName );
 667         }
 668         else
 669         {
 670             if ( aBtnAdd.GetText() != aStrAdd )
 671                 aBtnAdd.SetText( aStrAdd );
 672
 673             bSaved=FALSE;
 674             pSaveObj->Restore();
 675
 676             if ( aEdAssign.GetText().Len() > 0 )
 677             {
 678                 aBtnAdd.Enable();
 679                 aBtnHeader.Enable();
 680                 aBtnDoSize.Enable();
 681                 aBtnKeepFmt.Enable();
 682                 aBtnStripData.Enable();
 683                 aFTSource.Enable();
 684                 aFTOperations.Enable();
 685             }
 686             else
 687             {
 688                 aBtnAdd.Disable();
 689                 aBtnHeader.Disable();
 690                 aBtnDoSize.Disable();
 691                 aBtnKeepFmt.Disable();
 692                 aBtnStripData.Disable();
 693                 aFTSource.Disable();
 694                 aFTOperations.Disable();
 695             }
 696             aBtnRemove.Disable();
 697         }
 698
 699         aFlAssign.Enable();
 700         aEdAssign.Enable();
 701         aRbAssign.Enable();
 702
 703         //@BugID 54702 Enablen/Disablen nur noch in Basisklasse
 704         //SFX_APPWINDOW->Enable();
 705         bRefInputMode = TRUE;
 706     }
 707     return 0;
 708 }
 709
 710 //------------------------------------------------------------------------
 711
 712 IMPL_LINK( ScDbNameDlg, AssModifyHdl, void *, EMPTYARG )
 713 {
 714     //  hier parsen fuer Save() etc.
 715
 716     ScRange aTmpRange;
 717     String aText = aEdAssign.GetText();
 718     if ( aTmpRange.ParseAny( aText, pDoc, aAddrDetails ) & SCA_VALID )
 719         theCurArea = aTmpRange;
 720
 721     return 0;
 722 }
 723
 724