OpenOffice.org OpenOffice - 3.3 Guia de Início Rápido

Getting StartedwithOpenOffice.org 3.3

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

You can customize an existing table of contents at any time. Right-click anywhere in it and choose Edit Index/Table from the pop-up menu. Chapter 12 (

Tracking changes to a documentYou can use several methods to keep track of changes made to a document.1) Make your changes to a copy of the document (

• When using a hyperlink, you do not have a choice of the content of the link (for example text or page number), but when using a cross-reference, you

numbers. The Cross-references tab of the Fields dialog lists some items, such as headings, bookmarks, figures, tables, and numbered items such as step

Figure 87: Inserting a bookmarkUsing master documentsMaster documents are typically used for producing long documents such as a book, a thesis, or a l

Chapter 5 Getting Started with CalcUsing Spreadsheets in OpenOffice.org105

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

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

Figure 89. Apply Style, Font Name and Font Size lists Formula barOn the left hand side of the Formula bar is a small text box, called the Name Box, wi

Individual cellsThe main section of the screen displays the cells in the form of a grid, with each cell being at the intersection of a column and a ro

own connection points. You can use Draw to create drawings for use in any of OOo’s other components, and you can create your own clip art and add it t

to separate the cells. Text is entered in quotation marks, numbers are entered without quotation marks.Opening a CSV fileTo open a CSV file in Calc:1)

Saving as a CSV fileTo save a spreadsheet as a comma separate value (CSV) file:1) Choose File > Save As.2) In the File name box, type a name for th

cell you want to go to and press Enter. Or just click into the Name box, backspace over the existing cell reference and type in the cell reference you

focus to the new cell. This method is most useful when the two cells are a large distance apart. Figure 96. (Left) One selected cell and (right) a g

Figure 97: Customizing the effect of the Enter keyMoving from sheet to sheetEach sheet in a spreadsheet is independent of the others, though they can

NoteThe sheet tab arrows that appear in Figure 98 only appear if you have some sheet tabs that can not be seen. Otherwise, they will appear faded as i

Selecting columns and rowsEntire columns and rows can be selected very quickly in OOo.Single column or rowTo select a single column, click on the colu

Multiple non contiguous sheetsTo select multiple non contiguous sheets:1) Click on the sheet tab for the first sheet.2) Move the mouse pointer over th

Deleting columns and rowsColumns and rows can be deleted individually or in groups.Single column or rowA single column or row can only be deleted by u

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

– You do not need to know which application was used to create a particular file. For example, you can open a Draw file from Writer.• Granularity. Usu

Viewing CalcUsing zoomUse the zoom function to change the view to show more or fewer cells in the window. For more about zoom, see Chapter 1 (Introduc

Two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Now as you scroll around the screen, e

Figure 105. Split screen bar on vertical scroll bar with cursor3) Hold down the left mouse button. A gray line appears, running across the page. Drag

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

Entering numbers as textA number can be entered as text to preserve a leading zero by entering an apostrophe before the number, like this: '0148

Using the Fill tool on cellsAt its simplest, the Fill tool is a way to duplicate existing content. Start by selecting the cell to copy, then drag the

Figure 110: Specifying the start of a fill series (result is in Figure 109)You can also use Edit > Fill > Series to create a one-time fill serie

Figure 112: Defining a new fill seriesUsing selection listsSelection lists are available only for text, and are limited to using only text that has al

Depending on how validation is set up, the tool can also define the range of contents that can be entered and provide help messages that explain the c

Changing part of the data in a cellSometimes it is necessary to change the contents of cell without removing all of the contents, for example if the p

connected with, nor endorsed by, OpenOffice.org. http://distribution.openoffice.org/cdrom/sellers.htmlHow to install the softwareInformation on instal

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

Shrinking text to fit the cellThe font size of the data in a cell can automatically adjust to fit in a cell. To do this, select the Shrink to fit cell

Formatting the fontTo quickly choose the font used in a cell, select the cell, then click the arrow next to the Font Name box on the Formatting toolba

Autoformatting cells and sheetsYou can use the AutoFormat feature to quickly apply a set of cell formats to a sheet or a selected cell range.1) Select

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

Figure 121: Hiding or showing cellsOutline group controlsIf you are continually hiding and showing the same cells, you can simplify the process by cre

Filtering which cells are visibleA filter is a list of conditions that each entry has to meet in order to be displayed. You can set three types of fil

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

Removing a print rangeIt may become necessary to remove a defined print range, for example if the whole sheet needs to be printed later.Choose Format

Top to bottom, then rightLeft to right, then downDetailsYou can specify which details to print. These details include:• Row and column headers• Sheet

Free OpenOffice.org supportDocumentation ProjectTemplates, user guides, how-tos, and other documentation. http://documentation.openoffice.org/See also

For example, if the top two rows of the sheet as well as column A need to be printed on all pages, do the following:1) Choose Format > Print Ranges

TipTo see page break lines more easily on screen, you can change their color. Choose Tools > Options > OpenOffice.org > Appearance and scroll

HeightHeight affects how big the header or footer will be.Figure 125: Header dialogHeader or footer appearanceTo change the appearance of the header o

