Getting Started with OpenOffice.org 3.
Copyright This document is Copyright © 2005–2010 by its contributors as listed below. You may distribute it and/or modify it under the terms of either the GNU General Public License (http://www.gnu.org/licenses/gpl.html), version 3 or later, or the Creative Commons Attribution License (http://creativecommons.org/licenses/by/3.0/), version 3.0 or later.
Contents Chapter 1 Introducing OpenOffice.org......................................................................................... 9 What is OpenOffice.org?.......................................................................................... 10 The advantages of OpenOffice.org...........................................................................11 Minimum requirements........................................................................................... 12 How to get the software..........
Setting a default template....................................................................................... 70 Associating a document with a different template..................................................71 Organizing templates............................................................................................... 72 Examples of style use............................................................................................... 73 Chapter 4 Getting Started with Writer..................
Using conditional formatting.................................................................................134 Hiding and showing data....................................................................................... 134 Sorting records...................................................................................................... 136 Printing..................................................................................................................
Creating database tables....................................................................................... 205 Defining relationships............................................................................................ 213 Creating a database form...................................................................................... 215 Accessing other data sources................................................................................229 Using data sources in OpenOffice.org..............
Chapter 13 Getting Started with Macros................................................................................... 322 Your first macros.................................................................................................... 323 Creating a macro................................................................................................... 328 Sometimes the macro recorder fails......................................................................332 Macro organization..................
1 Chapter Introducing OpenOffice.
What is OpenOffice.org? OpenOffice.org (OOo) is both a software product and a community of volunteers who produce and support the software. Note Because someone else owns the trademark OpenOffice, the correct name for both the open-source project and its software is OpenOffice.org. The OpenOffice.org software is a freely available, full-featured office productivity suite. If you have used previous versions of OpenOffice.org, you might want to look over the new features lists at http://www.openoffice.
own connection points. You can use Draw to create drawings for use in any of OOo’s other components, and you can create your own clip art and add it to the Gallery. Draw can import graphics from many common formats and save them in over 20 formats, including PNG, HTML, PDF, and Flash. Base (database) Base provides tools for day-to-day database work within a simple interface.
– You do not need to know which application was used to create a particular file. For example, you can open a Draw file from Writer. • Granularity. Usually, if you change an option, it affects all components . However, OOo options can be set at a component level or even document level. • File compatibility.
connected with, nor endorsed by, OpenOffice.org. http://distribution.openoffice.org/cdrom/sellers.html How to install the software Information on installing and setting up OpenOffice.org on the various supported operating systems is given here: http://download.openoffice.org/common/instructions.html. You can also download the more detailed Installation Guide from http://wiki.services.openoffice.org/wiki/Documentation. Extensions and add-ons Extensions and add-ons to enhance OpenOffice.
Free OpenOffice.org support Documentation Project Templates, user guides, how-tos, and other documentation. http://documentation.openoffice.org/ See also the Documentation wiki, http://wiki.services.openoffice.org/wiki/Documentation Native Language Project Information, resources, and mail lists in your language. http://projects.openoffice.org/native-lang.html Mac Support Support for installing and using OOo on Mac OS X. http://porting.openoffice.org/mac/index.html OpenOffice.
Note for Windows users If you have associated Microsoft Office file types with OOo, then when you doubleclick on a *.doc (Word) file, it opens in Writer; *.xls (Excel) files open in Calc, and *.ppt (PowerPoint) files open in Impress. If you did not associate the file types, then when you double-click on a Microsoft Word document, it opens in Microsoft Word (if Word is installed on your computer), Excel files open in Excel, and PowerPoint files open in PowerPoint.
Disabling the Quickstarter To close the Quickstarter, right-click on the icon in the system tray, and then click Exit Quickstarter on the pop-up menu. The next time the computer is restarted, the Quickstarter will be loaded again. To prevent OpenOffice.org from loading during system startup, deselect the Load OpenOffice.org during system start-up item on the pop-up menu. You might want to do this if your computer has insufficient memory, for example.
Type of document Component Command-line option Text Writer -writer Spreadsheet Calc -calc Drawing Draw -draw Presentation Impress -impress Formula Math -math Database Base -base Web page Writer -web To see a list of options you can use when starting Writer at the command line in Windows, type: soffice -? Below is a list of some of the more popular options. Option Description -help Get a complete list of options. -nologo Do not show the startup screen.
• File contains commands that apply to the entire document such as Open, Save, and Export as PDF. • Edit contains commands for editing the document such as Undo: xxx (where xxx is the command to undo) and Find & Replace. It also contains commands to cut, copy, and paste selected parts of your document. • View contains commands for controlling the display of the document such as Zoom and Web Layout. • Insert contains commands for inserting elements into your document such as Header, Footer, and Picture.
Figure 2: Example of a tear-off toolbar Moving toolbars To move a docked toolbar, place the mouse pointer over the toolbar handle (the small vertical bar to the left of the toolbar), hold down the left mouse button, drag the toolbar to the new location, and then release the mouse button (Figure 3). To move a floating toolbar, click on its title bar and drag it to a new location (Figure 4).
Docking/floating windows and toolbars Toolbars and some windows, such as the Navigator and the Styles and Formatting window, are dockable. You can move, resize, or dock them to an edge. To dock a window or toolbar, hold down the Control key and double-click on the frame of the floating window (or in a vacant area near the icons at the top of the floating window) to dock it in its last position.
Status bar The status bar is located at the bottom of the workspace. It provides information about the document and convenient ways to quickly change some features. It is similar in Writer, Calc, Impress, and Draw, although each component includes some component-specific items. Figure 7: Left end of status bar in Writer Figure 8: Right end of status bar in Writer Common status bar items are described below.
What are all these things called? The terms used in OpenOffice.org for most parts of the user interface (the parts of the program you see and use, in contrast to the behind-the-scenes code that actually makes it work) are the same as for most other programs. A dialog is a special type of window. Its purpose is to inform you of something, or request input from you, or both. It provides controls for you to use to specify how to carry out an action.
Starting a new document You can start a new, blank document in OOo in several ways. When OOo is open but no document is open (for example if you close all the open documents but leave the program running), the Start Center is shown. Click one of the icons to open a new document of that type, or click the Templates icon to start a new document using a template. Figure 10: OpenOffice.org Start Center You can also start a new document in one of the following ways.
You can also open an existing document in one of the following ways. • Choose File > Open... • Click the Open button on the main toolbar. • Press Control+O on the keyboard. In each case, the Open dialog appears. Select the file you want, and then click Open. If a document is already open in OOo, the second document opens in a new window. In the Open dialog, you can reduce the list of files by selecting the type of file you are looking for.
match, you receive an error message. Close the message box to return to the Set Password dialog box and enter the password again. Caution OOo uses a very strong encryption mechanism that makes it almost impossible to recover the contents of a document in case you lose the password. Figure 11: Entering a password for a document Writer and Calc provide a second level of protection, which allows a file to be viewed but not changed without a password; that is, the file opens in read-only mode.
This section discusses the OpenOffice.org Open and Save As dialogs. Figure 12 shows the Save As dialog; the Open dialog is similar. Figure 12: The OpenOffice.org Save As dialog The three buttons in the top right of the OOo Open and Save As dialogs are, from left to right: • Go Up One Level in the folder (directory) hierarchy.
Using the Navigator The Navigator lists objects contained in a document, collected into categories. For example, in Writer it shows Headings, Tables, Text frames, Comments, Graphics, Bookmarks, and other items, as shown in Figure 13. In Calc it shows Sheets, Range Names, Database Ranges, Graphics, Drawing Objects, and other items. In Impress and Draw it shows Slides, Pictures, and other items.
• Click the Navigation icon (second icon from the left at the top of the Navigator) to display the Navigation toolbar. Here you can pick one of the categories and use the Previous and Next icons to move from one item to the next. This is particularly helpful for finding items like bookmarks and indexes, which can be difficult to see. The names of the icons (shown in the tooltips) change to match the selected category; for example, Next Graphic or Next Bookmark.
Figure 16: List of actions that can be undone After changes have been undone, Redo becomes active. To redo a change, select Edit > Redo, or press Control+Y or click on the Redo icon . As with Undo, click on the triangle to the right of the arrow to get a list of the changes that can be reapplied. To modify the number of changes OpenOffice.org remembers, choose Tools > Options > OpenOffice.org > Memory and in the Undo section change Number of steps.
Caution Not saving your document could result in the loss of recently made changes, or worse still, your entire file. Closing OpenOffice.org To close OOo completely, choose File > Exit, or close the last open document as described in “Closing a document” above. If all the documents have been saved, OOo closes immediately. If any documents have been modified but not saved, a warning message appears. Follow the procedure in “Closing a document” to save or discard your changes. Using OpenOffice.
2 Chapter Setting up OpenOffice.
Choosing options for all of OOo This section covers some of the settings that apply to all the components of OpenOffice.org. For information on settings not discussed here, see the online help. Click Tools > Options. The list in the left-hand box of the Options – OpenOffice.org dialog varies depending on which component of OOo is open. The illustrations in this chapter show the list as it appears when a Writer document is open. Click the marker (+ or triangle) by OpenOffice.org on the left-hand side.
Figure 19: Filling in user data General options The options on the OpenOffice.org – General page are described below. Figure 20: Setting general options for OpenOffice.org Help - Tips When Tips is active, one or two words will appear when you hold the mouse pointer over an icon or field, without clicking. Help - Extended tips When Extended tips is active, a brief description of the function of a particular icon or menu command or a field on a dialog appears when you hold the mouse pointer over that item.
Help formatting High contrast is an operating system setting that changes the system color scheme to improve readability. To display Help in high contrast (if your computer’s operating system supports this), choose one of the high-contrast style sheets from the pull-down list.
even when not being used. This option (sometimes called Enable systray quickstarter) is not available on all operating systems. Figure 21: Choosing Memory options for the OpenOffice.org applications View options The options on the OpenOffice.org – View page affect the way the document window looks and behaves. Some of these options are described below. Set them to suit your personal preferences.
User Interface – Icon size and style The first box specifies the display size of toolbar icons (Automatic, Small, or Large). The Automatic icon size option uses the setting for your operating system. The second box specifies the icon style (theme); here the Automatic option uses an icon set compatible with your operating system and choice of desktop: for example, KDE or Gnome on Linux.
Mouse positioning Specifies if and how the mouse pointer will be positioned in newly opened dialogs. Middle mouse button Defines the function of the middle mouse button. • Automatic scrolling – dragging while pressing the middle mouse button shifts the view. • Paste clipboard – pressing the middle mouse button inserts the contents of the “Selection clipboard” at the cursor position.
Figure 24: Choosing general printing options to apply to all OOo components Path options On the OpenOffice.org – Paths page, you can change the location of files associated with, or used by, OpenOffice.org to suit your working situation. In a Windows system, for example, you might want to store documents by default somewhere other than My Documents. To make changes, select an item in the list shown in Figure 25 and click Edit.
Figure 25: Viewing the paths of files used by OpenOffice.org Color options On the OpenOffice.org – Colors page, you can specify colors to use in OOo documents. You can select a color from a color table, edit an existing color, and define new colors. These colors are stored in your color palette and are then available in all components of OOo. Figure 26: Defining colors to use in color palettes in OOo Chapter 2 Setting up OpenOffice.
To modify a color: 1) Select the color to modify from the list or the color table. 2) Enter the new values that define the color. If necessary, change the settings from RGB (Red, Green, Blue) to CMYK (Cyan, Magenta, Yellow, Black) or vice versa. The changed color appears in the lower of the two color preview boxes at the top. 3) Modify the Name as required. 4) Click the Modify button. The newly defined color is now listed in the Color table.
Font options You can define replacements for any fonts that might appear in your documents. If you receive from someone else a document containing fonts that you do not have on your system, OpenOffice.org will substitute fonts for those it does not find. You might prefer to specify a different font from the one the program chooses. Figure 28: Defining a font to be substituted for another font On the OpenOffice.org – Fonts page: 1) Select the Apply Replacement Table option.
Figure 29: Choosing security options for opening and saving documents Security options and warnings If you record changes, save multiple versions, or include hidden information or notes in your documents, and you do not want some of the recipients to see that information, you can set warnings to remind you to remove it, or you can have OOo remove some of it automatically. Note that (unless removed) much of this information is retained in a file whether the file is in OpenOffice.
Figure 30: Security options and warnings dialog Appearance options Writing, editing, and (especially) page layout are often easier when you can see the page margins (text boundaries), the boundaries of tables and sections (in Writer documents), page breaks in Calc, grid lines in Draw or Writer, and other features. In addition, you might prefer to use colors that are different from OOo’s defaults for such items as note indicators or field shadings. On the OpenOffice.
• To show or hide items such as text boundaries, select or deselect the options next to the names of the items. • To change the default colors for items, click the down-arrow in the Color Setting column by the name of the item and select a color from the pop-up box. • To save your color changes as a color scheme, click Save, type a name in the Scheme box; then click OK.
Figure 33: Choosing a Java runtime environment Online Update options On the OpenOffice.org – Online Update page, you can choose whether and how often to have OOo check the OOo website for program updates. If the Check for updates automatically option is selected, an icon appears at the right-hand end of the menu bar when an update is available. Click this icon to open a dialog where you can choose to download the update.
Improvement program On the OpenOffice.org – Improvement Program page, you can choose whether or not to participate in the OpenOffice.org Improvement Program, which collects anonymous statistics about how you use OOo. Choosing options for loading and saving documents You can set the Load/Save options to suit the way you work. If the Options dialog is not already open, click Tools > Options. Click the expansion symbol (+ or triangle) to the left of Load/Save.
document settings are overruled by the user-specific settings of the person who opens it. If you deselect this option, the user’s personal settings do not overrule the settings in the document. For example, your choice (in the options for OOo Writer) of how to update links is affected by the Load user-specific settings option.
VBA Properties Load/Save options On the Load/Save – VBA Properties page, you can choose whether to keep any macros in Microsoft Office documents that are opened in OpenOffice.org. Figure 37: Choosing Load/Save VBA Properties • If you choose Save original Basic code, the macros will not work in OOo but are retained if you save the file into Microsoft Office format.
Figure 38: Choosing Load/Save Microsoft Office options HTML compatibility Load/Save options Choices made on the Load/Save – HTML Compatibility page affect HTML pages imported into OpenOffice.org and those exported from OOo. See HTML documents; importing/exporting in the Help for more information. Font sizes Use these fields to define the respective font sizes for the HTML to tags, if they are used in the HTML pages. (Many pages no longer use these tags.) Figure 39.
Import - Use 'English (USA)' locale for numbers When importing numbers from an HTML page, the decimal and thousands separator characters differ according to the locale of the HTML page. The clipboard, however, contains no information about the locale. If this option is not selected, numbers will be interpreted according to the Language - Locale setting in Tools > Options > Language Settings > Languages (see page 51). If this option is selected, numbers will be interpreted as for the English (USA) locale.
Choosing language settings You may need to do several things to set the language settings to what you want: • Install the required dictionaries • Change some locale and language settings • Choose spelling options Install the required dictionaries OOo automatically installs several dictionaries with the program. To add other dictionaries, be sure you are connected to the Internet, and then use Tools > Language > More Dictionaries Online.
Figure 41: Choosing language options If necessary, select the options to enable support for Asian languages (Chinese, Japanese, Korean) and support for CTL (complex text layout) languages such as Urdu, Thai, Hebrew, and Arabic. If you choose either of these options, the next time you open this dialog, you will see some extra choices under Language Settings, as shown below. These choices (Searching in Japanese, Asian Layout, and Complex Text Layout) are not discussed here.
Figure 43: Choosing languages, dictionaries, and options for checking spelling Here you can also check which user-defined (custom) dictionaries are active by default, and add or remove dictionaries, by clicking the New or Delete buttons. Note OpenOffice.org does not have a grammar checker, but you can install a grammar checker extension such as Language Tool and access that tool from Tools > Spelling and Grammar. See Chapter 14 for more about installing extensions.
Figure 44: Internet options, showing E-mail page available to Linux users. Controlling OOo’s AutoCorrect functions Some people find some or all of the items in OOo’s AutoCorrect function annoying because they change what you type when you do not want it changed. Many people find some of the AutoCorrect functions quite helpful; if you do, then select the relevant options. But if you find unexplained changes appearing in your document, this is a good place to look to find the cause.
3 Chapter Using Styles and Templates 55
What is a template? A template is a model that you use to create other documents. For example, you can create a template for business reports that has your company’s logo on the first page. New documents created from this template will all have your company’s logo on the first page.
• Numbering styles apply similar alignment, numbering or bullet characters, and fonts to numbered or bulleted lists. • Cell styles include fonts, alignment, borders, background, number formats (for example, currency, date, number), and cell protection. • Graphics styles in drawings and presentations include line, area, shadowing, transparency, font, connectors, dimensioning, and other attributes. • Presentation styles include attributes for font, indents, spacing, alignment, and tabs.
Tip At the bottom of the Styles and Formatting window is a dropdown list. In Figure 46 the window shows Automatic, meaning the list includes only styles applied automatically by OOo. You can choose to show all styles or other groups of styles, for example only custom styles.
You can open this list and click once on the style you want, or you can use the up and down arrow keys to move through the list and then press Enter to apply the highlighted style. Tip Select More... at the bottom of the list to open the Styles and Formatting window. Figure 47: The Apply Style list on the Formatting toolbar Using keyboard shortcuts Some keyboard shortcuts for applying styles are predefined.
Changing a style using the Style dialog To change an existing style using the Style dialog, right-click on the required style in the Styles and Formatting window and select Modify from the pop-up menu. The Style dialog displayed depends on the type of style selected. Each style dialog has several tabs. See the chapters on styles in the user guides for details. Updating a style from a selection To update a style from a selection: 1) Open the Styles and Formatting window.
Creating new (custom) styles You may want to add some new styles. You can do this in two ways: • Creating a new style using the Style dialog • Creating a new style from a selection Creating a new style using the Style dialog To create a new style using the Style dialog, right-click in the Styles and Formatting window and select New from the pop-up menu. If you want your new style to be linked with an existing style, first select that style and then right-click and select New.
Dragging and dropping to create a style You can drag and drop a text selection into the Styles and Formatting window to create a new style. Writer Select some text and drag it to the Styles and Formatting window. If Paragraph Styles are active, the paragraph style will be added to the list. If Character Styles are active, the character style will be added to the list. Calc Drag a cell selection to the Styles and Formatting window to create cell styles.
Figure 50: Choosing to copy styles from a document, not a template Figure 51: Copying a style from one document to another Loading styles from a template or document You can copy styles by loading them from a template or another document: 1) Open the document you want to copy styles into. 2) In the Styles and Formatting window, long-click on the arrow next to the New Style from Selection icon, and then click on Load Styles (see Figure 48).
Figure 52. Copying styles from a template into the open document 4) Select the categories of styles to be copied. Select Overwrite if you want the styles being copied to replace any styles of the same names in the document you are copying them into. 5) Click OK to copy the styles. You will not see any change on screen. Note Caution To copy the styles from another document, click the From File button to open a window from which you can select the required document.
Using a template to create a document To use a template to create a document: 1) From the main menu, choose File > New > Templates and Documents. The Templates and Documents dialog opens. 2) In the box on the left, click the Templates icon if it is not already selected. A list of template folders appears in the center box. 3) Double-click the folder that contains the template that you want to use. A list of all the templates contained in that folder appears in the center box.
Creating a template You can create your own templates in two ways: from a document, and using a wizard. Creating a template from a document To create a template from a document: 1) Open a new or existing document of the type you want to make into a template (text document, spreadsheet, drawing, presentation). 2) Add the content and styles that you want. 3) From the main menu, choose File > Templates > Save. The Templates dialog opens (see Figure 54).
You can also save menu and toolbar customizations in templates; see Chapter 14 (Customizing OpenOffice.org) for more information. Creating a template using a wizard You can use wizards to create templates for letters, faxes, agendas, presentations, and Web pages.
Editing a template You can edit a template’s styles and content, and then, if you wish, you can reapply the template’s styles to documents that were created from that template. (Note that you can only reapply styles. You cannot reapply content.) To edit a template: 1) From the main menu, choose File > Templates > Edit. A standard file browser window opens. 2) Select the template that you want to edit. 3) Edit the template just as you would any other document.
Note To re-enable updating from a template: 1) Use Tools > Macros > Organize Macros > OpenOffice.org Basic. Select the document from the list, click the expansion symbol (+ or triangle), and select Standard. If Standard has an expansion symbol beside it, click that and select a module. 2) If the Edit button is active, click it. If the Edit button is not active, click New. 3) In the Basic window, enter the following: Sub FixDocV3 ' set UpdateFromTemplate oDocSettings = ThisComponent.createInstance( _ "com.
Figure 57: Newly-added package of templates Setting a default template If you create a document by choosing File > New > Text Document (or Spreadsheet, Presentation, or Drawing) from the main menu, OOo creates the document from the Default template for that type of document. You can, however, set a custom template to be the default. You can reset the default later if you choose.
Resetting the default template To re-enable OOo’s Default template for a document type as the default: 1) In the Template Management dialog, click any folder in the box on the left. 2) Click the Commands button and choose Reset Default Template from the drop-down menu. The next time that you create a document by choosing File > New, the document will be created from OOo’s Default template for that document type.
4) In the Select Template window, find and select the required template and click Open. 5) Save the document. If you now look in File > Properties, you will see the new template listed at the bottom of the General page. Organizing templates OOo can only use templates that are in OOo template folders. You can create new OOo template folders and use them to organize your templates. For example, you might have one template folder for report templates and another for letter templates.
Deleting a template You cannot delete templates supplied with OOo or installed using the Extension Manager; you can only delete templates that you have created or imported. To delete a template: 1) In the Template Management dialog, double-click the folder that contains the template you want to delete. A list of the templates contained in that folder appears underneath the folder name. 2) Click the template that you want to delete. 3) Click the Commands button and choose Delete from the drop-down menu.
As an example, we can use the First Page and Default page styles that come with OOo. Figure 58 shows what we want to happen: the first page is to be followed by the default page, and all the following pages are to be in the Default page style. Details are in Chapter 4 (Formatting Pages) in the Writer Guide. Figure 58: Flow of page styles Dividing a document into chapters In a similar way, you can divide a document into chapters.
Controlling page breaks automatically Writer automatically flows text from one page to the next. If you do not like the default settings, you can change them. For example, you can require a paragraph to start on a new page or column and specify the style of the new page. A typical use is for chapter titles to always start on a new right-hand (odd-numbered) page.
4 Chapter Getting Started with Writer Word Processing with OpenOffice.
What is Writer? Writer is the word processor component of OpenOffice.org (OOo).
Figure 61: Left end of status bar Page number Shows the current page number, the sequence number of the current page (if different), and the total number of pages in the document. For example, if you restarted page numbering at 1 on the third page, its page number is 1 and its sequence number is 3. If any bookmarks have been defined in the document, a right-click on this field pops up a list of bookmarks; click on the required one. To jump to a specific page in the document, double-click on this field.
Digital signature If the document has been digitally signed, an icon double-click the icon to view the certificate. shows here. You can Section or object information When the cursor is on a section, heading, or list item, or when an object (such as a picture or table) is selected, information about that item appears in this field. Double-clicking in this area opens a relevant dialog. For details, consult the Help or the Writer Guide.
You can also choose View > Zoom from the menu bar to display the Zoom & View Layout dialog, where you can set the same options as on the Status bar. In Web Layout view, most of the choices are not available. Figure 64: Choosing Zoom and View Layout options. Moving quickly through a document In addition to the navigation features of the Status bar (described above), you can use the main Navigator window and the Navigation toolbar as described in Chapter 1 (Introducing OpenOffice.org).
Click an icon to select that object type. Now all the Previous and Next icons (in the Navigator itself, in the Navigation Toolbar, and on the scroll bar) will jump to the next object of the selected type. This is particularly helpful for finding items like index entries, which can be difficult to see in the text. The names of the icons (shown in the tooltips) change to match the selected category; for example, Next Graphic, Next Bookmark, or Continue search forward.
From this point on, all changes you make to the document will occur only in the Microsoft Word document. You have changed the name and file type of your document. If you want to go back to working with the .odt version of your document, you must open it again. Tip To have OOo save documents by default in the Microsoft Word file format, go to Tools > Options > Load/Save. See “Choosing options for loading and saving documents” in Chapter 2 (Setting up OpenOffice.org).
3) Use the arrow keys to move to the start of the next piece of text to be selected. Hold down the Shift key and select the next piece of text. 4) Repeat as often as needed. Now you can work with the selected text. Press Esc to exit from this mode. Selecting a vertical block of text You can select a vertical block or “column” of text that is separated by spaces or tabs (as you might see in text pasted from e-mails, program listings, or other sources), using OOo’s block selection mode.
Figure 70: Paste Special menu Finding and replacing text and formatting Writer has two ways to find text within a document: the Find toolbar for fast searching and the Find & Replace dialog. In the dialog, you can: • • • • Find and replace words and phrases Use wildcards and regular expressions to fine-tune a search Find and replace specific formatting Find and replace paragraph styles If the Find toolbar is not visible, you can display it using View > Toolbars > Find.
1) Type the text you want to find in the Search for box. 2) To replace the text with different text, type the new text in the Replace with box. 3) You can select various options such as matching the case, matching whole words only, or doing a search for similar words. 4) When you have set up your search, click Find. To replace text, click Replace instead. For more information on using Find & Replace, see the Writer Guide.
Inserting dashes and non-breaking spaces and hyphens To prevent two words from being separated at the end of a line, press Control+Shift+spacebar after the first word to insert a non-breaking space. In cases where you do not want the hyphen to appear at the end of a line, for example in a number such as 123-4567, you can press Control+Shift+minus sign to insert a non-breaking hyphen. To enter en and em dashes, you can use the Replace dashes option on the Options tab under Tools > AutoCorrect Options.
To set the measurement unit and the spacing of default tab stop intervals, go to Tools > Options > OpenOffice.org Writer > General. Figure 73: Selecting a default tab stop interval You can also set or change the measurement unit for rulers in the current document by right-clicking on the ruler to open a list of units. Click on one of them to change the ruler to that unit. The selected setting applies only to that ruler.
Writer does not include a grammar checker, but you can install an extension such as Language Tool and access it from Tools > Spelling and Grammar. (See Chapter 14 for more about installing extensions.) Language Tool adds a new menu item and submenu to the Tools menu, from which you can configure the tool and check or recheck the document.
See the different tabs of the dialog for the wide variety of other options available to fine-tune AutoCorrect. Tip AutoCorrect can be used as a quick way to insert special characters. For example, (c) will be autocorrected to ©. You can add your own special characters. Using word completion If Word Completion is enabled, Writer tries to guess which word you are typing and offers to complete the word for you. To accept the suggestion, press Enter. Otherwise continue typing.
Tip If the only option under the AutoText button is Import, either you have not entered a name for your AutoText or there is no text selected in the document. AutoText is especially powerful when assigned to fields. See Chapter 14 (Working with Fields) in the Writer Guide for more information. Inserting AutoText To insert AutoText, type the shortcut and press F3. Formatting text Using styles is recommended Styles are central to using Writer.
1 Open Styles and Formatting Window 2 Apply Style 3 Font Name 4 Font Size 5 Bold 6 Italic 7 Underline 8 Superscript 9 Subscript 10 Increase Font 11 Reduce Font 12 Font Color 13 Highlighting 14 Background Color 15 Open Character Format Dialog Figure 76: Formatting toolbar, showing icons for character formatting Tip To remove manual formatting, select the text and choose Format > Default Formatting, or right-click and choose Default Formatting.
Note It is a matter of personal preference whether you type your information first, then apply Numbering/Bullets, or apply them as you type. Using the Bullets and Numbering toolbar You can create nested lists (where one or more list items has a sub-list under it, as in an outline) by using the buttons on the Bullets and Numbering toolbar (Figure 77). You can move items up or down the list, or create sub-points, and even change the style of bullets.
Figure 79: Turning on automatic hyphenation Note Turning on hyphenation for the Default paragraph style affects all other paragraph styles that are based on Default. You can individually change other styles so that hyphenation is not active; for example, you might not want headings to be hyphenated. Any styles that are not based on Default are not affected.
Formatting pages Writer provides several ways for you to control page layouts: page styles, columns, frames, tables, and sections. For more information, see Chapter 4 (Formatting Pages) in the Writer Guide. Tip Page layout is usually easier if you show text, object, table, and section boundaries in Tools > Options > OpenOffice.org > Appearance, and paragraph ends, tabs, breaks, and other items in Tools > Options > OpenOffice.org Writer > Formatting Aids.
For a newsletter with complex layout, two or three columns on the page, and some articles that continue from one page to some place several pages later, use page styles for basic layout. Place articles in linked frames and anchor graphics to fixed positions on the page if necessary. For a document with terms and translations to appear side-by-side in what appear to be columns, use a table to keep items lined up, and so you can type in both “columns”.
5) To change the title for the whole document, go back to File > Properties > Description. Fields are covered in detail in Chapter 14 (Working with Fields) in the Writer Guide. For more about headers and footers, see Chapter 4 (Formatting Pages) and Chapter 6 (Introduction to Styles) in the Writer Guide. Numbering pages To automatically number pages: 1) Insert a header or footer, as described in “Creating headers and footers” on page 95.
Figure 81: Specifying a page break before a paragraph Method 2: 1) Insert > Manual break. 2) By default, Page break is selected on the Insert Break dialog (Figure 82). 3) Choose the required page Style. 4) Select Change page number. 5) Specify the page number to start from, and then click OK.
To change margins using the rulers: 1) The gray sections of the rulers are the margins. Put the mouse cursor over the line between the gray and white sections. The pointer turns into a doubleheaded arrow. 2) Hold down the left mouse button and drag the mouse to move the margin. Figure 83: Moving the margins Tip The small arrows on the ruler are used for indenting paragraphs. They are often in the same place as the page margins, so you need to be careful to move the margin marker, not the arrows.
Figure 84: Example of comments To navigate from one comment to another, open the Navigator (F5), expand the Comments section, and click on the comment text to move the cursor to the anchor point of the comment in the document. Right-click on the comment to quickly edit or delete it. You can also navigate through the comments using the keyboard. Use Ctrl+Alt+Page Down to move to the next comment and Ctrl+Alt+Page Up to move to the previous comment.
You can customize an existing table of contents at any time. Right-click anywhere in it and choose Edit Index/Table from the pop-up menu. Chapter 12 (Creating Tables of Contents, Indexes and Bibliographies) of the Writer Guide describes in detail all the customizations you can choose. Creating indexes and bibliographies Indexes and bibliographies work in a similar way to tables of contents.
Tracking changes to a document You can use several methods to keep track of changes made to a document. 1) Make your changes to a copy of the document (stored in a different folder, or under a different name, or both), then use Writer to combine the two files and show the differences. Choose Edit > Compare Document. This technique is particularly useful if you are the only person working on the document, as it avoids the increase in file size and complexity caused by the other methods.
• When using a hyperlink, you do not have a choice of the content of the link (for example text or page number), but when using a cross-reference, you have several choices, including bookmarks. • To hyperlink to an object such as a graphic, and have the hyperlink show useful text such as Figure 6, you need to either give such an object a useful name instead of leaving it as the default name (“Graphics6”), or you need to use the Hyperlink dialog to modify the visible text.
numbers. The Cross-references tab of the Fields dialog lists some items, such as headings, bookmarks, figures, tables, and numbered items such as steps in a procedure. You can also create your own reference items; see “Setting References” in Chapter 14 (Working with Fields) in the Writer Guide for instructions. To insert a cross-reference to a heading, figure, bookmark, or other item: 1) In your document, place the cursor where you want the cross-reference to appear.
Figure 87: Inserting a bookmark Using master documents Master documents are typically used for producing long documents such as a book, a thesis, or a long report; or when different people are writing different chapters or other parts of the full document, so you don’t need to share files. A master document joins separate text documents into one larger document, and unifies the formatting, table of contents (TOC), bibliography, index, and other tables or lists. Yes, master documents do work in Writer.
5 Chapter Getting Started with Calc Using Spreadsheets in OpenOffice.
What is Calc? Calc is the spreadsheet component of OpenOffice.org (OOo). You can enter data (usually numerical) in a spreadsheet and then manipulate this data to produce certain results. Alternatively you can enter data and then use Calc in a ‘What if...’ manner by changing some of the data and observing the results without having to retype the entire spreadsheet.
Parts of the main Calc window When Calc is started, the main window looks similar to Figure 88. Figure 88: Parts of the Calc window Title bar The Title bar, located at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is Untitled X, where X is a number. When you save a spreadsheet for the first time, you are prompted to enter a name of your choice. Menu bar Under the Title bar is the Menu bar.
Figure 89. Apply Style, Font Name and Font Size lists Formula bar On the left hand side of the Formula bar is a small text box, called the Name Box, with a letter and number combination in it, such as D7. This combination, called the cell reference, is the column letter and row number of the selected cell. Figure 90. Formula Bar To the right of the Name box are the the Function Wizard, Sum, and Function buttons.
Individual cells The main section of the screen displays the cells in the form of a grid, with each cell being at the intersection of a column and a row. At the top of the columns and at the left end of the rows are a series of gray boxes containing letters and numbers. These are the column and row headers. The columns start at A and go on to the right, and the rows start at 1 and go down. These column and row headers form the cell references that appear in the Name Box on the Formula Bar (Figure 90).
to separate the cells. Text is entered in quotation marks, numbers are entered without quotation marks. Opening a CSV file To open a CSV file in Calc: 1) Choose File > Open. 2) Locate the CSV file that you want to open. 3) If the file has a *.csv extension, select the file and click Open. 4) If the file has another extension (for example, *.txt), select the file, select Text CSV (*csv;*txt;*xls) in the File type box (scroll down into the spreadsheet section to find it) and then click Open.
Saving as a CSV file To save a spreadsheet as a comma separate value (CSV) file: 1) Choose File > Save As. 2) In the File name box, type a name for the file. 3) In the File type list, select Text CSV (.csv) and click Save. You may see the message box shown below. Click Keep Current Format. 4) In the Export of text files dialog, select the options you want and then click OK.
cell you want to go to and press Enter. Or just click into the Name box, backspace over the existing cell reference and type in the cell reference you want and press Enter. Using the Navigator To open the Navigator, click its icon on the Standard toolbar, or press F5, or choose View > Navigator on the Menu bar, or double-click on the Sheet Sequence Number in the Status Bar. Type the cell reference into the top two fields, labeled Column and Row, and press Enter.
focus to the new cell. This method is most useful when the two cells are a large distance apart. Figure 96. (Left) One selected cell and (right) a group of selected cells Using the Tab and Enter keys • Pressing Enter or Shift+Enter moves the focus down or up, respectively. • Pressing Tab or Shift+Tab moves the focus to the right or to the left, respectively. Using the arrow keys Pressing the arrow keys on the keyboard moves the focus in the direction of the arrows.
Figure 97: Customizing the effect of the Enter key Moving from sheet to sheet Each sheet in a spreadsheet is independent of the others, though they can be linked with references from one sheet to another. There are three ways to navigate between different sheets in a spreadsheet. Using the Navigator When the Navigator is open (Figure 95), double-clicking on any of the listed sheets selects the sheet.
Note The sheet tab arrows that appear in Figure 98 only appear if you have some sheet tabs that can not be seen. Otherwise, they will appear faded as in Figure 88. Selecting items in a sheet or spreadsheet Selecting cells Cells can be selected in a variety of combinations and quantities. Single cell Left-click in the cell. The result will look like the left side of Figure 96. You can verify your selection by looking in the Name box.
Selecting columns and rows Entire columns and rows can be selected very quickly in OOo. Single column or row To select a single column, click on the column identifier letter (see Figure 88). To select a single row, click on the row identifier number. Multiple columns or rows To select multiple columns or rows that are contiguous: 1) Click on the first column or row in the group. 2) Hold down the Shift key. 3) Click the last column or row in the group.
Multiple non contiguous sheets To select multiple non contiguous sheets: 1) Click on the sheet tab for the first sheet. 2) Move the mouse pointer over the second sheet tab. 3) Hold down the Control key and click on the sheet tab. 4) Repeat as necessary. The selected tabs will turn white. Any actions that you perform will now affect all highlighted sheets. All sheets Right-click any one of the sheet tabs and choose Select All Sheets from the pop-up menu.
Deleting columns and rows Columns and rows can be deleted individually or in groups. Single column or row A single column or row can only be deleted by using the mouse: 1) Select the column or row to be deleted. 2) Right-click on the column or row header. 3) Select Delete Columns or Delete Rows from the pop-up menu. Multiple columns or rows Multiple columns or rows can be deleted at once rather than deleting them one at a time.
Figure 101. Insert Sheet dialog Deleting sheets Sheets can be deleted individually or in groups. Single sheet Right-click on the tab of the sheet you want to delete and choose Delete Sheet from the pop-up menu, or chose Edit > Sheet > Delete from the menu bar. Multiple sheets To delete multiple sheets, select them as described earlier, then either right-click over one of the tabs and select Delete Sheet from the pop-up menu, or choose Edit > Sheet > Delete from the menu bar.
Viewing Calc Using zoom Use the zoom function to change the view to show more or fewer cells in the window. For more about zoom, see Chapter 1 (Introducing OpenOffice.org) in this book. Freezing rows and columns Freezing locks a number of rows at the top of a spreadsheet or a number of columns on the left of a spreadsheet or both. Then when scrolling around within the sheet, any frozen columns and rows remain in view. Figure 102 shows some frozen rows and columns.
Two lines appear on the screen, a horizontal line above this cell and a vertical line to the left of this cell. Now as you scroll around the screen, everything above and to the left of these lines will remain in view. Unfreezing To unfreeze rows or columns, choose Window > Freeze. The check mark by Freeze will vanish. Splitting the screen Another way to change the view is by splitting the window, also known as splitting the screen. The screen can be split either horizontally or vertically or both.
Figure 105. Split screen bar on vertical scroll bar with cursor 3) Hold down the left mouse button. A gray line appears, running across the page. Drag the mouse downwards and this line follows. 4) Release the mouse button and the screen splits into two views, each with its own vertical scroll bar. You can scroll the upper and lower parts independently. Notice in Figure 103, the Beta and the A0 values are in the upper part of the window and other calculations are in the lower part.
Entering data using the keyboard Most data entry in Calc can be accomplished using the keyboard. Entering numbers Click in the cell and type in the number using the number keys on either the main keyboard or the numeric keypad. To enter a negative number, either type a minus (–) sign in front of it or enclose it in parentheses (brackets), like this: (1234). By default, numbers are right-aligned and negative numbers have a leading minus symbol.
Entering numbers as text A number can be entered as text to preserve a leading zero by entering an apostrophe before the number, like this: '01481. The data is now regarded as text by Calc and displayed exactly as entered. Typically, formulas will treat the entry as a zero and functions will ignore it. Take care that the cell containing the number is not used in a formula. If “smart quotes” are used for apostrophes, the apostrophe remains visible in the cell.
Using the Fill tool on cells At its simplest, the Fill tool is a way to duplicate existing content. Start by selecting the cell to copy, then drag the mouse in any direction (or hold down the Shift key and click in the last cell you want to fill), and then choose Edit > Fill and the direction in which you want to copy: Up, Down, Left or Right.
Figure 110: Specifying the start of a fill series (result is in Figure 109) You can also use Edit > Fill > Series to create a one-time fill series for numbers by entering the start and end values and the increment. For example, if you entered start and end values of 1 and 7 with an increment of 2, you would get the sequence of 1, 3, 5, 7. In all these cases, the Fill tool creates only a momentary connection between the cells. Once they are filled, the cells have no further connection with one another.
Figure 112: Defining a new fill series Using selection lists Selection lists are available only for text, and are limited to using only text that has already been entered in the same column. To use a selection list, select a blank cell and press Ctrl+D. A drop-down list appears of any cell in the same column that either has at least one text character or whose format is defined as Text. Click on the entry you require.
Depending on how validation is set up, the tool can also define the range of contents that can be entered and provide help messages that explain the content rules you have set up for the cell and what users should do when they enter invalid content. You can also set the cell to refuse invalid content, accept it with a warning, or start a macro when an error is entered. See Chapter 2 (Entering, Editing and Formatting Data) in the Calc Guide for more information.
Changing part of the data in a cell Sometimes it is necessary to change the contents of cell without removing all of the contents, for example if the phrase “See Dick run” is in a cell and it needs to be changed to “See Dick run fast.” It is often useful to do this without deleting the old cell contents first. The process is the similar to the one described above, but you need to place the cursor inside the cell. You can do this in two ways.
Figure 114: Format Cells > Alignment dialog Figure 115: Automatic text wrap Using manual line breaks To insert a manual line break while typing in a cell, press Ctrl+Enter. This method does not work with the cursor in the input line. When editing text, first double-click the cell, then single-click at the position where you want the line break. When a manual line break is entered, the cell width does not change. Figure 116 shows the results of using two manual line breaks after the first line of text.
Shrinking text to fit the cell The font size of the data in a cell can automatically adjust to fit in a cell. To do this, select the Shrink to fit cell size option in the Format Cells dialog (Figure 114). Figure 117 shows the results. Figure 117: Shrinking font size to fit cells Formatting numbers Several different number formats can be applied to cells by using icons on the Formatting toolbar. Select the cell, then click the relevant icon. Figure 118: Number format icons.
Formatting the font To quickly choose the font used in a cell, select the cell, then click the arrow next to the Font Name box on the Formatting toolbar and choose a font from the list. Tip To choose whether to show the font names in their font or in plain text, go to Tools > Options > OpenOffice.org > View and select or deselect the Show preview of fonts option in the Font Lists section. For more information, see Chapter 2 (Setting Up OpenOffice.org).
Autoformatting cells and sheets You can use the AutoFormat feature to quickly apply a set of cell formats to a sheet or a selected cell range. 1) Select the cells, including the column and row headers, that you want to format. 2) Choose Format > AutoFormat. Note The AutoFormat feature can only be applied if the selected set of cells consist of at least 3 columns and 3 rows and includes the column and row headers.
Formatting spreadsheets using themes Calc comes with a predefined set of formatting themes that you can apply to your spreadsheets. It is not possible to add themes to Calc, and they cannot be modified. However, you can modify their styles after you apply them to a spreadsheet. To apply a theme to a spreadsheet: 1) Click the Choose Themes icon in the Tools toolbar. If this toolbar is not visible, you can show it using View > Toolbars > Tools. The Theme Selection dialog appears.
Figure 121: Hiding or showing cells Outline group controls If you are continually hiding and showing the same cells, you can simplify the process by creating outline groups, which add a set of controls for hiding and showing the cells in the group that are quick to use and always available. If the contents of cells falls into a regular pattern, such as four cells followed by a total, then you can use Data > Group and Outline > AutoOutline to have Calc add outline controls based on the pattern.
Filtering which cells are visible A filter is a list of conditions that each entry has to meet in order to be displayed. You can set three types of filters from the Data > Filter sub-menu. Automatic filters add a drop-down list to the top row of a column that contains commonly used filters. They are quick and convenient and are useful with text and with numbers, because the list includes every unique entry in the selected cells.
Copy sort results to Sets a spreadsheet address to which to copy the sort results. If a range is specified that does not have the necessary number of cells, then cells are added. If a range contains cells that already have content, then the sort fails. Custom sort order Select the box, then choose one of the sort orders defined in Tools > Options > Spreadsheet > Sort Lists from the drop-down list. Direction Sets whether rows or columns are sorted.
Removing a print range It may become necessary to remove a defined print range, for example if the whole sheet needs to be printed later. Choose Format > Print Ranges > Remove. This removes all defined print ranges on the sheet. After the print range is removed, the default page break lines will appear on the screen. Editing a print range At any time, you can directly edit the print range, for example to remove or resize part of the print range. Choose Format > Print Ranges > Edit.
Top to bottom, then right Left to right, then down Details You can specify which details to print.
For example, if the top two rows of the sheet as well as column A need to be printed on all pages, do the following: 1) Choose Format > Print Ranges > Edit. On the Edit Print Ranges dialog, type the rows in the text entry box under Rows to repeat. For example, to repeat rows 1 and 2, type $1:$2. This automatically changes Rows to repeat from, - none - to - user defined -. Figure 124: Specifying repeating rows 2) To repeat, type the columns in the text entry box under Columns to repeat.
Tip To see page break lines more easily on screen, you can change their color. Choose Tools > Options > OpenOffice.org > Appearance and scroll down to the Spreadsheet section. Deleting a page break To remove a page break: 1) Navigate to a cell that is next to the break you want to remove. 2) Select Edit > Delete Manual Break. 3) Select Row Break or Column Break depending on your need. The break is now removed. Note Multiple manual row and column breaks can exist on the same page.
Height Height affects how big the header or footer will be. Figure 125: Header dialog Header or footer appearance To change the appearance of the header or footer, click the More button in the header dialog. This opens the Border/Background dialog (Figure 126). From this dialog you can set the background and border of the header or footer. For more information see Chapter 4 (Using Styles and Templates) in the Calc Guide. Figure 126: Header/Footer Border/Background 142 Getting Started with OpenOffice.
Setting the contents of the header or footer The header or footer of a Calc spreadsheet has three columns for text. Each column can have different contents. To set the contents of the header or footer, click the Edit button in the header or footer dialog shown in Figure 125 to display the dialog shown in Figure 127. Figure 127: Edit contents of header or footer Areas Each area in the header or footer is independent and can have different information in it.
6 Chapter Getting Started with Impress Presentations in OpenOffice.
What is Impress? Impress is OpenOffice.org’s slide show (presentations) program. You can create slides that contain many different elements, including text, bulleted and numbered lists, tables, charts, clip art, and a wide range of graphic objects. Impress also includes a spelling checker, a thesaurus, prepackaged text styles, and attractive background styles. This chapter includes instructions, screenshots, and hints to guide you through the Impress environment while designing the easier presentations.
Figure 128: Main window of Impress; oval indicates the Hide/Show markers Tip You can remove the Slides pane or Tasks pane from view by clicking the X in the upper right corner. You can also show or hide these panes using View > Slide Pane or View > Tasks Pane. You can also hide these panes in order to maximize the Workspace area by clicking the Hide/Show marker in the middle of the vertical separator line and restore them by clicking again on the same area.
It is also possible to perform the following operations, although there are more efficient methods than using the Slides pane: • Change the slide transition following the selected slide or after each slide in a group of slides. • Change the sequence of slides in the presentation. • Change the slide design. • Change slide layout for a group of slides simultaneously. Tasks pane The Tasks pane has five sections.
Toolbars Many toolbars can be used during slide creation; they can be displayed or hidden by clicking View > Toolbars and selecting from the menu. You can also select the icons that you wish to appear on each toolbar. For more information, refer to Chapter 1 (Introducing OpenOffice.org) in this book. Many of the toolbars in Impress are similar to the toolbars in Draw. Refer to the Draw Guide for details on the functions available and how to use them.
Workspace views Each of the workspace views is designed to ease the completion of certain tasks; it is therefore useful to familiarize yourself with them in order to quickly accomplish those tasks. Normal view Normal view is the main view for working with individual slides. Use this view to format and design and to add text, graphics, and animation effects. To place a slide in the slide design area (Normal view), click the slide thumbnail in the Slides pane or double-click it in the Navigator.
• Double-click the slide’s name in the Navigator. 3) In the text box below the slide, click on the words Click to add notes and begin typing. You can resize the Notes text box using the green resizing handles which appear when you click on the edge of the box. You can also move the box by placing the pointer on the border, then clicking and dragging. To make changes in the text style, press the F11 key to open the Styles and Formatting window.
Use this dialog to select the elements you want to appear on each handout page and their contents. More details on how to use this dialog are provided in the Impress Guide. Figure 136: Dialog to set the page information for handouts and notes Slide Sorter view Slide Sorter view contains all of the slide thumbnails. Use this view to work with a group of slides or with only one slide.
Customizing Slide Sorter view To change the number of slides per row: 1) Check View > Toolbars > Slide View to make the Slide View toolbar visible. Figure 138: Slide Sorter and Slide View toolbars 2) Adjust the number of slides (up to a maximum of 15). Moving a slide using Slide Sorter To move a slide in a presentation in the Slide Sorter: 1) Click the slide. A thick black border is drawn around it. 2) Drag and drop it to the location you want.
– For more than one slide, select the group of slides and add the desired transition. • Mark a slide as hidden. Hidden slides will not be shown in the slide show. • Copy or cut and paste a slide. Renaming slides Right-click on a thumbnail in the Slides pane or the Slide Sorter and choose Rename Slide from the pop-up menu. In the Name field, delete the old name of the slide and type the new name. Click OK.
• Open existing presentation continues work on a previously created presentation. The wizard changes to show a list of existing presentations. Choose the presentation you want. Both of these options are covered in the Impress Guide. 2) Click Next. Figure 140 shows the Presentation Wizard step 2 as it appears if you selected Empty Presentation at step 1. If you selected From template, an example slide is shown in the Preview box.
The Screen page is optimized for a 4:3 display (28cm x 21cm) so it is not suitable for modern widescreen displays. You can change the slide size at any time switching to Normal view and selecting Format > Page. Note 5) Click Next. The Presentation Wizard step 3 appears. Figure 141: Selecting a slide design • • Choose the desired slide transition from the Effect drop-down menu. Select the desired speed for the transition between the different slides in the presentation from the Speed drop-down menu.
Formatting a presentation A new presentation contains only one empty slide. In this section we will start adding new slides and preparing them for the intended contents. Inserting slides This can be done in a variety of ways; take your pick. • Insert > Slide. • Right-click on the present slide, and select Slide > New Slide from the pop-up menu. • Click the Slide icon in the Presentation toolbar. Sometimes, rather than starting from a new slide you want to duplicate a slide you have already inserted.
The Title Slide (which also contains a section for a subtitle) or Title Only are suitable layouts for the first slide, while for most of the slides you will probably use the Title, Contents layout. If you do not know the names for the prepackaged layouts position the cursor on an icon in the Layout section and its name will be displayed in a small rectangle. Tip The small rectangle is called tooltip. If the tooltips are not enabled select Tools > Options > OpenOffice.
Modifying the slide elements At present each slide will contain only the elements that are present in the slide master you are using such as background images, logos, header, footer and so on. It is however unlikely that the predefined layouts will suit all your needs. Although Impress does not have the functionality to create new layouts, it allows you to resize and move the layout elements. It is also possible to add slide elements without being limited to the size and position of the layout boxes.
Modifying the slide show By default the slide show will display all the slides in the same order as they appear in the slide sorter, without any transition between slides, and you need some keyboard or mouse interaction to move from one slide to the next. You can use the Slide Show menu to change the order of the slides, choose which ones are shown, automate moving from one slide to the next, and other settings.
Figure 144: Selected text box showing the green resizing handles and text toolbar You can move, resize, and delete text boxes. For more information, see Chapter 3 in the Impress Guide. Note In addition to the normal text boxes where text is horizontally aligned, it is possible to insert text boxes where the text is aligned vertically. This choice is available only when Asian languages are enabled in Tools > Options > Language Settings > Languages.
Pasting unformatted text It is normally good practice to paste text without formatting and apply the formatting later. To paste without formatting, either press Control+Shift+V and then select Unformatted text from the dialog that appears, or click on the small black triangle next to the paste symbol in the standard toolbar and select Unformatted text.
Creating lists in AutoLayout text boxes Every text box included in the available layouts is already formatted as a bulleted list, therefore to create a bulleted list the only necessary steps are: 1) From the Layout pane, choose a slide design that contains a text box. Those are easily recognizable from the thumbnail. 2) Click in the text box that reads Click to add an outline. 3) Type the text, then press Enter to start a new bulleted line.
For the entire list: 1) Select the entire list or click on the gray border of the text box so that the green resizing handles are displayed. 2) Select Format > Bullets and Numbering or click on the Bullets and Numbering icon . 3) The Bullets and Numbering dialog contains five tabs: Bullets, Numbering type, Graphics, Position, and Customize. • If a bullet list is needed, select the desired bullet style from the default styles available on the Bullets page.
Caution When resizing a graphic, right-click the picture. Select Position and Size from the context menu and make sure that Keep ratio is selected. Then adjust the height or width to the size you need. (As you adjust one dimension. both dimensions will change.) Failure to do so will cause the picture to become distorted. Remember also that resizing a bitmap image will reduce its quality; better by far to create an image of the desired size outside of Impress.
and total row as well as the first and last columns of the table, and apply a banded appearance to the rows and columns. Having completed the table design, entering data into the cells is similar to working with text box objects. Click in the cell you wish to add data to, and begin typing. To move around cells quickly, use the following key options: • The arrow keys move the cursor to the next table cell if the cell is empty, otherwise they move the cursor to the next character in the cell.
Working with slide masters and styles A slide master is a slide that is used as the starting point for other slides. It is similar to a page style in Writer: it controls the basic formatting of all slides based on it. A slide show can have more than one slide master. Note OOo uses three terms for a slide that is used to create other slides: master slide, slide master, and master page. This book uses the term slide master, except when describing the user interface.
Figure 146: Available master pages (slides) Creating a slide master Creating a new slide master is similar to modifying the default slide master. To start, enable editing of slide masters by View > Master > Slide Master. On the Master View toolbar, click the New Master icon. A second slide master appears in the Slides pane. Modify this slide master to suit your requirements.
Loading additional slide masters Sometimes, in the same set of slides, you may need to mix multiple slide masters that may belong to different templates. For example, you may need a completely different layout for the first slide of the presentation, or you may want to add to your presentation a slide from a different presentation (based on a template available on the hard disk). The Slide Design dialog makes this possible.
Tip To limit the size of the presentation file, you may want to minimize the number of slide masters used.
The Impress slide master comes with three pre-configured areas for date, footer and page number. Select Insert > Page Number or Insert > Date and Time to open a dialog box where you can configure these three areas. Figure 148: Configuring the slide footer areas Tip To change the number format (1,2,3 or a,b,c or i,ii,iii, etc.) for the page number field, choose Format > Page and then select a format from the list in the Layout Settings area.
Tip To change the author information, go to Tools > Options > OpenOffice.org > User Data. Adding comments to a presentation Starting with OOo 3.2, Impress supports comments (formerly called sticky notes) similar to those in Writer and Calc. In Normal View, choose Insert > Comment from the menu bar. A small box containing your initials appears in the upper left-hand corner of the slide, with a larger text box beside it (see Figure 149).
Setting up the slide show As mentioned in “Modifying the slide show” on page 159, Impress allocates reasonable default settings for slide shows, while at the same time allowing for customizing many aspects of the slide show experience. This section covers only some aspects; advanced techniques are explained in Chapter 9 (Slide Shows) in the Impress Guide. Most of the tasks are best done in Slide Sorter view where you can see most of the slides simultaneously.
Running the slide show To run the slide show, do one of the following: • Click Slide Show > Slide Show. • Click the Slide Show button on the Presentation toolbar. • Press F5 or F9 on the keyboard. If the slide transition is Automatic after x seconds, let the slide show run by itself. If the slide transition is On mouse click, do one of the following to move from one slide to the next: • Use the arrow keys on the keyboard to go to the next slide or to go back to the previous one.
7 Chapter Getting Started with Draw Vector Drawing in OpenOffice.
What is Draw? Draw is a vector graphics drawing program, although it can also perform some operations on raster graphics (pixels). Using Draw, you can quickly create a wide variety of graphical images. Vector graphics store and display an image as simple geometric elements such as lines, circles, and polygons rather than a collections of pixels (points on the screen). Vector graphics allow for easier storage and scaling of the image. Draw is fully integrated into the OpenOffice.
Figure 150. Initial Draw window Rulers You should see rulers (bars with numbers) on the upper and left-hand side of the workspace. The rulers show the size of a selected object on the page (see the gray double lines, highlighted in Figure 151). When no object is selected, they show the location of the mouse pointer, which helps to accurately position drawing objects more accurately. You can also use the rulers to manage object handles and guide lines, making it easier to position objects.
Status bar The Status bar is located at the bottom of the screen (in all OOo components); it includes several Draw-specific fields. For details on the contents and use of these fields, see Chapter 1 (Introducing OpenOffice.org) in this book and Chapter 1 (Introducing Draw) in the Draw Guide. Note The sizes are given in the current measurement unit (not to be confused with the ruler units). This unit is defined in Tools > Options > OpenOffice.
Text Formatting toolbar If the selected object is text, the toolbar changes to the Text Formatting toolbar, which is similar to the Formatting toolbar in Writer. For more information, see Chapter 4 (Getting Started with Writer) in this book. Drawing toolbar The Drawing toolbar is the most important toolbar in Draw. It contains all the necessary functions for drawing various geometric and freehand shapes and for organizing them on the page.
Figure 156. Changing the color palette Click on the Edit button to open the Color dialog, where you can set individual colors. See “Color options” in Chapter 2 (Setting Up OpenOffice.org) of this book. Many more input possibilities are available in this dialog. For a more detailed description of color palettes and their options, see Chapter 8 (Tips and Tricks) in the Draw Guide.
Figure 157: Exact positioning with snap to grid Showing the grid To make the grid visible, choose View > Grid > Display Grid. Alternatively, turn the grid on (or off) with the icon on the Options toolbar. Configuring the grid The color, spacing, and resolution of the grid points can be individually chosen for each axis. The spacing between the lines is defined in the Grid options dialog (Tools > Options > OpenOffice.org Draw > Grid).
• The resolution is the size of the squares or rectangles in the grid. If the resolution is Horizontal 1 cm, Vertical 2 cm, the grid consists of rectangles 2 cm high and 1 cm wide. • Subdivisions are additional points that appear along the sides of each rectangle or square in the grid. Objects snap to subdivisions as well as to the corners of the grid. • The pixel (pix element) size of the snap area defines how close you need to bring an object to a snap point or line before it will snap to it.
The basic drawing shapes Draw provides a wide range of shapes, located in palettes accessed from the Drawing Toolbar. This section describes only a few of the basic shapes. These shapes include; rectangles and squares, circles, ellipses, and arcs, 3D objects, curves, lines and arrows, text, and connectors. All shapes in Draw are called objects. See the Draw Guide for a complete description of the shapes available.
To change line attributes (for example, the color or line type), select the line by clicking on it, then use the tools in the Line and Filling toolbar; or for more control, right-click on the line and choose Line to open the Line dialog. Drawing an arrow Arrows are drawn like lines. Draw classifies arrows as a subgroup of lines: Lines with arrowheads. The information field on the status bar shows them only as lines. Click on the Line Ends with Arrow icon to draw an arrow.
Hold down the Shift key to draw a square. Hold down the Alt key to draw a rectangle starting from its center. To combine the effects, hold down both the Shift and Alt keys simultaneously. Drawing a circle or ellipse To draw an ellipse (also called an oval) or a circle, use the Ellipse icon from the Drawing toolbar. (A circle is simply an ellipse with both axes the same length.) The ellipse drawn is the largest ellipse that fits inside the (imaginary) rectangle drawn with the mouse.
1 Curve, filled 4 Freeform line, Filled 7 Polygon (45°) 2 Polygon, filled 5 Curve 8 Freeform line 3 Polygon (45°), filled 6 Polygon Figure 165: Curves toolbar (incorrectly titled "Lines") Polygons Draw the first line from the start point with the left mouse button held down. As soon as you release the mouse button, a first corner point is drawn; move the mouse to see how the second line will look. Every mouse click sets another corner point. A double-click ends the drawing.
Text frames can also have fill colors, shadows, and other attributes, just like any other Draw object. You can rotate the frame and write the text at any angle. These options are available by right-clicking on the object. Use the Callout tool , located on the Drawing toolbar, to create callouts (also known as captions or figure labels).
Figure 167 shows two Draw objects and a connector. Figure 167: A connector between two objects Draw offers a range of different connectors and connector functions. Open the floating Connector toolbar by clicking on the arrow next to the Connector icon . For more about connectors and gluepoints, see Chapter 9 (Organization Charts, Flow Diagrams, and More) in the Draw Guide. Drawing geometric shapes Geometric shapes include basic shapes, symbol shapes, block arrows, flowcharts, callouts, and stars.
Symbol shapes The Symbol Shapes icon provides an array of tools for drawing the various symbols. Block arrows The Block Arrows icon toolbar. opens the Block Arrows Flowcharts The tools for drawing flowcharts are accessed by clicking on the Flowcharts icon . The creation of flowcharts, organization charts, and similar planning tools are described in Chapter 9 (Organization Charts, Flow Diagrams, and More) in the Draw Guide. Callouts Use the Callouts icon toolbar.
Selection modes There are three selection modes: moving and changing size, editing, and rotating points. To set the default mode (either moving and changing sizes or editing) for selecting objects, click on the Points button from the Drawing toolbar. In standard mode (when you begin a new drawing), the Points button is not active, and the default mode is for selections to be moved or changed in size; these selections are indicated by small green squares.
Selecting objects Direct selection To easiest way to select an object is to click directly on it. For objects that are not filled, click directly on the object's outline to select it. Selection by framing You can select several objects at once by using the mouse to drag a large rectangle around the objects, as shown. For this to work, the Select icon on the Drawing toolbar must be active. Only objects that lie entirely within the rectangle are selected.
These options are also available from the Arrange tear-off toolbar from the button on the Drawing toolbar. A keyboard shortcut is Shift+Ctrl+plus sign to bring an object to the top, and Shift+Ctrl+minus to send an object to the bottom. Draw also provides tools for aligning multiple objects; details are given in the Draw Guide. Selecting several objects To select or deselect several objects one by one, press the Shift key and click on the various objects to be selected or deselected.
Rotation Rotating an object lets you move the object around an axis. To do this dynamically (with the mouse), use the red handles, as you do when changing the size of the object. Note Rotation works in a slightly different way for 3D objects because the rotation occurs in 3D space and not in one plane. See Chapter 7 (Working with 3D Objects) in the Draw Guide regarding rotation when Edit Points mode is active.
Editing objects To change an object’s attributes (such as color and border width) you can use the Line and Filling toolbar or the context menu. If the Line and Filling toolbar (Figure 170) is not visible, you can display it using View > Toolbars > Line and Filling. From here you can edit the most common object attributes. You can also open the Line dialog by clicking on the Line and the Area dialog by clicking on the Area icon icon to see more options.
Figure 171: The vertical lines have different levels of transparency (0%, 25%, and 50%). Drawing arrows Arrowheads (and other line endings—usually referred to collectively as arrows) are a line property. Select a line and click on the Arrow Style icon from the Line and Filling toolbar. This opens the Arrowheads menu. Several types of arrowheads are available. Each end of the line can have a different arrowhead (or no arrowhead). Arrowheads are only applicable to lines.
Adding a shadow In Draw, shadows are considered as an area property. Click on the Shadow icon on the Line and Filling toolbar. You can customize the position, distance, color, and transparency of shadows by using Format > Area > Shadow or by right-clicking on the selected object and choosing Area > Shadow. Adding transparency You can make objects partly or fully transparent, or even with a varying degree of transparency (as a gradient).
Mirror copies Move the axis of symmetry to the desired location of the mirror axis. Copy the object to the clipboard. Flip the object, then click on an empty area of the Draw screen in order to deselect the object. Paste from the clipboard to put a copy of the object in its original location and now you have a mirror copy. Distorting an image There are three tools on the Effects menu that let you drag the corners and edges of an object to distort the image.
Figure 172: Duplicating an object Cross-fading Cross-fading transforms a shape from one form to another. The result is a new group of objects including the start and end points and the intermediate steps. To carry out a cross-fade, first select two objects (hold the Shift key while selecting each object in turn) and then choose Edit > Cross-fading. On the Cross-fading dialog, choose the number of increments (transition steps).
Combining multiple objects Using Draw, you can combine drawing objects together in two distinct ways: grouping and combining. These two methods allow you to treat multiple objects as one unit, or to merge objects to form a new shape. Grouping is like putting objects in a container. You can move them as a group and apply global changes to them. A group can always be undone and the objects that make up the group can always be manipulated separately.
Aids for positioning objects Draw has various tools to help you arrange the objects with respect to each other: • Moving an object to the front or to the back • Aligning objects with respect to each other • Distributing the distance and space between objects See Chapter 5 (Combining Multiple Objects) in the Draw Guide for more information.
Adding comments to a drawing Starting with OOo 3.2, Draw supports comments (formerly called notes) similar to those in Writer and Calc. Choose Insert > Comment from the menu bar. A small box containing your initials appears in the upper left-hand corner of the Draw page, with a larger text box beside it. Draw has automatically added your name and the date at the bottom of this text box. Type or paste your comment into the text box.
8 Chapter Getting Started with Base OpenOffice.
Introduction A data source, or database, is a collection of pieces of information that can be accessed or managed by OpenOffice.org (OOo) . For example, a list of names and addresses is a data source that could be used for producing a mail merge letter . A shop stock list could be a data source managed through OOo. Note OpenOffice.org uses the terms “Data Source” and “Database” to refer to the same thing, which could be a database such as MySQL or dBase or a spreadsheet or text document holding data.
a database are the elements. The tables are subsets. Relationships are defined in terms of unions and intersections of the subsets (tables). To explain how to use a database, we will create one for automobile expenses. In the process, we will be explaining how a database works. Planning a database The first step in creating a database is to ask yourself many questions. Write them down, and leave some space between the questions to later write the answers.
Tip While we have listed fields we will create in the tables of the database, there is one more field that may be needed in a table: the field for the primary key. In some tables, the field for the primary key has already been listed. In other tables such as the payment type, an additional field for the primary key must be created.
Caution As you create a database, you should save your work regularly. This means more than just saving what you have just created. You must save the whole database as well. For example, when you create your first table, you must save it before you can close it. When the table is first saved, it is also made part of the database. Creating database tables In a database, a table stores information for a group of things we call fields.
3) Selected fields: Using the > button, move the following fields from the Available fields window to the Selected fields window in this order: CollectionID, AlbumTitle, Artist, DatePurchased, Format, Notes, and NumberofTracks. 4) Selected Fields from another sample table. Click Business as the Category. Select Employees from the dropdown list of sample tables. Use the > button to move the Photo field from the Available fields window to the Selected fields window.
Figure 177: Changing field types If any of these fields requires an entry, set Entry required to Yes. An entry with that field blank will then not be allowed. In general, only set Entry required to Yes if something must always be put in that field. By default, Entry required is set to No. Note • CollectionID: Change AutoValue from No to Yes. • AlbumTitle: – Entry required: Leave Entry required as No, unless all of your music is in albums.
Note Each field has a Field Type, which must be specified. Types include text, integer, date, and decimal. If the field is going to have general information in it (for example, a name or a description), use text. If the field will always contain a number (for example, a price), the type should be decimal or another numerical field. The wizard picks the right field type, so to get an idea of how this works, see what the wizard has chosen for different fields. Step 3: Set primary key.
needed. (See Caution below for the reason why.) Click Create. The new table is created. Caution Once tables have been created using the wizard and data has been entered, editing them should be very limited. Fields can be added or deleted, but adding a field requires taking the time to enter the data for that one field for every record having an entry for that field. Deleting a field deletes all the data once contained in that field.
Figure 178: Defining the primary key field The primary key serves only one purpose: to uniquely identify the record. Any name can be used for this field. We have used FuelID for convenience, so we know to which table it belongs. Note 3) All other fields (Date, FuelCost, FuelQuantity, Odometer, and PaymentType): • • Type the next field name in the Field Name column. Select the Field Type for each field. – – – • 210 For Date use Date[DATE]. (Press the D key to select it.
Figure 179: Changing field properties Figure 180: Field Format options 4) To access additional formatting options, click the button to the right of the Format example field. 5) Description can be anything, or can be left blank. 6) To save and close the table, choose File > Save. Name the table Fuel. Close the Fuel table. Follow the same steps to create the Vacations table. The fields and their field types are listed in Figure 181. Make sure you make the Date field the primary key before closing.
Figure 181: Fields in Vacations table Creating tables for the list box When the same information can be used in several fields, design a table for each type of information. Each table will contain two fields: the information field and ID, in that order. Caution You must create these tables with the information field listed first and the ID field listed last. Failure to do so will produce the wrong results.
Adding data to the list table List tables do not require a form. Instead, add their data directly to the table. In this example, use the names of the two people with a bank card and Cash for cash purchases. 1) In the main database window, click on the Tables icon (Figure 175). In the list of tables, right-click on Payment Type and select Open from the pop-up menu. a) Enter Dan in the Type column in the first row. Press the Tab key to move to the second row.
• Double-click the name of the table. In our case, do this for both Vacations and Fuel. • Or, click the name of the table and then click Add for each table. 3) Click Close to close the Add Tables dialog when you have added the tables you want. 4) You can define the relationship between the Vacations and Fuel tables in two ways: • Click and drag the Date field in the Fuel table to the Date field in the Vacations table.
Click OK to close the Relations dialog and choose File > Save to save the Relation Design window. While these options are not strictly necessary, they do help. Having them selected permits you to update a table that has a relationship defined with another table. It also permits you to delete a field from the table. e) Figure 185: Update options and Delete options section Creating a database form Databases are used to store data. But, how is the data put into the database? Forms are used to do this.
Step 1: Select fields. 1) Under Tables or queries, select Table: Vacations. Available fields lists the fields for the Vacations table. 2) Click the right double arrow to move all of these fields to the Fields in the form list. Click Next. Figure 188: Form Wizard steps Step 2: Set up a subform. Since we have already created a relationship between the Fuel and Vacations tables, we will use that relationship. If no relationship had been defined, this would be done in step 4.
Step 3: Add subform fields. This step is exactly the same as step 1. The only difference is that not all of the fields will be used in the subform. 1) Fuel is preselected under Tables or queries. 2) Use the >> button to move all the fields to the right. 3) Click the FuelID field to highlight it. 4) Use the < button to move the FuelID to the left. 5) Click Next. Figure 190: Selecting fields of a subform Step 4: Get joined fields. This step is for tables or queries for which no relationship has been defined.
Step 5: Arrange controls. Each control in a form consists of two parts: label and field. This step in creating the form determines where a control’s label and field are placed in relationship with each other. The four choices from left to right are Columnar left, Columnar Labels on top, As Data Sheet, and In Blocks - Labels Above. 1) Arrangement of the main form: Click the second icon (Columnar Labels on top). The labels will be placed above their field.
4) Change the wording of some of the labels. Some single words should be two words. Some abbreviations should be used if possible (Misc. for miscellaneous). 5) Change the lengths of several fields and labels. Only Lunch, Supper, Motel, and Tolls have acceptable lengths. But for a better appearance, changes will be made to these as well. 6) Replace all the fields whose label ends in Payment with a list box containing the entries from the Payment Type table.
Figure 193: Selecting multiple controls Move the cursor over one of the fields. It changes to a drag icon. Drag the group of controls to where you want them. Tip When either changing size or moving a control, two properties of the Form Design toolbar should be selected: Snap to Grid, and Guides when Moving. Your controls will line up better, and an outline of what you are moving moves as the cursor moves. You should also have both rulers active (View > Ruler). Step 1: Change the Date field.
2) Move the cursor over the middle green handle on the right. The cursor becomes a double-headed arrow. 3) Drag the cursor to the left until the field is 2.5 cm wide (1 inch). Tip If you have the Snap to Grid and Guides when moving icons selected in the Design Format toolbar, you will see how wide the field is as you shorten it. 4) Repeat these steps to shorten these fields: Lpayment, SPayment, SnPayment, Mpayment, and MiscPayment. Step 3: Move the controls to group them by category.
The table wizard in Base contains suggested fields which are single words, often consisting of two separate words. Table names in the wizard have been that way also. However, you can use multiple words as the name of a field, label, or table. We will do so when we create a list box for each of the payment type controls. Note 1) Control+click the SnackNo label. Do one of the following: • • Right-click the SnackNo label and select Control from the pop-up menu.
Step 6: Replace fields with other fields. We want to replace the PaymentType field with a List Box. Then we can choose the type of payment from the Payment Type table rather than having to manually enter the type. In my case, each of my payment types begins with a different letter. If I enter the first letter of the payment type, the rest of the word automatically appears. I can then go to the next field. 1) Control+click the Payment field for Breakfast.
• Type the following exactly as it is in the List contents box: SELECT "Type", "Type" FROM "Payment Type" Figure 200: List content for payment type fields Note What you wrote is called an SQL command. The words SELECT and FROM are written in capital letters because they are commands. When the command SELECT is used, it requires a field name within quotation marks and then the field’s alias, also within quotation marks. In this case, the field and its alias are the same.
2) Click the Control icon to open the Properties window (Figure 202). 3) Scroll down to the Scrollbars setting. Change the selection from None to Vertical in this dropdown list. Figure 202: Scrollbar selections in the Properties window 4) Close the Properties window. 5) Lengthen the Misc. Notes field by moving the cursor over the middle green handle at the bottom of the field and dragging down until the length is 6 cm (2.4 inches). Step 8: Change labels and fields in the subform.
Figure 203: Properties window for control in a subform Step 9: Add headings to groups. This step is easier to do if you have end-of-paragraph markers visible. Choose View > Nonprinting Characters to turn them on. 1) Make sure the cursor in in the upper left corner. If it is not, click in that corner to move it there. 2) Press the Enter key to move the cursor down to the space between the Date field and the Breakfast field. 3) Change the Apply Styles dropdown list from Default to Heading 2.
Step 10: Change the background of a form. The background for a form can be a color, or a graphic (picture). You can use any of the colors in the Color Table at Tools > Options > OpenOffice.org > Colors. If you know how to create custom colors, you can use them. You can also use a picture (graphic file) as the background. If you choose a dark background, you many need to change many of the labels and headings so they can be seen. 1) Select the labels of the top row of controls.
Tip Learning how to use styles can be very helpful at times. By using styles, we changed the font color for all three headings at one time. There are other methods of changing the font color, but they require repeating the same steps for each heading. 4) To add a graphic to the background: a) Right-click on the background and select Page from the pop-up menu. b) On the Page Style dialog, click the Background tab, change the As dropdown list from Color to Graphic.
Figure 208: Form Design toolbar with Activation Order icon circled 4) Rearrange the order of the fields in the Tab Order window. a) Find the txtMPayment listing near the bottom of the list and click it. b) Click the Move Up button until txtPayment is just below fmtMotel. c) Use the same two steps to put the fields in the same order as in Figure 209. Click OK. Figure 209: Tab order for the main form 5) Save and close the form. 6) Save the database.
1) File > New > Database opens the Database Wizard window. 2) Select Connect to an existing database. Click the arrow next to the Database type field and select the database type from the dropdown list. Click Next. 3) Click Browse and select the database. Click Next. 4) Accept the default settings: Register the database for me, and Open the database for editing. Click Finish. Name and save the database in the location of your choice.
Using data sources in OpenOffice.org Having registered the data source, whether a spreadsheet, text document, external database or other accepted data source, you can use it in other OpenOffice.org components including Writer and Calc. Viewing data sources Open a document in Writer or Calc. To view the data sources available, press F4 or select View > Data Sources from the pull-down menu.
Launching Base to work on data sources You can launch OOo Base at any time from the View Data Source pane . Just rightclick on a database or the Tables or Queries icons and select Edit Database File. Once in Base, you can edit, add, and delete tables, queries, forms, and reports. Using data sources in Writer and Calc Data can be placed into Writer and Calc documents from the tables in the data source window. In Writer, values from individual fields can be inserted.
7) Final result: On , our breakfast cost paid by , our lunch cost paid by , and our supper cost paid by . 8) Add data to the fields of the sentence: • Click the gray box to the left of the row of data you want to add. That row should be highlighted like the second row of Figure 213. • Click the Data to Fields icon (circled). This should fill the fields with the data from the row you chose.
Figure 214: Insert Database Columns dialog 6) Select the settings for your table. Use the default settings as in Figure 214. 7) Click OK. Save the document. Calc spreadsheets There are two ways to enter data in a Calc spreadsheet. One enters the data into the spreadsheet cells. The other creates records in the spreadsheet just like they are done in creating a form in a database.
3) Repeat until you have moved all of the fields you need to where you want them. 4) Name and save the spreadsheet. 5) Click a row of the table in the Data Source window. 6) Drag the data in the ID field in the selected row onto the ID field in the spreadsheet. The Save icon should activate. 7) Click the Edit File button to make the spreadsheet read only. Click Save when asked if you want to save the file.
The Odometer, Tolls, and Motel fields are numerical fields. Enter values directly into them, or use the up and down arrows. When the value is entered, use the Tab key to go to the next field. • Clicking the up arrow increases the value, and the down arrow decreases the value one unit. • These two arrows only change the numerals to the left of the decimal place. • Numerals to the right of the decimal place must be changed by deleting them and typing the desired ones.
Figure 217 is a record with data inserted in its fields. Figure 217: Sample record of the Vacation form and subform Creating queries Queries are used to get specific information from a database. Query results are special tables within the database. To demonstrate the use of queries, we will use two different methods: • Using our CD-Collection table, we will create a list of albums by a particular artist. We will do this using the Wizard.
Step 1: Select the fields. 1) Select the CD-Collection table from the dropdown list of tables. 2) Select fields from the CD-Collection table in the Available fields list. a) Click Artist, and use the > button to move it to the Fields in the Query list. b) Move the AlbumTitle and DatePurchased fields in the same manner. c) Click Next. Tip To change the order of the fields, select the field you want to move and click the up or down arrow.
2) Click the second Sort by dropdown list. • Click CD-Collection.ArtistTitle. and select Ascending. 3) Repeat this process for CD-Collection.DatePurchased. 4) Click Next. Step 3: Select the search conditions. The search conditions allow us to compare the name we entered with the names of the artist in our database and decide whether to include a particular artist in our query or not.
Step 1: Open the first query in Design View. Click Create Query in Design View. Step 2: Add tables. Figure 220: Add Tables or Query window 1) Click Fuel to highlight it. 2) Click Add. Click Close. Tip Move the cursor over the bottom edge of the fuel table (Figure 221) and drag the to make it longer and easier to see all of the fields in the table. Figure 221: Fuel table in query Step 3: Add fields to the table at the bottom. 1) Double-click the FuelID field in the Fuel table.
Step 4: Set the criterion for the query. We want the query’s FuelID to begin with the numeral 1. 1) Type >0 in the Criterion cell under FuelID in the query table. 2) Click the Run Query icon in the Query Design toolbar. Figure 223: Query Design toolbar Figure 224 contains the Fuel table with my entries and the query results based upon the Fuel table: the query results are in the right table. Figure 224: Fuel table and query of the fuel table Step 5: Save and close the query.
Figure 226: Tables in this query 1) Double-click FuelQuantity in the End-Reading query. 2) Double-click Odometer in the End-Reading query. 3) Double-click Odometer in the Fuel table. Figure 227: Added fields to the query Step 8: Enter the FuelID difference field. We want the difference between the FuelID value of the Fuel table and FuelID value of the End-Reading query to equal one (1). 1) Type "End-Reading".FuelID - Fuel.FuelID in the field to the right of the Odometer field of the Fuel Table.
Figure 229: Field for distance traveled calculations 3) Calculate fuel economy: Type ("End-Reading".Odometer – Fuel.Odometer)/"EndReading".FuelQuantity in the next column to the right of the word Field. Figure 230: Fuel economy calculation field Note When entering fields for these calculations, you must follow this format: table or query name followed by a period follow by the field name. For hyphenated or multiple-word names (table or query), use double quotes around the table or query name.
Figure 232: Query table with aliases added 3) Run the query again. The results are in Figure 233. Figure 233: Query run with aliases We really do not need the column showing the difference between the FuelID fields from the table and query, so we will hide it. While it will not be visible, it will still be used in the calculations. 4) Hide a field that does not need to be seen. Remove the check in the box of the Visible cell as in Figure 234.
Creating reports Reports provide information found in the database in a useful way. In this they are similar to queries. Reports are generated from the database’s tables or queries. They can contain all of the fields of the table or query or just a selected group of fields. Reports can be static or dynamic. Static reports contain the data in the selected fields at the time the report was created. Dynamic reports can be updated to show the latest data.
The fields we need for the first report from the Vacations table are: Date, Motel, Toll, Breakfast, Lunch, Supper, SnackCost, and Miscellaneous. This report will not require an additional query. The second report involves the Fuel table. Since this table includes fuel purchases at times other than during the vacation, we need to create a query that contains only the fuel purchased during the vacation. Vacations table report To create a new report.
Step 4: Sort options We do not want to do any additional sorting. Click Next. Step 5: Choose layout Use default settings for the layout. Click Next. Step 6: Create report • • • Note Label the report: Vacation Expenses. Select Static report. Click Finish. If you feel adventurous, try selecting some of the other layout choices. After selecting a choice, drag the Report Wizard window out of the way so that you can see what you have selected.
Note When a new report is opened in this way, the query used to open it is automatically selected in the Tables or queries dropdown list in the Report Wizard. 4) Create the report. Use >> to move both fields from the Available fields list to the Fields in report list. Click Next. 5) Label fields. Add a space to FuelCost to make it Fuel Cost (two words). Click Next. 6) Group fields. Click Date to highlight it. Use > to move the Date field to the Groupings list. Click Next. 7) Choose layout.
b) c) In the Fuel table list, double-click to add FuelCost to the bottom table (Figure 240). Save and close the query. Figure 240: Adding an additional field to the query 2) Add the FuelCost field from the End-Reading query to the Fuel Economy query: • Right-click the Fuel Economy query and select Edit from the pop-up menu. • Double-click the FuelCost field in the End-Reading query list to add it to the query table at the bottom. 3) Add a calculation field to the right of the FuelCost field.
Modifying a report At the end of the last section, we left the Fuel Statistics report open in the edit mode (Figure 241). We will be working on that report. These same steps can be used with any report that you open for editing. Figure 241: A report in edit mode The Author is the name you listed in Tools > Options > OpenOffice.org > User Data. The date is not correct. The columns need to be moved to the left to give a better appearance.
This can also be done with the last column on the right even though there is no black border. It should now look something like Figure 243. Figure 243: Realigned columns in a report Step 3: Change the number formatting in the cells. The fuel quantity should have three decimal places. The Begin, End, and Distance should have one decimal place. Fuel Cost should be currency and have two decimal places, and Cost per mile should have three decimal places.
Figure 245: Final report More ways to create reports An extension is available to assist in report creation. Sun Report Builder creates stylish, complex database reports. You can define group and page headers, group and page footers, and calculation fields. It is available from http://extensions.services.openoffice.org/. To install this extension, follow these steps: 1) Choose Tools > Extension Manager from the menu bar. In the Extension Manager dialog, click Get more extensions online....
9 Chapter Getting Started with Math OpenOffice.
What is Math? Math is OpenOffice.org’s component for writing mathematical equations. It is most commonly used as an equation editor for text documents, but it can also be used with other types of documents or stand-alone. When used inside Writer, the equation is treated as an object inside the text document. Note The equation editor is for writing equations in symbolic form, as in equation 1. If you want to evaluate a numeric value, see the Calc Guide.
Entering a formula The equation editor uses a markup language to represent formulas. For example, %beta creates the Greek character beta ( ). This markup is designed to read similar to English whenever possible. For example, a over b produces a fraction: a . b You can enter a formula in three ways: • Select a symbol from the Elements window. • Right-click on the equation editor and select the symbol from the context menu. • Type markup in the equation editor.
Example 1: 5×4 For this example we will enter a simple formula: 5×4 . On the Elements window: 1) Select the top-left button of the categories (top) section. 2) Click on the multiplication symbol.
Figure 250: Result of entering 5 and 4 next to the times operator Right-click menu Another way to access mathematical symbols is to right-click on the equation editor. This pops up the menu shown in Figure 251. The items in this menu correspond exactly to those in the Elements window. Figure 251: Right-click menu Markup You can type the markup directly in the equation editor. For example, you can type 5 times 4 to obtain 5×4 . If you know the markup, this can be the fastest way to enter a formula.
Below is a short list of common equations and their corresponding markup. Display Command Display Command a=b a=b a sqrt {a} a2 a^2 an a_n ∫ f x dx int f(x) dx ∑ an sum a_n a≤b a <= b ∞ infinity a×b a times b x⋅y x cdot y Greek characters Greek characters ( , , , , and so on) are common in mathematical formulas. These characters are not available in the Elements window or on the right-click menu.
Figure 252: Symbols catalog—used for entering Greek characters and some special symbols. Example 2: π ≃ 3.14159 For this example we will suppose that: • We want to enter the above formula (the value of pi rounded to 5 decimal places). • We know the name of the Greek character (pi). • But we do not know the markup associated with the ≃ symbol. Step 1: Type % followed by the text pi. This displays the Greek character . Step 2: Open the Elements window (View > Elements).
Step 4: Click on the a ≃ b symbol. The equation editor now shows the markup %pi simeq . Step 5: Delete the text and add 3.14159 at the end of the equation. We end up with the markup %pi simeq 3.14159. The result is shown in Figure 255. Figure 255: Final result Customizations Formula editor as a floating window The formula editor can cover a large part of the Writer window.
Figure 257: Formula editor as a floating window How can I make a formula bigger? This is one of the most common questions people ask about Math. The answer is simple, but not intuitive: 1) Start the formula editor and choose Format > Font size. Figure 258: Changing the font size for a formula 2) Select a larger font size under Base size (top-most entry). Figure 259: Edit Base size (top) to make a formula bigger. The result of this change is illustrated in Figure 260.
Figure 260: Result of changing the base font size. Formula layout The most difficult part of using Math comes when writing complicated formulas. This section provides some advice. Brackets are your friends Math knows nothing about order of operation. You must use brackets to state the order of operations explicitly. Consider the following example. Markup 2 over Result x + 1 2 over {x + 1} 2 1 x 2 x1 Equations over more than one line Suppose you want to type an equation covering more than one line.
Markup Result n ∑ ak sum from k = 1 to n a_k k =1 int from 0 to x f(t) dt or x ∫ f t dt int_0^x f(t) dt or 0 x ∫0 f t dt ∫f int from Re f ℜ ∞ ∑ 2−n sum to infinity 2^{-n} For more details on integrals and sums, see the Math Guide. Note Brackets with matrices look ugly! For background, we start with an overview of the matrix command. Markup Result a b c d matrix { a # b ## c # d } Rows are separated by two #’s and entries within each row are separated by one #.
How do I make a derivative? Making derivatives essentially comes down to one trick: Tell Math it’s a fraction. In other words, you have to use the over command. Combine this with either the letter d (for a total derivative) or the partial command (for a partial derivative) to achieve the effect of a derivative. Note Notice that we have to use braces (squiggly brackets) to make the derivative.
Figure 261: Changing spacing in a matrix formula Numbering equations Equation numbering is one of Math’s best hidden features. The steps are simple, but obscure: 1) Start a new line. 2) Type fn and then press F3. The fn is replaced by a numbered formula: E=mc 2 (2) Now you can double-click on the formula to edit it.
Figure 262: Inserting a cross-reference to an equation number 266 Getting Started with OpenOffice.org 3.
10 Chapter Printing, Exporting, and E-mailing 267
Introduction This chapter provides general information about printing, exporting, and e-mailing documents from OOo. Quick printing Click the Print File Directly icon printer defined for your computer. Note to send the entire document to the default You can change the action of the Print File Directly icon to send the document to the printer defined for the document instead of the default printer for the computer.
The Print dialog has four tabs, from which you can choose a range of options, as described in the following sections. The options selected on the Print dialog apply to this printing of this document only. Note To specify default printing settings for OOo, go to Tools > Options > OpenOffice.org – Print and Tools > Options > OpenOffice.org [Component] – Print. See Chapter 2 (Setting Up OOo) for more details. The different components of OOo have different available print settings, as summarized in Table 2.
Figure 265: General print options Printing multiple pages on a single sheet of paper You can print multiple pages of a document on one sheet of paper. To do this: 1) In the Print dialog, select the Page Layout tab (Figure 266). Figure 266: Printing multiple page per sheet of paper 2) In the Layout section, select from the drop-down list the number of pages to print per sheet. The preview panel on the left of the Print dialog shows how the printed document will look.
3) In the Page sides section, select whether to print all pages or only some pages. 4) Click the Print button. Tip In Writer, to print two pages per sheet in “facing pages” (book layout) style, print from Print Preview instead. See page 276. Selecting pages/sheets/slides to print In addition to printing a full document, you can choose to print individual pages/ sheets/slides, ranges of pages/sheets/slides, or a selection of a document.
Figure 267: Printing a selection of text Calc You can choose single sheets, multiple sheets, and selections of cells for printing. Figure 268: Choosing what to print in Calc Printing an individual sheet: 1) In the spreadsheet, click on the sheet tab to select the sheet you want to print. 2) Choose File > Print from the menu bar. 272 Getting Started with OpenOffice.org 3.
3) In the Ranges and copies section of the Print dialog, choose the Selected sheets option. 4) Click the Print button. Printing a range of sheets: 1) In the spreadsheet, select the sheets to print. a) Select the first sheet. b) Hold down the Control key. c) Click on the additional sheet tabs. d) Release the Control key when all required sheets are selected. 2) Choose File > Print from the menu bar. 3) In the Ranges and copies section of the Print dialog, choose the Selected sheets option.
Printing a range of pages: 1) Choose File > Print from the menu bar. 2) Select the slides to print. a) In the Ranges and copies section of the Print dialog, select the Slides option. b) Enter the number of the slides to print (for example 1-4 or 1,3,7,11). 3) Click the Print button. Printing a selection of a slide, or a selection from multiple slides: 1) In the document, select the section of the slide to print. 2) Choose File > Print from the menu bar.
To print a brochure on a single-sided printer: 1) Choose File > Print. 2) In the Print dialog, click Properties. 3) Check the printer is set to the same orientation (portrait or landscape) as specified in the page setup for your document. Usually the orientation does not matter, but it does for brochures. Click OK to return to the Print dialog. 4) Select the Page layout tab in the Print dialog. 5) Select the Brochure option.
Printing in black and white (on a color printer) You may wish to print documents in black and white on a color printer. Several choices are available. Please note that some color printers may print in color regardless of the settings you choose. Change the printer settings to print in black and white or grayscale: 1) Choose File > Print to open the Print dialog. 2) Click Properties to open the Properties dialog for the printer.
To use Page Preview: 1) Choose File > Page Preview (or click the Page Preview button on the Standard toolbar). Writer now displays the Page Preview toolbar instead of the Formatting toolbar. Figure 269. Page Preview toolbar (Writer) 2) Select the required preview icon: Two Pages ( Book Preview ( ), Multiple Pages ( ) or ). 3) To print the document from this view, click the Print document icon( open the Print dialog. 4) Choose the print options and click the Print button to print.
Controlling PDF content and quality For more control over the content and quality of the resulting PDF, use File > Export as PDF. The PDF Options dialog opens. This dialog has five pages (General, Initial View, User Interface, Links, and Security). Select the appropriate settings, and then click Export. Then you are asked to enter the location and file name of the PDF to be created, and click Save to export the file.
Range section • All: Exports the entire document to PDF. • Pages: To export a range of pages, use the format 3-6 (pages 3 to 6). To export single pages, use the format 7;9;11 (pages 7, 9, and 11). You can also export a combination of page ranges and single pages, by using a format like 36;8;10;12. • Selection: Exports all the selected material. Images section • Lossless compression: Images are stored without any loss of quality. Tends to make large files when used with photographs.
on an odd page, OOo inserts a blank page between the two odd pages. This option controls whether to export that blank page. • Embed standard fonts: In previous versions of OOo, the standard fonts (Times, Helvetica, Courier, Symbol, and ZapfDingbats) were only embedded into the PDF when the resulting file was of the PDF/A type, since the PDF/A standards requires this. In version 3.3, you can choose to embed these fonts in all PDF documents created by OOo to enhance display accuracy in PDF viewers.
• Display document title. Causes the PDF viewer to display the document’s title in the title bar. User interface options section • Hide menubar. Causes the PDF viewer to hide the menu bar. • Hide toolbar. Causes the PDF viewer to hide the toolbar. • Hide window controls. Causes the PDF viewer to hide other window controls. Figure 273: User Interface page of PDF Options dialog Transitions In Impress, displays slide transition effects as their respective PDF effects.
Figure 274: Links page of PDF Options dialog Export URLs relative to file system If you have defined relative links in a document, this option exports those links to the PDF. Cross-document links Defines the behavior of links clicked in PDF files. Security page of PDF Options dialog PDF export includes options to encrypt the PDF (so it cannot be opened without a password) and apply some digital rights management (DRM) features. • With an open password set, the PDF can only be opened with the password.
Figure 275: Security page of PDF Options dialog Figure 276: Setting a password to encrypt a PDF Chapter 10 Printing, Exporting, and E- mailing 283
Exporting to other formats OOo uses the term “export” for some file operations involving a change of file type. If you cannot find what you want under File > Save As, look under File > Export as well. OpenOffice.org can export files to XHTML. In addition, OOo Draw and OOo Impress can export to Adobe Flash (.swf) and a range of image formats. To export to one of these formats, choose File > Export.
Figure 277: Select starting document 2) On the second page, select E-mail message and click Next. Figure 278: Select document type 3) On the third page, click the Select Address List button. Select the required address list (even if only one is shown) and then click OK. (If the address list you need is not shown here, you can click Add to find it and add it to the list.
Figure 279: Selecting an address list 4) Back on the Select address list page, click Next. On the Create salutation page, deselect This document should contain a salutation. Figure 280: Deselecting a salutation 5) In the left-hand list, click 8. Save, print or send. OOo displays a “Creating documents” message and then displays the Save, print or send page of the Wizard. 6) Select Send merged document as E-Mail. The lower part of the page changes to show e-mail settings choices.
Figure 281: Sending a document as an email message 7) Type a subject for your email and click Send documents. OOo sends the emails. Digital signing of documents To sign a document digitally, you need a personal key, also known as a certificate. A personal key is stored on your computer as a combination of a private key, which must be kept secret, and a public key, which you add to your documents when you sign them.
To sign a document: 1) Choose File > Digital Signatures. 2) If you have not saved the document since the last change, a message box appears. Click Yes to save the file. 3) After saving, you see the Digital Signatures dialog. Click Add to add a public key to the document. 4) In the Select Certificate dialog, select your certificate and click OK. 5) You see again the Digital Signatures dialog, where you can add more certificates if you want. Click OK to add the public key to the saved file.
11 Chapter Graphics, the Gallery, and Fontwork 289
Introduction You can add graphic and image files, including photos, drawings, scanned images, and others, to OpenOffice.org documents. OOo can import various vector (line drawing) and raster (bitmap) file formats. The most commonly used graphic formats are GIF, JPG, PNG, and BMP. See Appendix B for a full list of the graphic formats OOo can import.
Figure 282. Insert picture dialog Linking an image file If the Link option in the Insert picture dialog is selected, OOo creates a link to the file containing the image instead of saving a copy of the image in the document. The result is that the image is displayed in the document, but when the document is saved, it contains only a reference to the image file—not the image itself. The document and the image remain as two separate files, and they are merged together only when you open the document again.
Embedding linked images If you originally linked the images, you can easily embed one or more of them later if you wish. To do so: 1) Open the document in OpenOffice.org and choose Edit > Links. 2) The Edit Links dialog (Figure 283) shows all the linked files. In the Source file list, select the files you want to change from linked to embedded. 3) Click the Break Link button. 4) Save the document.
Inserting an image using a scanner If a scanner is connected to your computer, OOo can call the scanning application and inserted the scanned item into the OOo document as an image. To start this procedure, place the cursor where you want the graphic to be inserted and chooe Insert > Picture > Scan > Select Source. Although this practice is quick and easy, it is unlikely to result in a high-quality image of the correct size.
To insert an object as a link: 1) Choose Tools > Gallery and select a theme. 2) Select an object with a single click, then while pressing the Shift and Control keys, drag and drop the object into the document. Inserting an image as a background To insert an image as the background to a page or paragraph: 1) Choose Tools > Gallery and select a theme. 2) Select an object with a single click, right-click on the object, and choose Insert > Background > Page or > Paragraph.
By default, the Gallery is docked above the workspace. To expand the Gallery, position the pointer over the line that divides it from the top of the workspace. When the pointer changes to parallel lines with arrows, click and drag downward. The workspace resizes in response. As for other docked windows, you can “float” the Gallery by moving the mouse pointer over an edge of the Gallery window, holding down the Control key, and double-clicking. Repeat this procedure to dock the Gallery again.
Deleting images from the Gallery To delete an image from a theme that you created: 1) Right-click on the name of the image file or its thumbnail in the Gallery. 2) Click Delete on the pop-up menu. A message appears, asking if you want to delete this object. Click Yes. Note Deleting the name of a file from the list in the Gallery does not delete the file from the hard disk or other location.
Creating an image map An image map defines areas of an image (called hotspots) with hyperlinks to web addresses, other files on the computer, or parts of the same document. Hotspots are the graphic equivalent of text hyperlinks (described in Chapter 12). Clicking on a hotspot causes OOo to open the linked page in the appropriate program (for example, the default browser for an HTML page; OOo Calc for a .ODS file; a PDF viewer for a PDF file).
• Load, Save, and Select icons. • Tools for drawing a hotspot shape: these tools work in exactly the same way as the corresponding tools in the Drawing toolbar. • Edit, Move, Insert, Delete Points: advanced editing tools to manipulate the shape of a polygon hotspot. Choose the Edit Points tool to activate the other tools. • Active icon: toggles the status of a selected hotspot between active and inactive. • Macro: associates a macro with the hotspot instead of just associating an hyperlink.
Creating drawing objects To begin using the drawing tools, display the Drawing toolbar (Figure 287) by clicking View > Toolbars > Drawing. If you are planning to use the drawing tools repeatedly, you can tear off this toolbar and move it to a convenient place on the window. 1 2 3 4 Select Line Rectangle Ellipse 5 6 7 8 Freeform Line Text Callouts Basic Shapes 9 10 11 12 Symbol Shapes Block arrows Flowcharts Callouts 13 14 15 16 17 Stars Points Fontwork Gallery From File Extrusion On/Off Figure 287.
1 Line 5 Line Color 9 To Foreground 13 Alignment 2 Arrow Style 6 Area 10 To Background 14 Change Anchor 3 Line Style 7 Area Style / Filling 11 Bring to Front 15 Ungroup 4 Line Width 8 Rotate 12 Send to Back 16 Group Figure 288. Drawing Object Properties toolbar The default you set applies to the current document and session. It is not retained when you close the document or close Writer, and it does not apply to any other document you open.
Using Fontwork With Fontwork you can create graphical text art objects for making your work more attractive. There are many different settings for text art objects (line, area, position, size, and more), so you have a large choice. You will surely find one that fits your document. Fontwork is available with each component of OOo, but you will notice small differences in the way that each component displays it.
Figure 290: The Fontwork Gallery 3) Double-click the object to edit the Fontwork text. Type your own text in place of the black Fontwork text that appears over the object (Figure 291). Figure 291: Editing Fontwork text 4) Click anywhere in a free space or press Esc to apply your changes. Editing a Fontwork object Now that the Fontwork object is created, you can edit some of its attributes. To do this, you can use the Fontwork toolbar, the Formatting toolbar, or menu options as described in this section.
Using the Fontwork toolbar Make sure that the Fontwork toolbar, shown in Figure 289, is visible. If you do not see it, go to View > Toolbars > Fontwork. Click on the different icons to edit Fontwork objects. Fontwork Shape: Edits the shape of the selected object. You can choose from a palette of shapes. Figure 292: Fontwork toolbar showing palette of shapes Fontwork Same Letter Heights: Changes the height of characters in the object.
Fontwork Character Spacing: Changes the character spacing and kerning in the object. For custom spacing, input a percentage value: 100% is normal spacing; less than 100% is tight spacing; more than 100% is expanded spacing. Using the Formatting toolbar Now let us go further and customize the Fontwork object with several more attributes. Click on the Fontwork object. The Formatting toolbar changes to show the options for editing the object.
Line options Line icon: Opens a dialog with three tabs: Line, Line Styles, Arrow Styles. Use the Line tab to edit the most common properties of the line around the selected Fontwork object, by choosing from previously-defined attributes including line style, line color, and arrow styles. Use the Lines Styles and Arrow Styles tabs to edit the properties of line and arrow styles, and define new styles. Arrow Style icon: Choose from the different arrow styles.
• As Character - The object is placed in the document like any character and moves with the paragraph as you add or delete text before the object. Ungroup icon: Ungroup the selected objects, so you can manage them individually. Group icon: Group the selected objects, so you can manage them as a single object. Using menu options You can use some the choices on the Format menu to anchor, align, arrange and group selected Fontwork objects, wrap text around them, and flip them horizontally and vertically.
12 Chapter Creating Web Pages Saving Documents as HTML Files 307
Introduction This chapter describes how to do the following in Writer, Calc, Draw and Impress: • Create hyperlinks within a document and to other documents such as web pages, PDFs, and other files. • Save documents as web pages (HTML documents). When creating a document that you plan to deliver as a web page, you need to consider the following: • In an HTML document, hyperlinks are active (clickable) but other crossreferences inserted by OOo are not active links.
Creating hyperlinks When you type text (such as a website addresses or URL) that can be used as a hyperlink, and then press the spacebar or the Enter key, OOo automatically creates the hyperlink and applies formatting to the text (usually a color and underlining). If this does not happen, you can enable this feature using Tools > AutoCorrect Options > Options and selecting the URL Recognition option.
Figure 296: Inserting a hyperlink using the Navigator When using the Navigator to hyperlink to an object such as a graphic, to have the hyperlink show useful text such as 2009 Sales Graph, you need to give such objects useful names instead of leaving them as the default names (“Graphics6”), or you need to edit the resulting link text using the Hyperlink dialog, as described below.
On the left side, select one of the four categories of hyperlink: • Internet: the hyperlink points to a web address, normally starting with http:// • Mail & News: the hyperlink opens an email message that is pre-addressed to a particular recipient • Document: the hyperlink points to another document or to another place in the current document • New document: the hyperlink creates a new document The top right part of the dialog changes according to the choice made for the hyperlink category in the left pa
• Name is applicable to HTML documents. It specifies text that will be added as a NAME attribute in the HTML code behind the hyperlink. • Events button : click this button to open the Assign Macro dialog and choose a macro to run when the link is clicked. See Chapter 13 (Getting Started with Macros) for more information. Editing hyperlinks To edit an existing link, click anywhere in the link text and then click the Hyperlink icon on the Standard toolbar or choose Edit > Hyperlink from the menu bar.
Saving a document as a series of web pages Writer can save a large document as a series of web pages (HTML files) with a table of contents page. To do this: 1) Decide which headings in the document should start on a new page and make sure all those headings have the same style (for example, Heading 1). 2) Choose File > Send > Create HTML Document. 3) In the Name and Path dialog, type the file name to save the pages under. Also specify which style indicates a new page (as decided in step 1).
2) Choose or browse to the document you would like to format. The Title, Summary and Author information is picked up from the document’s properties; if necessary, edit it. Click Next. 314 Getting Started with OpenOffice.org 3.
3) Chose a layout for the web site by clicking on the layout boxes. Click Next. 4) Chose the information to be listed and the screen resolution. Click Next.
5) Select a style for the page. Use the drop-down list to choose different styles and color combinations. You can browse to a background image and icon set from the Gallery. Click Next. 6) Enter general information such as Title and HTML Metadata information. Click Next. 7) Chose where to save the file and preview the page if you wish. Click Finish. 316 Getting Started with OpenOffice.org 3.
To edit or view the document’s underlying HTML code, open the document, and then choose View > HTML Source or click the HTML Source icon on the Main toolbar. Saving Calc spreadsheets as web pages Calc can save files as HTML documents. As for Writer, choose File > Save As and select HTML Document, or choose File > Wizards > Web Page. If the file contains more than one sheet, the additional sheets will follow one another in the HTML file. Links to each sheet will be placed at the top of the document.
Note Depending on the size of your presentation and the number of graphics it contains, the HTML export function may create many HTML, JPG, and GIF files. If you simply save to your desktop (not in a specific folder), these separate HTML and graphics files will be all over your desktop. So be sure to create a folder to hold all the files. 3) Choose the design for all of the pages, either from an existing design or by creating a new one.
5) Decide how the images will be saved (PNG, GIF, or JPG) and what resolution to use. When choosing a resolution, consider what the majority of your viewers might be using. If you specify a high resolution, then a viewer with a mediumresolution monitor will have to scroll sideways to see the entire slide, which isprobably not desirable. 6) If Create title page was chosen in step 4, supply the information for it on the next page.
7) Choose the navigation button style to use to move from one page to another. If you do not choose any, OOo will create a text navigator. 8) Select the color scheme for the web pages. Available schemes include the document’s existing scheme, one based upon browser colors, and a completely user-defined scheme. You can save a new scheme so that it will appear on the first page of the HTML export wizard. 320 Getting Started with OpenOffice.org 3.
9) Click Create to generate the HTML files. If this is a new design, a small dialog pops up. If you might want to reuse this design, you can give it a name and save it. Otherwise, click Do Not Save. Saving Draw documents as web pages Exporting drawings from OpenOffice.org’s Draw application is similar to exporting a presentation from Impress. Choose File > Export and select HTML Document as the file type.
13 Chapter Getting Started with Macros Using the Macro Recorder 322
Your first macros A macro is a saved sequence of commands or keystrokes that are stored for later use. An example of a simple macro is one that “types” your address. The OpenOffice.org macro language is very flexible, allowing automation of both simple and complex tasks. Macros are especially useful to repeat a task the same way over and over again. OpenOffice.org macros are usually written in a language called StarBasic, or just abbreviated Basic.
Listing 2: Contents of Module1 after it is created. REM ***** BASIC ***** Sub Main End Sub Add the new macro either before Sub Main or after End Sub. In Listing 3, the new macro has been added before Sub Main. Listing 3: Module1 after adding the new macro. REM ***** BASIC ***** Sub HelloMacro Print "Hello" End Sub Sub Main End Sub Click on the Run Basic button in the toolbar to run the first macro in the module.
Figure 300: OOo Macro Organizer dialog, DBInspection library selected 4) Be certain to open the library container named My Macros. Find the library named Standard under My Macros. Be warned, every library container has a library named Standard. Select the Standard library and click New Module to create a new module to contain the macro. 5) The default module name is Module1. Type a descriptive name and click OK to create the module. The OpenOffice.
Figure 302: Select your macro and click Run There are other methods to run a macro. For example, use Tools > Macros > Organize Macros > OpenOffice.org Basic to open the macro organizer, which contains a Run button as well. Another method is to use the macro organizer; the dialog usually opens faster, but the selection process may be slightly slower. Viewing and editing the macro You can view and edit the macro that was just created. Use Tools > Macros > Organize Macros > OpenOffice.
dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args1()) end sub The macro in Listing 4 is not as complicated as it first appears. Learning a few things helps significantly in understanding the generated macros. The discussion starts with features near the top of the macro listing and describes them. If you like to avoid details, then simply change the text “Andrew Pitonyak” in the macro above to what you want to insert at the current cursor position.
Pulling the macro together The following details are very complete; it is not important to understand all of the details. The first line defines the start of the macro. sub EnterMyName Declare two variables: dim document as object dim dispatcher as object ThisComponent refers to the current document. The CurrentController property of a document refers to a service that “controls” the document. For example, when you type, it is the current controller that notices.
A complicated example I frequently copy rows and columns of data from a web site and format them as a table in a text document. First, I copy the table from the web site to the clipboard. To avoid strange formatting and fonts, I paste the text into a Writer document as unformatted text. I reformat the text with tabs between columns so that I can use Table > Convert > Text to Table to convert to a table.
14) 15) 16) 17) Press Tab to insert a tab between the number and the name. Press Home to move to the start of the line. Press down arrow to move to the next line. Stop recording the macro and save the macro. It takes much longer to read and write the steps than to record the macro. Work slowly and think about the steps as you do them. With practice this becomes second nature. The generated macro has been modified to contain the step number in the comments to match the code to the step above.
rem (7) Press Ctrl+Shift+Right Arrow to select the number. dispatcher.executeDispatch(document, ".uno:WordRightSel", "", 0, Array()) rem (8) Press Ctrl+C to copy the selected text to the clipboard. dispatcher.executeDispatch(document, ".uno:Copy", "", 0, Array()) rem (9) Press End to move the cursor to the end of the line. dispatcher.executeDispatch(document, ".uno:GoToEndOfLine", "", 0, Array()) rem (10) Press Backspace twice to remove the two trailing spaces. dispatcher.executeDispatch(document, ".
The IDE has a Run Basic icon in the toolbar that runs the first macro in the IDE. Unless you change the first macro, it is the empty macro named Main. Modify Main so that it reads as shown in Listing 6. Listing 6: Modify Main to call CopyNumToCol1. Sub Main CopyNumToCol1 End Sub Now, you can run CopyNumToCol1 by repeatedly clicking the Run Basic icon in the toolbar of the IDE. This is very fast and easy, especially for temporary macros that will be used a few times and then discarded.
organization dialogs, inserting special characters, and similar types of dialogs. Other possible problems using the macro recorder include things such as inserting a formula, setting user data, setting filters in Calc, actions in database forms, and exporting a document to an encrypted PDF file. You never know for certain what will work unless you try it, however. The actions from the search dialog are properly captured, for example.
A computer scientist would use Figure 304 to precisely describe the situation. The text “1..*” means one or more, and “0..*” means zero or more. The black triangle means composed of or contains. • A library container contains one or more libraries, and each library is contained in one library container. • A library contains zero or more modules, and each module is contained in one library. • A module contains zero or more macros, and each macro is contained in one module.
Every library container contains a library named Standard. It is better to create your own libraries with meaningful names than to use the Standard library. Not only are meaningful names easier to manage, but they can also be imported into other library containers whereas the Standard library cannot. Caution OpenOffice.org allows you to import libraries into a library container, but it will not allow you to overwrite the library named Standard.
Figure 306: The macro organizer dialog Importing macros The OpenOffice.org Macro Organizer dialog provides functionality to create, delete, and rename libraries, modules, and dialogs. Select the library container to use and then click the Import button to import macro libraries (see Figure 307). Tip You cannot import the library named Standard. Tip On Linux, the OpenOffice.org-specific files are stored in a directory whose name begins with a period.
Navigate to the directory containing the library to import. There are usually two files from which to choose, dialog.xlb and script.xlb. It does not matter which of these two files you select; both will be imported. Select a file and click Open to continue. Figure 308: Choose library import options If the library already exists, it will not be replaced unless Replace existing libraries is checked.
How to run a macro A typical method to run a macro is as follows: 1) Use Tools > Macros > Run Macro to open the Macro Selector dialog (see Figure 309). 2) Select the library and module in the Library list (left hand side). 3) Select the macro in the Macro name list (right hand side). 4) Click Run to run the macro. Figure 309: Use the Macro Selector dialog to run macros Although you can use Tools > Macros > Run Macro to run all macros, this is not efficient for frequently run macros.
To add a menu item, keyboard shortcut, or toolbar icon that calls a macro, use the Customize dialog (see Figure 308). Open this dialog in either of these ways: • Choose Tools > Customize from the main menu bar. • Each toolbar has an icon that opens a menu; choose the Customize Toolbar option. Figure 310: OpenOffice.org Customize dialog Tip Complete coverage of the Customize dialog is beyond the scope of this document. Click the Help button to access the help pages included with OpenOffice.org.
Menu item Use Tools > Customize to open the Customize dialog, and select the Menus tab. You can modify an existing menu, or create new menus that call macros. For more about modifying menus, see Chapter 14. Keyboard shortcuts Use Tools > Customize to open the Customize dialog, and select the Keyboard tab. Assigning keyboard shortcuts is discussed in Chapter 14. Event In OpenOffice.org, when something happens, we say that an event occurred.
Figure 311: Assign macro to an application level event Figure 312: Assign macro to the document open event Chapter 13 Getting Started with Macros 341
Figure 313: PrintHello is assigned to the Open Document event Extensions An extension is a package that can be installed into OpenOffice.org to add new functionality. Extensions can be written in almost any programming language and may be simple or sophisticated.
MsgBox "This macro only works with a text document" Exit Sub End If REM Get the view cursor from the current controller. oCurs = oDoc.currentController.getViewCursor() REM Move the cursor to the end of the document oCurs.gotoEnd(False) REM Insert text "Hello" at the end of the document oCurs.Text.insertString(oCurs, "Hello", False) End Sub Finding more information Numerous resources are available that provide help with writing macros. Use Help > OpenOffice.org Help to open the OOo help pages.
Printed and eBook materials The following books are available for purchase in both printed and eBook form from their publishers. Andrew Pitonyak’s OpenOffice.org Macros Explained. See http://www.hentzenwerke.com/catalog/oome.htm. Dr. Mark Alexander Bain’s Learn OpenOffice.org Spreadsheet Macro Programming. See http://www.packtpub.com/openoffice-ooobasic-calc-automation/book. 344 Getting Started with OpenOffice.org 3.
14 Chapter Customizing OpenOffice.
Introduction This Appendix describes some common customizations that you may wish to do. You can customize menus, toolbars, and keyboard shortcuts in OpenOffice.org, add new menus and toolbars, and assign macros to events. However, you cannot customize context (right-click) menus. Other customizations are made easy by extensions that you can install from the OpenOffice.org website or from other providers. Note Customizations to menus and toolbars can be saved in a template.
3) In the Save In drop-down list, choose whether to save this changed menu for the application (for example, OpenOffice.org Writer) or for a selected document (for example, MyDoc.odt). 4) In the section OpenOffice.org [name of the program (example: Writer)] Menus, select from the Menu drop-down list the menu that you want to customize. The list includes all the main menus as well as submenus (menus that are contained under another menu).
Modifying existing menus To modify an existing menu, select it in the Menu list and click the Menu button to drop down a list of modifications: Move, Rename, Delete. Not all of these modifications can be applied to all the entries in the Menu list. For example, Rename and Delete are not available for the menus supplied by OOo. To move a menu (such as File), choose Menu > Move. A dialog similar to the one shown in Figure 315 (but without the Menu name box) opens.
Figure 316: Adding a command to a menu Customizing toolbars You can customize toolbars in several ways, including choosing which icons are visible and locking the position of a docked toolbar, as described in Chapter 1 (Introducing OpenOffice.org). This section describes how to create new toolbars and add other icons (commands) to the list of those available on a toolbar.
Figure 317. The Toolbars page of the Customize dialog Creating a new toolbar To create a new toolbar: 1) Choose Tools > Customize > Toolbars from the menu bar. 2) Click New. On the Name dialog, type the new toolbar's name and choose from the Save In drop-down list where to save this changed menu: for the application (for example, Writer) or for a selected document. The new toolbar now appears on the list of toolbars in the Customize dialog.
2) The Add Commands dialog is the same as for adding commands to menus (Figure 316). Select a category and then the command, and click Add. The dialog remains open, so you can select several commands. When you have finished adding commands, click Close. If you insert an item which does not have an associated icon, the toolbar will display the full name of the item: the next section describes how to choose an icon for a toolbar command.
Figure 319: Setting up OOo for sending faxes 4) Click the arrow icon at the end of the Standard toolbar. In the drop-down menu, choose Customize Toolbar. The Toolbars page of the Customize dialog appears (Figure 317). Click Add. 5) On the Add Commands dialog (Figure 320), select Documents in the Category list, then select Send Default Fax in the Commands list. Click Add. Now you can see the new icon in the Commands list.
Assigning shortcut keys In addition to using the built-in keyboard shortcuts (listed in Appendix A), you can define your own. You can assign shortcuts to standard OOo functions or your own macros and save them for use with the entire OpenOffice.org suite. Caution Be careful when reassigning your operating system’s or OOo’s predefined shortcut keys. Many key assignments are universally understood shortcuts, such as F1 for Help, and are always expected to provide certain results.
Figure 321. Defining keyboard shortcuts for applying styles 5) Choose the category of style. (This example uses a paragraph style, but you can also choose character styles and others.) The Function list will display the names of the available styles for the selected category. The example shows some of OOo’s predefined styles. 6) To assign Ctrl+9 to be the shortcut key combination for the List 1 style, select List 1 in the Function list, and then click Modify.
3) Next enter a name for the keyboard configuration file in the File name box, or select an existing file from the list. If you need to, browse to find a file from another location. 4) Click Save. A confirmation dialog appears if you are about to overwrite an existing file, otherwise there will be no feedback and the file will be saved.
Tip To get extensions that are listed in the repository, you can open the Extension Manager and click the Get more extensions here link. Figure 322: Using the Extension Manager Note To install a shared extension, you need write access to the OpenOffice.org installation directory. Some popular extensions This section describes a few of the more important and popular extensions to OpenOffice.org. In each case, you need to first install the extension as described in the previous section.
Documents with more sophisticated layouts, such as those created with professional desktop publishing applications that use special fonts and complex vector graphics, are not suitable for the PDF Import Extension. Similarly, longer documents (> 20 pages) may cause some performance and stability problems.
A Appendix Keyboard Shortcuts 358
Introduction You can use OpenOffice.org (OOo) without requiring a pointing device, such as a mouse or trackball, by using its built-in keyboard shortcuts. This appendix lists some of the most common built-in keyboard shortcuts that apply to all components of OpenOffice.org. For shortcuts specific to Writer, Calc, Impress, Draw, or Base read the relevant component guide or search the application Help.
General keyboard shortcuts Opening menus and menu items Shortcut Keys Result Alt+ Opens a menu where is the underlined character of the menu you want to open. For example, Alt+T opens the menu Tools. Alt++<*> Opens a menu item where is the underlined character of the menu you want to open and <*> is the item within that menu. For example, Alt+T+G opens the Gallery menu item in the menu Tools. Esc Closes an open menu.
Getting help Shortcut Keys Result F1 Opens OOo Help dialog. In OOo Help: jumps to first help page of the selected tab. Shift+F1 Turns cursor into the What’s This? question mark. Shows tip for an item underneath the cursor. Shift+F2 Shows tip for a selected item. Esc In OOo Help: goes up one level. Managing documents Shortcut Keys Result Ctrl+F4 or Alt+F4 Closes the current document. Closes OpenOffice.org when the last open document is closed. Ctrl+O Launches Open dialog to open a document.
Editing Shortcut Keys Result Ctrl+X Cuts selected items. Ctrl+C Copies selected items. Ctrl+V Pastes copied or cut items from the clipboard. Ctrl+Shift+V Opens the Paste Special dialog. Ctrl+A Selects all. Ctrl+Z Undoes last action. Ctrl+Y Redoes last action. Ctrl+Shift+Y Repeats last command. Ctrl+F Opens the Find & Replace dialog. Ctrl+Shift+F Searches for the last entered search term. Ctrl+Shift+R Refreshes (redraws) the document view.
B Appendix Open Source, Open Standards, OpenDocument 363
Introduction OpenOffice.org is both a product and an open-source project. If you are new to OOo, its open source development, and the community that produces and supports it, you should read this appendix. A short history of OpenOffice.org The OpenOffice.org project began when Sun Microsystems released the source code (“blueprints”) for its StarOffice® software to the open source community on October 13, 2000. OpenOffice.org 1.0, the product, was released on April 30, 2002.
What is “open source”? The four essential rights of open-source software are embodied within the Free Software Foundation’s General Public License (GPL): • • • • The right to use the software for any purpose. Freedom to redistribute the software for free or for a fee. Access to the complete source code of the program (that is, the “blueprints”). The right to modify any part of the source, or use portions of it in other programs.
OpenDocument filename extensions The most common filename extensions used for OpenDocument documents are: *.odt for word processing (text) documents *.ods for spreadsheets *.odp for presentations *.odb for databases *.odg for graphics (vector drawings) *.odf for formulas (mathematical equations) Frequently asked questions May I distribute OOo to anyone? Yes. How many computers may I install it on? As many as you like. May I sell it? Yes. May I use OpenOffice.org in a business? Yes.
Why do I need Java to run OOo? Is it written in Java? OpenOffice.org is not written in Java; it is written in the C++ language. Java is one of several languages that can be used to extend OOo. The Java JDK/JRE is only required for some features. The most notable one is the HSQLDB relational database engine. Note: Java is available at no cost. If you do not want to use Java, you can still use nearly all of the features of OOo. How can I contribute to OpenOffice.
Opening spreadsheets In addition to OpenDocument formats (.ods and .ots), Calc 3 can open the formats used by OOo 1.x (.sxc and .stc) and the following spreadsheet formats: Microsoft Excel 97/2000/XP (.xls, .xlw, and .xlt) Microsoft Excel 4.x–5.0/95 (.xls, .xlw, and .xlt) Microsoft Excel 2003 XML (.xml) Microsoft Excel 2007 XML (.xlsx, .xlsm, .xlts, .xltm) Microsoft Excel 2007 binary (.xlsb) Lotus 1-2-3 (.wk1, .wks, and .123) Data Interchange Format (.dif) Rich Text Format (.rtf) Text CSV (.csv and .
File formats OOo can save to Saving in an OpenDocument format guarantees the correct rendering of the file when it is transferred to another person or when the file is re-opened with a later version of OpenOffice.org. It is strongly recommended that you use ODF as default file format. However, you can save files in other formats, if you wish. Tip When sharing a document that you do not expect or want the recipient to modify, the safest option is to convert the document to PDF. OpenOffice.
StarCalc 3.0, 4.0, and 5.0 formats (.sdc and .vor) Unified Office Format spreadsheet (.uos) HTML Document (OpenOffice.org Calc) (.html and .htm) Pocket Excel (.pxl) Note The Java Runtime Environment is required to use the mobile device filters for AportisDoc (Palm), Pocket Word, and Pocket Excel. Saving presentations In addition to OpenDocument formats (.odp, .otp, and .odg), Impress 3 can save in these formats: OpenOffice.org 1.x Presentation (.sxi) OpenOffice.org 1.x Presentation Template (.
Index 3 3D objects 199 A accepting or rejecting changes 101 accessibility features 361 accessibility options 44 adding macros from other sources 322 advantages of OpenOffice.
cross-fading 197 cross-references inserting references 102 overview 102 CSV file open 110 save 111 CSV files 109, 111 Ctrl-click required to follow hyperlinks 42 curves, Draw 185 custom dictionary 52 Customize dialog 338 customizing keyboard shortcuts 352 menus 345 toolbars 348 cut and paste 83 D dashes 86 data editing, Calc changing data in a cell 129 removing data from a cell 128 replacing all data in a cell 128 data entry, Calc dates and times 124 fill series 125 Fill tool 125 numbers 123 numbers as tex
Flash export 199 HTML export 199 inserting pictures 199 line 182 rectangle 183 save in a foreign format 199 Drawing Object Properties toolbar 298 drawing objects 3D objects 199 grouping 299 grouping and combining 198 positioning 199 properties 298 Drawing toolbar 178, 298 drawing tools 297 duplication 196 dynamic gradients 196 E E-mail options 53 e-mailing Mail Merge Wizard 284 several recipients 284 Writer document as attachment 283 edit document properties before saving 47 editing data, Calc 128 ellipse,
formatting pages 94 Formatting toolbar 18 formatting, Calc AutoFormat 133 conditional 134 themes 134 formula bar, Calc 108 formula editor See: equation editor 260 formula files, opening 367 formula layout 262 Free Software Foundation (FSF) 364 freeform line, Draw 185 function key shortcuts 361 Function Wizard, Calc 108 hidden objects 190 hiding and showing data, Calc 134 high contrast 34 history of OpenOffice.
function keys 361 loading from a file 354 resetting to default values 354 saving to a file 353 keyboard shortcuts (macros) 338 L landscape pages 74 language settings 51 language support 11 layout methods 94 Layout pane 159 layout, selecting (Impress) 156 LGPL 365 libraries of macros 332 library containers 332 licensing of OpenOffice.
Calc 112 new document 23 non-breaking hyphen 86 non-breaking spaces 86 nonconsecutive items, selecting 82 Normal view (Impress) 149 Notes view (Impress) 149 numbered list 161 numbering equations 265 numbering pages 96 O OASIS 12 objects adjusting size 191 arranging 190 dynamic movement 191 dynamic size modification 191 framing 190 hidden 190 moving 191 rotating 192 selecting several 191 ODF format version, saving 47 ODF plugin (Sun) 81 Office Assistant (Microsoft) 33 online update options 45 OOo Macro Orga
grayscale on color printer 276 handouts 274 headers and footers, Calc 141 Impress and Draw 273 multiple pages per sheet 270 notes (Impress) 274 page break, Calc 140 page order, details, scale, in Calc 138 page orientation 269 rows or columns on every page 139 selecting what to print 271 Writer 271 Professional Template Pack extension 356 Q queries (database) aliases 243 creating using a Wizard 237 creating using Design View 239 joined fields 217 search conditions 239 Query Wizard (database) 237 Quickstarte
adding pictures 163 adding tables 164 adding text 158 layouts 156 master 166 modifying 158 rename 153 Slides pane (Impress) 146 snap functions 179 Snap to grid 179 Solaris system requirements 12 Solver for Nonlinear Programming (for Calc) 356 sort order (database fields) 238 sorting records, Calc 136 special characters 85, 89 spelling checker 87 spelling options 52 spreadsheet using as data source 230 spreadsheets adding to slides 165 cell reference 111 definition 106 navigate 111 opening 367 saving 368 sav
toolbars 148 adding commands 349 choosing icons for commands 350 Color Bar 178 creating 349 customizing 20 displaying or hiding 18 Draw 177 Drawing 178 Fontwork 300 Line and Filling toolbar 177 moving 19 Options Bar (Draw) 178 overview 18 show or hide icons 20 tooltips 33, 157 track changes 100 transparency 195, 196 two-digit years 34 typing errors, autocorrect 124 U undo change 28 undoing groups 198 unformatted text, pasting 161 ungrouping 198 unit of measurement 176 unsaved changes flag 78 URL Recognitio
