OpenOffice.org OpenOffice - 3.2 Guide de démarrage rapide

Naviguer en ligne ou télécharger Guide de démarrage rapide pour Logiciels graphiques OpenOffice.org OpenOffice - 3.2. OpenOffice.org OpenOffice - 3.2 Getting Started Guide Manuel d'utilisatio

  • Télécharger
  • Ajouter à mon manuel
  • Imprimer
  • Page
    / 442
  • Table des matières
  • MARQUE LIVRES
  • Noté. / 5. Basé sur avis des utilisateurs
Vue de la page 0
Getting Started
with
OpenOffice.org
This PDF is designed to be read onscreen, two pages at a
time. If you want to print a copy, your PDF viewer should
have an option for printing two pages on one sheet of
paper, but you may need to start with page 2 to get it to
print facing pages correctly. (Print this cover page
separately.)
Free eBook Edition
Vue de la page 0
1 2 3 4 5 6 ... 441 442

Résumé du contenu

Page 1 - Free eBook Edition

Getting Started with OpenOffice.orgThis PDF is designed to be read onscreen, two pages at a time. If you want to print a copy, your PDF viewer should

Page 2

Chapter 1 Introducing OpenOffice.orgFree eBook Edition

Page 3

indent icons on the ruler to open the Tabs page of the Paragraph dialog (Figure 75).A better strategy is to define tabs for the paragraph style. See C

Page 4

Checking spelling and grammarWriter provides a spelling checker, which can be used in two ways.AutoSpellcheck checks each word as it is typed and disp

Page 5

The main advantage of changing the language is that you can then use the correct dictionaries to check spelling and apply the localized versions of Au

Page 6

Choose Tools > AutoCorrect Options to open the AutoCorrect dialog. There you can define which strings of text are corrected and how. In most cases,

Page 7

Using AutoTextAutoText allows you to assign text, tables, graphics and other items to a key combination. For example, rather than typing “Senior Manag

Page 8

system and the selection of icon size and style in Tools > Options > OpenOffice.org > View.1 Open Styles and Formatting Window5 Align Right 1

Page 9

AutoformattingYou can set Writer to automatically format parts of a document according to the choices made on the Options page of the AutoCorrect dial

Page 10

Using the Bullets and Numbering toolbarYou can create nested lists (where one or more list items has a sublist under it, as in an outline) by using th

Page 11

2) On the Paragraph Styles page of the Styles and Formatting window, right-click on Default in the list and select Modify.3) On the Paragraph Style di

Page 12

Manual hyphenationTo manually hyphenate words, do not use a normal hyphen, which will remain visible even if the word is no longer at the end of a lin

Page 13

What is OpenOffice.org?OpenOffice.org (OOo) is both a software product and a community of volunteers who produce and support the software.NoteBecause

Page 14

For an index or other document with two columns of text, where the text continues from the left-hand column to the right-hand column and then to the n

Page 15

Creating headers and footersA header is an area that appears at the top of a page. A footer appears at the bottom of the page. Information, such as pa

Page 16

2) Press the spacebar once, type the word “of” and a space, then choose Insert > Fields > Page Count.NoteThe Page Count field inserts the total

Page 17

Figure 80: Restarting page numbering after a manual page breakChanging page marginsYou can change page margins in two ways:• Using the page rulers—qui

Page 18

TipThe small arrows on the ruler are used for indenting paragraphs. They are often in the same place as the page margins, so you need to be careful to

Page 19

Choose Tools > Options > User Data to configure the name you want to appear in the Author field of the note, or to change it.If more than one pe

Page 20

1) Place the cursor within the table of contents.2) Right-click and choose Update Index/Table from the pop-up menu.NoteIf you cannot place your cursor

Page 21

Printing from WriterWriter provides a range of choices when printing.Quick printingClick the Print File Directly icon to send the entire document to

Page 22

• What pages to print, how many copies to print, and in what order to print them. Use dashes to specify page ranges and commas or semicolons to separa

Page 23

• In the Comments section, you can choose whether to print any comments that have been added to your document (using Insert > Comment), and where t

Page 24

Impress (presentations)Impress provides all the common multimedia presentation tools, such as special effects, animation, and drawing tools. It is int

Page 25

To use Page Preview:1) Choose File > Page Preview, or click the Page Preview button .The Writer window changes to display the current page and the

Page 26

> Print. In the Print dialog, click Properties and be sure the printer is set to the same orientation (portrait or landscape) as specified in the p

Page 27

• In Character, you can choose Fonts (Sizes...), Fonts Effects (Underlining, Color...), Position (Rotating/scaling...), Hyperlink, Background and more

Page 28

4) In the lower left of this page, choose the envelope format from the drop-down list. The width and height of the selected envelope then show in the

Page 29

Printing labelsLabels are commonly used for printing address lists (where each label shows a different address), but they can also be used for making

Page 30

Figure 91. Labels dialog, Format page5) Click Save to save your new format.6) When you have finished formatting, click New Document to make your sheet

Page 31

Sending a fax through the Print dialog1) Open the Print dialog by choosing File > Print and select the fax driver in the Name list.2) Click OK to o

Page 32

Using fieldsFields are extremely useful features of Writer. They are used for data that changes in a document (such as the current date or the total n

Page 33

Using hyperlinksThe easiest way to insert a hyperlink to another part of the same document is by using the Navigator:1) Open the document containing t

Page 34

items, such as headings, bookmarks, figures, tables, and numbered items such as steps in a procedure. You can also create your own reference items; se

Page 35

The advantages of OpenOffice.orgHere are some of the advantages of OpenOffice.org over other office suites:• No licensing fees. OOo is free for anyone

Page 36

Using bookmarksBookmarks are listed in the Navigator and can be accessed directly from there with a single mouse click. You can cross-reference to boo

Page 37

Using master documentsMaster documents are typically used for producing long documents such as a book, a thesis, or a long report; or when different p

Page 38

Chapter 5 Getting Started with CalcUsing Spreadsheets in OpenOffice.orgFree eBook Edition

Page 39

What is Calc?Calc is the spreadsheet component of OpenOffice.org (OOo). You can enter data (usually numerical) in a spreadsheet and then manipulate th

Page 40

Parts of the main Calc windowWhen Calc is started, the main window looks similar to Figure 96.Figure 96. Parts of the Calc windowTitle barThe Title ba

Page 41

In the Formatting toolbar, the three boxes on the left are the Apply Style, Font Name, and Font Size lists (see Figure 97). They show the current sett

Page 42

The Function button inserts an equals (=) sign into the selected cell and the Input Line, thereby setting the cell ready to accept a formula.When you

Page 43

Figure 99: Left end of Calc status barFigure 100: Right end of Calc status barStarting new spreadsheetsA new spreadsheet can be opened from any compon

Page 44

Opening existing spreadsheetsYou can open an existing spreadsheet from the Start Center or from any component of OOo.From the Start CenterClick the Op

Page 45

6) You can preview the layout of the imported data at the bottom of the dialog. Right-click a column in the preview to set the format or to hide the c

Page 46

