AOO410/main/sc/source/ui/dbgui/dpgroupdlg.cxx - openoffice - Git at Google

 /**************************************************************
  *
  * Licensed to the Apache Software Foundation (ASF) under one
  * or more contributor license agreements.  See the NOTICE file
  * distributed with this work for additional information
  * regarding copyright ownership.  The ASF licenses this file
  * to you under the Apache License, Version 2.0 (the
  * "License"); you may not use this file except in compliance
  * with the License.  You may obtain a copy of the License at
  *
  *   http://www.apache.org/licenses/LICENSE-2.0
  *
  * Unless required by applicable law or agreed to in writing,
  * software distributed under the License is distributed on an
  * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
  * KIND, either express or implied.  See the License for the
  * specific language governing permissions and limitations
  * under the License.
  *
  *************************************************************/


 // MARKER(update_precomp.py): autogen include statement, do not remove
 #include "precompiled_sc.hxx"

 #ifdef SC_DLLIMPLEMENTATION
 #undef SC_DLLIMPLEMENTATION
 #endif


 #include "dpgroupdlg.hxx"
 #ifndef SC_DPGROUPDLG_HRC
 #include "dpgroupdlg.hrc"
 #endif

 #include "scresid.hxx"
 #ifndef SC_SC_HRC
 #include "sc.hrc"
 #endif

 #include "globstr.hrc"

 #include <com/sun/star/sheet/DataPilotFieldGroupBy.hpp>

 // ============================================================================

 namespace {

 /** Date part flags in order of the list box entries. */
 static const sal_Int32 spnDateParts[] =
 {
     com::sun::star::sheet::DataPilotFieldGroupBy::SECONDS,
     com::sun::star::sheet::DataPilotFieldGroupBy::MINUTES,
     com::sun::star::sheet::DataPilotFieldGroupBy::HOURS,
     com::sun::star::sheet::DataPilotFieldGroupBy::DAYS,
     com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS,
     com::sun::star::sheet::DataPilotFieldGroupBy::QUARTERS,
     com::sun::star::sheet::DataPilotFieldGroupBy::YEARS
 };

 static const sal_uInt16 nDatePartResIds[] =
 {
     STR_DPFIELD_GROUP_BY_SECONDS,
     STR_DPFIELD_GROUP_BY_MINUTES,
     STR_DPFIELD_GROUP_BY_HOURS,
     STR_DPFIELD_GROUP_BY_DAYS,
     STR_DPFIELD_GROUP_BY_MONTHS,
     STR_DPFIELD_GROUP_BY_QUARTERS,
     STR_DPFIELD_GROUP_BY_YEARS
 };

 } // namespace

 // ============================================================================

 ScDPGroupEditHelper::ScDPGroupEditHelper( RadioButton& rRbAuto, RadioButton& rRbMan, Edit& rEdValue ) :
     mrRbAuto( rRbAuto ),
     mrRbMan( rRbMan ),
     mrEdValue( rEdValue )
 {
     mrRbAuto.SetClickHdl( LINK( this, ScDPGroupEditHelper, ClickHdl ) );
     mrRbMan.SetClickHdl( LINK( this, ScDPGroupEditHelper, ClickHdl ) );
 }

 bool ScDPGroupEditHelper::IsAuto() const
 {
     return mrRbAuto.IsChecked();
 }

 double ScDPGroupEditHelper::GetValue() const
 {
     double fValue;
     if( !ImplGetValue( fValue ) )
         fValue = 0.0;
     return fValue;
 }

 void ScDPGroupEditHelper::SetValue( bool bAuto, double fValue )
 {
     if( bAuto )
     {
         mrRbAuto.Check();
         ClickHdl( &mrRbAuto );
     }
     else
     {
         mrRbMan.Check();
         ClickHdl( &mrRbMan );
     }
     ImplSetValue( fValue );
 }

 IMPL_LINK( ScDPGroupEditHelper, ClickHdl, RadioButton*, pButton )
 {
     if( pButton == &mrRbAuto )
     {
         // disable edit field on clicking "automatic" radio button
         mrEdValue.Disable();
     }
     else if( pButton == &mrRbMan )
     {
         // enable and set focus to edit field on clicking "manual" radio button
         mrEdValue.Enable();
         mrEdValue.GrabFocus();
     }
     return 0;
 }

 // ----------------------------------------------------------------------------

 ScDPNumGroupEditHelper::ScDPNumGroupEditHelper(
         RadioButton& rRbAuto, RadioButton& rRbMan, ScDoubleField& rEdValue ) :
     ScDPGroupEditHelper( rRbAuto, rRbMan, rEdValue ),
     mrEdValue( rEdValue )
 {
 }

 bool ScDPNumGroupEditHelper::ImplGetValue( double& rfValue ) const
 {
     return mrEdValue.GetValue( rfValue );
 }

 void ScDPNumGroupEditHelper::ImplSetValue( double fValue )
 {
     mrEdValue.SetValue( fValue );
 }

 // ----------------------------------------------------------------------------

 ScDPDateGroupEditHelper::ScDPDateGroupEditHelper(
         RadioButton& rRbAuto, RadioButton& rRbMan, DateField& rEdValue, const Date& rNullDate ) :
     ScDPGroupEditHelper( rRbAuto, rRbMan, rEdValue ),
     mrEdValue( rEdValue ),
     maNullDate( rNullDate )
 {
 }

 bool ScDPDateGroupEditHelper::ImplGetValue( double& rfValue ) const
 {
     rfValue = mrEdValue.GetDate() - maNullDate;
     return true;
 }

 void ScDPDateGroupEditHelper::ImplSetValue( double fValue )
 {
     Date aDate( maNullDate );
     aDate += static_cast< sal_Int32 >( fValue );
     mrEdValue.SetDate( aDate );
 }

 // ============================================================================
 // ============================================================================

 ScDPNumGroupDlg::ScDPNumGroupDlg( Window* pParent, const ScDPNumGroupInfo& rInfo ) :
     ModalDialog     ( pParent, ScResId( RID_SCDLG_DPNUMGROUP ) ),
     maFlStart       ( this, ScResId( FL_START ) ),
     maRbAutoStart   ( this, ScResId( RB_AUTOSTART ) ),
     maRbManStart    ( this, ScResId( RB_MANSTART ) ),
     maEdStart       ( this, ScResId( ED_START ) ),
     maFlEnd         ( this, ScResId( FL_END ) ),
     maRbAutoEnd     ( this, ScResId( RB_AUTOEND ) ),
     maRbManEnd      ( this, ScResId( RB_MANEND ) ),
     maEdEnd         ( this, ScResId( ED_END ) ),
     maFlBy          ( this, ScResId( FL_BY ) ),
     maEdBy          ( this, ScResId( ED_BY ) ),
     maBtnOk         ( this, ScResId( BTN_OK ) ),
     maBtnCancel     ( this, ScResId( BTN_CANCEL ) ),
     maBtnHelp       ( this, ScResId( BTN_HELP ) ),
     maStartHelper   ( maRbAutoStart, maRbManStart, maEdStart ),
     maEndHelper     ( maRbAutoEnd, maRbManEnd, maEdEnd )
 {
     FreeResource();

     maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start );
     maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End );
     maEdBy.SetValue( (rInfo.Step <= 0.0) ? 1.0 : rInfo.Step );

     /*  Set the initial focus, currently it is somewhere after calling all the radio
         button click handlers. Now the first enabled editable control is focused. */
     if( maEdStart.IsEnabled() )
         maEdStart.GrabFocus();
     else if( maEdEnd.IsEnabled() )
         maEdEnd.GrabFocus();
     else
         maEdBy.GrabFocus();
 }

 ScDPNumGroupInfo ScDPNumGroupDlg::GetGroupInfo() const
 {
     ScDPNumGroupInfo aInfo;
     aInfo.Enable = sal_True;
     aInfo.DateValues = sal_False;
     aInfo.AutoStart = maStartHelper.IsAuto();
     aInfo.AutoEnd = maEndHelper.IsAuto();

     // get values and silently auto-correct them, if they are not valid
     // TODO: error messages in OK event?
     aInfo.Start = maStartHelper.GetValue();
     aInfo.End = maEndHelper.GetValue();
     if( !maEdBy.GetValue( aInfo.Step ) || (aInfo.Step <= 0.0) )
         aInfo.Step = 1.0;
     if( aInfo.End <= aInfo.Start )
         aInfo.End = aInfo.Start + aInfo.Step;

     return aInfo;
 }

 // ============================================================================

 ScDPDateGroupDlg::ScDPDateGroupDlg( Window* pParent,
         const ScDPNumGroupInfo& rInfo, sal_Int32 nDatePart, const Date& rNullDate ) :
     ModalDialog     ( pParent, ScResId( RID_SCDLG_DPDATEGROUP ) ),
     maFlStart       ( this, ScResId( FL_START ) ),
     maRbAutoStart   ( this, ScResId( RB_AUTOSTART ) ),
     maRbManStart    ( this, ScResId( RB_MANSTART ) ),
     maEdStart       ( this, ScResId( ED_START ) ),
     maFlEnd         ( this, ScResId( FL_END ) ),
     maRbAutoEnd     ( this, ScResId( RB_AUTOEND ) ),
     maRbManEnd      ( this, ScResId( RB_MANEND ) ),
     maEdEnd         ( this, ScResId( ED_END ) ),
     maFlBy          ( this, ScResId( FL_BY ) ),
     maRbNumDays     ( this, ScResId( RB_NUMDAYS ) ),
     maRbUnits       ( this, ScResId( RB_UNITS ) ),
     maEdNumDays     ( this, ScResId( ED_NUMDAYS ) ),
     maLbUnits       ( this, ScResId( LB_UNITS ) ),
     maBtnOk         ( this, ScResId( BTN_OK ) ),
     maBtnCancel     ( this, ScResId( BTN_CANCEL ) ),
     maBtnHelp       ( this, ScResId( BTN_HELP ) ),
     maStartHelper   ( maRbAutoStart, maRbManStart, maEdStart, rNullDate ),
     maEndHelper     ( maRbAutoEnd, maRbManEnd, maEdEnd, rNullDate )
 {
     FreeResource();

     maLbUnits.SetHelpId( HID_SC_DPDATEGROUP_LB );

     static const size_t nCount = sizeof( nDatePartResIds ) / sizeof( nDatePartResIds[0] );
     for( size_t nIdx = 0 ; nIdx < nCount; ++nIdx )
         maLbUnits.InsertEntry( ScGlobal::GetRscString( nDatePartResIds[nIdx] ) );

     maEdStart.SetShowDateCentury( sal_True );
     maEdEnd.SetShowDateCentury( sal_True );

     maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start );
     maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End );

     if( nDatePart == 0 )
         nDatePart = com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS;
     for( size_t nIdx = 0; nIdx < nCount; ++nIdx )
         maLbUnits.CheckEntryPos( static_cast< sal_uInt16 >( nIdx ), (nDatePart & spnDateParts[ nIdx ]) != 0 );

     if( rInfo.DateValues )
     {
         maRbNumDays.Check();
         ClickHdl( &maRbNumDays );

         double fNumDays = rInfo.Step;
         if( fNumDays < 1.0 )
             fNumDays = 1.0;
         else if( fNumDays > 32767.0 )
             fNumDays = 32767.0;
         maEdNumDays.SetValue( static_cast< long >( fNumDays ) );
     }
     else
     {
         maRbUnits.Check();
         ClickHdl( &maRbUnits );
     }

     /*  Set the initial focus, currently it is somewhere after calling all the radio
         button click handlers. Now the first enabled editable control is focused. */
     if( maEdStart.IsEnabled() )
         maEdStart.GrabFocus();
     else if( maEdEnd.IsEnabled() )
         maEdEnd.GrabFocus();
     else if( maEdNumDays.IsEnabled() )
         maEdNumDays.GrabFocus();
     else if( maLbUnits.IsEnabled() )
         maLbUnits.GrabFocus();

     maRbNumDays.SetClickHdl( LINK( this, ScDPDateGroupDlg, ClickHdl ) );
     maRbUnits.SetClickHdl( LINK( this, ScDPDateGroupDlg, ClickHdl ) );
     maLbUnits.SetCheckButtonHdl( LINK( this, ScDPDateGroupDlg, CheckHdl ) );
 }

 ScDPNumGroupInfo ScDPDateGroupDlg::GetGroupInfo() const
 {
     ScDPNumGroupInfo aInfo;
     aInfo.Enable = sal_True;
     aInfo.DateValues = maRbNumDays.IsChecked();
     aInfo.AutoStart = maStartHelper.IsAuto();
     aInfo.AutoEnd = maEndHelper.IsAuto();

     // get values and silently auto-correct them, if they are not valid
     // TODO: error messages in OK event?
     aInfo.Start = maStartHelper.GetValue();
     aInfo.End = maEndHelper.GetValue();
     sal_Int64 nNumDays = maEdNumDays.GetValue();
     aInfo.Step = static_cast<double>( aInfo.DateValues ? nNumDays : 0L );
     if( aInfo.End <= aInfo.Start )
         aInfo.End = aInfo.Start + nNumDays;

     return aInfo;
 }

 sal_Int32 ScDPDateGroupDlg::GetDatePart() const
 {
     // return DAYS for special "number of days" mode
     if( maRbNumDays.IsChecked() )
         return com::sun::star::sheet::DataPilotFieldGroupBy::DAYS;

     // return listbox contents for "units" mode
     sal_Int32 nDatePart = 0;
     for( sal_uLong nIdx = 0, nCount = maLbUnits.GetEntryCount(); nIdx < nCount; ++nIdx )
         if( maLbUnits.IsChecked( static_cast< sal_uInt16 >( nIdx ) ) )
             nDatePart |= spnDateParts[ nIdx ];
     return nDatePart;
 }

 IMPL_LINK( ScDPDateGroupDlg, ClickHdl, RadioButton*, pButton )
 {
     if( pButton == &maRbNumDays )
     {
         maLbUnits.Disable();
         // enable and set focus to edit field on clicking "num of days" radio button
         maEdNumDays.Enable();
         maEdNumDays.GrabFocus();
         maBtnOk.Enable();
     }
     else if( pButton == &maRbUnits )
     {
         maEdNumDays.Disable();
         // enable and set focus to listbox on clicking "units" radio button
         maLbUnits.Enable();
         maLbUnits.GrabFocus();
         // disable OK button if no date part selected
         CheckHdl( &maLbUnits );
     }
     return 0;
 }

 IMPL_LINK( ScDPDateGroupDlg, CheckHdl, SvxCheckListBox*, pListBox )
 {
     // enable/disable OK button on modifying check list box
     if( pListBox == &maLbUnits )
         maBtnOk.Enable( maLbUnits.GetCheckedEntryCount() > 0 );
     return 0;
 }

 // ============================================================================
	/**************************************************************
	*
	* Licensed to the Apache Software Foundation (ASF) under one
	* or more contributor license agreements. See the NOTICE file
	* distributed with this work for additional information
	* regarding copyright ownership. The ASF licenses this file
	* to you under the Apache License, Version 2.0 (the
	* "License"); you may not use this file except in compliance
	* with the License. You may obtain a copy of the License at
	*
	* http://www.apache.org/licenses/LICENSE-2.0
	*
	* Unless required by applicable law or agreed to in writing,
	* software distributed under the License is distributed on an
	* "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
	* KIND, either express or implied. See the License for the
	* specific language governing permissions and limitations
	* under the License.
	*
	*************************************************************/



	// MARKER(update_precomp.py): autogen include statement, do not remove
	#include "precompiled_sc.hxx"

	#ifdef SC_DLLIMPLEMENTATION
	#undef SC_DLLIMPLEMENTATION
	#endif


	#include "dpgroupdlg.hxx"
	#ifndef SC_DPGROUPDLG_HRC
	#include "dpgroupdlg.hrc"
	#endif

	#include "scresid.hxx"
	#ifndef SC_SC_HRC
	#include "sc.hrc"
	#endif

	#include "globstr.hrc"

	#include <com/sun/star/sheet/DataPilotFieldGroupBy.hpp>

	// ============================================================================

	namespace {

	/** Date part flags in order of the list box entries. */
	static const sal_Int32 spnDateParts[] =
	{
	com::sun::star::sheet::DataPilotFieldGroupBy::SECONDS,
	com::sun::star::sheet::DataPilotFieldGroupBy::MINUTES,
	com::sun::star::sheet::DataPilotFieldGroupBy::HOURS,
	com::sun::star::sheet::DataPilotFieldGroupBy::DAYS,
	com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS,
	com::sun::star::sheet::DataPilotFieldGroupBy::QUARTERS,
	com::sun::star::sheet::DataPilotFieldGroupBy::YEARS
	};

	static const sal_uInt16 nDatePartResIds[] =
	{
	STR_DPFIELD_GROUP_BY_SECONDS,
	STR_DPFIELD_GROUP_BY_MINUTES,
	STR_DPFIELD_GROUP_BY_HOURS,
	STR_DPFIELD_GROUP_BY_DAYS,
	STR_DPFIELD_GROUP_BY_MONTHS,
	STR_DPFIELD_GROUP_BY_QUARTERS,
	STR_DPFIELD_GROUP_BY_YEARS
	};

	} // namespace

	// ============================================================================

	ScDPGroupEditHelper::ScDPGroupEditHelper( RadioButton& rRbAuto, RadioButton& rRbMan, Edit& rEdValue ) :
	mrRbAuto( rRbAuto ),
	mrRbMan( rRbMan ),
	mrEdValue( rEdValue )
	{
	mrRbAuto.SetClickHdl( LINK( this, ScDPGroupEditHelper, ClickHdl ) );
	mrRbMan.SetClickHdl( LINK( this, ScDPGroupEditHelper, ClickHdl ) );
	}

	bool ScDPGroupEditHelper::IsAuto() const
	{
	return mrRbAuto.IsChecked();
	}

	double ScDPGroupEditHelper::GetValue() const
	{
	double fValue;
	if( !ImplGetValue( fValue ) )
	fValue = 0.0;
	return fValue;
	}

	void ScDPGroupEditHelper::SetValue( bool bAuto, double fValue )
	{
	if( bAuto )
	{
	mrRbAuto.Check();
	ClickHdl( &mrRbAuto );
	}
	else
	{
	mrRbMan.Check();
	ClickHdl( &mrRbMan );
	}
	ImplSetValue( fValue );
	}

	IMPL_LINK( ScDPGroupEditHelper, ClickHdl, RadioButton*, pButton )
	{
	if( pButton == &mrRbAuto )
	{
	// disable edit field on clicking "automatic" radio button
	mrEdValue.Disable();
	}
	else if( pButton == &mrRbMan )
	{
	// enable and set focus to edit field on clicking "manual" radio button
	mrEdValue.Enable();
	mrEdValue.GrabFocus();
	}
	return 0;
	}

	// ----------------------------------------------------------------------------

	ScDPNumGroupEditHelper::ScDPNumGroupEditHelper(
	RadioButton& rRbAuto, RadioButton& rRbMan, ScDoubleField& rEdValue ) :
	ScDPGroupEditHelper( rRbAuto, rRbMan, rEdValue ),
	mrEdValue( rEdValue )
	{
	}

	bool ScDPNumGroupEditHelper::ImplGetValue( double& rfValue ) const
	{
	return mrEdValue.GetValue( rfValue );
	}

	void ScDPNumGroupEditHelper::ImplSetValue( double fValue )
	{
	mrEdValue.SetValue( fValue );
	}

	// ----------------------------------------------------------------------------

	ScDPDateGroupEditHelper::ScDPDateGroupEditHelper(
	RadioButton& rRbAuto, RadioButton& rRbMan, DateField& rEdValue, const Date& rNullDate ) :
	ScDPGroupEditHelper( rRbAuto, rRbMan, rEdValue ),
	mrEdValue( rEdValue ),
	maNullDate( rNullDate )
	{
	}

	bool ScDPDateGroupEditHelper::ImplGetValue( double& rfValue ) const
	{
	rfValue = mrEdValue.GetDate() - maNullDate;
	return true;
	}

	void ScDPDateGroupEditHelper::ImplSetValue( double fValue )
	{
	Date aDate( maNullDate );
	aDate += static_cast< sal_Int32 >( fValue );
	mrEdValue.SetDate( aDate );
	}

	// ============================================================================
	// ============================================================================

	ScDPNumGroupDlg::ScDPNumGroupDlg( Window* pParent, const ScDPNumGroupInfo& rInfo ) :
	ModalDialog ( pParent, ScResId( RID_SCDLG_DPNUMGROUP ) ),
	maFlStart ( this, ScResId( FL_START ) ),
	maRbAutoStart ( this, ScResId( RB_AUTOSTART ) ),
	maRbManStart ( this, ScResId( RB_MANSTART ) ),
	maEdStart ( this, ScResId( ED_START ) ),
	maFlEnd ( this, ScResId( FL_END ) ),
	maRbAutoEnd ( this, ScResId( RB_AUTOEND ) ),
	maRbManEnd ( this, ScResId( RB_MANEND ) ),
	maEdEnd ( this, ScResId( ED_END ) ),
	maFlBy ( this, ScResId( FL_BY ) ),
	maEdBy ( this, ScResId( ED_BY ) ),
	maBtnOk ( this, ScResId( BTN_OK ) ),
	maBtnCancel ( this, ScResId( BTN_CANCEL ) ),
	maBtnHelp ( this, ScResId( BTN_HELP ) ),
	maStartHelper ( maRbAutoStart, maRbManStart, maEdStart ),
	maEndHelper ( maRbAutoEnd, maRbManEnd, maEdEnd )
	{
	FreeResource();

	maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start );
	maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End );
	maEdBy.SetValue( (rInfo.Step <= 0.0) ? 1.0 : rInfo.Step );

	/* Set the initial focus, currently it is somewhere after calling all the radio
	button click handlers. Now the first enabled editable control is focused. */
	if( maEdStart.IsEnabled() )
	maEdStart.GrabFocus();
	else if( maEdEnd.IsEnabled() )
	maEdEnd.GrabFocus();
	else
	maEdBy.GrabFocus();
	}

	ScDPNumGroupInfo ScDPNumGroupDlg::GetGroupInfo() const
	{
	ScDPNumGroupInfo aInfo;
	aInfo.Enable = sal_True;
	aInfo.DateValues = sal_False;
	aInfo.AutoStart = maStartHelper.IsAuto();
	aInfo.AutoEnd = maEndHelper.IsAuto();

	// get values and silently auto-correct them, if they are not valid
	// TODO: error messages in OK event?
	aInfo.Start = maStartHelper.GetValue();
	aInfo.End = maEndHelper.GetValue();
	if( !maEdBy.GetValue( aInfo.Step ) \|\| (aInfo.Step <= 0.0) )
	aInfo.Step = 1.0;
	if( aInfo.End <= aInfo.Start )
	aInfo.End = aInfo.Start + aInfo.Step;

	return aInfo;
	}

	// ============================================================================

	ScDPDateGroupDlg::ScDPDateGroupDlg( Window* pParent,
	const ScDPNumGroupInfo& rInfo, sal_Int32 nDatePart, const Date& rNullDate ) :
	ModalDialog ( pParent, ScResId( RID_SCDLG_DPDATEGROUP ) ),
	maFlStart ( this, ScResId( FL_START ) ),
	maRbAutoStart ( this, ScResId( RB_AUTOSTART ) ),
	maRbManStart ( this, ScResId( RB_MANSTART ) ),
	maEdStart ( this, ScResId( ED_START ) ),
	maFlEnd ( this, ScResId( FL_END ) ),
	maRbAutoEnd ( this, ScResId( RB_AUTOEND ) ),
	maRbManEnd ( this, ScResId( RB_MANEND ) ),
	maEdEnd ( this, ScResId( ED_END ) ),
	maFlBy ( this, ScResId( FL_BY ) ),
	maRbNumDays ( this, ScResId( RB_NUMDAYS ) ),
	maRbUnits ( this, ScResId( RB_UNITS ) ),
	maEdNumDays ( this, ScResId( ED_NUMDAYS ) ),
	maLbUnits ( this, ScResId( LB_UNITS ) ),
	maBtnOk ( this, ScResId( BTN_OK ) ),
	maBtnCancel ( this, ScResId( BTN_CANCEL ) ),
	maBtnHelp ( this, ScResId( BTN_HELP ) ),
	maStartHelper ( maRbAutoStart, maRbManStart, maEdStart, rNullDate ),
	maEndHelper ( maRbAutoEnd, maRbManEnd, maEdEnd, rNullDate )
	{
	FreeResource();

	maLbUnits.SetHelpId( HID_SC_DPDATEGROUP_LB );

	static const size_t nCount = sizeof( nDatePartResIds ) / sizeof( nDatePartResIds[0] );
	for( size_t nIdx = 0 ; nIdx < nCount; ++nIdx )
	maLbUnits.InsertEntry( ScGlobal::GetRscString( nDatePartResIds[nIdx] ) );

	maEdStart.SetShowDateCentury( sal_True );
	maEdEnd.SetShowDateCentury( sal_True );

	maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start );
	maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End );

	if( nDatePart == 0 )
	nDatePart = com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS;
	for( size_t nIdx = 0; nIdx < nCount; ++nIdx )
	maLbUnits.CheckEntryPos( static_cast< sal_uInt16 >( nIdx ), (nDatePart & spnDateParts[ nIdx ]) != 0 );

	if( rInfo.DateValues )
	{
	maRbNumDays.Check();
	ClickHdl( &maRbNumDays );

	double fNumDays = rInfo.Step;
	if( fNumDays < 1.0 )
	fNumDays = 1.0;
	else if( fNumDays > 32767.0 )
	fNumDays = 32767.0;
	maEdNumDays.SetValue( static_cast< long >( fNumDays ) );
	}
	else
	{
	maRbUnits.Check();
	ClickHdl( &maRbUnits );
	}

	/* Set the initial focus, currently it is somewhere after calling all the radio
	button click handlers. Now the first enabled editable control is focused. */
	if( maEdStart.IsEnabled() )
	maEdStart.GrabFocus();
	else if( maEdEnd.IsEnabled() )
	maEdEnd.GrabFocus();
	else if( maEdNumDays.IsEnabled() )
	maEdNumDays.GrabFocus();
	else if( maLbUnits.IsEnabled() )
	maLbUnits.GrabFocus();

	maRbNumDays.SetClickHdl( LINK( this, ScDPDateGroupDlg, ClickHdl ) );
	maRbUnits.SetClickHdl( LINK( this, ScDPDateGroupDlg, ClickHdl ) );
	maLbUnits.SetCheckButtonHdl( LINK( this, ScDPDateGroupDlg, CheckHdl ) );
	}

	ScDPNumGroupInfo ScDPDateGroupDlg::GetGroupInfo() const
	{
	ScDPNumGroupInfo aInfo;
	aInfo.Enable = sal_True;
	aInfo.DateValues = maRbNumDays.IsChecked();
	aInfo.AutoStart = maStartHelper.IsAuto();
	aInfo.AutoEnd = maEndHelper.IsAuto();

	// get values and silently auto-correct them, if they are not valid
	// TODO: error messages in OK event?
	aInfo.Start = maStartHelper.GetValue();
	aInfo.End = maEndHelper.GetValue();
	sal_Int64 nNumDays = maEdNumDays.GetValue();
	aInfo.Step = static_cast<double>( aInfo.DateValues ? nNumDays : 0L );
	if( aInfo.End <= aInfo.Start )
	aInfo.End = aInfo.Start + nNumDays;

	return aInfo;
	}

	sal_Int32 ScDPDateGroupDlg::GetDatePart() const
	{
	// return DAYS for special "number of days" mode
	if( maRbNumDays.IsChecked() )
	return com::sun::star::sheet::DataPilotFieldGroupBy::DAYS;

	// return listbox contents for "units" mode
	sal_Int32 nDatePart = 0;
	for( sal_uLong nIdx = 0, nCount = maLbUnits.GetEntryCount(); nIdx < nCount; ++nIdx )
	if( maLbUnits.IsChecked( static_cast< sal_uInt16 >( nIdx ) ) )
	nDatePart \|= spnDateParts[ nIdx ];
	return nDatePart;
	}

	IMPL_LINK( ScDPDateGroupDlg, ClickHdl, RadioButton*, pButton )
	{
	if( pButton == &maRbNumDays )
	{
	maLbUnits.Disable();
	// enable and set focus to edit field on clicking "num of days" radio button
	maEdNumDays.Enable();
	maEdNumDays.GrabFocus();
	maBtnOk.Enable();
	}
	else if( pButton == &maRbUnits )
	{
	maEdNumDays.Disable();
	// enable and set focus to listbox on clicking "units" radio button
	maLbUnits.Enable();
	maLbUnits.GrabFocus();
	// disable OK button if no date part selected
	CheckHdl( &maLbUnits );
	}
	return 0;
	}

	IMPL_LINK( ScDPDateGroupDlg, CheckHdl, SvxCheckListBox*, pListBox )
	{
	// enable/disable OK button on modifying check list box
	if( pListBox == &maLbUnits )
	maBtnOk.Enable( maLbUnits.GetCheckedEntryCount() > 0 );
	return 0;
	}

	// ============================================================================