OpenOffice.org User Guide

for Version 2.x

[OpenOffice.org User Guide for 2.0]
[0.20]
First edition: [2005-04-11]
First English edition: [2005-04-11]

Copyright and trademark information

The contents of this Documentation are subject to the Public Documentation License, Version 1.0 (the "License"); you may only use this Documentation if you comply with the terms of this License. A copy of the License is available at: http://www.openoffice.org/licenses/PDL.rtf.

The Original Documentation is “OpenOffice.org User Guide for Version 2.x”.

Contributor(s): G. Roderick Singleton.

Portions created by G. Roderick Singleton are Copyright © 2005, 2006. All Rights Reserved.

All trademarks within this guide belong to legitimate owners.

[Note: a copy of the PDL is included in this template and is also available at: http://www.openoffice.org/licenses/PDL.rtf.]

Feedback

Please direct any comments or suggestions about this document to: grsingleton@openoffice.org

Acknowledgements

I wish to recognize the Technical Writers of Sun Microsystems for the fine model they have provided for organizing this document. I also wish to thank Erwin Tenhumberg for his blog, Mary Ellen Dawley for indexing and Ross Johnson for his editing/corrections.

Modifications and updates

Version	Date	Description of Change
[0.9]	[2005-11-11]	[grs: 9th draft issued for comment – switched to master doc, stewart's amendments and added a chapter on XML usage (flat file)]
[0.10]	[2005-11-11]	[grs: 10th draft issued for comment – fix page numbering
[0.11]	[2006-01-31]	[grs:11th draft issued for comment – updated index
[0.12a]	[2006-02-20]	[rj: 12th draft issued for comment – corrections for 2.0 to replace 1.1.x references
[0.13]	[2006-02-21]	[grs 13th draft issued for comment – integrated Ross Johnson's changes and edited for consistent grammar.
[0.14]	[2006-03-02]	[grs:14th draft issued for comment – document layout to be more bookish
[0.15]	[2006-04-10]	[grs:15th draft issued for comment – Added POSTNET section
[0.16]	[2006-06-19]	[grs:16th draft issued for comment – Added file recovery info to Troubleshooting chapter
[0.17]	[2006-06-27]	[grs:17th draft issued for comment – Corrected Overview
[0.18a]	[2006-07-19]	[grs:18ath draft issued for comment – updated concordance file section and added JMF section to Chapter 14 and wps how-to.
[0.19]	[2006-07-31]	[grs:19th draft issued for comment – Added new export PDF feature
[0.20]	[2006-08-16]	[grs:20th draft issued for comment – Fixed many legacy terms and added language/writing aids and comment on style painter

Contents

Overview	1

Using the Guide	1

New Features with 2.x	2

Open Standards XML File Format (OASIS OpenDocument)	2

New Multi-pane View	2

New CustomShapes (compatible with Microsoft AutoShapes)	2

More Slide Transitions and Animation Effects	2

Enhanced PDF Export	2

New enhanced Database Frontend	4

Mail Merge Wizard	4

Enhanced Word Count Feature	4

Support for Nested Tables	4

Digital Signatures Support	4

XForms Support	4

WordPerfect® Filters	4

Calc now has 65,536 Rows	5

Enhanced DataPilot Support	5

Native Installers	5

Native Desktop Integration	5

Floating Toolbars	5

Style Paint Brush	5

Chapter 1: Using OpenOffice.org Help	7

OpenOffice.org Step-by-Step Help	7

Tips	8

Turning tips on and off	8

Extended Tips	8

Turning extended tips on and off	8

Help Agent	8

Turning the Help Agent on and off	8

Chapter 2: Working With OpenOffice.org	10

The User Interface	10

Starting OpenOffice.org	10

The OpenOffice.org Writer Window	11

Toolbars in the OpenOffice.org Window	11

The Title Bar	11

The Menu Bar	12

The Toolbars	12

Examples of Floating Toolbars	13

Using Floating Toolbars	14

The document window	14

Docking toolbars	14

Docking windows	15

Changing the Visibility of Buttons on Toolbars	15

Opening and Saving Documents	16

Opening Documents	16

Saving Documents	19

Changing the Work Directory	20

Saving Documents Automatically	20

Backup a File Automatically	20

Saving Recovery Information Automatically Every 'n' Minutes	20

OpenOffice.org File Formats	21

XML file format names	21

OpenOffice.org XML file structure	22

Definition of the XML formats	23

Setting Tabstops	23

Sending Documents as E-Mail	24

Single Messages	24

MailMerge	24

Printing Documents	25

Displaying Print Previews	26

Reduced Printing of Documents	27

To print two pages beside one another on one sheet of paper	27

Printing in Black and White	27

Printing text and graphics in black and white	27

Printing all Draw and Impress documents in black and white	27

Printing only text in black and white	28

Printing all Writer documents with black and white text	28

Printing the current Writer document with black and white text	28

Printing Brochures	28

Spellcheck	29

Automatic Spellcheck	29

Checking Multilingual Texts	30

Starting Spellcheck	31

Excluding Text From the Spellcheck	32

Adding Writing Aids for Other Languages	32

Getting New Writing Aids	32

Using Automatic Functions	37

Using AutoCorrect and AutoFormat	37

Turning off URL Recognition by AutoCorrect	39

Undo URL recognition	39

Turn off URL recognition	39

Other AutoCorrect functions	39

Creating a Letter Template With the Wizard	41

Find & Replace	42

Finding a Word in Text	42

Searching for Whole Words Only	43

Match Case	43

Searching for Text With Wildcards	43

Searching Backward	44

Current Selection Only	44

Searching for Styles	44

Searching for Text Attributes	44

Searching for Special Formats	44

Similarity Search	45

List of Regular Expressions	45

Printing or Exporting Documents	47

Only “open password”, no restriction	49

“open password”, restricted	49

Permission restricted only	49

PDF without restriction (Default behaviour)	49

Permissions available	49

Printing	49

Changes	49

Enable copy	50

Enable accessibility	50

Programming PDF Security in Macros	50

Chapter 3: Managing Text Documents With Writer	53

The OpenOffice.org Writer Functions	53

Writing	53

Designing and Structuring	53

Desktop Publishing with OpenOffice.org Writer	54

Calculations	54

Creating Drawings	54

Inserting Graphics	54

Customizable Program Interface	54

Drag&Drop	54

Extensive Help Functions	54

The OpenOffice.org Writer Window	55

Windows® of OpenOffice.org Writer	55

Entering and Formatting Text	56

Entering New Text	56

To enter new text:	56

Line breaks	56

Automatic correction	56

Word completion	56

Inserting Text	56

Switching Between Insert Mode and Overwrite Mode	57

Using the keyboard:	57

Using the mouse:	57

Entering Text Anywhere on a Page	57

Selecting and Deleting Text	58

Deleting characters	58

Deleting text	58

Selecting text to delete with the mouse	58

Selecting text to delete with the keyboard	58

Deleting non-adjacent pieces of text.	58

Status bar uses	59

Setting the Viewing Zoom Factor	59

Editing or Activating Hyperlinks	59

Applying Various Fonts	59

Keyboard Navigating and Selection in Writer	60

Inserting Special Characters	60

Inserting Protected Spaces, Hyphens and Conditional Separators	61

Non-breaking spaces	61

Non-breaking hyphen	61

Hyphen, em-dash and en-dash	61

Manual Hyphenation	61

Emphasizing Text	61

Changing the colour of Text	62

Rotating Text	62

Defining Borders	63

Choose Format from the menu bar, Borders tab page	63

Use the Borders floating toolbar with Tables	64

Superscripts and Subscripts	67

Applying subscripts/superscripts retrospectively	68

Writing in Uppercase or Lowercase	68

Moving Text Sections in Documents	68

Resetting Font Attributes While Typing	69

Example procedure for resetting Font Attributes	69

Quick Formatting Using the Adjacent Paragraph Format	69

Using Sections	69

Sections and Columns	71

Inserting Sections	71

Editing Sections	71

Formatting Text With and Without Styles	72

Direct Formatting or Formatting With Styles	72

The Style Concept in OpenOffice.org	73

The Styles in the Styles and Formatting Window	73

Paragraph Styles	73

Paragraph Style.	74

Character Styles	76

Hierarchical Styles	76

Numbering Styles	77

Creating New Character Styles or Paragraph Styles	77

Creating Document Templates	78

The Advantages of the Styles and Formatting Window	79

Formatting Multiple Paragraphs	79

Changing a Style the Easy Way	79

Page Styles and Page Numbers	80

Create Page Styles	80

Editing Page Styles	83

Page Breaks as Paragraph Formats	84

Changing the Format of Page Numbers	85

Page Styles Summary	87

Defining default Templates	88

Templates and Styles	89

Copying Styles Between Templates and Documents	89

New Style from Selection	90

Transferring Formats With Fill Format Mode	90

Updating Styles From Selections	90

This is how to update a Style:	90

Style can also be updated by using drag and drop:	91

Entering and Formatting Text Automatically	91

Disabling the AutoCorrect Function	91

ASCII Quotation marks are replaced with Custom Quotes	91

Sentences always begin with a capital letter	91

Three identical characters will become a whole line	91

Automatic Spellcheck	92

To exclude words from Spellcheck	92

Using AutoText	93

Defining AutoText	94

Using AutoText in Networks	95

Printing AutoTexts	95

AutoText With AutoComplete	96

Exceptions in AutoCorrect	96

Example	96

Text Frames	97

Inserting, Editing and Linking Text Frames	97

Inserting Text Frames	97

Editing Text Frames	98

Linking Text Frames	98

Using Text Animation	100

Drawing Lines in Text	103

Editing Text With FontWork	104

Aligning Text With Lines	106

Aligning text on a free form line	106

Aligning text with straight lines	106

The Navigator	107

Jumping From One Object to Another in Text	107

Jumping to a Specific Page	108

Chapters in Navigator	109

Indexes and Tables of Contents in Writer	110

Defining Index/Table of Contents Entries	110

Editing or Deleting Index and Table Entries	111

Creating a Table of Contents	112

Creating Alphabetical Indexes	113

Creating User-Defined Indexes	113

Using a Concordance File	115

Preparation	115

Entering Data	115

Example file	116

Creating Bibliographies	118

Updating, Editing and Deleting Indexes and Tables of Contents	119

Editing the Format of an Index/Table of Contents	119

Indexes Covering Multiple Documents	119

Headings and Numbering	121

Numbering and Numbering Styles	121

Turning Bullets On and Off	121

Turning Numbering On and Off	122

Example numbered list with sublevels:	123

Outline Numbering	123

Automatic Bullets and Numbering	124

Numbering Illustrations by Chapters	124

Defining Number Ranges	125

Using Master Documents and Subdocuments	127

Importing Lists From Other Text Programs	132

Changing Numbering via the Keyboard	132

Interrupting and Continuing Numbering	133

Delete the automatic numbering	133

Formatting the paragraph	133

Continuing numbering with a new starting value	133

Numbering Lines	134

Line Numbering for All Paragraphs	134

Line Numbering for Particular Paragraphs	134

Tables in Text	135

Inserting Tables	135

Inserting an empty table using the mouse:	135

Inserting an empty table via the Insert menu or floating toolbar:	135

Inserting a single row table by typing ++... or ||...	135

Inserting from OpenOffice.org Calc with the clipboard	135

Inserting from OpenOffice.org Calc using drag-and-drop	136

Deleting Tables	136

Inserting Paragraphs Before Tables at Start of Page	137

Resize columns, rows, and cells	137

Table AutoFormat	137

Table properties in general	137

Calculating in Text Documents	139

Formulae in Text Documents	139

Formula Options	139

Basic Calculation Functions	139

Basic Functions in the Submenu	139

Operators	139

Statistical Functions	140

Trigonometric Functions	141

More Defined Values	141

Calculating in Text	141

Calculating With formulae Located in Text	142

Conditional Text	143

Defining and using conditional text – by example	143

Defining a conditional variable	143

Type “Reminder” in the document, and then add space.	143

Defining a condition and the conditional text:	144

Displaying the conditional text:	145

Calculating in Text Document Tables	146

Calculating Across Multiple Tables	147

Calculating Cell Totals in Tables	148

Merging and Splitting Cells	148

Merging Cells in OpenOffice.org Writer	148

Splitting Cells in OpenOffice.org Writer	148

Merging Cells in OpenOffice.org Calc OLE Objects	148

Cancelling the merging of cells in OpenOffice.org Calc OLE Objects	148

Inserting or Deleting Rows/Columns Using the Keyboard	149

Repeating Multiple Heading Rows in a Table	149

Enlarging and Reducing Cells in Text Tables	149

Adapting Table Widths	150

Images, Drawings, Clipart and FontWork	151

Positioning Objects	151

Captions and Number Ranges	151

Defining Captions	152

Editing or deleting captions	152

Inserting an object in a number range	152

Numbering Illustrations by Chapters	153

Inserting Graphics	153

Inserting Graphics via dialogue	153

Inserting Graphics From OpenOffice.org Draw or Impress	153

Inserting Graphics via Drag and Drop From the Gallery	154

Adding Graphics To the Gallery via Drag and Drop	155

Inserting Graphics With a Scanner	155

Inserting a Chart From OpenOffice.org Calc	155

Dragging and Dropping the Chart with Move or Copy	155

Charts with Linked Data	156

Inserting Decorative Horizontal Lines	156

Headers, Footers and Footnotes	157

Some Notes Concerning Headers and Footers	157

Inserting Page Numbers in Footers	157

Formatting Headers and Footers	160

Defining Different Headers	160

Inserting Page Numbers of Continuation Pages	160

Inserting Lines Under Headers	161

Footnotes and Endnotes	162

Inserting and Editing Footnotes	163

Inserting a footnote via an icon	163

Inserting a footnote via a dialogue	163

Tips for Working with Footnotes	164

Spacing Between Footnotes	164

Spellcheck, Dictionaries, Hyphenation	165

Controlling Spellcheck via the dialogue	165

Automatic Spellcheck	166

To exclude words from the Spellcheck:	167

Removing Words From User-Defined Dictionaries	167

Hyphenation	167

Automatic hyphenation	167

Manual Hyphenation	168

Thesaurus	169

Form Letters, Business Cards and Labels	171

Creating Form Letters	171

Brief Instructions (For Quick Results)	171

Fixed and Variable Fields	171

Creating and Printing Labels and Business Cards	173

Designing Business Cards via dialogue	173

Designing Labels and Business Cards	174

Printing Labels With Serial Numbers	174

Printing Address Labels	175

Avoiding Blank Paragraphs	176

Newsletters	178

Creating a Newsletter From a Template	179

Creating Page Styles	179

Editing Headers	179

Editing Columns	179

Editing Paragraph Styles	180

Working with Frames	181

Formatting a Frame	181

Anchoring Frames	181

Defining a Frame Wrap	181

Defining a Wrap Region	181

Using coloured or Graphic Backgrounds	183

Creating a Table of Contents	183

Further Information	186

Using Automatic Hyphenation	186

Letters With Envelopes	187

Using a Ready-Made Letter Template	187

Creating a Letter Template Using the Wizard	187

Creating an Envelope Template	188

Inserting an Envelope into a Document	189

Adjusting the Printer for the Printout	189

Creating and Printing a Letter With an Envelope	190

Creating an Single Envelope	190

Adding a POSTNET Bar Code to an Envelope	191

Get a POSTNET font	191

Building a Complete POSTNET Bar Code for Printing	191

Chapter 4: Spreadsheets in Calc	193

Overview of the Functions in Calc	193

Calculating	193

Database Functions	193

Arranging Data	193

Examining and Extrapolating Data	193

What-If Calculations	193

Dynamic Charts	194

Importing and Exporting Data	194

Importing into Calc	194

Exporting from Calc	195

Referencing Data in Networks and the Internet	195

The Calc Window	196

Structure of a Spreadsheet	196

Rows and Columns	197

Multiple Sheets in a Document	197

Inserting Sheets	198

Renaming Sheets	198

Values and Formulae as Cell Contents	199

Calculating in Spreadsheets	199

Using Built-in Functions	201

A Short Description of What Cells Can Contain	202

Text	202

Numbers	204

Calculating With formulae	207

Calculating With Dates and Times	208

Inserting and Editing Notes	209

Handling Multiple Sheets	210

Displaying Multiple Sheets	210

Working With Multiple Sheets	211

Printing Spreadsheets	211

Formatting a Spreadsheet	213

Formating Numbers	213

Dates	213

Formatting Cells and Sheets	214

Using AutoFormat for Tables	214

Layout of Spreadsheets	215

Designing Spreadsheets Clearly	215

Formatting Text in a Spreadsheet	216

Formatting Numbers in a Spreadsheet	216

Formatting Borders and Backgrounds for Cells and Pages	216

Addressing Cells	217

Addresses and References, Absolute and Relative	217

Relative Addressing	217

Absolute Addressing	217

When to Use Relative and Absolute References	217

Addressing by Name	219

Recognizing Names as Addressing	219

Only Copy Visible Cells	220

Referencing a Cell in Another Document	221

Using References in formulae	222

References to Other Sheets	223

Using Charts	225

Editing Chart Titles	228

Editing Chart Legends	228

Adding Texture to Chart Bars	229

Editing Chart Axis	229

Database Functions in Calc	230

Defining Database Ranges	230

Creating Records in a Spreadsheet	230

Defining Database Ranges	232

Sorting Database Ranges	232

Filtering Database Ranges	233

Grouping Database Ranges and Calculating Subtotals	235

Transferring Data From a Data Source to a Spreadsheet	236

Opening a Database File in Calc	236

Evaluating Data With Calc	239

DataPilot	239

What use is the DataPilot?	240

Creating DataPilot Tables	240

Selecting DataPilot Output Ranges	242

Editing DataPilot Tables	242

Filtering DataPilot Tables	242

Updating DataPilot Tables	242

Deleting DataPilot Tables	242

Consolidating Data	243

Applying Goal Seek	245

Naming Cells	245

Start Goal Seek	246

Applying Multiple Operations	246

Multiple Operations in Columns or Rows	246

Examples	246

Calculating With One Formula and One Variable	247

Calculating with Several formulae Simultaneously	247

Multiple Operations Across Rows and Columns	247

Calculating with Two Variables	248

Using Scenarios	249

Using Ready-Made Scenarios	249

Creating Personal Scenarios	249

Validity of Cell Contents	251

Using Cell Contents Validity	251

Sample macro:	253

Printing or Exporting Spreadsheets	254

Printing Sheet Details	254

Defining Number of Pages for Printing	254

Printing Sheets in Landscape Format	255

Printing Rows or Columns on Every Page	255

Saving and Opening Sheets in HTML	257

Saving Sheets in HTML	257

Opening Sheets in HTML	257

formulae and Values as CSV Files	258

Exporting formulae and Values as CSV Files	258

Importing a CSV File	258

AutoFill	260

Applying Sort Lists	260

Automatic Row Filling	260

Protecting Sheets	261

Creating a Reference	262

Further Information	262

Inserting a note	263

Inserting a sheet into another document	263

Displaying formulae	263

Using print ranges	263

Freezing Columns	263

Splitting a Calc Window	263

Conditional Formatting	263

Defining Validity	265

Creating Input Help	265

Linking Sheet Information	266

Chapter 5: Creating Presentations With Impress	267

OpenOffice.org Impress Toolbars and Windows®	268

How to Create a Basic Presentation	269

Creating a Presentation With the Wizard	269

Creating a Simple Presentation Without the Wizard	275

Switching Presentation Views	276

Arranging Slides	277

Incorporating Slide Show Effects	278

In-Slide Effects	278

Showing a Presentation	278

Editing Presentations	279

Defining Background colours	279

Switching Page Styles	280

Presentation Styles	280

Using Outline View	281

Slide Transitions, Effects and Animation	282

Automatic Slide Transition	282

Effects for Objects	282

Selecting Hidden Objects	283

Individual Presentations	283

Exporting, Printing and Presenting	285

Printing a Presentation Slide	285

Exporting Presentations as Web Pages	286

Exchanging Data via the Clipboard	287

Creating a Business Report	288

Creating a Business Report in Presentation Form	288

Entering Text in the Outline View	289

Changing the Slide Layout	289

Designing Slides	289

Creating a Slide Show	291

Defining or Changing Slide Order	292

Creating Cross-Fade Effects	292

Starting Presentations	293

Working with Connectors	294

"Edge to Edge” Connectors	294

"Middle to Middle” Connectors	295

Editing Connectors	295

Using a Snap Grid	295

Editing Glue Points	296

Hints and Tips for a Successful Presentation	297

Using the Mouse as a Pointer	297

Changing Bullet Symbols in Outline View	297

Inserting, Deleting and Renaming Slides	297

Creating and Printing Handouts	298

Organizing and Printing Notes	298

Using the Navigator	299

Edit Jump Targets	299

Modifying Object Size	299

Creating Additional Objects	299

Changing Font and Font Size	299

Modifying colours	299

Chapter 6: Creating Drawings with Draw	301

OpenOffice.org Draw Functions	301

Creating and Publishing Vector Graphics	301

Creating 3D Objects	301

Manage Organization Charts	301

Drawing	301

Export	302

Construct	302

Integrate	302

The OpenOffice.org Draw Window	303

Toolbars and Windows® in OpenOffice.org Draw	303

Drawing Rectangles and Ellipses and Entering Text	304

Rotating and Resizing Objects	306

Arranging and Aligning Objects	307

Arranging Objects	307

Aligning Objects	308

Drawing Sectors and Segments	309

Entering Text	310

Normal Text	310

Fitting Text to Frames	310

Callouts	311

Converting Text Into 3D	311

Drawing, Editing and Converting	312

Curves and Objects	312

Drawing Curves	312

Editing Curves	313

Vectorizing Bitmaps	314

Converting Text Characters to Curves	315

Converting to Curves, Polygons, 3D	316

Working With Objects	319

Duplicating Objects	319

Cross-Fading Between Two Objects	320

Grouping Objects	321

Entering Groups	321

Exiting Groups	321

Navigating Between Objects of a Group	322

Combining Objects and Constructing Shapes	323

Combining Objects	323

Constructing Shapes	323

Shapes - Merge	324

Shapes - Subtract	324

Graphic Objects in Drawings and Presentations	325

Inserting Bitmaps	325

Editing Bitmaps	325

Applying Text to Bitmaps	325

Saving Bitmaps	326

Working With colours	328

The colour Bar	328

Defining Custom colours	329

Replacing colours using the Eyedropper	331

Gradients and Patterns for Objects and Background	333

Defining Gradients	333

Defining a custom colour Gradient	333

Interactively Defining a colour Gradient	334

Organizing the Attribute Tables	335

3D Globe	336

Creating Texture on a 3D Object	336

Using Illumination	338

More 3d Effects	338

3D Effects: Favourites	338

3D Effects: Geometry	339

3D Effects: Shading	339

3D Effects: Illumination	340

3D Effects: Textures and Material	340

Designing 3D Objects From Font Characters	341

First Step:	341

Second Step:	342

Third Step:	343

Fourth Step:	345

Fifth Step:	346

Using a Grid	347

Mechanical or Construction Drawings	348

Creating a Construction Plan	349

Using Snap Lines	353

Using Dimension Lines	353

Working With Multiple Layers	354

Using One colour per Layer	354

Chapter 7: Databases and Data Sources	355

Registering a Data Source	355

AddressBooks	357

Registering an AddressBook	357

Using the Wizard to import an AddressBook	357

Manually Registering an Existing Address Book	357

System Address Book as Data Source	359

Importing Data Into OpenOffice.org	361

Importing and Exporting Data in Text Format	361

Exporting in CSV Text Format	361

Database Tables	363

Table Design	363

Field Properties	364

Form Design	365

Forms in OpenOffice.org Tutorial	365

Available controls	366

Customizing controls	367

Creating a group of option buttons	368

Setting up a combo box	368

How to set up a list box	369

Do any other controls have an wizard?	370

Attaching a data source to a form	370

Associating data with a field	370

Activating form controls in a document	371

How to use the form	371

Searching in Tables and Form Documents	373

Searching With a Form Filter	373

Operators	373

Commands	374

Chapter 8: Customizing OpenOffice.org	377

Modifying and Customizing the User Interface of OpenOffice.org	377

Configuring the Keyboard	377

Configuring Menus	378

Changing Toolbars	379

Inserting, Moving and Deleting Icons on Toolbars	379

Changing Icon Views	380

Changing the Look of the User Interface	381

Selecting Measurement Units	381

Moving, Deleting or Copying Icons	381

Sending Faxes and Configuring OpenOffice.org for Faxing	382

Creating a LAN Friendly Faxing Solution under Linux	382

Creating a LAN Friendly Faxing Solution under Windows	382

Sending a Fax via dialogue	383

Configuring OpenOffice.org for Faxing via Icon	383

Further Information	383

Chapter 9: Advanced Techniques	384

Copying and Moving Data Using Drag and Drop	384

Dragging and Dropping Within a OpenOffice.org Document	384

Inserting Objects From the Gallery	384

Inserting an object as a copy	384

Inserting an object as a link	385

Inserting an object as a background graphic	385

Inserting an object as a texture (pattern) for another object	385

Copying Graphics From the Gallery	385

Inserting Graphics From a Document in the Gallery	385

Copying Graphics Between Documents	386

Copying Draw Objects into Other Documents	386

Inserting a Draw object in a text document	387

Inserting a Draw object in a spreadsheet	388

Drag and Drop With the Data Source View	390

Using data in a text document	390

Applying data to a table document	390

Inserting controls in a text form	390

Copying Sheet Areas to Text Documents	391

Inserting Data From Spreadsheets	391

Inserting Data From Text Documents	391

Copying Text Using Drag and Drop	392

Revision Marking Function	393

Recording and Displaying Changes	393

Accepting or Rejecting Changes	394

Comparing Versions of a Document	395

Merging Versions	395

Recording Changes	395

Version Management	396

Protecting Contents in OpenOffice.org	397

Protecting All Documents When Saving	397

Turning on protection	397

Turning off protection	397

Protecting Revision Marking	397

Turning on revision protection	397

Turning off revision protection	397

Protecting Cell Ranges in Calc	397

Protecting Sections in Writer	398

Turning on protection	398

Turning off protection	398

Protecting Cells in a OpenOffice.org Writer Table	398

Automatic Protection of Indexes and Tables	399

Turning on protection	399

Turning off protection	399

Protecting frames, graphics and OLE objects	399

Protecting Drawing Objects and Form Objects	399

Turning on protection	399

Turning off protection	399

Protecting Records	400

Digital Signatures and Encryption	400

Overview	400

Certificates	400

How to get a Certificate?	400

Self-signed certificates	401

Certificates from a Certificate Authority	401

Integrating a Certificate with OpenOffice.org	401

Changing Defaults and Other Configuration Items	402

Saving Configuration With Document	402

Inserting and Editing Tab Stops	402

Moving Tabs on the Ruler	403

Changing the Properties of Tabs	403

Deleting Tabs	403

Changing the Defaults	403

Changing the colour of Text	404

Inserting Landscape pages into a Portrait-oriented Document	404

More on Templates	405

Changing Default Templates	405

Modifying Default Templates	405

Resetting Default Templates	405

Using Custom Templates	405

Using OpenOffice.org over a Network	406

Chapter 10: Introducing OpenOffice.org Basic and Macros	407

Accessing the Sample Macros	407

Calling the Sample Macros	407

Editing the Sample Macros	409

The Sample Macros	410

AutoText	410

ChangeAllChars	410

GetTexts	410

ReadDir	410

Userfields	410

Chapter 11: Using OpenOffice.org Math	411

Formula Entry	411

Tool bar	411

Command Icon Box	412

Command dialogue Box	412

Creating an Equation with dialogue Commands	413

Special Formating	414

Exponentiation:	414

Subscripting:	414

Leading and trailing superscript and subscript:	414

Centre subscript / superscript:	414

Under brace / Over brace:	415

Various types of Brackets	415

Special Characters	416

Special Operators	417

Integral Sign:	417

Summation Character:	417

Product Character:	417

Vectors and Matrices	418

Vector	418

Matrix	418

Formatting	419

Size	419

Colour	419

Layout	420

Alignment	421

Examples	422

Chapter 12: Building Forms with Xforms	425

Step-by-Step Procedure	425

Chapter 13: Xml Enhancements	435

Flat XML filter	435

Creating a new Docbook Filter	440

Chapter 14: Troubleshooting Common Problems	441

Error Message contains “Get Storage: "No Content"”	441

Under Windows®	441

Multi-user installations:	441

Single-user installations:	441

UNIX systems	442

Outline numbering is not retained after a save.	442

How get the page count to not count a title page?
Or How do I offset the page count?	443

What to do when document prints or exports with blank pages	443

What to to do with a General error General input/output error	444

How to recover content from a Openoffice.org file	444

Steps for recovering a damaged Openoffice.org file:	444

How to get sounds under Linux?	445

Overview	445

Starting	445

Installing the JRE	446

Activating the JRE in OpenOffice.org	446

Installating the JMF	446

Integration of the JMF in OpenOffice.org	447

Registration of the Plugins in the JMF	448

Integration of the Plugins in OpenOffice.org	448

Time for the second test	448

Integration of the Plugins in OpenOffice.org	450

Time for the third test	450

What to do if it fails?	450

How to open Microsoft Works Documents in OpenOffice.org 2.x	451

Index	452

Public Documentation License, Version 1.0	460