Setting the contents of the header or footerThe header or footer of a Calc spreadsheet has three columns for text. Each column can have different cont

Chapter 6 Getting Started with ImpressPresentations in OpenOffice.org144

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

Figure 128: Main window of Impress; oval indicates the Hide/Show markersTipYou can remove the Slides pane or Tasks pane from view by clicking the X in

It is also possible to perform the following operations, although there are more efficient methods than using the Slides pane:• Change the slide trans

ToolbarsMany toolbars can be used during slide creation; they can be displayed or hidden by clicking View > Toolbars and selecting from the menu.Yo

Workspace viewsEach of the workspace views is designed to ease the completion of certain tasks; it is therefore useful to familiarize yourself with th

Note for Windows usersIf you have associated Microsoft Office file types with OOo, then when you double-click on a *.doc (Word) file, it opens in Writ

• Double-click the slide’s name in the Navigator.3) In the text box below the slide, click on the words Click to add notes and begin typing.You can re

Use this dialog to select the elements you want to appear on each handout page and their contents. More details on how to use this dialog are provided

Customizing Slide Sorter viewTo change the number of slides per row:1) Check View > Toolbars > Slide View to make the Slide View toolbar visible

– For more than one slide, select the group of slides and add the desired transition.• Mark a slide as hidden. Hidden slides will not be shown in the

• Open existing presentation continues work on a previously created presentation. The wizard changes to show a list of existing presentations. Choose

NoteThe Screen page is optimized for a 4:3 display (28cm x 21cm) so it is not suitable for modern widescreen displays. You can change the slide size a

Formatting a presentationA new presentation contains only one empty slide. In this section we will start adding new slides and preparing them for the

The Title Slide (which also contains a section for a subtitle) or Title Only are suitable layouts for the first slide, while for most of the slides yo

Modifying the slide elementsAt present each slide will contain only the elements that are present in the slide master you are using such as background

Modifying the slide showBy default the slide show will display all the slides in the same order as they appear in the slide sorter, without any transi

Disabling the QuickstarterTo close the Quickstarter, right-click on the icon in the system tray, and then click Exit Quickstarter on the pop-up menu.

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

Pasting unformatted textIt is normally good practice to paste text without formatting and apply the formatting later. To paste without formatting, eit

Creating lists in AutoLayout text boxesEvery text box included in the available layouts is already formatted as a bulleted list, therefore to create a

For the entire list:1) Select the entire list or click on the gray border of the text box so that the green resizing handles are displayed.2) Select F

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

and total row as well as the first and last columns of the table, and apply a banded appearance to the rows and columns.Having completed the table des

Working with slide masters and stylesA slide master is a slide that is used as the starting point for other slides. It is similar to a page style in W

Figure 146: Available master pages (slides)Creating a slide masterCreating a new slide master is similar to modifying the default slide master.To star

Loading additional slide mastersSometimes, in the same set of slides, you may need to mix multiple slide masters that may belong to different template

TipTo limit the size of the presentation file, you may want to minimize the number of slide masters used.Modifying a slide masterThe following items c

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

The Impress slide master comes with three pre-configured areas for date, footer and page number.Select Insert > Page Number or Insert > Date and

TipTo change the author information, go to Tools > Options > OpenOffice.org > User Data.Adding comments to a presentationStarting with OOo 3.

Setting up the slide showAs mentioned in “Modifying the slide show” on page 159, Impress allocates reasonable default settings for slide shows, while

Running the slide showTo run the slide show, do one of the following:• Click Slide Show > Slide Show.• Click the Slide Show button on the Presentat

Chapter 7 Getting Started with DrawVector Drawing in OpenOffice.org174

What is Draw?Draw is a vector graphics drawing program, although it can also perform some operations on raster graphics (pixels). Using Draw, you can

Figure 150. Initial Draw windowRulersYou should see rulers (bars with numbers) on the upper and left-hand side of the workspace. The rulers show the s

Status barThe Status bar is located at the bottom of the screen (in all OOo components); it includes several Draw-specific fields.For details on the c

Text Formatting toolbarIf the selected object is text, the toolbar changes to the Text Formatting toolbar, which is similar to the Formatting toolbar

Figure 156. Changing the color paletteClick on the Edit button to open the Color dialog, where you can set individual colors. See “Color options” in C

• File contains commands that apply to the entire document such as Open, Save, and Export as PDF.• Edit contains commands for editing the document suc

Figure 157: Exact positioning with snap to gridShowing the gridTo make the grid visible, choose View > Grid > Display Grid. Alternatively, turn

• The resolution is the size of the squares or rectangles in the grid. If the resolution is Horizontal 1 cm, Vertical 2 cm, the grid consists of recta

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

To change line attributes (for example, the color or line type), select the line by clicking on it, then use the tools in the Line and Filling toolbar

Hold down the Shift key to draw a square. Hold down the Alt key to draw a rectangle starting from its center. To combine the effects, hold down both t

1 Curve, filled 4 Freeform line, Filled 7 Polygon (45°)2 Polygon, filled 5 Curve 8 Freeform line3 Polygon (45°), filled 6 PolygonFigure 165: Curves to

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

