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 = basqrt {a}a2a^2ana_n∫f xdxint 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 tdt 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
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
Commentaires sur ces manuels