diff options
Diffstat (limited to 'sc/source/ui/dbgui/dpgroupdlg.cxx')
| -rw-r--r-- | sc/source/ui/dbgui/dpgroupdlg.cxx | 360 |
1 files changed, 360 insertions, 0 deletions
diff --git a/sc/source/ui/dbgui/dpgroupdlg.cxx b/sc/source/ui/dbgui/dpgroupdlg.cxx new file mode 100644 index 000000000000..4ac3fb8d68ad --- /dev/null +++ b/sc/source/ui/dbgui/dpgroupdlg.cxx @@ -0,0 +1,360 @@ +/************************************************************************* + * + * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER. + * + * Copyright 2000, 2010 Oracle and/or its affiliates. + * + * OpenOffice.org - a multi-platform office productivity suite + * + * This file is part of OpenOffice.org. + * + * OpenOffice.org is free software: you can redistribute it and/or modify + * it under the terms of the GNU Lesser General Public License version 3 + * only, as published by the Free Software Foundation. + * + * OpenOffice.org is distributed in the hope that it will be useful, + * but WITHOUT ANY WARRANTY; without even the implied warranty of + * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + * GNU Lesser General Public License version 3 for more details + * (a copy is included in the LICENSE file that accompanied this code). + * + * You should have received a copy of the GNU Lesser General Public License + * version 3 along with OpenOffice.org. If not, see + * <http://www.openoffice.org/license.html> + * for a copy of the LGPLv3 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 <tools/resary.hxx> +#include "scresid.hxx" +#ifndef SC_SC_HRC +#include "sc.hrc" +#endif +#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 +}; + +} // 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 ) +{ + maLbUnits.SetHelpId( HID_SC_DPDATEGROUP_LB ); + ResStringArray aArr( ScResId( STR_UNITS ) ); + for( USHORT nIdx = 0, nCount = sal::static_int_cast<USHORT>(aArr.Count()); nIdx < nCount; ++nIdx ) + maLbUnits.InsertEntry( aArr.GetString( nIdx ) ); + + FreeResource(); + + maEdStart.SetShowDateCentury( TRUE ); + maEdEnd.SetShowDateCentury( TRUE ); + + maStartHelper.SetValue( rInfo.AutoStart, rInfo.Start ); + maEndHelper.SetValue( rInfo.AutoEnd, rInfo.End ); + + if( nDatePart == 0 ) + nDatePart = com::sun::star::sheet::DataPilotFieldGroupBy::MONTHS; + for( ULONG nIdx = 0, nCount = maLbUnits.GetEntryCount(); nIdx < nCount; ++nIdx ) + maLbUnits.CheckEntryPos( static_cast< USHORT >( 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( ULONG nIdx = 0, nCount = maLbUnits.GetEntryCount(); nIdx < nCount; ++nIdx ) + if( maLbUnits.IsChecked( static_cast< USHORT >( 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; +} + +// ============================================================================ + |