Figure 167 shows two Draw objects and a connector.Figure 167: A connector between two objectsDraw offers a range of different connectors and connector

Symbol shapesThe Symbol Shapes icon provides an array of tools for drawing the various symbols.Block arrowsThe Block Arrows icon opens the Block A

Selection modesThere are three selection modes: moving and changing size, editing, and rotating points.To set the default mode (either moving and chan

Figure 2: Example of a tear-off toolbarMoving toolbarsTo move a docked toolbar, place the mouse pointer over the toolbar handle (the small vertical ba

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

These options are also available from the Arrange tear-off toolbar from the button on the Drawing toolbar. A keyboard shortcut is Shift+Ctrl+plus si

RotationRotating an object lets you move the object around an axis. To do this dynamically (with the mouse), use the red handles, as you do when chang

Editing objectsTo change an object’s attributes (such as color and border width) you can use the Line and Filling toolbar or the context menu.If the L

Figure 171: The vertical lines have different levels of transparency (0%, 25%, and 50%).Drawing arrowsArrowheads (and other line endings—usually refer

Adding a shadowIn Draw, shadows are considered as an area property. Click on the Shadow icon on the Line and Filling toolbar.You can customize the p

Mirror copiesMove the axis of symmetry to the desired location of the mirror axis. Copy the object to the clipboard. Flip the object, then click on an

Figure 172: Duplicating an objectCross-fadingCross-fading transforms a shape from one form to another. The result is a new group of objects including

Combining multiple objectsUsing Draw, you can combine drawing objects together in two distinct ways: grouping and combining. These two methods allow y

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

CopyrightThis document is Copyright © 2005–2010 by its contributors as listed below. You may distribute it and/or modify it under the terms of either

Docking/floating windows and toolbarsToolbars and some windows, such as the Navigator and the Styles and Formatting window, are dockable. You can move

Adding comments to a drawingStarting with OOo 3.2, Draw supports comments (formerly called notes) similar to those in Writer and Calc. Choose Insert &

Chapter 8 Getting Started with BaseOpenOffice.org’s Database Component201

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

a database are the elements. The tables are subsets. Relationships are defined in terms of unions and intersections of the subsets (tables).To explain

TipWhile we have listed fields we will create in the tables of the database, there is one more field that may be needed in a table: the field for the

Caution As you create a database, you should save your work regularly. This means more than just saving what you have just created. You must save the

3) Selected fields: Using the > button, move the following fields from the Available fields window to the Selected fields window in this order: Col

Figure 177: Changing field typesNoteIf any of these fields requires an entry, set Entry required to Yes. An entry with that field blank will then not

NoteEach field has a Field Type, which must be specified. Types include text, integer, date, and decimal. If the field is going to have general inform

needed. (See Caution below for the reason why.) Click Create. The new table is created.Caution Once tables have been created using the wizard and data

Status barThe status bar is located at the bottom of the workspace. It provides information about the document and convenient ways to quickly change s

Figure 178: Defining the primary key fieldNoteThe primary key serves only one purpose: to uniquely identify the record. Any name can be used for this

Figure 179: Changing field propertiesFigure 180: Field Format options4) To access additional formatting options, click the button to the right of the

Figure 181: Fields in Vacations tableCreating tables for the list boxWhen the same information can be used in several fields, design a table for each

Adding data to the list tableList tables do not require a form. Instead, add their data directly to the table. In this example, use the names of the t

• 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

e) Click OK to close the Relations dialog and choose File > Save to save the Relation Design window.While these options are not strictly necessary,

Step 1: Select fields.1) Under Tables or queries, select Table: Vacations. Available fields lists the fields for the Vacations table.2) Click the righ

Step 3: Add subform fields.This step is exactly the same as step 1. The only difference is that not all of the fields will be used in the subform.1) F

Step 5: Arrange controls.Each control in a form consists of two parts: label and field. This step in creating the form determines where a control’s la

4) Change the wording of some of the labels. Some single words should be two words. Some abbreviations should be used if possible (Misc. for miscellan

What are all these things called?The terms used in OpenOffice.org for most parts of the user interface (the parts of the program you see and use, in c

Figure 193: Selecting multiple controlsMove the cursor over one of the fields. It changes to a drag icon. Drag the group of controls to where you want

2) Move the cursor over the middle green handle on the right. The cursor becomes a double-headed arrow.3) Drag the cursor to the left until the field

NoteThe table wizard in Base contains suggested fields which are single words, often consisting of two separate words. Table names in the wizard have

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

• Type the following exactly as it is in the List contents box:SELECT "Type", "Type" FROM "Payment Type"Figure 200: List

2) Click the Control icon to open the Properties window (Figure 202).3) Scroll down to the Scrollbars setting. Change the selection from None to Verti

Figure 203: Properties window for control in a subformStep 9: Add headings to groups.This step is easier to do if you have end-of-paragraph markers vi

Step 10: Change the background of a form.The background for a form can be a color, or a graphic (picture). You can use any of the colors in the Color

TipLearning how to use styles can be very helpful at times. By using styles, we changed the font color for all three headings at one time. There are o

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