• No vendor lock-in. OOo3 uses OpenDocument, an XML (eXtensible Markup Language) file format developed as an industry standard by OASIS (Organization

Page 47

From the toolbarClick the Save button on the Function bar. If the file has been saved and no subsequent changes have been made, this button is graye

Page 48

Figure 102: Choosing options when exporting to Text CSVNavigating within spreadsheetsCalc provides many ways to navigate within a spreadsheet from cel

Page 49

Figure 103: The Navigator in CalcThe Navigator displays lists of all the objects in a spreadsheet document, grouped into categories. If an indicator (

Page 50

Figure 104. (Left) One selected cell and (right) a group of selected cellsUsing the Tab and Enter keys• Pressing Enter or Shift+Enter moves the foc

Page 51

left. Depending on the file being used or on the type of data being entered, different directions can be useful.The Enter key can also be used to swit

Page 52

Figure 106. Sheet tab arrowsSelecting items in a sheet or spreadsheetSelecting cellsCells can be selected in a variety of combinations and quantities.

Page 53

The result of any of these methods looks like the right side of Figure104.TipYou can also directly select a range of cells using the Name box. Click i

Page 54

Figure 107. Select All boxYou can also press Control+A to select the entire sheet.Selecting sheetsYou can select either one or multiple sheets. It can

Page 55

Working with columns and rowsInserting columns and rowsColumns and rows can be inserted individually or in groups,NoteWhen you insert a single new col

Page 56

Multiple columns or rowsMultiple columns or rows can be deleted at once rather than deleting them one at a time.1) Highlight the required number of co

Page 57

from a third-party distributor. The project maintains a list of distributors, but the distributors are not connected with, nor endorsed by, OpenOffice

Page 58

Figure 109. Insert Sheet dialogDeleting sheetsSheets can be deleted individually or in groups.Single sheetRight-click on the tab of the sheet you want

Page 59

NoteSheet names must start with either a letter or a number; other characters including spaces are not allowed. Apart from the first character of the

Page 60

You can set the freeze point at one row, one column, or both a row and a column as in Figure 110.Freezing single rows or columns1) Click on the header

Page 61

Figure 111. Split screen exampleSplitting the screen horizontallyTo split the screen horizontally:1) Move the mouse pointer into the vertical scroll b

Page 62

Notice in Figure 111, the Beta and the A0 values are in the upper part of the window and other calculations are in the lower part. Thus you can make c

Page 63

Entering data using the keyboardMost data entry in Calc can be accomplished using the keyboard.Entering numbersClick in the cell and type in the numbe

Page 64

CautionWhen a number is formatted as text, take care that the cell containing the number is not used in a formula because Calc will ignore the value.E

Page 65

The most basic ability is to drop and drag the contents of one cell to another with a mouse. However, Calc also includes several other tools for autom

Page 66

type, and enter as the Start value an item from any defined series. The selected cells then fill in the other items on the list sequentially, repeatin

Page 67

Defining a fill seriesTo define a fill series, go to Tools > Options > OpenOffice.org Calc > Sort Lists. This dialog shows the previously-def

Page 68

newsgroups, forums, or mailing lists. There are also numerous websites run by users that offer free tips and tutorials.Free OpenOffice.org supportUser

Page 69

Sharing content between sheetsYou might want to enter the same information in the same cell on multiple sheets, for example to set up standard listing

Page 70

Removing data from a cellData can be removed (deleted) from a cell in several ways.Removing data onlyThe data alone can be removed from a cell without

Page 71

The process is the similar to the one described above, but you need to place the cursor inside the cell. You can do this in two ways.Using the keyboar

Page 72

Figure 121: Format Cells > Alignment dialogFigure 122: Automatic text wrapUsing manual line breaksTo insert a manual line break while typing in a c

Page 73

Figure 123: Cell with manual line breaksShrinking text to fit the cellThe font size of the data in a cell can automatically adjust to fit in a cell. T

Page 74

Figure 126: Format Cells > NumbersFormatting the fontTo quickly choose the font used in a cell, select the cell, then click the arrow next to the F

Page 75

To specify the language of the cell (useful because it allows different languages to exist in the same document and be spell checked correctly), use t

Page 76

Figure 127: Choosing an AutoFormat3) To select which properties (number format, font, alignment, borders, pattern, autofit width and height) to includ

Page 77

Formatting spreadsheets using themesCalc comes with a predefined set of formatting themes that you can apply to your spreadsheets.It is not possible t

Page 78

Hiding and showing dataWhen elements are hidden, they are neither visible nor printed, but can still be selected for copying if you select the element

Page 79

Starting OpenOffice.orgThe most common way to launch any component of OOo is by using the system menu, the standard menu from which most applications

Page 80

When you close the dialog, the outline group controls are visible between either the row or column headers and the edges of the editing window. The co

Page 81

operators AND and OR. Standard filters are mostly useful for numbers, although a few of the conditional operators, such as = and < > can also be

Page 82

Copy sort results toSets a spreadsheet address to which to copy the sort results. If a range is specified that does not have the necessary number of c

Page 83

Figure 131. Top of the Printer Options dialogSelecting sheets to printYou can select one or more sheets for printing. This can be useful if you have a

Page 84

Where a sheet prints on more than one page of paper, it can be printed either by column, where the first column of pages prints, and then the second c

Page 85

NoteRemember that since the print detail options are a part of the page’s properties, they are also a part of the page style’s properties. Therefore,

Page 86

Adding to the print rangeAfter defining a print range, you can add more cells to it. This allows multiple, separate areas of the same sheet to be prin

Page 87

Figure 133: Specifying repeating rows2) Columns can also repeat; type the columns in the text entry box under Columns to repeat. For example, to repea

Page 88

Column breakSelecting Column Break creates a page break to the left of the selected cell. For example, if the active cell is H15, then the break is cr

Page 89

From here you can also set the margins, the spacing, and height for the header or footer. You can check the AutoFit height box to have the height of t

Page 90

Using the Quickstarter under WindowsThe Quickstarter is an icon that is placed in the Windows system tray during system startup. It indicates that Ope

Page 91

Figure 135: Header/Footer Border/BackgroundContents of the header or footerThe header or footer of a Calc spreadsheet has three columns for text. Each

Page 92

AreasEach area is independent and can have different information in it.HeaderYou can select from several preset choices in the Header drop-down list,

Page 93

Chapter 6 Getting Started with ImpressPresentations in OpenOffice.orgFree eBook Edition

Page 94

What is Impress?Impress is OpenOffice.org’s slide show (presentations) program. You can create slides that contain many different elements, including

Page 95

Figure 137: Main window of ImpressSeveral additional operations can be performed on one or more slides in the Slides pane:• Add new slides at any plac

Page 96

Tasks paneThe Tasks pane has five sections.Master PagesHere you define the page style for your presentation. Impress contains 28 prepackaged Master Pa

Page 97

Each view is designed to make completing certain tasks easier. In summary:• Normal view is the main view for creating individual slides. Use this view

Page 98

Figure 138: Left end of the Impress status barFigure 139: Right end of Impress status barNavigatorThe Navigator (Figure 140) displays all objects cont

Page 99

Working with viewsThis section describes the use of the five views.Normal viewNormal view is the main view for working with individual slides. Use thi

Page 100

Outline view serves at least two purposes.4) Making changes in the text of a slide:• You can add and delete the text in a slide just as you would in t

Page 101

Reactivating the QuickstarterIf the Quickstarter has been disabled, you can reactivate it by selecting the Load OpenOffice.org during system start-up

Page 102

Figure 142: Notes viewSlide Sorter viewSlide Sorter view contains all the slide thumbnails (Figure 143). Use this view to work with a group of slides

Page 103

Change the number of slides per row if desired.1) Check View > Toolbars > Slide View to make the Slide View toolbar (Figure 144) visible.Figure

Page 104

You can work with slides in the Slide Sorter view just as you can in the Slide pane. To make changes, right-click a slide and do any of the following

