1*b1cdbd2cSJim Jagielski /**************************************************************
2*b1cdbd2cSJim Jagielski *
3*b1cdbd2cSJim Jagielski * Licensed to the Apache Software Foundation (ASF) under one
4*b1cdbd2cSJim Jagielski * or more contributor license agreements. See the NOTICE file
5*b1cdbd2cSJim Jagielski * distributed with this work for additional information
6*b1cdbd2cSJim Jagielski * regarding copyright ownership. The ASF licenses this file
7*b1cdbd2cSJim Jagielski * to you under the Apache License, Version 2.0 (the
8*b1cdbd2cSJim Jagielski * "License"); you may not use this file except in compliance
9*b1cdbd2cSJim Jagielski * with the License. You may obtain a copy of the License at
10*b1cdbd2cSJim Jagielski *
11*b1cdbd2cSJim Jagielski * http://www.apache.org/licenses/LICENSE-2.0
12*b1cdbd2cSJim Jagielski *
13*b1cdbd2cSJim Jagielski * Unless required by applicable law or agreed to in writing,
14*b1cdbd2cSJim Jagielski * software distributed under the License is distributed on an
15*b1cdbd2cSJim Jagielski * "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
16*b1cdbd2cSJim Jagielski * KIND, either express or implied. See the License for the
17*b1cdbd2cSJim Jagielski * specific language governing permissions and limitations
18*b1cdbd2cSJim Jagielski * under the License.
19*b1cdbd2cSJim Jagielski *
20*b1cdbd2cSJim Jagielski *************************************************************/
21*b1cdbd2cSJim Jagielski
22*b1cdbd2cSJim Jagielski
23*b1cdbd2cSJim Jagielski
24*b1cdbd2cSJim Jagielski // MARKER(update_precomp.py): autogen include statement, do not remove
25*b1cdbd2cSJim Jagielski #include "precompiled_sc.hxx"
26*b1cdbd2cSJim Jagielski
27*b1cdbd2cSJim Jagielski
28*b1cdbd2cSJim Jagielski
29*b1cdbd2cSJim Jagielski #include <vcl/svapp.hxx>
30*b1cdbd2cSJim Jagielski #include <svl/zforlist.hxx>
31*b1cdbd2cSJim Jagielski
32*b1cdbd2cSJim Jagielski #include <com/sun/star/uno/Any.hxx>
33*b1cdbd2cSJim Jagielski #include <com/sun/star/uno/Sequence.hxx>
34*b1cdbd2cSJim Jagielski
35*b1cdbd2cSJim Jagielski #include "cfgids.hxx"
36*b1cdbd2cSJim Jagielski #include "docoptio.hxx"
37*b1cdbd2cSJim Jagielski #include "rechead.hxx"
38*b1cdbd2cSJim Jagielski #include "scresid.hxx"
39*b1cdbd2cSJim Jagielski #include "sc.hrc"
40*b1cdbd2cSJim Jagielski #include "miscuno.hxx"
41*b1cdbd2cSJim Jagielski
42*b1cdbd2cSJim Jagielski using namespace utl;
43*b1cdbd2cSJim Jagielski using namespace rtl;
44*b1cdbd2cSJim Jagielski using namespace com::sun::star::uno;
45*b1cdbd2cSJim Jagielski
46*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
47*b1cdbd2cSJim Jagielski
48*b1cdbd2cSJim Jagielski #define SC_VERSION ((sal_uInt16)251)
49*b1cdbd2cSJim Jagielski
50*b1cdbd2cSJim Jagielski TYPEINIT1(ScTpCalcItem, SfxPoolItem);
51*b1cdbd2cSJim Jagielski
52*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
53*b1cdbd2cSJim Jagielski
54*b1cdbd2cSJim Jagielski //! these functions should be moved to some header file
TwipsToHMM(long nTwips)55*b1cdbd2cSJim Jagielski inline long TwipsToHMM(long nTwips) { return (nTwips * 127 + 36) / 72; }
HMMToTwips(long nHMM)56*b1cdbd2cSJim Jagielski inline long HMMToTwips(long nHMM) { return (nHMM * 72 + 63) / 127; }
57*b1cdbd2cSJim Jagielski
TwipsToEvenHMM(long nTwips)58*b1cdbd2cSJim Jagielski inline long TwipsToEvenHMM(long nTwips) { return ( (nTwips * 127 + 72) / 144 ) * 2; }
59*b1cdbd2cSJim Jagielski
60*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
61*b1cdbd2cSJim Jagielski
lcl_GetDefaultTabDist()62*b1cdbd2cSJim Jagielski sal_uInt16 lcl_GetDefaultTabDist()
63*b1cdbd2cSJim Jagielski {
64*b1cdbd2cSJim Jagielski if ( ScOptionsUtil::IsMetricSystem() )
65*b1cdbd2cSJim Jagielski return 709; // 1,25 cm
66*b1cdbd2cSJim Jagielski else
67*b1cdbd2cSJim Jagielski return 720; // 1/2"
68*b1cdbd2cSJim Jagielski }
69*b1cdbd2cSJim Jagielski
70*b1cdbd2cSJim Jagielski //========================================================================
71*b1cdbd2cSJim Jagielski // ScDocOptions - Dokument-Optionen
72*b1cdbd2cSJim Jagielski //========================================================================
73*b1cdbd2cSJim Jagielski
ScDocOptions()74*b1cdbd2cSJim Jagielski ScDocOptions::ScDocOptions()
75*b1cdbd2cSJim Jagielski {
76*b1cdbd2cSJim Jagielski ResetDocOptions();
77*b1cdbd2cSJim Jagielski }
78*b1cdbd2cSJim Jagielski
79*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
80*b1cdbd2cSJim Jagielski
ScDocOptions(const ScDocOptions & rCpy)81*b1cdbd2cSJim Jagielski ScDocOptions::ScDocOptions( const ScDocOptions& rCpy )
82*b1cdbd2cSJim Jagielski : fIterEps( rCpy.fIterEps ),
83*b1cdbd2cSJim Jagielski nIterCount( rCpy.nIterCount ),
84*b1cdbd2cSJim Jagielski nPrecStandardFormat( rCpy.nPrecStandardFormat ),
85*b1cdbd2cSJim Jagielski nDay( rCpy.nDay ),
86*b1cdbd2cSJim Jagielski nMonth( rCpy.nMonth ),
87*b1cdbd2cSJim Jagielski nYear( rCpy.nYear ),
88*b1cdbd2cSJim Jagielski nYear2000( rCpy.nYear2000 ),
89*b1cdbd2cSJim Jagielski nTabDistance( rCpy.nTabDistance ),
90*b1cdbd2cSJim Jagielski bIsIgnoreCase( rCpy.bIsIgnoreCase ),
91*b1cdbd2cSJim Jagielski bIsIter( rCpy.bIsIter ),
92*b1cdbd2cSJim Jagielski bCalcAsShown( rCpy.bCalcAsShown ),
93*b1cdbd2cSJim Jagielski bMatchWholeCell( rCpy.bMatchWholeCell ),
94*b1cdbd2cSJim Jagielski bDoAutoSpell( rCpy.bDoAutoSpell ),
95*b1cdbd2cSJim Jagielski bLookUpColRowNames( rCpy.bLookUpColRowNames ),
96*b1cdbd2cSJim Jagielski bFormulaRegexEnabled( rCpy.bFormulaRegexEnabled )
97*b1cdbd2cSJim Jagielski {
98*b1cdbd2cSJim Jagielski }
99*b1cdbd2cSJim Jagielski
100*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
101*b1cdbd2cSJim Jagielski
~ScDocOptions()102*b1cdbd2cSJim Jagielski ScDocOptions::~ScDocOptions()
103*b1cdbd2cSJim Jagielski {
104*b1cdbd2cSJim Jagielski }
105*b1cdbd2cSJim Jagielski
106*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
107*b1cdbd2cSJim Jagielski
ResetDocOptions()108*b1cdbd2cSJim Jagielski void ScDocOptions::ResetDocOptions()
109*b1cdbd2cSJim Jagielski {
110*b1cdbd2cSJim Jagielski bIsIgnoreCase = sal_False;
111*b1cdbd2cSJim Jagielski bIsIter = sal_False;
112*b1cdbd2cSJim Jagielski nIterCount = 100;
113*b1cdbd2cSJim Jagielski fIterEps = 1.0E-3;
114*b1cdbd2cSJim Jagielski nPrecStandardFormat = SvNumberFormatter::UNLIMITED_PRECISION;
115*b1cdbd2cSJim Jagielski nDay = 30;
116*b1cdbd2cSJim Jagielski nMonth = 12;
117*b1cdbd2cSJim Jagielski nYear = 1899;
118*b1cdbd2cSJim Jagielski nYear2000 = SvNumberFormatter::GetYear2000Default();
119*b1cdbd2cSJim Jagielski nTabDistance = lcl_GetDefaultTabDist();
120*b1cdbd2cSJim Jagielski bCalcAsShown = sal_False;
121*b1cdbd2cSJim Jagielski bMatchWholeCell = sal_True;
122*b1cdbd2cSJim Jagielski bDoAutoSpell = sal_False;
123*b1cdbd2cSJim Jagielski bLookUpColRowNames = sal_True;
124*b1cdbd2cSJim Jagielski bFormulaRegexEnabled= sal_True;
125*b1cdbd2cSJim Jagielski }
126*b1cdbd2cSJim Jagielski
127*b1cdbd2cSJim Jagielski //========================================================================
128*b1cdbd2cSJim Jagielski // ScTpCalcItem - Daten fuer die CalcOptions-TabPage
129*b1cdbd2cSJim Jagielski //========================================================================
130*b1cdbd2cSJim Jagielski
131*b1cdbd2cSJim Jagielski //UNUSED2008-05 ScTpCalcItem::ScTpCalcItem( sal_uInt16 nWhichP ) : SfxPoolItem( nWhichP )
132*b1cdbd2cSJim Jagielski //UNUSED2008-05 {
133*b1cdbd2cSJim Jagielski //UNUSED2008-05 }
134*b1cdbd2cSJim Jagielski
135*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
136*b1cdbd2cSJim Jagielski
ScTpCalcItem(sal_uInt16 nWhichP,const ScDocOptions & rOpt)137*b1cdbd2cSJim Jagielski ScTpCalcItem::ScTpCalcItem( sal_uInt16 nWhichP, const ScDocOptions& rOpt )
138*b1cdbd2cSJim Jagielski : SfxPoolItem ( nWhichP ),
139*b1cdbd2cSJim Jagielski theOptions ( rOpt )
140*b1cdbd2cSJim Jagielski {
141*b1cdbd2cSJim Jagielski }
142*b1cdbd2cSJim Jagielski
143*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
144*b1cdbd2cSJim Jagielski
ScTpCalcItem(const ScTpCalcItem & rItem)145*b1cdbd2cSJim Jagielski ScTpCalcItem::ScTpCalcItem( const ScTpCalcItem& rItem )
146*b1cdbd2cSJim Jagielski : SfxPoolItem ( rItem ),
147*b1cdbd2cSJim Jagielski theOptions ( rItem.theOptions )
148*b1cdbd2cSJim Jagielski {
149*b1cdbd2cSJim Jagielski }
150*b1cdbd2cSJim Jagielski
151*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
152*b1cdbd2cSJim Jagielski
~ScTpCalcItem()153*b1cdbd2cSJim Jagielski __EXPORT ScTpCalcItem::~ScTpCalcItem()
154*b1cdbd2cSJim Jagielski {
155*b1cdbd2cSJim Jagielski }
156*b1cdbd2cSJim Jagielski
157*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
158*b1cdbd2cSJim Jagielski
GetValueText() const159*b1cdbd2cSJim Jagielski String __EXPORT ScTpCalcItem::GetValueText() const
160*b1cdbd2cSJim Jagielski {
161*b1cdbd2cSJim Jagielski return String::CreateFromAscii( RTL_CONSTASCII_STRINGPARAM("ScTpCalcItem") );
162*b1cdbd2cSJim Jagielski }
163*b1cdbd2cSJim Jagielski
164*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
165*b1cdbd2cSJim Jagielski
operator ==(const SfxPoolItem & rItem) const166*b1cdbd2cSJim Jagielski int __EXPORT ScTpCalcItem::operator==( const SfxPoolItem& rItem ) const
167*b1cdbd2cSJim Jagielski {
168*b1cdbd2cSJim Jagielski DBG_ASSERT( SfxPoolItem::operator==( rItem ), "unequal Which or Type" );
169*b1cdbd2cSJim Jagielski
170*b1cdbd2cSJim Jagielski const ScTpCalcItem& rPItem = (const ScTpCalcItem&)rItem;
171*b1cdbd2cSJim Jagielski
172*b1cdbd2cSJim Jagielski return ( theOptions == rPItem.theOptions );
173*b1cdbd2cSJim Jagielski }
174*b1cdbd2cSJim Jagielski
175*b1cdbd2cSJim Jagielski //------------------------------------------------------------------------
176*b1cdbd2cSJim Jagielski
Clone(SfxItemPool *) const177*b1cdbd2cSJim Jagielski SfxPoolItem* __EXPORT ScTpCalcItem::Clone( SfxItemPool * ) const
178*b1cdbd2cSJim Jagielski {
179*b1cdbd2cSJim Jagielski return new ScTpCalcItem( *this );
180*b1cdbd2cSJim Jagielski }
181*b1cdbd2cSJim Jagielski
182*b1cdbd2cSJim Jagielski //==================================================================
183*b1cdbd2cSJim Jagielski // Config Item containing document options
184*b1cdbd2cSJim Jagielski //==================================================================
185*b1cdbd2cSJim Jagielski
186*b1cdbd2cSJim Jagielski #define CFGPATH_CALC "Office.Calc/Calculate"
187*b1cdbd2cSJim Jagielski
188*b1cdbd2cSJim Jagielski #define SCCALCOPT_ITER_ITER 0
189*b1cdbd2cSJim Jagielski #define SCCALCOPT_ITER_STEPS 1
190*b1cdbd2cSJim Jagielski #define SCCALCOPT_ITER_MINCHG 2
191*b1cdbd2cSJim Jagielski #define SCCALCOPT_DATE_DAY 3
192*b1cdbd2cSJim Jagielski #define SCCALCOPT_DATE_MONTH 4
193*b1cdbd2cSJim Jagielski #define SCCALCOPT_DATE_YEAR 5
194*b1cdbd2cSJim Jagielski #define SCCALCOPT_DECIMALS 6
195*b1cdbd2cSJim Jagielski #define SCCALCOPT_CASESENSITIVE 7
196*b1cdbd2cSJim Jagielski #define SCCALCOPT_PRECISION 8
197*b1cdbd2cSJim Jagielski #define SCCALCOPT_SEARCHCRIT 9
198*b1cdbd2cSJim Jagielski #define SCCALCOPT_FINDLABEL 10
199*b1cdbd2cSJim Jagielski #define SCCALCOPT_REGEX 11
200*b1cdbd2cSJim Jagielski #define SCCALCOPT_COUNT 12
201*b1cdbd2cSJim Jagielski
202*b1cdbd2cSJim Jagielski #define CFGPATH_DOCLAYOUT "Office.Calc/Layout/Other"
203*b1cdbd2cSJim Jagielski
204*b1cdbd2cSJim Jagielski #define SCDOCLAYOUTOPT_TABSTOP 0
205*b1cdbd2cSJim Jagielski #define SCDOCLAYOUTOPT_COUNT 1
206*b1cdbd2cSJim Jagielski
207*b1cdbd2cSJim Jagielski
GetCalcPropertyNames()208*b1cdbd2cSJim Jagielski Sequence<OUString> ScDocCfg::GetCalcPropertyNames()
209*b1cdbd2cSJim Jagielski {
210*b1cdbd2cSJim Jagielski static const char* aPropNames[] =
211*b1cdbd2cSJim Jagielski {
212*b1cdbd2cSJim Jagielski "IterativeReference/Iteration", // SCCALCOPT_ITER_ITER
213*b1cdbd2cSJim Jagielski "IterativeReference/Steps", // SCCALCOPT_ITER_STEPS
214*b1cdbd2cSJim Jagielski "IterativeReference/MinimumChange", // SCCALCOPT_ITER_MINCHG
215*b1cdbd2cSJim Jagielski "Other/Date/DD", // SCCALCOPT_DATE_DAY
216*b1cdbd2cSJim Jagielski "Other/Date/MM", // SCCALCOPT_DATE_MONTH
217*b1cdbd2cSJim Jagielski "Other/Date/YY", // SCCALCOPT_DATE_YEAR
218*b1cdbd2cSJim Jagielski "Other/DecimalPlaces", // SCCALCOPT_DECIMALS
219*b1cdbd2cSJim Jagielski "Other/CaseSensitive", // SCCALCOPT_CASESENSITIVE
220*b1cdbd2cSJim Jagielski "Other/Precision", // SCCALCOPT_PRECISION
221*b1cdbd2cSJim Jagielski "Other/SearchCriteria", // SCCALCOPT_SEARCHCRIT
222*b1cdbd2cSJim Jagielski "Other/FindLabel", // SCCALCOPT_FINDLABEL
223*b1cdbd2cSJim Jagielski "Other/RegularExpressions" // SCCALCOPT_REGEX
224*b1cdbd2cSJim Jagielski };
225*b1cdbd2cSJim Jagielski Sequence<OUString> aNames(SCCALCOPT_COUNT);
226*b1cdbd2cSJim Jagielski OUString* pNames = aNames.getArray();
227*b1cdbd2cSJim Jagielski for(int i = 0; i < SCCALCOPT_COUNT; i++)
228*b1cdbd2cSJim Jagielski pNames[i] = OUString::createFromAscii(aPropNames[i]);
229*b1cdbd2cSJim Jagielski
230*b1cdbd2cSJim Jagielski return aNames;
231*b1cdbd2cSJim Jagielski }
232*b1cdbd2cSJim Jagielski
GetLayoutPropertyNames()233*b1cdbd2cSJim Jagielski Sequence<OUString> ScDocCfg::GetLayoutPropertyNames()
234*b1cdbd2cSJim Jagielski {
235*b1cdbd2cSJim Jagielski static const char* aPropNames[] =
236*b1cdbd2cSJim Jagielski {
237*b1cdbd2cSJim Jagielski "TabStop/NonMetric" // SCDOCLAYOUTOPT_TABSTOP
238*b1cdbd2cSJim Jagielski };
239*b1cdbd2cSJim Jagielski Sequence<OUString> aNames(SCDOCLAYOUTOPT_COUNT);
240*b1cdbd2cSJim Jagielski OUString* pNames = aNames.getArray();
241*b1cdbd2cSJim Jagielski for(int i = 0; i < SCDOCLAYOUTOPT_COUNT; i++)
242*b1cdbd2cSJim Jagielski pNames[i] = OUString::createFromAscii(aPropNames[i]);
243*b1cdbd2cSJim Jagielski
244*b1cdbd2cSJim Jagielski // adjust for metric system
245*b1cdbd2cSJim Jagielski if (ScOptionsUtil::IsMetricSystem())
246*b1cdbd2cSJim Jagielski pNames[SCDOCLAYOUTOPT_TABSTOP] = OUString::createFromAscii( "TabStop/Metric" );
247*b1cdbd2cSJim Jagielski
248*b1cdbd2cSJim Jagielski return aNames;
249*b1cdbd2cSJim Jagielski }
250*b1cdbd2cSJim Jagielski
ScDocCfg()251*b1cdbd2cSJim Jagielski ScDocCfg::ScDocCfg() :
252*b1cdbd2cSJim Jagielski aCalcItem( OUString::createFromAscii( CFGPATH_CALC ) ),
253*b1cdbd2cSJim Jagielski aLayoutItem( OUString::createFromAscii( CFGPATH_DOCLAYOUT ) )
254*b1cdbd2cSJim Jagielski {
255*b1cdbd2cSJim Jagielski sal_Int32 nIntVal = 0;
256*b1cdbd2cSJim Jagielski double fDoubleVal = 0;
257*b1cdbd2cSJim Jagielski
258*b1cdbd2cSJim Jagielski Sequence<OUString> aNames;
259*b1cdbd2cSJim Jagielski Sequence<Any> aValues;
260*b1cdbd2cSJim Jagielski const Any* pValues = NULL;
261*b1cdbd2cSJim Jagielski
262*b1cdbd2cSJim Jagielski sal_uInt16 nDateDay, nDateMonth, nDateYear;
263*b1cdbd2cSJim Jagielski GetDate( nDateDay, nDateMonth, nDateYear );
264*b1cdbd2cSJim Jagielski
265*b1cdbd2cSJim Jagielski aNames = GetCalcPropertyNames();
266*b1cdbd2cSJim Jagielski aValues = aCalcItem.GetProperties(aNames);
267*b1cdbd2cSJim Jagielski aCalcItem.EnableNotification(aNames);
268*b1cdbd2cSJim Jagielski pValues = aValues.getConstArray();
269*b1cdbd2cSJim Jagielski DBG_ASSERT(aValues.getLength() == aNames.getLength(), "GetProperties failed");
270*b1cdbd2cSJim Jagielski if(aValues.getLength() == aNames.getLength())
271*b1cdbd2cSJim Jagielski {
272*b1cdbd2cSJim Jagielski for(int nProp = 0; nProp < aNames.getLength(); nProp++)
273*b1cdbd2cSJim Jagielski {
274*b1cdbd2cSJim Jagielski DBG_ASSERT(pValues[nProp].hasValue(), "property value missing");
275*b1cdbd2cSJim Jagielski if(pValues[nProp].hasValue())
276*b1cdbd2cSJim Jagielski {
277*b1cdbd2cSJim Jagielski switch(nProp)
278*b1cdbd2cSJim Jagielski {
279*b1cdbd2cSJim Jagielski case SCCALCOPT_ITER_ITER:
280*b1cdbd2cSJim Jagielski SetIter( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
281*b1cdbd2cSJim Jagielski break;
282*b1cdbd2cSJim Jagielski case SCCALCOPT_ITER_STEPS:
283*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= nIntVal) SetIterCount( (sal_uInt16) nIntVal );
284*b1cdbd2cSJim Jagielski break;
285*b1cdbd2cSJim Jagielski case SCCALCOPT_ITER_MINCHG:
286*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= fDoubleVal) SetIterEps( fDoubleVal );
287*b1cdbd2cSJim Jagielski break;
288*b1cdbd2cSJim Jagielski case SCCALCOPT_DATE_DAY:
289*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= nIntVal) nDateDay = (sal_uInt16) nIntVal;
290*b1cdbd2cSJim Jagielski break;
291*b1cdbd2cSJim Jagielski case SCCALCOPT_DATE_MONTH:
292*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= nIntVal) nDateMonth = (sal_uInt16) nIntVal;
293*b1cdbd2cSJim Jagielski break;
294*b1cdbd2cSJim Jagielski case SCCALCOPT_DATE_YEAR:
295*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= nIntVal) nDateYear = (sal_uInt16) nIntVal;
296*b1cdbd2cSJim Jagielski break;
297*b1cdbd2cSJim Jagielski case SCCALCOPT_DECIMALS:
298*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= nIntVal) SetStdPrecision( (sal_uInt16) nIntVal );
299*b1cdbd2cSJim Jagielski break;
300*b1cdbd2cSJim Jagielski case SCCALCOPT_CASESENSITIVE:
301*b1cdbd2cSJim Jagielski // content is reversed
302*b1cdbd2cSJim Jagielski SetIgnoreCase( !ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
303*b1cdbd2cSJim Jagielski break;
304*b1cdbd2cSJim Jagielski case SCCALCOPT_PRECISION:
305*b1cdbd2cSJim Jagielski SetCalcAsShown( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
306*b1cdbd2cSJim Jagielski break;
307*b1cdbd2cSJim Jagielski case SCCALCOPT_SEARCHCRIT:
308*b1cdbd2cSJim Jagielski SetMatchWholeCell( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
309*b1cdbd2cSJim Jagielski break;
310*b1cdbd2cSJim Jagielski case SCCALCOPT_FINDLABEL:
311*b1cdbd2cSJim Jagielski SetLookUpColRowNames( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
312*b1cdbd2cSJim Jagielski break;
313*b1cdbd2cSJim Jagielski case SCCALCOPT_REGEX :
314*b1cdbd2cSJim Jagielski SetFormulaRegexEnabled( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
315*b1cdbd2cSJim Jagielski break;
316*b1cdbd2cSJim Jagielski }
317*b1cdbd2cSJim Jagielski }
318*b1cdbd2cSJim Jagielski }
319*b1cdbd2cSJim Jagielski }
320*b1cdbd2cSJim Jagielski aCalcItem.SetCommitLink( LINK( this, ScDocCfg, CalcCommitHdl ) );
321*b1cdbd2cSJim Jagielski
322*b1cdbd2cSJim Jagielski SetDate( nDateDay, nDateMonth, nDateYear );
323*b1cdbd2cSJim Jagielski
324*b1cdbd2cSJim Jagielski aNames = GetLayoutPropertyNames();
325*b1cdbd2cSJim Jagielski aValues = aLayoutItem.GetProperties(aNames);
326*b1cdbd2cSJim Jagielski aLayoutItem.EnableNotification(aNames);
327*b1cdbd2cSJim Jagielski pValues = aValues.getConstArray();
328*b1cdbd2cSJim Jagielski DBG_ASSERT(aValues.getLength() == aNames.getLength(), "GetProperties failed");
329*b1cdbd2cSJim Jagielski if(aValues.getLength() == aNames.getLength())
330*b1cdbd2cSJim Jagielski {
331*b1cdbd2cSJim Jagielski for(int nProp = 0; nProp < aNames.getLength(); nProp++)
332*b1cdbd2cSJim Jagielski {
333*b1cdbd2cSJim Jagielski DBG_ASSERT(pValues[nProp].hasValue(), "property value missing");
334*b1cdbd2cSJim Jagielski if(pValues[nProp].hasValue())
335*b1cdbd2cSJim Jagielski {
336*b1cdbd2cSJim Jagielski switch(nProp)
337*b1cdbd2cSJim Jagielski {
338*b1cdbd2cSJim Jagielski case SCDOCLAYOUTOPT_TABSTOP:
339*b1cdbd2cSJim Jagielski // TabDistance in ScDocOptions is in twips
340*b1cdbd2cSJim Jagielski if (pValues[nProp] >>= nIntVal)
341*b1cdbd2cSJim Jagielski SetTabDistance( (sal_uInt16) HMMToTwips( nIntVal ) );
342*b1cdbd2cSJim Jagielski break;
343*b1cdbd2cSJim Jagielski }
344*b1cdbd2cSJim Jagielski }
345*b1cdbd2cSJim Jagielski }
346*b1cdbd2cSJim Jagielski }
347*b1cdbd2cSJim Jagielski aLayoutItem.SetCommitLink( LINK( this, ScDocCfg, LayoutCommitHdl ) );
348*b1cdbd2cSJim Jagielski }
349*b1cdbd2cSJim Jagielski
IMPL_LINK(ScDocCfg,CalcCommitHdl,void *,EMPTYARG)350*b1cdbd2cSJim Jagielski IMPL_LINK( ScDocCfg, CalcCommitHdl, void *, EMPTYARG )
351*b1cdbd2cSJim Jagielski {
352*b1cdbd2cSJim Jagielski Sequence<OUString> aNames = GetCalcPropertyNames();
353*b1cdbd2cSJim Jagielski Sequence<Any> aValues(aNames.getLength());
354*b1cdbd2cSJim Jagielski Any* pValues = aValues.getArray();
355*b1cdbd2cSJim Jagielski
356*b1cdbd2cSJim Jagielski sal_uInt16 nDateDay, nDateMonth, nDateYear;
357*b1cdbd2cSJim Jagielski GetDate( nDateDay, nDateMonth, nDateYear );
358*b1cdbd2cSJim Jagielski
359*b1cdbd2cSJim Jagielski for(int nProp = 0; nProp < aNames.getLength(); nProp++)
360*b1cdbd2cSJim Jagielski {
361*b1cdbd2cSJim Jagielski switch(nProp)
362*b1cdbd2cSJim Jagielski {
363*b1cdbd2cSJim Jagielski case SCCALCOPT_ITER_ITER:
364*b1cdbd2cSJim Jagielski ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], IsIter() );
365*b1cdbd2cSJim Jagielski break;
366*b1cdbd2cSJim Jagielski case SCCALCOPT_ITER_STEPS:
367*b1cdbd2cSJim Jagielski pValues[nProp] <<= (sal_Int32) GetIterCount();
368*b1cdbd2cSJim Jagielski break;
369*b1cdbd2cSJim Jagielski case SCCALCOPT_ITER_MINCHG:
370*b1cdbd2cSJim Jagielski pValues[nProp] <<= (double) GetIterEps();
371*b1cdbd2cSJim Jagielski break;
372*b1cdbd2cSJim Jagielski case SCCALCOPT_DATE_DAY:
373*b1cdbd2cSJim Jagielski pValues[nProp] <<= (sal_Int32) nDateDay;
374*b1cdbd2cSJim Jagielski break;
375*b1cdbd2cSJim Jagielski case SCCALCOPT_DATE_MONTH:
376*b1cdbd2cSJim Jagielski pValues[nProp] <<= (sal_Int32) nDateMonth;
377*b1cdbd2cSJim Jagielski break;
378*b1cdbd2cSJim Jagielski case SCCALCOPT_DATE_YEAR:
379*b1cdbd2cSJim Jagielski pValues[nProp] <<= (sal_Int32) nDateYear;
380*b1cdbd2cSJim Jagielski break;
381*b1cdbd2cSJim Jagielski case SCCALCOPT_DECIMALS:
382*b1cdbd2cSJim Jagielski pValues[nProp] <<= (sal_Int32) GetStdPrecision();
383*b1cdbd2cSJim Jagielski break;
384*b1cdbd2cSJim Jagielski case SCCALCOPT_CASESENSITIVE:
385*b1cdbd2cSJim Jagielski // content is reversed
386*b1cdbd2cSJim Jagielski ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], !IsIgnoreCase() );
387*b1cdbd2cSJim Jagielski break;
388*b1cdbd2cSJim Jagielski case SCCALCOPT_PRECISION:
389*b1cdbd2cSJim Jagielski ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], IsCalcAsShown() );
390*b1cdbd2cSJim Jagielski break;
391*b1cdbd2cSJim Jagielski case SCCALCOPT_SEARCHCRIT:
392*b1cdbd2cSJim Jagielski ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], IsMatchWholeCell() );
393*b1cdbd2cSJim Jagielski break;
394*b1cdbd2cSJim Jagielski case SCCALCOPT_FINDLABEL:
395*b1cdbd2cSJim Jagielski ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], IsLookUpColRowNames() );
396*b1cdbd2cSJim Jagielski break;
397*b1cdbd2cSJim Jagielski case SCCALCOPT_REGEX :
398*b1cdbd2cSJim Jagielski ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], IsFormulaRegexEnabled() );
399*b1cdbd2cSJim Jagielski }
400*b1cdbd2cSJim Jagielski }
401*b1cdbd2cSJim Jagielski aCalcItem.PutProperties(aNames, aValues);
402*b1cdbd2cSJim Jagielski
403*b1cdbd2cSJim Jagielski return 0;
404*b1cdbd2cSJim Jagielski }
405*b1cdbd2cSJim Jagielski
IMPL_LINK(ScDocCfg,LayoutCommitHdl,void *,EMPTYARG)406*b1cdbd2cSJim Jagielski IMPL_LINK( ScDocCfg, LayoutCommitHdl, void *, EMPTYARG )
407*b1cdbd2cSJim Jagielski {
408*b1cdbd2cSJim Jagielski Sequence<OUString> aNames = GetLayoutPropertyNames();
409*b1cdbd2cSJim Jagielski Sequence<Any> aValues(aNames.getLength());
410*b1cdbd2cSJim Jagielski Any* pValues = aValues.getArray();
411*b1cdbd2cSJim Jagielski
412*b1cdbd2cSJim Jagielski for(int nProp = 0; nProp < aNames.getLength(); nProp++)
413*b1cdbd2cSJim Jagielski {
414*b1cdbd2cSJim Jagielski switch(nProp)
415*b1cdbd2cSJim Jagielski {
416*b1cdbd2cSJim Jagielski case SCDOCLAYOUTOPT_TABSTOP:
417*b1cdbd2cSJim Jagielski // TabDistance in ScDocOptions is in twips
418*b1cdbd2cSJim Jagielski // use only even numbers, so defaults don't get changed
419*b1cdbd2cSJim Jagielski // by modifying other settings in the same config item
420*b1cdbd2cSJim Jagielski pValues[nProp] <<= (sal_Int32) TwipsToEvenHMM( GetTabDistance() );
421*b1cdbd2cSJim Jagielski break;
422*b1cdbd2cSJim Jagielski }
423*b1cdbd2cSJim Jagielski }
424*b1cdbd2cSJim Jagielski aLayoutItem.PutProperties(aNames, aValues);
425*b1cdbd2cSJim Jagielski
426*b1cdbd2cSJim Jagielski return 0;
427*b1cdbd2cSJim Jagielski }
428*b1cdbd2cSJim Jagielski
429*b1cdbd2cSJim Jagielski
SetOptions(const ScDocOptions & rNew)430*b1cdbd2cSJim Jagielski void ScDocCfg::SetOptions( const ScDocOptions& rNew )
431*b1cdbd2cSJim Jagielski {
432*b1cdbd2cSJim Jagielski *(ScDocOptions*)this = rNew;
433*b1cdbd2cSJim Jagielski
434*b1cdbd2cSJim Jagielski aCalcItem.SetModified();
435*b1cdbd2cSJim Jagielski aLayoutItem.SetModified();
436*b1cdbd2cSJim Jagielski }
437*b1cdbd2cSJim Jagielski
438*b1cdbd2cSJim Jagielski
439