Starting a new documentYou can start a new, blank document in OOo in several ways.When OOo is open but no document is open (for example if you close a

1) File > New > Database opens the Database Wizard window.2) Select Connect to an existing database. Click the arrow next to the Database type f

Using data sources in OpenOffice.orgHaving registered the data source, whether a spreadsheet, text document, external database or other accepted data

Launching Base to work on data sourcesYou can launch OOo Base at any time from the View Data Source pane. Just right-click on a database or the Tables

7) Final result: On <Date>, our breakfast cost <Breakfast> paid by <BPayment>, our lunch cost <Lunch> paid by <LPayment>

Figure 214: Insert Database Columns dialog6) Select the settings for your table. Use the default settings as in Figure 214.7) Click OK. Save the docum

3) Repeat until you have moved all of the fields you need to where you want them.4) Name and save the spreadsheet.5) Click a row of the table in the D

The Odometer, Tolls, and Motel fields are numerical fields. Enter values directly into them, or use the up and down arrows. When the value is entered,

Figure 217 is a record with data inserted in its fields.Figure 217: Sample record of the Vacation form and subformCreating queriesQueries are used to

Step 1: Select the fields.1) Select the CD-Collection table from the dropdown list of tables.2) Select fields from the CD-Collection table in the Avai

2) Click the second Sort by dropdown list.• Click CD-Collection.ArtistTitle. and select Ascending.3) Repeat this process for CD-Collection.DatePurchas

You can also open an existing document in one of the following ways.• Choose File > Open...• Click the Open button on the main toolbar.• Press Cont

Step 1: Open the first query in Design View.Click Create Query in Design View.Step 2: Add tables.Figure 220: Add Tables or Query window1) Click Fuel t

Step 4: Set the criterion for the query.We want the query’s FuelID to begin with the numeral 1.1) Type >0 in the Criterion cell under FuelID in the

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

Figure 229: Field for distance traveled calculations3) Calculate fuel economy:Type ("End-Reading".Odometer – Fuel.Odometer)/"End-Readin

Figure 232: Query table with aliases added3) Run the query again. The results are in Figure 233.Figure 233: Query run with aliasesWe really do not nee

Creating reportsReports provide information found in the database in a useful way. In this they are similar to queries. Reports are generated from the

The fields we need for the first report from the Vacations table are: Date, Motel, Toll, Breakfast, Lunch, Supper, SnackCost, and Miscellaneous. This

Step 4: Sort optionsWe do not want to do any additional sorting. Click Next.Step 5: Choose layoutUse default settings for the layout. Click Next.Step

NoteWhen a new report is opened in this way, the query used to open it is automatically selected in the Tables or queries dropdown list in the Report

b) In the Fuel table list, double-click to add FuelCost to the bottom table (Figure 240).c) Save and close the query.Figure 240: Adding an additional

match, you receive an error message. Close the message box to return to the Set Password dialog box and enter the password again.CautionOOo uses a ver

Modifying a reportAt the end of the last section, we left the Fuel Statistics report open in the edit mode (Figure 241). We will be working on that re

This can also be done with the last column on the right even though there is no black border. It should now look something like Figure 243.Figure 243:

Figure 245: Final reportMore ways to create reportsAn extension is available to assist in report creation. Sun Report Builder creates stylish, complex

Chapter 9 Getting Started with MathOpenOffice.org’s Equation Editor253

What is Math?Math is OpenOffice.org’s component for writing mathematical equations. It is most commonly used as an equation editor for text documents,

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

Example 1:5×4For this example we will enter a simple formula:5×4. On the Elements window:1) Select the top-left button of the categories (top) section

Figure 250: Result of entering 5 and 4 next to the times operatorRight-click menuAnother way to access mathematical symbols is to right-click on the e

Below is a short list of common equations and their corresponding markup.Display Command Display Commanda=ba = basqrt {a}a2a^2ana_n∫f xdxint f(x) d

Figure 252: Symbols catalog—used for entering Greek characters and some special symbols.Example 2:π ≃ 3.14159For this example we will suppose that:•

This section discusses the OpenOffice.org Open and Save As dialogs. Figure 12 shows the Save As dialog; the Open dialog is similar.Figure 12: The Open

Step 4: Click on the a≃b symbol. The equation editor now shows the markup %pi<?> simeq <?>.Step 5: Delete the <?> text and add 3.14

Figure 257: Formula editor as a floating windowHow can I make a formula bigger?This is one of the most common questions people ask about Math. The ans

Figure 260: Result of changing the base font size.Formula layoutThe most difficult part of using Math comes when writing complicated formulas. This se

Markup Resultsum from k = 1 to n a_k∑k =1nakint from 0 to x f(t) dtor int_0^x f(t) dt∫0xf tdt or ∫0xf t dtint from Re f∫ℜfsum to infinity 2^{-n}∑

How do I make a derivative?Making derivatives essentially comes down to one trick: Tell Math it’s a fraction.In other words, you have to use the over

Figure 261: Changing spacing in a matrix formulaNumbering equationsEquation numbering is one of Math’s best hidden features. The steps are simple, but

