The KSpread Handbook

 docs.kde.org
Search

The KSpread Handbook

Pamela Roberts <pamroberts@blueyonder.co.uk>


Revision 1.02.00

Copyright © 2002 Pamela Roberts

Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.1 or any later version published by the Free Software Foundation; with no Invariant Sections, with no Front-Cover Texts, and with no Back-Cover Texts. A copy of the license is included in the section entitled "GNU Free Documentation License".

KSpread is a full featured spreadsheet program.

Table of Contents

1. Introduction
2. KSpread Basics
Spreadsheets for Beginners
Selecting Cells
Entering Data
Copy, Cut and Paste
Copying and Pasting Cell Areas
Other Paste Modes
Insert and Delete
Simple Sums
Recalculation
Sorting Data
The Statusbar Summary Calculator
Saving your Work
Templates
Printing a Spreadsheet
3. Spreadsheet Formatting
Fonts, Text, Borders and Colors
Data Formats and Representation
Conditional Cell Attributes
Changing Cell Sizes
Merging Cells
Hiding Rows and Columns
4. Advanced KSpread
Series
Formulae
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
Link Cells
Validity Checking
Other Features
Splitting the View
Named Cells and Areas
Cell Comments
5. Importing and Exporting Foreign Formats
CSV Data
6. Configuring KSpread Shortcuts and Toolbars
Shortcuts
User Defined Menus
Toolbars
7. The KSpread Configuration Dialog Box
Preferences
Locale Parameters
Interface
Misc
Color
Page layout
Spelling
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
KDE Logo