dbnamdlg.cxx (57b4fa3c) | dbnamdlg.cxx (22407013) |
---|---|
1/************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance --- 146 unchanged lines hidden (view full) --- 155 aBtnCancel ( this, ScResId( BTN_CANCEL ) ), 156 aBtnHelp ( this, ScResId( BTN_HELP ) ), 157 aBtnAdd ( this, ScResId( BTN_ADD ) ), 158 aBtnRemove ( this, ScResId( BTN_REMOVE ) ), 159 aBtnMore ( this, ScResId( BTN_MORE ) ), 160 161 aStrAdd ( ScResId( STR_ADD ) ), 162 aStrModify ( ScResId( STR_MODIFY ) ), | 1/************************************************************** 2 * 3 * Licensed to the Apache Software Foundation (ASF) under one 4 * or more contributor license agreements. See the NOTICE file 5 * distributed with this work for additional information 6 * regarding copyright ownership. The ASF licenses this file 7 * to you under the Apache License, Version 2.0 (the 8 * "License"); you may not use this file except in compliance --- 146 unchanged lines hidden (view full) --- 155 aBtnCancel ( this, ScResId( BTN_CANCEL ) ), 156 aBtnHelp ( this, ScResId( BTN_HELP ) ), 157 aBtnAdd ( this, ScResId( BTN_ADD ) ), 158 aBtnRemove ( this, ScResId( BTN_REMOVE ) ), 159 aBtnMore ( this, ScResId( BTN_MORE ) ), 160 161 aStrAdd ( ScResId( STR_ADD ) ), 162 aStrModify ( ScResId( STR_MODIFY ) ), |
163 aStrNoName ( ScGlobal::GetRscString(STR_DB_NONAME) ), | |
164 aStrInvalid ( ScResId( STR_DB_INVALID ) ), 165 // 166 pViewData ( ptrViewData ), 167 pDoc ( ptrViewData->GetDocument() ), 168 bRefInputMode ( sal_False ), 169 aAddrDetails ( pDoc->GetAddressConvention(), 0, 0 ), 170 aLocalDbCol ( *(pDoc->GetDBCollection()) ) 171{ --- 28 unchanged lines hidden (view full) --- 200 } 201} 202 203 204//---------------------------------------------------------------------------- 205 206void ScDbNameDlg::Init() 207{ | 163 aStrInvalid ( ScResId( STR_DB_INVALID ) ), 164 // 165 pViewData ( ptrViewData ), 166 pDoc ( ptrViewData->GetDocument() ), 167 bRefInputMode ( sal_False ), 168 aAddrDetails ( pDoc->GetAddressConvention(), 0, 0 ), 169 aLocalDbCol ( *(pDoc->GetDBCollection()) ) 170{ --- 28 unchanged lines hidden (view full) --- 199 } 200} 201 202 203//---------------------------------------------------------------------------- 204 205void ScDbNameDlg::Init() 206{ |
208 aBtnHeader.Check( sal_True ); // Default: mit Spaltenkoepfen | 207 aBtnHeader.Check( sal_True ); // Default: mit Spaltenkoepfen |
209 210 aBtnMore.AddWindow( &aFlOptions ); | 208 209 aBtnMore.AddWindow( &aFlOptions ); |
211 aBtnMore.AddWindow( &aBtnHeader ); 212 aBtnMore.AddWindow( &aBtnDoSize ); 213 aBtnMore.AddWindow( &aBtnKeepFmt ); 214 aBtnMore.AddWindow( &aBtnStripData ); 215 aBtnMore.AddWindow( &aFTSource ); 216 aBtnMore.AddWindow( &aFTOperations ); | 210 aBtnMore.AddWindow( &aBtnHeader ); 211 aBtnMore.AddWindow( &aBtnDoSize ); 212 aBtnMore.AddWindow( &aBtnKeepFmt ); 213 aBtnMore.AddWindow( &aBtnStripData ); 214 aBtnMore.AddWindow( &aFTSource ); 215 aBtnMore.AddWindow( &aFTOperations ); |
217 | 216 |
218 String theAreaStr; 219 SCCOL nStartCol = 0; 220 SCROW nStartRow = 0; 221 SCTAB nStartTab = 0; 222 SCCOL nEndCol = 0; 223 SCROW nEndRow = 0; 224 SCTAB nEndTab = 0; | 217 String theAreaStr; 218 SCCOL nStartCol = 0; 219 SCROW nStartRow = 0; 220 SCTAB nStartTab = 0; 221 SCCOL nEndCol = 0; 222 SCROW nEndRow = 0; 223 SCTAB nEndTab = 0; |
225 | 224 |
226 aBtnOk.SetClickHdl ( LINK( this, ScDbNameDlg, OkBtnHdl ) ); 227 aBtnCancel.SetClickHdl ( LINK( this, ScDbNameDlg, CancelBtnHdl ) ); 228 aBtnAdd.SetClickHdl ( LINK( this, ScDbNameDlg, AddBtnHdl ) ); 229 aBtnRemove.SetClickHdl ( LINK( this, ScDbNameDlg, RemoveBtnHdl ) ); 230 aEdName.SetModifyHdl ( LINK( this, ScDbNameDlg, NameModifyHdl ) ); 231 aEdAssign.SetModifyHdl ( LINK( this, ScDbNameDlg, AssModifyHdl ) ); 232 UpdateNames(); | 225 aBtnOk.SetClickHdl ( LINK( this, ScDbNameDlg, OkBtnHdl ) ); 226 aBtnCancel.SetClickHdl ( LINK( this, ScDbNameDlg, CancelBtnHdl ) ); 227 aBtnAdd.SetClickHdl ( LINK( this, ScDbNameDlg, AddBtnHdl ) ); 228 aBtnRemove.SetClickHdl ( LINK( this, ScDbNameDlg, RemoveBtnHdl ) ); 229 aEdName.SetModifyHdl ( LINK( this, ScDbNameDlg, NameModifyHdl ) ); 230 aEdAssign.SetModifyHdl ( LINK( this, ScDbNameDlg, AssModifyHdl ) ); 231 UpdateNames(); |
233 | 232 |
234 if ( pViewData && pDoc ) 235 { 236 ScDBCollection* pDBColl = pDoc->GetDBCollection(); 237 ScDBData* pDBData = NULL; | 233 if ( pViewData && pDoc ) 234 { 235 ScDBCollection* pDBColl = pDoc->GetDBCollection(); 236 ScDBData* pDBData = NULL; |
238 | 237 |
239 pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab, 240 nEndCol, nEndRow, nEndTab ); | 238 pViewData->GetSimpleArea( nStartCol, nStartRow, nStartTab, 239 nEndCol, nEndRow, nEndTab ); |
241 | 240 |
242 theCurArea = ScRange( ScAddress( nStartCol, nStartRow, nStartTab ), 243 ScAddress( nEndCol, nEndRow, nEndTab ) ); | 241 theCurArea = ScRange( ScAddress( nStartCol, nStartRow, nStartTab ), 242 ScAddress( nEndCol, nEndRow, nEndTab ) ); |
244 | 243 |
245 theCurArea.Format( theAreaStr, ABS_DREF3D, pDoc, aAddrDetails ); | 244 theCurArea.Format( theAreaStr, ABS_DREF3D, pDoc, aAddrDetails ); |
246 | 245 |
247 if ( pDBColl ) 248 { 249 // Feststellen, ob definierter DB-Bereich markiert wurde: 250 pDBData = pDBColl->GetDBAtCursor( nStartCol, nStartRow, nStartTab, sal_True ); 251 if ( pDBData ) 252 { 253 String theDbName; 254 ScAddress& rStart = theCurArea.aStart; 255 ScAddress& rEnd = theCurArea.aEnd; | 246 if ( pDBColl ) 247 { 248 // Feststellen, ob definierter DB-Bereich markiert wurde: 249 pDBData = pDBColl->GetDBAtCursor( nStartCol, nStartRow, nStartTab, sal_True ); 250 if ( pDBData ) 251 { 252 String theDbName; 253 ScAddress& rStart = theCurArea.aStart; 254 ScAddress& rEnd = theCurArea.aEnd; |
256 SCCOL nCol1; 257 SCCOL nCol2; 258 SCROW nRow1; 259 SCROW nRow2; 260 SCTAB nTab; 261 | 255 SCCOL nCol1; 256 SCCOL nCol2; 257 SCROW nRow1; 258 SCROW nRow2; 259 SCTAB nTab; 260 |
262 pDBData->GetArea( nTab, nCol1, nRow1, nCol2, nRow2 ); | 261 pDBData->GetArea( nTab, nCol1, nRow1, nCol2, nRow2 ); |
263 | 262 |
264 if ( (rStart.Tab() == nTab) 265 && (rStart.Col() == nCol1) && (rStart.Row() == nRow1) 266 && (rEnd.Col() == nCol2) && (rEnd.Row() == nRow2 ) ) 267 { 268 pDBData->GetName( theDbName ); 269 //if ( theDbName != aStrNoName ) 270 if ( !pDBData->IsBuildin() ) 271 aEdName.SetText( theDbName ); 272 else 273 aEdName.SetText( EMPTY_STRING ); 274 aBtnHeader.Check( pDBData->HasHeader() ); 275 aBtnDoSize.Check( pDBData->IsDoSize() ); 276 aBtnKeepFmt.Check( pDBData->IsKeepFmt() ); 277 aBtnStripData.Check( pDBData->IsStripData() ); 278 SetInfoStrings( pDBData ); 279 } 280 } 281 } 282 } | 263 if ( (rStart.Tab() == nTab) 264 && (rStart.Col() == nCol1) && (rStart.Row() == nRow1) 265 && (rEnd.Col() == nCol2) && (rEnd.Row() == nRow2 ) ) 266 { 267 pDBData->GetName( theDbName ); 268 if ( !pDBData->IsInternalUnnamed() 269 && !pDBData->IsInternalForAutoFilter() ) 270 { 271 aEdName.SetText( theDbName ); 272 } 273 else 274 { 275 aEdName.SetText( EMPTY_STRING ); 276 } 277 aBtnHeader.Check( pDBData->HasHeader() ); 278 aBtnDoSize.Check( pDBData->IsDoSize() ); 279 aBtnKeepFmt.Check( pDBData->IsKeepFmt() ); 280 aBtnStripData.Check( pDBData->IsStripData() ); 281 SetInfoStrings( pDBData ); 282 } 283 } 284 } 285 } |
283 | 286 |
284 aEdAssign.SetText( theAreaStr ); 285 aEdName.GrabFocus(); 286 bSaved=sal_True; 287 pSaveObj->Save(); 288 NameModifyHdl( 0 ); | 287 aEdAssign.SetText( theAreaStr ); 288 aEdName.GrabFocus(); 289 bSaved=sal_True; 290 pSaveObj->Save(); 291 NameModifyHdl( 0 ); |
289} 290 291 292void ScDbNameDlg::SetInfoStrings( const ScDBData* pDBData ) 293{ 294 String aSource = aStrSource; 295 if (pDBData) 296 { --- 59 unchanged lines hidden (view full) --- 356 357 RefInputDone(); 358} 359 360//------------------------------------------------------------------------ 361 362void ScDbNameDlg::UpdateNames() 363{ | 292} 293 294 295void ScDbNameDlg::SetInfoStrings( const ScDBData* pDBData ) 296{ 297 String aSource = aStrSource; 298 if (pDBData) 299 { --- 59 unchanged lines hidden (view full) --- 359 360 RefInputDone(); 361} 362 363//------------------------------------------------------------------------ 364 365void ScDbNameDlg::UpdateNames() 366{ |
364 sal_uInt16 nNameCount = aLocalDbCol.GetCount(); | 367 sal_uInt16 nNameCount = aLocalDbCol.GetCount(); |
365 | 368 |
366 aEdName.SetUpdateMode( sal_False ); 367 //----------------------------------------------------------- 368 aEdName.Clear(); 369 aEdAssign.SetText( EMPTY_STRING ); | 369 aEdName.SetUpdateMode( sal_False ); 370 //----------------------------------------------------------- 371 aEdName.Clear(); 372 aEdAssign.SetText( EMPTY_STRING ); |
370 | 373 |
371 if ( nNameCount > 0 ) 372 { 373 ScDBData* pDbData = NULL; 374 String aString; | 374 if ( nNameCount > 0 ) 375 { 376 ScDBData* pDbData = NULL; 377 String aString; |
375 | 378 |
376 for ( sal_uInt16 i=0; i<nNameCount; i++ ) 377 { 378 pDbData = (ScDBData*)(aLocalDbCol.At( i )); 379 if ( pDbData ) 380 { 381 pDbData->GetName( aString ); 382 //if ( aString != aStrNoName ) 383 if ( !pDbData->IsBuildin() ) 384 aEdName.InsertEntry( aString ); 385 } 386 } 387 } 388 else 389 { 390 aBtnAdd.SetText( aStrAdd ); 391 aBtnAdd.Disable(); 392 aBtnRemove.Disable(); 393 } 394 //----------------------------------------------------------- 395 aEdName.SetUpdateMode( sal_True ); 396 aEdName.Invalidate(); | 379 for ( sal_uInt16 i=0; i<nNameCount; i++ ) 380 { 381 pDbData = (ScDBData*)(aLocalDbCol.At( i )); 382 if ( pDbData ) 383 { 384 pDbData->GetName( aString ); 385 if ( !pDbData->IsInternalUnnamed() 386 && !pDbData->IsInternalForAutoFilter() ) 387 aEdName.InsertEntry( aString ); 388 } 389 } 390 } 391 else 392 { 393 aBtnAdd.SetText( aStrAdd ); 394 aBtnAdd.Disable(); 395 aBtnRemove.Disable(); 396 } 397 //----------------------------------------------------------- 398 aEdName.SetUpdateMode( sal_True ); 399 aEdName.Invalidate(); |
397} 398 399//------------------------------------------------------------------------ 400 401void ScDbNameDlg::UpdateDBData( const String& rStrName ) 402{ 403 String theArea; 404 sal_uInt16 nAt; --- 316 unchanged lines hidden --- | 400} 401 402//------------------------------------------------------------------------ 403 404void ScDbNameDlg::UpdateDBData( const String& rStrName ) 405{ 406 String theArea; 407 sal_uInt16 nAt; --- 316 unchanged lines hidden --- |