Skip to content

start:

Documentation - HOW TO...

Last modified: $Date: 2007/11/05 14:21:36 $

Mission Statement

To provide easy to follow instructions to accomplish various tasks within each of the OpenOffice.org programs.

Summary

The How-To documents listed below are now available for consultation.

Key to File Formats

  • HTML files are viewable in your web browser.
  • SXW files can be opened and edited in OpenOffice.org Writer.
  • ODT files can be opened and edited in OpenOffice.org2.0 Writer.
  • PDF files are portable read-only documents.
  • ZIP files are compressed archives that must be extracted after download.
Math
Title
Available Formats
Formula Command Reference
Formula How To
KIT with PDF instructions //-->
General
Title
Available Formats
Quick Reference of Toolbars in OpenOffice.org
How To Modify Context Menus in OOo
How To Insert Special Characters (updated)
11 Tips for Moving to OOo
Bullet Proof Templates
How to Distribute Macros with an Addon
Word Processor
Title
Available Formats
Write and Manage OpenOffice.org text Documents using Common Features and Styles.
Writing a Thesis with OpenOffice.org

Do a "Mail Merge" from a Calc spreadsheet.
How To Change A Paragraph Style
How To Create Numbering in OOo
How To Insert Watermarking
How To Create and Maintain a Table Of Contents
How To Work With Templates
How to Work with Sections
How to Setup and Use Cross References
How To Create Columns
MS Word to OOo Writer: How to perform common tasks
Style Painter Addon
How to Convert Word Tables to Calc or dBase for MailMerge: courtesy of the French Native Language Project
Example of a Multi-page J8163 Label Template: courtesy of Peter Hillier-Brook

Inserting Text in a Document.
SXW - ODT - PDF

Importing User Word Lists into OpenOffice.org.
ODT - PDF

How To Email Mailmerge using mailmerge.py
ODT - PDF

Label Format Cross-Reference
PDF
Spreadsheet
Title
Available Formats
Project-Management with Gantt-Charts.
Project-Management with Gantt-Charts Calc template.
Carry out Simple Calculations and Format Cells and Sheets in a Folder.
Utilize Sort Lists and AutoFill

Apply Conditional Formatting to a Cell

How To Define a Data Range

How To Format A Spreadsheet

How to set the Printing Settings

How to Protect a Sheet or a Cell
Draw
Title
Available Formats

Compose a Document with Simple Geometric Shapes, to Change their Attributes (color, size, position, ...) and to Print the Result.

How-to Get to Grips with OpenOffice.org Draw
SXW - PDF
Impress
Title
Available Formats

First Steps in Impress (Version 2.0)
ODT - PDF

How To Create a New Impress Document Using a Template.
SXW - ODT - PDF

How to Insert a New Slide in Impress.
SXW - ODT - PDF

How to Insert Notes in a Presentation.
SXW - ODT - PDF

Using Movies in Impress on Linux without the need for Java Software.
ODT - PDF
Data Source
Title
Available Formats

How to Create a Data Source from Scratch

How To Link Tables Using named Parameters

Using SQLite Database with OpenOffice.org
Miscellaneous
Title
Available Formats
How To Change your Email Address for a Mailing List
How to Setup Multiple Screens under Linux
Installing and using CVS under Windows
How To Install OOo1.1.x with a Response File
Installing OpenOffice.org on a USB key (updated)
VBA to StarBasic Cross Reference
VBA to StarBasic Cross Reference Example Files
Multi-save Addon in English
Troubleshooting Common Problems
Hacker's Guide for 1.1.x
Hacker's Guide for 2.0
Macros
Title
Available Formats
Andrew Pitonyak's Macro Document
Andrew Pitonyak's Font Macro Document
Link to Andrew Pitonyak's Database info
How To Organize and Call Macros in OOo

Valid XHTML 1.0 Transitional