Page 105

Creating a new presentationThis section describes how to set up a new presentation. The settings selected here are general: they apply to all the slid

Page 106

the drop-down menu or choose File > New > Presentation from the menu bar.When you start Impress, the Presentation Wizard appears (Figure146).Tip

Page 107

2) Click Next. Figure 147 shows the Presentation Wizard step 2 as it appears if you selected Empty Presentation at step 1. If you selected From Templa

Page 108

4) Select how the presentation will be used under Select an output medium. Most often, presentations are created for computer screen display. Select S

Page 109

Formatting a presentationNow put your presentation together based on your outline.CautionRemember to save frequently while working on the presentation

Page 110

Inserting additional slidesThe steps for inserting additional slides are basically the same as for selecting the title page. It is a process that has

Page 111

CautionChanges to any of the pre-packaged layouts can only be made using View > Normal, which is the default. Attempting to do this by modifying a

Page 112

CopyrightThis document is Copyright © 2005–2010 by its contributors as listed in the section titled Authors. You may distribute it and/or modify it un

Page 113

Type of document Component Command-line optionText Writer-writerSpreadsheet Calc-calcDrawing Draw-drawPresentation Impress-impressFormula Math-mathDat

Page 114

CautionWhen resizing a graphic, right-click the picture. Select Position and Size from the context menu and make sure that Keep ratio is selected. The

Page 115

2) Would an additional slide make a particular point clearer? If so, another slide needs to be created.3) Would some custom animations help some of th

Page 116

slides based on that slide master; it is, however, possible to modify each individual slide without affecting the slide master.Slide masters have two

Page 117

Creating slide mastersYou can create a new slide master in a similar way to modifying the default slide master.To start, enable editing of slide maste

Page 118

2) Select in the new dialog the template from which to load the slide master. Click OK.3) Click OK again to close the slide design dialog.The slide ma

Page 119

CautionAny changes made to one slide when in Master View mode will appear on all slides using this slide master. Always make sure you close Master Vie

Page 120

• Author—First and last names listed in the OpenOffice.org user data• Page number (slide number)• File nameTipTo change the number format (1,2,3 or a,

Page 121

Figure 152: Selected text box showing the green resizing handles and text toolbarYou can move, resize, and delete text boxes. For more information, se

Page 122

bullet points and so on. There are several ways to ensure consistency; these methods are explained below.Pasting unformatted textIt is normally good p

Page 123

TipPresentation styles are very different from Writer styles and are applied in quite a different way.Creating bulleted and numbered listsThe procedur

Page 124

Parts of the main windowThe main window is similar in each component of OOo, although some details vary. See the chapters in this book about Writer, C

Page 125

4) The default list type is a bulleted list. The mechanisms to change the appearance of the list are explained on page 210.Creating a new outline leve

Page 126

For a single line in the list:1) Click anywhere in the line to place the cursor in it.2) Follow steps 2–4 of the previous instruction set.If the list

Page 127

toolbar offers many of the same buttons as the table toolbar in Writer, with the exception of functions like Sort and Sum for performing calculations.

Page 128

formatting of the spreadsheet, it is necessary to activate it and enter the edit mode. To do so, double-click inside the frame with the green handles.

Page 129

Type or paste your comment into the text box. You can optionally apply some basic formatting to parts of the text by selecting it, right-clicking, and

Page 130

Slide transition choices are also found on the Tasks pane. For more information about slide transitions, see Chapter 9 in the Impress Guide.TipThe Sli

Page 131

Chapter 7 Getting Started with DrawVector Drawing in OpenOffice.orgFree eBook Edition

Page 132

What is Draw?Draw is a vector graphics drawing program. It offers a series of powerful tools that enable you to quickly create all sorts of graphics.

Page 133

Figure 155. Initial Draw windowRulersYou should see rulers (bars with numbers) on the upper and left-hand side of the workspace. These show the size o

Page 134

To modify the units of measurement of the rulers, right-click on one of the rulers (Figure 3). The two rulers can have different units.Status barThe S

Page 135

The top docked toolbar (default position) is called the Standard toolbar. The Standard toolbar is consistent across the OpenOffice.org applications.Th

Page 136

You can also select the icons that you wish to appear on the corresponding toolbar. On the View > Toolbars menu, choose Customize, click on the Too

Page 137

The tools available in the various toolbars are explained in the following sections. The appearance of the toolbar icons may vary with your operating

Page 138

Figure 162. Changing the color paletteTo load another palette, click on the Load Color List button (circled). The file selector dialog asks you to cho

Page 139

Figure 163. Defining color schemesOptions toolbarThe Options toolbar lets you activate or deactivate various drawing aids. The Options toolbar is not

Page 140

Icon FunctionAllow quick editingSelect text area onlyDouble-click to edit textSimple handlesLarge handlesPositioning objects with snap functionsIn Dra

Page 141

Showing the gridMake the grid visible under View > Grid > Display Grid. Alternatively turn the grid on and off with the icon on the Options to

Page 142

• The pixel (pix element) size of the snap area defines how close you need to bring an object to a snap point or line before it will snap to it.Changi

Page 143

The basic drawing shapesDraw provides a wide range of shapes, located in palettes accessed from the Drawing Toolbar. This chapter describes only a few

Page 144

Hold down the Shift key while drawing the line to restrict the angle of the line to a multiple of 45 degrees (0, 45, 90, 135, and so on).Hold down the

Page 145

Figure 170: Lines and Arrows toolbarDrawing a rectangle or squareDrawing rectangles is similar to drawing straight lines, except that you use the Rect

Page 146

Moving toolbarsTo move a docked toolbar, place the mouse pointer over the toolbar handle, hold down the left mouse button, drag the toolbar to the new

Page 147

Figure 172: Drawing an ellipseThere are three other ways to draw an ellipse or circle:• Hold down the Shift key while drawing to force the ellipse to

Page 148

If you move the mouse cursor over one of the icons, a tooltip pops up with a description of the function. For a more detailed description of the handl

Page 149

Text frames can also have fill colors, shadows, and other attributes, just like any other Draw object. You can rotate the frame and write the text at

Page 150

Figure 175 shows two Draw objects and a connector.Figure 175: A connector between two objectsDraw has a range of advanced connector functions. You can

Page 151

Symbol shapesThe Symbol Shapes icon brings you to an array of tools for drawing the various symbol shapes.Block arrowsThe Block Arrows icon opens

Page 152

Selection modesThere are three selection modes: moving and changing size, rotating, and editing points.The default mode for selecting objects depends

Page 153

Selecting objectsDirect selectionTo select an object, the easiest way is to click directly on it. For objects that are not filled, click directly on t

Page 154

When you click on the selected object, its outline appears briefly through the objects on top of the selected object.In the illustration to the right,

Page 155

Dynamic movement of objectsTo move an object, select it and then click within the object’s border and hold down the left mouse button while moving the

Page 156

