kspread

kspread_dlg_preference.cpp
1/* This file is part of the KDE project
2 Copyright (C) 2005 Raphael Langerhorst <raphael.langerhorst@kdemail.net>
3 (C) 2002-2004 Ariya Hidayat <ariya@kde.org>
4 (C) 2002-2003 Norbert Andres <nandres@web.de>
5 (C) 2000-2005 Laurent Montel <montel@kde.org>
6 (C) 2002 John Dailey <dailey@vt.edu>
7 (C) 2002 Philipp Mueller <philipp.mueller@gmx.de>
8 (C) 2001-2002 David Faure <faure@kde.org>
9 (C) 2001 Werner Trobin <trobin@kde.org>
10 (C) 2000 Bernd Johannes Wuebben <wuebben@kde.org>
11
12 This library is free software; you can redistribute it and/or
13 modify it under the terms of the GNU Library General Public
14 License as published by the Free Software Foundation; either
15 version 2 of the License, or (at your option) any later version.
16
17 This library is distributed in the hope that it will be useful,
18 but WITHOUT ANY WARRANTY; without even the implied warranty of
19 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
20 Library General Public License for more details.
21
22 You should have received a copy of the GNU Library General Public License
23 along with this library; see the file COPYING.LIB. If not, write to
24 the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor,
25 * Boston, MA 02110-1301, USA.
26*/
27
28#include <tqvbox.h>
29#include <tqlayout.h>
30#include <tqcheckbox.h>
31#include <tqcombobox.h>
32#include <tqvgroupbox.h>
33#include <tqwhatsthis.h>
34
35#include <tdeconfig.h>
36#include <kstatusbar.h>
37#include <knuminput.h>
38#include <tdespell.h>
39#include <tdemessagebox.h>
40#include <kcolorbutton.h>
41
42#include <KoTabBar.h>
43#include <KoSpeaker.h>
44
45#include "kspread_sheet.h"
46#include "kspread_sheetprint.h"
47#include "kspread_doc.h"
48#include "kspread_canvas.h"
49#include "kspread_view.h"
50#include "kspread_locale.h"
51#include "kspread_editors.h"
52
53#include "kspread_dlg_preference.h"
54
55using namespace KSpread;
56
57PreferenceDialog::PreferenceDialog( View* parent, const char* /*name*/)
58 : KDialogBase(KDialogBase::IconList,i18n("Configure KSpread") ,
59 KDialogBase::Ok | KDialogBase::Cancel| KDialogBase::Default,
60 KDialogBase::Ok)
61
62{
63 m_pView=parent;
64
65 connect(this, TQ_SIGNAL(okClicked()),this,TQ_SLOT(slotApply()));
66
67 TQVBox *page2=addVBoxPage(i18n("Locale Settings"), TQString(),BarIcon("go-home",TDEIcon::SizeMedium));
68 _localePage=new parameterLocale(parent,page2 );
69
70 TQVBox *page3=addVBoxPage(i18n("Interface"), TQString(),BarIcon("signature", TDEIcon::SizeMedium) );
71 _configure = new configure(parent,page3 );
72
73 TQVBox * page4=addVBoxPage(i18n("Misc"), TQString(),BarIcon("misc",TDEIcon::SizeMedium) );
74 _miscParameter = new miscParameters(parent,page4 );
75
76 TQVBox *page5=addVBoxPage(i18n("Color"), TQString(),BarIcon("colorize",TDEIcon::SizeMedium) );
77 _colorParameter=new colorParameters(parent,page5 );
78
79 TQVBox *page6=addVBoxPage(i18n("Page Layout"), TQString(),BarIcon("edit",TDEIcon::SizeMedium) );
80 _layoutPage=new configureLayoutPage(parent,page6 );
81
82 TQVBox *page7 = addVBoxPage( i18n("Spelling"), i18n("Spell Checker Behavior"),
83 BarIcon("tools-check-spelling", TDEIcon::SizeMedium) );
84 _spellPage=new configureSpellPage(parent,page7);
85
86 if (KoSpeaker::isKttsdInstalled()) {
87 TQVBox *page8 = addVBoxPage( i18n("Abbreviation for Text-to-Speech", "TTS"),
88 i18n("Text-to-Speech Settings"), BarIcon("access", TDEIcon::SizeMedium) );
89 _ttsPage=new configureTTSPage(parent, page8);
90 } else _ttsPage = 0;
91
92}
93
94void PreferenceDialog::openPage(int flags)
95{
96 if(flags & KS_LOCALE)
97 showPage( 0 );
98 else if(flags & KS_INTERFACE)
99 showPage( 1 );
100 else if(flags & KS_MISC)
101 showPage( 2 );
102 else if(flags & KS_COLOR)
103 showPage( 3 );
104 else if(flags & KS_LAYOUT)
105 showPage( 4 );
106 else if(flags & KS_SPELLING)
107 showPage( 5 );
108}
109
110void PreferenceDialog::slotApply()
111{
112 m_pView->doc()->emitBeginOperation( false );
113 _configure->apply();
114 _miscParameter->apply();
115 _colorParameter->apply();
116 _layoutPage->apply();
117 _spellPage->apply();
118 _localePage->apply();
119 if (_ttsPage) _ttsPage->apply();
120 m_pView->doc()->refreshInterface();
121 m_pView->slotUpdateView( m_pView->activeSheet() );
122}
123
124void PreferenceDialog::slotDefault()
125{
126 switch(activePageIndex())
127 {
128 case 1:
129 _configure->slotDefault();
130 break;
131 case 2:
132 _miscParameter->slotDefault();
133 break;
134 case 3:
135 _colorParameter->slotDefault();
136 break;
137 case 4:
138 _layoutPage->slotDefault();
139 break;
140 case 5:
141 _spellPage->slotDefault();
142 break;
143 case 6:
144 _ttsPage->slotDefault();
145 break;
146 default:
147 break;
148 }
149}
150
151
152parameterLocale::parameterLocale( View* _view, TQVBox *box , char *name )
153 :TQObject ( box->parent(),name)
154{
155 m_pView = _view;
156 m_bUpdateLocale=false;
157 TQGroupBox* tmpTQGroupBox = new TQVGroupBox( i18n("Settings"), box, "GroupBox" );
158
159 TDELocale* locale=_view->doc()->locale();
160
161 m_language=new TQLabel( tmpTQGroupBox,"label");
162 m_number=new TQLabel( tmpTQGroupBox,"label6");
163 m_date=new TQLabel( tmpTQGroupBox,"label1");
164 m_shortDate=new TQLabel( tmpTQGroupBox,"label5");
165 m_time=new TQLabel( tmpTQGroupBox,"label2");
166 m_money=new TQLabel( tmpTQGroupBox,"label3");
167
168 updateToMatchLocale(locale);
169
170 m_updateButton=new TQPushButton ( i18n("&Update Locale Settings"), tmpTQGroupBox);
171 connect(m_updateButton, TQ_SIGNAL(clicked()),this,TQ_SLOT(updateDefaultSystemConfig()));
172}
173
174void parameterLocale::apply()
175{
176 if (m_bUpdateLocale)
177 {
178 m_pView->doc()->emitBeginOperation( false );
179 m_pView->doc()->refreshLocale();
180 m_pView->slotUpdateView( m_pView->activeSheet() );
181 }
182}
183
184void parameterLocale::updateDefaultSystemConfig()
185{
186 m_bUpdateLocale=true;
187 static_cast<Locale*>(m_pView->doc()->locale())->defaultSystemConfig( );
188 TDELocale* locale=m_pView->doc()->locale();
189 updateToMatchLocale( locale );
190}
191
192void parameterLocale::updateToMatchLocale(TDELocale* locale)
193{
194 m_language->setText( i18n("Language: %1").arg( locale->language() ));
195 m_number->setText( i18n("Default number format: %1").arg( locale->formatNumber(12.55) ));
196 m_date->setText( i18n("Long date format: %1").arg( locale->formatDate( TQDate::currentDate() )));
197 m_shortDate->setText( i18n("Short date format: %1").arg( locale->formatDate( TQDate::currentDate() ,true) ));
198 m_time->setText( i18n("Time format: %1").arg( locale->formatTime( TQTime::currentTime() ) ));
199 m_money->setText( i18n("Currency format: %1").arg( locale->formatMoney(12.55) ));
200}
201
202configure::configure( View* _view, TQVBox *box , char *name )
203 :TQObject ( box->parent(),name)
204 {
205 m_pView = _view;
206
207 bool vertical=true;
208 bool horizontal=true;
209 bool rowHeader=true;
210 bool colHeader=true;
211 bool tabbar=true;
212 bool formulaBar=true;
213 bool statusBar=true;
214 m_oldBackupFile = true;
215
216 TQGroupBox* tmpTQGroupBox = new TQVGroupBox( i18n("Settings"), box, "GroupBox" );
217
218 config = Factory::global()->config();
219 int _page=1;
220
221 oldRecent=10;
222 oldAutoSaveValue=KoDocument::defaultAutoSave()/60;
223
224 if( config->hasGroup("Parameters" ))
225 {
226 config->setGroup( "Parameters" );
227 _page=config->readNumEntry( "NbPage" ,1) ;
228 horizontal=config->readBoolEntry("Horiz ScrollBar",true);
229 vertical=config->readBoolEntry("Vert ScrollBar",true);
230 colHeader=config->readBoolEntry("Column Header",true);
231 rowHeader=config->readBoolEntry("Row Header",true);
232 tabbar=config->readBoolEntry("Tabbar",true);
233 formulaBar=config->readBoolEntry("Formula bar",true);
234 statusBar=config->readBoolEntry("Status bar",true);
235 oldRecent=config->readNumEntry( "NbRecentFile" ,10);
236 oldAutoSaveValue=config->readNumEntry("AutoSave",KoDocument::defaultAutoSave()/60);
237 m_oldBackupFile=config->readBoolEntry("BackupFile",m_oldBackupFile);
238 }
239 nbPage=new KIntNumInput(_page, tmpTQGroupBox , 10);
240 nbPage->setRange(1, 10, 1);
241 nbPage->setLabel(i18n("Number of sheets open at the &beginning:"));
242 TQWhatsThis::add(nbPage, i18n( "Controls how many worksheets will be created if the option Start with an empty document is chosen when KSpread is started." ) );
243
244 nbRecentFile=new KIntNumInput(oldRecent, tmpTQGroupBox , 10);
245 nbRecentFile->setRange(1, 20, 1);
246 nbRecentFile->setLabel(i18n("&Number of files to show in Recent Files list:"));
247 TQWhatsThis::add(nbRecentFile, i18n( "Controls the maximum number of filenames that are shown when you select File-> Open Recent." ) );
248
249 autoSaveDelay=new KIntNumInput(oldAutoSaveValue, tmpTQGroupBox , 10);
250 autoSaveDelay->setRange(0, 60, 1);
251 autoSaveDelay->setLabel(i18n("Au&tosave delay (minutes):"));
252 autoSaveDelay->setSpecialValueText(i18n("Do not save automatically"));
253 autoSaveDelay->setSuffix(i18n("min"));
254 TQWhatsThis::add(autoSaveDelay, i18n( "Here you can select the time between autosaves, or disable this feature altogether by choosing Do not save automatically (drag the slider to the far left)." ) );
255
256 m_createBackupFile = new TQCheckBox( i18n("Create backup files"), tmpTQGroupBox );
257 m_createBackupFile->setChecked( m_oldBackupFile );
258 TQWhatsThis::add(m_createBackupFile, i18n( "Check this box if you want some backup files created. This is checked per default." ) );
259
260 showVScrollBar=new TQCheckBox(i18n("Show &vertical scrollbar"),tmpTQGroupBox);
261 showVScrollBar->setChecked(vertical);
262 TQWhatsThis::add(showVScrollBar, i18n( "Check or uncheck this box to show or hide the vertical scrollbar in all sheets." ) );
263
264 showHScrollBar=new TQCheckBox(i18n("Show &horizontal scrollbar"),tmpTQGroupBox);
265 showHScrollBar->setChecked(horizontal);
266 TQWhatsThis::add(showHScrollBar, i18n( "Check or uncheck this box to show or hide the horizontal scrollbar in all sheets." ) );
267
268 showColHeader=new TQCheckBox(i18n("Show c&olumn header"),tmpTQGroupBox);
269 showColHeader->setChecked(colHeader);
270 TQWhatsThis::add(showColHeader, i18n( "Check this box to show the column letters across the top of each worksheet." ) );
271 showRowHeader=new TQCheckBox(i18n("Show &row header"),tmpTQGroupBox);
272 showRowHeader->setChecked(rowHeader);
273 TQWhatsThis::add(showRowHeader, i18n( "Check this box to show the row numbers down the left side." ) );
274
275 showTabBar =new TQCheckBox(i18n("Show ta&bs"),tmpTQGroupBox);
276 showTabBar->setChecked(tabbar);
277 TQWhatsThis::add(showTabBar, i18n( "This check box controls whether the sheet tabs are shown at the bottom of the worksheet." ) );
278
279 showFormulaBar =new TQCheckBox(i18n("Sho&w formula toolbar"),tmpTQGroupBox);
280 showFormulaBar->setChecked(formulaBar);
281 TQWhatsThis::add(showFormulaBar, i18n( "Here is where you can choose to show or hide the Formula bar." ) );
282
283 showStatusBar =new TQCheckBox(i18n("Show stat&us bar"),tmpTQGroupBox);
284 showStatusBar->setChecked(statusBar);
285 TQWhatsThis::add(showStatusBar, i18n( "Uncheck this box if you want to hide the status bar." ) );
286}
287
288
289void configure::slotDefault()
290{
291 showHScrollBar->setChecked(true);
292 showRowHeader->setChecked(true);
293 showVScrollBar->setChecked(true);
294 showColHeader->setChecked(true);
295 showTabBar->setChecked(true);
296 showFormulaBar->setChecked(true);
297 showStatusBar->setChecked(true);
298 nbPage->setValue(1);
299 nbRecentFile->setValue(10);
300 autoSaveDelay->setValue(KoDocument::defaultAutoSave()/60);
301 m_createBackupFile->setChecked( true );
302}
303
304
305void configure::apply()
306{
307 m_pView->doc()->emitBeginOperation( false );
308 config->setGroup( "Parameters" );
309 config->writeEntry( "NbPage", nbPage->value());
310 Doc *doc =m_pView->doc();
311 bool active=true;
312 active=showHScrollBar->isChecked();
313 if( m_pView->horzScrollBar()->isVisible()!=active)
314 {
315 config->writeEntry( "Horiz ScrollBar",active);
316 if( active)
317 m_pView->horzScrollBar()->show();
318 else
319 m_pView->horzScrollBar()->hide();
320 doc->setShowHorizontalScrollBar(active);
321 }
322 active=showVScrollBar->isChecked();
323 if( m_pView->vertScrollBar()->isVisible()!=active)
324 {
325 config->writeEntry( "Vert ScrollBar", active);
326 if(active)
327 m_pView->vertScrollBar()->show();
328 else
329 m_pView->vertScrollBar()->hide();
330 doc->setShowVerticalScrollBar(active);
331
332 }
333 active=showColHeader->isChecked();
334 if( m_pView->hBorderWidget()->isVisible()!=active)
335 {
336 config->writeEntry( "Column Header", active);
337 if( active)
338 m_pView->hBorderWidget()->show();
339 else
340 m_pView->hBorderWidget()->hide();
341 doc->setShowColHeader(active);
342 }
343
344 active=showRowHeader->isChecked();
345 if( m_pView->vBorderWidget()->isVisible()!=active)
346 {
347 config->writeEntry( "Row Header", active);
348 if( active)
349 m_pView->vBorderWidget()->show();
350 else
351 m_pView->vBorderWidget()->hide();
352 doc->setShowRowHeader(active);
353 }
354
355 active=showTabBar->isChecked();
356 if(m_pView->tabBar()->isVisible()!=active)
357 {
358 config->writeEntry( "Tabbar", active);
359 if(active)
360 m_pView->tabBar()->show();
361 else
362 m_pView->tabBar()->hide();
363 doc->setShowTabBar(active);
364 }
365
366 active=showFormulaBar->isChecked();
367 if(m_pView->posWidget()->isVisible()!=active)
368 {
369 config->writeEntry( "Formula bar",active);
370 m_pView->editWidget()->showEditWidget(active);
371 if(active)
372 m_pView->posWidget()->show();
373 else
374 m_pView->posWidget()->hide();
375 doc->setShowFormulaBar(active);
376 }
377
378 active=showStatusBar->isChecked();
379 config->writeEntry( "Status bar",active);
380 m_pView->showStatusBar( active );
381
382 int val=nbRecentFile->value();
383 if( oldRecent!= val)
384 {
385 config->writeEntry( "NbRecentFile",val);
386 m_pView->changeNbOfRecentFiles(val);
387 }
388 val=autoSaveDelay->value();
389 if(val!=oldAutoSaveValue)
390 {
391 config->writeEntry( "AutoSave", val );
392 doc->setAutoSave(val*60);
393 }
394
395 bool state =m_createBackupFile->isChecked();
396 if(state!=m_oldBackupFile)
397 {
398 config->writeEntry( "BackupFile", state );
399 doc->setBackupFile( state);
400 m_oldBackupFile=state;
401 }
402
403 m_pView->slotUpdateView( m_pView->activeSheet() );
404}
405
406
407miscParameters::miscParameters( View* _view,TQVBox *box, char *name )
408 :TQObject ( box->parent(),name)
409 {
410 m_pView = _view;
411
412
413 TQGroupBox* tmpTQGroupBox = new TQVGroupBox( i18n("Misc"), box, "GroupBox" );
414
415 config = Factory::global()->config();
416 indentUnit = _view->doc()->unit();
417 double _indent = KoUnit::toUserValue( 10.0, indentUnit);
418 bool m_bMsgError=false;
419 if( config->hasGroup("Parameters" ))
420 {
421 config->setGroup( "Parameters" );
422 _indent = config->readDoubleNumEntry( "Indent" , _indent ) ;
423 m_bMsgError=config->readBoolEntry( "Msg error" ,false) ;
424 }
425
426 if( config->hasGroup("Misc") )
427 {
428 config->setGroup( "Misc" );
429 m_oldNbRedo=config->readNumEntry("UndoRedo",m_oldNbRedo);
430 }
431
432 m_undoRedoLimit=new KIntNumInput( m_oldNbRedo, tmpTQGroupBox );
433 m_undoRedoLimit->setLabel(i18n("Undo/redo limit:"));
434 m_undoRedoLimit->setRange(10, 60, 1);
435
436
437 TQLabel *label=new TQLabel(i18n("&Completion mode:"), tmpTQGroupBox);
438
439 typeCompletion=new TQComboBox(tmpTQGroupBox);
440 label->setBuddy(typeCompletion);
441 TQWhatsThis::add(typeCompletion, i18n( "Lets you choose the (auto) text completion mode from a range of options in the drop down selection box." ) );
442 TQStringList listType;
443 listType+=i18n("None");
444 listType+=i18n("Manual");
445 listType+=i18n("Popup");
446 listType+=i18n("Automatic");
447 listType+=i18n("Semi-Automatic");
448 typeCompletion->insertStringList(listType);
449 typeCompletion->setCurrentItem(0);
450 comboChanged=false;
451 connect(typeCompletion,TQ_SIGNAL(activated( const TQString & )),this,TQ_SLOT(slotTextComboChanged(const TQString &)));
452
453 label=new TQLabel(i18n("&Pressing enter moves cell cursor:"), tmpTQGroupBox);
454 typeOfMove=new TQComboBox( tmpTQGroupBox);
455 label->setBuddy(typeOfMove);
456 listType.clear();
457 listType+=i18n("Down");
458 listType+=i18n("Up");
459 listType+=i18n("Right");
460 listType+=i18n("Left");
461 listType+=i18n("Down, First Column");
462 typeOfMove->insertStringList(listType);
463 typeOfMove->setCurrentItem(0);
464 TQWhatsThis::add(typeOfMove, i18n( "When you have selected a cell, pressing the Enter key will move the cell cursor one cell left, right, up or down, as determined by this setting." ) );
465
466 label=new TQLabel(i18n("&Method of calc:"), tmpTQGroupBox);
467
468 typeCalc=new TQComboBox( tmpTQGroupBox);
469 label->setBuddy(typeCalc);
470 TQStringList listTypeCalc;
471 listTypeCalc+=i18n("Sum");
472 listTypeCalc+=i18n("Min");
473 listTypeCalc+=i18n("Max");
474 listTypeCalc+=i18n("Average");
475 listTypeCalc+=i18n("Count");
476 listTypeCalc+=i18n("CountA");
477 listTypeCalc+=i18n("None");
478 typeCalc->insertStringList(listTypeCalc);
479 typeCalc->setCurrentItem(0);
480 TQWhatsThis::add(typeCalc, i18n( "This drop down selection box can be used to choose the calculation performed by the Statusbar Summary function." ) );
481
482// valIndent = new KDoubleNumInput( _indent, tmpTQGroupBox , 10.0 );
483 valIndent = new KDoubleNumInput( tmpTQGroupBox );
484 valIndent->setRange( KoUnit::toUserValue( 0.0, indentUnit ),
485 KoUnit::toUserValue( 400.0, indentUnit ),
486 KoUnit::toUserValue( 10.0, indentUnit) );
487// valIndent->setRange( 0.0, 100.0, 10.0 );
488 valIndent->setValue ( KoUnit::toUserValue( _indent, indentUnit ) );
489 TQWhatsThis::add(valIndent, i18n( "Lets you define the amount of indenting used by the Increase Indent and Decrease Indent option in the Format menu." ) );
490 valIndent->setLabel(i18n("&Indentation step (%1):").arg(KoUnit::unitName(indentUnit)));
491
492 msgError= new TQCheckBox(i18n("&Show error message for invalid formulae"),tmpTQGroupBox);
493 msgError->setChecked(m_bMsgError);
494 TQWhatsThis::add(msgError, i18n( "If this box is checked a message box will pop up when what you have entered into a cell cannot be understood by KSpread." ) );
495
496 initComboBox();
497}
498
499void miscParameters::slotTextComboChanged(const TQString &)
500{
501 comboChanged=true;
502}
503
504void miscParameters::initComboBox()
505{
506 TDEGlobalSettings::Completion tmpCompletion=TDEGlobalSettings::CompletionAuto;
507 if( config->hasGroup("Parameters" ))
508 {
509 config->setGroup( "Parameters" );
510 tmpCompletion=( TDEGlobalSettings::Completion)config->readNumEntry( "Completion Mode" ,TDEGlobalSettings::CompletionAuto) ;
511 config->writeEntry( "Completion Mode", (int)tmpCompletion);
512 }
513switch(tmpCompletion )
514 {
515 case TDEGlobalSettings::CompletionNone:
516 typeCompletion->setCurrentItem(0);
517 break;
518 case TDEGlobalSettings::CompletionAuto:
519 typeCompletion->setCurrentItem(3);
520 break;
521 case TDEGlobalSettings::CompletionMan:
522 typeCompletion->setCurrentItem(4);
523 break;
524 case TDEGlobalSettings::CompletionShell:
525 typeCompletion->setCurrentItem(1);
526 break;
527 case TDEGlobalSettings::CompletionPopup:
528 typeCompletion->setCurrentItem(2);
529 break;
530 default :
531 typeCompletion->setCurrentItem(0);
532 break;
533 }
534switch( m_pView->doc()->getMoveToValue( ))
535 {
536 case KSpread::Bottom:
537 typeOfMove->setCurrentItem(0);
538 break;
539 case KSpread::Left:
540 typeOfMove->setCurrentItem(3);
541 break;
542 case KSpread::Top:
543 typeOfMove->setCurrentItem(1);
544 break;
545 case KSpread::Right:
546 typeOfMove->setCurrentItem(2);
547 break;
548 case KSpread::BottomFirst:
549 typeOfMove->setCurrentItem(4);
550 break;
551 default :
552 typeOfMove->setCurrentItem(0);
553 break;
554 }
555
556switch( m_pView->doc()->getTypeOfCalc())
557 {
558 case SumOfNumber:
559 typeCalc->setCurrentItem(0);
560 break;
561 case Min:
562 typeCalc->setCurrentItem(1);
563 break;
564 case Max:
565 typeCalc->setCurrentItem(2);
566 break;
567 case Average:
568 typeCalc->setCurrentItem(3);
569 break;
570 case Count:
571 typeCalc->setCurrentItem(4);
572 break;
573 case CountA:
574 typeCalc->setCurrentItem(5);
575 break;
576 case NoneCalc:
577 typeCalc->setCurrentItem(6);
578 break;
579 default :
580 typeCalc->setCurrentItem(0);
581 break;
582 }
583
584}
585
586void miscParameters::slotDefault()
587{
588 m_undoRedoLimit->setValue(30);
589 valIndent->setValue( KoUnit::toUserValue( 10.0, indentUnit) );
590 typeCompletion->setCurrentItem(3);
591 typeOfMove->setCurrentItem(0);
592 msgError->setChecked(false);
593 typeCalc->setCurrentItem(0);
594}
595
596
597void miscParameters::apply()
598{
599 kdDebug() << "Applying misc preferences" << endl;
600
601 config->setGroup( "Misc" );
602 int const newUndo=m_undoRedoLimit->value();
603 if( newUndo!=m_oldNbRedo )
604 {
605 config->writeEntry("UndoRedo",newUndo);
606 m_pView->doc()->setUndoRedoLimit(newUndo);
607 m_oldNbRedo=newUndo;
608 }
609
610 config->setGroup( "Parameters" );
611 TDEGlobalSettings::Completion tmpCompletion=TDEGlobalSettings::CompletionNone;
612
613 switch(typeCompletion->currentItem())
614 {
615 case 0:
616 tmpCompletion=TDEGlobalSettings::CompletionNone;
617 break;
618 case 1:
619 tmpCompletion=TDEGlobalSettings::CompletionShell;
620 break;
621 case 2:
622 tmpCompletion=TDEGlobalSettings::CompletionPopup;
623 break;
624 case 3:
625 tmpCompletion=TDEGlobalSettings::CompletionAuto;
626 break;
627 case 4:
628 tmpCompletion=TDEGlobalSettings::CompletionMan;
629 break;
630 }
631
632
633 if(comboChanged)
634 {
635 m_pView->doc()->setCompletionMode(tmpCompletion);
636 config->writeEntry( "Completion Mode", (int)tmpCompletion);
637 }
638
639 KSpread::MoveTo tmpMoveTo=KSpread::Bottom;
640 switch(typeOfMove->currentItem())
641 {
642 case 0:
643 tmpMoveTo=KSpread::Bottom;
644 break;
645 case 1:
646 tmpMoveTo=KSpread::Top;
647 break;
648 case 2:
649 tmpMoveTo=KSpread::Right;
650 break;
651 case 3:
652 tmpMoveTo=KSpread::Left;
653 break;
654 case 4:
655 tmpMoveTo=KSpread::BottomFirst;
656 break;
657 }
658 if(tmpMoveTo!=m_pView->doc()->getMoveToValue())
659 {
660 m_pView->doc()->setMoveToValue(tmpMoveTo);
661 config->writeEntry( "Move", (int)tmpMoveTo);
662 }
663
664 MethodOfCalc tmpMethodCalc=SumOfNumber;
665 switch(typeCalc->currentItem())
666 {
667 case 0:
668 tmpMethodCalc =SumOfNumber;
669 break;
670 case 1:
671 tmpMethodCalc=Min;
672 break;
673 case 2:
674 tmpMethodCalc=Max;
675 break;
676 case 3:
677 tmpMethodCalc=Average;
678 break;
679 case 4:
680 tmpMethodCalc=Count;
681 break;
682 case 5:
683 tmpMethodCalc=CountA;
684 break;
685 case 6:
686 tmpMethodCalc=NoneCalc;
687 break;
688
689 }
690 if(tmpMethodCalc!=m_pView->doc()->getTypeOfCalc())
691 {
692 m_pView->doc()->setTypeOfCalc(tmpMethodCalc);
693 config->writeEntry( "Method of Calc", (int)tmpMethodCalc);
694 m_pView->calcStatusBarOp();
695 m_pView->initCalcMenu();
696 }
697
698 double val = valIndent->value();
699 if( val != m_pView->doc()->getIndentValue() )
700 {
701 KoUnit::Unit oldUnit = m_pView->doc()->unit();
702 m_pView->doc()->setUnit(indentUnit);
703 m_pView->doc()->setIndentValue( val );
704 m_pView->doc()->setUnit(oldUnit);
705 config->writeEntry( "Indent", KoUnit::fromUserValue( val, indentUnit ) );
706 }
707
708 bool active=msgError->isChecked();
709 if(active!=m_pView->doc()->getShowMessageError())
710 {
711 m_pView->doc()->setShowMessageError( active);
712 config->writeEntry( "Msg error" ,(int)active);
713 }
714}
715
716
717
718colorParameters::colorParameters( View* _view,TQVBox *box , char *name )
719 :TQObject ( box->parent(),name)
720{
721 m_pView = _view;
722 config = Factory::global()->config();
723
724 TQColor _gridColor(TQt::lightGray);
725
726 if ( config->hasGroup("KSpread Color" ) )
727 {
728 config->setGroup( "KSpread Color" );
729 _gridColor = config->readColorEntry("GridColor",&_gridColor);
730 }
731
732 TQGroupBox* tmpTQGroupBox = new TQVGroupBox( i18n("Color"), box, "GroupBox" );
733
734 TQLabel *label = new TQLabel(i18n("&Grid color:"), tmpTQGroupBox,"label20" );
735
736 gridColor = new KColorButton( _gridColor,
737 TQt::lightGray,
738 tmpTQGroupBox );
739 TQWhatsThis::add(gridColor, i18n( "Click here to change the grid color ie the color of the borders of each cell." ) );
740 label->setBuddy(gridColor);
741
742 TQColor _pbColor(TQt::red);
743 if ( config->hasGroup("KSpread Color" ) )
744 {
745 config->setGroup( "KSpread Color" );
746 _pbColor = config->readColorEntry("PageBorderColor", &_pbColor);
747 }
748
749 TQLabel * label2 = new TQLabel( i18n("&Page borders:"), tmpTQGroupBox, "label21" );
750
751 pageBorderColor = new KColorButton( _pbColor,
752 TQt::red,
753 tmpTQGroupBox );
754 TQWhatsThis::add(pageBorderColor, i18n( "When the View ->Show Page Borders menu item is checked, the page borders are displayed. Click here to choose another color for the borders than the default red." ) );
755
756 label2->setBuddy(pageBorderColor);
757}
758
759void colorParameters::apply()
760{
761 TQColor _col = gridColor->color();
762 if ( m_pView->doc()->gridColor() != _col )
763 {
764 m_pView->doc()->setGridColor( _col );
765 config->setGroup( "KSpread Color" );
766 config->writeEntry( "GridColor", _col );
767 }
768
769 TQColor _pbColor = pageBorderColor->color();
770 if ( m_pView->doc()->pageBorderColor() != _pbColor )
771 {
772 m_pView->doc()->changePageBorderColor( _pbColor );
773 config->setGroup( "KSpread Color" );
774 config->writeEntry( "PageBorderColor", _pbColor );
775 }
776}
777
778void colorParameters::slotDefault()
779{
780 gridColor->setColor( lightGray );
781 pageBorderColor->setColor( red );
782}
783
784
785
786configureLayoutPage::configureLayoutPage( View* _view,TQVBox *box , char *name )
787 :TQObject ( box->parent(),name)
788{
789 m_pView = _view;
790
791 TQGroupBox* tmpTQGroupBox = new TQGroupBox( 0, TQt::Vertical, i18n("Default Parameters"), box, "GroupBox" );
792 tmpTQGroupBox->layout()->setSpacing(KDialog::spacingHint());
793 tmpTQGroupBox->layout()->setMargin(KDialog::marginHint());
794
795 TQGridLayout *grid1 = new TQGridLayout(tmpTQGroupBox->layout(),8,1);
796 grid1->addRowSpacing( 0, KDialog::marginHint() );
797 grid1->setRowStretch( 7, 10 );
798
799 config = Factory::global()->config();
800
801 TQLabel *label=new TQLabel(i18n("Default page &size:"), tmpTQGroupBox);
802
803 grid1->addWidget(label,0,0);
804
805 defaultSizePage=new TQComboBox( tmpTQGroupBox);
806 label->setBuddy(defaultSizePage);
807 defaultSizePage->insertStringList( KoPageFormat::allFormats() );
808 defaultSizePage->setCurrentItem(1);
809 TQWhatsThis::add(defaultSizePage, i18n( "Choose the default page size for your worksheet among all the most common page sizes.\nNote that you can overwrite the page size for the current sheet using the Format -> Page Layout... dialog." ) );
810 grid1->addWidget(defaultSizePage,1,0);
811
812 label=new TQLabel(i18n("Default page &orientation:"), tmpTQGroupBox);
813 grid1->addWidget(label,2,0);
814
815 defaultOrientationPage=new TQComboBox( tmpTQGroupBox);
816 label->setBuddy(defaultOrientationPage);
817
818 TQStringList listType;
819 listType+=i18n( "Portrait" );
820 listType+=i18n( "Landscape" );
821 defaultOrientationPage->insertStringList(listType);
822 defaultOrientationPage->setCurrentItem(0);
823 TQWhatsThis::add(defaultOrientationPage, i18n( "Choose the sheet orientation: portrait or lanscape.\nNote that you can overwrite the orientation for the current sheet using the Format -> Page Layout... dialog." ) );
824 grid1->addWidget(defaultOrientationPage,3,0);
825
826 label=new TQLabel(tmpTQGroupBox);
827 label->setText(i18n("Default page &unit:"));
828 grid1->addWidget(label,4,0);
829 defaultUnit=new TQComboBox( tmpTQGroupBox);
830 label->setBuddy(defaultUnit);
831
832 defaultUnit->insertStringList(KoUnit::listOfUnitName());
833 defaultUnit->setCurrentItem(0);
834 TQWhatsThis::add(defaultUnit, i18n( "Choose the default unit that will be used in your sheet.\nNote that you can overwrite the unit for the current sheet using the Format -> Page Layout... dialog." ) );
835 grid1->addWidget(defaultUnit,5,0);
836 initCombo();
837
838}
839
840void configureLayoutPage::slotDefault()
841{
842 defaultSizePage->setCurrentItem(1);
843 defaultOrientationPage->setCurrentItem(0);
844 defaultUnit->setCurrentItem(0);
845}
846
847void configureLayoutPage::initCombo()
848{
849 paper=1;
850 orientation=0;
851 unit=0;
852 if( config->hasGroup("KSpread Page Layout" ))
853 {
854 config->setGroup( "KSpread Page Layout" );
855 paper=config->readNumEntry( "Default size page" ,1);
856 orientation=config->readNumEntry( "Default orientation page" ,0);
857 unit=config->readNumEntry( "Default unit page" ,0);
858 }
859
860 defaultUnit->setCurrentItem(m_pView->doc()->unit());
861 defaultSizePage->setCurrentItem(paper);
862 defaultOrientationPage->setCurrentItem(orientation);
863}
864
865
866void configureLayoutPage::apply()
867{
868 m_pView->doc()->emitBeginOperation( false );
869 config->setGroup( "KSpread Page Layout" );
870
871 if( paper != defaultSizePage->currentItem() )
872 {
873 unsigned int sizePage = defaultSizePage->currentItem();
874 config->writeEntry( "Default size page", sizePage );
875 m_pView->activeSheet()->print()->setPaperFormat( (KoFormat)sizePage );
876 }
877 if( orientation != defaultOrientationPage->currentItem() )
878 {
879 unsigned int orientationPage = defaultOrientationPage->currentItem();
880 config->writeEntry( "Default orientation page", orientationPage );
881 m_pView->activeSheet()->print()->setPaperOrientation( (KoOrientation)orientationPage );
882 }
883 if( unit != defaultUnit->currentItem() )
884 {
885 unsigned int unitPage = defaultUnit->currentItem();
886 config->writeEntry( "Default unit page", unitPage );
887 m_pView->doc()->setUnit( (KoUnit::Unit)unitPage );
888 }
889 m_pView->slotUpdateView( m_pView->activeSheet() );
890}
891
892configureSpellPage::configureSpellPage( View* _view,TQVBox *box , char *name )
893 :TQObject ( box->parent(),name)
894{
895 m_pView = _view;
896
897 config = Factory::global()->config();
898
899
900 m_spellConfigWidget = new KSpellConfig( box, "spell_check",m_pView->doc()->getKSpellConfig()/*, false*/);
901 dontCheckUpperWord = new TQCheckBox( i18n("Skip all uppercase words"),box);
902 TQWhatsThis::add(dontCheckUpperWord, i18n( "If checked, the words written in uppercase letters are not spell checked. This might be useful if you have a lot of acronyms such as TDE for example." ) );
903 dontCheckTitleCase = new TQCheckBox( i18n("Do not check title case"),box);
904 TQWhatsThis::add(dontCheckTitleCase, i18n( "Check this box if you want the spellchecker to ignore the title case, for example My Own Spreadsheet or My own spreadsheet. If this is unchecked, the spell checker will ask for a uppercase letter in the title nouns." ) );
905
906 TQWidget* spacer = new TQWidget( box );
907 spacer->setSizePolicy( TQSizePolicy( TQSizePolicy::Minimum, TQSizePolicy::Expanding ) );
908
909 if( config->hasGroup("KSpell kspread") )
910 {
911 config->setGroup( "KSpell kspread" );
912
913 dontCheckUpperWord->setChecked(config->readBoolEntry("KSpell_dont_check_upper_word",false));
914 dontCheckTitleCase->setChecked(config->readBoolEntry("KSpell_dont_check_title_case",false));
915 }
916 //m_spellConfigWidget->addIgnoreList( m_pView->doc()->spellListIgnoreAll() );
917}
918
919
920void configureSpellPage::apply()
921{
922 m_pView->doc()->emitBeginOperation( false );
923
924 KSpellConfig *_spellConfig = m_spellConfigWidget;
925 config->setGroup( "KSpell kspread" );
926 config->writeEntry ("KSpell_NoRootAffix",(int) _spellConfig->noRootAffix ());
927 config->writeEntry ("KSpell_RunTogether", (int) _spellConfig->runTogether ());
928 config->writeEntry ("KSpell_Dictionary", _spellConfig->dictionary ());
929 config->writeEntry ("KSpell_DictFromList",(int) _spellConfig->dictFromList());
930 config->writeEntry ("KSpell_Encoding", (int) _spellConfig->encoding());
931 config->writeEntry ("KSpell_Client", _spellConfig->client());
932// m_spellConfigWidget->saveDictionary();
933 Doc* doc = m_pView->doc();
934 doc->setKSpellConfig(*_spellConfig);
935
936 bool state=dontCheckUpperWord->isChecked();
937 config->writeEntry ("KSpell_dont_check_upper_word",(int)state);
938 doc->setDontCheckUpperWord(state);
939
940 state=dontCheckTitleCase->isChecked();
941 config->writeEntry("KSpell_dont_check_title_case",(int)state);
942 doc->setDontCheckTitleCase(state);
943
944 //m_pView->doc()->addIgnoreWordAllList( m_spellConfigWidget->ignoreList() );
945
946 m_pView->slotUpdateView( m_pView->activeSheet() );
947}
948
949void configureSpellPage::slotDefault()
950{
951 //FIXME
952 //m_spellConfigWidget->setDefault();
953}
954
956
957configureTTSPage::configureTTSPage( View *_view, TQVBox *box, char *name )
958 : TQObject( box->parent(), name )
959{
960 Q_UNUSED(_view);
961
962 m_cbSpeakPointerWidget = new TQCheckBox(i18n("Speak widget under &mouse pointer"), box);
963 m_cbSpeakFocusWidget = new TQCheckBox(i18n("Speak widget with &focus"), box);
964 m_gbScreenReaderOptions = new TQVGroupBox("", box);
965 m_gbScreenReaderOptions->setMargin( KDialog::marginHint() );
966 m_gbScreenReaderOptions->setInsideSpacing( KDialog::spacingHint() );
967 m_cbSpeakTooltips = new TQCheckBox(i18n("Speak &tool tips"), m_gbScreenReaderOptions);
968 m_cbSpeakWhatsThis = new TQCheckBox(i18n("Speak &What's This"), m_gbScreenReaderOptions);
969 m_cbSpeakDisabled = new TQCheckBox(i18n("Verbal indication if widget is disabled (grayed)",
970 "&Say whether disabled"), m_gbScreenReaderOptions);
971 m_cbSpeakAccelerators = new TQCheckBox(i18n("Spea&k accelerators"), m_gbScreenReaderOptions);
972 TQHBox* hbAcceleratorPrefix = new TQHBox(m_gbScreenReaderOptions);
973 TQWidget* spacer = new TQWidget(hbAcceleratorPrefix);
974 spacer->setMinimumWidth(2 * KDialog::marginHint());
975 m_lblAcceleratorPrefix =
976 new TQLabel(i18n("A word spoken before another word", "Pr&efaced by the word:"),
977 hbAcceleratorPrefix);
978 m_leAcceleratorPrefixWord = new TQLineEdit(i18n("Keyboard accelerator, such as Alt+F", "Accelerator"),
979 hbAcceleratorPrefix);
980 m_lblAcceleratorPrefix->setBuddy(m_leAcceleratorPrefixWord);
981 TQHBox* hbPollingInterval = new TQHBox(m_gbScreenReaderOptions);
982 hbPollingInterval->setMargin( 0 );
983 TQLabel* lblPollingInterval = new TQLabel(i18n("&Polling interval:"), hbPollingInterval);
984 m_iniPollingInterval = new KIntNumInput(hbPollingInterval);
985 m_iniPollingInterval->setSuffix(" ms");
986 m_iniPollingInterval->setRange(100, 5000, 100, true);
987 lblPollingInterval->setBuddy(m_iniPollingInterval);
988
989 config = Factory::global()->config();
990 config->setGroup("TTS");
991 m_cbSpeakPointerWidget->setChecked(config->readBoolEntry("SpeakPointerWidget", false));
992 m_cbSpeakFocusWidget->setChecked(config->readBoolEntry("SpeakFocusWidget", false));
993 m_cbSpeakTooltips->setChecked(config->readBoolEntry("SpeakTooltips", true));
994 m_cbSpeakWhatsThis->setChecked(config->readBoolEntry("SpeakWhatsThis", false));
995 m_cbSpeakDisabled->setChecked(config->readBoolEntry("SpeakDisabled", true));
996 m_cbSpeakAccelerators->setChecked(config->readBoolEntry("SpeakAccelerators", true));
997 m_leAcceleratorPrefixWord->setText(config->readEntry("AcceleratorPrefixWord",
998 i18n("Keyboard accelerator, such as Alt+F", "Accelerator")));
999 m_iniPollingInterval->setValue(config->readNumEntry("PollingInterval", 600));
1000
1001 screenReaderOptionChanged();
1002 connect(m_cbSpeakPointerWidget, TQ_SIGNAL(toggled(bool)), this, TQ_SLOT(screenReaderOptionChanged()));
1003 connect(m_cbSpeakFocusWidget, TQ_SIGNAL(toggled(bool)), this, TQ_SLOT(screenReaderOptionChanged()));
1004 connect(m_cbSpeakAccelerators, TQ_SIGNAL(toggled(bool)), this, TQ_SLOT(screenReaderOptionChanged()));
1005}
1006
1007void configureTTSPage::slotDefault()
1008{
1009 m_cbSpeakPointerWidget->setChecked(false);
1010 m_cbSpeakFocusWidget->setChecked(false);
1011 m_cbSpeakTooltips->setChecked(true);
1012 m_cbSpeakWhatsThis->setChecked(false);
1013 m_cbSpeakDisabled->setChecked(true);
1014 m_cbSpeakAccelerators->setChecked(true);
1015 m_leAcceleratorPrefixWord->setText(i18n("Keyboard accelerator, such as Alt+F", "Accelerator"));
1016 m_iniPollingInterval->setValue(600);
1017}
1018
1019void configureTTSPage::apply()
1020{
1021 config->setGroup("TTS");
1022 config->writeEntry("SpeakPointerWidget", m_cbSpeakPointerWidget->isChecked());
1023 config->writeEntry("SpeakFocusWidget", m_cbSpeakFocusWidget->isChecked());
1024 config->writeEntry("SpeakTooltips", m_cbSpeakTooltips->isChecked());
1025 config->writeEntry("SpeakWhatsThis", m_cbSpeakWhatsThis->isChecked());
1026 config->writeEntry("SpeakDisabled", m_cbSpeakDisabled->isChecked());
1027 config->writeEntry("SpeakAccelerators", m_cbSpeakAccelerators->isChecked());
1028 config->writeEntry("AcceleratorPrefixWord", m_leAcceleratorPrefixWord->text());
1029 config->writeEntry("PollingInterval", m_iniPollingInterval->value());
1030 if (kospeaker) kospeaker->readConfig(config);
1031}
1032
1033void configureTTSPage::screenReaderOptionChanged()
1034{
1035 m_gbScreenReaderOptions->setEnabled(
1036 m_cbSpeakPointerWidget->isChecked() || m_cbSpeakFocusWidget->isChecked());
1037 m_leAcceleratorPrefixWord->setEnabled(m_cbSpeakAccelerators->isChecked());
1038 m_lblAcceleratorPrefix->setEnabled(m_cbSpeakAccelerators->isChecked());
1039}
1040
1041#include "kspread_dlg_preference.moc"
KSpread::Doc::setShowTabBar
void setShowTabBar(bool b)
If b is true, tab bar is visible, otherwise it will be hidden.
Definition kspread_doc.cpp:1412
KSpread::Doc::setShowVerticalScrollBar
void setShowVerticalScrollBar(bool b)
If b is true, vertical scrollbar is visible, otherwise it will be hidden.
Definition kspread_doc.cpp:1332
KSpread::Doc::setShowColHeader
void setShowColHeader(bool b)
Definition kspread_doc.h:265
KSpread::Doc::setShowHorizontalScrollBar
void setShowHorizontalScrollBar(bool b)
If b is true, horizontal scrollbar is visible, otherwise it will be hidden.
Definition kspread_doc.cpp:1342
KSpread::Doc::setShowFormulaBar
void setShowFormulaBar(bool b)
If b is true, formula bar is visible, otherwise it will be hidden.
Definition kspread_doc.cpp:1422
KSpread::Doc::setKSpellConfig
void setKSpellConfig(KSpellConfig _tdespell)
get custom tdespell config
Definition kspread_doc.cpp:1462
KSpread::Doc::setShowRowHeader
void setShowRowHeader(bool b)
If b is true, row header is visible, otherwise it will be hidden.
Definition kspread_doc.cpp:1367
KSpread::View
The View class displays a KSpread document.
Definition kspread_view.h:188
KSpread
The KSpread namespace.
Definition commands.h:39