OpenOffice.org: the complete guide

Here you can access, in PDF format, a complete guide (over 100 pages) to OpenOffice.org. Whether you want to get more from word processor documents and spreadsheets, or delve into databases and macros, we've got it covered. Click the following links to read the guides, and we hope they come in useful! Note that the guides were written with OpenOffice.org 2.2 in mind, so a few things may be slightly different if you're running a newer version.

(Previously published content from LXFS11. All PDFs are (C) copyright Future Publishing and may not be reproduced or redistributed without permission from the Editor.)

Introduction

• Welcome - A message from the Editor
• Introduction - What is OpenOffice.org?
• Converting from MS Office - How to switch from Microsoft

Word processing

• Getting started with Writer - OpenOffice.org's word processor
• Structuring content - Creating a table of contents
• Advanced Writer - Master documents and templates
• Making websites - Using Writer to create a site

Spreadsheets

• Getting started with Calc - OpenOffice.org's spreadsheet
• Calc Charts - Pretty graphs ahoy!
• Calc formulae - Functions, formats and data
• Calc DataPilot - Reveal hidden depths of your data

Presentations

• Getting started with Impress - OpenOffice.org's presentation tool
• Impress slideshows - Create attractive presentations
• Presentation secrets - Don't bore your audience to tears

Databases

• Getting started with Base - OpenOffice.org's database
• Mail merging - Combine the power of Writer and Base
• Queries and forms - Advanced Base techniques

Illustrations

• Draw - OpenOffice.org's illustration tool
• Flowcharts - Making a simple flowchart
• Using pens - Different ways to draw
• Tips and tricks - Do more with vector graphics

Macros and printing

• Macros and scripting - Automate time-consuming jobs
• Sharing with MS Office - Transferring files to Microsoft users
• Printing - Making hard copy versions of your documents
• Making PDFs - Join the paperless office revolution

Enhancing OOo

• Dictionaries - Add support for other languages
• Extensions - Useful plug-ins for the suite

Tips and tricks

• Tips and tricks - 34 handy time-savers

Projects

• Project 1 - Load data with macros in Calc
• Project 1 Extra - Form controls for data entry
• Project 2 - Create CD labels in Draw
• Project 3 - Make a CD cover in Writer
• Project 4 - Using MySQL with Base

Glossary

• Glossary - Lost? Confused? Seek the answer here!