NoteRotation works in a slightly different way for 3D objects because the rotation occurs in 3D space and not in one plane. See Chapter 7 (Working wit

Page 157

To dock a window or toolbar, do one of the following:• Click on the title bar of the floating window and drag it to the side until you see the outline

Page 158

Editing objectsTo change an object’s attributes (such as color, border width, among others) you can use the Line and Filling toolbar or the context me

Page 159

You can change some properties from the Line and Filling toolbar. To see more options, select the object and click on the Line icon or right-click o

Page 160

Editing the inside (fill) of an objectThe OpenOffice.org term for the inside of an object is Area fill. The area fill of an object can be a uniform co

Page 161

Special effectsWith Draw, you can apply many special effects to objects and groups of objects. This section describes a few of these effects. Others i

Page 162

Distorting an imageThere are three tools on the Effects menu that let you drag the corners and edges of an object to distort the image.The Distort too

Page 163

Cross-fadingCross-fading transforms a shape from one form to another, with OpenOffice.org handling all of the intermediate transitions. The result is

Page 164

Grouping by common selectionWhen several objects are selected, any operations you carry out are applied to all of the objects. For example, you can ro

Page 165

Aids for positioning objectsDraw has various tools to help you arrange the objects with respect to each other:• Moving an object to the front or to th

Page 166

shapes than with 3D bodies, but 3D bodies currently allow for more customizing than 3D shapes.See Chapter 7 (Working with 3D Objects) in the Draw Guid

Page 167

Type or paste your comment into the text box. You can optionally apply some basic formatting to parts of the text by selecting it, right-clicking, and

Page 168

Right-click (context) menusYou can quickly access many menu functions by right-clicking on a paragraph, graphics, or other object. A context menu will

Page 169

Chapter 8 Getting Started with BaseOpenOffice.org’s Database ComponentFree eBook Edition

Page 170

IntroductionA data source, or database, is a collection of pieces of information that can be accessed or managed by OpenOffice.org (OOo). For example,

Page 171

books. There is an obvious relationship between the authors and the books they have written. The library may contain more than one book by the same au

Page 172

What fields fit the maintenance area? Date of service, odometer reading, type of service, cost of service, and next scheduled service of this type (fo

Page 173

On the first page of the Database Wizard, select Create a new database and then click Next.The second page has two questions. Make sure the choice for

Page 174

Creating database tablesIn a database, a table stores information for a group of things we call fields. For example, a table might hold an address boo

Page 175

Step 1: Select fields.We will use the CD-Collection Sample table in the Personal category to select the fields we need.1) Category: Select Personal. T

Page 176

Step 2: Set field types and formats.In this step you give the fields their properties. When you click a field, the information on the right changes. (

Page 177

• NumberofTracks: Change the Field Type to Tiny Integer [TINYINT]. Your allowable number of tracks will be 999. Small Integer [SMALLINT] would allow 9

Page 178

Creating a table by copying an existing tableIf you have a large collection of music, you might want to create a table for each type of music you have

Page 179

Digital signatureIf the document has been digitally signed, an icon shows here. You can double-click the icon to view the certificate.Object informa

Page 180

The first table to be created is Fuel. Its fields are FuelID, Date, FuelCost, FuelQuantity, Odometer, and PaymentType.1) Click Create Table in Design

Page 181

3) All other fields (Date, FuelCost, FuelQuantity, Odometer, and PaymentType):• Type the next field name in the Field Name column.• Select the Field T

Page 182

Figure 188: Field Format options4) To access additional formatting options, click the button to the right of the Format example field.5) Description c

Page 183

Creating tables for the list boxWhen the same information can be used in several fields, design a table for each type of information. Each table will

Page 184

c) Enter Cash in the third row. The PaymentID changes to 2.2) Save and close the table window.TipYou can also use the Enter key to move from entry fie

Page 185

• Double-click the name of the table. In our case, do this for both Vacations and Fuel.• Or, click the name of the table and then click Add for each t

Page 186

5) Modifying the Update options and Delete options section of the Relation window.a) Right-click the line connecting the Date fields in the two table

Page 187

Creating a database formDatabases are used to store data. But, how is the data put into the database? Forms are used to do this. In the language of da

Page 188

Figure 196: Form Wizard stepsStep 2: Set up a subform.Since we have already created a relationship between the Fuel and Vacations tables, we will use

Page 189

5) Click Next.Figure 198: Selecting fields of a subformStep 4: Get joined fields.This step is for tables or queries for which no relationship has been

Page 190

Figure 9: Dialog showing common controls:1=Tabbed page (not strictly speaking a control)2=Radio buttons (only one can be selected at a time)3=Checkbox

Page 191

right are Columnar left, Columnar - Labels on top, As Data Sheet, and In Blocks - Labels Above.1) Arrangement of the main form: Click the second icon

Page 192

1) Provide a dropdown capability for the Date field in the main form, and lengthen the field to show the day of the week, month, day, and year.2) Shor

Page 193

Figure 200: Selecting a field of a control• Moving a group of controls is almost as easy as moving one of them.1) Click the field of the top left cont

Page 194

Figure 202: Form Controls toolbar• Scroll down to the Date format property. This is a dropdown list with Standard (short) as the default setting. Clic

Page 195

Figure 204: Positioning of controls1) Click the first control you want to move. A border appears around the control with eight green handles.2) Move t

Page 196

2) The dialog that opens is labeled Properties: Label Field. It contains all of the properties of the selected label.• In the Label selection, edit th

Page 197

Step 6: Replace fields with other fields.We want to replace the PaymentType field with a List Box. Then we can choose the type of payment from the Pay

Page 198

Figure 207: Type of list contents dropdown list • Type the following exactly as it is in the List contents box:SELECT "Type", "Type&quo

Page 199

Figure 209: Position of controls in main formStep 7: Change the Misc. Notes field.We want the Misc. Notes control, which has a field type of Memo, to

Page 200

Step 8: Change labels and fields in the subform.The subform is located at the bottom of the form. We want to widen the Date column, change the field i

Page 201

• Press Control+N on the keyboard.• Use File > Wizards for some special types of documents.Opening an existing documentWhen no document is open, th

Page 202

Step 9: Add headings to groups.This step is easier to do if you have end-of-paragraph markers visible. Choose View > Nonprinting Characters to turn

Page 203

b) Control+shift+click the rest of the labels of the top row. The border will gradually grow to the right as you do this until all the labels are encl

Page 204

4) To add a graphic to the background:a) Right-click on the background and select Page from the pop-up menu.b) On the Page Style dialog, click the Bac

Page 205

Figure 216: Form Design toolbar with Activation Order icon circled4) Rearrange the order of the fields in the Tab Order window.a) Find the txtMPayment

Page 206

Accessing other data sourcesOpenOffice.org allows data sources to be accessed and then linked into OOo documents. For example, a mail merge links an e

Page 207

Registering *.odb databasesDatabases created by OOo2.x or later are in the *.odb (OpenDocument Base) format. Other programs can also produce databases

Page 208

Editing data sourcesSome data sources can be edited in the View Data Sources dialog. A spreadsheet can not. A record can be edited, added, or deleted.

Page 209

Writer documentsTo insert a field from a table opened in the data source window into a Writer document, click on the field name (the gray square at th

Page 210

• Click another row and then click this icon again. The data in the sentence changes to this selected row of data.• Save the document if you want to u

Page 211

You can also limit the fields you use to less than all of the fields available.• If you want to use all of the fields, use the double arrow pointing t

Page 212

To save an open document with the current file name, choose File > Save. This will overwrite the last saved state of the file.Password protectionTo

Page 213

Adding records to a spreadsheet is fairly easy. You need to have the Data Source window open, your spreadsheet open, and the table you want to use sel

Page 214

The quickest way to enter a date in the Date field is to click the arrow that opens the dropdown calendar. Then click the day the you want (Figure 224

Page 215

NoteSince the Tab key is used to move between fields, it can not be used in a text field. All spacing must be done by the spacebar. Finally, the Enter

Page 216

Figure 225: Sample record of the Vacation form and subformCreating queriesQueries are used to get specific information from a database. Query results

Page 217

NoteWhen working with a query, more than one table can be used. Since different tables may contain the same field names, the format for naming fields

Page 218

Step 2: Select the sorting order.Up to four fields can be used to sort the information of our query. A little simple logic helps at this point. Which

Page 219

1) Since we are only searching for one thing, we will use the default setting of Match all of the following.2) We are looking for a particular artist,

