?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
merge the formfield patch from ooo-build
[ooovba.git] / sc / source / ui / dbgui / consdlg.cxx
blob758e5d681201687a47cdb3536470a3a7d59e8072
1 /*************************************************************************
2 *
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4 *
5 * Copyright 2008 by Sun Microsystems, Inc.
6 *
7 * OpenOffice.org - a multi-platform office productivity suite
8 *
9 * $RCSfile: consdlg.cxx,v $
10 * $Revision: 1.13 $
11 *
12 * This file is part of OpenOffice.org.
13 *
14 * OpenOffice.org is free software: you can redistribute it and/or modify
15 * it under the terms of the GNU Lesser General Public License version 3
16 * only, as published by the Free Software Foundation.
17 *
18 * OpenOffice.org is distributed in the hope that it will be useful,
19 * but WITHOUT ANY WARRANTY; without even the implied warranty of
20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
21 * GNU Lesser General Public License version 3 for more details
22 * (a copy is included in the LICENSE file that accompanied this code).
23 *
24 * You should have received a copy of the GNU Lesser General Public License
25 * version 3 along with OpenOffice.org. If not, see
26 * <http://www.openoffice.org/license.html>
27 * for a copy of the LGPLv3 License.
28 *
29 ************************************************************************/
30
31 // MARKER(update_precomp.py): autogen include statement, do not remove
32 #include "precompiled_sc.hxx"
33
34 // System - Includes ---------------------------------------------------------
35
36
37
38 #include <sfx2/dispatch.hxx>
39
40 // INCLUDE -------------------------------------------------------------------
41
42 #include "tabvwsh.hxx"
43 #include "uiitems.hxx"
44 #include "dbcolect.hxx"
45 #include "rangenam.hxx"
46 #include "rangeutl.hxx"
47 #include "reffact.hxx"
48 #include "document.hxx"
49 #include "scresid.hxx"
50
51 #include "globstr.hrc"
52 #include "consdlg.hrc"
53
54 #define _CONSDLG_CXX
55 #include "consdlg.hxx"
56 #undef _CONSDLG_CXX
57 #include <vcl/msgbox.hxx>
58
59 #define INFOBOX(id) InfoBox(this, ScGlobal::GetRscString(id)).Execute()
60
61 //============================================================================
62 // class ScAreaData
63
64 class ScAreaData
65 {
66 public:
67 ScAreaData() {}
68 ~ScAreaData() {}
69
70 void Set( const String& rName, const String& rArea, BOOL bDb )
71 {
72 aStrName = rName;
73 aStrArea = rArea;
74 bIsDbArea = bDb;
75 }
76
77 String aStrName;
78 String aStrArea;
79 BOOL bIsDbArea;
80 };
81
82
83 //============================================================================
84 // class ScConsolidateDialog
85
86
87 ScConsolidateDlg::ScConsolidateDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent,
88 const SfxItemSet& rArgSet )
89
90 : ScAnyRefDlg ( pB, pCW, pParent, RID_SCDLG_CONSOLIDATE ),
91 //
92 aFtFunc ( this, ScResId( FT_FUNC ) ),
93 aLbFunc ( this, ScResId( LB_FUNC ) ),
94
95 aFtConsAreas ( this, ScResId( FT_CONSAREAS ) ),
96 aLbConsAreas ( this, ScResId( LB_CONSAREAS ) ),
97
98 aLbDataArea ( this, ScResId( LB_DATA_AREA ) ),
99 aFtDataArea ( this, ScResId( FT_DATA_AREA ) ),
100 aEdDataArea ( this, this, ScResId( ED_DATA_AREA ) ),
101 aRbDataArea ( this, ScResId( RB_DATA_AREA ), &aEdDataArea, this ),
102
103 aLbDestArea ( this, ScResId( LB_DEST_AREA ) ),
104 aFtDestArea ( this, ScResId( FT_DEST_AREA ) ),
105 aEdDestArea ( this, this, ScResId( ED_DEST_AREA ) ),
106 aRbDestArea ( this, ScResId( RB_DEST_AREA ), &aEdDestArea, this),
107
108 aFlConsBy ( this, ScResId( FL_CONSBY ) ),
109 aBtnByRow ( this, ScResId( BTN_BYROW ) ),
110 aBtnByCol ( this, ScResId( BTN_BYCOL) ),
111
112 aFlSep ( this, ScResId( FL_SEP ) ),
113 aFlOptions ( this, ScResId( FL_OPTIONS ) ),
114 aBtnRefs ( this, ScResId( BTN_REFS ) ),
115
116 aBtnOk ( this, ScResId( BTN_OK ) ),
117 aBtnCancel ( this, ScResId( BTN_CANCEL ) ),
118 aBtnHelp ( this, ScResId( BTN_HELP ) ),
119 aBtnAdd ( this, ScResId( BTN_ADD ) ),
120 aBtnRemove ( this, ScResId( BTN_REMOVE ) ),
121 aBtnMore ( this, ScResId( BTN_MORE ) ),
122
123 aStrUndefined ( ScResId( SCSTR_UNDEFINED ) ),
124 //
125 theConsData ( ((const ScConsolidateItem&)
126 rArgSet.Get( rArgSet.GetPool()->
127 GetWhich( SID_CONSOLIDATE ) )
128 ).GetData() ),
129 pViewData ( ((ScTabViewShell*)SfxViewShell::Current())->
130 GetViewData() ),
131 pDoc ( ((ScTabViewShell*)SfxViewShell::Current())->
132 GetViewData()->GetDocument() ),
133 pRangeUtil ( new ScRangeUtil ),
134 pAreaData ( NULL ),
135 nAreaDataCount ( 0 ),
136 nWhichCons ( rArgSet.GetPool()->GetWhich( SID_CONSOLIDATE ) ),
137
138 pRefInputEdit ( &aEdDataArea )
139 {
140 Init();
141 FreeResource();
142 }
143
144
145 //----------------------------------------------------------------------------
146
147 __EXPORT ScConsolidateDlg::~ScConsolidateDlg()
148 {
149 delete [] pAreaData;
150 delete pRangeUtil;
151 }
152
153
154 //----------------------------------------------------------------------------
155
156 void ScConsolidateDlg::Init()
157 {
158 DBG_ASSERT( pViewData && pDoc && pRangeUtil, "Error in Ctor" );
159
160 String aStr;
161 USHORT i=0;
162
163 aEdDataArea .SetGetFocusHdl( LINK( this, ScConsolidateDlg, GetFocusHdl ) );
164 aEdDestArea .SetGetFocusHdl( LINK( this, ScConsolidateDlg, GetFocusHdl ) );
165 aLbDataArea .SetGetFocusHdl( LINK( this, ScConsolidateDlg, GetFocusHdl ) );
166 aLbDestArea .SetGetFocusHdl( LINK( this, ScConsolidateDlg, GetFocusHdl ) );
167 aEdDataArea .SetModifyHdl ( LINK( this, ScConsolidateDlg, ModifyHdl ) );
168 aEdDestArea .SetModifyHdl ( LINK( this, ScConsolidateDlg, ModifyHdl ) );
169 aLbConsAreas.SetSelectHdl ( LINK( this, ScConsolidateDlg, SelectHdl ) );
170 aLbDataArea .SetSelectHdl ( LINK( this, ScConsolidateDlg, SelectHdl ) );
171 aLbDestArea .SetSelectHdl ( LINK( this, ScConsolidateDlg, SelectHdl ) );
172 aBtnOk .SetClickHdl ( LINK( this, ScConsolidateDlg, OkHdl ) );
173 aBtnCancel .SetClickHdl ( LINK( this, ScConsolidateDlg, ClickHdl ) );
174 aBtnAdd .SetClickHdl ( LINK( this, ScConsolidateDlg, ClickHdl ) );
175 aBtnRemove .SetClickHdl ( LINK( this, ScConsolidateDlg, ClickHdl ) );
176
177 aBtnMore.AddWindow( &aFlConsBy );
178 aBtnMore.AddWindow( &aBtnByRow );
179 aBtnMore.AddWindow( &aBtnByCol );
180 aBtnMore.AddWindow( &aFlSep );
181 aBtnMore.AddWindow( &aFlOptions );
182 aBtnMore.AddWindow( &aBtnRefs );
183
184 aBtnAdd.Disable();
185 aBtnRemove.Disable();
186
187 aBtnByRow.Check( theConsData.bByRow );
188 aBtnByCol.Check( theConsData.bByCol );
189 aBtnRefs .Check( theConsData.bReferenceData );
190
191 aLbFunc.SelectEntryPos( FuncToLbPos( theConsData.eFunction ) );
192
193 // Einlesen der Konsolidierungsbereiche
194 aLbConsAreas.Clear();
195 const formula::FormulaGrammar::AddressConvention eConv = pDoc->GetAddressConvention();
196 for ( i=0; i<theConsData.nDataAreaCount; i++ )
197 {
198 const ScArea& rArea = *(theConsData.ppDataAreas[i] );
199 if ( rArea.nTab < pDoc->GetTableCount() )
200 {
201 ScRange( rArea.nColStart, rArea.nRowStart, rArea.nTab,
202 rArea.nColEnd, rArea.nRowEnd, rArea.nTab ).Format( aStr,
203 SCR_ABS_3D, pDoc, eConv );
204 aLbConsAreas.InsertEntry( aStr );
205 }
206 }
207
208 if ( theConsData.nTab < pDoc->GetTableCount() )
209 {
210 ScAddress( theConsData.nCol, theConsData.nRow, theConsData.nTab
211 ).Format( aStr, SCA_ABS_3D, pDoc, eConv );
212 aEdDestArea.SetText( aStr );
213 }
214 else
215 aEdDestArea.SetText( EMPTY_STRING );
216
217 //----------------------------------------------------------
218
219 /*
220 * Aus den RangeNames und Datenbankbereichen werden sich
221 * in der Hilfsklasse ScAreaData die Bereichsnamen gemerkt,
222 * die in den ListBoxen erscheinen.
223 */
224
225 ScRangeName* pRangeNames = pDoc->GetRangeName();
226 ScDBCollection* pDbNames = pDoc->GetDBCollection();
227 const USHORT nRangeCount = pRangeNames ? pRangeNames->GetCount() : 0;
228 const USHORT nDbCount = pDbNames ? pDbNames ->GetCount() : 0;
229
230 nAreaDataCount = nRangeCount+nDbCount;
231 pAreaData = NULL;
232
233 if ( nAreaDataCount > 0 )
234 {
235 pAreaData = new ScAreaData[nAreaDataCount];
236
237 String aStrName;
238 String aStrArea;
239 USHORT nAt = 0;
240 ScRange aRange;
241 ScAreaNameIterator aIter( pDoc );
242 while ( aIter.Next( aStrName, aRange ) )
243 {
244 aRange.Format( aStrArea, SCA_ABS_3D, pDoc, eConv );
245 pAreaData[nAt++].Set( aStrName, aStrArea, aIter.WasDBName() );
246 }
247 }
248
249 FillAreaLists();
250 ModifyHdl( &aEdDestArea );
251 aLbDataArea.SelectEntryPos( 0 );
252 aEdDataArea.SetText( EMPTY_STRING );
253 aEdDataArea.GrabFocus();
254
255 aFlSep.SetStyle( aFlSep.GetStyle() | WB_VERT );
256
257 //@BugID 54702 Enablen/Disablen nur noch in Basisklasse
258 //SFX_APPWINDOW->Enable();
259 }
260
261
262 //----------------------------------------------------------------------------
263 void ScConsolidateDlg::FillAreaLists()
264 {
265 aLbDataArea.Clear();
266 aLbDestArea.Clear();
267 aLbDataArea.InsertEntry( aStrUndefined );
268 aLbDestArea.InsertEntry( aStrUndefined );
269
270 if ( pRangeUtil && pAreaData && (nAreaDataCount > 0) )
271 {
272 String aString;
273
274 for ( USHORT i=0;
275 (i<nAreaDataCount) && (pAreaData[i].aStrName.Len()>0);
276 i++ )
277 {
278 aLbDataArea.InsertEntry( pAreaData[i].aStrName, i+1 );
279
280 // if ( !pAreaData[i].bIsDbArea )
281 aLbDestArea.InsertEntry( pAreaData[i].aStrName, i+1 );
282 }
283 }
284 }
285
286
287 //----------------------------------------------------------------------------
288 // Uebergabe eines mit der Maus selektierten Tabellenbereiches, der dann als
289 // neue Selektion im Referenz-Fenster angezeigt wird.
290
291
292 void ScConsolidateDlg::SetReference( const ScRange& rRef, ScDocument* pDocP )
293 {
294 if ( pRefInputEdit )
295 {
296 if ( rRef.aStart != rRef.aEnd )
297 RefInputStart( pRefInputEdit );
298
299 String aStr;
300 USHORT nFmt = SCR_ABS_3D; //!!! nCurTab fehlt noch
301 const formula::FormulaGrammar::AddressConvention eConv = pDocP->GetAddressConvention();
302
303 if ( rRef.aStart.Tab() != rRef.aEnd.Tab() )
304 nFmt |= SCA_TAB2_3D;
305
306 if ( pRefInputEdit == &aEdDataArea)
307 rRef.Format( aStr, nFmt, pDocP, eConv );
308 else if ( pRefInputEdit == &aEdDestArea )
309 rRef.aStart.Format( aStr, nFmt, pDocP, eConv );
310
311 pRefInputEdit->SetRefString( aStr );
312 }
313
314 ModifyHdl( pRefInputEdit );
315 }
316
317
318 //----------------------------------------------------------------------------
319
320 BOOL __EXPORT ScConsolidateDlg::Close()
321 {
322 return DoClose( ScConsolidateDlgWrapper::GetChildWindowId() );
323 }
324
325
326 //----------------------------------------------------------------------------
327
328 void ScConsolidateDlg::SetActive()
329 {
330 if ( bDlgLostFocus )
331 {
332 bDlgLostFocus = FALSE;
333
334 if ( pRefInputEdit )
335 {
336 pRefInputEdit->GrabFocus();
337 ModifyHdl( pRefInputEdit );
338 }
339 }
340 else
341 GrabFocus();
342
343 RefInputDone();
344 }
345
346
347 //----------------------------------------------------------------------------
348
349 void __EXPORT ScConsolidateDlg::Deactivate()
350 {
351 bDlgLostFocus = TRUE;
352 }
353
354
355 //----------------------------------------------------------------------------
356
357 BOOL ScConsolidateDlg::VerifyEdit( formula::RefEdit* pEd )
358 {
359 if ( !pRangeUtil || !pDoc || !pViewData ||
360 ((pEd != &aEdDataArea) && (pEd != &aEdDestArea)) )
361 return FALSE;
362
363 SCTAB nTab = pViewData->GetTabNo();
364 BOOL bEditOk = FALSE;
365 String theCompleteStr;
366 const formula::FormulaGrammar::AddressConvention eConv = pDoc->GetAddressConvention();
367
368 if ( pEd == &aEdDataArea )
369 {
370 bEditOk = pRangeUtil->IsAbsArea( pEd->GetText(), pDoc,
371 nTab, &theCompleteStr, NULL, NULL, eConv );
372 }
373 else if ( pEd == &aEdDestArea )
374 {
375 String aPosStr;
376
377 pRangeUtil->CutPosString( pEd->GetText(), aPosStr );
378 bEditOk = pRangeUtil->IsAbsPos( aPosStr, pDoc,
379 nTab, &theCompleteStr, NULL, eConv );
380 }
381
382 if ( bEditOk )
383 pEd->SetText( theCompleteStr );
384
385 return bEditOk;
386 }
387
388
389 //----------------------------------------------------------------------------
390 // Handler:
391 // ========
392
393 IMPL_LINK( ScConsolidateDlg, GetFocusHdl, Control*, pCtr )
394 {
395 if ( pCtr ==(Control*)&aEdDataArea ||
396 pCtr ==(Control*)&aEdDestArea)
397 {
398 pRefInputEdit = (formula::RefEdit*)pCtr;
399 }
400 else if(pCtr ==(Control*)&aLbDataArea )
401 {
402 pRefInputEdit = &aEdDataArea;
403 }
404 else if(pCtr ==(Control*)&aLbDestArea )
405 {
406 pRefInputEdit = &aEdDestArea;
407 }
408 return 0;
409 }
410
411
412 //----------------------------------------------------------------------------
413
414 IMPL_LINK( ScConsolidateDlg, OkHdl, void*, EMPTYARG )
415 {
416 USHORT nDataAreaCount = aLbConsAreas.GetEntryCount();
417
418 if ( nDataAreaCount > 0 )
419 {
420 ScRefAddress aDestAddress;
421 SCTAB nTab = pViewData->GetTabNo();
422 String aDestPosStr( aEdDestArea.GetText() );
423 const formula::FormulaGrammar::AddressConvention eConv = pDoc->GetAddressConvention();
424
425 if ( pRangeUtil->IsAbsPos( aDestPosStr, pDoc, nTab, NULL, &aDestAddress, eConv ) )
426 {
427 ScConsolidateParam theOutParam( theConsData );
428 ScArea** ppDataAreas = new ScArea*[nDataAreaCount];
429 ScArea* pArea;
430 USHORT i=0;
431
432 for ( i=0; i<nDataAreaCount; i++ )
433 {
434 pArea = new ScArea;
435 pRangeUtil->MakeArea( aLbConsAreas.GetEntry( i ),
436 *pArea, pDoc, nTab, eConv );
437 ppDataAreas[i] = pArea;
438 }
439
440 theOutParam.nCol = aDestAddress.Col();
441 theOutParam.nRow = aDestAddress.Row();
442 theOutParam.nTab = aDestAddress.Tab();
443 theOutParam.eFunction = LbPosToFunc( aLbFunc.GetSelectEntryPos() );
444 theOutParam.bByCol = aBtnByCol.IsChecked();
445 theOutParam.bByRow = aBtnByRow.IsChecked();
446 theOutParam.bReferenceData = aBtnRefs.IsChecked();
447 theOutParam.SetAreas( ppDataAreas, nDataAreaCount );
448
449 for ( i=0; i<nDataAreaCount; i++ )
450 delete ppDataAreas[i];
451 delete [] ppDataAreas;
452
453 ScConsolidateItem aOutItem( nWhichCons, &theOutParam );
454
455 SetDispatcherLock( FALSE );
456 SwitchToDocument();
457 GetBindings().GetDispatcher()->Execute( SID_CONSOLIDATE,
458 SFX_CALLMODE_SLOT | SFX_CALLMODE_RECORD,
459 &aOutItem, 0L, 0L );
460 Close();
461 }
462 else
463 {
464 INFOBOX( STR_INVALID_TABREF );
465 aEdDestArea.GrabFocus();
466 }
467 }
468 else
469 Close(); // keine Datenbereiche definiert -> Cancel
470 return 0;
471 }
472
473
474 //----------------------------------------------------------------------------
475
476 IMPL_LINK( ScConsolidateDlg, ClickHdl, PushButton*, pBtn )
477 {
478 if ( pBtn == &aBtnCancel )
479 Close();
480 else if ( pBtn == &aBtnAdd )
481 {
482 if ( aEdDataArea.GetText().Len() > 0 )
483 {
484 String aNewEntry( aEdDataArea.GetText() );
485 ScArea** ppAreas = NULL;
486 USHORT nAreaCount = 0;
487 const formula::FormulaGrammar::AddressConvention eConv = pDoc->GetAddressConvention();
488
489 if ( pRangeUtil->IsAbsTabArea( aNewEntry, pDoc, &ppAreas, &nAreaCount, TRUE, eConv ) )
490 {
491 // IsAbsTabArea() legt ein Array von ScArea-Zeigern an,
492 // welche ebenfalls dynamisch erzeugt wurden.
493 // Diese Objekte muessen hier abgeraeumt werden.
494
495 for ( USHORT i=0; i<nAreaCount; i++ )
496 {
497 String aNewArea;
498
499 if ( ppAreas[i] )
500 {
501 const ScArea& rArea = *(ppAreas[i]);
502 ScRange( rArea.nColStart, rArea.nRowStart, rArea.nTab,
503 rArea.nColEnd, rArea.nRowEnd, rArea.nTab
504 ).Format( aNewArea, SCR_ABS_3D, pDoc, eConv );
505
506 if ( aLbConsAreas.GetEntryPos( aNewArea )
507 == LISTBOX_ENTRY_NOTFOUND )
508 {
509 aLbConsAreas.InsertEntry( aNewArea );
510 }
511 delete ppAreas[i];
512 }
513 }
514 delete [] ppAreas;
515 }
516 else if ( VerifyEdit( &aEdDataArea ) )
517 {
518 String aNewArea( aEdDataArea.GetText() );
519
520 if ( aLbConsAreas.GetEntryPos( aNewArea ) == LISTBOX_ENTRY_NOTFOUND )
521 aLbConsAreas.InsertEntry( aNewArea );
522 else
523 INFOBOX( STR_AREA_ALREADY_INSERTED );
524 }
525 else
526 {
527 INFOBOX( STR_INVALID_TABREF );
528 aEdDataArea.GrabFocus();
529 }
530 }
531 }
532 else if ( pBtn == &aBtnRemove )
533 {
534 while ( aLbConsAreas.GetSelectEntryCount() )
535 aLbConsAreas.RemoveEntry( aLbConsAreas.GetSelectEntryPos() );
536 aBtnRemove.Disable();
537 }
538 return 0;
539 }
540
541
542 //----------------------------------------------------------------------------
543
544 IMPL_LINK( ScConsolidateDlg, SelectHdl, ListBox*, pLb )
545 {
546 if ( pLb == &aLbConsAreas )
547 {
548 if ( aLbConsAreas.GetSelectEntryCount() > 0 )
549 aBtnRemove.Enable();
550 else
551 aBtnRemove.Disable();
552 }
553 else if ( (pLb == &aLbDataArea) || (pLb == &aLbDestArea) )
554 {
555 Edit* pEd = (pLb == &aLbDataArea) ? &aEdDataArea : &aEdDestArea;
556 USHORT nSelPos = pLb->GetSelectEntryPos();
557
558 if ( pRangeUtil
559 && (nSelPos > 0)
560 && (nAreaDataCount > 0)
561 && (pAreaData != NULL) )
562 {
563 if ( nSelPos <= nAreaDataCount )
564 {
565 String aString( pAreaData[nSelPos-1].aStrArea );
566
567 if ( pLb == &aLbDestArea )
568 pRangeUtil->CutPosString( aString, aString );
569
570 pEd->SetText( aString );
571
572 if ( pEd == &aEdDataArea )
573 aBtnAdd.Enable();
574 }
575 }
576 else
577 {
578 pEd->SetText( EMPTY_STRING );
579 if ( pEd == &aEdDataArea )
580 aBtnAdd.Enable();
581 }
582 }
583 return 0;
584 }
585
586
587 //----------------------------------------------------------------------------
588
589 IMPL_LINK( ScConsolidateDlg, ModifyHdl, formula::RefEdit*, pEd )
590 {
591 if ( pEd == &aEdDataArea )
592 {
593 String aAreaStr( pEd->GetText() );
594 if ( aAreaStr.Len() > 0 )
595 {
596 aBtnAdd.Enable();
597 }
598 else
599 aBtnAdd.Disable();
600 }
601 else if ( pEd == &aEdDestArea )
602 {
603 aLbDestArea.SelectEntryPos(0);
604 }
605 return 0;
606 }
607
608
609 //----------------------------------------------------------------------------
610 // Verallgemeinern!!! :
611 // Resource der ListBox und diese beiden Umrechnungsmethoden gibt es
612 // auch noch in tpsubt bzw. ueberall, wo StarCalc-Funktionen
613 // auswaehlbar sind.
614
615 ScSubTotalFunc ScConsolidateDlg::LbPosToFunc( USHORT nPos )
616 {
617 switch ( nPos )
618 {
619 case 2: return SUBTOTAL_FUNC_AVE;
620 case 6: return SUBTOTAL_FUNC_CNT;
621 case 1: return SUBTOTAL_FUNC_CNT2;
622 case 3: return SUBTOTAL_FUNC_MAX;
623 case 4: return SUBTOTAL_FUNC_MIN;
624 case 5: return SUBTOTAL_FUNC_PROD;
625 case 7: return SUBTOTAL_FUNC_STD;
626 case 8: return SUBTOTAL_FUNC_STDP;
627 case 9: return SUBTOTAL_FUNC_VAR;
628 case 10: return SUBTOTAL_FUNC_VARP;
629 case 0:
630 default:
631 return SUBTOTAL_FUNC_SUM;
632 }
633 }
634
635
636 //----------------------------------------------------------------------------
637
638 USHORT ScConsolidateDlg::FuncToLbPos( ScSubTotalFunc eFunc )
639 {
640 switch ( eFunc )
641 {
642 case SUBTOTAL_FUNC_AVE: return 2;
643 case SUBTOTAL_FUNC_CNT: return 6;
644 case SUBTOTAL_FUNC_CNT2: return 1;
645 case SUBTOTAL_FUNC_MAX: return 3;
646 case SUBTOTAL_FUNC_MIN: return 4;
647 case SUBTOTAL_FUNC_PROD: return 5;
648 case SUBTOTAL_FUNC_STD: return 7;
649 case SUBTOTAL_FUNC_STDP: return 8;
650 case SUBTOTAL_FUNC_VAR: return 9;
651 case SUBTOTAL_FUNC_VARP: return 10;
652 case SUBTOTAL_FUNC_NONE:
653 case SUBTOTAL_FUNC_SUM:
654 default:
655 return 0;
656 }
657 }
658
vba interoperability for OOo