docs.kde.org
The KSpread Handbook
Next
 

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

Legal Notice

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
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
Protection
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
Shortcuts
User Defined Menus
Toolbars
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
Next
 
 
 Introduction
 


docs.kde.org