sc/source/ui/miscdlgs/filldlg.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: filldlg.cxx,v $
  10  * $Revision: 1.9 $
  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 #undef SC_DLLIMPLEMENTATION
  35
  36
  37
  38 //----------------------------------------------------------------------------
  39
  40 #include <svtools/zforlist.hxx>
  41 #include <vcl/msgbox.hxx>
  42 #include <limits.h>
  43
  44 #include "scresid.hxx"
  45 #include "document.hxx"
  46 #include "miscdlgs.hrc"
  47
  48 #define _FILLDLG_CXX
  49 #include "filldlg.hxx"
  50 #undef _FILLDLG_CXX
  51
  52
  53
  54 //============================================================================
  55 // class ScFillSeriesDlg
  56
  57 //----------------------------------------------------------------------------
  58
  59 ScFillSeriesDlg::ScFillSeriesDlg( Window*       pParent,
  60                                                                   ScDocument&   rDocument,
  61                                                                   FillDir       eFillDir,
  62                                                                   FillCmd       eFillCmd,
  63                                                                   FillDateCmd   eFillDateCmd,
  64                                                                   String                aStartStr,
  65                                                                   double                fStep,
  66                                                                   double                fMax,
  67                                                                   USHORT                nPossDir )
  68
  69         :       ModalDialog     ( pParent, ScResId( RID_SCDLG_FILLSERIES ) ),
  70
  71         aFlDirection    ( this, ScResId( FL_DIRECTION ) ),
  72                 aBtnDown        ( this, ScResId( BTN_BOTTOM ) ),
  73                 aBtnRight       ( this, ScResId( BTN_RIGHT ) ),
  74                 aBtnUp          ( this, ScResId( BTN_TOP ) ),
  75                 aBtnLeft        ( this, ScResId( BTN_LEFT ) ),
  76         aFlSep1         ( this, ScResId( FL_SEP1 ) ),
  77         aFlType         ( this, ScResId( FL_TYPE ) ),
  78                 aBtnArithmetic  ( this, ScResId( BTN_ARITHMETIC ) ),
  79                 aBtnGeometric   ( this, ScResId( BTN_GEOMETRIC ) ),
  80                 aBtnDate        ( this, ScResId( BTN_DATE ) ),
  81                 aBtnAutoFill    ( this, ScResId( BTN_AUTOFILL ) ),
  82         aFlSep2         ( this, ScResId( FL_SEP2 ) ),
  83         aFlTimeUnit     ( this, ScResId( FL_TIME_UNIT ) ),
  84                 aBtnDay         ( this, ScResId( BTN_DAY ) ),
  85                 aBtnDayOfWeek   ( this, ScResId( BTN_DAY_OF_WEEK ) ),
  86                 aBtnMonth       ( this, ScResId( BTN_MONTH ) ),
  87                 aBtnYear        ( this, ScResId( BTN_YEAR ) ),
  88
  89                 aFtStartVal     ( this, ScResId( FT_START_VALUE ) ),
  90                 aEdStartVal     ( this, ScResId( ED_START_VALUES ) ),
  91                 aStartStrVal    ( aStartStr),
  92                 aFtEndVal       ( this, ScResId( FT_END_VALUE ) ),
  93                 aEdEndVal       ( this, ScResId( ED_END_VALUES ) ),
  94                 aFtIncrement    ( this, ScResId( FT_INCREMENT ) ),
  95                 aEdIncrement    ( this, ScResId( ED_INCREMENT ) ),
  96
  97                 aBtnOk          ( this, ScResId( BTN_OK ) ),
  98                 aBtnCancel      ( this, ScResId( BTN_CANCEL ) ),
  99                 aBtnHelp        ( this, ScResId( BTN_HELP ) ),
 100                 errMsgInvalidVal( ScResId( STR_VALERR ) ),
 101                 rDoc                    ( rDocument ),
 102                 theFillDir      ( eFillDir ),
 103                 theFillCmd      ( eFillCmd ),
 104                 theFillDateCmd  ( eFillDateCmd ),
 105                 fIncrement      ( fStep ),
 106                 fEndVal         ( fMax )
 107 {
 108         Init( nPossDir );
 109         FreeResource();
 110 }
 111
 112
 113 //----------------------------------------------------------------------------
 114
 115 __EXPORT ScFillSeriesDlg::~ScFillSeriesDlg()
 116 {
 117 }
 118
 119 //----------------------------------------------------------------------------
 120
 121 void ScFillSeriesDlg::SetEdStartValEnabled(BOOL bFlag)
 122 {
 123         bStartValFlag=bFlag;
 124         if(bFlag)
 125         {
 126            aFtStartVal.Enable();
 127            aEdStartVal.Enable();
 128         }
 129         else
 130         {
 131            aFtStartVal.Disable();
 132            aEdStartVal.Disable();
 133         }
 134 }
 135
 136 //----------------------------------------------------------------------------
 137
 138 void ScFillSeriesDlg::Init( USHORT nPossDir )
 139 {
 140         aBtnOk.SetClickHdl         ( LINK( this, ScFillSeriesDlg, OKHdl ) );
 141         aBtnArithmetic.SetClickHdl ( LINK( this, ScFillSeriesDlg, DisableHdl ) );
 142         aBtnGeometric.SetClickHdl  ( LINK( this, ScFillSeriesDlg, DisableHdl ) );
 143         aBtnDate.SetClickHdl       ( LINK( this, ScFillSeriesDlg, DisableHdl ) );
 144         aBtnAutoFill.SetClickHdl   ( LINK( this, ScFillSeriesDlg, DisableHdl ) );
 145
 146         if( nPossDir == FDS_OPT_NONE )
 147         {
 148                 aBtnLeft.Disable();
 149                 aBtnRight.Disable();
 150                 aBtnDown.Disable();
 151                 aBtnUp.Disable();
 152         }
 153
 154         if( nPossDir == FDS_OPT_HORZ )
 155         {
 156                 aBtnDown.Disable();
 157                 aBtnUp.Disable();
 158         }
 159
 160         if( nPossDir == FDS_OPT_VERT )
 161         {
 162                 aBtnLeft.Disable();
 163                 aBtnRight.Disable();
 164         }
 165
 166         switch ( theFillDir )
 167         {
 168                 case FILL_TO_LEFT:      aBtnLeft.Check();   break;
 169                 case FILL_TO_RIGHT:     aBtnRight.Check();  break;
 170                 case FILL_TO_BOTTOM:    aBtnDown.Check();   break;
 171                 case FILL_TO_TOP:       aBtnUp.Check();     break;
 172                 default:
 173                 break;
 174         }
 175
 176         switch ( theFillCmd )
 177         {
 178                 case FILL_LINEAR:
 179                         aBtnArithmetic.Check();
 180                         DisableHdl( &aBtnArithmetic );
 181                         break;
 182                 case FILL_GROWTH:
 183                         aBtnGeometric.Check();
 184                         DisableHdl( &aBtnGeometric );
 185                         break;
 186                 case FILL_DATE:
 187                         aBtnDate.Check();
 188                         DisableHdl( &aBtnDate );
 189                         break;
 190                 case FILL_AUTO:
 191                         aBtnAutoFill.Check();
 192                         DisableHdl( &aBtnAutoFill );
 193                         break;
 194                 default:
 195                 break;
 196         }
 197
 198         switch ( theFillDateCmd )
 199         {
 200                 case FILL_DAY:          aBtnDay.Check();        break;
 201                 case FILL_WEEKDAY:      aBtnDayOfWeek.Check();  break;
 202                 case FILL_MONTH:        aBtnMonth.Check();      break;
 203                 case FILL_YEAR:         aBtnYear.Check();       break;
 204                 default:
 205                 break;
 206         }
 207
 208         fStartVal = MAXDOUBLE;
 209         /*
 210         String aStartTxt;
 211         if ( fStartVal != MAXDOUBLE )
 212                 rDoc.GetFormatTable()->GetInputLineString( fStartVal, 0, aStartTxt );
 213         aEdStartVal.SetText( aStartTxt );
 214         */
 215
 216         aEdStartVal.SetText( aStartStrVal);
 217
 218         String aIncrTxt;
 219         rDoc.GetFormatTable()->GetInputLineString( fIncrement, 0, aIncrTxt );
 220         aEdIncrement.SetText( aIncrTxt );
 221
 222         String aEndTxt;
 223         if ( fEndVal != MAXDOUBLE )
 224                 rDoc.GetFormatTable()->GetInputLineString( fEndVal, 0, aEndTxt );
 225         aEdEndVal.SetText( aEndTxt );
 226
 227         bStartValFlag=FALSE;
 228
 229     aFlSep1.SetStyle( aFlSep1.GetStyle() | WB_VERT );
 230     aFlSep2.SetStyle( aFlSep2.GetStyle() | WB_VERT );
 231 }
 232
 233
 234 //----------------------------------------------------------------------------
 235
 236 BOOL __EXPORT ScFillSeriesDlg::CheckStartVal()
 237 {
 238         BOOL bValOk = FALSE;
 239         sal_uInt32 nKey = 0;
 240         String aStr( aEdStartVal.GetText() );
 241
 242         if ( aStr.Len() == 0 || aBtnAutoFill.IsChecked())
 243         {
 244                 fStartVal = MAXDOUBLE;
 245                 bValOk = TRUE;
 246         }
 247         else
 248                 bValOk = rDoc.GetFormatTable()->IsNumberFormat( aStr, nKey, fStartVal );
 249
 250         return bValOk;
 251 }
 252
 253
 254 //----------------------------------------------------------------------------
 255
 256 BOOL __EXPORT ScFillSeriesDlg::CheckIncrementVal()
 257 {
 258         sal_uInt32 nKey = 0;
 259         String aStr( aEdIncrement.GetText() );
 260
 261         return rDoc.GetFormatTable()->IsNumberFormat( aStr, nKey, fIncrement );
 262 }
 263
 264
 265 //----------------------------------------------------------------------------
 266
 267 BOOL __EXPORT ScFillSeriesDlg::CheckEndVal()
 268 {
 269         BOOL    bValOk = FALSE;
 270         sal_uInt32 nKey = 0;
 271         String  aStr( aEdEndVal.GetText() );
 272
 273         if ( aStr.Len() == 0 )
 274         {
 275                 fEndVal = (fIncrement < 0) ? -MAXDOUBLE : MAXDOUBLE;
 276                 bValOk  = TRUE;
 277         }
 278         else
 279                 bValOk = rDoc.GetFormatTable()->IsNumberFormat( aStr, nKey, fEndVal );
 280
 281         return bValOk;
 282 }
 283
 284
 285 //----------------------------------------------------------------------------
 286 // Handler:
 287 //----------------------------------------------------------------------------
 288
 289 IMPL_LINK( ScFillSeriesDlg, DisableHdl, Button *, pBtn )
 290 {
 291         if ( pBtn == &aBtnDate )
 292         {
 293                 aBtnDay.Enable();
 294                 aBtnDayOfWeek.Enable();
 295                 aBtnMonth.Enable();
 296                 aBtnYear.Enable();
 297         aFlTimeUnit.Enable();
 298         }
 299         else
 300         {
 301                 aBtnDay.Disable();
 302                 aBtnDayOfWeek.Disable();
 303                 aBtnMonth.Disable();
 304                 aBtnYear.Disable();
 305         aFlTimeUnit.Disable();
 306         }
 307
 308         if ( pBtn != &aBtnAutoFill )
 309         {
 310                 aFtIncrement.Enable();
 311                 aEdIncrement.Enable();
 312                 aFtEndVal.Enable();
 313                 aEdEndVal.Enable();
 314         }
 315         else
 316         {
 317                 aFtIncrement.Disable();
 318                 aEdIncrement.Disable();
 319                 aFtEndVal.Disable();
 320                 aEdEndVal.Disable();
 321         }
 322         return 0;
 323 }
 324
 325
 326 //----------------------------------------------------------------------------
 327
 328 IMPL_LINK( ScFillSeriesDlg, OKHdl, void *, EMPTYARG )
 329 {
 330         if ( aBtnLeft.IsChecked() )             theFillDir = FILL_TO_LEFT;
 331         else if ( aBtnRight.IsChecked() )       theFillDir = FILL_TO_RIGHT;
 332         else if ( aBtnDown.IsChecked() )        theFillDir = FILL_TO_BOTTOM;
 333         else if ( aBtnUp.IsChecked() )          theFillDir = FILL_TO_TOP;
 334
 335         if ( aBtnArithmetic.IsChecked() )       theFillCmd = FILL_LINEAR;
 336         else if ( aBtnGeometric.IsChecked() )   theFillCmd = FILL_GROWTH;
 337         else if ( aBtnDate.IsChecked() )        theFillCmd = FILL_DATE;
 338         else if ( aBtnAutoFill.IsChecked() )    theFillCmd = FILL_AUTO;
 339
 340         if ( aBtnDay.IsChecked() )              theFillDateCmd = FILL_DAY;
 341         else if ( aBtnDayOfWeek.IsChecked() )   theFillDateCmd = FILL_WEEKDAY;
 342         else if ( aBtnMonth.IsChecked() )       theFillDateCmd = FILL_MONTH;
 343         else if ( aBtnYear.IsChecked() )        theFillDateCmd = FILL_YEAR;
 344
 345         BOOL  bAllOk = TRUE;
 346     Edit* pEdWrong = NULL;
 347         if ( !CheckStartVal() )
 348         {
 349                 bAllOk = FALSE;
 350                 pEdWrong = &aEdStartVal;
 351         }
 352         else if ( !CheckIncrementVal() )
 353         {
 354                 bAllOk = FALSE;
 355                 pEdWrong = &aEdIncrement;
 356         }
 357         else if ( !CheckEndVal() )
 358         {
 359                 bAllOk = FALSE;
 360                 pEdWrong = &aEdEndVal;
 361         }
 362         if ( bAllOk )
 363                 EndDialog( RET_OK );
 364         else
 365         {
 366                 ErrorBox( this,
 367                                   WinBits( WB_OK | WB_DEF_OK ),
 368                                   errMsgInvalidVal
 369                                 ).Execute();
 370                 pEdWrong->GrabFocus();
 371         }
 372
 373         return 0;
 374 }
 375
 376
 377
 378