sc/source/ui/miscdlgs/simpref.cxx

   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: simpref.cxx,v $
  10  * $Revision: 1.11.30.2 $
  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 -------------------------------------------------------------------
  39
  40 #include <vcl/msgbox.hxx>
  41 #include <sfx2/app.hxx>
  42
  43 #include "reffact.hxx"
  44 #include "document.hxx"
  45 #include "scresid.hxx"
  46 #include "globstr.hrc"
  47 #include "simpref.hrc"
  48 #include "rangenam.hxx"         // IsNameValid
  49 #include "simpref.hxx"
  50 #include "scmod.hxx"
  51
  52 //============================================================================
  53
  54 #define ABS_SREF                  SCA_VALID \
  55                                                 | SCA_COL_ABSOLUTE | SCA_ROW_ABSOLUTE | SCA_TAB_ABSOLUTE
  56 #define ABS_DREF                  ABS_SREF \
  57                                                 | SCA_COL2_ABSOLUTE | SCA_ROW2_ABSOLUTE | SCA_TAB2_ABSOLUTE
  58 #define ABS_SREF3D              ABS_SREF | SCA_TAB_3D
  59 #define ABS_DREF3D              ABS_DREF | SCA_TAB_3D
  60
  61 //----------------------------------------------------------------------------
  62
  63 #define ERRORBOX(s) ErrorBox(this,WinBits(WB_OK|WB_DEF_OK),s).Execute()
  64 #define QUERYBOX(m) QueryBox(this,WinBits(WB_YES_NO|WB_DEF_YES),m).Execute()
  65
  66 //============================================================================
  67 //      class ScSimpleRefDlg
  68
  69 //----------------------------------------------------------------------------
  70 ScSimpleRefDlg::ScSimpleRefDlg( SfxBindings* pB, SfxChildWindow* pCW, Window* pParent,
  71                                                   ScViewData*   ptrViewData )
  72
  73         :       ScAnyRefDlg     ( pB, pCW, pParent, RID_SCDLG_SIMPLEREF ),
  74                 //
  75                 aFtAssign               ( this, ScResId( FT_ASSIGN ) ),
  76         aEdAssign       ( this, this, ScResId( ED_ASSIGN ) ),
  77                 aRbAssign               ( this, ScResId( RB_ASSIGN ), &aEdAssign, this ),
  78
  79                 aBtnOk                  ( this, ScResId( BTN_OK ) ),
  80                 aBtnCancel              ( this, ScResId( BTN_CANCEL ) ),
  81                 aBtnHelp                ( this, ScResId( BTN_HELP ) ),
  82
  83                 //
  84                 pViewData               ( ptrViewData ),
  85                 pDoc                    ( ptrViewData->GetDocument() ),
  86                 bRefInputMode   ( FALSE ),
  87                 bAutoReOpen             ( TRUE ),
  88                 bCloseOnButtonUp( FALSE ),
  89         bSingleCell     ( FALSE ),
  90         bMultiSelection ( FALSE )
  91 {
  92         //      damit die Strings in der Resource bei den FixedTexten bleiben koennen:
  93         Init();
  94         FreeResource();
  95         SetDispatcherLock( TRUE ); // Modal-Modus einschalten
  96 }
  97
  98 //----------------------------------------------------------------------------
  99 __EXPORT ScSimpleRefDlg::~ScSimpleRefDlg()
 100 {
 101         SetDispatcherLock( FALSE ); // Modal-Modus einschalten
 102 }
 103
 104 //----------------------------------------------------------------------------
 105 void ScSimpleRefDlg::FillInfo(SfxChildWinInfo& rWinInfo) const
 106 {
 107         ScAnyRefDlg::FillInfo(rWinInfo);
 108         rWinInfo.bVisible=bAutoReOpen;
 109 }
 110
 111 //----------------------------------------------------------------------------
 112 void ScSimpleRefDlg::SetRefString(const String &rStr)
 113 {
 114         aEdAssign.SetText(rStr);
 115 }
 116
 117 //----------------------------------------------------------------------------
 118 void ScSimpleRefDlg::Init()
 119 {
 120         aBtnOk.SetClickHdl              ( LINK( this, ScSimpleRefDlg, OkBtnHdl ) );
 121         aBtnCancel.SetClickHdl  ( LINK( this, ScSimpleRefDlg, CancelBtnHdl ) );
 122         bCloseFlag=FALSE;
 123 }
 124
 125 //----------------------------------------------------------------------------
 126 // Uebergabe eines mit der Maus selektierten Tabellenbereiches, der dann als
 127 //  neue Selektion im Referenz-Fenster angezeigt wird.
 128 void ScSimpleRefDlg::SetReference( const ScRange& rRef, ScDocument* pDocP )
 129 {
 130         if ( aEdAssign.IsEnabled() )
 131         {
 132                 if ( rRef.aStart != rRef.aEnd )
 133                         RefInputStart( &aEdAssign );
 134
 135                 theCurArea = rRef;
 136                 String aRefStr;
 137                 if ( bSingleCell )
 138                 {
 139                         ScAddress aAdr = rRef.aStart;
 140             aAdr.Format( aRefStr, SCA_ABS_3D, pDocP, pDocP->GetAddressConvention() );
 141                 }
 142                 else
 143             theCurArea.Format( aRefStr, ABS_DREF3D, pDocP, pDocP->GetAddressConvention() );
 144
 145         if ( bMultiSelection )
 146         {
 147             String aVal = aEdAssign.GetText();
 148             Selection aSel = aEdAssign.GetSelection();
 149             aSel.Justify();
 150             aVal.Erase( (xub_StrLen)aSel.Min(), (xub_StrLen)aSel.Len() );
 151             aVal.Insert( aRefStr, (xub_StrLen)aSel.Min() );
 152             Selection aNewSel( aSel.Min(), aSel.Min()+aRefStr.Len() );
 153             aEdAssign.SetRefString( aVal );
 154             aEdAssign.SetSelection( aNewSel );
 155         }
 156         else
 157             aEdAssign.SetRefString( aRefStr );
 158
 159                 aChangeHdl.Call( &aRefStr );
 160         }
 161 }
 162
 163
 164 //----------------------------------------------------------------------------
 165 BOOL __EXPORT ScSimpleRefDlg::Close()
 166 {
 167         CancelBtnHdl(&aBtnCancel);
 168         return TRUE;
 169 }
 170
 171 //------------------------------------------------------------------------
 172 void ScSimpleRefDlg::SetActive()
 173 {
 174         aEdAssign.GrabFocus();
 175
 176         //      kein NameModifyHdl, weil sonst Bereiche nicht geaendert werden koennen
 177         //      (nach dem Aufziehen der Referenz wuerde der alte Inhalt wieder angezeigt)
 178         //      (der ausgewaehlte DB-Name hat sich auch nicht veraendert)
 179
 180         RefInputDone();
 181 }
 182 //------------------------------------------------------------------------
 183 BOOL ScSimpleRefDlg::IsRefInputMode() const
 184 {
 185         return TRUE;
 186 }
 187
 188 String ScSimpleRefDlg::GetRefString() const
 189 {
 190         return aEdAssign.GetText();
 191 }
 192
 193 void ScSimpleRefDlg::SetCloseHdl( const Link& rLink )
 194 {
 195         aCloseHdl=rLink;
 196 }
 197
 198 void ScSimpleRefDlg::SetUnoLinks( const Link& rDone, const Link& rAbort,
 199                                                                         const Link& rChange )
 200 {
 201         aDoneHdl        = rDone;
 202         aAbortedHdl     = rAbort;
 203         aChangeHdl      = rChange;
 204 }
 205
 206 void ScSimpleRefDlg::SetFlags( BOOL bSetCloseOnButtonUp, BOOL bSetSingleCell, BOOL bSetMultiSelection )
 207 {
 208         bCloseOnButtonUp = bSetCloseOnButtonUp;
 209         bSingleCell = bSetSingleCell;
 210         bMultiSelection = bSetMultiSelection;
 211 }
 212
 213 void ScSimpleRefDlg::StartRefInput()
 214 {
 215     if ( bMultiSelection )
 216     {
 217         // initially select the whole string, so it gets replaced by default
 218         aEdAssign.SetSelection( Selection( 0, aEdAssign.GetText().Len() ) );
 219     }
 220
 221         aRbAssign.DoRef();
 222         bCloseFlag=TRUE;
 223 }
 224
 225 void ScSimpleRefDlg::RefInputDone( BOOL bForced)
 226 {
 227         ScAnyRefDlg::RefInputDone(bForced);
 228         if ( (bForced || bCloseOnButtonUp) && bCloseFlag )
 229                 OkBtnHdl(&aBtnOk);
 230 }
 231 //------------------------------------------------------------------------
 232 // Handler:
 233 // ========
 234 IMPL_LINK( ScSimpleRefDlg, OkBtnHdl, void *, EMPTYARG )
 235 {
 236         bAutoReOpen=FALSE;
 237         String aResult=aEdAssign.GetText();
 238         aCloseHdl.Call(&aResult);
 239         Link aUnoLink = aDoneHdl;               // stack var because this is deleted in DoClose
 240         DoClose( ScSimpleRefDlgWrapper::GetChildWindowId() );
 241         aUnoLink.Call( &aResult );
 242         return 0;
 243 }
 244
 245 //------------------------------------------------------------------------
 246 IMPL_LINK( ScSimpleRefDlg, CancelBtnHdl, void *, EMPTYARG )
 247 {
 248         bAutoReOpen=FALSE;
 249         String aResult=aEdAssign.GetText();
 250         aCloseHdl.Call(NULL);
 251         Link aUnoLink = aAbortedHdl;    // stack var because this is deleted in DoClose
 252         DoClose( ScSimpleRefDlgWrapper::GetChildWindowId() );
 253         aUnoLink.Call( &aResult );
 254         return 0;
 255 }
 256
 257
 258
 259 //------------------------------------------------------------------------
 260