?  search:
summary | log | graphiclog1 | graphiclog2 | commit | commitdiff | tree | refs | edit | fork
blame | history | raw | HEAD
update dev300-m57
[ooovba.git] / sc / source / core / tool / viewopti.cxx
blobeabb137ece6536759c36b8182b701be3767609b8
1 /*************************************************************************
2 *
3 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
4 *
5 * Copyright 2008 by Sun Microsystems, Inc.
6 *
7 * OpenOffice.org - a multi-platform office productivity suite
8 *
9 * $RCSfile: viewopti.cxx,v $
10 * $Revision: 1.9.32.3 $
11 *
12 * This file is part of OpenOffice.org.
13 *
14 * OpenOffice.org is free software: you can redistribute it and/or modify
15 * it under the terms of the GNU Lesser General Public License version 3
16 * only, as published by the Free Software Foundation.
17 *
18 * OpenOffice.org is distributed in the hope that it will be useful,
19 * but WITHOUT ANY WARRANTY; without even the implied warranty of
20 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
21 * GNU Lesser General Public License version 3 for more details
22 * (a copy is included in the LICENSE file that accompanied this code).
23 *
24 * You should have received a copy of the GNU Lesser General Public License
25 * version 3 along with OpenOffice.org. If not, see
26 * <http://www.openoffice.org/license.html>
27 * for a copy of the LGPLv3 License.
28 *
29 ************************************************************************/
30
31 // MARKER(update_precomp.py): autogen include statement, do not remove
32 #include "precompiled_sc.hxx"
33
34
35
36 #include <vcl/svapp.hxx>
37
38 #include <com/sun/star/uno/Any.hxx>
39 #include <com/sun/star/uno/Sequence.hxx>
40
41 #include "global.hxx"
42 #include "globstr.hrc"
43 #include "cfgids.hxx"
44 #include "viewopti.hxx"
45 #include "rechead.hxx"
46 #include "scresid.hxx"
47 #include "sc.hrc"
48 #include "miscuno.hxx"
49
50 using namespace utl;
51 using namespace rtl;
52 using namespace com::sun::star::uno;
53
54 //------------------------------------------------------------------
55
56 TYPEINIT1(ScTpViewItem, SfxPoolItem);
57
58 #define SC_VERSION ((USHORT)302)
59
60
61 //========================================================================
62 // class ScGridOptions
63 //========================================================================
64
65
66 void ScGridOptions::SetDefaults()
67 {
68 *this = ScGridOptions();
69
70 // Raster-Defaults sind jetzt zwischen den Apps unterschiedlich
71 // darum hier selber eintragen (alles in 1/100mm)
72
73 if ( ScOptionsUtil::IsMetricSystem() )
74 {
75 nFldDrawX = 1000; // 1cm
76 nFldDrawY = 1000;
77 nFldSnapX = 1000;
78 nFldSnapY = 1000;
79 }
80 else
81 {
82 nFldDrawX = 1270; // 0,5"
83 nFldDrawY = 1270;
84 nFldSnapX = 1270;
85 nFldSnapY = 1270;
86 }
87 nFldDivisionX = 1;
88 nFldDivisionY = 1;
89 }
90
91 //------------------------------------------------------------------------
92
93 const ScGridOptions& ScGridOptions::operator=( const ScGridOptions& rCpy )
94 {
95 nFldDrawX = rCpy.nFldDrawX; // UINT32
96 nFldDrawX = rCpy.nFldDrawX;
97 nFldDivisionX = rCpy.nFldDivisionX;
98 nFldDrawY = rCpy.nFldDrawY;
99 nFldDivisionY = rCpy.nFldDivisionY;
100 nFldSnapX = rCpy.nFldSnapX;
101 nFldSnapY = rCpy.nFldSnapY;
102 bUseGridsnap = rCpy.bUseGridsnap; // BitBool
103 bSynchronize = rCpy.bSynchronize;
104 bGridVisible = rCpy.bGridVisible;
105 bEqualGrid = rCpy.bEqualGrid;
106
107 return *this;
108 }
109
110 //------------------------------------------------------------------------
111
112 int ScGridOptions::operator==( const ScGridOptions& rCpy ) const
113 {
114 return ( nFldDrawX == rCpy.nFldDrawX
115 && nFldDrawX == rCpy.nFldDrawX
116 && nFldDivisionX == rCpy.nFldDivisionX
117 && nFldDrawY == rCpy.nFldDrawY
118 && nFldDivisionY == rCpy.nFldDivisionY
119 && nFldSnapX == rCpy.nFldSnapX
120 && nFldSnapY == rCpy.nFldSnapY
121 && bUseGridsnap == rCpy.bUseGridsnap
122 && bSynchronize == rCpy.bSynchronize
123 && bGridVisible == rCpy.bGridVisible
124 && bEqualGrid == rCpy.bEqualGrid );
125 }
126
127
128 //========================================================================
129 // class ScViewOptions
130 //========================================================================
131
132 ScViewOptions::ScViewOptions()
133 {
134 SetDefaults();
135 }
136
137 //------------------------------------------------------------------------
138
139 ScViewOptions::ScViewOptions( const ScViewOptions& rCpy )
140 {
141 *this = rCpy;
142 }
143
144 //------------------------------------------------------------------------
145
146 __EXPORT ScViewOptions::~ScViewOptions()
147 {
148 }
149
150 //------------------------------------------------------------------------
151
152 void ScViewOptions::SetDefaults()
153 {
154 aOptArr[ VOPT_FORMULAS ] =
155 aOptArr[ VOPT_SYNTAX ] =
156 aOptArr[ VOPT_HELPLINES ] =
157 aOptArr[ VOPT_BIGHANDLES ] = FALSE;
158 aOptArr[ VOPT_NOTES ] =
159 aOptArr[ VOPT_NULLVALS ] =
160 aOptArr[ VOPT_VSCROLL ] =
161 aOptArr[ VOPT_HSCROLL ] =
162 aOptArr[ VOPT_TABCONTROLS ] =
163 aOptArr[ VOPT_OUTLINER ] =
164 aOptArr[ VOPT_HEADER ] =
165 aOptArr[ VOPT_GRID ] =
166 aOptArr[ VOPT_ANCHOR ] =
167 aOptArr[ VOPT_PAGEBREAKS ] =
168 aOptArr[ VOPT_SOLIDHANDLES] =
169 aOptArr[ VOPT_CLIPMARKS ] = TRUE;
170
171 aModeArr[VOBJ_TYPE_OLE ] =
172 aModeArr[VOBJ_TYPE_CHART] =
173 aModeArr[VOBJ_TYPE_DRAW ] = VOBJ_MODE_SHOW;
174
175 aGridCol = Color( SC_STD_GRIDCOLOR );
176 aGridColName = ScGlobal::GetRscString( STR_GRIDCOLOR );
177
178 aGridOpt.SetDefaults();
179 }
180
181 //------------------------------------------------------------------------
182
183 Color ScViewOptions::GetGridColor( String* pStrName ) const
184 {
185 if ( pStrName )
186 *pStrName = aGridColName;
187
188 return aGridCol;
189 }
190
191 //------------------------------------------------------------------------
192
193 const ScViewOptions& ScViewOptions::operator=( const ScViewOptions& rCpy )
194 {
195 USHORT i;
196
197 for ( i=0; i<MAX_OPT; i++ ) aOptArr [i] = rCpy.aOptArr[i];
198 for ( i=0; i<MAX_TYPE; i++ ) aModeArr[i] = rCpy.aModeArr[i];
199
200 aGridCol = rCpy.aGridCol;
201 aGridColName = rCpy.aGridColName;
202 aGridOpt = rCpy.aGridOpt;
203
204 return *this;
205 }
206
207 //------------------------------------------------------------------------
208
209 int ScViewOptions::operator==( const ScViewOptions& rOpt ) const
210 {
211 BOOL bEqual = TRUE;
212 USHORT i;
213
214 for ( i=0; i<MAX_OPT && bEqual; i++ ) bEqual = (aOptArr [i] == rOpt.aOptArr[i]);
215 for ( i=0; i<MAX_TYPE && bEqual; i++ ) bEqual = (aModeArr[i] == rOpt.aModeArr[i]);
216
217 bEqual = bEqual && (aGridCol == rOpt.aGridCol);
218 bEqual = bEqual && (aGridColName == rOpt.aGridColName);
219 bEqual = bEqual && (aGridOpt == rOpt.aGridOpt);
220
221 return bEqual;
222 }
223
224 //------------------------------------------------------------------------
225
226 SvxGridItem* ScViewOptions::CreateGridItem( USHORT nId /* = SID_ATTR_GRID_OPTIONS */ ) const
227 {
228 SvxGridItem* pItem = new SvxGridItem( nId );
229
230 pItem->SetFldDrawX ( aGridOpt.GetFldDrawX() );
231 pItem->SetFldDivisionX ( aGridOpt.GetFldDivisionX() );
232 pItem->SetFldDrawY ( aGridOpt.GetFldDrawY() );
233 pItem->SetFldDivisionY ( aGridOpt.GetFldDivisionY() );
234 pItem->SetFldSnapX ( aGridOpt.GetFldSnapX() );
235 pItem->SetFldSnapY ( aGridOpt.GetFldSnapY() );
236 pItem->SetUseGridSnap ( aGridOpt.GetUseGridSnap() );
237 pItem->SetSynchronize ( aGridOpt.GetSynchronize() );
238 pItem->SetGridVisible ( aGridOpt.GetGridVisible() );
239 pItem->SetEqualGrid ( aGridOpt.GetEqualGrid() );
240
241 return pItem;
242 }
243
244 //========================================================================
245 // ScTpViewItem - Daten fuer die ViewOptions-TabPage
246 //========================================================================
247
248 //UNUSED2008-05 ScTpViewItem::ScTpViewItem( USHORT nWhichP ) : SfxPoolItem( nWhichP )
249 //UNUSED2008-05 {
250 //UNUSED2008-05 }
251
252 //------------------------------------------------------------------------
253
254 ScTpViewItem::ScTpViewItem( USHORT nWhichP, const ScViewOptions& rOpt )
255 : SfxPoolItem ( nWhichP ),
256 theOptions ( rOpt )
257 {
258 }
259
260 //------------------------------------------------------------------------
261
262 ScTpViewItem::ScTpViewItem( const ScTpViewItem& rItem )
263 : SfxPoolItem ( rItem ),
264 theOptions ( rItem.theOptions )
265 {
266 }
267
268 //------------------------------------------------------------------------
269
270 __EXPORT ScTpViewItem::~ScTpViewItem()
271 {
272 }
273
274 //------------------------------------------------------------------------
275
276 String __EXPORT ScTpViewItem::GetValueText() const
277 {
278 return String::CreateFromAscii( RTL_CONSTASCII_STRINGPARAM("ScTpViewItem") );
279 }
280
281 //------------------------------------------------------------------------
282
283 int __EXPORT ScTpViewItem::operator==( const SfxPoolItem& rItem ) const
284 {
285 DBG_ASSERT( SfxPoolItem::operator==( rItem ), "unequal Which or Type" );
286
287 const ScTpViewItem& rPItem = (const ScTpViewItem&)rItem;
288
289 return ( theOptions == rPItem.theOptions );
290 }
291
292 //------------------------------------------------------------------------
293
294 SfxPoolItem* __EXPORT ScTpViewItem::Clone( SfxItemPool * ) const
295 {
296 return new ScTpViewItem( *this );
297 }
298
299 //==================================================================
300 // Config Item containing view options
301 //==================================================================
302
303 #define CFGPATH_LAYOUT "Office.Calc/Layout"
304
305 #define SCLAYOUTOPT_GRIDLINES 0
306 #define SCLAYOUTOPT_GRIDCOLOR 1
307 #define SCLAYOUTOPT_PAGEBREAK 2
308 #define SCLAYOUTOPT_GUIDE 3
309 #define SCLAYOUTOPT_SIMPLECONT 4
310 #define SCLAYOUTOPT_LARGECONT 5
311 #define SCLAYOUTOPT_COLROWHDR 6
312 #define SCLAYOUTOPT_HORISCROLL 7
313 #define SCLAYOUTOPT_VERTSCROLL 8
314 #define SCLAYOUTOPT_SHEETTAB 9
315 #define SCLAYOUTOPT_OUTLINE 10
316 #define SCLAYOUTOPT_COUNT 11
317
318 #define CFGPATH_DISPLAY "Office.Calc/Content/Display"
319
320 #define SCDISPLAYOPT_FORMULA 0
321 #define SCDISPLAYOPT_ZEROVALUE 1
322 #define SCDISPLAYOPT_NOTETAG 2
323 #define SCDISPLAYOPT_VALUEHI 3
324 #define SCDISPLAYOPT_ANCHOR 4
325 #define SCDISPLAYOPT_TEXTOVER 5
326 #define SCDISPLAYOPT_OBJECTGRA 6
327 #define SCDISPLAYOPT_CHART 7
328 #define SCDISPLAYOPT_DRAWING 8
329 #define SCDISPLAYOPT_COUNT 9
330
331 #define CFGPATH_GRID "Office.Calc/Grid"
332
333 #define SCGRIDOPT_RESOLU_X 0
334 #define SCGRIDOPT_RESOLU_Y 1
335 #define SCGRIDOPT_SUBDIV_X 2
336 #define SCGRIDOPT_SUBDIV_Y 3
337 #define SCGRIDOPT_OPTION_X 4
338 #define SCGRIDOPT_OPTION_Y 5
339 #define SCGRIDOPT_SNAPTOGRID 6
340 #define SCGRIDOPT_SYNCHRON 7
341 #define SCGRIDOPT_VISIBLE 8
342 #define SCGRIDOPT_SIZETOGRID 9
343 #define SCGRIDOPT_COUNT 10
344
345
346 Sequence<OUString> ScViewCfg::GetLayoutPropertyNames()
347 {
348 static const char* aPropNames[] =
349 {
350 "Line/GridLine", // SCLAYOUTOPT_GRIDLINES
351 "Line/GridLineColor", // SCLAYOUTOPT_GRIDCOLOR
352 "Line/PageBreak", // SCLAYOUTOPT_PAGEBREAK
353 "Line/Guide", // SCLAYOUTOPT_GUIDE
354 "Line/SimpleControlPoint", // SCLAYOUTOPT_SIMPLECONT
355 "Line/LargeControlPoint", // SCLAYOUTOPT_LARGECONT
356 "Window/ColumnRowHeader", // SCLAYOUTOPT_COLROWHDR
357 "Window/HorizontalScroll", // SCLAYOUTOPT_HORISCROLL
358 "Window/VerticalScroll", // SCLAYOUTOPT_VERTSCROLL
359 "Window/SheetTab", // SCLAYOUTOPT_SHEETTAB
360 "Window/OutlineSymbol" // SCLAYOUTOPT_OUTLINE
361 };
362 Sequence<OUString> aNames(SCLAYOUTOPT_COUNT);
363 OUString* pNames = aNames.getArray();
364 for(int i = 0; i < SCLAYOUTOPT_COUNT; i++)
365 pNames[i] = OUString::createFromAscii(aPropNames[i]);
366
367 return aNames;
368 }
369
370 Sequence<OUString> ScViewCfg::GetDisplayPropertyNames()
371 {
372 static const char* aPropNames[] =
373 {
374 "Formula", // SCDISPLAYOPT_FORMULA
375 "ZeroValue", // SCDISPLAYOPT_ZEROVALUE
376 "NoteTag", // SCDISPLAYOPT_NOTETAG
377 "ValueHighlighting", // SCDISPLAYOPT_VALUEHI
378 "Anchor", // SCDISPLAYOPT_ANCHOR
379 "TextOverflow", // SCDISPLAYOPT_TEXTOVER
380 "ObjectGraphic", // SCDISPLAYOPT_OBJECTGRA
381 "Chart", // SCDISPLAYOPT_CHART
382 "DrawingObject" // SCDISPLAYOPT_DRAWING
383 };
384 Sequence<OUString> aNames(SCDISPLAYOPT_COUNT);
385 OUString* pNames = aNames.getArray();
386 for(int i = 0; i < SCDISPLAYOPT_COUNT; i++)
387 pNames[i] = OUString::createFromAscii(aPropNames[i]);
388
389 return aNames;
390 }
391
392 Sequence<OUString> ScViewCfg::GetGridPropertyNames()
393 {
394 static const char* aPropNames[] =
395 {
396 "Resolution/XAxis/NonMetric", // SCGRIDOPT_RESOLU_X
397 "Resolution/YAxis/NonMetric", // SCGRIDOPT_RESOLU_Y
398 "Subdivision/XAxis", // SCGRIDOPT_SUBDIV_X
399 "Subdivision/YAxis", // SCGRIDOPT_SUBDIV_Y
400 "Option/XAxis/NonMetric", // SCGRIDOPT_OPTION_X
401 "Option/YAxis/NonMetric", // SCGRIDOPT_OPTION_Y
402 "Option/SnapToGrid", // SCGRIDOPT_SNAPTOGRID
403 "Option/Synchronize", // SCGRIDOPT_SYNCHRON
404 "Option/VisibleGrid", // SCGRIDOPT_VISIBLE
405 "Option/SizeToGrid" // SCGRIDOPT_SIZETOGRID
406 };
407 Sequence<OUString> aNames(SCGRIDOPT_COUNT);
408 OUString* pNames = aNames.getArray();
409 for(int i = 0; i < SCGRIDOPT_COUNT; i++)
410 pNames[i] = OUString::createFromAscii(aPropNames[i]);
411
412 // adjust for metric system
413 if (ScOptionsUtil::IsMetricSystem())
414 {
415 pNames[SCGRIDOPT_RESOLU_X] = OUString::createFromAscii( "Resolution/XAxis/Metric" );
416 pNames[SCGRIDOPT_RESOLU_Y] = OUString::createFromAscii( "Resolution/YAxis/Metric" );
417 pNames[SCGRIDOPT_OPTION_X] = OUString::createFromAscii( "Option/XAxis/Metric" );
418 pNames[SCGRIDOPT_OPTION_Y] = OUString::createFromAscii( "Option/YAxis/Metric" );
419 }
420
421 return aNames;
422 }
423
424
425 ScViewCfg::ScViewCfg() :
426 aLayoutItem( OUString::createFromAscii( CFGPATH_LAYOUT ) ),
427 aDisplayItem( OUString::createFromAscii( CFGPATH_DISPLAY ) ),
428 aGridItem( OUString::createFromAscii( CFGPATH_GRID ) )
429 {
430 sal_Int32 nIntVal = 0;
431
432 Sequence<OUString> aNames = GetLayoutPropertyNames();
433 Sequence<Any> aValues = aLayoutItem.GetProperties(aNames);
434 aLayoutItem.EnableNotification(aNames);
435 const Any* pValues = aValues.getConstArray();
436 DBG_ASSERT(aValues.getLength() == aNames.getLength(), "GetProperties failed");
437 if(aValues.getLength() == aNames.getLength())
438 {
439 for(int nProp = 0; nProp < aNames.getLength(); nProp++)
440 {
441 DBG_ASSERT(pValues[nProp].hasValue(), "property value missing");
442 if(pValues[nProp].hasValue())
443 {
444 switch(nProp)
445 {
446 case SCLAYOUTOPT_GRIDCOLOR:
447 if ( pValues[nProp] >>= nIntVal )
448 SetGridColor( Color(nIntVal), EMPTY_STRING );
449 break;
450 case SCLAYOUTOPT_GRIDLINES:
451 SetOption( VOPT_GRID, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
452 break;
453 case SCLAYOUTOPT_PAGEBREAK:
454 SetOption( VOPT_PAGEBREAKS, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
455 break;
456 case SCLAYOUTOPT_GUIDE:
457 SetOption( VOPT_HELPLINES, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
458 break;
459 case SCLAYOUTOPT_SIMPLECONT:
460 // content is reversed
461 SetOption( VOPT_SOLIDHANDLES, !ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
462 break;
463 case SCLAYOUTOPT_LARGECONT:
464 SetOption( VOPT_BIGHANDLES, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
465 break;
466 case SCLAYOUTOPT_COLROWHDR:
467 SetOption( VOPT_HEADER, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
468 break;
469 case SCLAYOUTOPT_HORISCROLL:
470 SetOption( VOPT_HSCROLL, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
471 break;
472 case SCLAYOUTOPT_VERTSCROLL:
473 SetOption( VOPT_VSCROLL, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
474 break;
475 case SCLAYOUTOPT_SHEETTAB:
476 SetOption( VOPT_TABCONTROLS, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
477 break;
478 case SCLAYOUTOPT_OUTLINE:
479 SetOption( VOPT_OUTLINER, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
480 break;
481 }
482 }
483 }
484 }
485 aLayoutItem.SetCommitLink( LINK( this, ScViewCfg, LayoutCommitHdl ) );
486
487 aNames = GetDisplayPropertyNames();
488 aValues = aDisplayItem.GetProperties(aNames);
489 aDisplayItem.EnableNotification(aNames);
490 pValues = aValues.getConstArray();
491 DBG_ASSERT(aValues.getLength() == aNames.getLength(), "GetProperties failed");
492 if(aValues.getLength() == aNames.getLength())
493 {
494 for(int nProp = 0; nProp < aNames.getLength(); nProp++)
495 {
496 DBG_ASSERT(pValues[nProp].hasValue(), "property value missing");
497 if(pValues[nProp].hasValue())
498 {
499 switch(nProp)
500 {
501 case SCDISPLAYOPT_FORMULA:
502 SetOption( VOPT_FORMULAS, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
503 break;
504 case SCDISPLAYOPT_ZEROVALUE:
505 SetOption( VOPT_NULLVALS, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
506 break;
507 case SCDISPLAYOPT_NOTETAG:
508 SetOption( VOPT_NOTES, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
509 break;
510 case SCDISPLAYOPT_VALUEHI:
511 SetOption( VOPT_SYNTAX, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
512 break;
513 case SCDISPLAYOPT_ANCHOR:
514 SetOption( VOPT_ANCHOR, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
515 break;
516 case SCDISPLAYOPT_TEXTOVER:
517 SetOption( VOPT_CLIPMARKS, ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
518 break;
519 case SCDISPLAYOPT_OBJECTGRA:
520 if ( pValues[nProp] >>= nIntVal )
521 {
522 //#i80528# adapt to new range eventually
523 if((sal_Int32)VOBJ_MODE_HIDE < nIntVal) nIntVal = (sal_Int32)VOBJ_MODE_SHOW;
524
525 SetObjMode( VOBJ_TYPE_OLE, (ScVObjMode)nIntVal);
526 }
527 break;
528 case SCDISPLAYOPT_CHART:
529 if ( pValues[nProp] >>= nIntVal )
530 {
531 //#i80528# adapt to new range eventually
532 if((sal_Int32)VOBJ_MODE_HIDE < nIntVal) nIntVal = (sal_Int32)VOBJ_MODE_SHOW;
533
534 SetObjMode( VOBJ_TYPE_CHART, (ScVObjMode)nIntVal);
535 }
536 break;
537 case SCDISPLAYOPT_DRAWING:
538 if ( pValues[nProp] >>= nIntVal )
539 {
540 //#i80528# adapt to new range eventually
541 if((sal_Int32)VOBJ_MODE_HIDE < nIntVal) nIntVal = (sal_Int32)VOBJ_MODE_SHOW;
542
543 SetObjMode( VOBJ_TYPE_DRAW, (ScVObjMode)nIntVal);
544 }
545 break;
546 }
547 }
548 }
549 }
550 aDisplayItem.SetCommitLink( LINK( this, ScViewCfg, DisplayCommitHdl ) );
551
552 ScGridOptions aGrid = GetGridOptions(); //! initialization necessary?
553 aNames = GetGridPropertyNames();
554 aValues = aGridItem.GetProperties(aNames);
555 aGridItem.EnableNotification(aNames);
556 pValues = aValues.getConstArray();
557 DBG_ASSERT(aValues.getLength() == aNames.getLength(), "GetProperties failed");
558 if(aValues.getLength() == aNames.getLength())
559 {
560 for(int nProp = 0; nProp < aNames.getLength(); nProp++)
561 {
562 DBG_ASSERT(pValues[nProp].hasValue(), "property value missing");
563 if(pValues[nProp].hasValue())
564 {
565 switch(nProp)
566 {
567 case SCGRIDOPT_RESOLU_X:
568 if (pValues[nProp] >>= nIntVal) aGrid.SetFldDrawX( nIntVal );
569 break;
570 case SCGRIDOPT_RESOLU_Y:
571 if (pValues[nProp] >>= nIntVal) aGrid.SetFldDrawY( nIntVal );
572 break;
573 case SCGRIDOPT_SUBDIV_X:
574 if (pValues[nProp] >>= nIntVal) aGrid.SetFldDivisionX( nIntVal );
575 break;
576 case SCGRIDOPT_SUBDIV_Y:
577 if (pValues[nProp] >>= nIntVal) aGrid.SetFldDivisionY( nIntVal );
578 break;
579 case SCGRIDOPT_OPTION_X:
580 if (pValues[nProp] >>= nIntVal) aGrid.SetFldSnapX( nIntVal );
581 break;
582 case SCGRIDOPT_OPTION_Y:
583 if (pValues[nProp] >>= nIntVal) aGrid.SetFldSnapY( nIntVal );
584 break;
585 case SCGRIDOPT_SNAPTOGRID:
586 aGrid.SetUseGridSnap( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
587 break;
588 case SCGRIDOPT_SYNCHRON:
589 aGrid.SetSynchronize( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
590 break;
591 case SCGRIDOPT_VISIBLE:
592 aGrid.SetGridVisible( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
593 break;
594 case SCGRIDOPT_SIZETOGRID:
595 aGrid.SetEqualGrid( ScUnoHelpFunctions::GetBoolFromAny( pValues[nProp] ) );
596 break;
597 }
598 }
599 }
600 }
601 SetGridOptions( aGrid );
602 aGridItem.SetCommitLink( LINK( this, ScViewCfg, GridCommitHdl ) );
603 }
604
605 IMPL_LINK( ScViewCfg, LayoutCommitHdl, void *, EMPTYARG )
606 {
607 Sequence<OUString> aNames = GetLayoutPropertyNames();
608 Sequence<Any> aValues(aNames.getLength());
609 Any* pValues = aValues.getArray();
610
611 for(int nProp = 0; nProp < aNames.getLength(); nProp++)
612 {
613 switch(nProp)
614 {
615 case SCLAYOUTOPT_GRIDCOLOR:
616 pValues[nProp] <<= (sal_Int32) GetGridColor().GetColor();
617 break;
618 case SCLAYOUTOPT_GRIDLINES:
619 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_GRID ) );
620 break;
621 case SCLAYOUTOPT_PAGEBREAK:
622 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_PAGEBREAKS ) );
623 break;
624 case SCLAYOUTOPT_GUIDE:
625 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_HELPLINES ) );
626 break;
627 case SCLAYOUTOPT_SIMPLECONT:
628 // content is reversed
629 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], !GetOption( VOPT_SOLIDHANDLES ) );
630 break;
631 case SCLAYOUTOPT_LARGECONT:
632 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_BIGHANDLES ) );
633 break;
634 case SCLAYOUTOPT_COLROWHDR:
635 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_HEADER ) );
636 break;
637 case SCLAYOUTOPT_HORISCROLL:
638 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_HSCROLL ) );
639 break;
640 case SCLAYOUTOPT_VERTSCROLL:
641 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_VSCROLL ) );
642 break;
643 case SCLAYOUTOPT_SHEETTAB:
644 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_TABCONTROLS ) );
645 break;
646 case SCLAYOUTOPT_OUTLINE:
647 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_OUTLINER ) );
648 break;
649 }
650 }
651 aLayoutItem.PutProperties(aNames, aValues);
652
653 return 0;
654 }
655
656 IMPL_LINK( ScViewCfg, DisplayCommitHdl, void *, EMPTYARG )
657 {
658 Sequence<OUString> aNames = GetDisplayPropertyNames();
659 Sequence<Any> aValues(aNames.getLength());
660 Any* pValues = aValues.getArray();
661
662 for(int nProp = 0; nProp < aNames.getLength(); nProp++)
663 {
664 switch(nProp)
665 {
666 case SCDISPLAYOPT_FORMULA:
667 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_FORMULAS ) );
668 break;
669 case SCDISPLAYOPT_ZEROVALUE:
670 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_NULLVALS ) );
671 break;
672 case SCDISPLAYOPT_NOTETAG:
673 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_NOTES ) );
674 break;
675 case SCDISPLAYOPT_VALUEHI:
676 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_SYNTAX ) );
677 break;
678 case SCDISPLAYOPT_ANCHOR:
679 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_ANCHOR ) );
680 break;
681 case SCDISPLAYOPT_TEXTOVER:
682 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], GetOption( VOPT_CLIPMARKS ) );
683 break;
684 case SCDISPLAYOPT_OBJECTGRA:
685 pValues[nProp] <<= (sal_Int32) GetObjMode( VOBJ_TYPE_OLE );
686 break;
687 case SCDISPLAYOPT_CHART:
688 pValues[nProp] <<= (sal_Int32) GetObjMode( VOBJ_TYPE_CHART );
689 break;
690 case SCDISPLAYOPT_DRAWING:
691 pValues[nProp] <<= (sal_Int32) GetObjMode( VOBJ_TYPE_DRAW );
692 break;
693 }
694 }
695 aDisplayItem.PutProperties(aNames, aValues);
696
697 return 0;
698 }
699
700 IMPL_LINK( ScViewCfg, GridCommitHdl, void *, EMPTYARG )
701 {
702 const ScGridOptions& rGrid = GetGridOptions();
703
704 Sequence<OUString> aNames = GetGridPropertyNames();
705 Sequence<Any> aValues(aNames.getLength());
706 Any* pValues = aValues.getArray();
707
708 for(int nProp = 0; nProp < aNames.getLength(); nProp++)
709 {
710 switch(nProp)
711 {
712 case SCGRIDOPT_RESOLU_X:
713 pValues[nProp] <<= (sal_Int32) rGrid.GetFldDrawX();
714 break;
715 case SCGRIDOPT_RESOLU_Y:
716 pValues[nProp] <<= (sal_Int32) rGrid.GetFldDrawY();
717 break;
718 case SCGRIDOPT_SUBDIV_X:
719 pValues[nProp] <<= (sal_Int32) rGrid.GetFldDivisionX();
720 break;
721 case SCGRIDOPT_SUBDIV_Y:
722 pValues[nProp] <<= (sal_Int32) rGrid.GetFldDivisionY();
723 break;
724 case SCGRIDOPT_OPTION_X:
725 pValues[nProp] <<= (sal_Int32) rGrid.GetFldSnapX();
726 break;
727 case SCGRIDOPT_OPTION_Y:
728 pValues[nProp] <<= (sal_Int32) rGrid.GetFldSnapY();
729 break;
730 case SCGRIDOPT_SNAPTOGRID:
731 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], rGrid.GetUseGridSnap() );
732 break;
733 case SCGRIDOPT_SYNCHRON:
734 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], rGrid.GetSynchronize() );
735 break;
736 case SCGRIDOPT_VISIBLE:
737 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], rGrid.GetGridVisible() );
738 break;
739 case SCGRIDOPT_SIZETOGRID:
740 ScUnoHelpFunctions::SetBoolInAny( pValues[nProp], rGrid.GetEqualGrid() );
741 break;
742 }
743 }
744 aGridItem.PutProperties(aNames, aValues);
745
746 return 0;
747 }
748
749 void ScViewCfg::SetOptions( const ScViewOptions& rNew )
750 {
751 *(ScViewOptions*)this = rNew;
752 aLayoutItem.SetModified();
753 aDisplayItem.SetModified();
754 aGridItem.SetModified();
755 }
756
757
vba interoperability for OOo