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