Contents
Copyright................................................................................................................... 2
Note for Mac users.................................................................................................... 8
Chapter 1
Introducing Calc.......................................................................................................... 9
What is Calc?........................................................................................................... 10
Spreadsheets, sheets, and cells...............................................................................10
Parts of the main Calc window................................................................................10
Starting new spreadsheets......................................................................................18
Opening existing spreadsheets................................................................................20
Opening CSV files.................................................................................................... 21
Saving spreadsheets................................................................................................22
Password protection.................................................................................................24
Navigating within spreadsheets..............................................................................26
Selecting items in a sheet or spreadsheet...............................................................29
Working with columns and rows..............................................................................32
Working with sheets.................................................................................................33
Viewing Calc............................................................................................................ 34
Using the Navigator.................................................................................................38
Using document properties......................................................................................40
Chapter 2
Entering, Editing, and Formatting Data....................................................................43
Introduction............................................................................................................. 44
Entering data using the keyboard...........................................................................44
Speeding up data entry............................................................................................ 46
Sharing content between sheets..............................................................................49
Validating cell contents............................................................................................50
Editing data.............................................................................................................. 52
Formatting data....................................................................................................... 53
Autoformatting cells and sheets..............................................................................59
Formatting spreadsheets using themes...................................................................60
Using conditional formatting...................................................................................60
Hiding and showing data.........................................................................................61
Sorting records........................................................................................................ 63
Finding and replacing in Calc..................................................................................65
Chapter 3
Creating Charts and Graphs......................................................................................69
Introduction............................................................................................................. 70
Creating a chart....................................................................................................... 70
Editing charts...........................................................................................................74
Formatting charts....................................................................................................79
Formatting 3D charts...............................................................................................82
Formatting the chart elements................................................................................85
OpenOffice.org 3.3 Calc Guide 3
Kommentare zu diesen Handbüchern