Page 220

1) Click Fuel to highlight it.2) Click Add. Click Close.TipMove the cursor over the bottom edge of the fuel table (Figure229) and drag the to make it

Page 221

Figure 232 contains the Fuel table with my entries and the query results based upon the Fuel table: the query results are in the right table.Figure 23

Page 222

Figure 234: Tables in this query1) Double-click FuelQuantity in the End-Reading query.2) Double-click Odometer in the End-Reading query.3) Double-clic

Page 223

ContentsChapter 1 Introducing OpenOffice.org...10What is OpenOffice.org?...

Page 224

Renaming and deleting filesYou can rename or delete files within the OOo dialogs, just as you can in your usual file manager. However, you cannot copy

Page 225

Figure 237: Field for distance traveled calculations3) Calculate fuel economy (Figure 238):Type ("End-Reading".Odometer – Fuel.Odometer)/&qu

Page 226

Notice that not all of the last column label is visible because some of the labels are long. We can fix this problem by using an alias for many of the

Page 227

NoteTo fully use queries requires a knowledge of set operations (unions, intersections, and, or, complements, and any combinations of these). Having a

Page 228

• How do we want the information arranged?• What fields are required to provide this information?• Will a query have to be created because these field

Page 229

Figure 244: Adding fields to a reportStep 2: Labeling fieldsChange any field labels you wish. We will shorten Miscellaneous to Misc. Click Next.Step 3

Page 230

NoteIf you feel adventurous, try selecting some of the other layout choices. After selecting a choice, drag the Report Wizard window out of the way so

Page 231

4) Create the report.Use >> to move both fields from the Available fields list to the Fields in report list. Click Next.5) Label fields.Add a sp

Page 232

1) Add the FuelCost field to the End-Reading query:a) Right-click the End-Reading query and select Edit from the pop-up menu.b) In the Fuel table list

Page 233

8) Group fields.Use > to move the Date field to the Groupings list. Click Next.9) Sort options: the wizard skipped this one.10) Choose layout: acce

Page 234

Figure 250: Modifying a date fieldb) Since this is a dynamic report, change the Select field from Date (fixed) to Date.c) Change the Format to what yo

Page 235

folders; to go to one of the folders on the list, move the mouse pointer over its name and release the mouse button.• Create New Folder.• Default Dire

Page 236

Figure 252: Option section of the Number Formating window3) Change the Cost per mile field.a) Right-click in the cell below Fuel Cost.b) Select Number

Page 237

More ways to create reportsAn extension is available to assist in report creation. Sun Report Builder creates stylish, complex database reports. You c

Page 238

Chapter 9 Getting Started with MathOpenOffice.org’s Equation EditorFree eBook Edition

Page 239

What is Math?Math is OpenOffice.org (OOo)’s component for writing mathematical equations. It is most commonly used as an equation editor for text docu

Page 240

Entering a formulaThe equation editor uses a markup language to represent formulas. For example, %beta creates the Greek character beta (). This mark

Page 241

The Formula Elements window is divided into two main parts.• The top shows the symbol categories. Click on these to change the list of symbols.• The b

Page 242

The <?> symbols shown in Figure 257 are placeholders that you can replace by other text, for example 5 and 4. The equation will update automatic

Page 243

MarkupYou can type the markup directly in the equation editor. For example, you can type 5 times 4 to obtain 5×4. If you know the markup, this can be

Page 244

NoteA complete table of Greek characters is provided in the Math Objects chapter in the Writer Guide.Another way to enter Greek characters is by using

Page 245

Figure 261. Tooltip indicates the Relations button.Figure 262. After selecting Relations.Step 4: Click on the a≃b symbol. The equation editor now show

Page 246

Click the marker (+ or arrow) by any of the categories to display the list of objects in that category. To hide the list of categories and show only t

Page 247

2) Hold down the Control key and double-click.Figure 264. Hold down the Control key and double-click on the border of the formula editor to turn it in

Page 248

2) Select a larger font size under Base size (top-most entry).Figure 267. Edit Base size (top) to make a formula bigger.The result of this change is i

Page 249

Equations over more than one lineSuppose you want to type an equation covering more than one line. For example:x=3y=1Your first reaction would be to s

Page 250

Brackets with matrices look ugly!For background, we start with an overview of the matrix command.Markup Resultmatrix { a # b ## c # d }a bc dNoteRows

Page 251

Markup Result{df} over {dx}{partial f} over {partial y}{partial^2 f} over {partial t^2}How do I align my equations at the equals sign?OOo Math does no

Page 252

2) In the Spacing dialog (Figure 269), click the Category button and select Matrices in the drop-down menu.3) Enter 0% for Column spacing and click OK

Page 253

Figure 270. Inserting a cross-reference to an equation number 326 Getting Started with OpenOffice.org 3.xFree eBook Edition

Page 254

Chapter 10 Printing, Exporting, and E-mailingFree eBook Edition

Page 255

IntroductionThis chapter provides general information about printing, exporting, and e-mailing documents from OOo.Quick printingClick the Print File D

Page 256

Figure 271. The Print dialogExporting to PDFOpenOffice.org can export documents to PDF (Portable Document Format). This industry-standard file format

Page 257

Undoing and redoing changesTo undo the most recent change, press Control+Z, or click the Undo icon on the Standard toolbar, or choose Edit > Undo

Page 258

General page of PDF Options dialogOn the General page, you can choose which pages to include in the PDF, the type of compression to use for images (wh

Page 259

• JPEG compression: Allows for varying degrees of quality. A setting of 90% works well with photographs (small file size, little perceptible loss of q

Page 260

numbered (right-hand) page. When the previous chapter ends on an odd page, OOo inserts a blank page between the two odd pages. This option controls wh

Page 261

• Display document title. Causes the PDF viewer to display the document’s title in the title bar.Figure 274: User Interface page of PDF Options dialog

Page 262

Convert document references to PDF targetsIf you have defined links to other documents with OpenDocument extensions (such as .ODT, .ODS, and .ODP), th

Page 263

Figure 276: Security page of PDF Options dialogFigure 277: Setting a password to encrypt a PDFChapter 10 Printing, Exporting, and E-mailing 335Free e

Page 264

NotePermissions settings are effective only if the user’s PDF viewer respects the settings.Exporting to other formatsOOo uses the term “export” for so

Page 265

E-mailing a document to several recipientsTo e-mail a document to several recipients, you can use the features in your e-mail program or you can use O

Page 266

3) On the third page, click the Select Address List button. Select the required address list (even if only one is shown) and then click OK. (If the ad

Page 267

5) In the left-hand list, click 8. Save, print or send. OOo displays a “Creating documents” message and then displays the Save, print or send page of

Page 268

Closing a documentTo close a document, choose File > Close.You can also close a document by clicking on the Close icon on the document window. This

Page 269

When someone later opens the document on any computer with a recent version of OpenOffice.org, the program will compute the checksum again and compare

Page 270

Chapter 11 Graphics, the Gallery, and FontworkFree eBook Edition

Page 271

IntroductionYou can add graphic and image files, including photos, drawings, scanned images, and others, to OpenOffice.org documents. OOo can import v

Page 272

Insert Picture dialog1) Click in the OOo document where you want the image to appear.2) Choose Insert > Picture > From File from the menu bar.3)

