OpenOffice.org 2.x Guia do Utilizador Página 1

OpenOffice.org User Guidefor Version 2.x[OpenOffice.org User Guide for 2.x][0.2]First edition: [2005-04-11]First English edition: [2005-04-11]

Searching for Text Attributes...47Searching for Special Formats

Chapter 3: Managing Text Documents With Writer Emphasizing TextThere are many ways of emphasizing text in a special way. Here are some of them:• Use t

Chapter 3: Managing Text Documents With Writer Open the Show Draw Functions floating toolbar on the Standard toolbar.On the Draw Functions toolbar, cl

Chapter 3: Managing Text Documents With Writer On the left of the dialogue panel is the Line arrangement group. Notice that the four outer edges of th

Chapter 3: Managing Text Documents With Writer Use the Borders floating toolbar with TablesSuppose the following table border is required for a docume

Chapter 3: Managing Text Documents With Writer 4. Now, with the mouse, select the whole of the first row, open the context menu and choose Table to op

Chapter 3: Managing Text Documents With Writer Superscripts and SubscriptsUsers have the following options for superscripting or subscripting text:1.

Chapter 3: Managing Text Documents With Writer Applying subscripts/superscripts retrospectivelyLet's say that while proofing text, the text H2O n

Chapter 3: Managing Text Documents With Writer To copy the text, rather than move, it, press Ctrl while performing the actions described above. As sho

Chapter 3: Managing Text Documents With Writer • Sections that are to be inserted into a document as files or parts of files.• Sections that can be in

Chapter 3: Managing Text Documents With Writer Sections and Columns• Multicolumn section: A section can contain other sections. This feature allows th

Automatic correction...60Word completion...

Chapter 3: Managing Text Documents With Writer Formatting Text With and Without StylesPlain text can be too bland unless one applies visual effects to

Chapter 3: Managing Text Documents With Writer The Style Concept in OpenOffice.orgStyles for characters, paragraphs, frames, numbered lists and pages

Chapter 3: Managing Text Documents With Writer Double-click an entry in the list of Paragraph Styles. The paragraph in which the cursor is positioned

Chapter 3: Managing Text Documents With Writer By way of example, if one changes the left indent to 2.54 cm (1 inch) in the Paragraph Style “Heading”,

Chapter 3: Managing Text Documents With Writer Character StylesIn the following illustration, the Styles and Formatting window displays a list of avai

Chapter 3: Managing Text Documents With Writer For example, start with the Paragraph Style “default”. It uses the font “Times New Roman” in “12” point

Chapter 3: Managing Text Documents With Writer e) close the dialogue with OK.Yet another example shows how to define a Paragraph Style for a subtitle

Chapter 3: Managing Text Documents With Writer The Advantages of the Styles and Formatting WindowFrom the preceding instructions users should now know

Chapter 3: Managing Text Documents With Writer 4. At the top of the Styles and Formatting window, click the Update Style icon. All headings formatted

Chapter 3: Managing Text Documents With Writer 4. Call up the context menu of one of the Page Styles and select the New... command.One will now see th

Writing in Uppercase or Lowercase ...72Moving Text Sections in

Chapter 3: Managing Text Documents With Writer 6. In the context menu of the Styles and Formatting window click the New... command again and define th

Chapter 3: Managing Text Documents With Writer 4. Select as Type the Page break option. In the list box select the Table of Contents Page Style which

Chapter 3: Managing Text Documents With Writer Under Format > Page > Page, one can select the page layout “mirrored”. This lets the user define

Chapter 3: Managing Text Documents With Writer If a particular paragraph should be on a new page with a new Page Style, then that would be a property

Chapter 3: Managing Text Documents With Writer 2. Select the desired field format.3. Click OK.Better than the direct formatting method, just described

Chapter 3: Managing Text Documents With Writer 3. In the Page Style dialogue set the desired width and height of the footer.Page Styles SummaryUnlike

Chapter 3: Managing Text Documents With Writer Defining default TemplatesWhenever users finds that they are forever changing the formatting of new doc

Chapter 3: Managing Text Documents With Writer Templates and StylesOpenOffice.org templates are files that one can use as base for creating personal,

Chapter 3: Managing Text Documents With Writer Creating New Styles From SelectionsCreate a new style by copying an existing style, as follows:1. Open

Chapter 3: Managing Text Documents With Writer Style can also be updated by using drag and drop:1. Select the style to be updated in the Styles and Fo

New Style from Selection...94Transferring Formats Wi

Chapter 3: Managing Text Documents With Writer Three identical characters will become a whole lineWhen three of the following characters ( - _ = * ~ #

Chapter 3: Managing Text Documents With Writer Using AutoTextWriter contains an AutoText function which helps users to use shortcuts and abbreviations

Chapter 3: Managing Text Documents With Writer Use the left mouse button to select the AutoText for insertion. Upon releasing the mouse button, the te

Chapter 3: Managing Text Documents With Writer Using AutoText in NetworksMultiple AutoText lists can be used. An example would be in a typical OpenOff

Chapter 3: Managing Text Documents With Writer AutoText With AutoCompleteTo enable AutoCompletion of selections in the AutoText dialogue, check Displa

Chapter 3: Managing Text Documents With Writer Text FramesMaking text look as good as it as reads is likely something desired. To achieve this, users

Chapter 3: Managing Text Documents With Writer Editing Text FramesSelect a text frame by clicking on one of its edges. Once selected, a user can drag

Chapter 3: Managing Text Documents With Writer Note: The height of a frame that is linked with a subsequent frame is automatically fixed. The height i

Chapter 3: Managing Text Documents With Writer Using Text AnimationWriter's Text Animation feature enables composition of applications with colou

Chapter 3: Managing Text Documents With Writer 10.Close the dialogue with OK.11.Open the context menu once more.12.Select the Line... command to defin

Jumping to a Specific Page...112Chapters in Navigator...

Chapter 3: Managing Text Documents With Writer 23.To alter the size of the animated text, select the rectangle again and double-click in the centre. N

Chapter 3: Managing Text Documents With Writer Drawing Lines in TextThere are a number of ways to add lines to a page of text and any lines that are i

Chapter 3: Managing Text Documents With Writer Editing Text With FontWorkThe FontWork program module is used for graphical text effects in a similar m

Chapter 3: Managing Text Documents With Writer 7. Click Vertical in the Shadow options. Specify 0.10 inches for the x-axis shadow distance. The text s

Chapter 3: Managing Text Documents With Writer Aligning Text With LinesAligning text on a free form line1. Draw a free form line using the free form l

Chapter 3: Managing Text Documents With Writer The NavigatorThe Navigator is another important feature of OpenOffice.org that, along with the Styles a

Chapter 3: Managing Text Documents With Writer For example, click the Navigation icon in the Navigator window and in the Navigation window click the G

Chapter 3: Managing Text Documents With Writer Chapters in NavigatorIn long documents, use the Navigator to obtain an overview and change the sequence

Chapter 3: Managing Text Documents With Writer Indexes and Tables of Contents in WriterWriter documents can contain any number of predefined or user-d

Chapter 3: Managing Text Documents With Writer Editing or Deleting Index and Table EntriesAll defined index entries are shaded gray in the document fo

Numbering Lines...138Line Numbering

Chapter 3: Managing Text Documents With Writer Creating a Table of Contents1. Place the cursor at the location at which to create the table of content

Chapter 3: Managing Text Documents With Writer Creating Alphabetical Indexes1. Place the cursor in which to create the index.2. Select Insert > Ind

Chapter 3: Managing Text Documents With Writer i. In the document, find a candidate location or text for the new index. ii. Position the text cursor

Chapter 3: Managing Text Documents With Writer g) Mark the other check boxes under Create from to create the index from all the objects of a certain t

Chapter 3: Managing Text Documents With Writer 'Word only' means terms will only be picked up if the full search term word(s) are found in t

Chapter 3: Managing Text Documents With Writer #Match case is 0 which means false, so all upper #and lower case instances will be selected#Word only i

Chapter 3: Managing Text Documents With Writer Creating BibliographiesBibliography entries are often in the form of: “Smith [Smith 1995] has also carr

Chapter 3: Managing Text Documents With Writer 2. First decide whether to select the entry from the records contained in the bibliography database or

Chapter 3: Managing Text Documents With Writer Where the list is a table of contents for the document, click a hyperlink to go straight to the first o

