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
9 * with the License. You may obtain a copy of the License at
10 *
11 * http://www.apache.org/licenses/LICENSE-2.0
12 *
13 * Unless required by applicable law or agreed to in writing,
14 * software distributed under the License is distributed on an
15 * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16 * KIND, either express or implied. See the License for the
17 * specific language governing permissions and limitations
18 * under the License.
19 *
20 *************************************************************/
21
22
23
24 // MARKER(update_precomp.py): autogen include statement, do not remove
25 #include "precompiled_sc.hxx"
26
27 #undef SC_DLLIMPLEMENTATION
28
29
30
31 //------------------------------------------------------------------
32
33 #include <sfx2/app.hxx>
34 #include <sfx2/docfile.hxx>
35 #include <sfx2/docinsert.hxx>
36 #include <sfx2/filedlghelper.hxx>
37 #include <svtools/ehdl.hxx>
38 #include <svtools/sfxecode.hxx>
39 #include <vcl/msgbox.hxx>
40
41 #include "global.hxx"
42 #include "docsh.hxx"
43 #include "viewdata.hxx"
44 #include "scresid.hxx"
45 #include "instbdlg.hrc"
46 #include "globstr.hrc"
47
48 #define SC_INSTBDLG_CXX
49 #include "instbdlg.hxx"
50
51 #include <layout/layout-pre.hxx>
52
53 #if ENABLE_LAYOUT
54 #undef ScResId
55 #define ScResId(x) #x
56 #undef ModalDialog
57 #define ModalDialog( parent, id ) Dialog( parent, "insert-sheet.xml", id )
58 #undef ErrorBox
59 #define ErrorBox( this, bits, message ) ErrorBox (LAYOUT_THIS_WINDOW (this), bits, message)
60 #endif /* ENABLE_LAYOUT */
61
62 //==================================================================
63
ScInsertTableDlg(Window * pParent,ScViewData & rData,SCTAB nTabCount,bool bFromFile)64 ScInsertTableDlg::ScInsertTableDlg( Window* pParent, ScViewData& rData, SCTAB nTabCount, bool bFromFile )
65
66 : ModalDialog ( pParent, ScResId( RID_SCDLG_INSERT_TABLE ) ),
67 //
68 aFlPos ( this, ScResId( FL_POSITION ) ),
69 aBtnBefore ( this, ScResId( RB_BEFORE ) ),
70 aBtnBehind ( this, ScResId( RB_BEHIND ) ),
71 aFlTable ( this, ScResId( FL_TABLE ) ),
72 aBtnNew ( this, ScResId( RB_NEW ) ),
73 aBtnFromFile ( this, ScResId( RB_FROMFILE ) ),
74 aFtCount ( this, ScResId( FT_COUNT ) ),
75 aNfCount ( this, ScResId( NF_COUNT ) ),
76 aFtName ( this, ScResId( FT_NAME ) ),
77 aEdName ( this, ScResId( ED_TABNAME ) ),
78 aLbTables ( this, ScResId( LB_TABLES ) ),
79 aFtPath ( this, ScResId( FT_PATH ) ),
80 aBtnBrowse ( this, ScResId( BTN_BROWSE ) ),
81 aBtnLink ( this, ScResId( CB_LINK ) ),
82 aBtnOk ( this, ScResId( BTN_OK ) ),
83 aBtnCancel ( this, ScResId( BTN_CANCEL ) ),
84 aBtnHelp ( this, ScResId( BTN_HELP ) ),
85 rViewData ( rData ),
86 rDoc ( *rData.GetDocument() ),
87 pDocShTables ( NULL ),
88 pDocInserter ( NULL ),
89 bMustClose ( false ),
90 nSelTabIndex ( 0 ),
91 nTableCount (nTabCount)
92 {
93 #if ENABLE_LAYOUT
94 SetHelpId (SID_INSERT_TABLE);
95 aFtPath.SetText (EMPTY_STRING);
96 #endif /* ENABLE_LAYOUT */
97 Init_Impl( bFromFile );
98 FreeResource();
99 aLbTables.SetAccessibleName(aBtnFromFile.GetText());
100 }
101
102 //------------------------------------------------------------------------
103
~ScInsertTableDlg()104 __EXPORT ScInsertTableDlg::~ScInsertTableDlg()
105 {
106 if (pDocShTables)
107 pDocShTables->DoClose();
108 delete pDocInserter;
109 }
110
111 //------------------------------------------------------------------------
112
Init_Impl(bool bFromFile)113 void ScInsertTableDlg::Init_Impl( bool bFromFile )
114 {
115 aBtnBrowse .SetClickHdl( LINK( this, ScInsertTableDlg, BrowseHdl_Impl ) );
116 aBtnNew .SetClickHdl( LINK( this, ScInsertTableDlg, ChoiceHdl_Impl ) );
117 aBtnFromFile .SetClickHdl( LINK( this, ScInsertTableDlg, ChoiceHdl_Impl ) );
118 aLbTables .SetSelectHdl( LINK( this, ScInsertTableDlg, SelectHdl_Impl ) );
119 aNfCount .SetModifyHdl( LINK( this, ScInsertTableDlg, CountHdl_Impl));
120 aBtnOk .SetClickHdl( LINK( this, ScInsertTableDlg, DoEnterHdl ));
121 aBtnBefore.Check();
122
123 aNfCount.SetText( String::CreateFromInt32(nTableCount) );
124 aNfCount.SetMax( MAXTAB - rDoc.GetTableCount() + 1 );
125
126 if(nTableCount==1)
127 {
128 String aName;
129 rDoc.CreateValidTabName( aName );
130 aEdName.SetText( aName );
131 }
132 else
133 {
134 String aName=aFlTable.GetText();
135 aName.AppendAscii(RTL_CONSTASCII_STRINGPARAM("..."));
136 aEdName.SetText( aName );
137 aFtName.Disable();
138 aEdName.Disable();
139 }
140
141 bool bShared = ( rViewData.GetDocShell() ? rViewData.GetDocShell()->IsDocShared() : false );
142
143 if ( !bFromFile || bShared )
144 {
145 aBtnNew.Check();
146 SetNewTable_Impl();
147 if ( bShared )
148 {
149 aBtnFromFile.Disable();
150 }
151 }
152 else
153 {
154 aBtnFromFile.Check();
155 SetFromTo_Impl();
156
157 aBrowseTimer.SetTimeoutHdl( LINK( this, ScInsertTableDlg, BrowseTimeoutHdl ) );
158 aBrowseTimer.SetTimeout( 200 );
159 }
160 }
161
162 //------------------------------------------------------------------------
163
164 #if ENABLE_LAYOUT
165 #undef ModalDialog
166 #define ModalDialog Dialog
167 #endif /* ENABLE_LAYOUT */
168
Execute()169 short __EXPORT ScInsertTableDlg::Execute()
170 {
171 // set Parent of DocumentInserter and Doc-Manager
172 Window* pOldDefParent = Application::GetDefDialogParent();
173 Application::SetDefDialogParent( LAYOUT_THIS_WINDOW (this) );
174
175 if ( aBtnFromFile.IsChecked() )
176 aBrowseTimer.Start();
177
178 short nRet = ModalDialog::Execute();
179 Application::SetDefDialogParent( pOldDefParent );
180 return nRet;
181 }
182
183 //------------------------------------------------------------------------
184
SetNewTable_Impl()185 void ScInsertTableDlg::SetNewTable_Impl()
186 {
187 if (aBtnNew.IsChecked() )
188 {
189 aNfCount .Enable();
190 aFtCount .Enable();
191 aLbTables .Disable();
192 aFtPath .Disable();
193 aBtnBrowse .Disable();
194 aBtnLink .Disable();
195
196 if(nTableCount==1)
197 {
198 aEdName.Enable();
199 aFtName.Enable();
200 }
201 }
202 }
203
204 //------------------------------------------------------------------------
205
SetFromTo_Impl()206 void ScInsertTableDlg::SetFromTo_Impl()
207 {
208 if (aBtnFromFile.IsChecked() )
209 {
210 aEdName .Disable();
211 aFtName .Disable();
212 aFtCount .Disable();
213 aNfCount .Disable();
214 aLbTables .Enable();
215 aFtPath .Enable();
216 aBtnBrowse .Enable();
217 aBtnLink .Enable();
218 }
219 }
220
221 //------------------------------------------------------------------------
222
FillTables_Impl(ScDocument * pSrcDoc)223 void ScInsertTableDlg::FillTables_Impl( ScDocument* pSrcDoc )
224 {
225 aLbTables.SetUpdateMode( sal_False );
226 aLbTables.Clear();
227
228 if ( pSrcDoc )
229 {
230 SCTAB nCount = pSrcDoc->GetTableCount();
231 String aName;
232
233 for ( SCTAB i=0; i<nCount; i++ )
234 {
235 pSrcDoc->GetName( i, aName );
236 aLbTables.InsertEntry( aName );
237 }
238 }
239
240 aLbTables.SetUpdateMode( sal_True );
241
242 if(aLbTables.GetEntryCount()==1)
243 aLbTables.SelectEntryPos(0);
244 }
245
246 //------------------------------------------------------------------------
247
GetFirstTable(sal_uInt16 * pN)248 const String* ScInsertTableDlg::GetFirstTable( sal_uInt16* pN )
249 {
250 const String* pStr = NULL;
251
252 if ( aBtnNew.IsChecked() )
253 {
254 aStrCurSelTable = aEdName.GetText();
255 pStr = &aStrCurSelTable;
256 }
257 else if ( nSelTabIndex < aLbTables.GetSelectEntryCount() )
258 {
259 aStrCurSelTable = aLbTables.GetSelectEntry( 0 );
260 pStr = &aStrCurSelTable;
261 if ( pN )
262 *pN = aLbTables.GetSelectEntryPos( 0 );
263 nSelTabIndex = 1;
264 }
265
266 return pStr;
267 }
268
269 //------------------------------------------------------------------------
270
GetNextTable(sal_uInt16 * pN)271 const String* ScInsertTableDlg::GetNextTable( sal_uInt16* pN )
272 {
273 const String* pStr = NULL;
274
275 if ( !aBtnNew.IsChecked() && nSelTabIndex < aLbTables.GetSelectEntryCount() )
276 {
277 aStrCurSelTable = aLbTables.GetSelectEntry( nSelTabIndex );
278 pStr = &aStrCurSelTable;
279 if ( pN )
280 *pN = aLbTables.GetSelectEntryPos( nSelTabIndex );
281 nSelTabIndex++;
282 }
283
284 return pStr;
285 }
286
287
288 //------------------------------------------------------------------------
289 // Handler:
290 //------------------------------------------------------------------------
291
IMPL_LINK(ScInsertTableDlg,CountHdl_Impl,NumericField *,EMPTYARG)292 IMPL_LINK( ScInsertTableDlg, CountHdl_Impl, NumericField*, EMPTYARG )
293 {
294 nTableCount = static_cast<SCTAB>(aNfCount.GetValue());
295 if ( nTableCount==1)
296 {
297 String aName;
298 rDoc.CreateValidTabName( aName );
299 aEdName.SetText( aName );
300 aFtName.Enable();
301 aEdName.Enable();
302 }
303 else
304 {
305 String aName=aFlTable.GetText();
306 aName.AppendAscii(RTL_CONSTASCII_STRINGPARAM("..."));
307 aEdName.SetText( aName );
308 aFtName.Disable();
309 aEdName.Disable();
310 }
311
312 DoEnable_Impl();
313 return 0;
314 }
315
316 //------------------------------------------------------------------------
IMPL_LINK(ScInsertTableDlg,ChoiceHdl_Impl,RadioButton *,EMPTYARG)317 IMPL_LINK( ScInsertTableDlg, ChoiceHdl_Impl, RadioButton*, EMPTYARG )
318 {
319 if ( aBtnNew.IsChecked() )
320 SetNewTable_Impl();
321 else
322 SetFromTo_Impl();
323
324 DoEnable_Impl();
325 return 0;
326 }
327
328 //------------------------------------------------------------------------
329
IMPL_LINK(ScInsertTableDlg,BrowseHdl_Impl,PushButton *,EMPTYARG)330 IMPL_LINK( ScInsertTableDlg, BrowseHdl_Impl, PushButton*, EMPTYARG )
331 {
332 if ( pDocInserter )
333 delete pDocInserter;
334 pDocInserter = new ::sfx2::DocumentInserter(
335 0, String::CreateFromAscii( ScDocShell::Factory().GetShortName() ) );
336 pDocInserter->StartExecuteModal( LINK( this, ScInsertTableDlg, DialogClosedHdl ) );
337 return 0;
338 }
339
340 //------------------------------------------------------------------------
341
IMPL_LINK(ScInsertTableDlg,SelectHdl_Impl,MultiListBox *,EMPTYARG)342 IMPL_LINK( ScInsertTableDlg, SelectHdl_Impl, MultiListBox*, EMPTYARG )
343 {
344 DoEnable_Impl();
345 return 0;
346 }
347
348 //------------------------------------------------------------------------
349
DoEnable_Impl()350 void ScInsertTableDlg::DoEnable_Impl()
351 {
352 if ( aBtnNew.IsChecked() || ( pDocShTables && aLbTables.GetSelectEntryCount() ) )
353 aBtnOk.Enable();
354 else
355 aBtnOk.Disable();
356 }
357
IMPL_LINK(ScInsertTableDlg,DoEnterHdl,PushButton *,EMPTYARG)358 IMPL_LINK( ScInsertTableDlg, DoEnterHdl, PushButton*, EMPTYARG )
359 {
360 if(nTableCount > 1 || rDoc.ValidTabName(aEdName.GetText()))
361 {
362 EndDialog(RET_OK);
363 }
364 else
365 {
366 String aErrMsg ( ScGlobal::GetRscString( STR_INVALIDTABNAME ) );
367 (void)ErrorBox( this,WinBits( WB_OK | WB_DEF_OK ),aErrMsg).Execute();
368 }
369 return 0;
370 }
371
IMPL_LINK(ScInsertTableDlg,BrowseTimeoutHdl,Timer *,EMPTYARG)372 IMPL_LINK( ScInsertTableDlg, BrowseTimeoutHdl, Timer*, EMPTYARG )
373 {
374 bMustClose = true;
375 BrowseHdl_Impl( &aBtnBrowse );
376 return 0;
377 }
378
IMPL_LINK(ScInsertTableDlg,DialogClosedHdl,sfx2::FileDialogHelper *,_pFileDlg)379 IMPL_LINK( ScInsertTableDlg, DialogClosedHdl, sfx2::FileDialogHelper*, _pFileDlg )
380 {
381 if ( ERRCODE_NONE == _pFileDlg->GetError() )
382 {
383 SfxMedium* pMed = pDocInserter->CreateMedium();
384 if ( pMed )
385 {
386 // ERRCTX_SFX_OPENDOC -> "Fehler beim Laden des Dokumentes"
387 SfxErrorContext aEc( ERRCTX_SFX_OPENDOC, pMed->GetName() );
388
389 if ( pDocShTables )
390 pDocShTables->DoClose(); // delete passiert beim Zuweisen auf die Ref
391
392 pMed->UseInteractionHandler( sal_True ); // to enable the filter options dialog
393
394 pDocShTables = new ScDocShell;
395 aDocShTablesRef = pDocShTables;
396
397 Pointer aOldPtr( GetPointer() );
398 SetPointer( Pointer( POINTER_WAIT ) );
399 pDocShTables->DoLoad( pMed );
400 SetPointer( aOldPtr );
401
402 sal_uLong nErr = pDocShTables->GetErrorCode();
403 if ( nErr )
404 ErrorHandler::HandleError( nErr ); // auch Warnings
405
406 if ( !pDocShTables->GetError() ) // nur Errors
407 {
408 FillTables_Impl( pDocShTables->GetDocument() );
409 aFtPath.SetText( pDocShTables->GetTitle( SFX_TITLE_FULLNAME ) );
410 }
411 else
412 {
413 pDocShTables->DoClose();
414 aDocShTablesRef.Clear();
415 pDocShTables = NULL;
416
417 FillTables_Impl( NULL );
418 aFtPath.SetText( EMPTY_STRING );
419 }
420 }
421
422 DoEnable_Impl();
423 }
424 else if ( bMustClose )
425 // execute slot FID_INS_TABLE_EXT and cancel file dialog
426 EndDialog( RET_CANCEL );
427
428 return 0;
429 }
430
431