diff options
author | Caolán McNamara <caolanm@redhat.com> | 2013-05-16 10:53:38 +0100 |
---|---|---|
committer | Caolán McNamara <caolanm@redhat.com> | 2013-05-16 14:33:39 +0100 |
commit | 28ca8eeee8898c5cd3730ebfcbbf303b68d25150 (patch) | |
tree | efa12414a9e353b1134466534cf23af9b85a17c9 /sc | |
parent | 35f846ffea29943729de98ae8d50adf4d82c4aa0 (diff) |
Resolves: #i117782# convert calculate page to .ui format
Change-Id: Iab0028ad1bfd8a841a3cf87aadbe0dc9d9ad830e
Diffstat (limited to 'sc')
-rw-r--r-- | sc/UIConfig_scalc.mk | 1 | ||||
-rw-r--r-- | sc/inc/helpids.h | 1 | ||||
-rw-r--r-- | sc/source/ui/cctrl/editfield.cxx | 12 | ||||
-rw-r--r-- | sc/source/ui/inc/editfield.hxx | 1 | ||||
-rw-r--r-- | sc/source/ui/inc/optdlg.hrc | 21 | ||||
-rw-r--r-- | sc/source/ui/inc/tpcalc.hxx | 44 | ||||
-rw-r--r-- | sc/source/ui/optdlg/tpcalc.cxx | 158 | ||||
-rw-r--r-- | sc/source/ui/src/optdlg.src | 147 | ||||
-rw-r--r-- | sc/uiconfig/scalc/ui/optcalculatepage.ui | 429 |
9 files changed, 535 insertions, 279 deletions
diff --git a/sc/UIConfig_scalc.mk b/sc/UIConfig_scalc.mk index 40a7160c1e67..1f77cdd0e521 100644 --- a/sc/UIConfig_scalc.mk +++ b/sc/UIConfig_scalc.mk @@ -78,6 +78,7 @@ $(eval $(call gb_UIConfig_add_uifiles,modules/scalc,\ sc/uiconfig/scalc/ui/leftfooterdialog \ sc/uiconfig/scalc/ui/leftheaderdialog \ sc/uiconfig/scalc/ui/managenamesdialog \ + sc/uiconfig/scalc/ui/optcalculatepage \ sc/uiconfig/scalc/ui/printeroptions \ sc/uiconfig/scalc/ui/protectsheetdlg \ sc/uiconfig/scalc/ui/sheetprintpage \ diff --git a/sc/inc/helpids.h b/sc/inc/helpids.h index e94b67fbc36a..5a3d02894615 100644 --- a/sc/inc/helpids.h +++ b/sc/inc/helpids.h @@ -60,7 +60,6 @@ #define HID_SC_PIVOTSUBT "SC_HID_SC_PIVOTSUBT" #define HID_SCPAGE_SUBT_OPTIONS "SC_HID_SCPAGE_SUBT_OPTIONS" #define HID_SCPAGE_SUBT_GROUP "SC_HID_SCPAGE_SUBT_GROUP" -#define HID_SCPAGE_CALC "SC_HID_SCPAGE_CALC" #define HID_SCPAGE_FORMULA "SC_HID_SCPAGE_FORMULA" #define HID_SCPAGE_USERLISTS "SC_HID_SCPAGE_USERLISTS" #define HID_SCPAGE_AREAS "SC_HID_SCPAGE_AREAS" diff --git a/sc/source/ui/cctrl/editfield.cxx b/sc/source/ui/cctrl/editfield.cxx index 71abbf914955..481eef06571a 100644 --- a/sc/source/ui/cctrl/editfield.cxx +++ b/sc/source/ui/cctrl/editfield.cxx @@ -25,6 +25,7 @@ #include <comphelper/string.hxx> #include <rtl/math.hxx> #include <unotools/localedatawrapper.hxx> +#include <vcl/builder.hxx> #include "global.hxx" // ============================================================================ @@ -50,6 +51,17 @@ ScDoubleField::ScDoubleField( Window* pParent, const ResId& rResId ) : { } +ScDoubleField::ScDoubleField( Window* pParent, WinBits nStyle ) : + Edit( pParent, nStyle ) +{ +} + +extern "C" SAL_DLLPUBLIC_EXPORT Window* SAL_CALL makeScDoubleField(Window *pParent, VclBuilder::stringmap &rMap) +{ + VclBuilder::ensureDefaultWidthChars(rMap); + return new ScDoubleField(pParent, WB_LEFT|WB_VCENTER|WB_BORDER|WB_3DLOOK); +} + bool ScDoubleField::GetValue( double& rfValue ) const { OUString aStr(comphelper::string::strip(GetText(), ' ')); diff --git a/sc/source/ui/inc/editfield.hxx b/sc/source/ui/inc/editfield.hxx index aae8affce186..97aebe70fcec 100644 --- a/sc/source/ui/inc/editfield.hxx +++ b/sc/source/ui/inc/editfield.hxx @@ -29,6 +29,7 @@ class ScDoubleField : public Edit { public: explicit ScDoubleField( Window* pParent, const ResId& rResId ); + explicit ScDoubleField( Window* pParent, WinBits nStyle ); bool GetValue( double& rfValue ) const; void SetValue( double fValue, diff --git a/sc/source/ui/inc/optdlg.hrc b/sc/source/ui/inc/optdlg.hrc index 07fa080b8281..ad6034034f7b 100644 --- a/sc/source/ui/inc/optdlg.hrc +++ b/sc/source/ui/inc/optdlg.hrc @@ -30,27 +30,6 @@ #define TP_INPUT 13 #define TP_FORMULA 15 -// TP_CALC: -#define BTN_ITERATE 1 -#define FT_STEPS 2 -#define FT_EPS 3 -#define ED_STEPS 4 -#define ED_EPS 5 -#define GB_ZREFS 6 -#define ED_PREC 7 -#define FT_PREC 8 -#define BTN_DATESTD 9 -#define BTN_DATESC10 10 -#define BTN_DATE1904 11 -#define FT_VALUE 13 -#define GB_DATE 14 -#define BTN_CASE 15 -#define BTN_CALC 17 -#define BTN_MATCH 18 -#define BTN_LOOKUP 19 -#define BTN_REGEX 20 -#define BTN_GENERAL_PREC 21 - // TP_VIEW: #define BTN_GRID 6 diff --git a/sc/source/ui/inc/tpcalc.hxx b/sc/source/ui/inc/tpcalc.hxx index e566ab92ac16..645d98fb0405 100644 --- a/sc/source/ui/inc/tpcalc.hxx +++ b/sc/source/ui/inc/tpcalc.hxx @@ -48,34 +48,30 @@ private: ~ScTpCalcOptions(); private: - FixedLine aGbZRefs; - CheckBox aBtnIterate; - FixedText aFtSteps; - NumericField aEdSteps; - FixedText aFtEps; - ScDoubleField aEdEps; - - FixedLine aSeparatorFL; - FixedLine aGbDate; - RadioButton aBtnDateStd; - RadioButton aBtnDateSc10; - RadioButton aBtnDate1904; - - CheckBox aBtnCase; - CheckBox aBtnCalc; - CheckBox aBtnMatch; - CheckBox aBtnRegex; - CheckBox aBtnLookUp; - CheckBox aBtnGeneralPrec; - - FixedText aFtPrec; - NumericField aEdPrec; + CheckBox* m_pBtnIterate; + FixedText* m_pFtSteps; + NumericField* m_pEdSteps; + FixedText* m_pFtEps; + ScDoubleField* m_pEdEps; + + RadioButton* m_pBtnDateStd; + RadioButton* m_pBtnDateSc10; + RadioButton* m_pBtnDate1904; + + CheckBox* m_pBtnCase; + CheckBox* m_pBtnCalc; + CheckBox* m_pBtnMatch; + CheckBox* m_pBtnRegex; + CheckBox* m_pBtnLookUp; + CheckBox* m_pBtnGeneralPrec; + + FixedText* m_pFtPrec; + NumericField* m_pEdPrec; ScDocOptions* pOldOptions; ScDocOptions* pLocalOptions; sal_uInt16 nWhichCalc; -#ifdef _TPCALC_CXX private: void Init(); @@ -83,8 +79,6 @@ private: // Handler: DECL_LINK( RadioClickHdl, RadioButton* ); DECL_LINK( CheckClickHdl, CheckBox* ); - -#endif }; diff --git a/sc/source/ui/optdlg/tpcalc.cxx b/sc/source/ui/optdlg/tpcalc.cxx index 9a62e93bd10b..f47650123adf 100644 --- a/sc/source/ui/optdlg/tpcalc.cxx +++ b/sc/source/ui/optdlg/tpcalc.cxx @@ -34,50 +34,38 @@ #include "sc.hrc" // -> Slot-IDs #include "optdlg.hrc" -#define _TPCALC_CXX #include "tpcalc.hxx" -#undef _TPCALC_CXX #include <math.h> //======================================================================== -ScTpCalcOptions::ScTpCalcOptions( Window* pParent, - const SfxItemSet& rCoreAttrs ) - - : SfxTabPage ( pParent, - ScResId( RID_SCPAGE_CALC ), - rCoreAttrs ), - - aGbZRefs ( this, ScResId( GB_ZREFS ) ), - aBtnIterate ( this, ScResId( BTN_ITERATE ) ), - aFtSteps ( this, ScResId( FT_STEPS ) ), - aEdSteps ( this, ScResId( ED_STEPS ) ), - aFtEps ( this, ScResId( FT_EPS ) ), - aEdEps ( this, ScResId( ED_EPS ) ), - aSeparatorFL ( this, ScResId( FL_SEPARATOR ) ), - aGbDate ( this, ScResId( GB_DATE ) ), - aBtnDateStd ( this, ScResId( BTN_DATESTD ) ), - aBtnDateSc10 ( this, ScResId( BTN_DATESC10 ) ), - aBtnDate1904 ( this, ScResId( BTN_DATE1904 ) ), - aBtnCase ( this, ScResId( BTN_CASE ) ), - aBtnCalc ( this, ScResId( BTN_CALC ) ), - aBtnMatch ( this, ScResId( BTN_MATCH ) ), - aBtnRegex ( this, ScResId( BTN_REGEX ) ), - aBtnLookUp ( this, ScResId( BTN_LOOKUP ) ), - aBtnGeneralPrec ( this, ScResId( BTN_GENERAL_PREC ) ), - aFtPrec ( this, ScResId( FT_PREC ) ), - aEdPrec ( this, ScResId( ED_PREC ) ), - pOldOptions ( new ScDocOptions( - ((const ScTpCalcItem&)rCoreAttrs.Get( - GetWhich( SID_SCDOCOPTIONS ))). - GetDocOptions() ) ), - pLocalOptions ( new ScDocOptions ), - nWhichCalc ( GetWhich( SID_SCDOCOPTIONS ) ) +ScTpCalcOptions::ScTpCalcOptions(Window* pParent, const SfxItemSet& rCoreAttrs) + : SfxTabPage(pParent, "OptCalculatePage", + "modules/scalc/ui/optcalculatepage.ui", rCoreAttrs) + , pOldOptions(new ScDocOptions( + ((const ScTpCalcItem&)rCoreAttrs.Get( + GetWhich(SID_SCDOCOPTIONS))).GetDocOptions())) + , pLocalOptions(new ScDocOptions) + , nWhichCalc(GetWhich(SID_SCDOCOPTIONS)) { - aSeparatorFL.SetStyle( aSeparatorFL.GetStyle() | WB_VERT ); + get(m_pBtnIterate, "iterate"); + get(m_pFtSteps, "stepsft"); + get(m_pEdSteps, "steps"); + get(m_pFtEps, "minchangeft"); + get(m_pEdEps, "minchange"); + get(m_pBtnDateStd, "datestd"); + get(m_pBtnDateSc10, "datesc10"); + get(m_pBtnDate1904, "date1904"); + get(m_pBtnCase, "case"); + get(m_pBtnCalc, "calc"); + get(m_pBtnMatch, "match"); + get(m_pBtnRegex, "regex"); + get(m_pBtnLookUp, "lookup"); + get(m_pBtnGeneralPrec, "generalprec"); + get(m_pFtPrec, "precft"); + get(m_pEdPrec, "prec"); Init(); - FreeResource(); SetExchangeSupport(); } @@ -93,11 +81,11 @@ ScTpCalcOptions::~ScTpCalcOptions() void ScTpCalcOptions::Init() { - aBtnIterate .SetClickHdl( LINK( this, ScTpCalcOptions, CheckClickHdl ) ); - aBtnGeneralPrec.SetClickHdl( LINK(this, ScTpCalcOptions, CheckClickHdl) ); - aBtnDateStd .SetClickHdl( LINK( this, ScTpCalcOptions, RadioClickHdl ) ); - aBtnDateSc10.SetClickHdl( LINK( this, ScTpCalcOptions, RadioClickHdl ) ); - aBtnDate1904.SetClickHdl( LINK( this, ScTpCalcOptions, RadioClickHdl ) ); + m_pBtnIterate->SetClickHdl( LINK( this, ScTpCalcOptions, CheckClickHdl ) ); + m_pBtnGeneralPrec->SetClickHdl( LINK(this, ScTpCalcOptions, CheckClickHdl) ); + m_pBtnDateStd->SetClickHdl( LINK( this, ScTpCalcOptions, RadioClickHdl ) ); + m_pBtnDateSc10->SetClickHdl( LINK( this, ScTpCalcOptions, RadioClickHdl ) ); + m_pBtnDate1904->SetClickHdl( LINK( this, ScTpCalcOptions, RadioClickHdl ) ); } //----------------------------------------------------------------------- @@ -115,46 +103,46 @@ void ScTpCalcOptions::Reset( const SfxItemSet& /* rCoreAttrs */ ) *pLocalOptions = *pOldOptions; - aBtnCase .Check( !pLocalOptions->IsIgnoreCase() ); - aBtnCalc .Check( pLocalOptions->IsCalcAsShown() ); - aBtnMatch .Check( pLocalOptions->IsMatchWholeCell() ); - aBtnRegex .Check( pLocalOptions->IsFormulaRegexEnabled() ); - aBtnLookUp .Check( pLocalOptions->IsLookUpColRowNames() ); - aBtnIterate.Check( pLocalOptions->IsIter() ); - aEdSteps .SetValue( pLocalOptions->GetIterCount() ); - aEdEps .SetValue( pLocalOptions->GetIterEps(), 6 ); + m_pBtnCase->Check( !pLocalOptions->IsIgnoreCase() ); + m_pBtnCalc->Check( pLocalOptions->IsCalcAsShown() ); + m_pBtnMatch->Check( pLocalOptions->IsMatchWholeCell() ); + m_pBtnRegex->Check( pLocalOptions->IsFormulaRegexEnabled() ); + m_pBtnLookUp->Check( pLocalOptions->IsLookUpColRowNames() ); + m_pBtnIterate->Check( pLocalOptions->IsIter() ); + m_pEdSteps->SetValue( pLocalOptions->GetIterCount() ); + m_pEdEps->SetValue( pLocalOptions->GetIterEps(), 6 ); pLocalOptions->GetDate( d, m, y ); switch ( y ) { case 1899: - aBtnDateStd.Check(); + m_pBtnDateStd->Check(); break; case 1900: - aBtnDateSc10.Check(); + m_pBtnDateSc10->Check(); break; case 1904: - aBtnDate1904.Check(); + m_pBtnDate1904->Check(); break; } sal_uInt16 nPrec = pLocalOptions->GetStdPrecision(); if (nPrec == SvNumberFormatter::UNLIMITED_PRECISION) { - aFtPrec.Disable(); - aEdPrec.Disable(); - aBtnGeneralPrec.Check(false); + m_pFtPrec->Disable(); + m_pEdPrec->Disable(); + m_pBtnGeneralPrec->Check(false); } else { - aBtnGeneralPrec.Check(); - aFtPrec.Enable(); - aEdPrec.Enable(); - aEdPrec.SetValue(nPrec); + m_pBtnGeneralPrec->Check(); + m_pFtPrec->Enable(); + m_pEdPrec->Enable(); + m_pEdPrec->SetValue(nPrec); } - CheckClickHdl( &aBtnIterate ); + CheckClickHdl(m_pBtnIterate); } @@ -163,16 +151,16 @@ void ScTpCalcOptions::Reset( const SfxItemSet& /* rCoreAttrs */ ) sal_Bool ScTpCalcOptions::FillItemSet( SfxItemSet& rCoreAttrs ) { // alle weiteren Optionen werden in den Handlern aktualisiert - pLocalOptions->SetIterCount( (sal_uInt16)aEdSteps.GetValue() ); - pLocalOptions->SetIgnoreCase( !aBtnCase.IsChecked() ); - pLocalOptions->SetCalcAsShown( aBtnCalc.IsChecked() ); - pLocalOptions->SetMatchWholeCell( aBtnMatch.IsChecked() ); - pLocalOptions->SetFormulaRegexEnabled( aBtnRegex.IsChecked() ); - pLocalOptions->SetLookUpColRowNames( aBtnLookUp.IsChecked() ); - - if (aBtnGeneralPrec.IsChecked()) + pLocalOptions->SetIterCount( (sal_uInt16)m_pEdSteps->GetValue() ); + pLocalOptions->SetIgnoreCase( !m_pBtnCase->IsChecked() ); + pLocalOptions->SetCalcAsShown( m_pBtnCalc->IsChecked() ); + pLocalOptions->SetMatchWholeCell( m_pBtnMatch->IsChecked() ); + pLocalOptions->SetFormulaRegexEnabled( m_pBtnRegex->IsChecked() ); + pLocalOptions->SetLookUpColRowNames( m_pBtnLookUp->IsChecked() ); + + if (m_pBtnGeneralPrec->IsChecked()) pLocalOptions->SetStdPrecision( - static_cast<sal_uInt16>(aEdPrec.GetValue()) ); + static_cast<sal_uInt16>(m_pEdPrec->GetValue()) ); else pLocalOptions->SetStdPrecision( SvNumberFormatter::UNLIMITED_PRECISION ); @@ -192,7 +180,7 @@ int ScTpCalcOptions::DeactivatePage( SfxItemSet* pSetP ) int nReturn = KEEP_PAGE; double fEps; - if( aEdEps.GetValue( fEps ) && (fEps > 0.0) ) + if( m_pEdEps->GetValue( fEps ) && (fEps > 0.0) ) { pLocalOptions->SetIterEps( fEps ); nReturn = LEAVE_PAGE; @@ -205,7 +193,7 @@ int ScTpCalcOptions::DeactivatePage( SfxItemSet* pSetP ) ScGlobal::GetRscString( STR_INVALID_EPS ) ).Execute(); - aEdEps.GrabFocus(); + m_pEdEps->GrabFocus(); } else if ( pSetP ) FillItemSet( *pSetP ); @@ -218,15 +206,15 @@ int ScTpCalcOptions::DeactivatePage( SfxItemSet* pSetP ) IMPL_LINK( ScTpCalcOptions, RadioClickHdl, RadioButton*, pBtn ) { - if ( pBtn == &aBtnDateStd ) + if (pBtn == m_pBtnDateStd) { pLocalOptions->SetDate( 30, 12, 1899 ); } - else if ( pBtn == &aBtnDateSc10 ) + else if (pBtn == m_pBtnDateSc10) { pLocalOptions->SetDate( 1, 1, 1900 ); } - else if ( pBtn == &aBtnDate1904 ) + else if (pBtn == m_pBtnDate1904) { pLocalOptions->SetDate( 1, 1, 1904 ); } @@ -238,32 +226,32 @@ IMPL_LINK( ScTpCalcOptions, RadioClickHdl, RadioButton*, pBtn ) IMPL_LINK( ScTpCalcOptions, CheckClickHdl, CheckBox*, pBtn ) { - if (pBtn == &aBtnGeneralPrec) + if (pBtn == m_pBtnGeneralPrec) { if (pBtn->IsChecked()) { - aEdPrec.Enable(); - aFtPrec.Enable(); + m_pEdPrec->Enable(); + m_pFtPrec->Enable(); } else { - aEdPrec.Disable(); - aFtPrec.Disable(); + m_pEdPrec->Disable(); + m_pFtPrec->Disable(); } } - else if (pBtn == &aBtnIterate) + else if (pBtn == m_pBtnIterate) { if ( pBtn->IsChecked() ) { - pLocalOptions->SetIter( sal_True ); - aFtSteps.Enable(); aEdSteps.Enable(); - aFtEps .Enable(); aEdEps .Enable(); + pLocalOptions->SetIter( true ); + m_pFtSteps->Enable(); m_pEdSteps->Enable(); + m_pFtEps->Enable(); m_pEdEps->Enable(); } else { pLocalOptions->SetIter( false ); - aFtSteps.Disable(); aEdSteps.Disable(); - aFtEps .Disable(); aEdEps .Disable(); + m_pFtSteps->Disable(); m_pEdSteps->Disable(); + m_pFtEps->Disable(); m_pEdEps->Disable(); } } diff --git a/sc/source/ui/src/optdlg.src b/sc/source/ui/src/optdlg.src index c5bc6a668ff4..4621c13d7d45 100644 --- a/sc/source/ui/src/optdlg.src +++ b/sc/source/ui/src/optdlg.src @@ -18,153 +18,6 @@ */ #include "optdlg.hrc" -TabPage RID_SCPAGE_CALC -{ - HelpId = HID_SCPAGE_CALC ; - SVLook = TRUE ; - Hide = TRUE ; - Pos = MAP_APPFONT ( 0 , 0 ) ; - Size = MAP_APPFONT ( TP_WIDTH , TP_HEIGHT ) ; - CheckBox BTN_ITERATE - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_ITERATE"; - Pos = MAP_APPFONT ( 12 , 14 ) ; - Size = MAP_APPFONT ( 112 , 10 ) ; - Text [ en-US ] = "~Iterations" ; - }; - FixedText FT_STEPS - { - Pos = MAP_APPFONT ( 20 , 28 ) ; - Size = MAP_APPFONT ( 58 , 8 ) ; - Text [ en-US ] = "~Steps" ; - }; - FixedText FT_EPS - { - Pos = MAP_APPFONT ( 20 , 42 ) ; - Size = MAP_APPFONT ( 58 , 16 ) ; - Text [ en-US ] = "~Minimum Change" ; - WordBreak = TRUE ; - }; - NumericField ED_STEPS - { - HelpID = "sc:NumericField:RID_SCPAGE_CALC:ED_STEPS"; - Border = TRUE ; - Pos = MAP_APPFONT ( 82 , 26 ) ; - Size = MAP_APPFONT ( 42 , 12 ) ; - TabStop = TRUE ; - Minimum = 1 ; - Maximum = 1000 ; - Left = TRUE ; - }; - Edit ED_EPS - { - HelpID = "sc:Edit:RID_SCPAGE_CALC:ED_EPS"; - Border = TRUE ; - Pos = MAP_APPFONT ( 82 , 42 ) ; - Size = MAP_APPFONT ( 42 , 12 ) ; - }; - FixedLine GB_ZREFS - { - Pos = MAP_APPFONT ( 6 , 3 ) ; - Size = MAP_APPFONT ( 121 , 8 ) ; - Text [ en-US ] = "Iterative references" ; - }; - RadioButton BTN_DATESTD - { - HelpID = "sc:RadioButton:RID_SCPAGE_CALC:BTN_DATESTD"; - Pos = MAP_APPFONT ( 139 , 14 ) ; - Size = MAP_APPFONT ( 112 , 10 ) ; - Text [ en-US ] = "12/30/1899 (defa~ult)" ; - QuickHelpText [ en-US ] = "Value 0 corresponds to 12/30/1899" ; - }; - RadioButton BTN_DATESC10 - { - HelpID = "sc:RadioButton:RID_SCPAGE_CALC:BTN_DATESC10"; - Pos = MAP_APPFONT ( 139 , 28 ) ; - Size = MAP_APPFONT ( 112 , 10 ) ; - Text [ en-US ] = "01/01/1900 (Star~Calc 1.0)" ; - QuickHelpText [ en-US ] = "Value 0 corresponds to 01/01/1900" ; - }; - RadioButton BTN_DATE1904 - { - HelpID = "sc:RadioButton:RID_SCPAGE_CALC:BTN_DATE1904"; - Pos = MAP_APPFONT ( 139 , 42 ) ; - Size = MAP_APPFONT ( 112 , 10 ) ; - Text [ en-US ] = "~01/01/1904" ; - QuickHelpText [ en-US ] = "0 corresponds to 01/01/1904" ; - }; - FixedLine FL_SEPARATOR - { - Pos = MAP_APPFONT ( 130 , 14 ) ; - Size = MAP_APPFONT ( 1 , 44 ) ; - }; - FixedLine GB_DATE - { - Pos = MAP_APPFONT ( 133 , 3 ) ; - Size = MAP_APPFONT ( 121 , 8 ) ; - Text [ en-US ] = "Date" ; - }; - CheckBox BTN_CASE - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_CASE"; - Pos = MAP_APPFONT ( 12 , 77 ) ; - Size = MAP_APPFONT ( 130 , 10 ) ; - Text [ en-US ] = "Case se~nsitive" ; - }; - CheckBox BTN_CALC - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_CALC"; - Pos = MAP_APPFONT ( 12 , 91 ) ; - Size = MAP_APPFONT ( 239 , 10 ) ; - Text [ en-US ] = "~Precision as shown" ; - }; - CheckBox BTN_MATCH - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_MATCH"; - Pos = MAP_APPFONT ( 12 , 105 ) ; - Size = MAP_APPFONT ( 239 , 10 ) ; - Text [ en-US ] = "Search criteria = and <> must apply to ~whole cells" ; - }; - CheckBox BTN_REGEX - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_REGEX"; - Pos = MAP_APPFONT ( 12 , 119 ) ; - Size = MAP_APPFONT ( 239 , 10 ) ; - Text [ en-US ] = "~Enable regular expressions in formulas" ; - }; - CheckBox BTN_LOOKUP - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_LOOKUP"; - Pos = MAP_APPFONT ( 12 , 133 ) ; - Size = MAP_APPFONT ( 239 , 10 ) ; - Text [ en-US ] = "~Automatically find column and row labels " ; - }; - CheckBox BTN_GENERAL_PREC - { - HelpID = "sc:CheckBox:RID_SCPAGE_CALC:BTN_GENERAL_PREC"; - Pos = MAP_APPFONT ( 12 , 147 ) ; - Size = MAP_APPFONT ( 164 , 10 ) ; - Text [ en-US ] = "~Limit decimals for general number format" ; - }; - FixedText FT_PREC - { - Pos = MAP_APPFONT ( 169 , 147 ) ; - Size = MAP_APPFONT ( 53 , 8 ) ; - Text [ en-US ] = "~Decimal places" ; - Right = TRUE ; - }; - NumericField ED_PREC - { - HelpID = "sc:NumericField:RID_SCPAGE_CALC:ED_PREC"; - Border = TRUE ; - Pos = MAP_APPFONT ( 226 , 145 ) ; - Size = MAP_APPFONT ( 25 , 12 ) ; - Maximum = 20 ; - Spin = TRUE ; - Repeat = TRUE ; - }; -}; - TabPage RID_SCPAGE_FORMULA { HelpId = HID_SCPAGE_FORMULA ; diff --git a/sc/uiconfig/scalc/ui/optcalculatepage.ui b/sc/uiconfig/scalc/ui/optcalculatepage.ui new file mode 100644 index 000000000000..322cd9583c2f --- /dev/null +++ b/sc/uiconfig/scalc/ui/optcalculatepage.ui @@ -0,0 +1,429 @@ +<?xml version="1.0" encoding="UTF-8"?> +<interface> + <!-- interface-requires gtk+ 3.0 --> + <!-- interface-requires LibreOffice 1.0 --> + <object class="GtkAdjustment" id="adjustment1"> + <property name="lower">1</property> + <property name="upper">1000</property> + <property name="value">100</property> + <property name="step_increment">1</property> + <property name="page_increment">10</property> + </object> + <object class="GtkAdjustment" id="adjustment2"> + <property name="upper">20</property> + <property name="step_increment">1</property> + <property name="page_increment">10</property> + </object> + <object class="GtkGrid" id="OptCalculatePage"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="border_width">6</property> + <property name="row_spacing">12</property> + <property name="column_spacing">18</property> + <child> + <object class="GtkFrame" id="frame1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="label_xalign">0</property> + <property name="shadow_type">none</property> + <child> + <object class="GtkAlignment" id="alignment1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="top_padding">6</property> + <property name="left_padding">12</property> + <child> + <object class="GtkGrid" id="grid3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="hexpand">True</property> + <property name="row_spacing">6</property> + <property name="column_spacing">12</property> + <child> + <object class="GtkCheckButton" id="case"> + <property name="label" translatable="yes">Case se_nsitive</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="calc"> + <property name="label" translatable="yes">_Precision as shown</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="match"> + <property name="label" translatable="yes">Search criteria = and <> must apply to _whole cells</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="regex"> + <property name="label" translatable="yes">_Enable regular expressions in formulas</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">3</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="lookup"> + <property name="label" translatable="yes">_Automatically find column and row labels</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">4</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkCheckButton" id="generalprec"> + <property name="label" translatable="yes">_Limit decimals for general number format</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">5</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkBox" id="box1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="halign">end</property> + <property name="hexpand">True</property> + <property name="spacing">12</property> + <child> + <object class="GtkLabel" id="precft"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">_Decimal places</property> + <property name="use_underline">True</property> + <property name="mnemonic_widget">prec</property> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">0</property> + </packing> + </child> + <child> + <object class="GtkSpinButton" id="prec"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="invisible_char">●</property> + <property name="adjustment">adjustment2</property> + </object> + <packing> + <property name="expand">False</property> + <property name="fill">True</property> + <property name="position">1</property> + </packing> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">5</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">General Calculations</property> + <attributes> + <attribute name="weight" value="bold"/> + </attributes> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkFrame" id="frame2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label_xalign">0</property> + <property name="shadow_type">none</property> + <child> + <object class="GtkAlignment" id="alignment2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="top_padding">6</property> + <property name="left_padding">12</property> + <child> + <object class="GtkGrid" id="grid1"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="row_spacing">6</property> + <property name="column_spacing">12</property> + <property name="row_homogeneous">True</property> + <child> + <object class="GtkCheckButton" id="iterate"> + <property name="label" translatable="yes">_Iterations</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">2</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="stepsft"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="margin_left">12</property> + <property name="xalign">0</property> + <property name="label" translatable="yes">_Steps</property> + <property name="use_underline">True</property> + <property name="mnemonic_widget">steps</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkLabel" id="minchangeft"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="margin_left">12</property> + <property name="xalign">0</property> + <property name="label" translatable="yes">_Minimum Change</property> + <property name="use_underline">True</property> + <property name="mnemonic_widget">minchange</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkSpinButton" id="steps"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="invisible_char">●</property> + <property name="adjustment">adjustment1</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="scuilo-ScDoubleField" id="minchange"> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="invisible_char">●</property> + <property name="width_chars">12</property> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Iterative references</property> + <attributes> + <attribute name="weight" value="bold"/> + </attributes> + </object> + </child> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkFrame" id="frame3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label_xalign">0</property> + <property name="shadow_type">none</property> + <child> + <object class="GtkAlignment" id="alignment3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="top_padding">6</property> + <property name="left_padding">12</property> + <child> + <object class="GtkGrid" id="grid2"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="row_homogeneous">True</property> + <child> + <object class="GtkRadioButton" id="datestd"> + <property name="label" translatable="yes">12/30/1899 (defa_ult)</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="tooltip_markup" translatable="yes">Value 0 corresponds to 12/30/1899</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="active">True</property> + <property name="draw_indicator">True</property> + <property name="group">datesc10</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkRadioButton" id="datesc10"> + <property name="label" translatable="yes">01/01/1900 (Star_Calc 1.0)</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="tooltip_markup" translatable="yes">Value 0 corresponds to 01/01/1900</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + <property name="group">date1904</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">1</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + <child> + <object class="GtkRadioButton" id="date1904"> + <property name="label" translatable="yes">_01/01/1904</property> + <property name="visible">True</property> + <property name="can_focus">True</property> + <property name="receives_default">False</property> + <property name="tooltip_markup" translatable="yes">0 corresponds to 01/01/1904</property> + <property name="use_underline">True</property> + <property name="xalign">0</property> + <property name="draw_indicator">True</property> + <property name="group">datestd</property> + </object> + <packing> + <property name="left_attach">0</property> + <property name="top_attach">2</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> + </child> + </object> + </child> + <child type="label"> + <object class="GtkLabel" id="label3"> + <property name="visible">True</property> + <property name="can_focus">False</property> + <property name="label" translatable="yes">Date</property> + <attributes> + <attribute name="weight" value="bold"/> + </attributes> + </object> + </child> + </object> + <packing> + <property name="left_attach">1</property> + <property name="top_attach">0</property> + <property name="width">1</property> + <property name="height">1</property> + </packing> + </child> + </object> +</interface> |