Frank-Andreas Schmidt
KSpread is complete a spreadsheet program. It is part of the KOffice suite of utilities.
Table of Contents
- 1. Still to be done on this manual
- 2. Introduction
- 3. Fundamentals
- 4. Step by Step Tutorial
- 5. The KSpread Screen
- 6. Detailed Guides: Document Storage and Printing
- 7. The Menu Items/Tool Bars
- 8. Detailed Guides: Editing your spreadsheet
- 9. Detailed Guides: Data representation issues
- 10. Detailed Guides: Python scripts
- 11. KSpread Options
- 12. Questions and Answers
- 13. Credits and License
- Glossary
- A. Key Bindings Summary
- B. Installation
Still to be done on this manual
This is a list of things which still need work in this manual:
A template only. Has to be filled with contents
Introduction
This chapter will show the main features of KSpread
KSpread is a full featured spreadsheet program.
It is part of the KOffice productivity suite for the K Desktop Environment.
Other applications in KOffice include
| KWord (text processing and desktop publishing) |
| KPresenter (presentation creator) |
| Kontour (a vector drawing program) |
| Krayon (a bitmap image editor) |
| KFormula (formula editor) |
| KChart (for charts/graphs) |
All KOffice applications were designed from the beginning to take advantage from KDE 2.0. Because of this, KSpread (like all of KOffice), supports drag and drop, themes, and many other advanced features.
KSpread is a spreadsheet which can work as a traditional table-oriented sheet but also allows to put in complex formula of higher mathematics and statistics. There's also the possibility of putting the data to visibility by using graphics
With the use of Python scripting there will be the possibility of having automated processes within the spreadsheets such as pre-defined input masks and calculation on demand.
Other advantages are:
This is only a template and has to be filled with information on the main program features.
What parts of this guide should I read?
We have to distinguish between different types of users:
If you got this file without having installed the software, read the chapter that deals with installation first.
If you are an experienced user who has a special question you may try the reference section and/or the FAQ's
If you got this file while working with KSpread (by pressing F1) it would be best to follow the chapter's link to the Step-by-Step Guide
Fundamentals
This next section is designed to introduce you to:
Rest deleted, will see to that later
KSpread can be started one of three ways:
You can select KSpread through the system menu by following the KDE Application menu Applications->Office->KSpread
If you are in a terminal program (Konsole, Xterm, etc.), you can type: kspread &
Or
kspread filename &
Using Konqueror, you can click on your data file (KSpread documents normally end in .ksp but it's not required). This will automatically start KSpread showing the last edited table of the sheet.
Step by Step Tutorial
Hopefully this tutorial has introduced you to the basics of KSpread.
The KSpread Screen
KSpread, like most GUI based programes, divides the screen up into several areas. Each are used to perform a group of similar features. When you start the KSpread screen, it is initially divided into 4 major areas:
The KDE Frame (which remains at the top of all programs run under KDE).
Rest deleted.
Detailed Guides: Document Storage and Printing
This section of the documentation will cover everything you need to know about starting a new spreadsheet, saving a spreadsheet to a file, retrieving a saved and printing a document.
Saving a spreadsheet to a file
Once you have entered data, formula and whatsoever into a spreadsheet, you will usually want to save this to a file on your hard drive.
Retrieving a saved file
Printing A Document
The Menu Items/Tool Bars
Detailed Guides: Editing your spreadsheet
Detailed Guides: Data representation issues
Detailed Guides: Python scripts
KSpread Options
In this section we may describe how to use filters to im-and export data
Questions and Answers
- 1. Where can I get updates?
- 2. How do themes affect KSpread?
- 3. How does Drag and Drop work with KSpread?
| 1. | Where can I get updates? |
| 2. | How do themes affect KSpread? |
| 3. | How does Drag and Drop work with KSpread? |
Credits and License
KSpread
Program copyright 1998-1999 The KOffice Team <bongo@kongo.org>
Documentation copyright 2000 Frank-Andreas Schmidt
This documentation is licensed under the terms of the GNU Free Documentation License.
This program is licensed under the terms of the GNU General Public License.
Glossary
Key Bindings Summary
Table A.1. Key Bindings for KSpread
| Command | Key Combination |
|---|---|
| Start New Document | Ctrl+N |
| Open Document | Ctrl+O |
| Save Document | Ctrl+S |
| Print Document | Ctrl+P |
| Close Document | Ctrl+W |
| Quit KSpread | Ctrl+Q |
| Forgot | Alt+Backspace |
| Copy | Ctrl+C |
| Cut | Ctrl+X |
| Paste | Ctrl+V |
| Find and Replace | Ctrl+F |
| Select All | Ctrl+A |
| Insert Picture | F2 |
| Insert Clipart | F3 |
| Insert Special Character | Alt+C |
| Insert Hard Frame Break | Ctrl+Enter |
Installation
In order to install and use KSpread you must have:
A functioning UNIX® system with the X Window System® system configured.
The K Desktop Environment 2.2 (KDE 2.2). KSpread will probably not function with older versions of KDE. Information on obtaining and installing KDE 2.2 can be found at: http://www.kde.org.
Permission to install software on your computer. If you are on a stand alone system, this will not be a problem. If, however, you are using a networked computer, check with your administrator.
If you plan on compiling KOffice from source code you will also need:
automake 1.4 or newer. This can be downloaded from: ftp://ftp.gnu.org/pub/gnu/automake/
autoconf 2.13 or later. This can be downloaded from: ftp://ftp.gnu.org/pub/gnu/autoconf/
A C++ compiler which supports exceptions (preferably gcc 2.95.x). This can be downloaded from http://egcs.cygnus.com/
Troll Tech's Qt™ 2.3 development packages. These can be downloaded from ftp://ftp.troll.no/
Once your system meets these requirements, you than need to decide whether you want to install from the source code, or premade compiled packages.
If you want to obtain the most current binary version of KOffice, you can find more information at Getting Binary Packages.
If pre-compiled binaries are not available for your system, you can download the source code and compile it yourself. Instructions on where to obtain the current source code and what to do with the source code once you have it, can be found under Getting the source code.
Getting Binary Packages
You can download the most current binaries from http://koffice.kde.org/
or from one of many mirror sites. The current list of mirror sites can be found at http://www.kde.org/mirrors.html
Note
It is important that you find a binary package that is compatable with your system. If you are unable to find it here, you may be able to obtain a pre-compiled binary from the website of your distribution.
From Binary Packages
To install KSpread from precompiled binaries, you should:
Ensure your computer has all the required software (excluding KOffice of course), is installed. You can find the system requirements under System Requirements.
Download the KOffice binary (***Insert filenames (rpm and deb and tar) here***) into a temporary directory.
If the file is a .rpm (Red Hat® Package Management Package), KOffice can be installed with: rpm -U filename
If the file is a .deb (Debian Package file), KOffice can be installed with: dpkg -i filename
If the file is a tarball (ends in .tar.gz or .tgz), KOffice can be installed with tar -xzvf filename
You are now installed!
You can now start KSpread or you can go through a Step by Step which will help take you through a sample document.
Getting Source Code
You can download the current source code from http://koffice.kde.org/ or from one of many mirror sites. The current list of mirror sites can be found at http://www.kde.org/mirrors.html
From Source Code
If you want to build KSpread from source code, you should
Ensure your computer has all the required software (excluding KOffice of course), is installed. You can find the system requirements under System Requirements.
Download the KOffice source file (Insert filenames (srpm and tar) here***) into a temporary directory.
STUFF
Problems with Compilation