Getting Started with LibreOffice 4.
Copyright This document is Copyright © 2010–2013 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. Contributors Jean Hollis Weber Martin Fox Andrew Pitonyak John A Smith Jeremy Cartwright Dan Lewis Hazel Russman Laurent Balland-Poirier Ron Faile Jr.
Contents Copyright..................................................................................................................................... 2 Preface.................................................................................................................................. 9 Who is this book for?................................................................................................................. 10 What's in this book?...........................................................
Applying styles........................................................................................................................... 61 Modifying styles......................................................................................................................... 63 Creating new (custom) styles..................................................................................................... 65 Copying styles from a template or document......................................................
Viewing Calc............................................................................................................................ 129 Using the keyboard.................................................................................................................. 131 Speeding up data entry............................................................................................................ 133 Sharing content between sheets.....................................................................
Arranging, aligning and distributing objects.............................................................................. 212 Inserting and editing pictures................................................................................................... 213 Working with 3D objects.......................................................................................................... 213 Exporting graphics...................................................................................................
Using LibreOffice’s drawing tools............................................................................................. 312 Using Fontwork........................................................................................................................ 314 Chapter 12 Creating Web Pages........................................................................................................ 321 Introduction...........................................................................................
Introduction.............................................................................................................................. 376 A short history of LibreOffice.................................................................................................... 376 The LibreOffice community...................................................................................................... 376 How is LibreOffice licensed?..........................................................................
Preface
Who is this book for? Anyone who wants to get up to speed quickly with LibreOffice will find this Getting Started Guide valuable. You may be new to office software, or you may be familiar with another office suite.
Paid support and training Alternatively, you can pay for support services. Service contracts can be purchased from a vendor or consulting firm specializing in LibreOffice. Table 1: Free support for LibreOffice users Free LibreOffice support FAQs Answers to frequently asked questions http://www.libreoffice.org/get-help/faq/ http://wiki.documentfoundation.org/Faq Documentation User guides, how-tos, and other documentation. http://www.libreoffice.org/get-help/documentation/ https://wiki.documentfoundation.
If you wish, you can change your LibreOffice software package to display Galaxy icons as follows: 1) On Linux and Windows operating systems, go to Tools > Options >LibreOffice > View on the main menu bar to open the dialog for view options. 2) On a Mac operating system, go to LibreOffice > Preferences > View on the main menu bar to open the dialog for view options. 3) In User interface > Icon size and style select Galaxy from the options available in the dropdown list.
Figure 1: Dialog showing common controls In most cases, you can interact only with the dialog (not the document itself) as long as the dialog remains open. When you close the dialog after use (usually, clicking OK or another button saves your changes and closes the dialog), then you can again work with your document. Some dialogs can be left open as you work, so you can switch back and forth between the dialog and your document. An example of this type is the Find & Replace dialog.
Frequently asked questions How is LibreOffice licensed? LibreOffice is distributed under the Open Source Initiative (OSI) approved Lesser General Public License (LGPL). The LGPL license is available from the LibreOffice website: http://www.libreoffice.org/download/license/ May I distribute LibreOffice to anyone? Yes. How many computers may I install it on? As many as you like. May I sell it? Yes. May I use LibreOffice in my business? Yes.
New features in LibreOffice 4 LibreOffice 4.0 offers a large number of new characteristics, which are listed on this page: https://www.libreoffice.org/download/4-0-new-features-and-fixes. Here are some highlights: • Integration with several content and document management systems – including Alfresco, IBM FileNet P8, Microsoft Sharepoint 2010, Nuxeo, OpenText, SAP NetWeaver Cloud Service and others – through the CMIS standard.
Chapter 1 Introducing LibreOffice
What is LibreOffice? LibreOffice is a freely available, fully-featured office productivity suite. Its native file format is Open Document Format (ODF), an open standard format that is being adopted by governments worldwide as a required file format for publishing and accepting documents. LibreOffice can also open and save documents in many other formats, including those used by several versions of Microsoft Office. LibreOffice includes the following components.
Math (formula editor) Math is the LibreOffice formula or equation editor. You can use it to create complex equations that include symbols or characters not available in standard font sets. While it is most commonly used to create formulae in other documents, such as Writer and Impress files, Math can also work as a standalone tool. You can save formulae in the standard Mathematical Markup Language (MathML) format for inclusion in web pages and other documents not created by LibreOffice.
Minimum requirements LibreOffice 4.0 requires one of the following operating systems: • Microsoft Windows XP, Vista, Windows 7, or Windows 8 • GNU/Linux Kernel version 2.6.18, glibc2 v2.5 or higher, and gtk v2.10.4 or higher • Mac OS X 10.4 (Tiger) or higher Administrator rights are needed for the installation process. Some LibreOffice features (wizards and the HSQLDB database engine) require that the Java Runtime Environment (JRE) is installed on your computer.
Figure 2: LibreOffice Start Center Starting from an existing document You can start LibreOffice by double-clicking the filename that is an ODF document in a file manager such as Windows Explorer. The appropriate component of LibreOffice will start and the document will be loaded. If Microsoft Office is installed on your computer and you have associated Microsoft Office file types with LibreOffice, when you double-click on the file: • For a Word file (*.doc or *.docx), it opens in Writer.
Figure 3: Quickstarter menu in Windows Disabling Quickstarter To close Quickstarter, right-click on the icon in the system tray, and then click Exit Quickstarter in the pop-up menu. The next time the computer is restarted, Quickstarter will be loaded again. To prevent LibreOffice from loading Quickstarter during system startup, deselect the Load LibreOffice during system start-up item on the pop-up menu. You might want to do this if your computer has insufficient memory, for example.
• 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.
Sub-menus and tool palettes Toolbar icons with a small triangle to the right will display sub-menus, tool palettes, and other ways of selecting things, depending on the icon. Tool palettes can be made into a floating toolbar and Figure 4 shows an example of a tool palette from the Drawing toolbar made into a floating toolbar. See “Moving toolbars” and “Floating toolbars” below for more information on moving and floating these toolbars created from tool palettes.
Figure 6: Selection of visible toolbar icons • Click Customise Toolbar to open the Customise dialog, see Chapter 14 Customizing LibreOffice for more information. • Click Dock Toolbar to dock the selected toolbar. By default, a toolbar will dock at the top of the workspace. You can reposition the toolbar to a different docked position; see “Moving toolbars” on page 24. • Click Dock All Toolbars to dock all floating toolbars. By default, toolbars will dock at the top of the workspace.
Context menus Context menus are a quick access to many menu functions and are opened by right-clicking on a paragraph, graphic, or other object. When a context menu opens, the functions or options available will be dependent on the object that has been selected. A context menu can be the easiest way to reach a function, especially if you are not sure where a function is located in the menus or toolbars. Status bar The status bar is located at the bottom of the workspace.
Zoom percentage Indicates the magnification level of the document. Right-click on the percentage figure to open a list of magnification values from which to choose. Double-clicking on this percentage figure opens the Zoom & View Layout dialog. Starting new documents You can start a new, blank document in LibreOffice in several ways. When LibreOffice is open but no document is open, the Start Center (Figure 2 on page 21) is shown.
On computers operating Microsoft Windows or Mac OS X, you can select to use the LibreOffice Open/Save dialogs or the ones provided by the computer operating system. See “Open and Save As dialogs” on page 31 for more information. Note Saving documents You can save documents as follows: • Using the Save command if you are keeping the document, its current filename and location.
Figure 9: Example of an operating system Save dialog When the Save As dialog (Figure 8) or Save dialog (Figure 9) opens, enter the file name, change the file format (if applicable), navigate to a new location (if applicable), and click Save. The dialog that opens when using the Save As command depends on the options that have been set in LibreOffice. See “Open and Save As dialogs” on page 31 for more information.
Figure 10: Set Password dialog Caution LibreOffice uses a very strong encryption mechanism that makes it almost impossible to recover the contents of a document if you lose or forget the password. Changing password When a document is password-protected, you can change the password while the document is open. Go to File > Properties > General on the main menu bar and click the Change Password button in the Properties dialog. This opens the Set Password dialog where you can enter a new password.
Renaming and deleting files You can rename or delete files within the LibreOffice dialogs, just as you can in a file manager. Select a file and then right click to open a context menu. Select either Delete or Rename, as appropriate. However, you cannot copy or paste files within the dialogs. Open and Save As dialogs You can choose whether to use the LibreOffice Open and Save As dialogs or the ones provided by your operating system.
Figure 11: Navigator in Calc The Navigator provides several convenient ways to move around a document and find items in it: • When a category is showing the list of objects in it, double-click on an object to jump directly to that object location in the document. • Objects are much easier to find if you have given them recognisable names when creating them, instead of keeping the LibreOffice default names, for example Sheet1, Table1, Table2, and so on.
Closing a document If there is only one document open and you want to close the document, go to File > Close on the menu bar or click on the X on the menu bar. If more than one document is open, go to File > Close on the menu bar or click on the X on the title bar of the window. The X may be located on either the right or left end of the title bar. When the last document is open, the X on the menu bar appears. If the document has not been saved since the last change, a message box is displayed.
Chapter 2 Setting up LibreOffice Choosing options to suit the way you work
Choosing options for all of LibreOffice This section covers some of the settings that apply to all the components of LibreOffice. For information on settings not discussed here, see the online help. Click Tools > Options. The list in the left-hand box of the Options – LibreOffice dialog varies depending on which component of LibreOffice 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 LibreOffice on the left-hand side.
Fill in the form (shown in Figure 13), or amend or delete any existing incorrect information. If you are using a version of LibreOffice other than US English, some field labels may be different from those shown in the illustrations. General options The options on the LibreOffice – General page are described below. Figure 14: Setting general options for LibreOffice 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.
Document status – Allow to save document even when the document is not modified Normally when a document has not been modified, the File > Save menu option and the Save icon on the Standard toolbar are disabled and the keyboard shortcut Ctrl+S has no effect. Select this option to allow documents to be saved even when they have not been modified. Year (two digits) Specifies how two-digit years are interpreted.
View options The options on the LibreOffice – 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. Figure 16: Choosing View options for LibreOffice applications User Interface – Scaling If the text in the help files or on the menus of the LibreOffice user interface is too small or too large, you can change it by specifying a scaling factor.
Figure 17. Font list (Left) With preview; (Right) Without preview Font Lists - Show font history Causes the last five fonts you have assigned to the current document to be displayed at the top of the font list. Otherwise fonts are shown in alphabetical order. Graphics output – Use hardware acceleration Directly accesses hardware features of the graphical display adapter to improve the screen display. Not supported on all operating systems and LibreOffice distributions.
Function Clipboard Selection clipboard Copy content Edit > Copy Ctrl+C Select text, table, or object. Paste content Edit > Paste Ctrl+V pastes at the cursor position. Clicking the middle mouse button pastes at the mouse pointer position. Pasting into another document No effect on the clipboard contents. The last marked selection is the content of the selection clipboard. Selection – Transparency Determines the appearance of selected text or graphics, which appear on a shaded background.
Paths options On the LibreOffice – Paths page, you can change the location of files associated with, or used by, LibreOffice 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 19 and click Edit. On the Select Path dialog (not shown; may also be titled Edit Paths), add or delete folders as required, and then click OK to return to the Options dialog.
Figure 20: Defining colors to use in color palettes in LibreOffice Alternatively, click the Edit button to open the Color Picker dialog, shown in Figure 21. Here you can select a color from the window on the left, or you can enter values on the right using your choice of RGB, CMYK, or HSB (Hue, Saturation and Brightness) values.
in the Name box, then click the Add button. A small box showing the new color is added to the Color table. Another way to define or alter colors is through the Colors page of the Area dialog, where you can also save and load palettes, a feature that is not possible here. In Calc, draw a temporary draw object and use the context menu of this object to open the Area dialog. If you load a palette in one component of LibreOffice, it is only active in that component; the other components keep their own palettes.
Table 2. Font substitution replacement actions Always checkbox checked Screen only checkbox blank Replacement action checked checked Font replacement only on screen, whether the font is installed or not. blank checked Font replacement only on screen, but only if font is not available. blank blank Font replacement on screen and when printing, but only if font is not available. Font replacement on screen and when printing, whether the font is installed or not.
Security options and warnings The following options are on the Security options and warnings dialog (Figure 24). Remove personal information on saving Select this option to always remove user data from the file properties when saving the file. To manually remove personal information from specific documents, deselect this option and then use the Delete button under File > Properties > General.
the Visit Firefox Personas button (an internet connection is required for this choice). Installation instructions are on the dialog. Full details about Personas are on the website http://www.getpersonas.
Figure 28: Showing or hiding text, object, and table boundaries Accessibility options Accessibility options include whether to allow animated graphics or text, how long help tips remain visible, some options for high contrast display, and a way to change the font for the user interface of the LibreOffice program. Accessibility support relies on the Java Runtime Environment for communication with assistive technology tools.
Advanced Java options If you install or update a Java Runtime Environment (JRE) after you install LibreOffice, or if you have more than one JRE installed on your computer, you can use the LibreOffice – Java options page to choose the JRE for LibreOffice to use. If you are a system administrator, programmer, or other person who customizes JRE installations, you can use the Parameters and Class Path pages (reached from the Java page) to specify this information.
Figure 31: Online update options Choosing Load/Save options You can set the Load/Save options for loading and saving documents 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. General Most of the choices on the Load/Save – General page are familiar to users of other office suites. Some items of interest are described below. Figure 32.
Load user-specific settings with the document A LibreOffice document contains certain settings that are read from the user’s system. When you save a document, these settings are saved with it. Select this option so that when a document loads, it ignores the stored settings in favor of the settings on your computer.
Examples File system Internet relative ../images/img.jpg ../images/img.jpg absolute file:///c|/work/images/img.jpg http://myserver.com/work/images/img.jpg If you choose to save relatively, the references to embedded graphics or other objects in your document will be saved relative to the location in the file system. In this case, it does not matter where the referenced directory structure is recorded.
Figure 33: Choosing Load/Save VBA Properties Save original Basic code takes precedence over Load Basic code. If both options are selected and you edit the disabled code in LibreOffice, the original Microsoft Basic code will be saved when saving in a Microsoft Office format. To remove any possible macro viruses from the Microsoft Office document, deselect Save original Basic code. The document will be saved without the Microsoft Basic code.
HTML compatibility Choices made on the Load/Save – HTML Compatibility page affect HTML pages imported into LibreOffice and those exported from LibreOffice. See HTML documents; importing/exporting in the Help for more information. Figure 35. Choosing HTML compatibility options 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.
document. Once you have created the macro in the LibreOffice Basic IDE, it appears in the source text of the HTML document in the header. If you want the macro to run automatically when the HTML document is opened, choose Tools > Customize > Events. See Chapter 13, Getting Started with Macros, for more information. Export - Display warning When the LibreOffice Basic option (see above) is not selected, the Display warning option becomes available.
On the right-hand side of the Language Settings – Languages page, change the User interface, Locale setting, Default currency, and Default languages for documents as required. In the example, English (USA) has been chosen for all the appropriate settings. Figure 37: Choosing language options If you want the language setting to apply to the current document only, instead of being the default for all new documents, select For the current document only.
Figure 38: Choosing languages, dictionaries, and options for checking spelling Choosing Internet options Use the Internet Options pages to define search engines and save proxy settings for use with LibreOffice. If you are using a Mozilla browser (such as Firefox) on Windows or Linux, you can enable the Browser Plug-in so you can open LibreOffice files in your browser, print them, save them, and work with them in other ways.
Figure 40: Specifying a MediaWiki server account Controlling LibreOffice’s AutoCorrect functions Some people find some or all of the items in LibreOffice’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.
Chapter 3 Using Styles and Templates
What is a template? A template is a document 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.
• Frame styles are used to format graphic and text frames, including wrapping type, borders, backgrounds, and columns. • 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.
Tip At the bottom of the Styles and Formatting window is a drop-down list. In Figure 42 the window shows Automatic, meaning the list includes only styles applied automatically by LibreOffice. You can choose to show all styles or other groups of styles, for example only custom styles.
Figure 43: The Apply Style list on the Formatting toolbar Using keyboard shortcuts Some keyboard shortcuts for applying styles are predefined. For example, in Writer Ctrl+0 applies the Text body style, Ctrl+1 applies the Heading 1 style, and Ctrl+2 applies the Heading 2 style. You can modify these shortcuts and create your own; see Chapter 14, Customizing LibreOffice, for instructions.
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 rightclick and select New.
Calc Drag a cell selection to the Styles and Formatting window to create cell styles. Draw/Impress Select and drag drawing objects to the Styles and Formatting window to create graphics styles. Copying styles from a template or document You can copy styles into a document by loading them from a template or from another document: 1) Open the document you want to copy styles into.
To delete unwanted styles, right-click on them (one at a time) in the Styles and Formatting window and click Delete on the context menu. If the style is not in use, you receive a confirmation message; click Yes to delete the style. If the style is in use, you receive a warning message asking you to confirm deletion. Caution Make sure the style is not in use before deletion. Otherwise, all objects with that style will return to the default style and retain their formatting as manual formatting.
Creating a template Note In a new installation, only the MediaWiki folder in Documents, and the Presentation Backgrounds folder in Presentations are visible. Other folders become visible only when content is added (My Templates, for example). If this is the case when you come to save your template, follow the instructions in Saving a template to a hidden folder on page 69, to save your template to one of these folders, or to another user folder.
Any settings that can be added to or modified in a document can be saved within a template.
Figure 50: Moving a file to My Templates 4) Click on Move to folder to open a menu of destination folders. Select a destination folder for the template. In the example above, My Templates is selected. The file is moved. 5) Now click on All Templates. The My Templates folder is no longer hidden and shows the Floor Plan template file in the folder.
To create a template using a wizard: 1) From the main menu, choose File > Wizards > [type of template required]. Figure 52. Creating a template using a wizard 2) Follow the instructions on the pages of the wizard. This process is slightly different for each type of template, but the format is very similar. 3) In the last section of the wizard, you can specify the template name which will show in the Template Manager, and also the name and location for saving the template.
2) Navigate to the template that you want to edit. Click once on it to activate the file handling controls (see Figure 50). Click Edit. The template opens in LibreOffice. 3) Edit the template just as you would any other document. To save your changes, choose File > Save from the main menu. Updating a document from a changed template The next time you open a document that was created from the changed template, the following message appears. Figure 53.
you may find collections of templates that have been packaged into extension (OXT) files. These are installed a little differently, as described below. Installing individual templates To install individual templates: 1) Download the template and save it anywhere on your computer. 2) Import the template into a template folder by following the instructions in “Importing a template“ on page 77.
4) When the package installation is complete, the templates are available for use through File > New > Templates and the extension is listed in the Extension Manager. See Chapter 14, Customizing LibreOffice, for more about the Extension Manager. Setting a default template If you create a document by choosing File > New > Text Document (or Spreadsheet, Presentation, or Drawing) from the main menu, LibreOffice creates the document from the default template for that type of document.
Figure 55: Resetting the default template for text documents Associating a document with a different template At times you might want to associate a document with a different template, or perhaps you are working with a document that did not start from a template. One of the major advantages of using templates is the ease of updating styles in more than one document, as described on page 72.
To begin, choose File > New > Templates to open the Template Manager dialog. Figure 56: Template file handling icons Creating a template folder To create a template folder: 1) In the Template Manager dialog, doube-click any folder, then click any template to activate the row of icons above the list of templates (see Figure 56). 2) Click the Move to folder button and choose New folder from the drop-down menu. 3) In the pop-up dialog, type a name for the new folder and click Accept.
Deleting a template You cannot delete templates supplied with LibreOffice 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 Manager dialog, double-click the folder that contains the template you want to delete. 2) Click the template that you want to delete. 3) Click the Delete button above the list of templates. A message box appears and asks you to confirm the deletion. Click Yes.
Figure 57: Flow of page styles Dividing a document into chapters In a similar way, you can divide a document into chapters. Each chapter might start with the First Page style, with the following pages using the Default page style, as above. At the end of the chapter, insert a manual page break and specify the next page to have the First Page style to start the next chapter, as shown in Figure 58.
Compiling an automatic table of contents To compile an automatic table of contents, first apply styles to the headings you want to appear in the contents list, then use Tools > Outline Numbering to tell Writer which styles go with which level in the table of contents. See Chapter 4 for more information. Defining a sequence of styles You can set up one paragraph style so that when you press Enter at the end of that paragraph, the following paragraph automatically has the style you wish applied to it.
Chapter 4 Getting Started with Writer Word Processing with LibreOffice
What is Writer? Writer is the word processor component of LibreOffice.
Status bar The Writer status bar provides information about the document and convenient ways to quickly change some document features. Figure 60: Left end of status bar Figure 61: Right 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.
Selection mode Click to choose different selection modes. The icon does not change, but when you hover the mouse pointer over this field, a tooltip indicates which mode is active. When you click in the field, a context menu displays the available options. Mode Effect Standard selection Click in the text where you want to position the cursor; click in a cell to make it the active cell. Any other selection is deselected.
Zoom To change the view magnification, drag the Zoom slider, or click on the + and – signs, or rightclick on the zoom level percent to pop up a list of magnification values from which to choose. Zoom interacts with the selected view layout to determine how many pages are visible in the document window. Changing document views Writer has several ways to view a document: Print Layout, Web Layout, and Full Screen. To access these and other choices, go to the View menu and click on the required view.
The Navigation toolbar (Figure 65) shows icons for all the object types shown in the Navigator, plus some extras (for example, the results of a Find command). Figure 65: Navigation toolbar 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.
Figure 66. Saving a file in Microsoft Word format Working with text Working with text (selecting, copying, pasting, moving) in Writer is similar to working with text in any other program. LibreOffice also has some convenient ways to select items that are not next to each other, select a vertical block of text, and paste unformatted text. Selecting items that are not consecutive To select nonconsecutive items (as shown in Figure 67) using the mouse: 1) Select the first piece of text.
Figure 67: Selecting items that are not next to each other To select nonconsecutive items using the keyboard: 1) Select the first piece of text. (For more information about keyboard selection of text, see the topic “Navigating and selecting with the keyboard” in the Help.) 2) Press Shift+F8. This puts Writer in “Adding selection” mode. 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.
Cutting, copying, and pasting text Cutting and copying text in Writer is similar to cutting and copying text in other applications. You can use the mouse or the keyboard for these operations. You can copy or move text within a document, or between documents, by dragging or by using menu selections, icons, or keyboard shortcuts. You can also copy text from other sources such as Web pages and paste it into a Writer document.
Using the Find toolbar If the Find toolbar is not visible, you can display it by choosing View > Toolbars > Find from the menu bar or by pressing Ctrl+F. The Find toolbar is shown docked at the bottom of the LibreOffice window (just above the Status Bar) in Figure 70, but you can float it or dock it in another location. For more information on floating and docking toolbars, see Chapter 1, Introducing LibreOffice.
4) When you have set up your search, click Find. To replace the found text, click Replace. For more information on using Find & Replace, see the Writer Guide. Tip Caution If you click Find All, LibreOffice selects all instances of the search text in the document. Similarly, if you click Replace All, LibreOffice replaces all matches. Use Replace All with caution; otherwise, you may end up with some hilarious (and highly embarrassing) mistakes.
Inserting dashes and non-breaking spaces and hyphens To prevent two words from being separated at the end of a line, press Ctrl+Shift when you type the space between the two words. 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 Shift+Ctrl+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.
Figure 73: Selecting a default tab stop interval You can also set or change the measurement unit for rulers in the current document by rightclicking 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. Figure 74: Changing the measurement unit for a ruler Checking spelling and grammar Writer provides a spelling checker, which can be used in two ways.
Using built-in language tools Writer provides some tools that make your work easier if you mix multiple languages within the same document or if you write documents in various languages. The main advantage of changing the language for a text selection is that you can then use the correct dictionaries to check spelling and apply the localized versions of Autocorrect replacement tables, thesaurus, and hyphenation rules.
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. To turn off Word Completion, select Tools > AutoCorrect Options > Word Completion and deselect Enable word completion.
Inserting AutoText To insert AutoText, type the shortcut and press F3. Formatting text Using styles is recommended Styles are central to using Writer. Styles enable you to easily format your document consistently, and to change the format with minimal effort. A style is a named set of formatting options. When you apply a style, you apply a whole group of formats at the same time. In addition, styles are used by LibreOffice for many processes, even if you are not aware of them.
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 > Clear Direct Formatting from the menu bar, or right-click and choose Clear Direct Formatting from the context menu, or use Ctr
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. Use View > Toolbars > Bullets and Numbering to see the toolbar.
3) On the Paragraph Style dialog (Figure 79), go to the Text Flow page. 4) Under Hyphenation, select or deselect the Automatically option. Click OK to save. 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.
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 > LibreOffice > Appearance, and paragraph end, tabs, breaks, and other items in Tools > Options > LibreOffice 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”.
After a header has been created, a down-arrow appears on the header marker. Click on this arrow to drop down a menu of choices for working with the header (Figure 82). Figure 82: Header menu To format a header, you can use either the menu item shown in Figure 82 or Format > Page > Header. Both methods take you to the same tab on the Page Style dialog. Inserting header and footer contents Other information such as document titles and chapter titles is often put into the header or footer.
Restarting page numbering Often you will want to restart the page numbering at 1, for example on the page following a title page or a table of contents. In addition, many documents have the “front matter” (such as the table of contents) numbered with Roman numerals and the main body of the document numbered in Arabic numerals, starting with 1. You can restart page numbering in two ways. Method 1: 1) Place the cursor in the first paragraph of the new page. 2) Choose Format > Paragraph.
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 double-headed arrow. 2) Hold down the left mouse button and drag the mouse to move the margin. Figure 84: Moving the margins Caution The small arrowheads on the ruler (the gray triangles) are used for indenting paragraphs.
If more than one person edits the document, each author is automatically allocated a different background color. Right-clicking on a comment pops up a menu where you can delete the current comment, all the comments from the same author, or all the comments in the document. From this menu, you can also apply some basic formatting to the text of the comment. You can also change the font type, size, and alignment from the main menu.
separate index containing only the common names of species. Before creating some types of indexes, you first need to create index entries embedded in your Writer document.
Tip Not all changes are recorded. For example, changing a tab stop from align left to align right, and changes in formulas (equations) or linked graphics are not recorded. Using fields Fields are extremely useful features of Writer. They are used for data that changes in a document (such as the current date or the total number of pages) and for inserting document properties such as name, author, and date of last update.
6) Drag the item to where you want to insert the hyperlink in the document. The name of the item is inserted in the document as an active hyperlink. You can also use the Hyperlink dialog to insert and modify hyperlinks within and between documents. See Chapter 12, Creating Web Pages.
Figure 87: The Cross-references tab of the Fields dialog Using bookmarks Bookmarks are listed in the Navigator and can be accessed directly from there with a single mouse click. You can cross-reference to bookmarks and create hyperlinks to bookmarks, as described above. 1) Select the text you want to bookmark. Click Insert > Bookmark. 2) On the Insert Bookmark dialog, the larger box lists any previously defined bookmarks. Type a name for this bookmark in the top box, and then click OK.
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.
Chapter 5 Getting Started with Calc Using Spreadsheets in LibreOffice
What is Calc? Calc is the spreadsheet component of LibreOffice. 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 or sheet. Other features provided by Calc include: • • • • Functions, which can be used to create formulas to perform complex calculations on data.
Figure 89: Calc main dialog • File – contains commands that apply to the entire document; for example Open, Save, Wizards, Export as PDF, Print, Digital Signatures and so on. • Edit – contains commands for editing the document; for example Undo, Copy, Changes, Fill, Plug-in and so on. • View – contains commands for modifying how the Calc user interface looks; for example Toolbars, Column & Row Headers, Full Screen, Zoom and so on.
Calc toolbars can be either docked and fixed in place, or floating allowing you to move a toolbar into a more convenient position on your workspace. Docked toolbars can be undocked and moved to different docked position on the workspace or undocked to become a floating toolbar. Toolbars that are floating when opened can be docked into a fixed position on your workspace. The default set of icons (sometimes called buttons) on toolbars provide a wide range of common commands and functions.
These column and row headers form the cell references that appear in the Name Box on the Formula Bar (Figure 90). If the headers are not visible on your spreadsheet, go to View on the main menu bar and select Column & Row Headers. Sheet tabs In Calc you can have more than one sheet in a spreadsheet. At the bottom of the grid of cells in a spreadsheet are sheet tabs indicating how many sheets there are in your spreadsheet. Clicking on a tab enables access to each individual sheet and displays that sheet.
Status bar The Calc status bar (Figure 92) provides information about the spreadsheet and convenient ways to quickly change some of its features. Most of the fields are similar to those in other components of LibreOffice; see Chapter 1 Introducing LibreOffice in this guide and the Calc Guide Chapter 1 Introducing Calc for more information.
The various options for importing CSV files into a Calc spreadsheet are as follows: • Import – Character Set – specifies the character set to be used in the imported file. – Language – determines how the number strings are imported. If Language is set to Default for CSV import, Calc will use the globally set language. If Language is set to a specific language, that language will be used when importing numbers. – From Row – specifies the row where you want to start the import.
Saving spreadsheets To save a spreadsheet, see Chapter 1 Introducing LibreOffice for more details on how to save files manually or automatically. Calc can also save spreadsheets in a range of formats and also export spreadsheets to PDF, HTML and XHTML file formats, see the Calc Guide Chapter 6 Printing, Exporting, and E-mailing for more information. Saving in other spreadsheet formats If you need to exchange files with users who are unable to receive spreadsheet files in Open Document Format (ODF) (*.
Figure 95: Confirm File Format dialog Figure 96: Export Text File dialog for CSV files Tip To have Calc save documents by default in a file format other than the default ODF format, go to Tools > Options > Load/Save > General. In Default file format and ODF settings > Document type, select Spreadsheet, then in Always save as, select your preferred file format. Navigating within spreadsheets Calc provides many ways to navigate within a spreadsheet from cell to cell and sheet to sheet.
Figure 97: Navigator dialog in Calc • Using the Navigator – click on the Navigator icon on the Standard toolbar or press the F5 key to open the Navigator dialog (Figure 97). Type the cell reference into the Column and Row fields and press the Enter key. • Using the Enter key – pressing Enter moves the cell focus down in a column to the next row. Pressing Shift+Enter moves the focus up in a column to the next row. • Using the Tab key – pressing Tab moves the cell focus right in a row to the next column.
Note The sheet tab arrows that appear in Figure 98 are only active if there are sheet tabs that cannot be seen. Note When you insert a new sheet into your spreadsheet, Calc automatically uses the next number in the numeric sequence as a name. Depending on which sheet is open when you insert a new sheet, your new sheet may not be in numerical order. It is recommended to rename sheets in your spreadsheet to make them more recognizable. Figure 98.
Keyboard shortcut Cell navigation Ctrl+↑ Moves cell focus from a blank cell to the first cell above containing data in the same column. Moves cell focus from a cell containing data to the cell in Row 1 in the same column. Ctrl+↓ Moves cell focus from a blank cell to the first cell below containing data in the same column. Moves cell focus from a cell containing data to the last cell containing data in the same column.
Selecting items in a spreadsheet Selecting cells Single cell Left-click in the cell. You can verify your selection by looking in the Name Box on the Formula Bar (Figure 90 on page 114). Range of contiguous cells A range of cells can be selected using the keyboard or the mouse. To select a range of cells by dragging the mouse cursor: 1) Click in a cell. 2) Press and hold down the left mouse button. 3) Move the mouse around the screen.
Selecting columns and rows Single column or row To select a single column, click on the column header (Figure 89 on page 113). To select a single row, click on the row header. 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. To select multiple columns or rows that are not contiguous: 1) Click on the first 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 desired sheet. 2) Move the mouse pointer over the sheet tab for the second desired sheet. 3) Hold down the Ctrl key and click on the sheet tab. 4) Repeat as necessary. 5) The selected tabs will turn white (default Calc setup). Any actions that you perform will now affect all highlighted sheets. All sheets Right-click a sheet tab and choose Select All Sheets from the context menu.
3) Select the option you require from the Delete Cells dialog (Figure 101). Figure 101: Delete Cells dialog Alternatively: 1) Click in the column or header to select the column or row. 2) Go to Edit on the main menu bar and select Delete Cells or right click and select Delete Columns or Delete Rows from the context menu. Multiple columns or rows To delete multiple columns or rows: 1) Select the columns or rows, see “Multiple columns or rows” on page 124 for more information.
• Select the sheet where you want to insert a new sheet, then go to Insert > Sheet on the main menu bar. • Right-click on the sheet tab where you want to insert a new sheet and select Insert Sheet from the context menu. • Click in the empty space at the end of the sheet tabs. • Right-click in the empty space at the end of the sheet tabs and select Insert Sheet from the context menu.
1) In the current document, right-click on the sheet tab you wish to move or copy and select Move/Copy Sheet from the context menu or go to Edit > Sheet > Move/Copy on the main menu bar. 2) Select Move to move the sheet or Copy to copy the sheet. 3) Select the spreadsheet where you want the sheet to be placed from the drop-down list in To document. This can be the same spreadsheet, another spreadsheet already open, or you can create a new spreadsheet.
Viewing Calc Changing document view Use the zoom function to show more or fewer cells in the window when you are working on a spreadsheet. For more about zoom, see Chapter 1 Introducing LibreOffice in this guide. 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 rows and columns. Then, when moving around within a sheet, the cells in frozen rows and columns always remain in view.
Splitting horizontally or vertically 1) Click on the row header below the rows where you want to split the screen horizontally or click on the column header to the right of the columns where you want to split the screen vertically. 2) Go to Window on the main menu bar and select Split. A heavy black line appears between the rows or columns indicating where the split has been placed.
Using the keyboard Most data entry in Calc can be accomplished using the keyboard. Numbers Click in the cell and type in a number using the number keys on either the main keyboard or numeric keypad. By default, numbers are right aligned in a cell. Minus numbers To enter a negative number, either type a minus (–) sign in front of the number or enclose the number in parentheses (), for example (1234). The result for both methods of entry will be the same, for example -1234.
Numbers as text Numbers can also be converted to text as follows: 1) With the cell selected, right click on the cell select Format Cells from the context menu or go to Format > Cells on the main menu bar or use the keyboard shortcut Ctrl+1 to open the Format Cells dialog (Figure 107). 2) Make sure the Numbers page is selected, then select Text from the Category list. 3) Click OK and the number is converted to text and, by default, left aligned.
Figure 108: AutoCorrect dialog Options Select the options for automatically correcting errors as you type and then click OK. Localized options Specify the AutoCorrect options for quotation marks and for options that are specific to the language of the text. Reset Resets modified values back to the LibreOffice default values. Deactivating automatic changes Some AutoCorrect settings are applied when you press the spacebar after you enter data.
Using the Fill tool The Calc Fill tool is used to duplicate existing content or create a series in a range of cells in your spreadsheet (Figure 109). 1) Select the cell containing the contents you want to copy or start the series from. 2) Drag the mouse in any direction or hold down the Shift key and click in the last cell you want to fill. 3) Go to Edit > Fill on the main menu bar and select the direction in which you want to copy or create data (Up, Down, Left or Right) or Series from the context menu.
– Right – creates a series running from left to right within the selected cell range using the defined increment to the end value. – Up – creates an upward series in the cell range of the column using the defined increment to the end value. – Left – creates a series running from right to left in the selected cell range using the defined increment to the end value. • Series Type – defines the series type. – Linear – creates a linear number series using the defined increment and end value.
Defining a fill series To define your own fill series: 1) Go to Tools > Options > LibreOffice Calc > Sort Lists to open the Sort Lists dialog (Figure 111). This dialog shows the previously-defined series in the Lists box on the left and the contents of the highlighted list in the Entries box. 2) Click New and the Entries box is cleared. 3) Type the series for the new list in the Entries box (one entry per line). 4) Click Add and the new list will now appear in the Lists box.
Validating cell contents When creating spreadsheets for other people to use, validating cell contents makes sure they enter data that is valid or appropriate for the cell. You can also use validation in your own work as a guide to entering data that is either complex or rarely used. Fill series and selection lists can handle some types of data, but are limited to predefined information.
Replacing data To completely replace data in a cell and insert new data, select the cell and type in the new data. The new data will replace the data already contained in the cell and will retain the original formatting used in the cell. Alternatively, click in the Input Line on the Formula Bar (Figure 90 on page 114) then double click on the data to highlight it completely and type the new data.
Figure 114: Format Cells dialog – Alignment page 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, double-click the cell, then reposition the cursor to where you want the line break. When a manual line break is entered, the cell width does not change and your text may still overlap the end of the cell.
• Enter a custom format code. • The Language setting controls the local settings for the different formats such as the date format and currency symbol. Formatting font To quickly select a font and format it for use in a cell: 1) Select the cell. 2) Click the small triangle on the right of the Font Name box on the Formatting toolbar (highlighted in Figure 116) and select a font from the drop-down list.
palette, is displayed. You can also use the Background tab of the Format Cells dialog (Figure 107 on page 131). See the Calc Guide Chapter 4 Using Styles and Templates in Calc for more information. AutoFormat of cells Using AutoFormat You can use Calc’s AutoFormat feature to format a group of cells quickly and easily. 1) Select the cells in at least three columns and rows, including column and row headers, that you want to format.
Using themes Calc comes with a predefined set of formatting themes that you can apply to 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 and the modified styles are only available for use for that spreadsheet when you save the spreadsheet. To apply a theme to a spreadsheet: 1) Click the Choose Themes icon in the Tools toolbar.
Hiding and showing data In Calc you can hide elements so that they are neither visible on a computer display nor printed when a spreadsheet is printed. However, hidden elements can still be selected for copying if you select the elements around them. For example, if column B is hidden, it is copied when you select columns A and C. For more information on how to hide and show data, including how to use outline groups and filtering, see the Calc Guide Chapter 2 Entering, Editing, and Formatting Data.
Figure 120: Cell Protection page in Format Cells dialog Showing data To show hidden sheets, rows, and columns: 1) Select the sheets, rows or columns each side of the hidden sheet, row or column. 2) Go to Format on the main menu bar and select Sheet, Row or Column. 3) Select Show from the menu and the sheet, row or column will be displayed and can be printed. 4) Alternatively, right-click on the sheet tabs, row headers or column headers and select Show from the context menu.
Figure 121: Sort Criteria dialog To sort cells in your spreadsheet: 1) Select the cells to be sorted. 2) Go to Data > Sort on the main menu bar to open the Sort dialog (Figure 121). 3) Select the sort criteria from the drop down lists. The selected lists are populated from the selected cells. 4) Select either ascending order (A-Z, 1-9) or descending order (Z-A, 9-1). 5) Click OK and the sort is carried out on your spreadsheet.
Printing Printing from Calc is much the same as printing from other LibreOffice components (see Chapter 10 Printing, Exporting, and Emailing in this guide). However, some details for printing in Calc are different, especially regarding preparation for printing. Print ranges Print ranges have several uses, including printing only a specific part of the data or printing selected rows or columns on every page.
Printing options To select the printing options of page order, details, and scale to be used when printing a spreadsheet: 1) Go to Format > Page on the main menu to open the Page Style dialog (). 2) Select the Sheet tab and make your selections from the available options. 3) Click OK. For more information on printing options, see the Calc Guide Chapter 6 Printing, Exporting, and E-mailing.
3) Select Row Break to create a page break above the selected cell. 4) Select Column Break to create a page break to the left of the selected cell. 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) Go to Edit > Delete Page Break on the main menu bar. 3) Select Row Break or Column Break depending on your need and break is removed. Note Multiple manual row and column breaks can exist on the same page.
5) Select Same content left/right option if you want the same header or footer to appear on all the printed pages. 6) Set the margins, spacing, and height for the header or footer. You can also select AutoFit height box to automatically adjust the height of the header or footer. 7) To change the appearance of the header or footer, click on More to open the borders and background dialog.
Chapter 6 Getting Started with Impress Presentations in LibreOffice
What is Impress? Impress is the presentation (slide show) program included in LibreOffice. You can create slides that contain many different elements, including text, bulleted and numbered lists, tables, charts, and a wide range of graphic objects such as clipart, drawings and photographs. Impress also includes a spelling checker, a thesaurus, text styles, and background styles.
Main Impress window The main Impress window (Figure 124) has three parts: the Slides pane, Workspace, and Tasks pane. Additionally, several toolbars can be displayed or hidden during the creation of a presentation. Figure 124: Main window of Impress; ovals indicate the Hide/Show markers Tip You can close the Slides pane or the Tasks pane by clicking the X in the upper right corner of the pane or go to View > Slide Pane or View > Tasks Pane on the main menu bar to deselect the pane.
Several additional operations can be performed on one or more slides simultaneously in the Slides pane: • • • • • Add new slides to the presentation. Mark a slide as hidden so that it will not be shown as part of the presentation. Delete a slide from the presentation if it is no longer needed. Rename a slide. Duplicate a slide (copy and paste) or move it to a different position in the presentation (cut and paste).
Workspace The Workspace (normally in the center of the main window) has five tabs: Normal, Outline, Notes, Handout, and Slide Sorter (Figure 125). These five tabs are called View buttons. The Workspace below the View buttons changes depending on the chosen view. The workspace views are described in detail on page 156.
• Digital signature – a flag indicating whether the document is digitally signed. After the file has been saved, double clicking on this flag opens the digital signatures dialog. • Slide number – the slide number currently displayed in the Workspace and the total number of slides in the presentation. • Page (slide) style – the style associated with the slide, handout, or notes page currently in the Workspace. Double clicking on the style name opens the slide design dialog.
Figure 128: Outline level and movement arrows in Text Formatting toolbar Use Outline view for the following purposes. 1) Making changes in the text of a slide: a) Add and delete the text in a slide just as in the Normal view. b) Move the paragraphs of text in the selected slide up or down by using the up and down arrow buttons (Move Up or Move Down) on the Text Formatting toolbar (highlighted in Figure 128).
Handout view Handout view is for setting up the layout of your slide for a printed handout. Click the Handout tab in the workspace, then choose Layouts in the Tasks pane (Figure 130) where you can then choose to print 1, 2, 3, 4, 6, or 9 slides per page. Figure 130: Handout layouts Use this view also to customize the information printed on the handout. Refer to the Impress Guide Chapter 10 Printing, E-mailing, Exporting, and Saving Slide Shows for instructions on printing slides, handouts, and notes.
Figure 132: Slide Sorter view Customizing Slide Sorter view To change the number of slides per row: 1) Go to View > Toolbars and select Slide Sorter and Slide View to show or hide the Slide Sorter and Slide View toolbars (Figure 133). 2) Adjust the number of slides (up to a maximum of 15). Figure 133: Slide Sorter and Slide View toolbars Moving a slide using Slide Sorter To move a slide in a presentation in the Slide Sorter: 1) Click the slide and the slide is highlighted (Figure 132).
• Duplicate Slide – creates a duplicate of the selected slide and places the new slide immediately after the selected slide (see “Duplicate slide” on page 163). • • • • Delete Slide – deletes the selected slide. Rename Slide – allows you to rename the selected slide. Slide Layout – allows you to change the layout of the selected slide. Slide Transition – allows you to change the transition of the selected slide. – – • • • • For one slide, select a slide and add the desired transition.
Figure 135. Selecting a slide design c) 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. 2) Click Next. Figure 135 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. 3) Choose a design under Select a slide design.
Figure 136: Selecting a slide transition effect Tip Caution You can accept the default values for both Effect and Speed unless you are skilled at creating presentations. Both of these values can be changed later while working with slide transitions and animations. These two features are explained in more detail in the Impress Guide Chapter 9 Slide Shows. Remember to save frequently while working on the presentation, to prevent any loss of information should something unexpected occur.
Duplicate slide Sometimes, rather than starting from a new slide you may want to duplicate a slide already included in your presentation. To duplicate a slide: 1) Select the slide you want to duplicate from the Slides Pane. 2) Right-click on the slide in the Slides Pane or Workspace and select Duplicate Slide from the context menu. Or, go to Slide Sorter view, right-click on a slide and select Duplicate Slide from the context menu. Alternatively, go to Insert on the main menu bar and select Duplicate Slide.
To view the names for the included layouts, use the Tooltip feature: position the cursor on an icon in the Layout section (or on any toolbar icon) and its name will be displayed in a small rectangle. Tip If tooltips are not enabled, choose Tools > Options > LibreOffice > General > Help and select the Tips option. If the Extended tips option is also selected, you will get more detailed tooltip information, but the tooltip names themselves will not be provided.
To remove any unwanted elements: 1) Click the element to highlight it. The resizing handles show it is selected. 2) Press the Delete key to remove it. Caution Changes to any of the layouts included in Impress can only be made using View > Normal, which is the default. Attempting any changes by modifying a slide master, although possible, may result in unpredictable results and requires extra care as well as a certain amount of trial and error.
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. You need to use keyboard input or mouse interaction to move from one slide to the next. You can use Slide Show on the main menu bar to change the order of the slides, choose which ones are shown, automate moving from one slide to the next, and other settings.
Figure 141: Creating and editing text boxes 5) Type or paste your text in the text box. 6) Click outside the text box to deselect it. You can move, resize, and delete text boxes. For more information, see the Impress Guide Chapter 3 Adding and Formatting Text. Vertical text 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.
Pasting unformatted text It is normally good practice to paste text without formatting and apply the formatting later. To paste text without formatting: • Use the keyboard shortcut Ctrl+Shift+V and select Unformatted text from the Paste Special dialog that opens. • Or, click on the small triangle next to the Paste icon in the Standard toolbar and select Unformatted text from the context menu.
Tip Press Shift+Enter to start a new line without creating a new bullet point. The new line will have the same indentation as the previous line. To switch off bullets altogether, click the Bullets On/Off icon on the Text Formatting toolbar. If the Text Formatting toolbar is not displayed, go to View > Toolbar > Text Formatting on the main menu bar. Text boxes Create a bulleted list in a text box as follows: 1) Click the Text icon on the Drawing toolbar and draw a text box on your slide.
Figure 143: Bullets and Numbering dialog For the entire list: 1) Select the entire list or click on the border of the text box so that the resizing handles are displayed. 2) Select Format > Bullets and Numbering on the main menu bar or click on the Bullets and Numbering icon on the Text Formatting toolbar. 3) The Bullets and Numbering dialog (Figure 143) contains five pages: Bullets, Numbering type, Graphics, Position, and Customize.
Adding pictures To add a picture to a contents box: 1) Go to Insert > Picture on the main menu bar and then select either From file or Scan. Alternatively, after inserting a new slide, click the Insert Picture icon (Figure 138 on page 164) on the new slide and select the file from the Insert Picture dialog that opens. To see a preview of the picture, check Preview at the bottom of the Insert Picture dialog. 2) Move the picture to the desired location.
Entering data into table 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 keyboard options: • Press the arrow keys to move the cursor to another cell if the cell is empty, or to the next character if the cell already contains text. • Press the Tab key to move to the next cell on the right and press Shift+Tab to move to the next cell on the left..
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 and it controls the basic formatting of all slides based on it. A slide show can have more than one slide master. Note LibreOffice 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 144: Slide (page) masters in Tasks Pane Figure 145: Master View toolbar Creating a slide master Creating a new slide master is similar to modifying the default slide master. 1) Enable editing of slide masters by selecting View > Master > Slide Master on the main menu bar and the Master View toolbar opens (Figure 145). If the Master View toolbar does not appear, go to View > Toolbars and select Master View.
2) To apply one of the slide masters to all slides in your presentation, right-click on it from the available selection and select Apply to All Slides on the context menu. To apply a different slide master to one or more selected slides: 1) In the Slide Pane, select the slide or slides where you want to use a new slide master. 2) In the Tasks Pane, right-click on the slide master you want to apply to the selected slides, and select Apply to Selected Slides on the context menu.
Figure 147: Load Slide Design dialog Tip To limit the size of the presentation file, you may want to minimize the number of slide masters used.
Figure 148: Example master view Adding text, footers, and fields to all slides A slide master can have text, footers, or fields added so that they appear on every slide in your presentation. Due to the layout of slides in Impress, headers are not normally added to slides. Text 1) Go to View > Master > Slide Master on the main menu bar to open Master View (Figure 148). 2) On the Drawing toolbar, select the Text icon or press the F2 key.
Figure 149: Header and Footer dialog in Impress Note Normally only footers are used on a slide. To create a header, you can use a text box as explained in “Text” on page 177. Fields To add a field into an object or as a separate object on a slide, select Insert > Fields on the main menu bar and select the required field from the submenu. If you want to edit this field in your slide, see the Impress Guide Chapter 3 Adding and Formatting Text for more information.
Adding comments to a presentation Impress supports comments similar to those in Writer and Calc. In Normal View, go to Insert > Comment on the main menu bar to open a blank comment (Figure 150). A small box containing your initials appears in the upper left-hand corner of the slide, with a larger text box beside it. Impress automatically adds your name and the current date at the bottom of the text box. Figure 150: Inserting comments Type or paste your comment into the text box.
Hiding slides 1) Select the slide you want to hide in the Slide Pane or Slide Sorter view on the Workspace area. 2) Go to Slide Show > Hide Slide on the main menu bar or right-click on the slide thumbnail and select Hide Slide from the context menu. Hidden slides are marked by a diagonal bars across the slide. Custom slide shows If you want to create a custom slide show from the same presentation: 1) Select the slides you want to use in your custom slide show.
Running a slide show To run a slide show, do one of the following: • Click Slide Show > Slide Show on the menu bar. • Click the Slide Show icon • Press F5 on the keyboard. on the Presentation toolbar. 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.
Chapter 7 Getting Started with Draw Vector Drawing in LibreOffice
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.
To change the measurement units of the rulers, which can be defined independently, right-click on a ruler, as illustrated for the horizontal ruler in Figure 154.
Figure 154: Ruler units Status bar The Status bar is located at the bottom of the screen in all LibreOffice components; it includes several Draw-specific fields. For details on the contents and use of these fields, see Chapter 1 Introducing LibreOffice in this guide and in the Draw Guide Chapter 1 Introducing Draw. Figure 155: Draw status bar Note The sizes are given in the current measurement unit and are not to be confused with the ruler units.
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 157: Drawing toolbar Line and Filling toolbar The Line and Filling toolbar lets you modify the main properties of a drawing object. The icons and pull-down lists vary, according to the type of object selected.
Figure 162. Changing the color palette You can access several specialized color palettes in Draw, as well as change individual colors to your own taste. This is done using the Area dialog by selecting Format > Area on the main menu bar or clicking the Area icon (Figure 162). on the Line and Filling toolbar, then selecting the Colors tab To load another palette, click on the Load Color List icon .
Figure 163: Tools available for Drawing toolbar Note When you draw a basic shape or select one for editing, the Info field at the left side in the status bar changes to reflect the present action: for example Line created, Text frame xxyy selected, and so on. Drawing a straight line Click on the Line icon and place the mouse pointer at the point where you want to start the line (Figure 164). Drag the mouse while keeping the mouse button pressed.
Figure 164: Drawing a straight line Holding down the Alt key while drawing a line results in the line extending outwards symmetrically in both directions from the start point. This lets you draw lines by starting from the middle of the line. When a line is drawn, it uses default attributes. To change any of these attributes, select the line by clicking on it, then right-click and select Line from the context menu or got to Format > Line on the main menu bar to open the Line dialog (Figure 165).
Choosing line endings Several types of line endings (arrows, circles, squares, and others) are available in Draw. Click on the small triangle to the right of the Lines and Arrows icon on the Drawing toolbar to open a tool palette containing tools for drawing lines and arrows. Alternatively, go to View > Toolbars > Arrows to open the Arrows toolbar as a floating toolbar (Figure 166). The icon for the tool used most recently will be shown on the Drawing toolbar to make it easier to use the same tool again.
Drawing circles or ellipses To draw an ellipse (also called an oval), click on the Ellipse icon on the Drawing toolbar. A circle is an ellipse with both axes the same length. To draw a circle, click on the Ellipse icon and hold down the Shift key whilst you draw a circle. To draw an ellipse or circle from its center, position your cursor on the drawing, press the mouse button and then hold down the Alt key while dragging with the cursor.
button and continue to drag the cursor to bend the line into a curve. Click to set the end point of the curve and fix the line on the page. To continue with your line, drag the mouse cursor to draw a straight line. Each mouse click sets a corner point and allows you to continue drawing another straight line from the corner point. A double click ends the drawing of your line.
Figure 168: Text information on the Status Bar Text properties can also be changed during text input, with any changes taking effect from the cursor position onwards. To change the properties for all of the text in the text frame, you have to highlight all text in the text frame. You can create Graphics styles that you can reuse for other text frames. Select Format > Styles and Formatting or press F11 to open the Styles and Formatting dialog. Graphics styles affect all of the text within a text frame.
Figure 170: Glue Points toolbar and available tools Glue points are not the same as the selection handles of an object. The handles are for moving or changing the shape of an object. Glue points are used to fix or glue a connector to an object so that when the object moves, the connector stays fixed to the object. For a more detailed description on the use of glue points, see the Draw Guide Chapter 3 Working with Objects and Object Points and Chapter 8 Connections, Flowcharts and Organization Charts.
Figure 172: Connectors toolbar and available tools Drawing geometric shapes The icons for drawing geometric shapes are located on the Drawing toolbar and each geometric shape is explained in the following sections. Clicking on the triangle to the right of the icon opens a floating toolbar giving access to the tools for that geometric shape. Tip The use of these tools for geometric shapes is similar to the tool used for drawing rectangles and squares.
Symbol shapes Click on the triangle to the right of the Symbol Shapes icon toolbar for drawing symbols. to open the Symbol Shapes Figure 174: Symbol Shapes toolbar Block arrows Click on the triangle to the right of the Block Arrows icon for drawing block arrows. to open the Block Arrows toolbar Figure 175: Block Arrows toolbar Flowcharts Click on the triangle to the right of the Flowcharts icon to open the Flowchart toolbar for symbols used in drawing flowcharts.
Stars and banners Click on the triangle to the right of the Stars icon drawing stars and banners. to open the Stars and Banners toolbar for Figure 178: Stars and Banners toolbar Note You can add text to all these geometric shapes. For more information, see the Draw Guide Chapter 2 Drawing Basic Shapes and Chapter 10 Advanced Draw Techniques. Selecting objects Direct selection The easiest way to select an object is to click directly on it.
reverse order, press Shift+Tab. This is a very quick way to reach an object, but it may not be practical if there a large number of objects in a drawing. Arranging objects In a complex drawing, several objects may be stacked on top of one another. To rearrange the stacking order by moving an object forward or backward, select an object, click Modify > Arrange on the main menu bar and select Bring Forward or Send Backward.
Figure 180: Left end of status bar when moving or adjusting an object Moving objects To move an object (or a group of objects), select it and then click within the object borders and hold down the left mouse button while dragging the mouse. During movement, the ghost image of the object appears to help with repositioning (Figure 181). To locate the object at its new location, release the mouse button.
If you press the Shift key while resizing an object, the change in size will be carried out symmetrically with respect to the two axes so that the aspect ratio of the object remains the same. This Shift key behavior works on all selection handles. Note This is the default behavior of the Shift key.
The rotation point is normally located at the center of an object. To change the position of the rotation point, click on the object with the mouse cursor and drag the object until the rotation point is at the desired position. This rotation point can even be outside of the object. If you press the Shift key while rotating an object, rotation will be restricted to 15° of movement. Note This is the default behavior of the Shift key.
Editing objects To edit an object or change its attributes, such as color or border width, and so on, the Line and Filling toolbar, the Text Formatting toolbar, or the context menu can be used. More information on editing objects and changing attributes can be found in the Draw Guide Chapter 4 Changing Object Attributes. Line and Filling toolbar By default, the Line and Filling toolbar in Draw is placed at the top of the workspace.
Figure 186: Text Formatting toolbar and its available tools Context menu When an object is selected and you right-click on the object, a context menu (Figure 187) opens that applies to the selected object. This context menu provides access to the options available and allows you to change object attributes without having to open a dialog. Menu entries with a small arrow on the right-hand side contain a submenu. Figure 187: Example of a context menu 204 | Getting Started with LibreOffice 4.
Formatting lines and borders In LibreOffice the term line indicates both a freestanding segment (line), outer edge of a shape (border), or an arrow. In most cases the properties of the line you can modify are its style (solid, dashed, invisible, and so on), its width and its color. Select the line you need to format and then use the controls on the Line and Filling toolbar to change the most common options (highlighted in Figure 188).
Formatting area fill The term area fill refers to the inside of an object, which can be a uniform color, gradient, hatching pattern, or bitmap (Figure 190). An area fill can be made partly or wholly transparent. In most cases, you will choose one of the standard fill options, which are all available from the Line and Filling toolbar. You can also define your own area fills. For more information on formatting area fill, see the Draw Guide Chapter 4 Changing Object Attributes.
Figure 191: Positioning with snap to grid Displaying the grid To display the grid in Draw or to switch off the grid, go to View > Grid > Display Grid on the main menu bar or click on the Display Grid icon on the Options toolbar. Configuring the grid The resolution, snap and snap position of the grid points can be configured. Go to Tools > Options > LibreOffice Draw > Grid on the main menu bar to open the options dialog for the grid (Figure 192). • Vertical and horizontal spacing of the dots in the grid.
Figure 192: Configuring the grid Help lines Draw has help lines to easily allow you to position an object using the rulers at the top and left side of the workspace. To turn on or off the help lines, go to Tools > Options > LibreOffice Draw > View on the main menu bar and select Snap Lines when moving option, or go to the Options toolbar and click on the Helplines While Moving icon .
Figure 193: Mode toolbar and its available tools Mirror copies At the moment there is no mirror command existing in Draw. However, mirroring an object can be emulated by using the Flip tool and this is described in the Draw Guide Chapter 4 Changing Object Attributes. Distorting an object Three tools on the Mode toolbar let you drag the corners and edges of an object to distort the image. • Distort tool distorts an object in perspective.
Duplication Duplication makes copies of an object while applying a set of changes such as color or rotation to the duplicates that are created. 1) Click on an object or group of objects and go to Edit > Duplicate on the main menu bar or use the keyboard shortcut Shift+F3 to open the Duplicate dialog (Figure 194). 2) Select the required options chosen from the options available. For example, when the options in the dialog are applied to a rectangle, they produce the result shown in Figure 195.
4) Select Cross-fading attributes to apply a gradual change of line and fill properties between the two objects. 5) Select Same orientation to apply a smooth transition between the two objects. 6) Click on OK and the result is a new group of objects with the first object selected as the start object and the second object selected as the end object. For example, when the options in the dialog are applied to a rectangle and a triangle, the cross fade produces the result shown in Figure 197.
To cancel a temporary grouping of objects simply click outside of the selection handles displayed around the objects. Permanent grouping A permanent grouping of objects is created after you have selected your objects. Go to Modify > Group on the main menu bar, or right-click on the selection and select Group from the context menu, or use the keyboard shortcut Ctrl+Shift+G. When you deselect your selection, the objects remain grouped together.
Inserting and editing pictures Draw contains a number of functions for editing pictures or raster graphics (bitmaps); for example, photos and scanned images. This includes the import and export of graphics, and the conversion of one graphic format to another. Draw includes a large range of graphic filters so that it can read and display several graphic file formats.
you can also delete the current comment, all the comments from the same author, or all the comments in the document. 3) You can move the small comment markers to anywhere you wish on the drawing. Typically you might place it on or near an object you refer to in the comment. Figure 198: Inserting comments 4) To show or hide the comment markers, go to View > Comments on the main menu bar. 5) Go to Tools > Options > User Data to enter the name you want to appear in the Author field of the comment.
Chapter 8 Getting Started with Base LibreOffice's Database Component
What is Base? A data source, or database, is a collection of pieces of information that can be accessed or managed by LibreOffice. 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 LibreOffice. Note LibreOffice 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.
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 write the answers later. At least some of the answers should seem obvious after you take some time to think. You may have to go through this process a few times before everything becomes clear in your mind and on paper.
Creating a new database To create a new database, choose File > New > Database from the menu bar, or click the arrow next to the New icon on the Standard toolbar and select Database from the drop down menu. Both methods open the Database Wizard. On the first page of the Database Wizard, select Create a new database and then click Next. The second page has two questions.
Creating database tables In a database, a table stores information for a group of things we call fields. For example, a table might hold an address book, a stock list, a phone book or a price list. A database must have at least one table and may have several. To work with tables, click the Tables icon in the Database list, or press Alt+a. The three tasks that you can perform on a table are in the Tasks list (see Figure 199). Using the Wizard to create a table Wizards are designed to do the basic work.
Figure 200: Selecting fields for the table Step 2: Set field types and formats. In this step you give the fields their properties. When you click a field, the information on the right changes. (See Figure 201.) You can then make changes to meet your needs. Click each field, one at a time, and make the changes listed below. Figure 201: Changing field types Note If any of these fields requires a mandatory entry, set Entry required to Yes. A blank field will then not be allowed .
Note In Base the maximum length of each field must be specified on creation . It is not easy to change this later, so if in doubt specify a greater length. Base uses VCHAR as the field format for text fields. This format uses only the actual number of characters in a field up to the limit set, so a field containing 20 characters will occupy only 20 characters even if the limit is set at 100.
Creating a table by copying an existing table If you have a large collection of music, you might want to create a table for each type of music you have. Rather than creating each table from the wizard, you can make copies of the original table, naming each according to the type of music contained in it. 1) Click on the Tables icon in the Database pane to see the existing tables. 2) Right-click on the CD-Collection table icon. Choose Copy from the pop-up menu.
b) Set FuelID as the Primary key. Right-click on the green triangle to the left of FuelID (Figure 202) and choose Primary Key from the menu. This places a key icon in front of FuelID. Figure 202: Defining the primary key field The primary key serves only one purpose: to identify the record uniquely. Any name can be used for this field. We have used FuelID for convenience, so we know to which table it belongs.
Figure 203: Changing field properties Figure 204: 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 205. Make sure you make the Date field the primary key before closing.
Figure 205: Fields in Vacations table Defining relationships Now that the tables have been created, what are the relationships between our tables? This is the time to define them based upon the questions we asked and answered in the beginning. When on vacation, we want to enter all of our expenses at once each day. Most of these expenses are in the Vacations table, but the fuel we buy is not. So we will link these two tables using the Date fields.
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. When you release the mouse button, a connecting line forms between the two date fields. • Or, click the New Relation icon. This opens the Relations window (Figure 207). Our two tables are listed in the Tables involved section. a) In the Fields involved section, click the drop down list under the Fuel label.
d) e) Select Delete cascade. 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 which has been modified. It also permits you to delete a field from the table without causing inconsistencies. Creating a database form Databases are used to store data.
Figure 211: 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 need to be done in step 4. 1) Click the box labeled Add Subform 2) Click Sub form based upon existing relation. 3) Fuel is listed as a relation we want to add. So click Fuel to highlight it, as in Figure 212. Click Next. Figure 212: Adding a subform Step 3: Add subform fields.
Figure 213: Selecting fields of a sub form Step 4: Get joined fields. This step is for tables or queries for which no relationship has been defined. Because we have already defined the relationship, the wizard skips this step. Note It is possible to create a relationship between two tables that is based upon more than one pair of fields. How to do that and why is discussed in the Base Guide. When selecting a pair of fields from two tables to use as a relationship, they have to have the same field type.
Step 5: Arrange controls. A 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 relative to 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.
Here are some methods that we will be using in these steps. The controls in the main form consist of a label and its field. Sometimes we want to work with the entire control, sometimes with only the label or the field, and there are times when we want to work with a group of controls. • Clicking a label or field selects the entire control. A border appears around the control with eight green handles. You can then drag and drop it where you want.
3) Hold the left mouse button down as you drag the cursor to the right until the length is 6 cm. The vertical dashed line is lined up with the 6. Release the mouse button. 4) Click the Control icon in the Form Controls toolbar. If it is not visible, choose View > Toolbars > Form Controls. The Properties: Date Field window opens. Each line contains a property of the field. Figure 217: Form Controls toolbar • Scroll down to the Date format property.
Figure 219: Positioning of controls Caution Do not use Control+click when moving a field. It moves either the field or the label but not both. To move both, use a plain mouse click and drag to the desired spot. Step 4: Change the label wording. Field names have been required to be single words for some time. However, the labels for the fields in a form can be more than one word. So we will change them by editing the text in the label. 1) Control+click the SnackNo label.
When changing the position or size of an entire control, use the Position and Size dialog or the drag and drop method. Caution Note When working with either the label or the field (but not both at the same time), you can use the Properties dialog to make these changes when you want to be exact. However, you need to be careful not to accidentally select the entire control for use with the Properties dialog or you will apply exactly the same values to both the label and field.
Step 7: Change labels and fields in the subform The subform is located at the bottom of the form. We want to widen the Date column, and change the label for the PaymentType column to two words. • To widen the Date column, move the mouse pointer over the dividing line between the Date and FuelCost columns. When the pointer changes shape, click and drag to move the divider to the right. • To change the PaymentType column: – Right-click the label PaymentType to open the menu.
Step 9: 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 > LibreOffice > Colors. If you know how to create custom colors, you can use them. You can also use a picture (graphic file) as the background. 1) Right-click the form to open a context menu. 2) Select Page. 3) Make sure the Background tab has been selected. (It will be in bold type while the other tabs will be in default type.
Figure 223: Finished form Step 10: Change the tab order. The Tab key moves the cursor from field to field. This is much easier to do than to click each field to enter data into it. It also permits us to group our expenses into areas before we begin entering data. For example, all of our meal receipts can be grouped together as can our snacks and also our fuel purchases. Figure 224: Form Design toolbar with Activation Order icon circled 1) Control+click the Date field.
Figure 225: Tab order for the main form Creating forms and sub forms in Design View This method requires using the Form Controls and Form Design toolbars extensively. These techniques are beyond the scope of this document. Instructions for creating forms using Design view will be described in the Database Guide. Accessing other data sources LibreOffice allows data sources to be accessed and then linked into LibreOffice documents.
3) Click Browse to locate the spreadsheet you want to access. If the spreadsheet is password protected, check the Password required box. Click Next. 4) If the spreadsheet requires a user’s name, enter it. If a password is also required, check its box. Click Next. Using this method of accessing a spreadsheet, you cannot change anything in the spreadsheet. You can only view the contents of the spreadsheet, run queries, and create reports based upon the data already entered into the spreadsheet.
Figure 226: Databases Editing data sources Some data sources (but not spreadsheets) can be edited in the Data View window. A record can be edited, added, or deleted. View a table’s data If you click on a table its rows and columns of data appear on the right side of the Data Source window. Editing this data requires only a click in the cell whose data should be changed, change the data, and click in the row above or below it to save the new data. Beneath the records are five tiny buttons.
Tip Choosing Tools > Mail Merge Wizard or clicking on the Mail Merge icon (circled in red) in the Data Sources window launches the Mail Merge wizard which steps you through creating a mail merge document. See Chapter 11 in the Writer Guide. Writer documents To insert a field from a table opened in the data source window into a Writer document, click on the field name (the gray square at the top of the field list) and, with the left mouse button held down, drag the field onto the document.
1) Navigate to the place you want to place the table and click the location. 2) Control+Click the gray box to the left of each row of the data source that you want to be a row in your table if the rows are not consecutive. To select consecutive rows, click the gray box to the left of the top desired row and Shift+click the bottom desired row. 3) Click the Data to text icon to open the Insert Database Columns dialog (Figure 231). (The Data to text icon is to the left of the Data to Fields icon in Figure 230.
2) Use F4 to open the database source window and select the table whose data you want to use. 3) Select the rows of data you want to add to the spreadsheet: • Click the gray box to the left of the row you want to select if only selecting one row. That row is highlighted. • To select multiple rows, hold down the Control key while clicking the gray box of the rows you need. Those rows are highlighted. • To select all the rows, click the gray box in the upper left corner. All rows are highlighted.
The quickest way to enter a date in the Date field is to click the arrow that opens the drop down calendar (Figure 233). Then click the day the you want. Then press the Tab key to go to the Odometer field. Figure 233: Calendar drop down The Odometer, Tolls, and Motel fields are numeric fields. Enter values directly into them, or use the up and down arrows. When the value has been entered, use the Tab key to go to the next field.
To move to another record when the form has a subform, click any of the fields of the main form. In this case, click the Date field of the main form. Then use the directional arrows at the bottom. There are four of them from left to right: First Record, Previous Record, Next Record, and Last Record (Figure 232). To the right of these arrows is the New Record icon. To create a new record while in another record in the main form, click either the Next Record icon or the New Record icon.
Using the Wizard to create a query Queries created by the wizard provide a list or lists of information based upon what one wants to know. It is possible to obtain a single answer or multiple answers, depending upon the circumstances. In the main database window (Figure 199), click the Queries icon in the Databases section, then in the Tasks section, click Use Wizard to Create Query. The Query Wizard window opens (Figure 235).
In our query, the artist is most important. The album title is less important, and the date purchased is of least importance. Of course, if we were interested in what music we bought on a given day, the date purchased would be the most important. Figure 236: Sorting order page 1) Click the first Sort by drop down list. a) Click CD-Collection.Artist to select it. b) To list the artists in alphabetical order (a-z), select Ascending on the right. 2) Click the second Sort by drop down list.
Step 5: Assign aliases if desired. We want the default settings. Click Next. Step 6: Overview. Name the query (suggestion: Query_Artists). To the right of this are two choices. Select Display Query. Click Finish. Using the Design View to create a query Creating a query using Design View is not as difficult as it may first seem. It may take multiple steps, but each step is fairly simple.
Figure 238: Fuel table in query Step 3: Add fields to the table at the bottom. 1) Double-click the FuelID field in the Fuel table. 2) Double-click the Odometer field. 3) Double-click the FuelQuantity field. The table at the bottom of the query window should now have three columns. Figure 239: Query 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.
Figure 242: Query of Fuel table Step 5: Save and close the query. Since this query contains the final odometer reading for our calculations, name it End-Reading when saving it. Then close the query. Step 6: Create the query to calculate the fuel economy. 1) Click Create Query in Design View to open a new query. 2) Add the Fuel table to the query just as you did in step 2: Add tables But, do not close the Add Tables window. 3) Add the End-Reading query to this query.
2) Double-click Odometer in the End-Reading query. 3) Double-click Odometer in the Fuel table. Figure 245: 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 EndReading 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. 2) Type the numeral 1 (one) in the Criterion cell of this column.
Figure 247: Field for distance traveled calculations Figure 248: 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. The query will then add the rest of the double quotes as in Figure 248. Use the arithmetical symbol between the two.
Type in the aliases as they are listed in Figure 250. Figure 250: Query table with aliases added 3) Run the query again. The results are in Figure 251. Figure 251: 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 column that does not need to be seen. Remove the check in the box of the Visible cell as in Figure 252.
Creating reports Reports provide information found in the database arranged in a useful way. In this respect, they are similar to queries. Reports are generated from the database’s tables, views, or queries. All reports are based upon a single table, view, or query, so you need first to decide what fields you want to use in the report. If you want to use fields from different tables, you must first combine these fields in a single query or view. Then you can create a report from this.
whether you want to update the report later. In this case, select dynamic. If you choose static, the report will always contain the data for the original report date. LibreOffice has always included the Report Builder extension. For some reason, it does not work in some versions. For these, creating a report is done the same way as is done using OpenOffice.org 3.3, and the Getting Started with Base chapter for OpenOffice.org 3.3 explains the basics for creating a report that can be used.
Step 2: Labeling fields Change any field labels you wish. We will shorten Miscellaneous to Misc. and make SnackCost into two words. 1) Shorten Miscellaneous to Misc. 2) Add a space to separate SnackCost into Snack Cost. 3) Click Next. Figure 255: Giving aliases to fields Step 3: Grouping Since we are grouping by the date, use the > button to move the Date field to the Grouping list. Click Next. Figure 256: Selecting fields for grouping data Step 4: Sort options We do not want to do any additional sorting.
1) 2) 3) 4) Select Columnar, three columns for the Layout of data. Layout of headers and footers has no possible selections. Select Landscape as the Orientation for the page layout. Click Next. Figure 257: Report Builder template determined by the Report Wizard Step 6: Create report 1) Label the report: Vacation Expenses. 2) Select Dynamic report. 3) Click Finish. Figure 258: Report without modifications The report has been created, but it needs some editing.
Note Report Builder is a LibreOffice extension to assist in report creation. With Report Builder, you can create stylish, complex database reports. You can define group and page headers, group and page footers, and calculation fields. It is installed by default with LibreOffice. 258 | Getting Started with LibreOffice 4.
Chapter 9 Getting Started with Math LibreOffice's Equation Editor
What is Math? Math is LibreOffice’s component for writing mathematical and chemical 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.
The upper area is the preview window, where the equation will appear during and after input. The lower area is the equation editor, where the markup code for the equation is entered. The floating Elements window will also appear. Inserting a formula into a Writer document To insert a formula into a Writer document, open the document and then choose Insert > Object > Formula from the menu bar. The formula editor opens at the bottom of the Writer window, and the floating Elements window appears.
If you frequently need to insert formulas, it is advisable to add the Formula button to the Standard toolbar or create a keyboard shortcut. See Chapter 14, Customizing LibreOffice, for more information. 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 a possible. For example, a over b produces a fraction: .
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 264: Result of entering 5 and 4 next to the times operator Tip To keep the equation from updating automatically, select View > AutoUpdate display to deselect it. To update a formula manually, press F9 or select View > Update. Right-click (context) menu Another way to access mathematical symbols is to right-click on the equation editor. This pops up the menu shown in Figure 265. The items in this menu correspond to those in the Elements window, with some extra commands.
The formula markup resembles the way the formula reads in English. Tip 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 ( α , β , γ ,θ , etc) are common in mathematical formulas. These characters are not available in the Elements window or the right-click menu.
Figure 266: 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 5: Delete the > text, press F4 key and type 3.14159 at the end of the equation. We end up with the markup %pi simeq 3.14159. The result is shown in Figure 269. Figure 269. Final result Changing a formula You can change a formula at any time. To switch into edit mode, double-click on the formula. To get to the appropriate section in the markup code, do any one of the following: • In the equation editor, click on the location. • Select an area of the markup code that you wish to change.
In the first example, Math has recognized that the 2 before and the x after the over belong to the fraction, and has represented them accordingly. If you want x+1 rather than x to be the denominator, you must bracket them together so that both will be placed there. In the second example, Math has recognized the minus sign as a prefix for the 1 and has therefore placed it in the numerator of the fraction.
Isolated and unpaired brackets Math expects that for every opening bracket there will be a closing one. If you forget a bracket, Math places an inverted question mark by the corresponding bracket. This disappears when all brackets are matched. Sometimes forgetting a bracket causes the whole structure of the formula to fall apart. However, an unpaired bracket is sometimes necessary.
Continuing the calculation on a new line without writing a complete new equation is not directly possible, because Math expects a term on the left hand side of an equals sign. You can substitute: • Empty quotes "". This will automatically cause the line to be left-justified. • Empty braces { }. The following line will then be centered. • Spaces characters ` or ~. The line will be centered with the spaces. The alignment of equals signs under each other is described on page 272.
To write function names with primes, as is usual in school notation, you must first add the signs to the catalog. Using single and double quotes is typographically ugly. See “Customizing the catalog” on page 278. Markup characters as regular characters Characters that are used for controlling markup cannot be entered directly as normal characters. The characters concerned are: %, {, }, &, |, _, ^ and ". So, for example, you cannot write 2% = 0.02 or 1" = 2.56cm.
How do I align my equations at the equals sign? Math does not have a command for aligning equations on a particular character, but you can use a matrix to do this, as shown below. Markup Result matrix{ alignr x+y # {}={} # alignl 2 ## alignr x # {}={} # alignl 2-y x+ y x = 2 = 2− y } The empty braces around = are necessary because = is a binary operator and thus needs an expression on each side.
Figure 272. Edit Base size (top) to make a formula bigger Figure 273. Result of changing the base font size Note The change in font size applies only to the current formula. To change the default font size, click on the Default button and then OK.
Figure 274: Fonts dialog The Custom fonts section determines which font will be used when the attribute font serif, font sans or font fixed is specified. To change a font, first click on Modify and choose the type of entry you wish to modify. The Fonts dialog opens, showing all the fonts available on your system. Figure 275: Font dialog The Font text input box uses predictive text as you type to assist locating the wanted font. If you do not know its name, use the scrollbar to scroll through them.
You can choose whatever fonts you like, but if you are exchanging documents with someone else, you should choose fonts that are present on your colleague’s computer. Changing the color Use the command color to change the color of a subset of a formula: color red ABC gives ABC . Choose from 8 colors: white, black, cyan, magenta, red, blue, green, yellow. You may set a color for a subset of a formula if it is enclosed between { } or other parentheses. For instance: A B color green {C D} E gives A B C D E .
Figure 276. Inserting a cross-reference to an equation number The AutoText inserted as a result of the above procedure consists of a 1x2 table. The left cell contains the formula and the right one the number. The number is an automatic counter named Text. You can edit the AutoText if, for example, you prefer square rather than round brackets, or if you want formula and number to be separated by tabs rather than formatted as a table.
5) Switch to the Wrap tab of the dialog. Change the values for Left and Right in the Spacing section to 0.00. 6) Click OK to close the dialog. This changes the spacing for all formulas that have not had their spacing adjusted manually. You can find more information on using styles in “Default layout with style” on page 280 and in Chapter 3 (Using Styles and Templates) of the Getting Started guide. Text mode Larger formulas should always be in a paragraph of their own, separated from the text.
Fast insertion of formulas If you already know the markup of your formula, here is a faster method to build your formula: • Write the formula markup in Writer. • Select the markup. • Insert the formula using a toolbar button, a menu item, or a keyboard shortcut. This method avoids the need to open and close the Math window and thus saves time. Customizations Customizing the catalog If you need to use a symbol that is not available in Math, you can add it to the catalog yourself.
Figure 277: Edit Symbols dialog Figure 278: Edit Symbols dialog: characters selected Now the Symbol set view area shows the new symbol. It can be selected just like the other symbols, either from here, or by writing them directly into the equation editor in the form %prime. Caution Symbols (Greek or Special), in contrast to commands, are case sensitive (lowercase/uppercase). Numerous free fonts contain a great number of mathematical symbols. The “STIX1” font is worthy of special mention here.
Figure 279: Catalog with new symbol Note Many symbols occur in more than one font. If you want to exchange documents with others, take care to use a font that is installed on their machine. In the default LibreOffice installation, only those user-defined symbols that actually occur in the document are stored with it. Sometimes it is useful to embed all the user-defined symbols, for example when the document is going to be further edited by another person.
Application to chemical formulas Math was designed to build mathematical formulas, but it can also be used to write chemical formulas. In chemistry, formulas look like H2O: names are usually non-italic uppercase. To write chemical formulas with Math, deselect the Italic attribute in the Fonts dialog (see “Changing the font” on page 273).
Chapter 10 Printing, Exporting, and E-mailing
Introduction This chapter provides general information about printing, exporting, and e-mailing documents from LibreOffice. Quick printing Click the Print File Directly icon your computer. Note to send the entire document to the default printer defined for 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 pages, 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 LibreOffice, go to Tools > Options > LibreOffice – Print and Tools > Options > LibreOffice Writer – Print. See Chapter 2, Setting Up LibreOffice, for more details.
Figure 283: 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 284). Figure 284: 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. 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 292. 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 285: Printing a selection of text Calc You can choose single sheets, multiple sheets, and selections of cells for printing. Figure 286: 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, or press Ctrl+P. 3) In the Ranges and copies section of the Print dialog, choose the Selected sheets option. 4) Click the Print button. 288 | Getting Started with LibreOffice 4.
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, or press Ctrl+P. 3) In the Ranges and copies section of the Print dialog, choose the Selected sheets option. 4) Click the Print button. Printing a selection of cells: 1) In the document, select the section of cells to print.
Printing a selection from 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, or press Ctrl+P. 3) Select the Selection option in the Ranges and copies section of the Print dialog. 4) Click the Print button. Printing handouts, notes, or outlines in Impress Handouts prints the slides in reduced size on the page, from one to nine slides per page.
7) Click the Print button. 8) Take the printed pages out of the printer, turn the pages over, and put them back into the printer in the correct orientation to print on the blank side. You may need to experiment a bit to find out what the correct arrangement is for your printer. 9) On the Print dialog, in the Page sides section, select Front sides / right pages option from the Include drop down box. 10) Click the Print button. Tip If your printer can print double-sided automatically, choose All pages.
2) Click Properties to open the Properties dialog for the printer. The available choices vary from one printer to another, but you should find options for the Color settings. See your printer’s help or user manual for more information. 3) The choices for color might include black and white or grayscale. Choose the required setting. 4) Click OK to confirm your choice and return to the Print dialog, 5) Click the Print button to print the document.
3) To print the document from this view, click the Print document icon( dialog. Choose the print options and click the Print button. ) to open the Print Calc To preview the sheets in Calc before printing: 1) Choose File > Page Preview. The Calc window now displays the Page Preview toolbar instead of the Formatting toolbar. Figure 288. Page Preview toolbar (Calc) 2) To print the document from this view, click the Print document icon dialog. 3) Choose the print options and click the Print button.
Figure 289: General page of PDF Options dialog Images section • Lossless compression: Images are stored without any loss of quality. Tends to make large files when used with photographs. Recommended for other kinds of images or graphics. • JPEG compression: Allows for varying degrees of quality. A setting of 90% works well with photographs (small file size, little perceptible loss of quality). • Reduce image resolution: Lower DPI (dots per inch) images have lower quality.
when using screen reader software. Some tags that are exported are table of contents, hyperlinks, and controls. This option can increase file sizes significantly. • Create PDF form - Submit format: Choose the format of submitting forms from within the PDF file. This setting overrides the control’s URL property that you set in the document. There is only one common setting valid for the whole PDF document: PDF (sends the whole document), FDF (sends the control contents), HTML, and XML.
Figure 291: User Interface page of PDF Options dialog Window options section • Resize window to initial page. Causes the PDF viewer window to resize to fit the first page of the PDF. • Center window on screen. Causes the PDF viewer window to be centered on the computer screen. • Open in full screen mode. Causes the PDF viewer to open full-screen instead of in a smaller window. • Display document title. Causes the PDF viewer to display the document’s title in the title bar.
Export bookmarks as named destinations If you have defined Writer bookmarks, Impress or Draw slide names, or Calc sheet names, this option exports them as “named destinations” to which Web pages and PDF documents can link. Convert document references to PDF targets If you have defined links to other documents with OpenDocument extensions (such as .odt, .ods, and .odp), this option converts the files' extensions to .pdf in the exported PDF document.
Figure 294 shows the pop-up dialog displayed when you click the Set open password button on the Security page of the PDF Options dialog. Figure 294: Setting a password to encrypt a PDF Exporting to other formats LibreOffice 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. LibreOffice can export files to XHTML.
File > Send > E-mail as OpenDocument (Text, Spreadsheet, or Presentation) has the same effect. If you choose E-mail as Microsoft [Word, Excel, or Powerpoint], LibreOffice first creates a file in one of those formats and then opens your e-mail program with the file attached. Similarly, if you choose E-mail as PDF, LibreOffice first creates a PDF using your default PDF settings (as when using the Export Directly as PDF toolbar button) and then opens your email program with the PDF file attached.
2) On the second page, select E-mail message and click Next. Figure 296: 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 297: Selecting an address list 300 | Getting Started with LibreOffice 4.
4) Back on the Select address list page, click Next. On the Create salutation page, deselect This document should contain a salutation. Figure 298: Deselecting a salutation 5) In the left-hand list, click 8. Save, print or send. LibreOffice 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 email settings choices.
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. You can get a certificate from a certification authority, which may be a private company or a governmental institution.
Chapter 11 Graphics, the Gallery, and Fontwork
Introduction You can add graphic and image files, including photos, drawings, scanned images, and others, to LibreOffice documents. LibreOffice 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 LibreOffice can import.
Figure 300. Insert picture dialog Linking an image file If the Link option in the Insert picture dialog is selected, LibreOffice 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.
2) The Edit Links dialog (Figure 301) 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. Note Going the other way, from embedded to linked, is not so easy—you must delete and reinsert the images, one at a time, selecting the Link option when you do so.
Inserting an image from the Gallery The Gallery provides a convenient way to group reusable objects such as graphics and sounds that you can insert into your documents. The Gallery is available in all components of LibreOffice. See “Managing the LibreOffice Gallery“ on page 308. You can copy or link an object from the Gallery into a 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. Modifying and positioning graphics LibreOffice provides many tools for resizing, modifying, filtering, and positioning graphics; wrapping text around graphics; and using graphics as backgrounds and watermarks.
Adding objects to the Gallery You may wish to add to the Gallery any images that you use frequently, for example, a company logo. You can then very easily insert these graphics into a document later. You can add images only to “My Theme” or to any other theme that you have created; these are indicated by a differently colored icon from the defaults, in the list of themes. You cannot add images to the built-in themes.
Adding a new theme to the Gallery To add a new theme to the Gallery: 1) Click the New Theme button above the list of themes (Figure 303). 2) In the Properties of New Theme dialog, click the General tab and type a name for the new theme. 3) Click the Files tab and add images to the theme, as described earlier. Deleting a theme from the Gallery You can delete only themes that you have added to the Gallery; you cannot delete any of the built-in themes.
To use the image map editor: 1) In your LibreOffice document, select the picture where you want to define the hotspots. 2) Choose Edit > ImageMap from the menu bar. The ImageMap Editor (Figure 306) opens. 3) Use the tools and fields in the dialog (described below) to define the hotspots and links necessary. 4) Click the Apply icon to apply the settings. 5) When done, click the Save icon to save the image map to a file, then click the X in the upper right corner to close the dialog.
Below the toolbar, specify for the selected hotspot: • Address: the address pointed to by the hyperlink. You can also point to an anchor in a document; to do this, write the address in this format: file:////document_name#anchor_name • Text: type the text that you want to be displayed when the mouse pointer is moved over the hotspot. • Frame: where the target of the hyperlink will open: pick among _blank (opens in a new browser window), _self (opens in the active browser window), _top or _parent.
To use a drawing tool: 1) Click in the document where you want the drawing to be anchored. You can change the anchor later, if necessary. 2) Choose the tool from the Drawing toolbar (Figure 307). The mouse pointer changes to a drawing-functions pointer . 3) Move the cross-hair pointer to the place in the document where you want the graphic to appear and then click and drag to create the drawing object. Release the mouse button.
Resizing a drawing object An object is resized in a similar way to an image. Select the object, click on one of the eight handles around it and drag it to its new position. For a scaled resizing, select one of the corner handles and keep the Shift key pressed while dragging the handle to its new position. For more sophisticated control of the size of the object, choose Format > Object > Position and Size from the menu bar. Use the Position and Size dialog to set the width and height independently.
Figure 310. The Fontwork Gallery 3) Double-click the object to edit the Fontwork text (see Figure 311). Select the text and type your own text in place of the black Fontwork text that appears over the object. 4) Click anywhere in a free space or press Esc to apply your changes. Figure 311. Editing Fontwork text Editing a Fontwork object Now that the Fontwork object is created, you can edit some of its attributes.
Using the Fontwork toolbar Make sure that the Fontwork toolbar, shown in Figure 309, 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 312. Fontwork toolbar showing palette of shapes Fontwork Same Letter Heights: Changes the height of characters in the object.
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. (The toolbar shown in Figure 314 appears when you use Fontwork in Writer.) Figure 314. Formatting toolbar for a Fontwork object in Writer This figure shows the toolbar floating. In its default, docked position it is one of the toolbars located below the menu bar.
• Colors tab: Modify the available colors or add new ones to appear on the Area tab. • Gradients tab: Modify the available gradients or add new ones to appear on the Area tab. • Hatching tab: Modify the available hatching patterns or add new ones to appear on the Area tab. • Bitmaps tab: Create simple bitmap patterns and import bitmaps, to make them available on the Area tab. Area Style / Filling boxes: Select the type of the fill of the selected object. For more detailed settings, use the Area icon.
Figure 315: 3D-Settings toolbar Moving and resizing Fontwork objects When you select a Fontwork object, eight colored squares (known as handles) appear around the edge of the object, as shown below. You can drag these handles to resize the object. A yellow dot also appears on the object. This dot may be along an edge of the object, or it may be somewhere else; see figure to right for an example. If you hover the pointer over this yellow dot, the pointer turns into a hand symbol.
Chapter 12 Creating Web Pages Saving Documents as HTML Files
Introduction This chapter describes how to do the following in Writer, Calc, Impress and Draw: • 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 cross-references inserted by LibreOffice are not active links.
If you do not want LibreOffice to convert a specific URL to a hyperlink, go to Edit > Undo Insert on the main menu bar, or press Ctrl+Z immediately after the formatting has been applied, or place the cursor in the hyperlink, right-click, and select Remove Hyperlink from the context menu. Tip To change the color of hyperlinks, go to Tools > Options > LibreOffice > Appearance, scroll to Unvisited links and/or Visited links, pick the new colors and click OK.
You can also use the Navigator to insert a hyperlink from one document (the source) to a specific place in another document (the target). Open the Navigator in the target document and drag the item to the position in the source document where you want the hyperlink to appear. Using the Hyperlink dialog You can the Hyperlink dialog to insert a hyperlink and modify all hyperlinks. 1) Highlight the existing text you want to use as a link.
specify the target in the document (for example a specific slide). Click the Target in Document icon to open the Target in Document dialog where you can select the type of target; or, if you know the name of the target, you can type it into the box. • For a New Document hyperlink, specify whether to edit the newly created document immediately (Edit now) or just create it (Edit later). Enter the file name and select the type of document to create (text, spreadsheet, and so on).
Creating web pages using the Web Wizard The Web Wizard in LibreOffice allows you to create several types of standard web pages and is available all LibreOffice modules. However, each time you open the Web Wizard in a LibreOffice module, Writer will automatically start before the Web Wizard dialog opens. The Web Wizard is linked to Writer and is normally used in Writer for creating web pages. 1) Go to File > Wizards > Web Page on the main menu bar to open the Web Wizard dialog (Figure 318).
4) Click Next > and select a layout for the web site by clicking on the layout boxes (Figure 320). Figure 320: Main layout page of Web Wizard dialog 5) Click Next > to customize the layout and select the information to be listed and screen resolution (Figure 321). 6) Click Next > and select a style for the page. Use the drop-down list to choose different styles and color combinations. Browse to select a background image and icon set from the Gallery (Figure 322).
Figure 322: Style page of Web Wizard dialog 7) Click Next > and enter general information for the web site such as Title and HTML Metadata information (Figure 323). Figure 323: Web site information page of Web Wizard dialog 8) Click Next > and select where to save the file and preview the page if you wish (Figure 324). 9) Enter the information of where to publish your new web site. 10) Click Finish to save the file and close the Web Wizard. 328 | Getting Started with LibreOffice 4.
Figure 324: Preview page of Web Wizard dialog Saving documents as web pages HTML capabilities in LibreOffice include saving and exporting existing documents in HTML format. You can also create several different types of web pages using the Web Wizard included with LibreOffice, see “Creating web pages using the Web Wizard” on page 326 for more information. The easiest way to create HTML documents is to start with an existing document.
2) Go to File > Send > Create HTML Document on the main menu bar to open the Name and Path of the HTML Document dialog (Figure 325). Figure 325. Creating a series of web pages from one document 3) Type the file name to save the pages under. 4) Specify which style indicates a new page using the Styles drop list at the bottom of the dialog (for example Heading 1). 5) Click Save to create the multi-page HTML document. The resulting HTML files conforms to the HTML 4 Transitional.
Impress presentations cannot be saved in HTML format, but have to be be exported as HTML documents. Note that you can click Create at any step in the following procedure. The web pages created will then use the default settings that you have not changed in any way. 1) Go to File > Export on the main menu bar and specify the file name and location of where to save the web page version of your presentation.
4) Specify the Publication type for the web pages (Figure 327), then click Next>>. The publication type defines the basic settings for the intended export. The choices are: • Standard HTML format – creates standard HTML pages from export pages. • Standard HTML with frames – creates standard HTML pages with frames. The exported page will be placed in the main frame and the frame to the left will display a table of contents in the form of hyperlinks.
6) Specify the Information for the title page to be used with the web version of your presentation (Figure 329). The title page normally contains the author's name, an e-mail address and home page, along with any additional information you may want to include. This page is not available if you have selected not to create a title page and either Automatic or WebCast publication type.
Figure 331: HTML Export dialog – button style page Figure 332: HTML Export dialog – color scheme page 10) Click Create. 11) If you have created a new design for your web pages, type in a name for your design and click Save. Note Depending on the size of your presentation and the number of graphics it contains, the HTML export function creates several HTML, JPG, and GIF files.
Chapter 13 Getting Started with Macros Using the Macro Recorder … and Beyond
Introduction 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 LibreOffice macro language is very flexible, allowing automation of both simple and complex tasks. Macros are very useful when you have to repeat the same task in the same way over and over again. LibreOffice macros are usually written in a language called LibreOffice Basic, sometimes abbreviated to Basic.
Figure 334: LibreOffice Basic Macro Organizer dialog Figure 335: Integrated Debugging Environment dialog Use the following steps to create a library to contain your macro: 1) Use Tools > Macros > Organize Macros > LibreOffice Basic to open the LibreOffice Basic Macro dialog (Figure 333). 2) Click Organizer to open the Basic Macro Organizer dialog (Figure 334) and select the Libraries tab. 3) Set the Location to My Macros & Dialogs, which is the default location. 4) Click New to open the New Library dialog.
8) Select Module1, or the new module that you created, and click Edit to open the Integrated Debugging Environment (IDE) (Figure 335). The IDE is a text editor included with LibreOffice that allows you to create and edit macros. 9) When a new module is created, it contains a comment and an empty macro named Main, which does nothing. 10) Add the new macro either before Sub Main or after End Sub. Listing 2 shows the new macro has been added before Sub Main.
library named Standard. 7) Select the Standard library and click New Module to create a new module to contain the macro. This opens the New Module dialog (Figure 336). Figure 336: New Module dialog 8) Type a descriptive name for the new module, for example Recorded and click OK to create the module. The LibreOffice Basic Macros dialog now displays the name of the new module in the Standard library. 9) In the Macro name text box, type a name for the macro you have just recorded, for example EnterMyName.
2) Select your new macro EnterMyName and click Edit to open the macro in the Basic IDE. The macro EnterMyName is shown in Listing 3. The EnterMyName macro is not as complicated as it first appears. Learning a few things helps significantly in understanding macros. The discussion starts with features near the top of the macro listing and describes them.
• Another kind of subroutine is called a function, which is a subroutine that returns a value. Functions are defined by the keyword FUNCTION at the beginning. However, recorded macros in LibreOffice always create subroutines, not functions. Defining variables using Dim You can write information on a piece of paper so that you can look at it later. A variable, like a piece of paper, contains information that can be changed and read.
This is where the magic happens. The dispatch helper sends a dispatch to the document frame (stored in the variable named document) with the command .uno:InsertText. The next two arguments, frame name and search flags, are beyond the scope of this document. The last argument is the array of property values to be used while executing the command InsertText. end sub The last line of the code ends the subroutine.
The data can be cleaned up in several ways, all of them easy to accomplish. The example given below uses keystrokes that assume the cursor is at the start of the line with the text THIN. 1) Make sure macro recording is enabled by going to Tools > Options > LibreOffice > Advanced on the main menu bar and selecting the option Enable macro recording. By default, this feature is turned off when LibreOffice was installed on your computer.
args4(0).Value = CHR$(9) dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args4()) rem (6) Press Delete to delete the lower case s .... dispatcher.executeDispatch(document, ".uno:Delete", "", 0, Array()) rem (6) ... and then press Shift+S to add an upper case S. dim args6(0) as new com.sun.star.beans.PropertyValue args6(0).Name = "Text" args6(0).Value = "S" dispatcher.executeDispatch(document, ".
end sub Cursor movements are used for all operations (as opposed to searching). If run on the DONTKNOW line, the word weight is moved to the front of the line, and the first “The” is changed to “She”. This is not perfect, but you should not run the macro on the lines that did not have the proper format. You need to do these manually.
It is not possible to specify what kind of object to create or insert. If an object is inserted from a file, you cannot specify which file to insert. When recording a macro and using Tools > Options on the main menu bar to open and modify configuration items, the generated macro does not record any configuration changes. In fact, the generated code is commented so it will not even be run. rem dispatcher.executeDispatch(document, ".
Figure 339: Macro Library hierarchy If a macro is contained in a document, then a recorded macro will attempt to work on that document; because it primarily uses “ThisComponent” for its actions. 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.
It is not important to understand where macros are stored for casual use. If you know where they are stored, however, you can create a backup, share your macros, or inspect them if there is an error. Go to Tools > Macros > Organize Dialogs on the main menu bar to open the LibreOffice Macro Organizer dialog (Figure 334 on page 337).
Figure 341: Choose library import options 4) Select the following options for importing libraries: a) If no options are selected, the library is copied to your user macro directory. However, if the library you are importing has the same name and you are importing into the same location, it will not be copied. b) Select Replace existing libraries if the library you want to import has the same name and you want to replace the existing library.
How to run a macro Although you can use Tools > Macros > Run Macro to run all macros, this is not efficient for frequently run macros. See “Running a macro” on page 339 for more information. A more common technique for frequently used macros is to assign the macro a toolbar icon, menu item, keyboard shortcut, or a button embedded in a document.
Figure 342: Menus page in Customize dialog Events In LibreOffice, when something happens it means that an event occurred. For example, opening a document, pressing a key, or moving the mouse cursor. LibreOffice allows events to cause a macro to be called; the macro is then called an event handler. Full coverage of event handlers is well beyond the scope of this document, but a little knowledge can accomplish much. Caution Be careful when you configure an event handler.
Figure 343: Events page in Customize dialog Many objects in a document can be set to call macros when events occur. The most common use is to add a control, such as a button, into a document. Even double-clicking on a graphic opens a dialog with a Macros tab that allows you to assign a macro to an event. Extensions An extension is a package that can be installed into LibreOffice to add new functionality. Extensions can be written in almost any programming language and may be simple or sophisticated.
Writing macros without the recorder The examples covered in this chapter are created using the macro recorder and the dispatcher. You can also write macros that directly access the objects that comprise LibreOffice if you are confident in writing computer code. In other words, you can create a macro that directly manipulates a document. Directly manipulating LibreOffice internal objects is an advanced topic that is beyond the scope of this chapter. A simple example, however, demonstrates how this works.
http://forum.openoffice.org/en/forum/ (Apache OpenOffice community forum; volunteers answer questions about LibreOffice as well) http://api.openoffice.org/docs/common/ref/com/sun/star/module-ix.html (official IDL reference; here you will find almost every command with a description) https://wiki.documentfoundation.org/Documentation/Other_Documentation_and_Resources (look in Programmers section for BASIC Programmers’ Guide and Developers’ Guide; the latter contains a detailed explanation) http://www.
Chapter 14 Customizing LibreOffice
Introduction This chapter describes some common customizations that you may wish to do. You can customize menus, toolbars, and keyboard shortcuts in LibreOffice, 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 LibreOffice website or from other providers. Note Customizations to menus and toolbars can be saved in a template.
example, in addition to File, Edit, View, and so on, there is File | Send and Edit | Changes. The commands available for the selected menu are shown in the central part of the dialog. 5) To customize the selected menu, click on the Modify button. You can also add commands to a menu by clicking on the Add button. These actions are described in the following sections. Use the up and down arrows next to the Entries list to move the selected menu item to a different position.
To move submenus (such as File | Send), select the main menu (File) in the Menu list and then, in the Menu Content section of the dialog, select the submenu (Send) in the Entries list and use the arrow keys to move it up or down in the sequence. Submenus are easily identified in the Entries list by a small black triangle on the right hand side of the name.
Modifying menu entries In addition to changing the sequence of entries on a menu or submenu, you can add submenus, rename or delete the entries, and add group separators. To begin, select the menu or submenu to be modified, from the Menu list near the top of the Customize page, then select the entry in the Entries list under Menu Content. Click the Modify button and choose the required action from the drop-down list of actions. Most of the actions should be self-explanatory.
Modifying existing toolbars To modify an existing toolbar: 1) In the Save In drop-down list, choose whether to save this changed toolbar for the application (for example, Writer) or for a selected document. 2) In the section LibreOffice [name of the program (example: Writer)] > Toolbars, select from the Toolbar drop-down list the toolbar that you want to customize. 3) Click on the Toolbar or Modify buttons, and add commands to a toolbar by clicking on the Add button.
Choosing icons for toolbar commands Toolbar buttons usually have icons, not words, on them, but not all of the commands have associated icons. To choose an icon for a command, select the command and click Modify > Change icon. On the Change Icon dialog, you can scroll through the available icons, select one, and click OK to assign it to the command.
Figure 349: Setting up LibreOffice for sending faxes Your toolbar now has a new icon to send the current document as a fax. Figure 350: Adding a Send Fax command to a toolbar 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 LibreOffice functions or your own macros and save them for use with the entire LibreOffice suite.
To adapt shortcut keys to your needs, use the Customize dialog, as described below. 1) Select Tools > Customize > Keyboard. The Customize dialog opens. 2) To have the shortcut key assignment available in all components of LibreOffice select the LibreOffice button. 3) Next select the required function from the Category and Function lists. 4) Now select the desired shortcut keys in the Shortcut keys list and click the Modify button at the upper right. 5) Click OK to accept the change.
Figure 351. Defining keyboard shortcuts for applying styles Saving changes to a file Changes to the shortcut key assignments can be saved in a keyboard configuration file for use at a later time, thus permitting you to create and apply different configurations as the need arises. To save keyboard shortcuts to a file: 1) After making your keyboard shortcut assignments, click the Save button at the right of the Customize dialog (Figure 351).
Assigning macros to events In LibreOffice, when something happens, we say that an event occurred. For example, a document was opened, a key was pressed, or the mouse moved. You can associate a macro with an event, so the macro is run when the event occurs. A common use is to assign the “open document” event to run a macro that performs certain setup tasks for the document. To associate a macro with an event, use the Events page of the Customize dialog.
Figure 353: Dialog showing the installation choices 5) The extension begins installing. 6) In all three cases, during the process you may be asked to accept a license agreement. When the installation is complete, the extension is listed in the Extension Manager dialog. Tip To get extensions that are listed in the repository, you can open the Extension Manager and click the Get more extensions online link. You do not need to download them separately.
Appendix A Keyboard Shortcuts
Introduction You can use LibreOffice without requiring a pointing device, such as a mouse or touchpad, 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 LibreOffice. For shortcuts specific to Writer, Calc, Impress, Draw, or Base, read the relevant component guide or search the application Help. Some of the shortcuts listed here may not work if your operating system uses the same shortcuts for other tasks.
General keyboard shortcuts Opening menus and menu items Shortcut Keys Result Opens a menu where > is the underlined character of the menu you want to open. For example, Alt+F opens the menu File Alt+> With the menu open, you will again find underlined characters. You can access these menu items directly by simply pressing the underlined character key. Where two menu items have the same underlined character, press the character key again to move to the next item.
• Press Ctrl+Enter on the Selection tool to select the first draw object in the document. If you want to edit, size, or move the selected draw object, first use Ctrl+F6 to move the focus into the document. Navigating and selecting with the keyboard You can navigate through a document and make selections with the keyboard. • To move the cursor, press the key or key combination given in the following table.
Macros Shortcut Keys Result Ctrl+* (multiplication sign: on number pad only) Runs a macro field. Shift+Ctrl+Q Stops a running macro. Getting help Shortcut Keys Result F1 Opens the LibreOffice Help dialog. In LibreOffice Help: jumps to the first help page of the selected tab. Shift+F1 Turns the cursor into the What’s This? question mark. Shows the tip for an item underneath the cursor. Shift+F2 Shows tip for a selected item. Esc In LibreOffice Help: goes up one level.
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 dialog Ctrl+H Opens the Find & Replace dialog. Ctrl+Shift+F Searches for the last entered search term. Ctrl+Shift+R Refreshes (redraws) the document view.
Shortcut keys Result Tab Selects the next Drawing Object. Shift+Tab Selects the previous Drawing Object. Ctrl+Home Selects the first Drawing Object. Ctrl+End Selects the last Drawing Object. Esc Ends Drawing Object selection. Esc (in Handle Selection Mode) Exit Handle Selection Mode and return to Object Selection Mode. Up/Down/Left/Right Arrow Move the selected point (the snap-to-grid functions are temporarily disabled, but end points still snap to each other).
Shortcut keys Result Shift key while creating or scaling a graphic object The ratio of the object's width to height is fixed. Defining keyboard shortcuts In addition to using the built-in keyboard shortcuts listed in this Appendix, you can define your own. See Chapter 14, Customizing LibreOffice, for instructions. Further reading For help with LibreOffice’s keyboard shortcuts, or using LibreOffice with a keyboard only, search the application Help using the “shortcut keys” or “accessibility” keywords.
Appendix B Open Source, Open Standards, OpenDocument
Introduction LibreOffice is a productivity suite that is compatible with other major office suites and available on a variety of platforms. It is open source software and therefore free to download, use, and distribute. If you are new to LibreOffice, this appendix will provide some information regarding its history, its community and some of its technical specifications. A short history of LibreOffice The OpenOffice.
How is LibreOffice licensed? LibreOffice is distributed under the Open Source Initiative (OSI) approved Lesser General Public License (LGPL). The LGPL license is available from the LibreOffice website: http://www.libreoffice.org/download/license/ 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.
Since version 2.0, OpenOffice.org has supported the open standard OASIS OpenDocument as its default file format. LibreOffice saves documents in OpenDocument Format by default. LibreOffice 3 adopted version 1.2 of the OpenDocument standard and this version of LibreOffice continues to use this standard.
Opening spreadsheets In addition to OpenDocument formats (.ods, .ots, and .fods), Calc can open the formats used by OpenOffice.org 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/2010 XML (.xlsx, .xlsm, .xlts, .xltm) Microsoft Excel 2007/2010 binary (.xlsb) Lotus 1-2-3 (.wk1, .wks, and .123) Data Interchange Format (.dif) Rich Text Format (.
Opening formula files In addition to OpenDocument Formula (.odf) files, Math can open the format used by OpenOffice.org 1.x (.sxm), StarMath, (.smf), and MathML (.mml) files. When opening a Word document that contains an embedded equation editor object, if the option for it (MathType to LibreOffice Math or reverse) is checked in Tools > Options > Load/Save > Microsoft Office, the object will be automatically converted to a LibreOffice Math object.
Saving spreadsheet files In addition to OpenDocument formats (.ods and .ots), Calc can save in these formats: OpenOffice.org 1.x Spreadsheet (.sxc) OpenOffice.org 1.x Spreadsheet Template (.stc) Microsoft Excel 97/2000/XP (.xls and .xlw) Microsoft Excel 97/2000/XP Template (.xlt) Microsoft Excel 5.0 and 95 (.xls and .xlw) Microsoft Excel 2003 XML (.xml) Microsoft Excel 2007/2010 XML (.xlsx) Office Open XML Spreadsheet (.xlsx) Data Interchange Format (.dif) dBase (.dbf) SYLK (.slk) Text CSV (.csv and .
Exporting to other formats LibreOffice uses the term “export” for some file operations involving a change of file type. If you cannot find the file type you are looking for under Save As, look under Export for additional types. LibreOffice can export files to HTML and XHTML. In addition, Draw and Impress can export to Adobe Flash (.swf) and a range of image formats. To export to one of these formats, choose File > Export.
Index 3 3D objects 213 A accepting or rejecting changes 107 accessibility options 48 adding macros from other sources 336 Advanced experimental features 49 macro recording 49 Advanced options 49 advantages of LibreOffice 19 antialiasing screen font 39 appearance options 47 Apply Style list 62 arrow keys navigating within spreadsheets 120 Arrows 205 Asian language support 56 AutoCorrect 58, 94 AutoFormat, Calc 141 AutoLayout 166 automatic saving 30 AutoRecovery 30, 51 AutoUpdate styles 64 B background imag
Fill tool 134 selection lists 136 sharing content 136 speeding up 133 validating cell contents 137 data source description 216 editing 240 linking 238 registering 238 using in OOo documents 240 viewing 239 data validity 137 database AutoValue 222 creating 218 creating tables 219 field types and formats 220 planning 217 primary key 219, 221 registering 239 Report Wizard 255 Table Wizard 219 tables 219 database form activation order 237 background 236 creating in Design View 238 creating using a Wizard 227 en
matrix markup 268 right-click menu 264 event handling 351 export directly as PDF 293 export HTML 54 exporting Flash 298 PDF 293 XHTML 298 extended tips 37 extension Report Builder 258 extensions 352, 365 extensions and addons sources of 20 F fax icon, adding to toolbar 361 features 112 Impress 152 Writer 82 fields bookmarks 108 cross-reference 108 Fields dialog box References tab 109 file locations 42 file sharing options 45 Fill Format 62 Fill tool, Calc 134 floating toolbars 24 font history 40 ignore set
I icon size and style (user interface) 39 icons in menus 39 IDE 340 ignore font settings when importing HTML 54 image map 310 images adding from file 304 linking 305 scanned 306 importing files 378 importing numbers from an HTML page 54 Impress content boxes 164 font resizing 167 152, 153 indents 92 indexes and bibliographies 105 Insert Bookmark dialog 109 Insert Picture dialog 304 inserting columns and rows 125 sheets 126 installing and setting up 20 International Support 11 Internet options 57 J Java Run
Microsoft Office file conversion 53 Microsoft Windows Quickstarter 21 system requirements 20 middle mouse button function 40 mouse positioning 40 moving from sheet to sheet 120 MySQL 216 N Navigation icons 85 Navigation toolbar 85 Navigator 31, 120 new document 27 non-breaking hyphen 92 non-breaking spaces 92 nonconsecutive items, selecting 87 numbering equations 275 numbering pages 102 numbers 131 O OASIS 19 objects framing 198 hidden 198 ODF format version, saving 52 Office Assistant (Microsoft) 37 Open
Q queries (database) aliases 253 creating using a Wizard 246 creating using Design View 248 joined fields 229 search conditions 247 Query Wizard (database) 246 Quickstarter 21 enabling 38 R raster graphics 213 rectangle, drawing 191 redlines 106 regular expressions 89 relationships (database) 225 REM 340 remove personal information on saving 46 removing personal data 302 renaming sheets 128 renaming files 31 replacement table (font) 44 Report Wizard (database) 255 revision marks 106 RGB 188 right to left (
modifying 63 types supported 60 updating from a selection 64 168 Styles and Formatting window 61 SUB 340 subroutines 346 subroutines in macros 340 Sun Microsystems 376 support 10 system font (user interface) 39 T tab stops.
| Getting Started with LibreOffice 4.