The KSpread Handbook

The KSpread Handbook

Pamela Roberts

Anne-Marie Mahfouf

Gary Cramblitt

Revision 1.5.2 (2006-06-12)

Copyright © 2002 Pamela Roberts

Copyright © 2005 Anne-Marie Mahfouf

Copyright © 2006 Gary Cramblitt

KSpread is a full featured spreadsheet program.

Table of Contents

1. Introduction

2. KSpread Basics

Spreadsheets for Beginners

Selecting Cells

Entering Data

Generic Cell Format

Copy, Cut and Paste

Copying and Pasting Cell Areas
Other Paste Modes

Insert and Delete

Simple Sums

Recalculation

Sorting Data

The Status bar Summary Calculator

Saving your Work

Templates

Printing a Spreadsheet

3. Spreadsheet Formatting

Cell Format

Data Formats and Representation
Fonts and Text Settings
Text Position and Rotation
Cell Border
Cell Background
Cell Protection

Conditional Cell Attributes

Changing Cell Sizes

Merging Cells

Hiding Rows and Columns

Sheet properties

4. Advanced KSpread

Built in Functions
Logical Comparisons
Absolute Cell References

Arithmetic using Special Paste

Goal Seeking

Using more than one Worksheet

Consolidating Data

Inserting a Chart

Inserting External Data

Validity Checking

Document Protection
Sheet protection
Cell or selected cells protection
Hide cell formula
Hide all in the cell

Other Features

Splitting the View
Named Cells and Areas
Cell Comments

5. Configuring KSpread Shortcuts and Toolbars

User Defined Menus

6. The KSpread Configuration Dialog Box

Locale Settings
Interface
Misc
Color
Page Layout
Spelling
Configure Text-To-Speech options

7. For Users with Disabilities

Installing the kdeaccessibility Module

Visual Impairments

Theming
KMagnifier
Text-to-Speech

Motor Impairments and Mouseless Operation

KMouseTool
XAccess Features
Mouse Emulation
Mouse Navigation
Keyboard shortcuts
Resizing panels
Setting focus to widgets

8. Command Reference

The File Menu
The Edit Menu
The View Menu
The Insert Menu
The Format Menu
The Data Menu
The Tools Menu
The Settings Menu
The Help Menu
The Right Mouse Button Menu
Other Shortcuts

9. Questions and Answers

10. Credits and License

A. Installation

Introduction