Chapter 3: Managing Text Documents With Writer Headings and NumberingMost text documents benefit from use of headings and numbering. Writer provides a

Calculating in Text Document Tables...150Calculating Across Multiple Tabl

Chapter 3: Managing Text Documents With Writer One can select further settings for the bulleted list in which the cursor is positioned with the Format

Chapter 3: Managing Text Documents With Writer Example numbered list with sublevels:1 Line one2 and line two. If one enters a return the next the ne

Chapter 3: Managing Text Documents With Writer With respect to custom style s where there is, currently, a Paragraph Style “Head1” that is used for he

Chapter 3: Managing Text Documents With Writer Numbering Illustrations by ChaptersNumbering illustrations by chapter, so that illustrations are labell

Chapter 3: Managing Text Documents With Writer This “Note” number range enables users to automatically number all the notes in a document. In the fiel

Chapter 3: Managing Text Documents With Writer Using Master Documents and SubdocumentsA new empty master document is created by choosing File > New

Chapter 3: Managing Text Documents With Writer The Navigator provides the functions needed for navigating and editing a master document. Double-click

Chapter 3: Managing Text Documents With Writer Note: When using master documents, use the same template as a base for all subdocuments and the master

Chapter 3: Managing Text Documents With Writer When one or more subdocuments are changed after creating an index, the indexes in the master document s

Chapter 3: Managing Text Documents With Writer b) Choose suitable horizontal and vertical references to the page in the properties dialogue, under &qu

Formatting Headers and Footers ...165Defining Different H

Chapter 3: Managing Text Documents With Writer Importing Lists From Other Text ProgramsWord processors internally organize bulleted and numbered lists

Chapter 3: Managing Text Documents With Writer Interrupting and Continuing NumberingSometimes, with a series of automatically numbered paragraphs, the

Chapter 3: Managing Text Documents With Writer Numbering LinesWhen lines are to be numbered within a document, select the line numbering properties th

Chapter 3: Managing Text Documents With Writer Tables in TextTables and spreadsheets can be included in text documents.Inserting TablesThere are a num

Chapter 3: Managing Text Documents With Writer Choose Edit > Paste Special to open the Paste Special dialogue which has several options from which

Chapter 3: Managing Text Documents With Writer Inserting Paragraphs Before Tables at Start of PageOccasionally a table will get inserted at the very b

Chapter 3: Managing Text Documents With Writer 4. Click OK upon making a choice.5. Tables can be designed with even greater impact using thematically

Chapter 3: Managing Text Documents With Writer Calculating in Text DocumentsFormulae in Text DocumentsPressing F2 opens the Formula bar. Clicking the

Chapter 3: Managing Text Documents With Writer List Separator|Separates the elements in a list.Example of using a list:MIN 10|20|50|<C6>|<A2:

Chapter 3: Managing Text Documents With Writer SineSINCalculates the sine in radiansExample: SIN (PI/2)CosineCOSCalculates the cosine in radians.Examp

Editing Headers ...184Editing Columns..

Chapter 3: Managing Text Documents With Writer 6. Press Enter, to inset the result as a field in the text.7. Double-click on the field to edit it.Calc

Chapter 3: Managing Text Documents With Writer Conditional TextFields can be used in a document to display text when a condition is met. For example,

Chapter 3: Managing Text Documents With Writer 5. Click “Text” in the Format list.6. Enter “1” in the Value box,7. Click Insert.To display integers, c

Chapter 3: Managing Text Documents With Writer 6. Type the text to display when the condition is met in the Then box. There is no limit to the length

Chapter 3: Managing Text Documents With Writer Calculating in Text Document TablesOpenOffice.org Writer tables can also include calculations, and thes

Chapter 3: Managing Text Documents With Writer c) Insert a single-cell table inside the frame using Insert > Table. d) Set a row and a column value

Chapter 3: Managing Text Documents With Writer Calculating Cell Totals in Tables1. Insert a table with multiple rows (Insert > Table) into a new te

Chapter 3: Managing Text Documents With Writer Inserting or Deleting Rows/Columns Using the KeyboardThe following methods describe how to insert and d

Chapter 3: Managing Text Documents With Writer Rows and columns can also be modified either in the table directly, or with the aid of the rulers. If t

Chapter 3: Managing Text Documents With Writer OpenOffice.org User Guide for 2.x 155

Arranging Data...203Examining and E

Chapter 3: Managing Text Documents With Writer Images, Drawings, Clipart and FontWorkImages, drawings, clipart, and special FontWork objects can be in

Chapter 3: Managing Text Documents With Writer Captions and Number RangesIn text documents one can create separate, continuously numbered captions for

Chapter 3: Managing Text Documents With Writer 5. Close the dialogue box. If illustrations are moved with their captions by hand so that the sequence

Chapter 3: Managing Text Documents With Writer Inserting Graphics From OpenOffice.org Draw or ImpressGraphic objects can be copied and inserted from o

Chapter 3: Managing Text Documents With Writer 1. When dragging and dropping, without pressing a key or while pressing the Ctrl key, a plus sign appea

Chapter 3: Managing Text Documents With Writer Drag the chart into the OpenOffice.org Writer document.This will move the chart. To copy the chart, pre

Chapter 3: Managing Text Documents With Writer Headers, Footers and FootnotesSome Notes Concerning Headers and FootersHeaders and footers are always l

Chapter 3: Managing Text Documents With Writer i. Place the cursor anywhere in the footer and click on the Centered icon on the Formatting toolbar. ii

Chapter 3: Managing Text Documents With Writer 5. Select the Insert > Fields > Other “command.a) In the Fields dialogue:b) Select the Document t

Chapter 3: Managing Text Documents With Writer Formatting Headers and FootersHeaders and footers can be formatted with multiple objects where an objec

Layout of Spreadsheets...225Designing Spreadsh

Chapter 3: Managing Text Documents With Writer 2. Choose the Document tab and under “Type” select ”Page”, under “Select” select “Next page” and under

Chapter 3: Managing Text Documents With Writer Draw a line under the header by going to the Borders tab. Under Line arrangement click between the two

Chapter 3: Managing Text Documents With Writer One can jump from a footnote anchor in the document to the footnote text quite easily by clicking on th

Chapter 3: Managing Text Documents With Writer When inserting a footnote using the icon, footnote numbering is automatic. The Insert Footnote dialogue

Chapter 3: Managing Text Documents With Writer Spellcheck, Dictionaries, HyphenationControlling Spellcheck via the dialogueChoose Tools > Spellchec

Chapter 3: Managing Text Documents With Writer If needed, all unknown words in a text can be automatically entered in the active user-defined dictiona

Chapter 3: Managing Text Documents With Writer Automatic hyphenationIn OpenOffice.org, automatic hyphenation is turned off by default. The following s

Chapter 3: Managing Text Documents With Writer Selecting Tools > Language > Hyphenation avoids searching manually through the text in order to f

Chapter 3: Managing Text Documents With Writer 3. In the dialogue which then appears, scroll down the two lower list boxes until a suitable word is fo

Chapter 3: Managing Text Documents With Writer Form Letters, Business Cards and LabelsWrite form letters, design business cards and produce labels a

What use is the DataPilot?...250Creating DataPilot Tabl

Chapter 3: Managing Text Documents With Writer On the other hand, a variable date is updated every time the document is opened and printed. A manual u

Chapter 3: Managing Text Documents With Writer 5. With each dialogue, select the features needed.6. Click Create to add this document to the templates

Chapter 3: Managing Text Documents With Writer Designing Labels and Business CardsUsing File > New > Labels for designing business cards, as bus

Chapter 3: Managing Text Documents With Writer 4. To define a custom format, select the Format tab. 5. Check Synchronize contents. 6. Click on New Doc

Chapter 3: Managing Text Documents With Writer 2. Select the format of the label sheets that will be printed from the dropdown menu. Remember to check

Chapter 3: Managing Text Documents With Writer 4. In the Condition field, enter the following text (without quotation marks): not(Company)Now the COMP

Chapter 3: Managing Text Documents With Writer NewslettersIn this section, learn how to create a newsletter/newspaper as a text document. This is usef

Chapter 3: Managing Text Documents With Writer Creating a Newsletter From a TemplateIn the File menu choose New > Templates and Documents. Locate a

