xref: /aoo42x/main/sc/source/ui/dbgui/dbnamdlg.cxx (revision 1a986828)
1b3f79822SAndrew Rist /**************************************************************
2cdf0e10cSrcweir  *
3b3f79822SAndrew Rist  * Licensed to the Apache Software Foundation (ASF) under one
4b3f79822SAndrew Rist  * or more contributor license agreements.  See the NOTICE file
5b3f79822SAndrew Rist  * distributed with this work for additional information
6b3f79822SAndrew Rist  * regarding copyright ownership.  The ASF licenses this file
7b3f79822SAndrew Rist  * to you under the Apache License, Version 2.0 (the
8b3f79822SAndrew Rist  * "License"); you may not use this file except in compliance
9b3f79822SAndrew Rist  * with the License.  You may obtain a copy of the License at
10b3f79822SAndrew Rist  *
11b3f79822SAndrew Rist  *   http://www.apache.org/licenses/LICENSE-2.0
12b3f79822SAndrew Rist  *
13b3f79822SAndrew Rist  * Unless required by applicable law or agreed to in writing,
14b3f79822SAndrew Rist  * software distributed under the License is distributed on an
15b3f79822SAndrew Rist  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16b3f79822SAndrew Rist  * KIND, either express or implied.  See the License for the
17b3f79822SAndrew Rist  * specific language governing permissions and limitations
18b3f79822SAndrew Rist  * under the License.
19b3f79822SAndrew Rist  *
20b3f79822SAndrew Rist  *************************************************************/
21b3f79822SAndrew Rist 
22b3f79822SAndrew Rist 
23cdf0e10cSrcweir 
24cdf0e10cSrcweir // MARKER(update_precomp.py): autogen include statement, do not remove
25cdf0e10cSrcweir #include "precompiled_sc.hxx"
26cdf0e10cSrcweir 
27cdf0e10cSrcweir // System - Includes ---------------------------------------------------------
28cdf0e10cSrcweir 
29cdf0e10cSrcweir 
30cdf0e10cSrcweir 
31cdf0e10cSrcweir // INCLUDE -------------------------------------------------------------------
32cdf0e10cSrcweir 
33cdf0e10cSrcweir #include <vcl/msgbox.hxx>
34cdf0e10cSrcweir 
35cdf0e10cSrcweir #include "reffact.hxx"
36cdf0e10cSrcweir #include "document.hxx"
37cdf0e10cSrcweir #include "scresid.hxx"
38cdf0e10cSrcweir #include "globstr.hrc"
39cdf0e10cSrcweir #include "dbnamdlg.hrc"
40cdf0e10cSrcweir #include "rangenam.hxx"		// IsNameValid
41cdf0e10cSrcweir 
42cdf0e10cSrcweir #define _DBNAMDLG_CXX
43cdf0e10cSrcweir #include "dbnamdlg.hxx"
44cdf0e10cSrcweir #undef _DBNAMDLG_CXX
45cdf0e10cSrcweir 
46cdf0e10cSrcweir 
47cdf0e10cSrcweir //============================================================================
48cdf0e10cSrcweir 
49cdf0e10cSrcweir #define ABS_SREF		  SCA_VALID \
50cdf0e10cSrcweir 						| SCA_COL_ABSOLUTE | SCA_ROW_ABSOLUTE | SCA_TAB_ABSOLUTE
51cdf0e10cSrcweir #define ABS_DREF		  ABS_SREF \
52cdf0e10cSrcweir 						| SCA_COL2_ABSOLUTE | SCA_ROW2_ABSOLUTE | SCA_TAB2_ABSOLUTE
53cdf0e10cSrcweir #define ABS_SREF3D		ABS_SREF | SCA_TAB_3D
54cdf0e10cSrcweir #define ABS_DREF3D		ABS_DREF | SCA_TAB_3D
55cdf0e10cSrcweir 
56cdf0e10cSrcweir //----------------------------------------------------------------------------
57cdf0e10cSrcweir 
58cdf0e10cSrcweir class DBSaveData;
59cdf0e10cSrcweir 
60cdf0e10cSrcweir static DBSaveData* pSaveObj = NULL;
61cdf0e10cSrcweir 
62cdf0e10cSrcweir #define ERRORBOX(s) ErrorBox(this,WinBits(WB_OK|WB_DEF_OK),s).Execute()
63cdf0e10cSrcweir #define QUERYBOX(m) QueryBox(this,WinBits(WB_YES_NO|WB_DEF_YES),m).Execute()
64cdf0e10cSrcweir 
65cdf0e10cSrcweir //============================================================================
66cdf0e10cSrcweir //	class DBSaveData
67cdf0e10cSrcweir 
68cdf0e10cSrcweir class DBSaveData
69cdf0e10cSrcweir {
70cdf0e10cSrcweir public:
DBSaveData(Edit & rEd,CheckBox & rHdr,CheckBox & rSize,CheckBox & rFmt,CheckBox & rStrip,ScRange & rArea)71cdf0e10cSrcweir 	DBSaveData( Edit& rEd, CheckBox& rHdr, CheckBox& rSize, CheckBox& rFmt,
72cdf0e10cSrcweir 							CheckBox& rStrip, ScRange& rArea )
73cdf0e10cSrcweir         : rEdAssign(rEd),
74cdf0e10cSrcweir           rBtnHeader(rHdr), rBtnSize(rSize), rBtnFormat(rFmt), rBtnStrip(rStrip),
75cdf0e10cSrcweir           rCurArea(rArea),
76cdf0e10cSrcweir           bHeader(sal_False), bSize(sal_False), bFormat(sal_False), bDirty(sal_False) {}
77cdf0e10cSrcweir 	void Save();
78cdf0e10cSrcweir 	void Restore();
79cdf0e10cSrcweir 
80cdf0e10cSrcweir private:
81cdf0e10cSrcweir 	Edit&		rEdAssign;
82cdf0e10cSrcweir 	CheckBox&	rBtnHeader;
83cdf0e10cSrcweir 	CheckBox&	rBtnSize;
84cdf0e10cSrcweir 	CheckBox&	rBtnFormat;
85cdf0e10cSrcweir 	CheckBox&	rBtnStrip;
86cdf0e10cSrcweir 	ScRange&	rCurArea;
87cdf0e10cSrcweir 	String		aStr;
88cdf0e10cSrcweir 	ScRange		aArea;
89cdf0e10cSrcweir 	sal_Bool		bHeader:1;
90cdf0e10cSrcweir 	sal_Bool		bSize:1;
91cdf0e10cSrcweir 	sal_Bool		bFormat:1;
92cdf0e10cSrcweir 	sal_Bool		bStrip:1;
93cdf0e10cSrcweir 	sal_Bool		bDirty:1;
94cdf0e10cSrcweir };
95cdf0e10cSrcweir 
96cdf0e10cSrcweir 
97cdf0e10cSrcweir 
98cdf0e10cSrcweir //----------------------------------------------------------------------------
99cdf0e10cSrcweir 
Save()100cdf0e10cSrcweir void DBSaveData::Save()
101cdf0e10cSrcweir {
102cdf0e10cSrcweir 	aArea   = rCurArea;
103cdf0e10cSrcweir 	aStr    = rEdAssign.GetText();
104cdf0e10cSrcweir 	bHeader = rBtnHeader.IsChecked();
105cdf0e10cSrcweir 	bSize   = rBtnSize.IsChecked();
106cdf0e10cSrcweir 	bFormat = rBtnFormat.IsChecked();
107cdf0e10cSrcweir 	bStrip	= rBtnStrip.IsChecked();
108cdf0e10cSrcweir 	bDirty  = sal_True;
109cdf0e10cSrcweir }
110cdf0e10cSrcweir 
111cdf0e10cSrcweir 
112cdf0e10cSrcweir //----------------------------------------------------------------------------
113cdf0e10cSrcweir 
Restore()114cdf0e10cSrcweir void DBSaveData::Restore()
115cdf0e10cSrcweir {
116cdf0e10cSrcweir 	if ( bDirty )
117cdf0e10cSrcweir 	{
118cdf0e10cSrcweir 		rCurArea = aArea;
119cdf0e10cSrcweir 		rEdAssign.SetText( aStr );
120cdf0e10cSrcweir 		rBtnHeader.Check ( bHeader );
121cdf0e10cSrcweir 		rBtnSize.Check   ( bSize );
122cdf0e10cSrcweir 		rBtnFormat.Check ( bFormat );
123cdf0e10cSrcweir 		rBtnStrip.Check  ( bStrip );
124cdf0e10cSrcweir 		bDirty = sal_False;
125cdf0e10cSrcweir 	}
126cdf0e10cSrcweir }
127cdf0e10cSrcweir 
128cdf0e10cSrcweir 
129cdf0e10cSrcweir //============================================================================
130cdf0e10cSrcweir //	class ScDbNameDlg
131cdf0e10cSrcweir 
132cdf0e10cSrcweir //----------------------------------------------------------------------------
133cdf0e10cSrcweir 
ScDbNameDlg(SfxBindings * pB,SfxChildWindow * pCW,Window * pParent,ScViewData * ptrViewData)134cdf0e10cSrcweir ScDbNameDlg::ScDbNameDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent,
135cdf0e10cSrcweir 						  ScViewData*	ptrViewData )
136cdf0e10cSrcweir 
137cdf0e10cSrcweir 	:	ScAnyRefDlg	( pB, pCW, pParent, RID_SCDLG_DBNAMES ),
138cdf0e10cSrcweir 		//
139cdf0e10cSrcweir         aFlName         ( this, ScResId( FL_NAME ) ),
140cdf0e10cSrcweir 		aEdName			( this, ScResId( ED_NAME ) ),
141cdf0e10cSrcweir 
142cdf0e10cSrcweir         aFlAssign       ( this, ScResId( FL_ASSIGN ) ),
143cdf0e10cSrcweir         aEdAssign       ( this, this, ScResId( ED_DBAREA ) ),
144cdf0e10cSrcweir 		aRbAssign		( this, ScResId( RB_DBAREA ), &aEdAssign, this ),
145cdf0e10cSrcweir 
146cdf0e10cSrcweir         aFlOptions      ( this, ScResId( FL_OPTIONS ) ),
147cdf0e10cSrcweir 		aBtnHeader		( this, ScResId( BTN_HEADER ) ),
148cdf0e10cSrcweir 		aBtnDoSize		( this, ScResId( BTN_SIZE ) ),
149cdf0e10cSrcweir 		aBtnKeepFmt		( this, ScResId( BTN_FORMAT ) ),
150cdf0e10cSrcweir 		aBtnStripData	( this, ScResId( BTN_STRIPDATA ) ),
151cdf0e10cSrcweir 		aFTSource		( this, ScResId( FT_SOURCE ) ),
152cdf0e10cSrcweir 		aFTOperations	( this, ScResId( FT_OPERATIONS ) ),
153cdf0e10cSrcweir 
154cdf0e10cSrcweir 		aBtnOk			( this, ScResId( BTN_OK ) ),
155cdf0e10cSrcweir 		aBtnCancel		( this, ScResId( BTN_CANCEL ) ),
156cdf0e10cSrcweir 		aBtnHelp		( this, ScResId( BTN_HELP ) ),
157cdf0e10cSrcweir 		aBtnAdd			( this, ScResId( BTN_ADD ) ),
158cdf0e10cSrcweir 		aBtnRemove		( this, ScResId( BTN_REMOVE ) ),
159cdf0e10cSrcweir 		aBtnMore		( this, ScResId( BTN_MORE ) ),
160cdf0e10cSrcweir 
161cdf0e10cSrcweir 		aStrAdd			( ScResId( STR_ADD ) ),
162cdf0e10cSrcweir 		aStrModify		( ScResId( STR_MODIFY ) ),
163cdf0e10cSrcweir 		aStrInvalid		( ScResId( STR_DB_INVALID ) ),
164cdf0e10cSrcweir 		//
165cdf0e10cSrcweir 		pViewData		( ptrViewData ),
166cdf0e10cSrcweir 		pDoc			( ptrViewData->GetDocument() ),
167cdf0e10cSrcweir 		bRefInputMode	( sal_False ),
168cdf0e10cSrcweir         aAddrDetails    ( pDoc->GetAddressConvention(), 0, 0 ),
169cdf0e10cSrcweir 		aLocalDbCol		( *(pDoc->GetDBCollection()) )
170cdf0e10cSrcweir {
171cdf0e10cSrcweir 	// WB_NOLABEL can't be set in resource...
172cdf0e10cSrcweir 	aFTSource.SetStyle( aFTSource.GetStyle() | WB_NOLABEL );
173cdf0e10cSrcweir 	aFTOperations.SetStyle( aFTOperations.GetStyle() | WB_NOLABEL );
174cdf0e10cSrcweir 
175cdf0e10cSrcweir 	//	damit die Strings in der Resource bei den FixedTexten bleiben koennen:
176cdf0e10cSrcweir 	aStrSource		= aFTSource.GetText();
177cdf0e10cSrcweir 	aStrOperations	= aFTOperations.GetText();
178cdf0e10cSrcweir 
179cdf0e10cSrcweir 	pSaveObj = new DBSaveData( aEdAssign, aBtnHeader,
180cdf0e10cSrcweir 						aBtnDoSize, aBtnKeepFmt, aBtnStripData, theCurArea );
181cdf0e10cSrcweir 	Init();
182cdf0e10cSrcweir 	FreeResource();
1830deba7fbSSteve Yin 	SynFocusTimer.SetTimeout(150);
1840deba7fbSSteve Yin 	SynFocusTimer.SetTimeoutHdl(LINK( this, ScDbNameDlg, FocusToComoboxHdl));
1850deba7fbSSteve Yin 	SynFocusTimer.Start();
186cdf0e10cSrcweir 	aRbAssign.SetAccessibleRelationMemberOf(&aFlAssign);
187cdf0e10cSrcweir }
188cdf0e10cSrcweir 
189cdf0e10cSrcweir 
190cdf0e10cSrcweir //----------------------------------------------------------------------------
191cdf0e10cSrcweir 
~ScDbNameDlg()192cdf0e10cSrcweir __EXPORT ScDbNameDlg::~ScDbNameDlg()
193cdf0e10cSrcweir {
194cdf0e10cSrcweir 	DELETEZ( pSaveObj );
195cdf0e10cSrcweir 
196cdf0e10cSrcweir 	ScRange* pEntry = (ScRange*)aRemoveList.First();
197cdf0e10cSrcweir 	while ( pEntry )
198cdf0e10cSrcweir 	{
199cdf0e10cSrcweir         aRemoveList.Remove( pEntry );
200cdf0e10cSrcweir         delete pEntry;
201cdf0e10cSrcweir 		pEntry = (ScRange*)aRemoveList.Next();
202cdf0e10cSrcweir 	}
203cdf0e10cSrcweir }
204cdf0e10cSrcweir 
205cdf0e10cSrcweir 
206cdf0e10cSrcweir //----------------------------------------------------------------------------
207cdf0e10cSrcweir 
Init()208cdf0e10cSrcweir void ScDbNameDlg::Init()
209cdf0e10cSrcweir {
21022407013SOliver-Rainer Wittmann     aBtnHeader.Check( sal_True );		// Default: mit Spaltenkoepfen
211*1a986828STsutomu Uchino     aBtnDoSize.Check( sal_True );
212*1a986828STsutomu Uchino     aBtnKeepFmt.Check( sal_True );
213cdf0e10cSrcweir 
214cdf0e10cSrcweir     aBtnMore.AddWindow( &aFlOptions );
21522407013SOliver-Rainer Wittmann     aBtnMore.AddWindow( &aBtnHeader );
21622407013SOliver-Rainer Wittmann     aBtnMore.AddWindow( &aBtnDoSize );
21722407013SOliver-Rainer Wittmann     aBtnMore.AddWindow( &aBtnKeepFmt );
21822407013SOliver-Rainer Wittmann     aBtnMore.AddWindow( &aBtnStripData );
21922407013SOliver-Rainer Wittmann     aBtnMore.AddWindow( &aFTSource );
22022407013SOliver-Rainer Wittmann     aBtnMore.AddWindow( &aFTOperations );
22122407013SOliver-Rainer Wittmann 
22222407013SOliver-Rainer Wittmann     String	theAreaStr;
22322407013SOliver-Rainer Wittmann     SCCOL	nStartCol 	= 0;
22422407013SOliver-Rainer Wittmann     SCROW	nStartRow 	= 0;
22522407013SOliver-Rainer Wittmann     SCTAB	nStartTab 	= 0;
22622407013SOliver-Rainer Wittmann     SCCOL	nEndCol 	= 0;
22722407013SOliver-Rainer Wittmann     SCROW	nEndRow		= 0;
22822407013SOliver-Rainer Wittmann     SCTAB	nEndTab 	= 0;
22922407013SOliver-Rainer Wittmann 
23022407013SOliver-Rainer Wittmann     aBtnOk.SetClickHdl		( LINK( this, ScDbNameDlg, OkBtnHdl ) );
23122407013SOliver-Rainer Wittmann     aBtnCancel.SetClickHdl	( LINK( this, ScDbNameDlg, CancelBtnHdl ) );
23222407013SOliver-Rainer Wittmann     aBtnAdd.SetClickHdl		( LINK( this, ScDbNameDlg, AddBtnHdl ) );
23322407013SOliver-Rainer Wittmann     aBtnRemove.SetClickHdl	( LINK( this, ScDbNameDlg, RemoveBtnHdl ) );
23422407013SOliver-Rainer Wittmann     aEdName.SetModifyHdl	( LINK( this, ScDbNameDlg, NameModifyHdl ) );
23522407013SOliver-Rainer Wittmann     aEdAssign.SetModifyHdl	( LINK( this, ScDbNameDlg, AssModifyHdl ) );
23622407013SOliver-Rainer Wittmann     UpdateNames();
23722407013SOliver-Rainer Wittmann 
23822407013SOliver-Rainer Wittmann     if ( pViewData && pDoc )
23922407013SOliver-Rainer Wittmann     {
24022407013SOliver-Rainer Wittmann         ScDBCollection*	pDBColl	= pDoc->GetDBCollection();
24122407013SOliver-Rainer Wittmann         ScDBData*		pDBData = NULL;
24222407013SOliver-Rainer Wittmann 
24322407013SOliver-Rainer Wittmann         pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab,
24422407013SOliver-Rainer Wittmann             nEndCol,	 nEndRow,  nEndTab );
24522407013SOliver-Rainer Wittmann 
24622407013SOliver-Rainer Wittmann         theCurArea = ScRange( ScAddress( nStartCol, nStartRow, nStartTab ),
24722407013SOliver-Rainer Wittmann             ScAddress( nEndCol,   nEndRow,   nEndTab ) );
24822407013SOliver-Rainer Wittmann 
24922407013SOliver-Rainer Wittmann         theCurArea.Format( theAreaStr, ABS_DREF3D, pDoc, aAddrDetails );
25022407013SOliver-Rainer Wittmann 
25122407013SOliver-Rainer Wittmann         if ( pDBColl )
25222407013SOliver-Rainer Wittmann         {
25322407013SOliver-Rainer Wittmann             // Feststellen, ob definierter DB-Bereich markiert wurde:
25422407013SOliver-Rainer Wittmann             pDBData = pDBColl->GetDBAtCursor( nStartCol, nStartRow, nStartTab, sal_True );
25522407013SOliver-Rainer Wittmann             if ( pDBData )
25622407013SOliver-Rainer Wittmann             {
25722407013SOliver-Rainer Wittmann                 String		theDbName;
25822407013SOliver-Rainer Wittmann                 ScAddress&	rStart = theCurArea.aStart;
25922407013SOliver-Rainer Wittmann                 ScAddress&	rEnd   = theCurArea.aEnd;
260cdf0e10cSrcweir                 SCCOL nCol1;
261cdf0e10cSrcweir                 SCCOL  nCol2;
262cdf0e10cSrcweir                 SCROW  nRow1;
263cdf0e10cSrcweir                 SCROW  nRow2;
264cdf0e10cSrcweir                 SCTAB  nTab;
265cdf0e10cSrcweir 
26622407013SOliver-Rainer Wittmann                 pDBData->GetArea( nTab, nCol1, nRow1, nCol2, nRow2 );
26722407013SOliver-Rainer Wittmann 
26822407013SOliver-Rainer Wittmann                 if (   (rStart.Tab() == nTab)
26922407013SOliver-Rainer Wittmann                     && (rStart.Col() == nCol1) && (rStart.Row() == nRow1)
27022407013SOliver-Rainer Wittmann                     && (rEnd.Col()   == nCol2) && (rEnd.Row()   == nRow2 ) )
27122407013SOliver-Rainer Wittmann                 {
27222407013SOliver-Rainer Wittmann                     pDBData->GetName( theDbName );
27322407013SOliver-Rainer Wittmann                     if ( !pDBData->IsInternalUnnamed()
27422407013SOliver-Rainer Wittmann                          && !pDBData->IsInternalForAutoFilter() )
27522407013SOliver-Rainer Wittmann                     {
27622407013SOliver-Rainer Wittmann                         aEdName.SetText( theDbName );
27722407013SOliver-Rainer Wittmann                     }
27822407013SOliver-Rainer Wittmann                     else
27922407013SOliver-Rainer Wittmann                     {
28022407013SOliver-Rainer Wittmann                         aEdName.SetText( EMPTY_STRING );
28122407013SOliver-Rainer Wittmann                     }
28222407013SOliver-Rainer Wittmann                     aBtnHeader.Check( pDBData->HasHeader() );
28322407013SOliver-Rainer Wittmann                     aBtnDoSize.Check( pDBData->IsDoSize() );
28422407013SOliver-Rainer Wittmann                     aBtnKeepFmt.Check( pDBData->IsKeepFmt() );
28522407013SOliver-Rainer Wittmann                     aBtnStripData.Check( pDBData->IsStripData() );
28622407013SOliver-Rainer Wittmann                     SetInfoStrings( pDBData );
28722407013SOliver-Rainer Wittmann                 }
28822407013SOliver-Rainer Wittmann             }
28922407013SOliver-Rainer Wittmann         }
29022407013SOliver-Rainer Wittmann     }
29122407013SOliver-Rainer Wittmann 
29222407013SOliver-Rainer Wittmann     aEdAssign.SetText( theAreaStr );
29322407013SOliver-Rainer Wittmann     aEdName.GrabFocus();
29422407013SOliver-Rainer Wittmann     bSaved=sal_True;
29522407013SOliver-Rainer Wittmann     pSaveObj->Save();
29622407013SOliver-Rainer Wittmann     NameModifyHdl( 0 );
297cdf0e10cSrcweir }
298cdf0e10cSrcweir 
299cdf0e10cSrcweir 
SetInfoStrings(const ScDBData * pDBData)300cdf0e10cSrcweir void ScDbNameDlg::SetInfoStrings( const ScDBData* pDBData )
301cdf0e10cSrcweir {
302cdf0e10cSrcweir 	String aSource = aStrSource;
303cdf0e10cSrcweir 	if (pDBData)
304cdf0e10cSrcweir 	{
305cdf0e10cSrcweir 		aSource += ' ';
306cdf0e10cSrcweir 		aSource += pDBData->GetSourceString();
307cdf0e10cSrcweir 	}
308cdf0e10cSrcweir 	aFTSource.SetText( aSource );
309cdf0e10cSrcweir 
310cdf0e10cSrcweir 	String aOper = aStrOperations;
311cdf0e10cSrcweir 	if (pDBData)
312cdf0e10cSrcweir 	{
313cdf0e10cSrcweir 		aOper += ' ';
314cdf0e10cSrcweir 		aOper += pDBData->GetOperations();
315cdf0e10cSrcweir 	}
316cdf0e10cSrcweir 	aFTOperations.SetText( aOper );
317cdf0e10cSrcweir }
318cdf0e10cSrcweir 
319cdf0e10cSrcweir //----------------------------------------------------------------------------
320cdf0e10cSrcweir // Uebergabe eines mit der Maus selektierten Tabellenbereiches, der dann als
321cdf0e10cSrcweir //  neue Selektion im Referenz-Fenster angezeigt wird.
322cdf0e10cSrcweir 
SetReference(const ScRange & rRef,ScDocument * pDocP)323cdf0e10cSrcweir void ScDbNameDlg::SetReference( const ScRange& rRef, ScDocument* pDocP )
324cdf0e10cSrcweir {
325cdf0e10cSrcweir 	if ( aEdAssign.IsEnabled() )
326cdf0e10cSrcweir 	{
327cdf0e10cSrcweir 		if ( rRef.aStart != rRef.aEnd )
328cdf0e10cSrcweir 			RefInputStart( &aEdAssign );
329cdf0e10cSrcweir 
330cdf0e10cSrcweir 		theCurArea = rRef;
331cdf0e10cSrcweir 
332cdf0e10cSrcweir 		String aRefStr;
333cdf0e10cSrcweir         theCurArea.Format( aRefStr, ABS_DREF3D, pDocP, aAddrDetails );
334cdf0e10cSrcweir 		aEdAssign.SetRefString( aRefStr );
335cdf0e10cSrcweir 		aBtnHeader.Enable();
336cdf0e10cSrcweir 		aBtnDoSize.Enable();
337cdf0e10cSrcweir 		aBtnKeepFmt.Enable();
338cdf0e10cSrcweir 		aBtnStripData.Enable();
339cdf0e10cSrcweir 		aFTSource.Enable();
340cdf0e10cSrcweir 		aFTOperations.Enable();
341cdf0e10cSrcweir 		aBtnAdd.Enable();
342cdf0e10cSrcweir 		bSaved=sal_True;
343cdf0e10cSrcweir 		pSaveObj->Save();
344cdf0e10cSrcweir 	}
345cdf0e10cSrcweir }
346cdf0e10cSrcweir 
347cdf0e10cSrcweir 
348cdf0e10cSrcweir //----------------------------------------------------------------------------
349cdf0e10cSrcweir 
Close()350cdf0e10cSrcweir sal_Bool __EXPORT ScDbNameDlg::Close()
351cdf0e10cSrcweir {
352cdf0e10cSrcweir 	return DoClose( ScDbNameDlgWrapper::GetChildWindowId() );
353cdf0e10cSrcweir }
354cdf0e10cSrcweir 
355cdf0e10cSrcweir //------------------------------------------------------------------------
356cdf0e10cSrcweir 
SetActive()357cdf0e10cSrcweir void ScDbNameDlg::SetActive()
358cdf0e10cSrcweir {
359cdf0e10cSrcweir 	aEdAssign.GrabFocus();
360cdf0e10cSrcweir 
361cdf0e10cSrcweir 	//	kein NameModifyHdl, weil sonst Bereiche nicht geaendert werden koennen
362cdf0e10cSrcweir 	//	(nach dem Aufziehen der Referenz wuerde der alte Inhalt wieder angezeigt)
363cdf0e10cSrcweir 	//	(der ausgewaehlte DB-Name hat sich auch nicht veraendert)
364cdf0e10cSrcweir 
365cdf0e10cSrcweir 	RefInputDone();
366cdf0e10cSrcweir }
367cdf0e10cSrcweir 
368cdf0e10cSrcweir //------------------------------------------------------------------------
369cdf0e10cSrcweir 
UpdateNames()370cdf0e10cSrcweir void ScDbNameDlg::UpdateNames()
371cdf0e10cSrcweir {
37222407013SOliver-Rainer Wittmann     sal_uInt16	nNameCount = aLocalDbCol.GetCount();
37322407013SOliver-Rainer Wittmann 
37422407013SOliver-Rainer Wittmann     aEdName.SetUpdateMode( sal_False );
37522407013SOliver-Rainer Wittmann     //-----------------------------------------------------------
37622407013SOliver-Rainer Wittmann     aEdName.Clear();
37722407013SOliver-Rainer Wittmann     aEdAssign.SetText( EMPTY_STRING );
37822407013SOliver-Rainer Wittmann 
37922407013SOliver-Rainer Wittmann     if ( nNameCount > 0 )
38022407013SOliver-Rainer Wittmann     {
38122407013SOliver-Rainer Wittmann         ScDBData*	pDbData = NULL;
38222407013SOliver-Rainer Wittmann         String		aString;
38322407013SOliver-Rainer Wittmann 
38422407013SOliver-Rainer Wittmann         for ( sal_uInt16 i=0; i<nNameCount; i++ )
38522407013SOliver-Rainer Wittmann         {
38622407013SOliver-Rainer Wittmann             pDbData = (ScDBData*)(aLocalDbCol.At( i ));
38722407013SOliver-Rainer Wittmann             if ( pDbData )
38822407013SOliver-Rainer Wittmann             {
38922407013SOliver-Rainer Wittmann                 pDbData->GetName( aString );
39022407013SOliver-Rainer Wittmann                 if ( !pDbData->IsInternalUnnamed()
39122407013SOliver-Rainer Wittmann                      && !pDbData->IsInternalForAutoFilter() )
39222407013SOliver-Rainer Wittmann                     aEdName.InsertEntry( aString );
39322407013SOliver-Rainer Wittmann             }
39422407013SOliver-Rainer Wittmann         }
39522407013SOliver-Rainer Wittmann     }
39622407013SOliver-Rainer Wittmann     else
39722407013SOliver-Rainer Wittmann     {
39822407013SOliver-Rainer Wittmann         aBtnAdd.SetText( aStrAdd );
39922407013SOliver-Rainer Wittmann         aBtnAdd.Disable();
40022407013SOliver-Rainer Wittmann         aBtnRemove.Disable();
40122407013SOliver-Rainer Wittmann     }
40222407013SOliver-Rainer Wittmann     //-----------------------------------------------------------
40322407013SOliver-Rainer Wittmann     aEdName.SetUpdateMode( sal_True );
40422407013SOliver-Rainer Wittmann     aEdName.Invalidate();
405cdf0e10cSrcweir }
406cdf0e10cSrcweir 
407cdf0e10cSrcweir //------------------------------------------------------------------------
408cdf0e10cSrcweir 
UpdateDBData(const String & rStrName)409cdf0e10cSrcweir void ScDbNameDlg::UpdateDBData( const String& rStrName )
410cdf0e10cSrcweir {
411cdf0e10cSrcweir 	String		theArea;
412cdf0e10cSrcweir 	sal_uInt16 		nAt;
413cdf0e10cSrcweir 	ScDBData*	pData;
414cdf0e10cSrcweir 
415cdf0e10cSrcweir 	aLocalDbCol.SearchName( rStrName, nAt );
416cdf0e10cSrcweir 	pData = (ScDBData*)(aLocalDbCol.At( nAt ));
417cdf0e10cSrcweir 
418cdf0e10cSrcweir 	if ( pData )
419cdf0e10cSrcweir 	{
420cdf0e10cSrcweir 		SCCOL nColStart = 0;
421cdf0e10cSrcweir 		SCROW nRowStart = 0;
422cdf0e10cSrcweir 		SCCOL nColEnd	 = 0;
423cdf0e10cSrcweir 		SCROW nRowEnd	 = 0;
424cdf0e10cSrcweir 		SCTAB nTab		 = 0;
425cdf0e10cSrcweir 
426cdf0e10cSrcweir 		pData->GetArea( nTab, nColStart, nRowStart, nColEnd, nRowEnd );
427cdf0e10cSrcweir 		theCurArea = ScRange( ScAddress( nColStart, nRowStart, nTab ),
428cdf0e10cSrcweir 							  ScAddress( nColEnd,	nRowEnd,   nTab ) );
429cdf0e10cSrcweir 		theCurArea.Format( theArea, ABS_DREF3D, pDoc, aAddrDetails );
430cdf0e10cSrcweir 		aEdAssign.SetText( theArea );
431cdf0e10cSrcweir 		aBtnAdd.SetText( aStrModify );
432cdf0e10cSrcweir 		aBtnHeader.Check( pData->HasHeader() );
433cdf0e10cSrcweir 		aBtnDoSize.Check( pData->IsDoSize() );
434cdf0e10cSrcweir 		aBtnKeepFmt.Check( pData->IsKeepFmt() );
435cdf0e10cSrcweir 		aBtnStripData.Check( pData->IsStripData() );
436cdf0e10cSrcweir 		SetInfoStrings( pData );
437cdf0e10cSrcweir 	}
438cdf0e10cSrcweir 
439cdf0e10cSrcweir 	aBtnAdd.SetText( aStrModify );
440cdf0e10cSrcweir 	aBtnAdd.Enable();
441cdf0e10cSrcweir 	aBtnRemove.Enable();
442cdf0e10cSrcweir 	aBtnHeader.Enable();
443cdf0e10cSrcweir 	aBtnDoSize.Enable();
444cdf0e10cSrcweir 	aBtnKeepFmt.Enable();
445cdf0e10cSrcweir 	aBtnStripData.Enable();
446cdf0e10cSrcweir 	aFTSource.Enable();
447cdf0e10cSrcweir 	aFTOperations.Enable();
448cdf0e10cSrcweir }
449cdf0e10cSrcweir 
450cdf0e10cSrcweir //------------------------------------------------------------------------
451cdf0e10cSrcweir 
452cdf0e10cSrcweir 
IsRefInputMode() const453cdf0e10cSrcweir sal_Bool ScDbNameDlg::IsRefInputMode() const
454cdf0e10cSrcweir {
455cdf0e10cSrcweir 	return bRefInputMode;
456cdf0e10cSrcweir }
457cdf0e10cSrcweir 
458cdf0e10cSrcweir //------------------------------------------------------------------------
459cdf0e10cSrcweir // Handler:
460cdf0e10cSrcweir // ========
461cdf0e10cSrcweir 
IMPL_LINK(ScDbNameDlg,OkBtnHdl,void *,EMPTYARG)462cdf0e10cSrcweir IMPL_LINK( ScDbNameDlg, OkBtnHdl, void *, EMPTYARG )
463cdf0e10cSrcweir {
464cdf0e10cSrcweir 	AddBtnHdl( 0 );
465cdf0e10cSrcweir 
466cdf0e10cSrcweir 	// Der View die Aenderungen und die Remove-Liste uebergeben:
467cdf0e10cSrcweir 	// beide werden nur als Referenz uebergeben, so dass an dieser
468cdf0e10cSrcweir 	// Stelle keine Speicherleichen entstehen koennen:
469cdf0e10cSrcweir 	if ( pViewData )
470cdf0e10cSrcweir 		pViewData->GetView()->
471cdf0e10cSrcweir 			NotifyCloseDbNameDlg( aLocalDbCol, aRemoveList );
472cdf0e10cSrcweir 
473cdf0e10cSrcweir 	Close();
474cdf0e10cSrcweir 	return 0;
475cdf0e10cSrcweir }
476cdf0e10cSrcweir 
477cdf0e10cSrcweir //------------------------------------------------------------------------
478cdf0e10cSrcweir 
IMPL_LINK_INLINE_START(ScDbNameDlg,CancelBtnHdl,void *,EMPTYARG)479cdf0e10cSrcweir IMPL_LINK_INLINE_START( ScDbNameDlg, CancelBtnHdl, void *, EMPTYARG )
480cdf0e10cSrcweir {
481cdf0e10cSrcweir 	Close();
482cdf0e10cSrcweir 	return 0;
483cdf0e10cSrcweir }
IMPL_LINK_INLINE_END(ScDbNameDlg,CancelBtnHdl,void *,EMPTYARG)484cdf0e10cSrcweir IMPL_LINK_INLINE_END( ScDbNameDlg, CancelBtnHdl, void *, EMPTYARG )
485cdf0e10cSrcweir 
486cdf0e10cSrcweir //------------------------------------------------------------------------
487cdf0e10cSrcweir 
488cdf0e10cSrcweir IMPL_LINK( ScDbNameDlg, AddBtnHdl, void *, EMPTYARG )
489cdf0e10cSrcweir {
490cdf0e10cSrcweir 	String	aNewName = aEdName.GetText();
491cdf0e10cSrcweir 	String	aNewArea = aEdAssign.GetText();
492cdf0e10cSrcweir 
493cdf0e10cSrcweir 	aNewName.EraseLeadingChars( ' ' );
494cdf0e10cSrcweir 	aNewName.EraseTrailingChars( ' ' );
495cdf0e10cSrcweir 
496cdf0e10cSrcweir 	if ( aNewName.Len() > 0 && aNewArea.Len() > 0 )
497cdf0e10cSrcweir 	{
498cdf0e10cSrcweir 		if ( ScRangeData::IsNameValid( aNewName, pDoc ) )
499cdf0e10cSrcweir 		{
500cdf0e10cSrcweir 			//	weil jetzt editiert werden kann, muss erst geparst werden
501cdf0e10cSrcweir 			ScRange aTmpRange;
502cdf0e10cSrcweir 			String aText = aEdAssign.GetText();
503cdf0e10cSrcweir 			if ( aTmpRange.ParseAny( aText, pDoc, aAddrDetails ) & SCA_VALID )
504cdf0e10cSrcweir 			{
505cdf0e10cSrcweir 				theCurArea = aTmpRange;
506cdf0e10cSrcweir 				ScAddress aStart = theCurArea.aStart;
507cdf0e10cSrcweir 				ScAddress aEnd   = theCurArea.aEnd;
508cdf0e10cSrcweir 
509cdf0e10cSrcweir 				ScDBData* pOldEntry = NULL;
510cdf0e10cSrcweir 				sal_uInt16 nFoundAt = 0;
511cdf0e10cSrcweir 				if ( aLocalDbCol.SearchName( aNewName, nFoundAt ) )
512cdf0e10cSrcweir 					pOldEntry = aLocalDbCol[nFoundAt];
513cdf0e10cSrcweir 				if (pOldEntry)
514cdf0e10cSrcweir 				{
515cdf0e10cSrcweir 					//	Bereich veraendern
516cdf0e10cSrcweir 
517cdf0e10cSrcweir 					pOldEntry->MoveTo( aStart.Tab(), aStart.Col(), aStart.Row(),
518cdf0e10cSrcweir 														aEnd.Col(), aEnd.Row() );
519cdf0e10cSrcweir 					pOldEntry->SetByRow( sal_True );
520cdf0e10cSrcweir 					pOldEntry->SetHeader( aBtnHeader.IsChecked() );
521cdf0e10cSrcweir 					pOldEntry->SetDoSize( aBtnDoSize.IsChecked() );
522cdf0e10cSrcweir 					pOldEntry->SetKeepFmt( aBtnKeepFmt.IsChecked() );
523cdf0e10cSrcweir 					pOldEntry->SetStripData( aBtnStripData.IsChecked() );
524cdf0e10cSrcweir 				}
525cdf0e10cSrcweir 				else
526cdf0e10cSrcweir 				{
527cdf0e10cSrcweir 					//	neuen Bereich einfuegen
528cdf0e10cSrcweir 
529cdf0e10cSrcweir 					ScDBData* pNewEntry = new ScDBData( aNewName, aStart.Tab(),
530cdf0e10cSrcweir 														aStart.Col(), aStart.Row(),
531cdf0e10cSrcweir 														aEnd.Col(), aEnd.Row(),
532cdf0e10cSrcweir 														sal_True, aBtnHeader.IsChecked() );
533cdf0e10cSrcweir 					pNewEntry->SetDoSize( aBtnDoSize.IsChecked() );
534cdf0e10cSrcweir 					pNewEntry->SetKeepFmt( aBtnKeepFmt.IsChecked() );
535cdf0e10cSrcweir 					pNewEntry->SetStripData( aBtnStripData.IsChecked() );
536cdf0e10cSrcweir 
537cdf0e10cSrcweir 					if ( !aLocalDbCol.Insert( pNewEntry ) )
538cdf0e10cSrcweir 						delete pNewEntry;
539cdf0e10cSrcweir 				}
540cdf0e10cSrcweir 
541cdf0e10cSrcweir 				UpdateNames();
542cdf0e10cSrcweir 
543cdf0e10cSrcweir 				aEdName.SetText( EMPTY_STRING );
544cdf0e10cSrcweir 				aEdName.GrabFocus();
545cdf0e10cSrcweir 				aBtnAdd.SetText( aStrAdd );
546cdf0e10cSrcweir 				aBtnAdd.Disable();
547cdf0e10cSrcweir 				aBtnRemove.Disable();
548cdf0e10cSrcweir 				aEdAssign.SetText( EMPTY_STRING );
549cdf0e10cSrcweir 				aBtnHeader.Check( sal_True );		// Default: mit Spaltenkoepfen
550cdf0e10cSrcweir 				aBtnDoSize.Check( sal_False );
551cdf0e10cSrcweir 				aBtnKeepFmt.Check( sal_False );
552cdf0e10cSrcweir 				aBtnStripData.Check( sal_False );
553cdf0e10cSrcweir 				SetInfoStrings( NULL );		// leer
554cdf0e10cSrcweir 				theCurArea = ScRange();
555cdf0e10cSrcweir 				bSaved=sal_True;
556cdf0e10cSrcweir 				pSaveObj->Save();
557cdf0e10cSrcweir 				NameModifyHdl( 0 );
558cdf0e10cSrcweir 			}
559cdf0e10cSrcweir 			else
560cdf0e10cSrcweir 			{
561cdf0e10cSrcweir 				ERRORBOX( aStrInvalid );
562cdf0e10cSrcweir 				aEdAssign.SetSelection( Selection( 0, SELECTION_MAX ) );
563cdf0e10cSrcweir 				aEdAssign.GrabFocus();
564cdf0e10cSrcweir 			}
565cdf0e10cSrcweir 		}
566cdf0e10cSrcweir 		else
567cdf0e10cSrcweir 		{
568cdf0e10cSrcweir 			ERRORBOX( ScGlobal::GetRscString(STR_INVALIDNAME) );
569cdf0e10cSrcweir 			aEdName.SetSelection( Selection( 0, SELECTION_MAX ) );
570cdf0e10cSrcweir 			aEdName.GrabFocus();
571cdf0e10cSrcweir 		}
572cdf0e10cSrcweir 	}
573cdf0e10cSrcweir 	return 0;
574cdf0e10cSrcweir }
575cdf0e10cSrcweir 
576cdf0e10cSrcweir //------------------------------------------------------------------------
577cdf0e10cSrcweir 
IMPL_LINK(ScDbNameDlg,RemoveBtnHdl,void *,EMPTYARG)578cdf0e10cSrcweir IMPL_LINK( ScDbNameDlg, RemoveBtnHdl, void *, EMPTYARG )
579cdf0e10cSrcweir {
580cdf0e10cSrcweir 	sal_uInt16		 nRemoveAt = 0;
581cdf0e10cSrcweir 	const String aStrEntry = aEdName.GetText();
582cdf0e10cSrcweir 
583cdf0e10cSrcweir 	if ( aLocalDbCol.SearchName( aStrEntry, nRemoveAt ) )
584cdf0e10cSrcweir 	{
585cdf0e10cSrcweir 		String aStrDelMsg = ScGlobal::GetRscString( STR_QUERY_DELENTRY );
586cdf0e10cSrcweir 		String aMsg		  = aStrDelMsg.GetToken( 0, '#' );
587cdf0e10cSrcweir 
588cdf0e10cSrcweir 		aMsg += aStrEntry;
589cdf0e10cSrcweir 		aMsg += aStrDelMsg.GetToken( 1, '#' );
590cdf0e10cSrcweir 
591cdf0e10cSrcweir 		if ( RET_YES == QUERYBOX(aMsg) )
592cdf0e10cSrcweir 		{
593cdf0e10cSrcweir 			ScDBData* pEntry = (ScDBData*)aLocalDbCol.At(nRemoveAt);
594cdf0e10cSrcweir 
595cdf0e10cSrcweir 			if ( pEntry )
596cdf0e10cSrcweir 			{
597cdf0e10cSrcweir                 SCTAB nTab;
598cdf0e10cSrcweir                 SCCOL nColStart, nColEnd;
599cdf0e10cSrcweir                 SCROW nRowStart, nRowEnd;
600cdf0e10cSrcweir                 pEntry->GetArea( nTab, nColStart, nRowStart, nColEnd, nRowEnd );
601cdf0e10cSrcweir 				aRemoveList.Insert(
602cdf0e10cSrcweir 					new ScRange( ScAddress( nColStart, nRowStart, nTab ),
603cdf0e10cSrcweir 								 ScAddress( nColEnd,   nRowEnd,   nTab ) ) );
604cdf0e10cSrcweir 			}
605cdf0e10cSrcweir 			aLocalDbCol.AtFree( nRemoveAt );
606cdf0e10cSrcweir 
607cdf0e10cSrcweir 			UpdateNames();
608cdf0e10cSrcweir 
609cdf0e10cSrcweir 			aEdName.SetText( EMPTY_STRING );
610cdf0e10cSrcweir 			aEdName.GrabFocus();
611cdf0e10cSrcweir 			aBtnAdd.SetText( aStrAdd );
612cdf0e10cSrcweir 			aBtnAdd.Disable();
613cdf0e10cSrcweir 			aBtnRemove.Disable();
614cdf0e10cSrcweir 			aEdAssign.SetText( EMPTY_STRING );
615cdf0e10cSrcweir 			theCurArea = ScRange();
616cdf0e10cSrcweir 			aBtnHeader.Check( sal_True );		// Default: mit Spaltenkoepfen
617cdf0e10cSrcweir 			aBtnDoSize.Check( sal_False );
618cdf0e10cSrcweir 			aBtnKeepFmt.Check( sal_False );
619cdf0e10cSrcweir 			aBtnStripData.Check( sal_False );
620cdf0e10cSrcweir 			SetInfoStrings( NULL );		// leer
621cdf0e10cSrcweir 			bSaved=sal_False;
622cdf0e10cSrcweir 			pSaveObj->Restore();
623cdf0e10cSrcweir 			NameModifyHdl( 0 );
624cdf0e10cSrcweir 		}
625cdf0e10cSrcweir 	}
626cdf0e10cSrcweir 	return 0;
627cdf0e10cSrcweir }
628cdf0e10cSrcweir 
629cdf0e10cSrcweir //------------------------------------------------------------------------
630cdf0e10cSrcweir 
IMPL_LINK(ScDbNameDlg,NameModifyHdl,void *,EMPTYARG)631cdf0e10cSrcweir IMPL_LINK( ScDbNameDlg, NameModifyHdl, void *, EMPTYARG )
632cdf0e10cSrcweir {
633cdf0e10cSrcweir 	String	theName		= aEdName.GetText();
634cdf0e10cSrcweir 	sal_Bool	bNameFound  = (COMBOBOX_ENTRY_NOTFOUND
635cdf0e10cSrcweir 						   != aEdName.GetEntryPos( theName ));
636cdf0e10cSrcweir 
637cdf0e10cSrcweir 	if ( theName.Len() == 0 )
638cdf0e10cSrcweir 	{
639cdf0e10cSrcweir 		if ( aBtnAdd.GetText() != aStrAdd )
640cdf0e10cSrcweir 			aBtnAdd.SetText( aStrAdd );
641cdf0e10cSrcweir 		aBtnAdd		.Disable();
642cdf0e10cSrcweir 		aBtnRemove	.Disable();
643cdf0e10cSrcweir         aFlAssign   .Disable();
644cdf0e10cSrcweir 		aBtnHeader	.Disable();
645cdf0e10cSrcweir 		aBtnDoSize	.Disable();
646cdf0e10cSrcweir 		aBtnKeepFmt	.Disable();
647cdf0e10cSrcweir 		aBtnStripData.Disable();
648cdf0e10cSrcweir 		aFTSource	.Disable();
649cdf0e10cSrcweir 		aFTOperations.Disable();
650cdf0e10cSrcweir 		aEdAssign	.Disable();
651cdf0e10cSrcweir 		aRbAssign	.Disable();
652cdf0e10cSrcweir 		//bSaved=sal_False;
653cdf0e10cSrcweir 		//pSaveObj->Restore();
654cdf0e10cSrcweir 		//@BugID 54702 Enablen/Disablen nur noch in Basisklasse
655cdf0e10cSrcweir 		//SFX_APPWINDOW->Disable(sal_False);		//! allgemeine Methode im ScAnyRefDlg
656cdf0e10cSrcweir 		bRefInputMode = sal_False;
657cdf0e10cSrcweir 	}
658cdf0e10cSrcweir 	else
659cdf0e10cSrcweir 	{
660cdf0e10cSrcweir 		if ( bNameFound )
661cdf0e10cSrcweir 		{
662cdf0e10cSrcweir 			if ( aBtnAdd.GetText() != aStrModify )
663cdf0e10cSrcweir 				aBtnAdd.SetText( aStrModify );
664cdf0e10cSrcweir 
665cdf0e10cSrcweir 			if(!bSaved)
666cdf0e10cSrcweir 			{
667cdf0e10cSrcweir 				bSaved=sal_True;
668cdf0e10cSrcweir 				pSaveObj->Save();
669cdf0e10cSrcweir 			}
670cdf0e10cSrcweir 			UpdateDBData( theName );
671cdf0e10cSrcweir 		}
672cdf0e10cSrcweir 		else
673cdf0e10cSrcweir 		{
674cdf0e10cSrcweir 			if ( aBtnAdd.GetText() != aStrAdd )
675cdf0e10cSrcweir 				aBtnAdd.SetText( aStrAdd );
676cdf0e10cSrcweir 
677cdf0e10cSrcweir 			bSaved=sal_False;
678cdf0e10cSrcweir 			pSaveObj->Restore();
679cdf0e10cSrcweir 
680cdf0e10cSrcweir 			if ( aEdAssign.GetText().Len() > 0 )
681cdf0e10cSrcweir 			{
682cdf0e10cSrcweir 				aBtnAdd.Enable();
683cdf0e10cSrcweir 				aBtnHeader.Enable();
684cdf0e10cSrcweir 				aBtnDoSize.Enable();
685cdf0e10cSrcweir 				aBtnKeepFmt.Enable();
686cdf0e10cSrcweir 				aBtnStripData.Enable();
687cdf0e10cSrcweir 				aFTSource.Enable();
688cdf0e10cSrcweir 				aFTOperations.Enable();
689cdf0e10cSrcweir 			}
690cdf0e10cSrcweir 			else
691cdf0e10cSrcweir 			{
692cdf0e10cSrcweir 				aBtnAdd.Disable();
693cdf0e10cSrcweir 				aBtnHeader.Disable();
694cdf0e10cSrcweir 				aBtnDoSize.Disable();
695cdf0e10cSrcweir 				aBtnKeepFmt.Disable();
696cdf0e10cSrcweir 				aBtnStripData.Disable();
697cdf0e10cSrcweir 				aFTSource.Disable();
698cdf0e10cSrcweir 				aFTOperations.Disable();
699cdf0e10cSrcweir 			}
700cdf0e10cSrcweir 			aBtnRemove.Disable();
701cdf0e10cSrcweir 		}
702cdf0e10cSrcweir 
703cdf0e10cSrcweir         aFlAssign.Enable();
704cdf0e10cSrcweir 		aEdAssign.Enable();
705cdf0e10cSrcweir 		aRbAssign.Enable();
706cdf0e10cSrcweir 
707cdf0e10cSrcweir 		//@BugID 54702 Enablen/Disablen nur noch in Basisklasse
708cdf0e10cSrcweir 		//SFX_APPWINDOW->Enable();
709cdf0e10cSrcweir 		bRefInputMode = sal_True;
710cdf0e10cSrcweir 	}
711cdf0e10cSrcweir 	return 0;
712cdf0e10cSrcweir }
713cdf0e10cSrcweir 
714cdf0e10cSrcweir //------------------------------------------------------------------------
715cdf0e10cSrcweir 
IMPL_LINK(ScDbNameDlg,AssModifyHdl,void *,EMPTYARG)716cdf0e10cSrcweir IMPL_LINK( ScDbNameDlg, AssModifyHdl, void *, EMPTYARG )
717cdf0e10cSrcweir {
718cdf0e10cSrcweir 	//	hier parsen fuer Save() etc.
719cdf0e10cSrcweir 
720cdf0e10cSrcweir 	ScRange aTmpRange;
721cdf0e10cSrcweir 	String aText = aEdAssign.GetText();
722cdf0e10cSrcweir 	if ( aTmpRange.ParseAny( aText, pDoc, aAddrDetails ) & SCA_VALID )
723cdf0e10cSrcweir 		theCurArea = aTmpRange;
7240deba7fbSSteve Yin     if( aText.Len() > 0 && aEdName.GetText().Len() > 0 )
7250deba7fbSSteve Yin     {
7260deba7fbSSteve Yin 		aBtnAdd.Enable();
7270deba7fbSSteve Yin 		aBtnHeader.Enable();
7280deba7fbSSteve Yin 		aBtnDoSize.Enable();
7290deba7fbSSteve Yin 		aBtnKeepFmt.Enable();
7300deba7fbSSteve Yin 		aBtnStripData.Enable();
7310deba7fbSSteve Yin 		aFTSource.Enable();
7320deba7fbSSteve Yin 		aFTOperations.Enable();
7330deba7fbSSteve Yin     }
7340deba7fbSSteve Yin     else
7350deba7fbSSteve Yin     {
7360deba7fbSSteve Yin 		aBtnAdd.Disable();
7370deba7fbSSteve Yin 		aBtnHeader.Disable();
7380deba7fbSSteve Yin 		aBtnDoSize.Disable();
7390deba7fbSSteve Yin 		aBtnKeepFmt.Disable();
7400deba7fbSSteve Yin 		aBtnStripData.Disable();
7410deba7fbSSteve Yin 		aFTSource.Disable();
7420deba7fbSSteve Yin 		aFTOperations.Disable();
7430deba7fbSSteve Yin     }
744cdf0e10cSrcweir 	return 0;
745cdf0e10cSrcweir }
746cdf0e10cSrcweir 
IMPL_LINK(ScDbNameDlg,FocusToComoboxHdl,Timer *,pTi)7470deba7fbSSteve Yin IMPL_LINK( ScDbNameDlg, FocusToComoboxHdl, Timer*, pTi)
7480deba7fbSSteve Yin {
7490deba7fbSSteve Yin 	(void)pTi;
7500deba7fbSSteve Yin 	// CallEventListeners is still protected - figure out if we need to make it public, or if the focus stuff can be handled better in VCL directly. First see what AT is expecting...
7510deba7fbSSteve Yin 	// aEdName.CallEventListeners( VCLEVENT_CONTROL_GETFOCUS );
7520deba7fbSSteve Yin 	return 0;
7530deba7fbSSteve Yin }
754