Figure 262: Inserting a cross-reference to an equation number 266 Getting Started with OpenOffice.org 3.3

Chapter 10 Printing, Exporting, and E-mailing267

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

The Print dialog has four tabs, from which you can choose a range of options, as described in the following sections.NoteThe options selected on the P

Using the NavigatorThe Navigator lists objects contained in a document, collected into categories. For example, in Writer it shows Headings, Tables, T

Figure 265: General print optionsPrinting multiple pages on a single sheet of paperYou can print multiple pages of a document on one sheet of paper. T

3) In the Page sides section, select whether to print all pages or only some pages.4) Click the Print button.TipIn Writer, to print two pages per shee

Figure 267: Printing a selection of textCalcYou can choose single sheets, multiple sheets, and selections of cells for printing.Figure 268: Choosing w

3) In the Ranges and copies section of the Print dialog, choose the Selected sheets option.4) Click the Print button.Printing a range of sheets:1) In

Printing a range of pages:1) Choose File > Print from the menu bar.2) Select the slides to print.a) In the Ranges and copies section of the Print d

To print a brochure on a single-sided printer:1) Choose File > Print.2) In the Print dialog, click Properties.3) Check the printer is set to the s

Printing in black and white (on a color printer)You may wish to print documents in black and white on a color printer. Several choices are available.

To use Page Preview:1) Choose File > Page Preview (or click the Page Preview button on the Standard toolbar).Writer now displays the Page Previe

Controlling PDF content and qualityFor more control over the content and quality of the resulting PDF, use File > Export as PDF. The PDF Options di

Range section• All: Exports the entire document to PDF.• Pages: To export a range of pages, use the format 3-6 (pages 3 to 6). To export single pages,

• Click the Navigation icon (second icon from the left at the top of the Navigator) to display the Navigation toolbar. Here you can pick one of the

on an odd page, OOo inserts a blank page between the two odd pages. This option controls whether to export that blank page.• Embed standard fonts: In

• Display document title. Causes the PDF viewer to display the document’s title in the title bar.User interface options section• Hide menubar. Causes

Figure 274: Links page of PDF Options dialogExport URLs relative to file systemIf you have defined relative links in a document, this option exports t

Figure 275: Security page of PDF Options dialogFigure 276: Setting a password to encrypt a PDFChapter 10 Printing, Exporting, and E-mailing 283

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

Figure 277: Select starting document2) On the second page, select E-mail message and click Next.Figure 278: Select document type3) On the third page

Figure 279: Selecting an address list4) Back on the Select address list page, click Next. On the Create salutation page, deselect This document should

Figure 281: Sending a document as an email message7) Type a subject for your email and click Send documents. OOo sends the e-mails.Digital signing of

To sign a document:1) Choose File > Digital Signatures.2) If you have not saved the document since the last change, a message box appears. Click Ye

Chapter 11 Graphics, the Gallery, and Fontwork289

Figure 16: List of actions that can be undoneAfter changes have been undone, Redo becomes active. To redo a change, select Edit > Redo, or press Co

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

Figure 282. Insert picture dialogLinking an image fileIf the Link option in the Insert picture dialog is selected, OOo creates a link to the file cont

Embedding linked imagesIf you originally linked the images, you can easily embed one or more of them later if you wish. To do so:1) Open the document

Inserting an image using a scannerIf a scanner is connected to your computer, OOo can call the scanning application and inserted the scanned item into

To insert an object as a link:1) Choose Tools > Gallery and select a theme.2) Select an object with a single click, then while pressing the Shift a

By default, the Gallery is docked above the workspace. To expand the Gallery, position the pointer over the line that divides it from the top of the w

Deleting images from the GalleryTo delete an image from a theme that you created:1) Right-click on the name of the image file or its thumbnail in the

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

• Load, Save, and Select icons.• Tools for drawing a hotspot shape: these tools work in exactly the same way as the corresponding tools in the Drawing

Creating drawing objectsTo begin using the drawing tools, display the Drawing toolbar (Figure 287) by clicking View > Toolbars > Drawing.If you

ContentsChapter 1 Introducing OpenOffice.org...9What is OpenOff

CautionNot saving your document could result in the loss of recently made changes, or worse still, your entire file.Closing OpenOffice.orgTo close OOo

1 Line 5 Line Color 9 To Foreground 13 Alignment2 Arrow Style 6 Area 10 To Background 14 Change Anchor3 Line Style 7 Area Style / Filling 11 Bring to

Using FontworkWith Fontwork you can create graphical text art objects for making your work more attractive. There are many different settings for text

Figure 290: The Fontwork Gallery3) Double-click the object to edit the Fontwork text. Type your own text in place of the black Fontwork text that appe

Using the Fontwork toolbarMake sure that the Fontwork toolbar, shown in Figure 289, is visible. If you do not see it, go to View > Toolbars > Fo

Fontwork Character Spacing: Changes the character spacing and kerning in the object. For custom spacing, input a percentage value: 100% is normal spac

Line optionsLine icon: Opens a dialog with three tabs: Line, Line Styles, Arrow Styles. Use the Line tab to edit the most common properties of the lin