Chapter 3: Managing Text Documents With Writer To create a dividing line, select a narrow line from the Line list box under Separator, set the Height

Chapter 3: Managing Text Documents With Writer Note: Newsletters or newspapers require a variety of main headings, subheadings, and text wraps to make

formulae and Values as CSV Files...268Exporting formulae and Va

Chapter 3: Managing Text Documents With Writer The First Paragraph field (or the menu command in the context menu) ensures that when a graphic is posi

Chapter 3: Managing Text Documents With Writer 7. If the text is a section linked to another file choose Insert > Section. In the Insert Sections d

Chapter 3: Managing Text Documents With Writer a) Draw a frame manually on the front page, b) Select To Page as anchor. c) Press the Escape key to set

Chapter 3: Managing Text Documents With Writer This is where the level of the Style is assigned, in the table of contents, for each Style used in the

Chapter 3: Managing Text Documents With Writer Further InformationUsing Automatic HyphenationWhen working with columns, it makes sense to activate aut

Chapter 3: Managing Text Documents With Writer Letters With EnvelopesWith OpenOffice.org Writer, a letter can be written in no time. These instruction

Chapter 3: Managing Text Documents With Writer 2. Click Letter in the submenu to see the first page of the Wizard for Letters. 3. Select Personal Lett

Chapter 3: Managing Text Documents With Writer 2. Locate the letter template wanted and open it. The templates are found in the OpenOffice.org direct

Chapter 3: Managing Text Documents With Writer Adjusting the Printer for the Printout Printing envelopes depends very much on the type of printer used

Chapter 3: Managing Text Documents With Writer 9. Same dialogue, select Orientation. This depends on how the envelope feeds (see step 5) In any case,

Presentation Styles...289Using Outline View

