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 minus18p
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} } 4313x2
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
Commentaires sur ces manuels