• As Character - The object is placed in the document like any character and moves with the paragraph as you add or delete text before the object.Ungr

Chapter 12 Creating Web PagesSaving Documents as HTML Files307

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

Creating hyperlinksWhen you type text (such as a website addresses or URL) that can be used as a hyperlink, and then press the spacebar or the Enter k

Chapter 2 Setting up OpenOffice.orgChoosing Options to Suit the Way You Work31

Figure 296: Inserting a hyperlink using the NavigatorWhen using the Navigator to hyperlink to an object such as a graphic, to have the hyperlink show

On the left side, select one of the four categories of hyperlink:• Internet: the hyperlink points to a web address, normally starting with http://• Ma

• Name is applicable to HTML documents. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink.• Events button

Saving a document as a series of web pagesWriter can save a large document as a series of web pages (HTML files) with a table of contents page. To do

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

3) Chose a layout for the web site by clicking on the layout boxes. Click Next.4) Chose the information to be listed and the screen resolution. Click

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

To edit or view the document’s underlying HTML code, open the document, and then choose View > HTML Source or click the HTML Source icon on the M

NoteDepending on the size of your presentation and the number of graphics it contains, the HTML export function may create many HTML, JPG, and GIF fil

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

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

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

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

Chapter 13 Getting Started with MacrosUsing the Macro Recorder322

Your first macrosA 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”

Listing 2: Contents of Module1 after it is created.REM ***** BASIC *****Sub MainEnd SubAdd the new macro either before Sub Main or after End Sub. I

Figure 300: OOo Macro Organizer dialog, DBInspection library selected4) Be certain to open the library container named My Macros. Find the library nam

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

dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args1())end subThe macro in Listing 4 is not as complicated as it f

Pulling the macro togetherThe following details are very complete; it is not important to understand all of the details. The first line defines the st

A complicated exampleI frequently copy rows and columns of data from a web site and format them as a table in a text document. First, I copy the table

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

14) Press Tab to insert a tab between the number and the name.15) Press Home to move to the start of the line.16) Press down arrow to move to the next

rem (7) Press Ctrl+Shift+Right Arrow to select the number.dispatcher.executeDispatch(document, ".uno:WordRightSel", "", 0, Array()

The IDE has a Run Basic icon in the toolbar that runs the first macro in the IDE. Unless you change the first macro, it is the empty macro named Main.

organization dialogs, inserting special characters, and similar types of dialogs. Other possible problems using the macro recorder include things such

A computer scientist would use Figure 304 to precisely describe the situation. The text “1..*” means one or more, and “0..*” means zero or more. The b

Every library container contains a library named Standard. It is better to create your own libraries with meaningful names than to use the Standard li

Figure 306: The macro organizer dialogImporting macrosThe OpenOffice.org Macro Organizer dialog provides functionality to create, delete, and rename l

Navigate to the directory containing the library to import. There are usually two files from which to choose, dialog.xlb and script.xlb. It does not m

How to run a macroA typical method to run a macro is as follows:1) Use Tools > Macros > Run Macro to open the Macro Selector dialog (see Figure

To add a menu item, keyboard shortcut, or toolbar icon that calls a macro, use the Customize dialog (see Figure 308). Open this dialog in either of th

Help formattingHigh contrast is an operating system setting that changes the system color scheme to improve readability. To display Help in high contr

Menu itemUse Tools > Customize to open the Customize dialog, and select the Menus tab. You can modify an existing menu, or create new menus that ca

Figure 311: Assign macro to an application level eventFigure 312: Assign macro to the document open eventChapter 13 Getting Started with Macros 341

Figure 313: PrintHello is assigned to the Open Document eventExtensionsAn extension is a package that can be installed into OpenOffice.org to add new

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

Printed and eBook materialsThe following books are available for purchase in both printed and eBook form from their publishers.Andrew Pitonyak’s OpenO

Chapter 14 Customizing OpenOffice.org345

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

3) In the Save In drop-down list, choose whether to save this changed menu for the application (for example, OpenOffice.org Writer) or for a selected

Modifying existing menusTo modify an existing menu, select it in the Menu list and click the Menu button to drop down a list of modifications: Move, R

Figure 316: Adding a command to a menuCustomizing toolbarsYou can customize toolbars in several ways, including choosing which icons are visible and l

even when not being used. This option (sometimes called Enable systray quickstarter) is not available on all operating systems.Figure 21: Choosing Mem

Figure 317. The Toolbars page of the Customize dialogCreating a new toolbarTo create a new toolbar:1) Choose Tools > Customize > Toolbars from t

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

Figure 319: Setting up OOo for sending faxes4) Click the arrow icon at the end of the Standard toolbar. In the drop-down menu, choose Customize Toolba

Assigning shortcut keysIn addition to using the built-in keyboard shortcuts (listed in Appendix A), you can define your own. You can assign shortcuts

Figure 321. Defining keyboard shortcuts for applying styles5) Choose the category of style. (This example uses a paragraph style, but you can also cho

3) Next enter a name for the keyboard configuration file in the File name box, or select an existing file from the list. If you need to, browse to fin