Page 273

• Advantage – You can modify the image file separately without changing the document because the link to the file remains valid, and the modified imag

Page 274

Figure 284: The Edit Links dialogInserting an image from the clipboardUsing the clipboard, you can copy images into an OOo document from another OOo d

Page 275

Modifying and positioning graphicsOpenOffice.org provides many tools for resizing, modifying, filtering, and positioning graphics; wrapping text aroun

Page 276

Figure 285. Icon view of one theme in the GalleryInserting images into a documentYou can copy or link an object from the Gallery into a document.To in

Page 277

Figure 286. Copying a graphic object from the Gallery into a documentManaging the GalleryThe default themes are locked; no items can be added to or de

Page 278

Method 1 (selecting a file):1) In the theme’s Properties, on the Files page, click the Find Files button. The Select path dialog opens.2) You can ente

Page 279

Chapter 2 Setting up OpenOffice.orgChoosing options to suit the way you workFree eBook Edition

Page 280

Adding a new theme to the GalleryTo add a new theme to the Gallery:1) Click the New Theme button above the list of themes (Figure285).2) In the Proper

Page 281

Creating an image mapAn image map defines areas of an image (called hotspots) with hyperlinks to web addresses, other files on the computer, or parts

Page 282

The main part of the dialog shows the image on which the hotspots are defined. A hotspot is identified by a line indicating its shape.The toolbar at t

Page 283

You can also use the drawing tools to annotate photographs, screen captures, or other illustrations produced by other programs, but this is not recomm

Page 284

5) You can now change the properties (fill color, line type and weight, anchoring, and others) of the drawing object using either the Drawing Object P

Page 285

and drag it to its new position. For a scaled resizing, select one of the corner handles and keep the Shift key pressed while dragging the handle to i

Page 286

• If you click on an existing Fontwork object, the Formatting toolbar changes to display the Fontwork options as shown in Figure 284. The contents of

Page 287

Figure 292. Editing Fontwork text4) Click anywhere in a free space or press Esc to apply your changes.Editing a Fontwork objectNow that the Fontwork o

Page 288

Fontwork Same Letter Heights: Changes the height of characters in the object. Toggles between normal height (some characters taller than others, for e

Page 289

Figure 295. Formatting toolbar for a Fontwork object in WriterThis figure shows the toolbar floating. In its default, docked position it is one of the

Page 290

Choosing options for all of OOoThis section covers some of the settings that apply to all the components of OpenOffice.org. For information on setting

Page 291

• Transparency tab: Set the transparency properties of the selected object.• Colors tab: Modify the available colors or add new ones to appear on the

Page 292

Using menu optionsYou can use some the choices on the Format menu to anchor, align, arrange and group selected Fontwork objects, wrap text around them

Page 293

Hovering the pointer over other parts of the object turns the pointer into the usual symbol for dragging the object to another part of the page.For pr

Page 294

Chapter 12 Creating Web PagesSaving Documents as HTML FilesFree eBook Edition

Page 295

IntroductionThis chapter describes how to do the following in Writer, Calc, Draw and Impress:• Create hyperlinks within a document and to other docume

Page 296

You can also insert hyperlinks using the Navigator and the Hyperlink dialog, and you can modify all hyperlinks using the Hyperlink dialog, as describe

Page 297

You can also use the Navigator to insert a hyperlink from one document (the source) to a specific place in another document (the target). Open the Nav

Page 298

For a Mail and News type hyperlink, specify whether it is a mail or news link, the receiver address and for email, also the subject.For a Document typ

Page 299

activates them, check that page to see if the option has been deselected.To change the color of hyperlinks, go to Tools > Options > OpenOffice.o

Page 300

3) In the dialog (Figure 298), type the file name to save the pages under. Also specify which style indicates a new page (as decided in step 1).4) Cli

Page 301

Figure 18: Filling in user dataGeneral optionsThe options on the OpenOffice.org – General page are described below.Figure 19: Setting general options

Page 302

2) Choose or browse to the document you would like to format. The Title, Summary and Author information is picked up from the document’s properties; i

Page 303

4) Choose the information to be listed and the screen resolution. Click Next.Chapter 12 Creating Web Pages 371Free eBook Edition

Page 304

5) Select a style for the page. Use the drop-down list to choose different styles and color combinations. You can browse to a background image and ico

Page 305

To edit or view the document’s underlying HTML code, click View > HTML Source or click the HTML Source icon on the Main toolbar.Saving Calc sprea

Page 306

1) To begin, select File > Export and choose HTML Document as the file type.2) Create a folder for the files, supply a name for the resulting HTML

Page 307

5) Decide how the images will be saved (PNG, GIF, or JPG) and what resolution to use.When choosing a resolution, consider what the majority of your vi

Page 308

7) Choose the navigation button style to use to move from one page to another. If you do not choose any, OOo will create a text navigator.8) Select th

Page 309

9) Click Create to generate the HTML files. If this is a new design, a small dialog pops up. If you might want to reuse this design, you can give it a

Page 310

Chapter 13 Getting Started with MacrosUsing the Macro RecorderFree eBook Edition

Page 311

Your first macroA macro is a saved sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that “types”

Page 312

Help AgentTo turn off the Help Agent (similar to Microsoft’s Office Assistant), deselect this option. To restore the default behavior, click Reset Hel

Page 313

Figure 300: OOo Macro Organizer dialog, DBInspection library selected5) The default module name is Module1; choose a better name. Although it is still

Page 314

Figure 302: Select your macro and click RunThere are other methods to run a macro. For example, use Tools > Macros > Organize Macros > OpenOf

Page 315

dispatcher = createUnoService("com.sun.star.frame.DispatchHelper")rem -------------------------------------------------------------dim args1

Page 316

• Another kind of subroutine is called a function. A function is a subroutine that returns a value. The keyword FUNCTION is used rather than SUB to de

Page 317

CreateUnoService accepts the name of a service and it tries to create an instance of that service. On completion, the dispatcher variable contains a r

Page 318

first column indicates the constant name. Each name is followed by a space and a tab.DONTKNOW The font weight is not specified/known.THIN specifies

Page 319

10) Press Backspace twice to remove the two trailing spaces.11) Press Home to move the cursor to the start of the line.12) Press Ctrl+V to paste the s

Page 320

dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args6())rem (6) Press Ctrl+Right Arrow twice to move the cursor to

Page 321

Cursor movements are used for all operations (as opposed to searching). If run on the DONTKNOW line, the word weight is moved to the front of the line

Page 322

The dispatch framework can also be used to send “commands” back to the UI (User Interface). For example, after saving the document, the File Save comm

Page 323

Memory optionsIn the Options dialog, click OpenOffice.org > Memory. Some considerations:• More memory can make OpenOffice.org faster and more conve

Page 324

as you learn more. Learning to read generated macros is a good place to start.If you record Calc macros, and the recorder can correctly generate a mac

Page 325

• A library container contains one or more libraries, and each library is contained in one library container.• A library contains zero or more modules

Page 326

Macros container. The My Macros container is stored in your user area or home directory.If a macro is contained in a document, then a recorded macro w

Page 327

example, on one or more of my OpenOffice.org upgrades, all of my macros disappeared. Although the macros were still on disk, the macros were not copie

Page 328

