The Calligra Sheets Handbook

Pamela Roberts

Anne-Marie Mahfouf

Gary Cramblitt

Revision 2.7 (2013-03-11)

Calligra Sheets is a full featured spreadsheet program.


Table of Contents

1. Introduction
2. Calligra Sheets 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 Calligra Sheets
Series
Formulae
Built in Functions
Logical Comparisons
Absolute Cell References
Arithmetic using Special Paste
Array Formulas
Goal Seeking
Pivot Tables
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
Named Cells and Areas
Cell Comments
5. Configuring Calligra Sheets Shortcuts and Toolbars
Shortcuts
Toolbars
6. The Calligra Sheets Configuration Dialog Box
Interface
Open/Save
Plugins
Spelling
Author
7. Command Reference
The File Menu
The Edit Menu
The View Menu
The Go 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
8. Functions
Supported Functions
Bit Operations
Conversion
Database
Date & Time
Engineering
Financial
Information
Logical
Lookup & Reference
Math
Statistical
Text
Trigonometric
9. Credits and License