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