?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
Version 4.0.2.1, tag libreoffice-4.0.2.1
[LibreOffice.git] / sc / source / ui / view / cellsh2.cxx
blob1ab57f6d665cda3dde338bdd244f7f5d78c3b5a6
1 /* -*- Mode: C++; tab-width: 4; indent-tabs-mode: nil; c-basic-offset: 4 -*- */
2 /*
3 * This file is part of the LibreOffice project.
4 *
5 * This Source Code Form is subject to the terms of the Mozilla Public
6 * License, v. 2.0. If a copy of the MPL was not distributed with this
7 * file, You can obtain one at http://mozilla.org/MPL/2.0/.
8 *
9 * This file incorporates work covered by the following license notice:
10 *
11 * Licensed to the Apache Software Foundation (ASF) under one or more
12 * contributor license agreements. See the NOTICE file distributed
13 * with this work for additional information regarding copyright
14 * ownership. The ASF licenses this file to you under the Apache
15 * License, Version 2.0 (the "License"); you may not use this file
16 * except in compliance with the License. You may obtain a copy of
17 * the License at http://www.apache.org/licenses/LICENSE-2.0 .
18 */
19
20 #include "scitems.hxx"
21 #include <sfx2/viewfrm.hxx>
22 #include <sfx2/app.hxx>
23 #include <sfx2/request.hxx>
24 #include <svl/aeitem.hxx>
25 #include <basic/sbxcore.hxx>
26 #include <svl/whiter.hxx>
27 #include <svl/zforlist.hxx>
28 #include <vcl/msgbox.hxx>
29 #include <svl/stritem.hxx>
30 #include <svl/visitem.hxx>
31 #include <unotools/moduleoptions.hxx>
32
33 #include <com/sun/star/frame/FrameSearchFlag.hpp>
34 #include <com/sun/star/sdbc/XResultSet.hpp>
35
36 #include "cellsh.hxx"
37 #include "tabvwsh.hxx"
38 #include "sc.hrc"
39 #include "globstr.hrc"
40 #include "global.hxx"
41 #include "globalnames.hxx"
42 #include "scmod.hxx"
43 #include "docsh.hxx"
44 #include "document.hxx"
45 #include "uiitems.hxx"
46 #include "dbfunc.hxx"
47 #include "dbdocfun.hxx"
48 #include "filtdlg.hxx"
49 #include "dbnamdlg.hxx"
50 #include "reffact.hxx"
51 #include "pvlaydlg.hxx"
52 #include "validat.hxx"
53 #include "scresid.hxx"
54
55 #include "validate.hrc" // ScValidationDlg
56 #include "scui_def.hxx"
57 #include "scabstdlg.hxx"
58 #include "impex.hxx"
59 #include "asciiopt.hxx"
60 #include "queryentry.hxx"
61 #include "markdata.hxx"
62
63 using namespace com::sun::star;
64
65 static bool lcl_GetTextToColumnsRange( const ScViewData* pData, ScRange& rRange )
66 {
67 OSL_ENSURE( pData, "lcl_GetTextToColumnsRange: pData is null!" );
68
69 bool bRet = false;
70 const ScMarkData& rMark = pData->GetMarkData();
71
72 if ( rMark.IsMarked() )
73 {
74 if ( !rMark.IsMultiMarked() )
75 {
76 rMark.GetMarkArea( rRange );
77 if ( rRange.aStart.Col() == rRange.aEnd.Col() )
78 {
79 bRet = true;
80 }
81 }
82 }
83 else
84 {
85 const SCCOL nCol = pData->GetCurX();
86 const SCROW nRow = pData->GetCurY();
87 const SCTAB nTab = pData->GetTabNo();
88 rRange = ScRange( nCol, nRow, nTab, nCol, nRow, nTab );
89 bRet = true;
90 }
91
92 const ScDocument* pDoc = pData->GetDocument();
93 OSL_ENSURE( pDoc, "lcl_GetTextToColumnsRange: pDoc is null!" );
94
95 if ( bRet && pDoc->IsBlockEmpty( rRange.aStart.Tab(), rRange.aStart.Col(),
96 rRange.aStart.Row(), rRange.aEnd.Col(),
97 rRange.aEnd.Row() ) )
98 {
99 bRet = false;
100 }
101
102 return bRet;
103 }
104
105 static sal_Bool lcl_GetSortParam( const ScViewData* pData, ScSortParam& rSortParam )
106 {
107 ScTabViewShell* pTabViewShell = pData->GetViewShell();
108 ScDBData* pDBData = pTabViewShell->GetDBData();
109 ScDocument* pDoc = pData->GetDocument();
110 SCTAB nTab = pData->GetTabNo();
111 ScDirection eFillDir = DIR_TOP;
112 sal_Bool bSort = sal_True;
113 ScRange aExternalRange;
114
115 if( rSortParam.nCol1 != rSortParam.nCol2 )
116 eFillDir = DIR_LEFT;
117 if( rSortParam.nRow1 != rSortParam.nRow2 )
118 eFillDir = DIR_TOP;
119
120 SCSIZE nCount = pDoc->GetEmptyLinesInBlock( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab, eFillDir );
121
122 if( rSortParam.nRow2 == MAXROW )
123 aExternalRange = ScRange( rSortParam.nCol1,sal::static_int_cast<SCROW>( nCount ), nTab );
124 else
125 aExternalRange = ScRange( pData->GetCurX(), pData->GetCurY(), nTab );
126
127 SCROW nStartRow = aExternalRange.aStart.Row();
128 SCCOL nStartCol = aExternalRange.aStart.Col();
129 SCROW nEndRow = aExternalRange.aEnd.Row();
130 SCCOL nEndCol = aExternalRange.aEnd.Col();
131 pDoc->GetDataArea( aExternalRange.aStart.Tab(), nStartCol, nStartRow, nEndCol, nEndRow, false, false );
132 aExternalRange.aStart.SetRow( nStartRow );
133 aExternalRange.aStart.SetCol( nStartCol );
134 aExternalRange.aEnd.SetRow( nEndRow );
135 aExternalRange.aEnd.SetCol( nEndCol );
136
137 if(( rSortParam.nCol1 == rSortParam.nCol2 && aExternalRange.aStart.Col() != aExternalRange.aEnd.Col() ) ||
138 ( rSortParam.nRow1 == rSortParam.nRow2 && aExternalRange.aStart.Row() != aExternalRange.aEnd.Row() ) )
139 {
140 sal_uInt16 nFmt = SCA_VALID;
141 String aExtendStr,aCurrentStr;
142
143 pTabViewShell->AddHighlightRange( aExternalRange,Color( COL_LIGHTBLUE ) );
144 ScRange rExtendRange( aExternalRange.aStart.Col(), aExternalRange.aStart.Row(), nTab, aExternalRange.aEnd.Col(), aExternalRange.aEnd.Row(), nTab );
145 rExtendRange.Format( aExtendStr, nFmt, pDoc );
146
147 ScRange rCurrentRange( rSortParam.nCol1, rSortParam.nRow1, nTab, rSortParam.nCol2, rSortParam.nRow2, nTab );
148 rCurrentRange.Format( aCurrentStr, nFmt, pDoc );
149
150 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
151 OSL_ENSURE(pFact, "ScAbstractFactory create fail!");
152
153 VclAbstractDialog* pWarningDlg = pFact->CreateScSortWarningDlg( pTabViewShell->GetDialogParent(),aExtendStr,aCurrentStr,RID_SCDLG_SORT_WARNING );
154 OSL_ENSURE(pWarningDlg, "Dialog create fail!");
155 short bResult = pWarningDlg->Execute();
156 if( bResult == BTN_EXTEND_RANGE || bResult == BTN_CURRENT_SELECTION )
157 {
158 if( bResult == BTN_EXTEND_RANGE )
159 {
160 pTabViewShell->MarkRange( aExternalRange, false );
161 pDBData->SetArea( nTab, aExternalRange.aStart.Col(), aExternalRange.aStart.Row(), aExternalRange.aEnd.Col(), aExternalRange.aEnd.Row() );
162 }
163 }
164 else
165 {
166 bSort = false;
167 pData->GetDocShell()->CancelAutoDBRange();
168 }
169
170 delete pWarningDlg;
171 pTabViewShell->ClearHighlightRanges();
172 }
173 return bSort;
174 }
175
176 //after end execute from !IsModalInputMode, it is safer to delay deleting
177 namespace
178 {
179 long DelayDeleteAbstractDialog( void *pAbstractDialog, void * /*pArg*/ )
180 {
181 delete reinterpret_cast<VclAbstractDialog*>( pAbstractDialog );
182 return 0;
183 }
184 }
185
186 void ScCellShell::ExecuteDB( SfxRequest& rReq )
187 {
188 ScTabViewShell* pTabViewShell = GetViewData()->GetViewShell();
189 sal_uInt16 nSlotId = rReq.GetSlot();
190 const SfxItemSet* pReqArgs = rReq.GetArgs();
191 ScModule* pScMod = SC_MOD();
192
193 pTabViewShell->HideListBox(); // Autofilter-DropDown-Listbox
194
195 if ( GetViewData()->HasEditView( GetViewData()->GetActivePart() ) )
196 {
197 pScMod->InputEnterHandler();
198 pTabViewShell->UpdateInputHandler();
199 }
200
201 switch ( nSlotId )
202 {
203 case SID_VIEW_DATA_SOURCE_BROWSER:
204 {
205 // check if database beamer is open
206
207 SfxViewFrame* pViewFrame = pTabViewShell->GetViewFrame();
208 sal_Bool bWasOpen = false;
209 {
210 uno::Reference<frame::XFrame> xFrame = pViewFrame->GetFrame().GetFrameInterface();
211 uno::Reference<frame::XFrame> xBeamerFrame = xFrame->findFrame(
212 rtl::OUString("_beamer"),
213 frame::FrameSearchFlag::CHILDREN);
214 if ( xBeamerFrame.is() )
215 bWasOpen = sal_True;
216 }
217
218 if ( bWasOpen )
219 {
220 // close database beamer: just forward to SfxViewFrame
221
222 pViewFrame->ExecuteSlot( rReq );
223 }
224 else
225 {
226 // show database beamer: SfxViewFrame call must be synchronous
227
228 pViewFrame->ExecuteSlot( rReq, (sal_Bool) false ); // sal_False = synchronous
229
230 // select current database in database beamer
231
232 ScImportParam aImportParam;
233 ScDBData* pDBData = pTabViewShell->GetDBData(sal_True,SC_DB_OLD); // don't create if none found
234 if (pDBData)
235 pDBData->GetImportParam( aImportParam );
236
237 ScDBDocFunc::ShowInBeamer( aImportParam, pTabViewShell->GetViewFrame() );
238 }
239 rReq.Done(); // needed because it's a toggle slot
240 }
241 break;
242
243 case SID_REIMPORT_DATA:
244 {
245 sal_Bool bOk = false;
246 ScDBData* pDBData = pTabViewShell->GetDBData(sal_True,SC_DB_OLD);
247 if (pDBData)
248 {
249 ScImportParam aImportParam;
250 pDBData->GetImportParam( aImportParam );
251 if (aImportParam.bImport && !pDBData->HasImportSelection())
252 {
253 pTabViewShell->ImportData( aImportParam );
254 pDBData->SetImportParam( aImportParam ); //! Undo ??
255 bOk = sal_True;
256 }
257 }
258
259 if (!bOk && ! rReq.IsAPI() )
260 pTabViewShell->ErrorMessage(STR_REIMPORT_EMPTY);
261
262 if( bOk )
263 rReq.Done();
264 }
265 break;
266
267 case SID_REFRESH_DBAREA:
268 {
269 ScDBData* pDBData = pTabViewShell->GetDBData(sal_True,SC_DB_OLD);
270 if (pDBData)
271 {
272 // repeat import like SID_REIMPORT_DATA
273
274 sal_Bool bContinue = sal_True;
275 ScImportParam aImportParam;
276 pDBData->GetImportParam( aImportParam );
277 if (aImportParam.bImport && !pDBData->HasImportSelection())
278 {
279 bContinue = pTabViewShell->ImportData( aImportParam );
280 pDBData->SetImportParam( aImportParam ); //! Undo ??
281
282 // mark (size may have been changed)
283 ScRange aNewRange;
284 pDBData->GetArea(aNewRange);
285 pTabViewShell->MarkRange(aNewRange);
286 }
287
288 if ( bContinue ) // fail at import -> break
289 {
290 // internal operations, when any stored
291
292 if ( pDBData->HasQueryParam() || pDBData->HasSortParam() ||
293 pDBData->HasSubTotalParam() )
294 pTabViewShell->RepeatDB();
295
296 // pivot tables that have the range as data source
297
298 ScRange aRange;
299 pDBData->GetArea(aRange);
300 GetViewData()->GetDocShell()->RefreshPivotTables(aRange);
301 }
302 }
303 rReq.Done();
304 }
305 break;
306
307 case SID_SBA_BRW_INSERT:
308 {
309 OSL_FAIL( "Deprecated Slot" );
310 }
311 break;
312
313 case SID_DATA_FORM:
314 {
315 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
316 OSL_ENSURE(pFact, "ScAbstractFactory create fail!");
317
318 AbstractScDataFormDlg* pDlg = pFact->CreateScDataFormDlg( pTabViewShell->GetDialogParent(),RID_SCDLG_DATAFORM, pTabViewShell);
319 OSL_ENSURE(pDlg, "Dialog create fail!");
320
321 pDlg->Execute();
322
323 rReq.Done();
324 }
325 break;
326
327 case SID_SUBTOTALS:
328 ExecuteSubtotals(rReq);
329 break;
330
331 case SID_SORT_DESCENDING:
332 case SID_SORT_ASCENDING:
333 {
334 //#i60401 ux-ctest: Calc does not support all users' strategies regarding sorting data
335 //the patch comes from maoyg
336 ScSortParam aSortParam;
337 ScDBData* pDBData = pTabViewShell->GetDBData();
338 ScViewData* pData = GetViewData();
339
340 pDBData->GetSortParam( aSortParam );
341
342 if( lcl_GetSortParam( pData, aSortParam ) )
343 {
344 SfxItemSet aArgSet( GetPool(), SCITEM_SORTDATA, SCITEM_SORTDATA );
345 SCCOL nCol = GetViewData()->GetCurX();
346 SCCOL nTab = GetViewData()->GetTabNo();
347 ScDocument* pDoc = GetViewData()->GetDocument();
348
349 pDBData->GetSortParam( aSortParam );
350 sal_Bool bHasHeader = pDoc->HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, nTab );
351
352 if( nCol < aSortParam.nCol1 )
353 nCol = aSortParam.nCol1;
354 else if( nCol > aSortParam.nCol2 )
355 nCol = aSortParam.nCol2;
356
357 aSortParam.bHasHeader = bHasHeader;
358 aSortParam.bByRow = true;
359 aSortParam.bCaseSens = false;
360 aSortParam.bNaturalSort = false;
361 aSortParam.bIncludePattern = true;
362 aSortParam.bInplace = true;
363 aSortParam.maKeyState[0].bDoSort = true;
364 aSortParam.maKeyState[0].nField = nCol;
365 aSortParam.maKeyState[0].bAscending = ( nSlotId == SID_SORT_ASCENDING );
366
367 for ( sal_uInt16 i=1; i<aSortParam.GetSortKeyCount(); i++ )
368 aSortParam.maKeyState[i].bDoSort = false;
369
370 aArgSet.Put( ScSortItem( SCITEM_SORTDATA, GetViewData(), &aSortParam ) );
371
372 pTabViewShell->UISort( aSortParam ); // subtotal when needed new
373
374 rReq.Done();
375 }
376 }
377 break;
378
379 case SID_SORT:
380 {
381 const SfxItemSet* pArgs = rReq.GetArgs();
382
383 //#i60401 ux-ctest: Calc does not support all users' strategies regarding sorting data
384 //the patch comes from maoyg
385
386 if ( pArgs ) // Basic
387 {
388 ScSortParam aSortParam;
389 ScDBData* pDBData = pTabViewShell->GetDBData();
390 ScViewData* pData = GetViewData();
391
392 pDBData->GetSortParam( aSortParam );
393
394 if( lcl_GetSortParam( pData, aSortParam ) )
395 {
396 ScDocument* pDoc = GetViewData()->GetDocument();
397
398 pDBData->GetSortParam( aSortParam );
399 sal_Bool bHasHeader = pDoc->HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, pData->GetTabNo() );
400 if( bHasHeader )
401 aSortParam.bHasHeader = bHasHeader;
402
403 aSortParam.bInplace = sal_True; // from Basic always
404
405 const SfxPoolItem* pItem;
406 if ( pArgs->GetItemState( SID_SORT_BYROW, sal_True, &pItem ) == SFX_ITEM_SET )
407 aSortParam.bByRow = static_cast<const SfxBoolItem*>(pItem)->GetValue();
408 if ( pArgs->GetItemState( SID_SORT_HASHEADER, sal_True, &pItem ) == SFX_ITEM_SET )
409 aSortParam.bHasHeader = static_cast<const SfxBoolItem*>(pItem)->GetValue();
410 if ( pArgs->GetItemState( SID_SORT_CASESENS, sal_True, &pItem ) == SFX_ITEM_SET )
411 aSortParam.bCaseSens = static_cast<const SfxBoolItem*>(pItem)->GetValue();
412 if ( pArgs->GetItemState( SID_SORT_NATURALSORT, true, &pItem ) == SFX_ITEM_SET )
413 aSortParam.bNaturalSort = static_cast<const SfxBoolItem*>(pItem)->GetValue();
414 if ( pArgs->GetItemState( SID_SORT_ATTRIBS, true, &pItem ) == SFX_ITEM_SET )
415 aSortParam.bIncludePattern = static_cast<const SfxBoolItem*>(pItem)->GetValue();
416 if ( pArgs->GetItemState( SID_SORT_USERDEF, sal_True, &pItem ) == SFX_ITEM_SET )
417 {
418 sal_uInt16 nUserIndex = static_cast<const SfxUInt16Item*>(pItem)->GetValue();
419 aSortParam.bUserDef = ( nUserIndex != 0 );
420 if ( nUserIndex )
421 aSortParam.nUserIndex = nUserIndex - 1; // Basic: 1-based
422 }
423
424 SCCOLROW nField0 = 0;
425 if ( pArgs->GetItemState( FN_PARAM_1, sal_True, &pItem ) == SFX_ITEM_SET )
426 nField0 = static_cast<const SfxInt32Item*>(pItem)->GetValue();
427 aSortParam.maKeyState[0].bDoSort = ( nField0 != 0 );
428 aSortParam.maKeyState[0].nField = nField0 > 0 ? (nField0-1) : 0;
429 if ( pArgs->GetItemState( FN_PARAM_2, sal_True, &pItem ) == SFX_ITEM_SET )
430 aSortParam.maKeyState[0].bAscending = static_cast<const SfxBoolItem*>(pItem)->GetValue();
431 SCCOLROW nField1 = 0;
432 if ( pArgs->GetItemState( FN_PARAM_3, sal_True, &pItem ) == SFX_ITEM_SET )
433 nField1 = static_cast<const SfxInt32Item*>(pItem)->GetValue();
434 aSortParam.maKeyState[1].bDoSort = ( nField1 != 0 );
435 aSortParam.maKeyState[1].nField = nField1 > 0 ? (nField1-1) : 0;
436 if ( pArgs->GetItemState( FN_PARAM_4, sal_True, &pItem ) == SFX_ITEM_SET )
437 aSortParam.maKeyState[1].bAscending = static_cast<const SfxBoolItem*>(pItem)->GetValue();
438 SCCOLROW nField2 = 0;
439 if ( pArgs->GetItemState( FN_PARAM_5, sal_True, &pItem ) == SFX_ITEM_SET )
440 nField2 = static_cast<const SfxInt32Item*>(pItem)->GetValue();
441 aSortParam.maKeyState[2].bDoSort = ( nField2 != 0 );
442 aSortParam.maKeyState[2].nField = nField2 > 0 ? (nField2-1) : 0;
443 if ( pArgs->GetItemState( FN_PARAM_6, sal_True, &pItem ) == SFX_ITEM_SET )
444 aSortParam.maKeyState[2].bAscending = static_cast<const SfxBoolItem*>(pItem)->GetValue();
445
446 // subtotal when needed new
447 pTabViewShell->UISort( aSortParam );
448 rReq.Done();
449 }
450 }
451 else
452 {
453 ScSortParam aSortParam;
454 ScDBData* pDBData = pTabViewShell->GetDBData();
455 ScViewData* pData = GetViewData();
456
457 pDBData->GetSortParam( aSortParam );
458
459 if( lcl_GetSortParam( pData, aSortParam ) )
460 {
461 SfxAbstractTabDialog* pDlg = NULL;
462 ScDocument* pDoc = GetViewData()->GetDocument();
463 SfxItemSet aArgSet( GetPool(), SCITEM_SORTDATA, SCITEM_SORTDATA );
464
465 pDBData->GetSortParam( aSortParam );
466 sal_Bool bHasHeader = pDoc->HasColHeader( aSortParam.nCol1, aSortParam.nRow1, aSortParam.nCol2, aSortParam.nRow2, pData->GetTabNo() );
467 if( bHasHeader )
468 aSortParam.bHasHeader = bHasHeader;
469
470 aArgSet.Put( ScSortItem( SCITEM_SORTDATA, GetViewData(), &aSortParam ) );
471
472 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
473 OSL_ENSURE(pFact, "ScAbstractFactory create fail!");
474
475 pDlg = pFact->CreateScSortDlg( pTabViewShell->GetDialogParent(), &aArgSet, RID_SCDLG_SORT );
476 OSL_ENSURE(pDlg, "Dialog create fail!");
477 pDlg->SetCurPageId(1); // 1=sort field tab 2=sort options tab
478
479 if ( pDlg->Execute() == RET_OK )
480 {
481 const SfxItemSet* pOutSet = pDlg->GetOutputItemSet();
482 const ScSortParam& rOutParam = ((const ScSortItem&)
483 pOutSet->Get( SCITEM_SORTDATA )).GetSortData();
484
485 // subtotal when needed new
486
487 pTabViewShell->UISort( rOutParam );
488
489 if ( rOutParam.bInplace )
490 {
491 rReq.AppendItem( SfxBoolItem( SID_SORT_BYROW,
492 rOutParam.bByRow ) );
493 rReq.AppendItem( SfxBoolItem( SID_SORT_HASHEADER,
494 rOutParam.bHasHeader ) );
495 rReq.AppendItem( SfxBoolItem( SID_SORT_CASESENS,
496 rOutParam.bCaseSens ) );
497 rReq.AppendItem( SfxBoolItem( SID_SORT_NATURALSORT,
498 rOutParam.bNaturalSort ) );
499 rReq.AppendItem( SfxBoolItem( SID_SORT_ATTRIBS,
500 rOutParam.bIncludePattern ) );
501 sal_uInt16 nUser = rOutParam.bUserDef ? ( rOutParam.nUserIndex + 1 ) : 0;
502 rReq.AppendItem( SfxUInt16Item( SID_SORT_USERDEF, nUser ) );
503 if ( rOutParam.maKeyState[0].bDoSort )
504 {
505 rReq.AppendItem( SfxInt32Item( FN_PARAM_1,
506 rOutParam.maKeyState[0].nField + 1 ) );
507 rReq.AppendItem( SfxBoolItem( FN_PARAM_2,
508 rOutParam.maKeyState[0].bAscending ) );
509 }
510 if ( rOutParam.maKeyState[1].bDoSort )
511 {
512 rReq.AppendItem( SfxInt32Item( FN_PARAM_3,
513 rOutParam.maKeyState[1].nField + 1 ) );
514 rReq.AppendItem( SfxBoolItem( FN_PARAM_4,
515 rOutParam.maKeyState[1].bAscending ) );
516 }
517 if ( rOutParam.maKeyState[2].bDoSort )
518 {
519 rReq.AppendItem( SfxInt32Item( FN_PARAM_5,
520 rOutParam.maKeyState[2].nField + 1 ) );
521 rReq.AppendItem( SfxBoolItem( FN_PARAM_6,
522 rOutParam.maKeyState[2].bAscending ) );
523 }
524 }
525
526 rReq.Done();
527 }
528 else
529 GetViewData()->GetDocShell()->CancelAutoDBRange();
530
531 delete pDlg;
532 }
533 }
534 }
535 break;
536
537 case SID_FILTER:
538 {
539 const SfxItemSet* pArgs = rReq.GetArgs();
540 if ( pArgs )
541 {
542 OSL_FAIL("SID_FILTER with arguments?");
543 pTabViewShell->Query( ((const ScQueryItem&)
544 pArgs->Get( SCITEM_QUERYDATA )).GetQueryData(), NULL, sal_True );
545 rReq.Done();
546 }
547 else
548 {
549 sal_uInt16 nId = ScFilterDlgWrapper::GetChildWindowId();
550 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
551 SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
552
553 pScMod->SetRefDialog( nId, pWnd ? false : sal_True );
554 }
555 }
556 break;
557
558 case SID_SPECIAL_FILTER:
559 {
560 const SfxItemSet* pArgs = rReq.GetArgs();
561 if ( pArgs )
562 {
563 OSL_FAIL("SID_SPECIAL_FILTER with arguments?");
564 pTabViewShell->Query( ((const ScQueryItem&)
565 pArgs->Get( SCITEM_QUERYDATA )).GetQueryData(), NULL, sal_True );
566 rReq.Done();
567 }
568 else
569 {
570 sal_uInt16 nId = ScSpecialFilterDlgWrapper::GetChildWindowId();
571 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
572 SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
573
574 pScMod->SetRefDialog( nId, pWnd ? false : sal_True );
575 }
576 }
577 break;
578
579 case FID_FILTER_OK:
580 {
581 const SfxPoolItem* pItem;
582 if ( pReqArgs && SFX_ITEM_SET ==
583 pReqArgs->GetItemState( SCITEM_QUERYDATA, sal_True, &pItem ) )
584 {
585 const ScQueryItem& rQueryItem = static_cast<const ScQueryItem&>(*pItem);
586
587 SCTAB nCurTab = GetViewData()->GetTabNo();
588 SCTAB nRefTab = GetViewData()->GetRefTabNo();
589
590 // If RefInput switched to a different sheet from the data sheet,
591 // switch back:
592
593 if ( nCurTab != nRefTab )
594 {
595 pTabViewShell->SetTabNo( nRefTab );
596 pTabViewShell->PaintExtras();
597 }
598
599 ScRange aAdvSource;
600 if (rQueryItem.GetAdvancedQuerySource(aAdvSource))
601 pTabViewShell->Query( rQueryItem.GetQueryData(), &aAdvSource, sal_True );
602 else
603 pTabViewShell->Query( rQueryItem.GetQueryData(), NULL, sal_True );
604 rReq.Done( *pReqArgs );
605 }
606 }
607 break;
608
609 case SID_UNFILTER:
610 {
611 ScQueryParam aParam;
612 ScDBData* pDBData = pTabViewShell->GetDBData();
613
614 pDBData->GetQueryParam( aParam );
615 SCSIZE nEC = aParam.GetEntryCount();
616 for (SCSIZE i=0; i<nEC; i++)
617 aParam.GetEntry(i).bDoQuery = false;
618 aParam.bDuplicate = sal_True;
619 pTabViewShell->Query( aParam, NULL, sal_True );
620 rReq.Done();
621 }
622 break;
623
624 case SID_AUTO_FILTER:
625 pTabViewShell->ToggleAutoFilter();
626 rReq.Done();
627 break;
628
629 case SID_AUTOFILTER_HIDE:
630 pTabViewShell->HideAutoFilter();
631 rReq.Done();
632 break;
633
634 case SID_PIVOT_TABLE:
635 {
636 const SfxPoolItem* pItem;
637 if ( pReqArgs && SFX_ITEM_SET ==
638 pReqArgs->GetItemState( SCITEM_PIVOTDATA, sal_True, &pItem ) )
639 {
640 SCTAB nCurTab = GetViewData()->GetTabNo();
641 SCTAB nRefTab = GetViewData()->GetRefTabNo();
642
643 // If RefInput switched to a different sheet from the data sheet,
644 // switch back:
645
646 if ( nCurTab != nRefTab )
647 {
648 pTabViewShell->SetTabNo( nRefTab );
649 pTabViewShell->PaintExtras();
650 }
651
652 const ScDPObject* pDPObject = pTabViewShell->GetDialogDPObject();
653 if ( pDPObject )
654 {
655 const ScPivotItem* pPItem = (const ScPivotItem*)pItem;
656 bool bSuccess = pTabViewShell->MakePivotTable(
657 pPItem->GetData(), pPItem->GetDestRange(), pPItem->IsNewSheet(), *pDPObject );
658 SfxBoolItem aRet(0, bSuccess);
659 rReq.SetReturnValue(aRet);
660 }
661 rReq.Done();
662 }
663 #ifndef DISABLE_SCRIPTING
664 else if (rReq.IsAPI())
665 SbxBase::SetError(SbxERR_BAD_PARAMETER);
666 #endif
667 }
668 break;
669
670 case SID_OPENDLG_PIVOTTABLE:
671 ExecuteDataPilotDialog();
672 break;
673 case SID_DEFINE_DBNAME:
674 {
675
676 sal_uInt16 nId = ScDbNameDlgWrapper::GetChildWindowId();
677 SfxViewFrame* pViewFrm = pTabViewShell->GetViewFrame();
678 SfxChildWindow* pWnd = pViewFrm->GetChildWindow( nId );
679
680 pScMod->SetRefDialog( nId, pWnd ? false : sal_True );
681
682 }
683 break;
684
685 case SID_SELECT_DB:
686 {
687 if ( pReqArgs )
688 {
689 const SfxStringItem* pItem =
690 (const SfxStringItem*)&pReqArgs->Get( SID_SELECT_DB );
691
692 if( pItem )
693 {
694 pTabViewShell->GotoDBArea( pItem->GetValue() );
695 rReq.Done();
696 }
697 else
698 {
699 OSL_FAIL("NULL");
700 }
701 }
702 else
703 {
704 ScDocument* pDoc = GetViewData()->GetDocument();
705 ScDBCollection* pDBCol = pDoc->GetDBCollection();
706
707 if ( pDBCol )
708 {
709 std::vector<String> aList;
710 const ScDBCollection::NamedDBs& rDBs = pDBCol->getNamedDBs();
711 ScDBCollection::NamedDBs::const_iterator itr = rDBs.begin(), itrEnd = rDBs.end();
712 for (; itr != itrEnd; ++itr)
713 aList.push_back(itr->GetName());
714
715 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
716 OSL_ENSURE(pFact, "ScAbstractFactory create fail!");
717
718 AbstractScSelEntryDlg* pDlg = pFact->CreateScSelEntryDlg( pTabViewShell->GetDialogParent(),
719 RID_SCDLG_SELECTDB,
720 String(ScResId(SCSTR_SELECTDB)),
721 String(ScResId(SCSTR_AREAS)),
722 aList,
723 RID_SCDLG_SELECTDB);
724 OSL_ENSURE(pDlg, "Dialog create fail!");
725 if ( pDlg->Execute() == RET_OK )
726 {
727 String aName = pDlg->GetSelectEntry();
728 pTabViewShell->GotoDBArea( aName );
729 rReq.AppendItem( SfxStringItem( SID_SELECT_DB, aName ) );
730 rReq.Done();
731 }
732
733 delete pDlg;
734 }
735 }
736 }
737 break;
738
739 case SID_MANAGE_XML_SOURCE:
740 ExecuteXMLSourceDialog();
741 break;
742 case FID_VALIDATION:
743 {
744 const SfxPoolItem* pItem;
745 const SfxItemSet* pArgs = rReq.GetArgs();
746 if ( pArgs )
747 {
748 OSL_FAIL("later...");
749 }
750 else
751 {
752 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
753 OSL_ENSURE(pFact, "ScAbstractFactory create fail!");
754 ::GetTabPageRanges ScTPValidationValueGetRanges = pFact->GetTabPageRangesFunc(TP_VALIDATION_VALUES);
755 OSL_ENSURE(ScTPValidationValueGetRanges, "TabPage create fail!");
756 SfxItemSet aArgSet( GetPool(), (*ScTPValidationValueGetRanges)() );
757 ScValidationMode eMode = SC_VALID_ANY;
758 ScConditionMode eOper = SC_COND_EQUAL;
759 String aExpr1, aExpr2;
760 sal_Bool bBlank = sal_True;
761 sal_Int16 nListType = ValidListType::UNSORTED;
762 sal_Bool bShowHelp = false;
763 String aHelpTitle, aHelpText;
764 sal_Bool bShowError = false;
765 ScValidErrorStyle eErrStyle = SC_VALERR_STOP;
766 String aErrTitle, aErrText;
767
768 ScDocument* pDoc = GetViewData()->GetDocument();
769 SCCOL nCurX = GetViewData()->GetCurX();
770 SCROW nCurY = GetViewData()->GetCurY();
771 SCTAB nTab = GetViewData()->GetTabNo();
772 ScAddress aCursorPos( nCurX, nCurY, nTab );
773 sal_uLong nIndex = ((SfxUInt32Item*)pDoc->GetAttr(
774 nCurX, nCurY, nTab, ATTR_VALIDDATA ))->GetValue();
775 if ( nIndex )
776 {
777 const ScValidationData* pOldData = pDoc->GetValidationEntry( nIndex );
778 if ( pOldData )
779 {
780 eMode = pOldData->GetDataMode();
781 eOper = pOldData->GetOperation();
782 sal_uLong nNumFmt = 0;
783 if ( eMode == SC_VALID_DATE || eMode == SC_VALID_TIME )
784 {
785 short nType = ( eMode == SC_VALID_DATE ) ? NUMBERFORMAT_DATE
786 : NUMBERFORMAT_TIME;
787 nNumFmt = pDoc->GetFormatTable()->GetStandardFormat(
788 nType, ScGlobal::eLnge );
789 }
790 aExpr1 = pOldData->GetExpression( aCursorPos, 0, nNumFmt );
791 aExpr2 = pOldData->GetExpression( aCursorPos, 1, nNumFmt );
792 bBlank = pOldData->IsIgnoreBlank();
793 nListType = pOldData->GetListType();
794
795 bShowHelp = pOldData->GetInput( aHelpTitle, aHelpText );
796 bShowError = pOldData->GetErrMsg( aErrTitle, aErrText, eErrStyle );
797
798 aArgSet.Put( SfxAllEnumItem( FID_VALID_MODE, sal::static_int_cast<sal_uInt16>(eMode) ) );
799 aArgSet.Put( SfxAllEnumItem( FID_VALID_CONDMODE, sal::static_int_cast<sal_uInt16>(eOper) ) );
800 aArgSet.Put( SfxStringItem( FID_VALID_VALUE1, aExpr1 ) );
801 aArgSet.Put( SfxStringItem( FID_VALID_VALUE2, aExpr2 ) );
802 aArgSet.Put( SfxBoolItem( FID_VALID_BLANK, bBlank ) );
803 aArgSet.Put( SfxInt16Item( FID_VALID_LISTTYPE, nListType ) );
804 aArgSet.Put( SfxBoolItem( FID_VALID_SHOWHELP, bShowHelp ) );
805 aArgSet.Put( SfxStringItem( FID_VALID_HELPTITLE, aHelpTitle ) );
806 aArgSet.Put( SfxStringItem( FID_VALID_HELPTEXT, aHelpText ) );
807 aArgSet.Put( SfxBoolItem( FID_VALID_SHOWERR, bShowError ) );
808 aArgSet.Put( SfxAllEnumItem( FID_VALID_ERRSTYLE, sal::static_int_cast<sal_uInt16>(eErrStyle) ) );
809 aArgSet.Put( SfxStringItem( FID_VALID_ERRTITLE, aErrTitle ) );
810 aArgSet.Put( SfxStringItem( FID_VALID_ERRTEXT, aErrText ) );
811 }
812 }
813
814 // cell range picker
815 SfxAbstractTabDialog* pDlg = pFact->CreateScValidationDlg( NULL, &aArgSet, TAB_DLG_VALIDATION, pTabViewShell );
816 OSL_ENSURE(pDlg, "Dialog create fail!");
817
818 short nResult = pDlg->Execute();
819 //When picking Cell Range, other Tab may be switched. Need restore the correct tab
820 pTabViewShell->SetTabNo( nTab );
821 if ( nResult == RET_OK )
822 {
823 const SfxItemSet* pOutSet = pDlg->GetOutputItemSet();
824
825 if ( pOutSet->GetItemState( FID_VALID_MODE, sal_True, &pItem ) == SFX_ITEM_SET )
826 eMode = (ScValidationMode) ((const SfxAllEnumItem*)pItem)->GetValue();
827 if ( pOutSet->GetItemState( FID_VALID_CONDMODE, sal_True, &pItem ) == SFX_ITEM_SET )
828 eOper = (ScConditionMode) ((const SfxAllEnumItem*)pItem)->GetValue();
829 if ( pOutSet->GetItemState( FID_VALID_VALUE1, sal_True, &pItem ) == SFX_ITEM_SET )
830 {
831 String aTemp1 = ((const SfxStringItem*)pItem)->GetValue();
832 if (eMode == SC_VALID_DATE || eMode == SC_VALID_TIME)
833 {
834 sal_uInt32 nNumIndex = 0;
835 double nVal;
836 if (pDoc->GetFormatTable()->IsNumberFormat(aTemp1, nNumIndex, nVal))
837 aExpr1 =String( ::rtl::math::doubleToUString( nVal,
838 rtl_math_StringFormat_Automatic, rtl_math_DecimalPlaces_Max,
839 ScGlobal::pLocaleData->getNumDecimalSep()[0], sal_True));
840 else
841 aExpr1 = aTemp1;
842 }
843 else
844 aExpr1 = aTemp1;
845 }
846 if ( pOutSet->GetItemState( FID_VALID_VALUE2, sal_True, &pItem ) == SFX_ITEM_SET )
847 {
848 String aTemp2 = ((const SfxStringItem*)pItem)->GetValue();
849 if (eMode == SC_VALID_DATE || eMode == SC_VALID_TIME)
850 {
851 sal_uInt32 nNumIndex = 0;
852 double nVal;
853 if (pDoc->GetFormatTable()->IsNumberFormat(aTemp2, nNumIndex, nVal))
854 aExpr2 =String( ::rtl::math::doubleToUString( nVal,
855 rtl_math_StringFormat_Automatic, rtl_math_DecimalPlaces_Max,
856 ScGlobal::pLocaleData->getNumDecimalSep()[0], sal_True));
857 else
858 aExpr2 = aTemp2;
859 }
860 else
861 aExpr2 = aTemp2;
862 }
863
864 if ( pOutSet->GetItemState( FID_VALID_BLANK, sal_True, &pItem ) == SFX_ITEM_SET )
865 bBlank = ((const SfxBoolItem*)pItem)->GetValue();
866 if ( pOutSet->GetItemState( FID_VALID_LISTTYPE, sal_True, &pItem ) == SFX_ITEM_SET )
867 nListType = ((const SfxInt16Item*)pItem)->GetValue();
868
869 if ( pOutSet->GetItemState( FID_VALID_SHOWHELP, sal_True, &pItem ) == SFX_ITEM_SET )
870 bShowHelp = ((const SfxBoolItem*)pItem)->GetValue();
871 if ( pOutSet->GetItemState( FID_VALID_HELPTITLE, sal_True, &pItem ) == SFX_ITEM_SET )
872 aHelpTitle = ((const SfxStringItem*)pItem)->GetValue();
873 if ( pOutSet->GetItemState( FID_VALID_HELPTEXT, sal_True, &pItem ) == SFX_ITEM_SET )
874 aHelpText = ((const SfxStringItem*)pItem)->GetValue();
875
876 if ( pOutSet->GetItemState( FID_VALID_SHOWERR, sal_True, &pItem ) == SFX_ITEM_SET )
877 bShowError = ((const SfxBoolItem*)pItem)->GetValue();
878 if ( pOutSet->GetItemState( FID_VALID_ERRSTYLE, sal_True, &pItem ) == SFX_ITEM_SET )
879 eErrStyle = (ScValidErrorStyle) ((const SfxAllEnumItem*)pItem)->GetValue();
880 if ( pOutSet->GetItemState( FID_VALID_ERRTITLE, sal_True, &pItem ) == SFX_ITEM_SET )
881 aErrTitle = ((const SfxStringItem*)pItem)->GetValue();
882 if ( pOutSet->GetItemState( FID_VALID_ERRTEXT, sal_True, &pItem ) == SFX_ITEM_SET )
883 aErrText = ((const SfxStringItem*)pItem)->GetValue();
884
885 ScValidationData aData( eMode, eOper, aExpr1, aExpr2, pDoc, aCursorPos );
886 aData.SetIgnoreBlank( bBlank );
887 aData.SetListType( nListType );
888
889 aData.SetInput(aHelpTitle, aHelpText); // sets bShowInput to TRUE
890 if (!bShowHelp)
891 aData.ResetInput(); // reset only bShowInput
892
893 aData.SetError(aErrTitle, aErrText, eErrStyle); // sets bShowError to TRUE
894 if (!bShowError)
895 aData.ResetError(); // reset only bShowError
896
897 pTabViewShell->SetValidation( aData );
898 pTabViewShell->TestHintWindow();
899 rReq.Done( *pOutSet );
900 }
901 //after end execute from !IsModalInputMode, it is safer to delay deleting
902 //delete pDlg;
903 Application::PostUserEvent( Link( pDlg, &DelayDeleteAbstractDialog ) );
904 }
905 }
906 break;
907
908 case SID_TEXT_TO_COLUMNS:
909 {
910 ScViewData* pData = GetViewData();
911 OSL_ENSURE( pData, "ScCellShell::ExecuteDB: SID_TEXT_TO_COLUMNS - pData is null!" );
912 ScRange aRange;
913
914 if ( lcl_GetTextToColumnsRange( pData, aRange ) )
915 {
916 ScDocument* pDoc = pData->GetDocument();
917 OSL_ENSURE( pDoc, "ScCellShell::ExecuteDB: SID_TEXT_TO_COLUMNS - pDoc is null!" );
918
919 ScImportExport aExport( pDoc, aRange );
920 aExport.SetExportTextOptions( ScExportTextOptions( ScExportTextOptions::None, 0, false ) );
921
922 // #i87703# text to columns fails with tab separator
923 aExport.SetDelimiter( static_cast< sal_Unicode >( 0 ) );
924
925 SvMemoryStream aStream;
926 aStream.SetStreamCharSet( RTL_TEXTENCODING_UNICODE );
927 ScImportExport::SetNoEndianSwap( aStream );
928 aExport.ExportStream( aStream, String(), FORMAT_STRING );
929
930 ScAbstractDialogFactory* pFact = ScAbstractDialogFactory::Create();
931 OSL_ENSURE( pFact, "ScCellShell::ExecuteDB: SID_TEXT_TO_COLUMNS - pFact is null!" );
932 AbstractScImportAsciiDlg *pDlg = pFact->CreateScImportAsciiDlg(
933 NULL, String(), &aStream, RID_SCDLG_ASCII,SC_TEXTTOCOLUMNS);
934 OSL_ENSURE( pDlg, "ScCellShell::ExecuteDB: SID_TEXT_TO_COLUMNS - pDlg is null!" );
935
936 if ( pDlg->Execute() == RET_OK )
937 {
938 ScDocShell* pDocSh = pData->GetDocShell();
939 OSL_ENSURE( pDocSh, "ScCellShell::ExecuteDB: SID_TEXT_TO_COLUMNS - pDocSh is null!" );
940
941 String aUndo = ScGlobal::GetRscString( STR_UNDO_TEXTTOCOLUMNS );
942 pDocSh->GetUndoManager()->EnterListAction( aUndo, aUndo );
943
944 ScImportExport aImport( pDoc, aRange.aStart );
945 ScAsciiOptions aOptions;
946 pDlg->GetOptions( aOptions );
947 pDlg->SaveParameters();
948 aImport.SetExtOptions( aOptions );
949 aImport.SetApi( false );
950 aStream.Seek( 0 );
951 aImport.ImportStream( aStream, String(), FORMAT_STRING );
952
953 pDocSh->GetUndoManager()->LeaveListAction();
954 }
955 delete pDlg;
956 }
957 }
958 break;
959 }
960 }
961
962 void ScCellShell::GetDBState( SfxItemSet& rSet )
963 {
964 ScTabViewShell* pTabViewShell = GetViewData()->GetViewShell();
965 ScViewData* pData = GetViewData();
966 ScDocShell* pDocSh = pData->GetDocShell();
967 ScDocument* pDoc = pDocSh->GetDocument();
968 SCCOL nPosX = pData->GetCurX();
969 SCROW nPosY = pData->GetCurY();
970 SCTAB nTab = pData->GetTabNo();
971
972 sal_Bool bAutoFilter = false;
973 sal_Bool bAutoFilterTested = false;
974
975 SfxWhichIter aIter(rSet);
976 sal_uInt16 nWhich = aIter.FirstWhich();
977 while (nWhich)
978 {
979 switch (nWhich)
980 {
981 case SID_REFRESH_DBAREA:
982 {
983 // imported data without selection
984 // or filter,sort,subtotal (also without import)
985 sal_Bool bOk = false;
986 ScDBData* pDBData = pTabViewShell->GetDBData(false,SC_DB_OLD);
987 if (pDBData && pDoc->GetChangeTrack() == NULL)
988 {
989 if ( pDBData->HasImportParam() )
990 bOk = !pDBData->HasImportSelection();
991 else
992 {
993 bOk = pDBData->HasQueryParam() ||
994 pDBData->HasSortParam() ||
995 pDBData->HasSubTotalParam();
996 }
997 }
998 if (!bOk)
999 rSet.DisableItem( nWhich );
1000 }
1001 break;
1002
1003 case SID_FILTER:
1004 case SID_SPECIAL_FILTER:
1005 {
1006 ScRange aDummy;
1007 ScMarkType eMarkType = GetViewData()->GetSimpleArea( aDummy);
1008 if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED)
1009 {
1010 rSet.DisableItem( nWhich );
1011 }
1012 }
1013 break;
1014
1015
1016 //in case of Redlining and multiselection disable
1017 case SID_SORT_ASCENDING:
1018 case SID_SORT_DESCENDING:
1019 case SCITEM_SORTDATA:
1020 case SCITEM_SUBTDATA:
1021 case SID_OPENDLG_PIVOTTABLE:
1022 {
1023 //! move ReadOnly check to idl flags
1024
1025 if ( pDocSh->IsReadOnly() || pDoc->GetChangeTrack()!=NULL ||
1026 GetViewData()->IsMultiMarked() )
1027 {
1028 rSet.DisableItem( nWhich );
1029 }
1030 }
1031 break;
1032
1033 case SID_REIMPORT_DATA:
1034 {
1035 // only imported data without selection
1036 ScDBData* pDBData = pTabViewShell->GetDBData(false,SC_DB_OLD);
1037 if (!pDBData || !pDBData->HasImportParam() || pDBData->HasImportSelection() ||
1038 pDoc->GetChangeTrack()!=NULL)
1039 {
1040 rSet.DisableItem( nWhich );
1041 }
1042 }
1043 break;
1044
1045 case SID_VIEW_DATA_SOURCE_BROWSER:
1046 {
1047 if (!SvtModuleOptions().IsModuleInstalled(SvtModuleOptions::E_SDATABASE))
1048 rSet.Put(SfxVisibilityItem(nWhich, false));
1049 else
1050 // get state (BoolItem) from SfxViewFrame
1051 pTabViewShell->GetViewFrame()->GetSlotState( nWhich, NULL, &rSet );
1052 }
1053 break;
1054 case SID_SBA_BRW_INSERT:
1055 {
1056 // SBA wants a sal_Bool-item, enabled
1057
1058 sal_Bool bEnable = sal_True;
1059 rSet.Put(SfxBoolItem(nWhich, bEnable));
1060 }
1061 break;
1062
1063 case SID_AUTO_FILTER:
1064 case SID_AUTOFILTER_HIDE:
1065 {
1066 if (!bAutoFilterTested)
1067 {
1068 bAutoFilter = pDoc->HasAutoFilter( nPosX, nPosY, nTab );
1069 bAutoFilterTested = sal_True;
1070 }
1071 if ( nWhich == SID_AUTO_FILTER )
1072 {
1073 ScRange aDummy;
1074 ScMarkType eMarkType = GetViewData()->GetSimpleArea( aDummy);
1075 if (eMarkType != SC_MARK_SIMPLE && eMarkType != SC_MARK_SIMPLE_FILTERED)
1076 {
1077 rSet.DisableItem( nWhich );
1078 }
1079 else if (pDoc->GetDPAtBlock(aDummy))
1080 {
1081 rSet.DisableItem( nWhich );
1082 }
1083 else
1084 rSet.Put( SfxBoolItem( nWhich, bAutoFilter ) );
1085 }
1086 else
1087 if (!bAutoFilter)
1088 rSet.DisableItem( nWhich );
1089 }
1090 break;
1091
1092 case SID_UNFILTER:
1093 {
1094 SCCOL nStartCol, nEndCol;
1095 SCROW nStartRow, nEndRow;
1096 SCTAB nStartTab, nEndTab;
1097 sal_Bool bAnyQuery = false;
1098
1099 sal_Bool bSelected = (GetViewData()->GetSimpleArea(
1100 nStartCol, nStartRow, nStartTab, nEndCol, nEndRow, nEndTab )
1101 == SC_MARK_SIMPLE);
1102
1103 if ( bSelected )
1104 {
1105 if (nStartCol==nEndCol && nStartRow==nEndRow)
1106 bSelected = false;
1107 }
1108 else
1109 {
1110 nStartCol = GetViewData()->GetCurX();
1111 nStartRow = GetViewData()->GetCurY();
1112 nStartTab = GetViewData()->GetTabNo();
1113 }
1114
1115 ScDBData* pDBData = bSelected
1116 ? pDoc->GetDBAtArea( nStartTab, nStartCol, nStartRow, nEndCol, nEndRow )
1117 : pDoc->GetDBAtCursor( nStartCol, nStartRow, nStartTab );
1118
1119 if ( pDBData )
1120 {
1121 ScQueryParam aParam;
1122 pDBData->GetQueryParam( aParam );
1123 if ( aParam.GetEntry(0).bDoQuery )
1124 bAnyQuery = sal_True;
1125 }
1126
1127 if ( !bAnyQuery )
1128 rSet.DisableItem( nWhich );
1129 }
1130 break;
1131
1132 case SID_DEFINE_DBNAME:
1133 {
1134 if ( pDocSh && pDocSh->IsDocShared() )
1135 {
1136 rSet.DisableItem( nWhich );
1137 }
1138 }
1139 break;
1140
1141 case SID_TEXT_TO_COLUMNS:
1142 {
1143 ScRange aRange;
1144 if ( !lcl_GetTextToColumnsRange( pData, aRange ) )
1145 {
1146 rSet.DisableItem( nWhich );
1147 }
1148 }
1149 break;
1150 }
1151 nWhich = aIter.NextWhich();
1152 }
1153 }
1154
1155
1156
1157 /* vim:set shiftwidth=4 softtabstop=4 expandtab: */
FREE OFFICE SUITE