<chapter id="configdialog">
<chapterinfo>
<authorgroup>
<author>
<firstname>Pamela</firstname>
<surname>Robert</surname>
<affiliation>
<address><email>pamroberts@blueyonder.co.uk</email></address>
</affiliation>
</author>
<!-- TRANS:ROLES_OF_TRANSLATORS -->
</authorgroup>
</chapterinfo>
<title>The &kspread; Configuration Dialog Box</title>

<para>Selecting <menuchoice><guimenu>Settings</guimenu><guimenuitem>
Configure Kspread...</guimenuitem></menuchoice> opens a dialog box 
with several pages, selected with the icons at the left of the dialog box, 
which allow you to change many aspects of &kspread;'s operation.</para>

<sect1 id="configpref">
<title><guilabel>Preferences</guilabel></title>
<para>This page has a number of check boxes which control how items are 
displayed, entered or calculated:

<variablelist>
<varlistentry>
<term><guilabel>Show formula</guilabel></term>
<listitem><para>If this box is checked &kspread; will display 
the actual formulae in cells rather than the results.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show formula indicator</guilabel></term>
<listitem><para>If this box is checked &kspread; will display a small blue 
triangle at the bottom left corner of cells containing formulae.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show grid</guilabel></term>
<listitem><para>Controls whether or not the sheet grid lines are shown.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show column number</guilabel></term>
<listitem><para>If this box is checked the column headings will show 
as numbers rather than as letters.
</para></listitem>
</varlistentry>
<varlistentry>

<term><guilabel>LC mode</guilabel></term>
<listitem><para>If this box is checked the cell reference shown at the 
left end of the Formula Bar will be displayed in LC mode 
(<abbrev>i.e.</abbrev> L2C3) rather than in its normal form B3. This does not 
seem to be of much use at the moment.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Automatic recalculation</guilabel></term>
<listitem><para>Controls whether formulae are recalculated 
automatically when the value of any cell they refer to changes.
</para></listitem>
</varlistentry>
<varlistentry>

<term><guilabel>Hide zero</guilabel></term>
<listitem><para>If this box is checked any cell containing the value 
zero will appear blank.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Convert first letter to uppercase</guilabel></term>
<listitem><para>Check this box and the first letter of any text you 
type in will automatically be converted to uppercase.
</para></listitem>
</varlistentry>

</variablelist></para>

</sect1>

<sect1 id="configlocale">
<title><guilabel>Locale Parameters</guilabel></title>
<para>This page of &kspread;'s configuration dialog box shows how items 
such as numbers, date, time and money are displayed.</para>
<para>If you have loaded a spreadsheet that was generated using a different 
locale, then pressing the <guibutton>Update to Locale System</guibutton> 
button on this page will update it to conform to your locale settings.</para>
</sect1>

<sect1 id="configinterface">
<title><guilabel>Interface</guilabel></title>
<para>This page of &kspread;'s configuration dialog box (obtained by selecting 
<guimenuitem>Configure Kspread...</guimenuitem> from the <guimenu>Settings
</guimenu> menu) controls some more &kspread; features:</para>

<para><variablelist>
<varlistentry>
<term><guilabel>Number of pages open at the beginning:</guilabel></term>
<listitem><para>Controls how many worksheets will be created if the 
option <guilabel>Start with an empty document</guilabel> is chosen when 
&kspread; is started.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Number of recent files:</guilabel></term>
<listitem><para>Controls the maximum number of filenames that are shown
when you select <menuchoice><guimenu>File</guimenu><guimenuitem>
Open Recent</guimenuitem></menuchoice>.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Auto save (min):</guilabel></term>
<listitem><para>Here you can select the time between autosaves, or disable 
this feature altogether by choosing <guilabel>No autosave</guilabel>
(drag the slider to the far left).
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show vertical scrollbar</guilabel></term>
<listitem><para>Check or uncheck this box to show or hide the vertical 
scrollbar.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show horizontal scrollbar</guilabel></term>
<listitem><para>Check or uncheck this box to show or hide the horizontal 
scrollbar.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show column header</guilabel></term>
<listitem><para>Check this box to show the column letters across the top of a 
worksheet.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show row header</guilabel></term>
<listitem><para>Check this box to show the row numbers down the left side.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show tabs</guilabel></term>
<listitem><para>This check box controls whether the sheet tabs are shown 
at the bottom of the worksheet.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show formula toolbar</guilabel></term>
<listitem><para>Here is where you can choose to show or hide the Formula bar.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show status bar</guilabel></term>
<listitem><para>Uncheck this box if you want to hide the status bar.
</para></listitem>
</varlistentry>