Figure 307: Select a macro library to importNavigate to the directory containing the library to import. There are usually two files from which to choo

Page 329

Downloading macros to importMacros are available for download. Some macros are contained in documents, some as regular files that you must select and

Page 330

Figure 309: Use the Macro Selector dialog to run macrosThe answers will determine where to store the macro and how to make it available. For example,

Page 331

Figure 310: OpenOffice.org Customize dialogToolbarMacros can be added to toolbars. For more about modifying toolbars, see Chapter 14 (Customizing Open

Page 332

EventIn OpenOffice.org, when something happens, we say that an event occurred. For example, a document was opened, a key was pressed, or the mouse mov

Page 333

A common use is to assign the Open Document event to call a specific macro. The macro then performs certain setup tasks for the document. Select the d

Page 334

What are styles?... 63Applying styles...

Page 335

User Interface – ScalingIf the text in the help files or on the menus of the OOo user interface is too small or too large, you can change it by specif

Page 336

ExtensionsAn extension is a package that can be installed into OpenOffice.org to add new functionality. Extensions can be written in almost any progra

Page 337

MsgBox "This macro only works with a text document" Exit Sub End If REM Get the view cursor from the current controller. oCurs =

Page 338

http://www.pitonyak.org/oo.php (Andrew Pitonyak’s macro page)http://www.pitonyak.org/AndrewMacro.odt (numerous examples of working macros)http://www.p

Page 339

Chapter 14 Customizing OpenOffice.orgFree eBook Edition

Page 340

IntroductionThis Appendix describes some common customizations that you may wish to do.You can customize menus, toolbars, and keyboard shortcuts in Op

Page 341

Figure 314: The Menus page of the Customize dialogCreating a new menuIn the Customize dialog, click New to display the dialog shown in Figure 315.1) T

Page 342

Figure 315: Adding a new menuModifying existing menusTo modify an existing menu, select it in the Menu list and click the Menu button to drop down a l

Page 343

3) Add a tilde (~) in front of the letter that you want to use as an accelerator. For example, to select the Save All command by pressing Alt+V, enter

Page 344

Menu Content. Click the Modify button and choose the required action from the drop-down list of actions.Most of the actions should be self-explanatory

Page 345

To customize toolbars:1) In the Save In drop-down list, choose whether to save this changed toolbar for the application (for example, Writer) or for a

Page 346

Font Lists - Show preview of fontsCauses the font list to look like Figure 22, Left, with the font names shown as an example of the font; with the opt

Page 347

2) The Add Commands dialog is the same as for adding commands to menus (Figure 316). Select a category and then the command, and click Add. The dialog

Page 348

Example: Adding a Fax icon to a toolbarYou can customize OpenOffice.org so that a single click on an icon automatically sends the current document as

Page 349

Figure 320: Adding a Send Fax command to a toolbarAssigning shortcut keysIn addition to using the built-in keyboard shortcuts (listed in Appendix A),

Page 350

NoteAll existing shortcut keys for the currently selected Function are listed in the Keys selection box. If the Keys list is empty, it indicates that

Page 351

2) To have the shortcut key assignment available only with one component (for example, Writer), select that component’s name in the upper right corner

Page 352

select the configuration file from the Load Keyboard Configuration dialog.Resetting the shortcut keysTo reset all of the keyboard shortcuts to their d

Page 353

4) When the installation is complete, the extension is listed in the Extension Manager dialog.TipTo get extensions that are listed in the repository,

Page 354

When the extension is installed, PDF is listed as a choice in the File Type drop-down list in the File > Open dialog. Best results can be achieved

Page 355

send them as email attachments. From Sun Microsystems. Open source.Professional Template Pack IIProvides more than 120 templates for Writer, Calc, and

Page 356

Appendix A Keyboard ShortcutsFree eBook Edition

Page 357

keyboard shortcuts. Clipboard and “Selection clipboard” can contain different contents at the same time.Function Clipboard Selection clipboardCopy con

Page 358

IntroductionYou can use OpenOffice.org (OOo) without requiring a pointing device, such as a mouse or trackball, by using its built-in keyboard shortcu

Page 359

change the activated option field in that area. Press the Tab key to go from one element or area to the next one, or press Shift+Tab to go in the reve

Page 360

General shortcut keys for OpenOffice.orgShortcut Keys ResultEnter Activates the focused button in a dialog.EscTerminates the action or dialog. If in O

Page 361

Shortcut Keys ResultCtrl+V Pastes from the clipboard.Ctrl+Shift+V Opens the Paste Special dialog.Ctrl+A Selects all.Ctrl+Z Undoes last action.Ctrl+Y R

Page 362

Appendix B Background InformationHistory, licensing, and file formatsFree eBook Edition

Page 363

IntroductionOpenOffice.org is both a product and an open-source project. If you are new to OOo, its open source development, and the community that pr

Page 364

on the wrong side of the digital divide. For tens of thousands of community members, this makes the OpenOffice.org community their volunteering opport

Page 365

For more information on Free and Open Source software, visit these websites:Open Source Initiative (OSI): http://www.opensource.orgFree Software Found

Page 366

Microsoft Word 6.0/95/97/2000/XP) (.doc and .dot)Microsoft Word 2003 XML (.xml)Microsoft Word 2007 XML (.docx, .docm, .dotx, .dotm)Microsoft WinWord 5

Page 367

Opening presentationsIn addition to OpenDocument formats (.odp, .odg, and .otp), Impress 3 can open the formats used by OOo 1.x (.sxi and .sti) and th

Page 368

TipIf your printouts are incorrectly placed on the page or chopped off at the top, bottom, or sides, or the printer is refusing to print, the most lik

Page 369

TipWhen sharing a document that you do not expect or want the recipient to modify, the safest option is to convert the document to PDF. OOo provides a

Page 370

dBase (.dbf)SYLK (.slk)Text CSV (.csv and .txt)StarCalc 3.0, 4.0, and 5.0 formats (.sdc and .vor)Unified Office Format spreadsheet (.uos)HTML Document

Page 371

Exporting to other formatsOOo uses the term “export” for some file operations involving a change of file type. If you cannot find what you want under

Page 372

Who owns the software? The copyright is shared by Sun Microsystems and all the volunteers who have contributed.Does that mean that they can take away

Page 373

IndexA accepting or rejecting changes 127accessibility features 420accessibility options 49advantages of OpenOffice.org 13antialiasing screen fon

Page 374

primary key 255, 258, 260registering 285Report Wizard 303Table Wizard 255tables 255database form activation order 282background 280creating in

Page 375

markup 317matrix markup 323right-click menu 316event handling 398export directly as PDF 329export HTML 56exporting to PDF 329extended tips 37e

Page 376

H handouts (Impress) 192header different on right and left pages 85Help Agent 38Help system 15Help Tips 37hidden objects 236high contrast 38h

Page 377

editing 381event handling 398example 384functions 390IDE 381, 388library container 379library containers 390menu items 396module 379modules

Page 378

page margins 113, 218parts of the main window 21password protection 29password-protect PDF 334pasting unformatted text 208path options 43PDF bl

Page 379

Color optionsOn the OpenOffice.org – Colors page (Figure 25), you can specify colors to use in OOo documents. You can select a color from a color tabl

Page 380