TipTo get extensions that are listed in the repository, you can open the Extension Manager and click the Get more extensions here link.Figure 322: Usi

Documents with more sophisticated layouts, such as those created with professional desktop publishing applications that use special fonts and complex

Appendix A Keyboard Shortcuts358

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

User Interface – Icon size and styleThe first box specifies the display size of toolbar icons (Automatic, Small, or Large). The Automatic icon size op

General keyboard shortcutsOpening menus and menu itemsShortcut Keys ResultAlt+<?>Opens a menu where <?> is the underlined character of the

Getting helpShortcut Keys ResultF1Opens OOo Help dialog. In OOo Help: jumps to first help page of the selected tab.Shift+F1Turns cursor into the What

EditingShortcut Keys ResultCtrl+X Cuts selected items.Ctrl+C Copies selected items.Ctrl+V Pastes copied or cut items from the clipboard.Ctrl+Shift+V O

Appendix B Open Source, Open Standards, OpenDocument363

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

What is “open source”?The four essential rights of open-source software are embodied within the Free Software Foundation’s General Public License (GPL

OpenDocument filename extensionsThe most common filename extensions used for OpenDocument documents are:*.odt for word processing (text) documents*.od

Why do I need Java to run OOo? Is it written in Java?OpenOffice.org is not written in Java; it is written in the C++ language. Java is one of several

Opening spreadsheetsIn addition to OpenDocument formats (.ods and .ots), Calc 3 can open the formats used by OOo 1.x (.sxc and .stc) and the following

File formats OOo can save toSaving in an OpenDocument format guarantees the correct rendering of the file when it is transferred to another person or

Mouse positioningSpecifies if and how the mouse pointer will be positioned in newly opened dialogs.Middle mouse buttonDefines the function of the midd

StarCalc 3.0, 4.0, and 5.0 formats (.sdc and .vor)Unified Office Format spreadsheet (.uos)HTML Document (OpenOffice.org Calc) (.html and .htm)Pocket E

Index3 3D objects 199A accepting or rejecting changes 101accessibility features 361accessibility options 44adding macros from other sources 322

cross-fading 197cross-references inserting references 102overview 102CSV file open 110save 111CSV files 109, 111Ctrl-click required to follow

Flash export 199HTML export 199inserting pictures 199line 182rectangle 183save in a foreign format 199Drawing Object Properties toolbar 298draw

formatting pages 94Formatting toolbar 18formatting, Calc AutoFormat 133conditional 134themes 134formula bar, Calc 108formula editor See: equat

function keys 361loading from a file 354resetting to default values 354saving to a file 353keyboard shortcuts (macros) 338L landscape pages 74l

Calc 112new document 23non-breaking hyphen 86non-breaking spaces 86nonconsecutive items, selecting 82Normal view (Impress) 149Notes view (Impres

grayscale on color printer 276handouts 274headers and footers, Calc 141Impress and Draw 273multiple pages per sheet 270notes (Impress) 274page b

adding pictures 163adding tables 164adding text 158layouts 156master 166modifying 158rename 153Slides pane (Impress) 146snap functions 179Sna

toolbars 148adding commands 349choosing icons for commands 350Color Bar 178creating 349customizing 20displaying or hiding 18Draw 177Drawing 1

Figure 24: Choosing general printing options to apply to all OOo componentsPath optionsOn the OpenOffice.org – Paths page, you can change the locatio

Figure 25: Viewing the paths of files used by OpenOffice.org Color optionsOn the OpenOffice.org – Colors page, you can specify colors to use in OOo do

Setting a default template...70Associating a document with a diffe

To modify a color:1) Select the color to modify from the list or the color table.2) Enter the new values that define the color. If necessary, change t

Font optionsYou can define replacements for any fonts that might appear in your documents. If you receive from someone else a document containing font

Figure 29: Choosing security options for opening and saving documentsSecurity options and warningsIf you record changes, save multiple versions, or in

Figure 30: Security options and warnings dialogAppearance optionsWriting, editing, and (especially) page layout are often easier when you can see the

• To show or hide items such as text boundaries, select or deselect the options next to the names of the items.• To change the default colors for item

Figure 33: Choosing a Java runtime environmentOnline Update optionsOn the OpenOffice.org – Online Update page, you can choose whether and how often to

Improvement programOn the OpenOffice.org – Improvement Program page, you can choose whether or not to participate in the OpenOffice.org Improvement Pr

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

VBA Properties Load/Save optionsOn the Load/Save – VBA Properties page, you can choose whether to keep any macros in Microsoft Office documents that a

Figure 38: Choosing Load/Save Microsoft Office optionsHTML compatibility Load/Save optionsChoices made on the Load/Save – HTML Compatibility page affe

Using conditional formatting...134Hiding and showing data...

Import - Use 'English (USA)' locale for numbersWhen importing numbers from an HTML page, the decimal and thousands separator characters diff

Choosing language settingsYou may need to do several things to set the language settings to what you want:• Install the required dictionaries• Change

Figure 41: Choosing language optionsIf necessary, select the options to enable support for Asian languages (Chinese, Japanese, Korean) and support for