</variablelist></para>

</sect1>

<sect1 id="configmisc">
<title><guilabel>Misc</guilabel></title>
<para>The <guilabel>Misc</guilabel> page of &kspread;'s configuration 
dialog box contains the following items;</para>

<para><variablelist>
<varlistentry>
<term><guilabel>Completion mode:</guilabel></term>
<listitem><para>Lets you choose the (auto) text completion mode from a 
range of options in the drop down selection box.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Value of indent:</guilabel></term>
<listitem><para>Lets you define the amount of indenting used by the 
<guimenuitem>Increase indent</guimenuitem> option in the <guimenu>Format
</guimenu> menu.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Press enter to move selection to:</guilabel></term>
<listitem><para>When you have selected a cell then press the <keysym>Enter
</keysym> key the selection will move one place to the left, right, up or 
down as determined by the setting in this drop down selection box.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show error message</guilabel></term>
<listitem><para>If this box is checked a message box will pop up when what 
you have entered into a cell cannot be understood by &kspread;.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Method of calc:</guilabel></term>
<listitem><para>This drop down selection box can be used to choose the 
calculation performed by the <link linkend="statusbarsum">Statusbar Summary
</link> function..
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Show comment indicator</guilabel></term>
<listitem><para>If this box is checked cells containing comments will be 
marked by a small red triangle at the top right corner.
</para></listitem>
</varlistentry>

</variablelist></para>

</sect1>

<sect1 id="configcolor">
<title><guilabel>Color</guilabel></title>
<para>This page of &kspread;'s configuration dialog box lets you choose the 
color of the sheet grid. If you do not want the grid to appear at all uncheck 
the <guilabel>Show grid</guilabel> box
in the <link linkend="configpref"><guilabel>Preferences</guilabel></link> 
configuration page.</para>
<para>This page also lets you select the color of the lines used to indicate 
the printed page borders when the <guimenuitem>Show Page Borders</guimenuitem> 
box in the <guimenu>View</guimenu> menu is checked.</para>
</sect1>

<sect1 id="configpagelayout">
<title><guilabel>Page layout</guilabel></title>
<para>This page of &kspread;'s configuration dialog box lets you set up the 
default page size, orientation and units used by the printer and by the 
<guilabel>Page Layout</guilabel> dialog box (obtained by selecting 
<guimenuitem>Page Layout...</guimenuitem> from the <guimenu>Format
</guimenu> menu.</para>
</sect1>

<sect1 id="configspelling">
<title><guilabel>Spelling</guilabel></title>
<para>This page lets you configure the behavior of &kspread;'s spell 
checker.</para>
<para><variablelist>

<varlistentry>
<term><guilabel>Create root/affix combinations not in dictionary</guilabel>
</term>
<listitem><para>If this box is checked then when &kspread; finds a word in 
the document which it does not recognize but which consists of a recognized
root word plus a recognized prefix or suffix it will accept it, whereas if
the box is not checked the spell checker will reject it.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Consider run-together words as spelling errors</guilabel>
</term>
<listitem><para>If this box is checked then common words which are run 
together will be considered to be spelling errors, for example <emphasis>
cannot</emphasis>.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Dictionary:</guilabel></term>
<listitem><para>This drop down selection box can be used to select 
alternative dictionaries.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Encoding:</guilabel></term>
<listitem><para>To select the character encoding that should be used.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Client:</guilabel></term>
<listitem><para>This combo box lets you select between different spell 
checking programs that may be present on your computer.
</para></listitem>
</varlistentry>

<varlistentry>
<term><guilabel>Ignore uppercase words</guilabel></term>
<listitem><para>Check this box if you want the spellchecker to ignore 
uppercase words, which are usually acronyms such as &kde;.
</para></listitem>
</varlistentry>


</variablelist></para>
</sect1>
</chapter>

<!--
Local Variables:
mode: sgml
sgml-parent-document: ("index.docbook" "book" "chapter")
sgml-minimize-attributes:nil
sgml-general-insert-case:lower
sgml-indent-step:0
sgml-indent-data:nil
End:
-->