S save as web page 368save AutoRecovery information 53save original Basic code 54save relative URLs 53saving files 28scaling factor (user inter

Page 381

create from document 75create using wizard 76deleting 83description 63editing 77exporting 84Extension Manager 78folders 82update document styl

Page 382

442 Getting Started with OpenOffice.org 3.xFree eBook Edition

Page 383

Modify the color components as required and click OK to exit the dialog. The newly defined color now appears in the lower of the color preview boxes s

Page 384

2) Select or type the name of the font to be replaced in the Font box. (If you do not have this font on your system, it will not appear in the drop-do

Page 385

OpenDocument format, or has been saved to other formats, including PDF.Click the Options button to open a separate dialog with specific choices (Figur

Page 386

Figure 29: Security options and warnings dialogRemove personal information on savingSelect this option to always remove user data from the file proper

Page 387

Figure 30: Showing or hiding text, object, and table boundaries• To show or hide items such as text boundaries, select or deselect the options next to

Page 388

Linking to another part of a document...127Using mail merge...

Page 389

Figure 31: Choosing accessibility optionsJava optionsIf you install or update a Java Runtime Environment (JRE) after you install OpenOffice.org, or if

Page 390

If OOo finds one or more JREs, it will display them there. You can then select the Use a Java runtime environment option and (if necessary) choose one

Page 391

Choosing options for loading and saving documentsYou can set the Load/Save options to suit the way you work.If the Options dialog is not already open,

Page 392

overruled by the user-specific settings of the person who opens it. If you deselect this option, the user’s personal settings do not overrule the sett

Page 393

Size optimization for ODF format. OpenOffice.org documents are XML files. When you select this option, OOo writes the XML data without indents and lin

Page 394

Microsoft Office Load/Save optionsOn the Load/Save – Microsoft Office page (Figure 37), you can choose what to do when importing and exporting Microso

Page 395

Figure 38. Choosing HTML compatibility optionsImport - Use 'English (USA)' locale for numbersWhen importing numbers from an HTML page, the d

Page 396

create the OpenOffice.org Basic macro; otherwise the script will not be inserted. OpenOffice.org Basic macros must be located in the header of the HTM

Page 397

Change locale and language settingsYou can change some details of the locale and language settings that OOo uses for all documents, or for specific do

Page 398

Figure 41: Extra pages available when enhanced language support options are selectedChoose spelling optionsTo choose the options for checking spelling

Page 399

Chapter 6 Getting Started with Impress...182What is Impress?...

Page 400

Here you can also check which user-defined (custom) dictionaries are active by default, and add or remove dictionaries, by clicking the New or Delete

Page 401

Controlling OOo’s AutoCorrect functionsSome people find some or all of the items in OOo’s AutoCorrect function annoying because they change what you t

Page 402

Chapter 3 Using Styles and TemplatesFree eBook Edition

Page 403

What is a template?A template is a model that you use to create other documents. For example, you can create a template for business reports that has

Page 404

In addition, styles are used by OpenOffice.org for many processes, even if you are not aware of them. For example, Writer relies on heading styles (or

Page 405

Table 1. Styles available in OOo componentsStyle Type Writer Calc Draw ImpressPage X XParagraph XCharacter XFrame XNumbering XCell XPresentation X XGr

Page 406

Figure 45: The Styles and Formatting window for Writer, showing paragraph styles.Using Fill Format modeUse Fill Format to apply a style to many differ

Page 407

You can open this list and click once on the style you want, or you can use the up and down arrow keys to move through the list and then press Enter t

Page 408

Changing a style using the Style dialogTo change an existing style using the Style dialog, right-click on the required style in the Styles and Formatt

Page 409

TipIf you are in the habit of manually overriding styles in your document, be sure that AutoUpdate is not enabled.Updating styles from a document or t

Page 410

Working with 3D objects...247Exporting graphics...

Page 411

4) In the Create Style dialog, type a name for the new style. The list shows the names of existing custom styles of the selected type. Click OK to sav

Page 412

Using the Template Management dialogTo copy or move styles using the Template Management dialog:1) Click File > Templates > Organize.2) In the T

Page 413

Figure 50: Copying a style from one document to another.Loading styles from a template or documentYou can copy styles by loading them from a template

Page 414

NoteTo copy the styles from another document, click the From File button to open a window from which you can select the required document.CautionIf yo

Page 415

4) Select the template that you want to use. You can preview the selected template or view the template’s properties:• To preview the template, click

Page 416

Creating a template from a documentTo create a template from a document:1) Open a new or existing document of the type you want to make into a templat

Page 417

• Format and settings regarding indexes, tables, bibliographies, table of contentsTemplates can also contain predefined text, saving you from having t

Page 418

templates directory, but you can choose a different location if you prefer.4) Finally, you have the option of creating a new document from your templa

Page 419

Caution If you choose No in the message box shown in Figure 54, that message will not appear again the next time you open the document after changing

Page 420

To install an extension, follow these steps:1) Download an extension package and save it anywhere on your computer.2) In OOo, select Tools > Extens

Page 421

Chapter 11 Graphics, the Gallery, and Fontwork...341Introduction...

Page 422

Setting a custom template as the defaultYou can set any template to be the default, as long as it is in one of the folders displayed in the Template M

Page 423

template from which the styles were loaded—so you cannot use this method. What you need to do is associate the document with the different template.Yo

Page 424

Organizing templatesOOo can only use templates that are in OOo template folders. You can create new OOo template folders and use them to organize your

Page 425

Moving a templateTo move a template from one template folder to another template folder:1) In the Template Management dialog, double-click the folder

Page 426

Exporting a templateTo export a template from a template folder to another location:1) In the Template Management dialog, double-click the folder that

Page 427

Dividing a document into chaptersIn a similar way, you can divide a document into chapters. Each chapter might start with the First Page style, with t

Page 428

Compiling an automatic table of contentsTo compile an automatic table of contents, first apply styles to the headings you want to appear in the conten

Page 429

Chapter 4 Getting Started with WriterWord Processing with OpenOffice.orgFree eBook Edition

Page 430

What is Writer?Writer is the word processor component of OpenOffice.org (OOo). In addition to the usual features of a word processor (spelling check,

Page 431

Status barThe Writer status bar provides information about the document and convenient ways to quickly change some document features.Figure 60: Left e

Page 432

Customizing toolbars...408Assigning shortcut keys...

Page 433

selecting text. See “Working with text” on page 94 for more information about ADD and BLK.Unsaved changesAn asterisk (*) appears here if changes to th

Page 434

ZoomTo change the view magnification, drag the Zoom slider, or click on the + and – signs, or right-click on the zoom level percent to pop up a list o

Page 435

Moving quickly through a documentIn addition to the navigation features of the Status bar (described above), you can use the main Navigator window and

Page 436

Working with documentsChapter 1 (Introducing OpenOffice.org) includes instructions on starting new documents, opening existing documents, and saving d

Page 437

Figure 66. Saving a file in Microsoft Word formatWorking with textWorking with text (selecting, copying, pasting, moving) in Writer is similar to work

Page 438

Figure 67: Selecting items that are not next to each otherTo select nonconsecutive items using the keyboard:1) Select the first piece of text. (For mo

Page 439

Figure 68: Selecting a vertical block of textCutting, copying, and pasting textCutting and copying text in Writer is similar to cutting and copying te

Page 440

Finding and replacing text and formattingWriter has a Find and Replace feature that automates the process of searching for text inside a document. In

Page 441

TipIf you click Find All, OOo selects all instances of the search text in the document. Similarly, if you click Replace All, OOo will replace all matc

Page 442

Inserting dashes and non-breaking spaces and hyphensTo prevent two words from being separated at the end of a line, press Control+spacebar after the f

Commentaires sur ces manuels

Pas de commentaire