Chapter 3: Managing Text Documents With Writer 2. Calculate the number that is needed to add to this number to make the last digit of the sum a zero (

Chapter 3: Managing Text Documents With Writer 3. If the listbox doesn't list the language that you want, see "Adding More Text Languages&qu

Chapter 3: Managing Text Documents With Writer 4. Choose whether to install the new files for the current user only or for all users depending permiss

Chapter 3: Managing Text Documents With Writer 11.Click Retrieve the list and select desired thesaruses using the method in step 7.12.The macro downlo

Chapter 3: Managing Text Documents With Writer OpenOffice.org User Guide for 2.x 200

Chapter 3: Managing Text Documents With Writer OpenOffice.org User Guide for 2.x 201

Chapter 4: Spreadsheets in CalcChapter 4: Spreadsheets in CalcCalc is the powerful spreadsheet program of the OpenOffice.org program. It provides the

Chapter 4: Spreadsheets in CalcDynamic ChartsCalc has a charting function that can display spreadsheet data graphically by selecting the data to be di

Chapter 4: Spreadsheets in CalcWhere the input file is in fixed width fields, check the Fixed width box and set the column widths in the measurement b

Chapter 4: Spreadsheets in CalcThe Calc Window Structure of a SpreadsheetA spreadsheet is made up of individual sheets. Each sheet contains various ce

Using the Navigator...307Edit Jump Targets...

Chapter 4: Spreadsheets in CalcA new spreadsheets is opened with the command File > New > Spreadsheet. Initially it is named “Untitled1” and rem

Chapter 4: Spreadsheets in CalcMultiple Sheets in a DocumentAt the lower edge of the spreadsheet document there are tabs for switching among the vario

Chapter 4: Spreadsheets in CalcOpenOffice.org User Guide for 2.x 208

Chapter 4: Spreadsheets in CalcValues and Formulae as Cell ContentsIndividual cells can contain text, numbers, dates or formulae. Cell contents are ve

Chapter 4: Spreadsheets in Calc6. Enter the following in cell B4:=A3 * A4 / 100When input is started with an equals sign, this indicates that a formul

Chapter 4: Spreadsheets in CalcUsing Built-in FunctionsCalc has many built-in functions, one of which convert Euros to another currency, such as the U

Chapter 4: Spreadsheets in Calc9. Click cell E2, then the small filled square in the bottom right hand corner of cell E2 and, pressing the left mouse

Chapter 4: Spreadsheets in CalcTo enter a number directly as text, enter an apostrophe (') first, for example for years in column headings '

Chapter 4: Spreadsheets in CalcNumbersWhile numbers are displayed in various ways, internally these always remain numeric. For example, '1'

Chapter 4: Spreadsheets in Calc3. In the Search for box, enter ^[0-9]4. In the Replace with box enter: &5. Check Regular expressions6. Check Curre

Editing Curves...320Vectorizing Bitma

Chapter 4: Spreadsheets in CalcIn Calc, users can define a number, formatted as “1,2 34.50 €”, to remain in Euros in another country and does not chan

Chapter 4: Spreadsheets in CalcCalculating With formulaeAll formulae begin with an equals sign. formulae may contain numbers or text, and other data i

Chapter 4: Spreadsheets in CalcCalculating With Dates and TimesIn spreadsheets users can do more than just display dates and times (both taken from th

Chapter 4: Spreadsheets in Calc4. Press the Enter key after each formula. The time since the birthday will be calculated and displayed in the various

Chapter 4: Spreadsheets in CalcHandling Multiple SheetsSpreadsheet are not limited to just one sheet. In fact, several sheets laid on top of each othe

Chapter 4: Spreadsheets in CalcWhen there is insufficient space to display the sheet tabs on the lower window border, increase it by moving the separa

Chapter 4: Spreadsheets in CalcTo print the only current sheet, go to menu File > Print... In the Print dialogue, select the Selection option and

Chapter 4: Spreadsheets in CalcFormatting a SpreadsheetA spreadsheet is hardly ever used without formatting. Cell contents, such as texts and numbers,

Chapter 4: Spreadsheets in CalcFormatting Cells and SheetsThe distinction between direct and Style formatting holds true for cells as well as for text

Chapter 4: Spreadsheets in CalcUse the More button to display additional options in the dialogue. In the additional section that is then displayed, se

Using Illumination...345More 3d Effects...

Chapter 4: Spreadsheets in CalcIn this example, the sheet has been formatted with certain cell attributes in the Format > Cells dialogue. In additi

Chapter 4: Spreadsheets in CalcAddressing CellsCells can be addressed directly by means of their coordinates in the row-and-column matrix. Use absolut

Chapter 4: Spreadsheets in CalcAbsolute references are used when a calculation refers to one specific cell in the sheet. For example, if a formula tha

Chapter 4: Spreadsheets in CalcAddressing by NameA neat way of making the references to cells and cell ranges in formulae legible is to give the range

Chapter 4: Spreadsheets in CalcThe automatic formula recognition allows entering, for example, the formula =SUM(Ju ly) in cell B8. This formula can th

Chapter 4: Spreadsheets in CalcMethod ResultCopy the visible cells, for example, with copy and paste via the clipboard,with the middle mouse button or

Chapter 4: Spreadsheets in CalcUsing References in formulaeSo far users have been introduced to formulae containing absolute values, absolute and rela

Chapter 4: Spreadsheets in CalcWhile dragging the mouse to highlight the desired range, the Wizard dialogue will be automatically minimized so that on

Chapter 4: Spreadsheets in CalcThe name of the sheet automatically receives a leading dollar sign, since the sheet has absolute addressing.Examine the

Chapter 4: Spreadsheets in CalcUsing ChartsData from spreadsheets can be represented graphically in a chart. A wide variety of charts and diagrams sui

Copying the form...372Changing the form&a

Chapter 4: Spreadsheets in CalcIf the age groups, rather than the towns, should appear on the horizontal axis, tilt the chart. As long as the chart re

Chapter 4: Spreadsheets in CalcThe type of chart can also be changed, after the fact. Double-click on the chart and choose Format > Chart Type, a d

Chapter 4: Spreadsheets in CalcIn a chart, individual data series or data points can be selected by clicking on them and then opening the context menu

Chapter 4: Spreadsheets in CalcIf the legend is moved over another object of the chart, its Properties dialogue can no longer be opened by double-clic

Chapter 4: Spreadsheets in CalcDatabase Functions in CalcSpreadsheets in Calc are also able to manage records consisting of several fields, as in a da

Chapter 4: Spreadsheets in Calc7. Choose a date format for Column A.8. Select column C by clicking on the column header, 9. Apply a currency format. C

Chapter 4: Spreadsheets in CalcDefining Database Ranges1. Select the three column area and define the selected area as a database range by choosing Da

Chapter 4: Spreadsheets in CalcSet the cursor in the database range and choose Data > Sort. In the dialogue that appears, select the column to be s

Chapter 4: Spreadsheets in Calca) Date > 1/2/2000 AND Amount > 100. In the dialogue, the existing contents of the data fields in the pull-down l

Chapter 4: Spreadsheets in CalcGrouping Database Ranges and Calculating SubtotalsAssuming there is sample data that can be expanded and actually used

Searching in Tables and Form Documents ...388Searching With a Form Filter

Chapter 4: Spreadsheets in CalcThe grand total is displayed at the bottom.Notice the controls to the left of the row headers. These enable the user to

Chapter 4: Spreadsheets in CalcWhen making a dBase import, a dialogue open from which to choose the character set of the file. For example, in some la

Chapter 4: Spreadsheets in Calc6. Select the folder containing the database file(s) in *.dbf format.7. Click OK.8. In the Name field, enter a name to

Chapter 4: Spreadsheets in CalcEvaluating Data With CalcCalc provides several powerful tools for evaluating data. The DataPilot helps produce any kind

Chapter 4: Spreadsheets in CalcWhat use is the DataPilot?A table that has been created with the DataPilot is an interactive table, i.e. data can be ar

Chapter 4: Spreadsheets in CalcUse this dialogue to select the functions to be used for displaying the data in the data area. To make a multiple selec

Chapter 4: Spreadsheets in CalcSelecting DataPilot Output RangesClick the button More in the DataPilot dialogue. The dialogue will be extended. Select

Chapter 4: Spreadsheets in CalcConsolidating DataDuring consolidation, the contents of the cells from several sheets will be combined in one place. Ch

Chapter 4: Spreadsheets in CalcIf a new sheet, independent from the source areas, should not be created , but retaining links to the source areas or c

Chapter 4: Spreadsheets in CalcApplying Goal SeekWith the help of Goal Seek one can calculate a value that, as part of a formula, leads to the result

Inserting a Draw object in a text document ...402Inserting a Draw object

Chapter 4: Spreadsheets in Calc11.Now enter the formula in E5 using the variables = C*n*i instead of =A5*B5*C5.Start Goal SeekAssume an interest rate

Chapter 4: Spreadsheets in CalcCalculating With One Formula and One Variable1. Open a new spreadsheet for this tutorial.2. To calculate the profit, fi

Chapter 4: Spreadsheets in CalcCalculating with Two VariablesConsider columns A and B of the sample table above. Now try varying not only the quantity

Chapter 4: Spreadsheets in CalcUsing ScenariosScenarios are important aids for making numbers that are dependent on each other and their resulting cal

Chapter 4: Spreadsheets in Calc4. Change any values in the frames to the values that are to apply to the new scenario. In this case, modify the dollar

Chapter 4: Spreadsheets in CalcValidity of Cell ContentsFor each cell the user can define, in advance, what type of contents will be valid for this ce

Chapter 4: Spreadsheets in CalcThe validity rule is a component of the cell format. To copy the validity rule to other cells, choose Edit > Copy an

Chapter 4: Spreadsheets in CalcSample macro:Function Example Validity(CellValue as String, TableCell as String)Dim msg as stringmsg =Invalid value: &a

Chapter 4: Spreadsheets in CalcPrinting or Exporting SpreadsheetsThere are many print options for putting spreadsheets on paper. Another way of distri

Chapter 4: Spreadsheets in CalcPrinting Sheets in Landscape FormatIn order to print a sheet use one of the number of interactive options available und

Copyright and trademark informationThe contents of this Documentation are subject to the Public Documentation License, Version 1.0 (the "License&

Protecting frames, graphics and OLE objects...413Protecting Drawing Objects and Form

Chapter 4: Spreadsheets in CalcThe dialogue shrinks so that more of the sheet can be displayed.3. Select the first two rows and, for example, click ce

Chapter 4: Spreadsheets in CalcSaving and Opening Sheets in HTMLSaving Sheets in HTMLCalc saves all the sheets of a spreadsheet together as one HTML d

Chapter 4: Spreadsheets in Calcformulae and Values as CSV FilesCSV is an acronym for “Comma Separated Values.” CSV-files are pure text files, which co

Chapter 4: Spreadsheets in Calc7. If the CSV file contains formulae as formulae, uncheck formulae (in Tools > Options > OpenOffice.org Calc >

Chapter 4: Spreadsheets in CalcAutoFillCopying text, values and other cell contents to a spreadsheet is very easily using the mouse. Here the user nee

Chapter 4: Spreadsheets in CalcThe dialogue also allows series of dates and times to be automatically filled in. For example, to insert the first date

Chapter 4: Spreadsheets in Calc• While a password can be applied for protecting the sheet and the document, this is not required. However, if a passwo

Chapter 4: Spreadsheets in CalcInserting a note To keep a note, perhaps reminding one to sell a certain share later on, select the relevant cell and c

Chapter 4: Spreadsheets in Calc4. Click in the Styles and Formatting window, and open the context menu and click the New command to activate the Cell

Chapter 4: Spreadsheets in CalcDefining ValidityTo avoid invalid entries in a spreadsheet, define a validity condition. Select the cells to which the

AutoText...423ChangeAllChars

Chapter 4: Spreadsheets in CalcLinking Sheet InformationThe information contained in a schedule can also be used by linking it to the vacation account

Chapter 5: Creating Presentations With ImpressChapter 5: Creating Presentations With ImpressPresentations have more than just drawings and graphics to

Chapter 5: Creating Presentations With ImpressOpenOffice.org Impress Toolbars and Windows®OpenOffice.org User Guide for 2.x 278

Chapter 5: Creating Presentations With ImpressHow to Create a Basic PresentationThe following brief step-by-step example demonstrates different method

Chapter 5: Creating Presentations With ImpressThe Wizard Presentation opens automatically. The first page allows starting with an empty presentation,

Chapter 5: Creating Presentations With Impress4. Page three of the Wizard deals with the slide transition. a) In the first list box select the slide e

Chapter 5: Creating Presentations With Impress7. Click Next. 8. Enter additional text which that should appear in the presentation on page four. OpenO

Chapter 5: Creating Presentations With Impress9. Click Next. The fifth and final page of the Wizard determines the number of the slides needed in the

Chapter 5: Creating Presentations With ImpressCreating a Simple Presentation Without the WizardThis section explains, with the help of a simple exampl

Chapter 5: Creating Presentations With Impress9. Assign an interesting colour or colour gradient to the sphere by way of the list boxes on the object

Chapter 12: Building Forms with Xforms ...435Step-by-Step Procedure...

Chapter 5: Creating Presentations With ImpressTo the left of the horizontal scroll bar in the drawing view, notes view and handout view, see the follo

Chapter 5: Creating Presentations With ImpressIf the context menu of a selected slide is called up, the Show/Hide Slide command will be seen. One can

Chapter 5: Creating Presentations With ImpressEditing PresentationsThis section shows how to use the versatile features of Impress to fine tune a pres

Chapter 5: Creating Presentations With ImpressNote that this modification is only valid for the current presentation document. Switching Page StylesTh

Chapter 5: Creating Presentations With ImpressUsing Outline ViewOne way to create a completely new presentation is in the Outline View mode. All slide

Chapter 5: Creating Presentations With ImpressSlide Transitions, Effects and AnimationWith Impress, grabbing an audience's attention using animat

Chapter 5: Creating Presentations With Impress5. Select the desired effect. 6. Click the Assign icon in the Effects window, or double-click the effect

Chapter 5: Creating Presentations With ImpressA more elegant way to keep individual slides hidden in certain presentations can be found under Presenta

Chapter 5: Creating Presentations With ImpressExporting, Printing and PresentingThere are many possible ways of outputting finished presentation docum

Chapter 5: Creating Presentations With ImpressExporting Presentations as Web PagesWhen the Web Page export file format is chosen, Impress automaticall

Index... ...464Public Document

Chapter 5: Creating Presentations With ImpressIn addition to the export of default HTML documents and HTML documents with frames, Impress documents ca

Chapter 5: Creating Presentations With ImpressCreating a Business ReportThis section explains how to create a business report for a presentation. In t

Chapter 5: Creating Presentations With Impress6. To insert another slide, click the area next to the tab at the bottom of the screen. Assign a name fo

Chapter 5: Creating Presentations With Impress1. Open the Styles and Formatting window by clicking the Styles and Formatting icon in the Formatting to

Chapter 5: Creating Presentations With ImpressCreating a Slide ShowIn completing a slide show, it is necessary to take a few additional steps to ensur

Chapter 5: Creating Presentations With ImpressThis dialogue also lets the user determine which slides to include in the presentation. Select any other

Chapter 5: Creating Presentations With ImpressWorking with ConnectorsIn addition to the individual frames, connectors are important components of an o

Chapter 5: Creating Presentations With Impress"Middle to Middle” ConnectorsIf a connector is selected from the Connectors floating toolbar and cl

Chapter 5: Creating Presentations With ImpressEditing Glue Points By default, the connectors dock to the handles in the centre of the object pages. Ho

Chapter 5: Creating Presentations With ImpressHints and Tips for a Successful PresentationUsing the Mouse as a PointerThere are occasions when using t

Chapter 5: Creating Presentations With ImpressCreating and Printing HandoutsProviding handouts, to help the audience follow a presentation, is often u

Chapter 5: Creating Presentations With ImpressNote: The settings in Printer Tools apply only to the current document. For specific settings for all pr

Chapter 5: Creating Presentations With ImpressKeyboard Navigating and Selection in ImpressNavigating and selection using the keyboard is done using th

Chapter 6: Creating Drawings with DrawChapter 6: Creating Drawings with DrawOpenOffice.org Draw can be used to create drawings with different degrees

Chapter 6: Creating Drawings with DrawExportUse Draw to quickly and easily create buttons and icons for Web pages et cetera and export them as GIF, JP

Chapter 6: Creating Drawings with DrawThe OpenOffice.org Draw WindowToolbars and Windows® in OpenOffice.org DrawThe above graphic shows the various fl

Chapter 6: Creating Drawings with DrawDrawing Rectangles and Ellipses and Entering TextThe drawing module in OpenOffice.org (Draw) has many functions

Chapter 6: Creating Drawings with Draw1. Draw a rectangle on the slide. It has preset attributes, including a blue fill and a thin black line as a bor

Chapter 6: Creating Drawings with DrawRotating and Resizing ObjectsWhen clicking an object for the first time, eight handles appear with which the siz

Chapter 6: Creating Drawings with DrawArranging and Aligning ObjectsArranging ObjectsWhere objects are overlapping and the position of the individual

OverviewOverviewThe OpenOffice.org User's Guide attempts to provide answers to questions about working with OpenOffice.org. It is focused on Open

Chapter 6: Creating Drawings with DrawDrawing Sectors and SegmentsThe Ellipse floating toolbar contains several icons for drawing sectors and segments

Chapter 6: Creating Drawings with DrawEntering TextTo enter a text in a drawing, decide if the text should have a “normal” format as in a text documen

Chapter 6: Creating Drawings with DrawCallouts1. Using the Callouts icon, drag the mouse from where the callout arrow should point, to the point wher

Chapter 6: Creating Drawings with DrawDrawing, Editing and ConvertingCurves and ObjectsWith vector graphics in drawing and presentation documents, des

Chapter 6: Creating Drawings with DrawThe curves, that have been drawn using the above steps, are Bézier curves. The points on a Bézier curve are call

Chapter 6: Creating Drawings with DrawVectorizing BitmapsWith Draw or Impress, transform pixel images, so called bitmaps, into vector drawings. One of

Chapter 6: Creating Drawings with DrawConverting Text Characters to CurvesSometimes one needs to fancy up some text, say for a logo or sign, such that

Chapter 6: Creating Drawings with Draw5. Use the Zoom floating toolbar to enlarge the view. If the black filling of the characters is a distraction du

Chapter 6: Creating Drawings with DrawSelect Modify > Convert > To 3D to generate a three-dimensional object from the two-dimensional object i

Chapter 6: Creating Drawings with Draw• Groups can be converted as long as they contain convertible objects. • Bitmaps will be laid as a texture over

OverviewOpenOffice.org User Guide for 2.x 2

Chapter 6: Creating Drawings with DrawWorking With ObjectsIndividual objects in an impress or draw document can be selected, copied, cut and pasted in

Chapter 6: Creating Drawings with Draw3. Finally, define a colour scheme from bottom to top. Select, for example, a darker yellow for the beginning co

Chapter 6: Creating Drawings with DrawThis new object is a group which consists of the specified number of individual objects. Enter the group by pres

Chapter 6: Creating Drawings with DrawNavigating Between Objects of a GroupUsing the Tab and Shift+Tab keys the user can move forward and backward alo

Chapter 6: Creating Drawings with DrawCombining Objects and Constructing ShapesIn Draw and Impress graphic objects may be combined in different ways.

Chapter 6: Creating Drawings with DrawShapes - MergeThe selected polygons are merged so that they make one object, the surface of which is the sum of

Chapter 6: Creating Drawings with DrawGraphic Objects in Drawings and PresentationsBoth Draw and Impress use a vector graphic format. However, pixel g

Chapter 6: Creating Drawings with Draw4. Open the Text floating toolbar from the Main toolbar and select an option; for example, the Fit Text to Frame

Chapter 6: Creating Drawings with DrawOpenOffice.org User Guide for 2.x 334

Chapter 6: Creating Drawings with DrawWorking With coloursThe object bar has a list box from which to choose the colour for a selected object from a n

Important Features with 2.xImportant Features with 2.xOpen Standards XML File Format (OASIS OpenDocument)Beginning with version 2.0 OpenOffice.org use

Chapter 6: Creating Drawings with DrawDefining Custom coloursAny number of colours can be defined by the user, have names assigned and be saved in col

Chapter 6: Creating Drawings with DrawThe colour models RGB and CMYK are just two of the models most used to define colours. RGB stands for red-green-

Chapter 6: Creating Drawings with DrawReplacing colours using the EyedropperIn Draw and Impress, images inserted in a bitmap format such as, GIF, JPEG

Chapter 6: Creating Drawings with Draw4. Click the left mouse button when the colour is found which is to be replaced. This colour will automatically

Chapter 6: Creating Drawings with DrawGradients and Patterns for Objects and BackgroundThe objects in drawings and presentations do not have to have u

Chapter 6: Creating Drawings with DrawIf the user has selected an object and then defined a new gradient, the new gradient is immediately assigned to

Chapter 6: Creating Drawings with DrawDepending on the type of gradient, one or both of the objects can be moved with the mouse and thus determine the

Chapter 6: Creating Drawings with Draw3D GlobeThis section describes how to create a three-dimensional globe with Draw in just a few steps. When finis

Chapter 6: Creating Drawings with Draw6. Locate the map to be used. If there is a Maps theme, click the it and the Gallery shows the maps.7. Click any

Chapter 6: Creating Drawings with DrawNow the world map can be seen as texture on the sphere. OpenOffice.org has automatically selected the most appro

Important Features with 2.x2. Encryption is compatible with PDF v1.4, only ARCFOUR (RC4 compatible) 128-bit encryption is provided.3. Permissions sett

Chapter 6: Creating Drawings with Draw3D Effects: GeometryBy using this feature, the user can control the manner and quality of how the object surface

Chapter 6: Creating Drawings with Draw3D Effects: IlluminationControl of illumination of a selected 3D object is easily done in a variety of ways. In

Chapter 6: Creating Drawings with DrawDesigning 3D Objects From Font CharactersThe step-by-step methodology described below is particularly useful in

Chapter 6: Creating Drawings with Draw4. Set the font size to about 400 pt. This font size is to provide a usably sized object that, when converted to

Chapter 6: Creating Drawings with DrawThird Step: Select the letter “P” again so that it can then be modified in a different way. Click the Format/ 3D

Chapter 6: Creating Drawings with DrawOpenOffice.org User Guide for 2.x 351

Chapter 6: Creating Drawings with DrawFourth Step:Now add some text to the logo. Start by inserting a text box and populate it with name of the compan

Chapter 6: Creating Drawings with Draw• For a border around the company name, convert it into polygons. Then select a line width greater than 0.00 and

Chapter 6: Creating Drawings with DrawNow there is a perfect 3D logo created with OpenOffice.org in only five steps!Note: that the user can also acces

Chapter 6: Creating Drawings with DrawUsing a GridTo work with great precision, for example to place rectangles one on top of the other, use the grid

Important Features with 2.xNew enhanced Database FeaturesOpenOffice.org always had database frontend tools, but in past versions they were very hidden

Chapter 6: Creating Drawings with DrawMechanical or Construction DrawingsThis section explains how to produce a mechanical drawing with OpenOffice.org

Chapter 6: Creating Drawings with DrawCreating a Construction PlanTo create a drawing like the preceding illustration, click the Rectangle icon and dr

Chapter 6: Creating Drawings with DrawAdd some more details.OpenOffice.org User Guide for 2.x 358

Chapter 6: Creating Drawings with DrawOpenOffice.org User Guide for 2.x 359

Chapter 6: Creating Drawings with DrawComplete the drawing.OpenOffice.org User Guide for 2.x 360

Chapter 6: Creating Drawings with DrawUsing Snap LinesIt is advisable to use snap lines to position lines and objects more precisely. To display a sna

Chapter 6: Creating Drawings with DrawWorking With Multiple LayersThe next step is to position the details in the motor drawing. It is a good idea to

Chapter 6: Creating Drawings with DrawOpenOffice.org User Guide for 2.x 363

Chapter 7: Databases and Data SourcesChapter 7: Databases and Data SourcesVersions of OpenOffice.org Base prior to 2.x required a connection to an ext

Chapter 7: Databases and Data Sources6. Click Save.An OpenOffice.org Base window will open for the new database. At this point, we have created an emp

Important Features with 2.xWordPerfect® FiltersOpenOffice.org 2.0 includes a WordPerfect® filter developed by the open source community. Developers ar

Chapter 7: Databases and Data SourcesStart time Time [TIME] Entry Required = NoEnd date Date [DATE] Entry Required = NoEnd time Time [TIME] Entry Requ

Chapter 7: Databases and Data SourcesTypeName Text [VARCHAR] Entry Required = Yes; Length = 503. Right-click the field selector for the ID field and c

Chapter 7: Databases and Data Sources1. In the database window, click the Forms icon on the left side. 2. Click the Use Wizard to Create Form button.3

Chapter 7: Databases and Data Sources3. If the text box itself is not selected, click away from the text box.4. Double-click the text box for the Star

Chapter 7: Databases and Data SourcesThe new form control might have a different look than the other controls on the form. In the Calendar database, w

Chapter 7: Databases and Data Sources5. On the second screen, Database Field, set the option to Yes, I want to save it in the following database field

Chapter 7: Databases and Data SourcesViewing DataThe database still does not have a convenient way to view the appointments it stores. We could look a

Chapter 7: Databases and Data Sources1. Re-enter form design mode by clicking the Design Mode On/Off button again.2. Click any control on the form.3.

Chapter 7: Databases and Data Sources1. Click the Queries icon on the left side of the database window.2. Click Create Query in Design View.3. The Add

Chapter 7: Databases and Data SourcesThe default type of join is an Inner join, which only returns records where the joined fields are equal. If the T

Important Features with 2.xQuickstarter for *NIX Operating SystemsThe release of OpenOffice.org 2.0.4, now adds quickstart capability to the *NIX rele

Chapter 7: Databases and Data Sources9. In Step 5, Choose layout, Align Left – Modern was chosen for the Layout of data and Generic for Layout of head

Chapter 7: Databases and Data Sources3. Expand the Tables icon by clicking the plus sign next to it.4. Click the icon for the Types table.5. Enter a T

Chapter 7: Databases and Data Sources2. The Form Filter toolbar opens, as does a blank copy of the form. Enter a date in the Start Date field.3. Click

Chapter 7: Databases and Data Sources3. Select the appropriate type from the drop-down. The various types are briefly discussed in the table below.4.

Chapter 7: Databases and Data Sources2. In the Data source box, select the system address book or the data source to use as the address book. If the s

Chapter 7: Databases and Data SourcesOnce the data is in a Calc spreadsheet, it can be edited as desired. Users have two ways of saving the data as an

Chapter 7: Databases and Data SourcesForm DesignForms in OpenOffice.orgIn some situations, a user may want to create a document that contains some fix

Chapter 7: Databases and Data SourcesOnce a control is chosen from the Form Controls toolbar, continue dropping that type of control. To turn off that

Chapter 7: Databases and Data SourcesCustomizing controlsWith some controls, one can simply drop them on a form and use them as is. That works for thi

Chapter 7: Databases and Data SourcesCreating a group of option buttonsOption buttons (also known as radio buttons) let users choose one item from amo

Important Features with 2.xOpenOffice.org User Guide for 2.x 8

Chapter 7: Databases and Data Sources3. In the Form Navigator dialog, right-click the Main Form item and choose Properties.4. Click the Data tab.5. Ma

Chapter 7: Databases and Data Sources2. In the Form Navigator dialog, right-click the Main Form item and choose Properties.3. Click the Events tab.As

Chapter 7: Databases and Data SourcesSearching in Tables and Form Documents In spreadsheets and documents in which form functions are used, one can c

Chapter 7: Databases and Data SourcesThere are various search options, including searching in one field rather than all fields, position of the value

Chapter 7: Databases and Data SourcesCommands OpenOffice.org commandSQL commandMeaning Condition is satisfied if...IS EMPTY IS NULL is null ... The fi

Chapter 7: Databases and Data SourcesCommand/Operator Result='Ms.' returns records with the field content “Ms.”LIKE 'g?ve' returns

Chapter 8: Customizing OpenOffice.orgChapter 8: Customizing OpenOffice.orgUse this section as a guide on customizing the user interface of OpenOffice.

Chapter 8: Customizing OpenOffice.orgNow, by pressing the F4 key or whatever shortcut keys were selected, one can start a spelling check of the curren

Chapter 8: Customizing OpenOffice.org5. Locate in the Functions menu, the category and function to add. In this case this would be found in the catego

Chapter 8: Customizing OpenOffice.org8. Again for Windows® only, to remove an icon from a toolbar, drag it out of the toolbar while keeping the Alt ke

Chapter 1: Using OpenOffice.org HelpChapter 1: Using OpenOffice.org HelpDifferent kinds of help are available in OpenOffice.org.● Step-by-step instruc

Chapter 8: Customizing OpenOffice.orgChanging the Look of the User InterfaceOpenOffice.org has different ways of display that reflect different operat

Chapter 8: Customizing OpenOffice.orgSending Faxes and Configuring OpenOffice.org for FaxingTo send a fax directly from OpenOffice.org, both a fax mod

Chapter 8: Customizing OpenOffice.orgSending a Fax via dialoguePrint the current document with the fax machine as a printer:1. Open the Print dialogue

Chapter 9: Advanced TechniquesChapter 9: Advanced TechniquesThis contains topics of interest to advanced users of OpenOffice.org including information

Chapter 9: Advanced Techniques• Drag the object into the document or right-click to open the context menu and select Insert and Copy.Inserting an obje

Chapter 9: Advanced Techniques• Display the Gallery theme to which to add the graphic.• Position the mouse pointer above the graphic, without clickin

Chapter 9: Advanced Techniques6. Insert the draw object at the target position by using Ctrl+V or use the Paste command from the context menu.Insertin

Chapter 9: Advanced TechniquesInserting a Draw object in a spreadsheetAn inserted draw object is anchored to a spreadsheet in the current cell. Change

Chapter 9: Advanced TechniquesDrag and Drop With the Data Source ViewThe simplest and quickest way of transferring data from a data source into a text

Chapter 9: Advanced TechniquesCopying Sheet Areas to Text Documents• Open both the text document and the spreadsheet. • Select the sheet area to copy.

Chapter 1: Using OpenOffice.org HelpOpenOffice.org Help is context-sensitive. This means that, when Help is opened in Writer it is specific to Writer.

Chapter 9: Advanced Techniques• In a text document use File > Send > Outline to presentation to create an new presentation document that contain

Chapter 9: Advanced TechniquesRevision Marking FunctionThe revision marking function in Writer and Calc highlights changes to documents so that whomev

Chapter 9: Advanced TechniquesAccepting or Rejecting ChangesWhen bringing a document in which others have noted their changes back together again, the

Chapter 9: Advanced TechniquesComparing Versions of a DocumentPerhaps one of the authors who received a copy of the document made changes but did not

Chapter 9: Advanced TechniquesChanges in a spreadsheet document are highlighted by a border around the cells; when a cell is pointed to more detailed

Chapter 9: Advanced TechniquesProtecting Contents in OpenOffice.orgThe following is an overview of the different ways of protecting contents in OpenOf

Chapter 9: Advanced TechniquesNote: Cell protection for cells , setting the Protected attribute, is only effective when the whole table is protected.

Chapter 9: Advanced TechniquesAutomatic Protection of Indexes and TablesTables of contents, alphabetical indexes and so on that are created automatica

Chapter 9: Advanced TechniquesProtecting RecordsChanges made in a document can be recorded by choosing either Edit > Changes > Record or Edit &g

Chapter 9: Advanced TechniquesSelf-signed certificatesThese are user created using certificate creation tools. The following list provides some that a

Chapter 1: Using OpenOffice.org HelpTurning the Help Agent on and off1. Choose Tools > Options > OpenOffice.org > General > Help Agent to

Chapter 9: Advanced TechniquesChanging Defaults and Other Configuration ItemsSaving Configuration With DocumentUsers can set a global configuration (s

Chapter 9: Advanced TechniquesDouble-click the ruler to open the Paragraph dialogue.Double-click the white area of the ruler to set one tab. The Parag

Chapter 9: Advanced TechniquesChanging the colour of TextClick the Font colour icon in Writer and other modules, and keep the mouse button pressed to

Chapter 9: Advanced TechniquesMore on TemplatesChanging Default TemplatesWhen a new document is opened using File > New, a blank document appears b

Chapter 9: Advanced TechniquesNew templates saved using File > Templates > Save or by selecting the “Template” file type in the “normal” Save di

Chapter 10: Introducing OpenOffice.org Basic and MacrosChapter 10: Introducing OpenOffice.org Basic and MacrosOpenOffice.org provides a number of samp

Chapter 10: Introducing OpenOffice.org Basic and MacrosEditing the Sample Macros1. Select Tools > Macros > Organize Macros > OpenOffice.org B

Chapter 10: Introducing OpenOffice.org Basic and MacrosThe Sample MacrosThe following sample macros are in the Gimmicks module.AutoTextUse the Main ma

Chapter 11: Using OpenOffice.org MathChapter 11: Using OpenOffice.org MathFormula EntryMain View of OpenOffice Formula.Tool barThe tool bar is divided

Chapter 11: Using OpenOffice.org MathThe upper part is for adjusting the on screen size of the image. The lower part contains an icon for an interacti

Chapter 1: Using OpenOffice.org HelpOpenOffice.org User Guide for 2.x 12

Chapter 11: Using OpenOffice.org MathThe command dialogue box displays the commands that create the equation. The dialogue box can be edited directly.

Chapter 11: Using OpenOffice.org MathSpecial FormatingOf course there are many other types of groupings that can be created with Open Office. Exponent

Chapter 11: Using OpenOffice.org MathUnder brace / Over brace:Command Input Field Formula+ 18 underbrace plus - ( 1 + 2 + 3 + 4) underbrace minus18p

Chapter 11: Using OpenOffice.org MathSpecial CharactersMany equations use special characters in addition to the usual characters of the alphabet. Open

Chapter 11: Using OpenOffice.org MathSpecial OperatorsThe following examples show the use of some special operatorsIntegral Sign:Command Input Field F

Chapter 11: Using OpenOffice.org MathVectors and MatricesVectors and Matrices are created by the 'stack' and 'matrix' commands res

Chapter 11: Using OpenOffice.org MathFormattingThere are some additional formating commands that are available in Open Office Formula. These allow adj

Chapter 11: Using OpenOffice.org MathAlignmentThe alignment commands are available to change the position of the elements of an equation with respect

Chapter 11: Using OpenOffice.org MathExamplesNow for the complicated examples:Command Input Field Formulanroot{4}{nroot {3} {1 over 3+x^2} } 4313x2

Chapter 12: Building Forms with Xforms Chapter 12: Building Forms with Xforms OpenOffice.org 2.0 now allows to create forms based on the open W3C XFor

Chapter 2: Working With OpenOffice.orgChapter 2: Working With OpenOffice.orgOpenOffice.org is reasonably intuitive but is sufficiently different to ot

Chapter 12: Building Forms with Xforms 2. Then Use View > Toolbars and ensure that the Form Control and Form Design bars are checked.Users may dock

Chapter 12: Building Forms with Xforms 3. Ensure that Data Navigator is enabled as shown below.4. Edit the form and add text boxes for those fields th

Chapter 12: Building Forms with Xforms 5. Select one of the text boxes and right-click to bring up the context menu. Select Control.OpenOffice.org Use

Chapter 12: Building Forms with Xforms 6. Adf fixOpenOffice.org User Guide for 2.x 439

Chapter 12: Building Forms with Xforms 7. Use the Data Navigator that was mentioned earlier. Under the "Bindings" tab the defined bindings s

Chapter 12: Building Forms with Xforms 8. In this dialogue, select the settings needed. For this example, these are Decimal as the Data Type and that

Chapter 12: Building Forms with Xforms 9. Now deselect Design mode so that the form may be tested in Run mode.10. Enter data in the fields. Note in th

Chapter 12: Building Forms with Xforms 11. Because one usually wants to do something with the data from the form, it is important to add a "Submi

Chapter 12: Building Forms with Xforms 13. Toggle Design On/Off to Off and test.14. This graphic shows the content of the submit as stored in the file

Chapter 12: Building Forms with Xforms Using Xforms and further xml processing can thus produce very usable reports et cetera.OpenOffice.org User Guid

Chapter 2: Working With OpenOffice.orgThe OpenOffice.org Writer WindowA text document is displayed and edited in the Writer window. Spreadsheet, prese

Chapter 13: Xml EnhancementsChapter 13: Xml EnhancementsThis section contains hints and tips for using Tools > XML Filter Settings to create new fi

Chapter 13: Xml Enhancements4.OpenOffice.org User Guide for 2.x 447

Chapter 13: Xml EnhancementsOpenOffice.org User Guide for 2.x 448

Chapter 13: Xml Enhancements5. Test the filter using the current document. BA display will open that provides output similar to the following:<?xm

Chapter 13: Xml Enhancements<xsl:strip-space elements="*"/><xsl:template match="/"> <xsl:copy-of select=".&qu

Chapter 13: Xml EnhancementsCreating a new Docbook Filter• Go to Tools > XML Filter Settings...• Set Filter Name and Name of File Type to DocBook (

Chapter 14: Troubleshooting Common ProblemsChapter 14: Troubleshooting Common ProblemsError Message contains “Get Storage: "No Content"”The

Chapter 14: Troubleshooting Common ProblemsNote: that there may be files called Common.xcu under paths such as C:\<some path>\.OpenOffice.org<

Chapter 14: Troubleshooting Common ProblemsHow get the page count to not count a title page? Or How do I offset the page count?If one has a title page

Chapter 14: Troubleshooting Common ProblemsWhat to to do with a General error General input/output error This error message indicates that the files s

Chapter 2: Working With OpenOffice.orgThe Menu BarAt the top of the OpenOffice.org window, immediately under the title bar, is the menu bar. Point wit

Chapter 14: Troubleshooting Common Problems8. Rename the new zipfile with the extension used with the original file.9. Open the new file in Openoffice

Chapter 14: Troubleshooting Common ProblemsThe JMF provides the framework for rendering media in OpenOffice.org. Out-of-the-box, it supports only a li

Chapter 14: Troubleshooting Common Problems2. Edit the soffice executable that is used to invoke OpenOffice.org (maybe /opt/openoffice.org2.0/program/

Chapter 14: Troubleshooting Common ProblemsInstallation of an additional Plugins: The mp3-PluginThe JMF supported some medium types, many must be re-t

Chapter 14: Troubleshooting Common ProblemsTime for the second testAfter you OpenOffice.org to havIntegration of the Plugins in OpenOffice.orge again

Chapter 14: Troubleshooting Common Problemsaudio/ogg>ogg Add the following entries in the rider “Plugins” under “Demultiplexer”net.sourceforge.jff

Chapter 14: Troubleshooting Common ProblemsWhat to do if it fails?Only no panic, the problem can be surely solved. Turn to our mailing list users@open

Chapter 14: Troubleshooting Common ProblemsOpenOffice.org User Guide for 2.x 463

IndexIndexThis index is a work in progress and page numbers may or may not be correct in the draft. They are a guide only.11/2 replacement...

Indexautomatic bullets...128automatic captions...129,

Modifications and updatesVersion Date Description of Change[0.9] [2005-11-11] [grs: 9th draft issued for comment – switched to master doc, stewart&apo

Chapter 2: Working With OpenOffice.orgSome icons have small triangles to indicate that there are more functions available. These are called floating t

IndexHimalayan...121Persian...121s

Indexturning on and off...32, 96, 171while typing...iii, vii, xi, 32, 33, 96, 171choosin

IndexEuro converter...211PostScript,UNIX...294, 397c

IndexdBase...240, 246, 247, 248, 365, 366, 378, 379, 380, 381default filters...243, 244, 248, 377Designing Labels

Indexdirect formatting...applying...

IndexTtree...bark...

IndexPublic Documentation License, Version 1.01.0 DEFINITIONS. 1.1. "Commercial Use" means distribution or otherwise making the Documentatio

Public Documentation License, Version 1.0All Documentation to which You contribute must identify the changes You made to create that Documentation and

Public Documentation License, Version 1.0This License represents the complete agreement concerning the subject matter hereof. If any provision of this

Chapter 2: Working With OpenOffice.orgUsing Floating ToolbarsWhen editing a text document, the Insert icon is in the Tools toolbar. Do a long click on

Chapter 2: Working With OpenOffice.orgUnhideHideClick the arrow button to hide a window.LockClick this button to lock a floating window.FloatingClick

Chapter 2: Working With OpenOffice.orgOpening and Saving DocumentsThere are multiple methods of loading or opening documents. For example, by using th

Chapter 2: Working With OpenOffice.orgthe File name pull-down list and press Enter. If *.txt, for example, is used only the files having .txt at the e

Chapter 2: Working With OpenOffice.org• My Documents - A quick route to the documents in a work directory. A work directory may be defined by selectin

Chapter 2: Working With OpenOffice.orgSaving DocumentsSaving the current document can be done in three ways, using File > Save command, the Save Do

Chapter 2: Working With OpenOffice.orgChanging the Work DirectoryWhen the Open dialogue comes up, the work directory is displayed. The user can change

Chapter 2: Working With OpenOffice.orgOpenOffice.org File FormatsOpenOffice.org uses an XML file format as the default for saving and opening document

Chapter 2: Working With OpenOffice.orgOpenOffice.org XML file structureThe OpenOffice.org XML file formats follow the OASIS OpenDocument standard and

Chapter 2: Working With OpenOffice.orgAdditional files can be contained in the packed file format. For example, Graphics can be found in the Pictures

Chapter 2: Working With OpenOffice.orgSending Documents as E-MailSingle MessagesWorking in OpenOffice.org, one can send the current document as an e-m

Chapter 2: Working With OpenOffice.orgPrinting DocumentsUpon creating a document, normally one will want to print it out on paper for distribution.Pri

Chapter 2: Working With OpenOffice.orgNote: There are many different printers with widely varying properties. The printing functions differ according

Chapter 2: Working With OpenOffice.orgReduced Printing of DocumentsTo get a reduced printout of a text document, choose File > Page Preview. Here,

Chapter 2: Working With OpenOffice.orgPrinting only text in black and whiteIn Writer, the user can choose to print colour-formatted text in black and

Chapter 2: Working With OpenOffice.org(a) If the printer is capable of duplex printing, choose Left and Right pages and brochure.(b) With a single sid

Chapter 2: Working With OpenOffice.orgUsers can create any number of custom/user dictionaries. Create a user dictionary by selecting Tools > Option

Chapter 2: Working With OpenOffice.orgSelect the language of an entire text document with Tools > Options > Language Settings > Languages. If

Chapter 2: Working With OpenOffice.orgExcluding Text From the SpellcheckIf certain areas, words or tables should not be spell checked because they are

ContentsOverview... ...1Using the

Chapter 2: Working With OpenOffice.org3. Click the big button in the middle of the document page to start the installation process:OpenOffice.org User

Chapter 2: Working With OpenOffice.org4. The following dialogue opens to begin the selection of the needed components:5. Click Next6. Click “Retrieve

Chapter 2: Working With OpenOffice.org7. Click Next and select the Hyphenation dictionaries needed and click Next when done:8. Click Next and select t

Chapter 2: Working With OpenOffice.org9. Clicking Next, starts the download and installation of the items selected in the previous steps. OpenOffice.o

Chapter 2: Working With OpenOffice.orgUsing Automatic FunctionsOpenOffice.org has all kinds of intelligent assistants to help, all of which have names

Chapter 2: Working With OpenOffice.orgThe following graphic shows the various functions available in this dialogue. A detailed explanation of each fun

Chapter 2: Working With OpenOffice.orgTurning off URL Recognition by AutoCorrectWhen text is entered,OpenOffice.org automatically recognizes a word th

Chapter 2: Working With OpenOffice.org• Assuming the Replace option is enabled to automatically start each sentence with a capital (uppercase) letter,

Chapter 2: Working With OpenOffice.orgCreating a Letter Template With the WizardIf one is writing a personal letter, the Wizard and standard AutoTexts

Chapter 2: Working With OpenOffice.orgFind & ReplaceWhen working with a computer it is often useful to be able to locate certain pieces of text qu

Help Agent...10Turning th

Chapter 2: Working With OpenOffice.orgThe Find & Replace dialogue can remain open without interfering with text entry and it can be moved to any p

Chapter 2: Working With OpenOffice.org• A paragraph end can be found with the dollar sign ($), and the first character at the beginning of a paragraph

Chapter 2: Working With OpenOffice.orgSearching for Special Formats By clicking the Format button, one opens a dialogue from which to select the speci

Chapter 2: Working With OpenOffice.orgCharacter Result/Use\n Finds a hard row break that was inserted with Shift+Enter. To change row breaks into para

Chapter 2: Working With OpenOffice.orgNote: The longest possible text within the paragraph is always found. If the paragraph contains the text “AX4 A4

Chapter 2: Working With OpenOffice.orgDigital Signatures and Printing or Exporting DocumentsThere are many print options for putting documents on pape

Chapter 2: Working With OpenOffice.org● create a PDF document that can be opened only with the correct password, but with restricted permissions; for

Chapter 2: Working With OpenOffice.orgOnly “open password”, no restrictionTo create a PDF document that can be opened by users having the correct pass

Chapter 2: Working With OpenOffice.orgThe “Not permitted” selection will disable all the changes (but copy, see Enable copy).Enable copyPoint (8) in .

Chapter 2: Working With OpenOffice.orgName Type Default valueNotesEncryptFileboolean false specifies that the PDF document should be encrypted while e

Displaying Print Previews...29Reduced Printing of Doc

Chapter 2: Working With OpenOffice.orgName Type Default valueNotespaste elsewhere).It corresponds to item (8) in .EnableTextAccessForAccessibilityTool

Chapter 3: Managing Text Documents With Writer Chapter 3: Managing Text Documents With Writer In this chapter, the user will learn about the OpenOffic

Chapter 3: Managing Text Documents With Writer Desktop Publishing with OpenOffice.org WriterOpenOffice.org Writer contains numerous functions to assis

Chapter 3: Managing Text Documents With Writer The OpenOffice.org Writer WindowWindows® of OpenOffice.org WriterThe above graphic shows the various wi

Chapter 3: Managing Text Documents With Writer Entering and Formatting TextThere is no prescribed sequence in which to work. One can enter text and, l

Chapter 3: Managing Text Documents With Writer Insert mode is enabled by default, thus any text, following the insertion point, is shifted as new text

Chapter 3: Managing Text Documents With Writer Centre Align Right3.Enter the text. OpenOffice.org automatically inserts the requisite number of blank

Chapter 3: Managing Text Documents With Writer 4. Release the mouse button and the Ctrl key.5. Repeat steps 1 to 4 for each piece of text to be delete

Chapter 3: Managing Text Documents With Writer The Paragraph Style dialogue opens, with various tabs. Click on the Font tab and specify the type, size

Chapter 3: Managing Text Documents With Writer • If a special character is required in any text input field (such as in the URL field of the Standard