OpenOffice.org User Guide

for Version 2.x

[OpenOffice.org User Guide for 2.x]
[0.22]
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 her indexing effort, Ross Johnson for his editing/correctionsand manitoban for the docking text in chapter 2.

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
[0.21]	[2006-10-18]	[grs:21st draft issued for comment – Integrated ztyx and walteram updates to chapters 3, 4 and 10
[0.22]	2007-03-06	[grs:22nd draft issued for comment — added more info on keyboard shortcuts to Chapter 5 – Impress and minor changes.

Contents

Overview	1

Using the Guide	1

Important 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 Features	4

Mail Merge Wizard	4

Enhanced Word Count Feature	4

Support for Nested Tables	4

Digital Signatures Support	4

XForms Support	4

WordPerfect® Filters	5

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

Quickstarter for *NIX Operating Systems	6

Multiple Language Support	6

New Charting Module	6

Chapter 1: Using OpenOffice.org Help	8

OpenOffice.org Step-by-Step Help	8

Tips	9

Turning tips on and off	9

Extended Tips	9

Turning extended tips on and off	9

Help Agent	9

Turning the Help Agent on and off	10

Chapter 2: Working With OpenOffice.org	12

The User Interface	12

Starting OpenOffice.org	12

The OpenOffice.org Writer Window	13

Toolbars in the OpenOffice.org Window	13

The Title Bar	13

The Menu Bar	14

The Toolbars	14

Examples of Floating Toolbars	15

Using Floating Toolbars	16

The document window	16

Docking toolbars	16

Docking windows	17

Changing the Visibility of Buttons on Toolbars	17

Opening and Saving Documents	18

Opening Documents	18

Saving Documents	21

Changing the Work Directory	23

Saving Documents Automatically	23

Backup a File Automatically	23

Saving Recovery Information Automatically Every 'n' Minutes	23

OpenOffice.org File Formats	24

XML file format names	24

OpenOffice.org XML file structure	25

Definition of the XML formats	26

Setting Tabstops	26

Sending Documents as E-Mail	27

Single Messages	27

MailMerge	27

Printing Documents	28

Displaying Print Previews	29

Reduced Printing of Documents	30

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

Printing in Black and White	30

Printing text and graphics in black and white	30

Printing all Draw and Impress documents in black and white	30

Printing only text in black and white	31

Printing all Writer documents with black and white text	31

Printing the current Writer document with black and white text	31

Printing Brochures	31

Spellcheck	32

Automatic Spellcheck	32

Checking Multilingual Texts	33

Starting Spellcheck	34

Excluding Text From the Spellcheck	35

Adding Writing Aids for Other Languages	35

Getting New Writing Aids	35

Using Automatic Functions	40

Using AutoCorrect and AutoFormat	40

Turning off URL Recognition by AutoCorrect	42

Undo URL recognition	42

Turn off URL recognition	42

Other AutoCorrect functions	42

Creating a Letter Template With the Wizard	44

Find & Replace	45

Finding a Word in Text	45

Searching for Whole Words Only	46

Match Case	46

Searching for Text With Wildcards	46

Searching Backward	47

Current Selection Only	47

Searching for Styles	47

Searching for Text Attributes	47

Searching for Special Formats	48

Similarity Search	48

List of Regular Expressions	48

Digital Signatures and Printing or Exporting Documents	51

Only “open password”, no restriction	53

“open password”, restricted	53

Permission restricted only	53

PDF without restriction (Default behaviour)	53

Permissions available	53

Printing	53

Changes	53

Enable copy	54

Enable accessibility	54

Programming PDF Security in Macros	54

Chapter 3: Managing Text Documents With Writer	57

The OpenOffice.org Writer Functions	57

Writing	57

Designing and Structuring	57

Desktop Publishing with OpenOffice.org Writer	58

Calculations	58

Creating Drawings	58

Inserting Graphics	58

Customizable Program Interface	58

Drag&Drop	58

Extensive Help Functions	58

The OpenOffice.org Writer Window	59

Windows® of OpenOffice.org Writer	59

Entering and Formatting Text	60

Entering New Text	60

To enter new text:	60

Line breaks	60

Automatic correction	60

Word completion	60

Inserting Text	60

Switching Between Insert Mode and Overwrite Mode	61

Using the keyboard:	61

Using the mouse:	61

Entering Text Anywhere on a Page	61

Selecting and Deleting Text	62

Deleting characters	62

Deleting text	62

Selecting text to delete with the mouse	62

Selecting text to delete with the keyboard	62

Deleting non-adjacent pieces of text.	62

Status bar uses	63

Setting the Viewing Zoom Factor	63

Editing or Activating Hyperlinks	63

Applying Various Fonts	63

Keyboard Navigating and Selection in Writer	64

Inserting Special Characters	64

Inserting Protected Spaces, Hyphens and Conditional Separators	65

Non-breaking spaces	65

Non-breaking hyphen	65

Hyphen, em-dash and en-dash	65

Manual Hyphenation	65

Emphasizing Text	66

Changing the colour of Text	66

Rotating Text	66

Defining Borders	67

Choose Format from the menu bar, Borders tab page	67

Use the Borders floating toolbar with Tables	69

Superscripts and Subscripts	71

Applying subscripts/superscripts retrospectively	72

Writing in Uppercase or Lowercase	72

Moving Text Sections in Documents	72

Resetting Font Attributes While Typing	73

Example procedure for resetting Font Attributes	73

Quick Formatting Using the Adjacent Paragraph Format	73

Using Sections	73

Sections and Columns	75

Inserting Sections	75

Editing Sections	75

Formatting Text With and Without Styles	76

Direct Formatting or Formatting With Styles	76

The Style Concept in OpenOffice.org	77

The Styles in the Styles and Formatting Window	77

Paragraph Styles	77

Paragraph Style.	78

Character Styles	80

Hierarchical Styles	80

Numbering Styles	81

Creating New Character Styles or Paragraph Styles	81

Creating Document Templates	82

The Advantages of the Styles and Formatting Window	83

Formatting Multiple Paragraphs	83

Changing a Style the Easy Way	83

Page Styles and Page Numbers	84

Create Page Styles	84

Editing Page Styles	88

Page Breaks as Paragraph Formats	88

Changing the Format of Page Numbers	89

Page Styles Summary	91

Defining default Templates	92

Templates and Styles	93

Copying Styles Between Templates and Documents	93

New Style from Selection	94

Transferring Formats With Fill Format Mode	94

Updating Styles From Selections	94

This is how to update a Style:	94

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

Entering and Formatting Text Automatically	95

Disabling the AutoCorrect Function	95

ASCII Quotation marks are replaced with Custom Quotes	95

Sentences always begin with a capital letter	95

Three identical characters will become a whole line	96

Automatic Spellcheck	96

To exclude words from Spellcheck	96

Using AutoText	97

Defining AutoText	98

Using AutoText in Networks	99

Printing AutoTexts	99

AutoText With AutoComplete	100

Exceptions in AutoCorrect	100

Example	100

Text Frames	101

Inserting, Editing and Linking Text Frames	101

Inserting Text Frames	101

Editing Text Frames	102

Linking Text Frames	102

Using Text Animation	104

Drawing Lines in Text	107

Editing Text With FontWork	108

Aligning Text With Lines	110

Aligning text on a free form line	110

Aligning text with straight lines	110

The Navigator	111

Jumping From One Object to Another in Text	111

Jumping to a Specific Page	112

Chapters in Navigator	113

Indexes and Tables of Contents in Writer	114

Defining Index/Table of Contents Entries	114

Editing or Deleting Index and Table Entries	115

Creating a Table of Contents	116

Creating Alphabetical Indexes	117

Creating User-Defined Indexes	117

Using a Concordance File	119

Preparation	119

Entering Data	119

Example file	120

Creating Bibliographies	122

Updating, Editing and Deleting Indexes and Tables of Contents	123

Editing the Format of an Index/Table of Contents	123

Indexes Covering Multiple Documents	124

Headings and Numbering	125

Numbering and Numbering Styles	125

Turning Bullets On and Off	125

Turning Numbering On and Off	126

Example numbered list with sublevels:	127

Outline Numbering	127

Automatic Bullets and Numbering	128

Numbering Illustrations by Chapters	129

Defining Number Ranges	129

Using Master Documents and Subdocuments	131

Importing Lists From Other Text Programs	136

Changing Numbering via the Keyboard	136

Interrupting and Continuing Numbering	137

Delete the automatic numbering	137

Formatting the paragraph	137

Continuing numbering with a new starting value	137

Numbering Lines	138

Line Numbering for All Paragraphs	138

Line Numbering for Particular Paragraphs	138

Tables in Text	139

Inserting Tables	139

Inserting an empty table using the mouse:	139

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

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

Inserting from OpenOffice.org Calc with the clipboard	139

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

Deleting Tables	140

Inserting Paragraphs Before Tables at Start of Page	141

Resize columns, rows, and cells	141

Table AutoFormat	141

Table properties in general	141

Calculating in Text Documents	143

Formulae in Text Documents	143

Formula Options	143

Basic Calculation Functions	143

Basic Functions in the Submenu	143

Operators	143

Statistical Functions	144

Trigonometric Functions	144

More Defined Values	145

Calculating in Text	145

Calculating With formulae Located in Text	146

Conditional Text	147

Defining and using conditional text – by example	147

Defining a conditional variable	147

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

Defining a condition and the conditional text:	148

Displaying the conditional text:	149

Calculating in Text Document Tables	150

Calculating Across Multiple Tables	151

Calculating Cell Totals in Tables	152

Merging and Splitting Cells	152

Merging Cells in OpenOffice.org Writer	152

Splitting Cells in OpenOffice.org Writer	152

Merging Cells in OpenOffice.org Calc OLE Objects	152

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

Inserting or Deleting Rows/Columns Using the Keyboard	153

Repeating Multiple Heading Rows in a Table	153

Enlarging and Reducing Cells in Text Tables	153

Adapting Table Widths	154

Images, Drawings, Clipart and FontWork	156

Positioning Objects	156

Captions and Number Ranges	157

Defining Captions	157

Editing or deleting captions	157

Inserting an object in a number range	157

Numbering Illustrations by Chapters	158

Inserting Graphics	158

Inserting Graphics via dialogue	158

Inserting Graphics From OpenOffice.org Draw or Impress	159

Inserting Graphics via Drag and Drop From the Gallery	159

Adding Graphics To the Gallery via Drag and Drop	160

Inserting Graphics With a Scanner	160

Inserting a Chart From OpenOffice.org Calc	160

Dragging and Dropping the Chart with Move or Copy	160

Charts with Linked Data	161

Inserting Decorative Horizontal Lines	161

Headers, Footers and Footnotes	162

Some Notes Concerning Headers and Footers	162

Inserting Page Numbers in Footers	162

Formatting Headers and Footers	165

Defining Different Headers	165

Inserting Page Numbers of Continuation Pages	165

Inserting Lines Under Headers	166

Footnotes and Endnotes	167

Inserting and Editing Footnotes	168

Inserting a footnote via an icon	168

Inserting a footnote via a dialogue	168

Tips for Working with Footnotes	169

Spacing Between Footnotes	169

Spellcheck, Dictionaries, Hyphenation	170

Controlling Spellcheck via the dialogue	170

Automatic Spellcheck	171

To exclude words from the Spellcheck:	172

Removing Words From User-Defined Dictionaries	172

Hyphenation	172

Automatic hyphenation	172

Manual Hyphenation	173

Thesaurus	174

Form Letters, Business Cards and Labels	176

Creating Form Letters	176

Brief Instructions (For Quick Results)	176

Fixed and Variable Fields	176

Creating and Printing Labels and Business Cards	178

Designing Business Cards via dialogue	178

Designing Labels and Business Cards	179

Printing Labels With Serial Numbers	179

Printing Address Labels	180

Avoiding Blank Paragraphs	181

Newsletters	183

Creating a Newsletter From a Template	184

Creating Page Styles	184

Editing Headers	184

Editing Columns	184

Editing Paragraph Styles	185

Working with Frames	186

Formatting a Frame	186

Anchoring Frames	186

Defining a Frame Wrap	186

Defining a Wrap Region	187

Using coloured or Graphic Backgrounds	188

Creating a Table of Contents	188

Further Information	191

Using Automatic Hyphenation	191

Letters With Envelopes	192

Using a Ready-Made Letter Template	192

Creating a Letter Template Using the Wizard	192

Creating an Envelope Template	193

Inserting an Envelope into a Document	194

Adjusting the Printer for the Printout	195

Creating and Printing a Letter With an Envelope	195

Creating an Single Envelope	195

Adding a POSTNET Bar Code to an Envelope	196

Get a POSTNET font	196

Building a Complete POSTNET Bar Code for Printing	196

Chapter 4: Spreadsheets in Calc	198

Overview of the Functions in Calc	198

Calculating	198

Database Functions	198

Arranging Data	198

Examining and Extrapolating Data	198

What-If Calculations	198

Dynamic Charts	199

Importing and Exporting Data	199

Importing into Calc	199

Exporting from Calc	200

Referencing Data in Networks and the Internet	200

The Calc Window	201

Structure of a Spreadsheet	201

Rows and Columns	202

Multiple Sheets in a Document	203

Inserting Sheets	203

Renaming Sheets	203

Values and Formulae as Cell Contents	205

Calculating in Spreadsheets	205

Using Built-in Functions	207

A Short Description of What Cells Can Contain	208

Text	208

Numbers	210

Calculating With formulae	213

Calculating With Dates and Times	214

Inserting and Editing Notes	215

Handling Multiple Sheets	216

Displaying Multiple Sheets	216

Working With Multiple Sheets	216

Printing Spreadsheets	217

Formatting a Spreadsheet	218

Formating Numbers	218

Dates	218

Formatting Cells and Sheets	219

Using AutoFormat for Tables	219

Layout of Spreadsheets	220

Designing Spreadsheets Clearly	220

Formatting Text in a Spreadsheet	221

Formatting Numbers in a Spreadsheet	221

Formatting Borders and Backgrounds for Cells and Pages	221

Addressing Cells	222

Addresses and References, Absolute and Relative	222

Relative Addressing	222

Absolute Addressing	222

When to Use Relative and Absolute References	222

Addressing by Name	224

Recognizing Names as Addressing	224

Only Copy Visible Cells	225

Referencing a Cell in Another Document	226

Using References in formulae	227

References to Other Sheets	228

Using Charts	230

Editing Chart Titles	233

Editing Chart Legends	233

Adding Texture to Chart Bars	234

Editing Chart Axis	234

Database Functions in Calc	235

Defining Database Ranges	235

Creating Records in a Spreadsheet	235

Defining Database Ranges	237

Sorting Database Ranges	237

Filtering Database Ranges	238

Grouping Database Ranges and Calculating Subtotals	240

Transferring Data From a Data Source to a Spreadsheet	241

Opening a Database File in Calc	241

Evaluating Data With Calc	244

DataPilot	244

What use is the DataPilot?	245

Creating DataPilot Tables	245

Selecting DataPilot Output Ranges	247

Editing DataPilot Tables	247

Filtering DataPilot Tables	247

Updating DataPilot Tables	247

Deleting DataPilot Tables	247

Consolidating Data	248

Applying Goal Seek	250

Naming Cells	250

Start Goal Seek	251

Applying Multiple Operations	251

Multiple Operations in Columns or Rows	251

Examples	251

Calculating With One Formula and One Variable	252

Calculating with Several formulae Simultaneously	252

Multiple Operations Across Rows and Columns	252

Calculating with Two Variables	253

Using Scenarios	254

Using Ready-Made Scenarios	254

Creating Personal Scenarios	254

Validity of Cell Contents	256

Using Cell Contents Validity	256

Sample macro:	258

Printing or Exporting Spreadsheets	259

Printing Sheet Details	259

Defining Number of Pages for Printing	259

Printing Sheets in Landscape Format	260

Printing Rows or Columns on Every Page	260

Saving and Opening Sheets in HTML	262

Saving Sheets in HTML	262

Opening Sheets in HTML	262

formulae and Values as CSV Files	263

Exporting formulae and Values as CSV Files	263

Importing a CSV File	263

AutoFill	265

Applying Sort Lists	265

Automatic Row Filling	265

Protecting Sheets	266

Creating a Reference	267

Further Information	267

Inserting a note	268

Inserting a sheet into another document	268

Displaying formulae	268

Using print ranges	268

Freezing Columns	268

Splitting a Calc Window	268

Conditional Formatting	268

Defining Validity	270

Creating Input Help	270

Linking Sheet Information	271

Chapter 5: Creating Presentations With Impress	272

OpenOffice.org Impress Toolbars and Windows®	273

How to Create a Basic Presentation	274

Creating a Presentation With the Wizard	274

Creating a Simple Presentation Without the Wizard	280

Switching Presentation Views	281

Arranging Slides	282

Incorporating Slide Show Effects	283

In-Slide Effects	283

Showing a Presentation	283

Editing Presentations	284

Defining Background colours	284

Switching Page Styles	285

Presentation Styles	285

Using Outline View	287

Slide Transitions, Effects and Animation	288

Automatic Slide Transition	288

Effects for Objects	288

Selecting Hidden Objects	289

Individual Presentations	289

Exporting, Printing and Presenting	291

Printing a Presentation Slide	291

Exporting Presentations as Web Pages	292

Exchanging Data via the Clipboard	293

Creating a Business Report	294

Creating a Business Report in Presentation Form	294

Entering Text in the Outline View	295

Changing the Slide Layout	295

Designing Slides	295

Creating a Slide Show	297

Defining or Changing Slide Order	298

Creating Cross-Fade Effects	298

Starting Presentations	299

Working with Connectors	300

"Edge to Edge” Connectors	300

"Middle to Middle” Connectors	301

Editing Connectors	301

Using a Snap Grid	301

Editing Glue Points	302

Hints and Tips for a Successful Presentation	303

Using the Mouse as a Pointer	303

Changing Bullet Symbols in Outline View	303

Inserting, Deleting and Renaming Slides	303

Creating and Printing Handouts	304

Organizing and Printing Notes	304

Using the Navigator	305

Edit Jump Targets	305

Modifying Object Size	305

Creating Additional Objects	305

Changing Font and Font Size	305

Modifying colours	305

Keyboard Navigating and Selection in Impress	306

Chapter 6: Creating Drawings with Draw	307

OpenOffice.org Draw Functions	307

Creating and Publishing Vector Graphics	307

Creating 3D Objects	307

Manage Organization Charts	307

Drawing	307

Export	308

Construct	308

Integrate	308

The OpenOffice.org Draw Window	309

Toolbars and Windows® in OpenOffice.org Draw	309

Drawing Rectangles and Ellipses and Entering Text	310

Rotating and Resizing Objects	312

Arranging and Aligning Objects	313

Arranging Objects	313

Aligning Objects	314

Drawing Sectors and Segments	316

Entering Text	317

Normal Text	317

Fitting Text to Frames	317

Callouts	318

Converting Text Into 3D	319

Drawing, Editing and Converting	320

Curves and Objects	320

Drawing Curves	320

Editing Curves	322

Vectorizing Bitmaps	323

Converting Text Characters to Curves	324

Converting to Curves, Polygons, 3D	325

Working With Objects	328

Duplicating Objects	328

Cross-Fading Between Two Objects	329

Grouping Objects	330

Entering Groups	330

Exiting Groups	330

Navigating Between Objects of a Group	331

Combining Objects and Constructing Shapes	332

Combining Objects	332

Constructing Shapes	332

Shapes - Merge	333

Shapes - Subtract	334

Graphic Objects in Drawings and Presentations	336

Inserting Bitmaps	336

Editing Bitmaps	336

Applying Text to Bitmaps	336

Saving Bitmaps	337

Working With colours	339

The colour Bar	339

Defining Custom colours	340

Replacing colours using the Eyedropper	342

Gradients and Patterns for Objects and Background	344

Defining Gradients	344

Defining a custom colour Gradient	344

Interactively Defining a colour Gradient	345

Organizing the Attribute Tables	346

3D Globe	347

Creating Texture on a 3D Object	347

Using Illumination	349

More 3d Effects	349

3D Effects: Favourites	349

3D Effects: Geometry	350

3D Effects: Shading	351

3D Effects: Illumination	353

3D Effects: Textures and Material	354

Designing 3D Objects From Font Characters	355

First Step:	355

Second Step:	356

Third Step:	357

Fourth Step:	359

Fifth Step:	360

Using a Grid	362

Mechanical or Construction Drawings	363

Creating a Construction Plan	364

Using Snap Lines	368

Using Dimension Lines	368

Working With Multiple Layers	369

Using One colour per Layer	369

Chapter 7: Databases and Data Sources	371

Registering a Data Source	371

AddressBooks	373

Registering an AddressBook	373

Using the Wizard to import an AddressBook	373

Manually Registering an Existing Address Book	373

System Address Book as Data Source	375

Importing Data Into OpenOffice.org	377

Importing and Exporting Data in Text Format	377

Exporting in CSV Text Format	377

Database Tables	379

Table Design	379

Field Properties	380

Form Design	381

Forms in OpenOffice.org Tutorial	381

Available controls	382

Customizing controls	383

Creating a group of option buttons	384

Setting up a combo box	385

How to set up a list box	385

Do any other controls have an wizard?	386

Attaching a data source to a form	386

Associating data with a field	386

Activating form controls in a document	387

How to use the form	388

Searching in Tables and Form Documents	389

Searching With a Form Filter	390

Operators	390

Commands	391

Chapter 8: Customizing OpenOffice.org	394

Modifying and Customizing the User Interface of OpenOffice.org	394

Configuring the Keyboard	394

Configuring Menus	395

Changing Toolbars	396

Inserting, Moving and Deleting Icons on Toolbars	396

Changing Icon Views	397

Changing the Look of the User Interface	398

Selecting Measurement Units	398

Moving, Deleting or Copying Icons	398

Sending Faxes and Configuring OpenOffice.org for Faxing	399

Creating a LAN Friendly Faxing Solution under Linux	399

Creating a LAN Friendly Faxing Solution under Windows	399

Sending a Fax via dialogue	400

Configuring OpenOffice.org for Faxing via Icon	400

Further Information	400

Chapter 9: Advanced Techniques	401

Copying and Moving Data Using Drag and Drop	401

Dragging and Dropping Within a OpenOffice.org Document	401

Inserting Objects From the Gallery	401

Inserting an object as a copy	401

Inserting an object as a link	402

Inserting an object as a background graphic	402

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

Copying Graphics From the Gallery	402

Inserting Graphics From a Document in the Gallery	402

Copying Graphics Between Documents	403

Copying Draw Objects into Other Documents	403

Inserting a Draw object in a text document	404

Inserting a Draw object in a spreadsheet	404

Drag and Drop With the Data Source View	405

Using data in a text document	405

Applying data to a table document	405

Inserting controls in a text form	405

Copying Sheet Areas to Text Documents	406

Inserting Data From Spreadsheets	406

Inserting Data From Text Documents	406

Copying Text Using Drag and Drop	407

Revision Marking Function	408

Recording and Displaying Changes	408

Accepting or Rejecting Changes	409

Comparing Versions of a Document	410

Merging Versions	410

Recording Changes	410

Version Management	411

Protecting Contents in OpenOffice.org	412

Protecting All Documents When Saving	412

Turning on protection	412

Turning off protection	412

Protecting Revision Marking	412

Turning on revision protection	412

Turning off revision protection	412

Protecting Cell Ranges in Calc	412

Protecting Sections in Writer	413

Turning on protection	413

Turning off protection	413

Protecting Cells in a OpenOffice.org Writer Table	413

Automatic Protection of Indexes and Tables	414

Turning on protection	414

Turning off protection	414

Protecting frames, graphics and OLE objects	414

Protecting Drawing Objects and Form Objects	414

Turning on protection	414

Turning off protection	414

Protecting Records	415

Digital Signatures and Encryption	415

Overview	415

Certificates	415

How to get a Certificate?	415

Self-signed certificates	416

Certificates from a Certificate Authority	416

Integrating a Certificate with OpenOffice.org	416

Changing Defaults and Other Configuration Items	417

Saving Configuration With Document	417

Inserting and Editing Tab Stops	417

Moving Tabs on the Ruler	418

Changing the Properties of Tabs	418

Deleting Tabs	418

Changing the Defaults	418

Changing the colour of Text	419

Inserting Landscape pages into a Portrait-oriented Document	419

More on Templates	420

Changing Default Templates	420

Modifying Default Templates	420

Resetting Default Templates	420

Using Custom Templates	420

Using OpenOffice.org over a Network	421

Chapter 10: Introducing OpenOffice.org Basic and Macros	422

Accessing the Sample Macros	422

Calling the Sample Macros	422

Editing the Sample Macros	423

The Sample Macros	424

AutoText	424

ChangeAllChars	424

GetTexts	424

ReadDir	424

Userfields	424

Chapter 11: Using OpenOffice.org Math	425

Formula Entry	425

Tool bar	425

Command Icon Box	426

Command dialogue Box	426

Creating an Equation with dialogue Commands	427

Special Formating	428

Exponentiation:	428

Subscripting:	428

Leading and trailing superscript and subscript:	428

Centre subscript / superscript:	428

Under brace / Over brace:	429

Various types of Brackets	429

Special Characters	430

Special Operators	431

Integral Sign:	431

Summation Character:	431

Product Character:	431

Vectors and Matrices	432

Vector	432

Matrix	432

Formatting	433

Size	433

Colour	433

Layout	433

Alignment	434

Examples	435

Chapter 12: Building Forms with Xforms	436

Step-by-Step Procedure	436

Chapter 13: Xml Enhancements	447

Flat XML filter	447

Creating a new Docbook Filter	452

Chapter 14: Troubleshooting Common Problems	453

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

Under Windows®	453

Multi-user installations:	453

Single-user installations:	453

UNIX systems	454

Outline numbering is not retained after a save.	454

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

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

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

How to recover content from a Openoffice.org file	456

Steps for recovering a damaged Openoffice.org file:	456

How to get sounds under Linux?	457

Overview	457

Starting	457

Installing the JRE	458

Activating the JRE in OpenOffice.org	458

Installating the JMF	458

Integration of the JMF in OpenOffice.org	459

Registration of the Plugins in the JMF	460

Integration of the Plugins in OpenOffice.org	460

Time for the second test	461

Integration of the Plugins in OpenOffice.org	462

Time for the third test	462

What to do if it fails?	463

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

Index	465

Public Documentation License, Version 1.0	473