OpenOffice.org OpenOffice - 3.2 Guía de inicio rápido

Busca en linea o descarga Guía de inicio rápido para Software De Gráficos OpenOffice.org OpenOffice - 3.2. OpenOffice.org OpenOffice - 3.2 Getting Started Guide Manual de usuario

  • Descarga
  • Añadir a mis manuales
  • Imprimir
  • Pagina
    / 442
  • Tabla de contenidos
  • MARCADORES
  • Valorado. / 5. Basado en revisión del cliente
Vista de pagina 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
Vista de pagina 0
1 2 3 4 5 6 ... 441 442

Indice de contenidos

Pagina 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

Pagina 2

Chapter 1 Introducing OpenOffice.orgFree eBook Edition

Pagina 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

Pagina 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

Pagina 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

Pagina 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,

Pagina 7

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 21

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

Pagina 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

Pagina 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

Pagina 24

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

Pagina 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

Pagina 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

Pagina 27

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 38

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 46

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

Pagina 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

Pagina 48

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

Pagina 49

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

Pagina 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

Pagina 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

Pagina 52

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 57

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

Pagina 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

Pagina 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

Pagina 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

Pagina 61

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 67

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

Pagina 68

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

Pagina 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

Pagina 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

Pagina 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

Pagina 72

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

Pagina 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

Pagina 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

Pagina 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

Pagina 76

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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,

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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,

Pagina 93

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

Pagina 94

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

Pagina 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

Pagina 96

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

Pagina 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

Pagina 98

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

Pagina 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

Pagina 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

Pagina 101

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 106

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

Pagina 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

Pagina 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

Pagina 109

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

Pagina 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

Pagina 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

Pagina 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

Pagina 113

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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,

Pagina 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

Pagina 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

Pagina 123

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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.

Pagina 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.

Pagina 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

Pagina 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

Pagina 131

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

Pagina 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.

Pagina 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

Pagina 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

Pagina 135

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

Pagina 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

Pagina 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

Pagina 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

Pagina 139

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

Pagina 140

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 145

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 152

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

Pagina 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

Pagina 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,

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 163

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 169

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

Pagina 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,

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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. (

Pagina 177

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 207

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

Pagina 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.

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 216

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

Pagina 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

Pagina 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

Pagina 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,

Pagina 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

Pagina 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

Pagina 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

Pagina 223

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

Pagina 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

Pagina 225

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

Pagina 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

Pagina 227

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 237

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

Pagina 238

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

Pagina 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

Pagina 240

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 253

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

Pagina 254

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

Pagina 255

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

Pagina 256

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 262

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 270

Chapter 11 Graphics, the Gallery, and FontworkFree eBook Edition

Pagina 271

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

Pagina 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)

Pagina 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

Pagina 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

Pagina 275

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

Pagina 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

Pagina 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

Pagina 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

Pagina 279

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 288

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 294

Chapter 12 Creating Web PagesSaving Documents as HTML FilesFree eBook Edition

Pagina 295

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 301

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

Pagina 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

Pagina 303

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 310

Chapter 13 Getting Started with MacrosUsing the Macro RecorderFree eBook Edition

Pagina 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”

Pagina 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

Pagina 313

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

Pagina 314

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

Pagina 315

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 320

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

Pagina 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

Pagina 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

Pagina 323

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 329

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

Pagina 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,

Pagina 331

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

Pagina 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

Pagina 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

Pagina 334

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

Pagina 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

Pagina 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

Pagina 337

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

Pagina 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

Pagina 339

Chapter 14 Customizing OpenOffice.orgFree eBook Edition

Pagina 340

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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),

Pagina 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

Pagina 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

Pagina 352

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

Pagina 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,

Pagina 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

Pagina 355

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

Pagina 356

Appendix A Keyboard ShortcutsFree eBook Edition

Pagina 357

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

Pagina 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

Pagina 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

Pagina 360

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

Pagina 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

Pagina 362

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

Pagina 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

Pagina 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

Pagina 365

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 373

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

Pagina 374

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

Pagina 375

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

Pagina 376

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

Pagina 377

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

Pagina 378

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

Pagina 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

Pagina 380

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

Pagina 381

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

Pagina 382

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

Pagina 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

Pagina 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

Pagina 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

Pagina 386

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

Pagina 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

Pagina 388

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

Pagina 389

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

Pagina 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

Pagina 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,

Pagina 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

Pagina 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

Pagina 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

Pagina 395

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

Pagina 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

Pagina 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

Pagina 398

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

Pagina 399

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

Pagina 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

Pagina 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

Pagina 402

Chapter 3 Using Styles and TemplatesFree eBook Edition

Pagina 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

Pagina 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

Pagina 405

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 410

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

Pagina 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

Pagina 412

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 417

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

Pagina 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

Pagina 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

Pagina 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

Pagina 421

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 429

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

Pagina 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,

Pagina 431

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

Pagina 432

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

Pagina 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

Pagina 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

Pagina 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

Pagina 436

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

Pagina 437

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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Pagina 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

Comentarios a estos manuales

Sin comentarios