Figure 43: Choosing languages, dictionaries, and options for checking spellingHere you can also check which user-defined (custom) dictionaries are act

Figure 44: Internet options, showing E-mail page available to Linux users.Controlling OOo’s AutoCorrect functionsSome people find some or all of the i

Chapter 3 Using Styles and Templates55

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

• Numbering styles apply similar alignment, numbering or bullet characters, and fonts to numbered or bulleted lists.• Cell styles include fonts, align

TipAt the bottom of the Styles and Formatting window is a dropdown list. In Figure 46 the window shows Automatic, meaning the list includes only style

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

Creating database tables...205Defining relationships...

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

Creating new (custom) stylesYou may want to add some new styles. You can do this in two ways:• Creating a new style using the Style dialog• Creating a

Dragging and dropping to create a styleYou can drag and drop a text selection into the Styles and Formatting window to create a new style.WriterSelect

Figure 50: Choosing to copy styles from a document, not a templateFigure 51: Copying a style from one document to anotherLoading styles from a templat

Figure 52. Copying styles from a template into the open document4) Select the categories of styles to be copied. Select Overwrite if you want the styl

Using a template to create a documentTo use a template to create a document:1) From the main menu, choose File > New > Templates and Documents.

Creating a templateYou can create your own templates in two ways: from a document, and using a wizard.Creating a template from a documentTo create a t

You can also save menu and toolbar customizations in templates; see Chapter 14 (Customizing OpenOffice.org) for more information.Creating a template u

Editing a templateYou can edit a template’s styles and content, and then, if you wish, you can reapply the template’s styles to documents that were cr

NoteTo re-enable updating from a template:1) Use Tools > Macros > Organize Macros > OpenOffice.org Basic. Select the document from the list,

Chapter 13 Getting Started with Macros...322Your first macros...

Figure 57: Newly-added package of templatesSetting a default templateIf you create a document by choosing File > New > Text Document (or Spreads

Resetting the default templateTo re-enable OOo’s Default template for a document type as the default:1) In the Template Management dialog, click any f

4) In the Select Template window, find and select the required template and click Open.5) Save the document. If you now look in File > Properties,

Deleting a templateYou cannot delete templates supplied with OOo or installed using the Extension Manager; you can only delete templates that you have

As an example, we can use the First Page and Default page styles that come with OOo. Figure 58 shows what we want to happen: the first page is to be f

Controlling page breaks automaticallyWriter automatically flows text from one page to the next. If you do not like the default settings, you can chang

Chapter 4 Getting Started with WriterWord Processing with OpenOffice.org76

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,

Figure 61: Left end of status barPage numberShows the current page number, the sequence number of the current page (if different), and the total numbe

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

8

You can also choose View > Zoom from the menu bar to display the Zoom & View Layout dialog, where you can set the same options as on the Status

Click an icon to select that object type. Now all the Previous and Next icons (in the Navigator itself, in the Navigation Toolbar, and on the scroll b

From this point on, all changes you make to the document will occur only in the Microsoft Word document. You have changed the name and file type of y

3) Use the arrow keys to move to the start of the next piece of text to be selected. Hold down the Shift key and select the next piece of text.4) Repe

Figure 70: Paste Special menuFinding and replacing text and formattingWriter has two ways to find text within a document: the Find toolbar for fast se

1) Type the text you want to find in the Search for box.2) To replace the text with different text, type the new text in the Replace with box.3) You c

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

To set the measurement unit and the spacing of default tab stop intervals, go to Tools > Options > OpenOffice.org Writer > General.Figure 73:

Writer does not include a grammar checker, but you can install an extension such as Language Tool and access it from Tools > Spelling and Grammar.

See the different tabs of the dialog for the wide variety of other options available to fine-tune AutoCorrect.TipAutoCorrect can be used as a quick wa

Chapter 1 Introducing OpenOffice.org9

TipIf the only option under the AutoText button is Import, either you have not entered a name for your AutoText or there is no text selected in the do

1 Open Styles and Formatting Window6 Italic 12 Font Color7 Underline 13 Highlighting2 Apply Style 8 Superscript 14 Background Color3 Font Name 9 Subsc

NoteIt is a matter of personal preference whether you type your information first, then apply Numbering/Bullets, or apply them as you type.Using the B

Figure 79: Turning on automatic hyphenationNoteTurning on hyphenation for the Default paragraph style affects all other paragraph styles that are base

Formatting pagesWriter provides several ways for you to control page layouts: page styles, columns, frames, tables, and sections. For more information

For a newsletter with complex layout, two or three columns on the page, and some articles that continue from one page to some place several pages late

5) To change the title for the whole document, go back to File > Properties > Description.Fields are covered in detail in Chapter 14 (Working wi

Figure 81: Specifying a page break before a paragraphMethod 2:1) Insert > Manual break.2) By default, Page break is selected on the Insert Break di

To change margins using the rulers:1) The gray sections of the rulers are the margins. Put the mouse cursor over the line between the gray and white s

Figure 84: Example of commentsTo navigate from one comment to another, open the Navigator (F5), expand the Comments section, and click on the comment