Pamela
Robert

    pamroberts@blueyonder.co.uk

# The &kspread; Configuration Dialog Box

Selecting Settings Configure Kspread... 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.

## Preferences

This page has a number of check boxes which control how items are displayed, entered or calculated:

Show formula

  If this box is checked &kspread; will display the actual formulae in cells rather than the results.

Show formula indicator

  If this box is checked &kspread; will display a small blue triangle at the bottom left corner of cells containing formulae.

Show grid

  Controls whether or not the sheet grid lines are shown.

Show column number

  If this box is checked the column headings will show as numbers rather than as letters.

LC mode

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

Automatic recalculation

  Controls whether formulae are recalculated automatically when the value of any cell they refer to changes.

Hide zero

  If this box is checked any cell containing the value zero will appear blank.

Convert first letter to uppercase

  Check this box and the first letter of any text you type in will automatically be converted to uppercase.

## Locale Parameters

This page of &kspread;'s configuration dialog box shows how items such as numbers, date, time and money are displayed.

If you have loaded a spreadsheet that was generated using a different locale, then pressing the Update to Locale System button on this page will update it to conform to your locale settings.

## Interface

This page of &kspread;'s configuration dialog box (obtained by selecting Configure Kspread... from the Settings menu) controls some more &kspread; features:

Number of pages open at the beginning:

  Controls how many worksheets will be created if the option Start with an empty document is chosen when &kspread; is started.

Number of recent files:

  Controls the maximum number of filenames that are shown when you select File Open Recent.

Auto save (min):

  Here you can select the time between autosaves, or disable this feature altogether by choosing No autosave (drag the slider to the far left).

Show vertical scrollbar

  Check or uncheck this box to show or hide the vertical scrollbar.

Show horizontal scrollbar

  Check or uncheck this box to show or hide the horizontal scrollbar.

Show column header

  Check this box to show the column letters across the top of a worksheet.

Show row header

  Check this box to show the row numbers down the left side.

Show tabs

  This check box controls whether the sheet tabs are shown at the bottom of the worksheet.

Show formula toolbar

  Here is where you can choose to show or hide the Formula bar.

Show status bar

  Uncheck this box if you want to hide the status bar.

## Misc

The Misc page of &kspread;'s configuration dialog box contains the following items;

Completion mode:

  Lets you choose the (auto) text completion mode from a range of options in the drop down selection box.

Value of indent:

  Lets you define the amount of indenting used by the Increase indent option in the Format menu.

Press enter to move selection to:

  When you have selected a cell then press the Enter 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.

Show error message

  If this box is checked a message box will pop up when what you have entered into a cell cannot be understood by &kspread;.

Method of calc:

  This drop down selection box can be used to choose the calculation performed by the Statusbar Summary function..

Show comment indicator

  If this box is checked cells containing comments will be marked by a small red triangle at the top right corner.

## Color

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 Show grid box in the Preferences configuration page.

This page also lets you select the color of the lines used to indicate the printed page borders when the Show Page Borders box in the View menu is checked.

## Page layout

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 Page Layout dialog box (obtained by selecting Page Layout... from the Format menu.

## Spelling

This page lets you configure the behavior of &kspread;'s spell checker.

Create root/affix combinations not in dictionary

  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.

Consider run-together words as spelling errors

  If this box is checked then common words which are run together will be considered to be spelling errors, for example cannot.

Dictionary:

  This drop down selection box can be used to select alternative dictionaries.

Encoding:

  To select the character encoding that should be used.

Client:

  This combo box lets you select between different spell checking programs that may be present on your computer.

Ignore uppercase words

  Check this box if you want the spellchecker to ignore uppercase words, which are usually acronyms such as &kde;.