Copyright This document is Copyright © 2016 by the LibreOffice Documentation Team. Contributors are 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/4.0/), version 4.0 or later. All trademarks within this guide belong to their legitimate owners.
Contents Copyright..................................................................................................................................... 2 Contributors................................................................................................................................. 2 Feedback..................................................................................................................................... 2 Acknowledgments.......................................................
Chapter 3 Using Styles and Templates............................................................................61 What is a template?................................................................................................................... 62 What are styles?........................................................................................................................ 62 Applying styles........................................................................................................
Working with columns and rows............................................................................................... 127 Working with sheets................................................................................................................. 129 Viewing Calc............................................................................................................................ 131 Using the keyboard.......................................................................................
Combining multiple objects...................................................................................................... 215 Arranging, aligning, and distributing objects............................................................................. 216 Inserting and editing pictures................................................................................................... 217 Working with 3D objects...............................................................................................
Chapter 12 Creating Web Pages.....................................................................................327 Introduction.............................................................................................................................. 328 Relative and absolute hyperlinks............................................................................................. 328 Creating hyperlinks......................................................................................................
File formats LibreOffice can save to......................................................................................... 385 Exporting to other formats........................................................................................................ 386 Index.................................................................................................................................. 387 8| Getting Started with LibreOffice 5.
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.
Table 1: Free support for LibreOffice users Free LibreOffice support Ask LibreOffice Questions and answers from the LibreOffice community http://ask.libreoffice.org/en/questions/ Documentation User guides, how-tos, and other documentation. http://www.libreoffice.org/get-help/documentation/ https://wiki.documentfoundation.org/Documentation/Publications FAQs Answers to frequently asked questions http://wiki.documentfoundation.
Using LibreOffice on a Mac Some keystrokes and menu items are different on a Mac from those used in Windows and Linux. The table below gives some common substitutions for the instructions in this chapter. For a more detailed list, see the application Help.
1) Tabbed page (not strictly speaking a control). 2) Radio buttons (only one can be selected at a time). 3) Checkbox (more than one can be selected at a time). 4) Spin box (click the up and down arrows to change the number shown in the text box next to it, or type in the text box). 5) Thumbnail or preview. 6) Drop-down list from which to select an item. 7) Push buttons. In most cases, you can interact only with the dialog (not the document itself) as long as the dialog remains open.
Is LibreOffice available in my language? LibreOffice has been translated (localized) into over 40 languages, so your language probably is supported. Additionally, there are over 70 spelling, hyphenation, and thesaurus dictionaries available for languages, and dialects that do not have a localized program interface. The dictionaries are available from the LibreOffice website at: www.libreoffice.org.
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 formulas in other documents, such as Writer and Impress files, Math can also work as a standalone tool. You can save formulas in the standard Mathematical Markup Language (MathML) format for inclusion in web pages and other documents not created by LibreOffice.
Minimum requirements LibreOffice 5.0 requires one of the following operating systems: • Microsoft Windows XP, Vista, Windows 7, Windows 8/8.1, or Windows 10. • GNU/Linux Kernel version 2.6.18, glibc2 v2.5 or higher, and gtk v2.10.4 or higher • Mac OS X 10.8 (Mountain Lion) 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 Opening an existing document before starting LibreOffice You can start LibreOffice by double-clicking the filename of an ODF document on the desktop, or in a file manager such as Windows Explorer or the Mac’s Finder. The appropriate component of LibreOffice will start and the document will be loaded.
Quickstarter When LibreOffice is installed on computers running Windows or Linux, a Quickstarter feature may also be installed. When Quickstarter is activated, the necessary library files are loaded when the computer system is started, resulting in a shorter startup time for LibreOffice components. Computers with a Mac operating system do not have a Quickstarter.
• Go to Tools > Options > LibreOffice > Memory on the Menu bar and deselect Load LibreOffice during system start-up (on Windows) or deselect Enable systray Quickstarter on Linux. Reactivating Quickstarter If Quickstarter has been disabled, you can reactivate it by using the instructions given in “Activating Quickstarter” above. Parts of the main window The main window is similar for each component of LibreOffice, although some details vary.
Displaying or hiding toolbars To display or hide toolbars, go to View > Toolbars on the Menu bar, then click on the name of a toolbar from the drop-down list. An active toolbar shows a check-mark beside its name. Toolbars created from tool palettes are not listed in the View menu. To close a toolbar go to View > Toolbars on the Menu bar and deselect the toolbar, or right-click in an empty space between the icons on a toolbar and select Close toolbar from the context menu.
Note You can also dock a floating toolbar by holding down the Ctrl key and double-clicking in the title bar of the toolbar. Floating toolbars LibreOffice includes several additional toolbars, whose default setting appear as floating toolbars in response to the current position of the cursor or selection. You can dock these toolbars to the top or bottom of the main window, or reposition them on your computer display (see “Moving toolbars” above).
• Click Customize Toolbar to open the Customize dialog; See Chapter 14 Customizing LibreOffice for more information. • Click Dock Toolbar to dock the selected floating 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 22. • Click Dock All Toolbars to dock all floating toolbars. By default, toolbars will dock at the top of the workspace.
Page style or slide design Shows the current page style or slide design. To edit the current page style or slide design, double-click on this field. To choose a different page style or slide design, right-click on this field and select from the list that pops up. Language Shows the current language of the text at the current cursor position. Insert mode Shows the type of insert mode the program is in. This field is blank if the program is in Insert mode.
To hide the Sidebar, click on the gray Hide button on the left. Click on the same button to show the Sidebar again. To undock the Sidebar and make it floating, and to dock a floating Sidebar, use the drop-down list at the top of the tab bar (see Figure 9). From the same list you can choose which items to include in the Sidebar.
You can also start a new document in one of the following ways: • Use File > New on the Menu bar and select the type of document from the context menu. • Use the keyboard shortcut Ctrl+N to create a new document. The type of document created depends on which LibreOffice component is open and active. For example, if Calc is open and active, a new spreadsheet is created. • Use File > Wizards on the Menu bar and select the type of document from the context menu.
Note You can choose whether to use the LibreOffice Open/Save dialogs or the ones provided by your computer’s operating system. See “Open and Save As dialogs” on page 30 for more information. This book uses the LibreOffice dialogs in illustrations. Saving documents You can save documents as follows: • Save command – use if you are keeping the document, its current filename and location.
• Go to File > Save As on the Menu bar. When the Save As dialog (Figure 10) or Save dialog opens, enter the file name, change the file type (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 30 for more information.
Changing the password When a document is password-protected, you can change the password while the document is open. Go to File > Properties > General on the Menu bar and click the Change Password button. This opens the Set Password dialog where you can enter a new password. Saving documents automatically LibreOffice can save files automatically as part of the AutoRecovery feature. Automatic saving, like manual saving, overwrites the last saved state of the file.
Graphics, Drawing Objects, and other items. In Impress and Draw it shows Slides, Pictures, and other items. To open the Navigator, click the Navigator icon on the Standard toolbar, or press the F5 key, or go to View > Navigator on the Menu bar, or click the Navigator icon in the Sidebar. In a default installation of LibreOffice, the Navigator is part of the Sidebar. Click the marker (+ or triangle) by any of the categories to display the list of objects in that category.
Closing a document If only one document is open and you want to close that document, go to File > Close on the Menu bar or click on the X on the right or left end of the Menu bar. On Windows and Linux, the document closes and the LibreOffice Start Center opens. On Mac OS X, the document closes and only the Menu bar remains at the top of the screen.
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 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.
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. Help – Extended tips When Extended tips is active, a brief description of the function of a particular icon or menu command or a field on a dialog appears when you hold the mouse pointer over that item.
• If your documents contain a lot of objects such as images, or the objects are large, LibreOffice’s performance may improve if you increase the memory for LibreOffice or the memory per object. If you find that objects seem to disappear from a document that contains a lot of them, increase the number of objects in the cache. (The objects are still in the file even if you cannot see them on screen.) • To load the Quickstarter when you start your computer, select the option near the bottom of the dialog.
Figure 16: Choosing View options for LibreOffice applications Mouse positioning Specifies if and how the mouse pointer will be positioned in newly opened dialogs. Middle mouse button Defines the function of the middle mouse button. • Automatic scrolling – dragging while pressing the middle mouse button shifts the view. • Paste clipboard – pressing the middle mouse button inserts the contents of the “Selection clipboard” at the cursor position.
Graphics output – Use OpenGL for all rendering Enables and disables the use of the 3D graphics language OpenGL. Not supported on all operating systems and LibreOffice distributions. Menu – icons in menus Causes icons as well as words to be visible in menus. Font Lists – Show preview of fonts Causes the font list to look like Figure 17, Left, with the font names shown as an example of the font; with the option deselected, the font list shows only the font names, not their formatting (Figure 17, Right).
Figure 18: Choosing general printing options to apply to all LibreOffice components In the Printer warnings section near the bottom of the page, you can choose whether to be warned if the paper size or orientation specified in your document does not match the paper size or orientation available for your printer. Having these warnings turned on can be quite helpful, particularly if you work with documents produced by people in other countries where the standard paper size is different from yours.
Figure 19: Viewing the paths of files used by LibreOffice Color options On the LibreOffice – Colors page, you can specify colors to use in LibreOffice documents. You can select a color from a color table, edit an existing color, and define new colors. These colors are stored in your color palette and are then available in all components of LibreOffice. To modify a color: 1) Select the color to modify from the list or the color table. 2) Enter the new values that define the color.
Figure 21: Editing colors The color window on the left is linked directly with the color input fields on the right; as you choose a color in the window, the numbers change accordingly. The color field at the lower left shows the value of the selected color on the left and the currently set value from the color value fields on the right. Modify the color components as required and click OK to exit the dialog. The newly defined color now appears in the lower of the color preview boxes shown in Figure 20.
On the LibreOffice – Fonts page: 1) Select the Apply replacement table option. 2) Select or type the name of the font to be replaced in the Font box. (If you do not have this font on your system, it will not appear in the drop-down list in this box, so you need to type it in.) 3) In the Replace with box, select a suitable font from the drop-down list of fonts installed on your computer.
Security options Use the LibreOffice – Security page to choose security options for saving documents and for opening documents that contain macros.
Passwords for web connections You can enter a master password to enable easy access to websites that require a user name and password. If you select the Persistently save passwords for web connections option, the Set Master Password dialog opens (Figure 24). LibreOffice will securely store all passwords that you use to access files from web servers. You can retrieve the passwords from the list after you enter the master password.
Ctrl-click required to follow hyperlinks The default behavior in LibreOffice is to Ctrl+click on a hyperlink to open the linked document. Many people find creation and editing of documents easier when accidental clicks on links do not activate the links. To set LibreOffice to activate hyperlinks using an ordinary click, deselect this option. The other options on this dialog should be self-explanatory.
Appearance options Writing, editing, and (especially) page layout are often easier when you can see the page margins (text boundaries), the boundaries of tables and sections (in Writer documents), page breaks in Calc, grid lines in Draw or Writer, and other features. In addition, you might prefer to use colors that are different from LibreOffice’s defaults for such items as comment indicators or field shadings.
Figure 29: Choosing accessibility options Advanced options 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 – Advanced options page to choose the JRE for LibreOffice to use.
Optional (unstable) options Enable experimental features Selecting this option enables features that are not yet complete or contain known bugs. The list of these features is different version by version. Enable macro recording (limited) This option enables macro recording with some limitations. Opening a window, switching between windows, and recording in a different window to that in which the recording began, is not supported.
Figure 32: 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.
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.
If you choose Load Basic code, you can edit the macros in LibreOffice. The changed code is saved in an ODF document but is not retained if you save into a Microsoft Office format. If you choose Save original Basic code, the macros will not work in LibreOffice but are retained unchanged if you save the file into Microsoft Office format. If you are importing a Microsoft Word or Excel file containing VBA code, you can select the option Executable 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 36. 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.
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. If the Display warning option is selected, then when exporting to HTML a warning is shown that LibreOffice Basic macros will be lost.
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 38: Choosing language options User interface The language of the user interface is usually set at the time LibreOffice is installed to match the language of the operating system.
Default languages for documents Select the languages used for the spelling checker, thesaurus, and hyphenation features of LibreOffice. If these options are only for the current document, select For the current document only. If necessary, select the options to enable support for Asian languages (Chinese, Japanese, Korean) and support for CTL (complex text layout) languages such as Urdu, Thai, Hebrew, and Arabic.
• If you use a custom dictionary that includes words in all upper case and words with numbers (for example, AS/400), select Check uppercase words and Check words with numbers. • Check special regions includes headers, footers, frames, and tables when checking spelling. Here you can also check which user-defined (custom) dictionaries are active by default, and add or remove user-installed dictionaries, by clicking the New or Delete buttons. Dictionaries installed by the system cannot be deleted.
Sentence spacing Checks for a single space between sentences, indicating when one or two extra spaces are found. More spaces Checks word and sentence spacing for more than two extra spaces. Em dash; En dash These options force a non-spaced em dash to replace a spaced en dash, or force a spaced en dash to replace a non-spaced em dash. Quotation marks Checks for correct typographical double quotation marks. Multiplication sign This option is selected by default.
If you are using a Unix- or Linux-based operating system (including Mac OS X), an additional page of E-mail options is available, where you can specify the e-mail program to use when you send the current document as e-mail. Under Windows the operating system’s default e-mail program is always used. A MediaWiki publisher is included on Windows and Linux. To enable it, select MediaWiki in the Internet options, then click the Add button to open the dialog shown in Figure 42.
Figure 43: The AutoCorrect dialog in Writer, showing some of the choices on the Options tab 60 | Getting Started with LibreOffice 5.
Chapter 3 Using Styles and Templates Using Consistent Formatting in Your Documents
What is a template? A template is a model document 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.
• Cell styles include fonts, alignment, borders, background, number formats (for example, currency, date, number), and cell protection. • Graphics styles in drawings and presentations include line, area, shadowing, transparency, font, connectors, dimensioning, and other attributes. • Presentation styles include attributes for font, indents, spacing, alignment, and tabs. Different styles are available in the various components of LibreOffice, as listed in Table 3.
Tip At the bottom of the Styles and Formatting window is a drop-down list. In Figure 44 the window shows Applied Styles, meaning the list includes only the styles used in the document. You can choose to show all styles or other groups of styles, for example only custom styles.
Figure 45: 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.
Using AutoUpdate AutoUpdate applies to paragraph and frame styles only. If the AutoUpdate option is selected on the Organizer page of the Paragraph Style or Frame Style dialog, applying direct formatting to a paragraph or frame using this style in your document automatically updates the style itself. Tip If you are in the habit of manually overriding styles in your document, be sure that AutoUpdate is not enabled.
Figure 48: Naming a new style created from a selection Dragging and dropping to create a style You can drag and drop a selection into the Styles and Formatting window to create a new style. The element to drag depends upon the LibreOffice application. Writer Select some text and drag it to the Styles and Formatting window. If Paragraph Styles are active, the paragraph style will be added to the list. If Character Styles are active, the character style will be added to the list.
Figure 49: Copying styles from a template into the open document Caution If your document has a table of contents, and if you have used custom styles for headings, the heading levels associated with outline levels in Tools > Outline Numbering will revert to the defaults of Heading 1, Heading 2, and so on when you load Text Styles from a file that does not use the same custom styles. You will need to change these back to your custom heading styles.
3) Select the folder that contains the template that you want to use. All the templates contained in that folder are listed on the page (as shown in Figure 50). 4) Select the template that you want to use. If you wish to view the template’s properties, click the Properties button above the list of templates. The template’s properties appear in a pop-up window. Click Close to close this pop-up window. 5) Select the required template. A new document based on the selected template opens in LibreOffice.
4) From the Menu bar, choose File > Templates > Save As Template. The Template Manager dialog (Figure 51) opens, displaying the default folders and any user-created folders. 5) Select the My Templates folder. 6) Select Save. 7) In the dialog that opens, type a name for the new template and click OK. 8) Close the Template Manager dialog.
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. The two names can be different but this may later cause you confusion. The default location is your user templates directory, but you can choose a different location if you prefer. 4) To set the file name or change the directory, select the Path button (the three dots to the right of the location). The Save As dialog opens.
Caution If you choose Keep Old Styles, the document is no longer connected to the template, even though the template is still listed under File > Properties > General. You can still import styles manually from the template, but to reconnect it to the template, you will have to copy it into an empty document based on the template. Adding templates obtained from other sources LibreOffice refers to sources for templates as repositories.
3) Find and select the package of templates you want to install and click Open. The package begins installing. You may be asked to accept a license agreement. 4) When the package installation is complete, restart LibreOffice. The templates are available for use through File > Templates > Manage and File > New > Templates and the extension is listed in the Extension Manager. See Chapter 14 Customizing LibreOffice for more about the Extension Manager.
Figure 54: Resetting the default template for text documents Associating a document with a different template At the time of writing this chapter, LibreOffice has no direct method of changing the template that a document uses; the Template Changer extension has not been updated for this version of LibreOffice. However, you can copy the contents of a document into an empty document that uses a different template.
Creating a template folder To create a template folder: 1) Go to the All Templates section of the Template Manager dialog. 2) Click the New folder button (see Figure 55). 3) In the pop-up dialog, type a name for the new folder and click OK. Figure 55: Creating a new folder Deleting a template folder You cannot delete template folders supplied with LibreOffice. Nor can you delete any folders added by the Extension Manager unless you first delete the extension that installed them.
3) Click the Delete button above the list of templates. A message box appears and asks you to confirm the deletion. Click Yes. Importing a template Before you can use a template in LibreOffice, it must be in one of the folders listed for the Template path in Tools > Options > LibreOffice > Paths: 1) In the Template Manager dialog, select the folder into which you want to import the template. 2) Click the Import button above the list of template folders. A standard file browser window opens.
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.
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 change some document features quickly. 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.
to exclude the text from a spelling check or choose More to open the Character dialog. Any directly formatted language settings can be reset to the default language from this menu. Insert mode This area is blank when in Insert mode. Double-click to change to Overwrite mode; singleclick to return to Insert mode. In Insert mode, any text after the cursor position moves forward to make room for the text you type; in Overwrite mode, text after the cursor position is replaced by the text you type.
Figure 62: View layouts: single, side-by-side, book. Sidebar The Writer sidebar (View > Sidebar) is located on the right side of the edit view. It is a mixture of toolbar and dialog and consists of four decks: Properties, Styles and Formatting, Gallery, and Navigator. Each deck has a corresponding icon on the Tab panel to the right of the sidebar, allowing you to switch between them. Each deck consists of a title bar and one or more content panels. Toolbars and sidebar panels share many functions.
If a frame is selected, then the wrap panel opens but may be grayed-out if frame wrap is not available. Caution Be aware that by changing the options on the Page panel you will change the page style in use, modifying not only the current page but all pages using the same page style. • Styles and Formatting: Manage the styles used on the document, applying existing styles, creating new ones or modifying them.
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. (When in Full Screen view, press the Esc key to return to either Print or Web Layout view.) Print Layout is the default view in Writer. In this view, you can use the Zoom slider and the View Layout icons on the Status Bar to change the magnification.
Working with documents Chapter 1, Introducing LibreOffice, includes instructions on starting new documents, opening existing documents, saving documents, and password-protecting documents. Chapter 3, Using Styles and Templates, covers how to create a document from a template. Saving as a Microsoft Word file If you need to exchange documents with users of Microsoft Word who are unwilling or unable to receive ODT files, you can open, edit, and save documents in Microsoft Word formats.
Tip To have Writer save documents by default in the Microsoft Word file format, go to Tools > Options > Load/Save > General. In the section named Default file format and ODF settings, under Document type, select Text document, then under Always save as, select your preferred file format. See Figure 67. Figure 67: Tools > Options > Load/Save > General page Working with text Working with text (selecting, copying, pasting, moving) in Writer is similar to working with text in any other program.
Figure 68: 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, toolbar buttons, or keyboard shortcuts. You can also copy text from other sources such as Web pages and paste it into a Writer document.
window (just above the Status Bar) in Figure 71, but you can float it or dock it in another location. For more information on floating and docking toolbars, see Chapter 1, Introducing LibreOffice. Figure 71: Docked position of Find toolbar To use the Find toolbar, click in the box and type your search text, then press Enter to find the next occurrence of that term from the current cursor position. Click the Find Next or Find Previous buttons as needed.
Figure 72: Expanded Find & Replace dialog Inserting special characters A special character is one not found on a standard English keyboard. For example, © ¾ æ ç ñ ö ø ¢ are all special characters. To insert a special character: 1) Place the cursor where you want the character to appear. 2) Choose Insert > Special Character to open the Special Characters dialog. 3) Select the characters (from any font or mixture of fonts) you wish to insert, in order, then click OK.
Figure 73: The Special Characters dialog, where you can insert special characters 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.
chosen a different default tab spacing, tabbed material will change to use the other person’s settings. Instead of using the defaults, define your own tab settings, as described in this section. To define indents and tab settings for one or more selected paragraphs, double-click on a part of the ruler that is not between the left and right indent icons to open the Indents & Spacing page of the Paragraph dialog.
To perform a combined spelling and grammar check on the document (or a text selection) click the Spelling and Grammar button. This checks the document or selection and opens the Spelling and Grammar dialog if any unrecognized words are found. In order to use this, the appropriate dictionaries must be installed. By default, four dictionaries are installed: a spellchecker, a grammar checker, a hyphenation dictionary, and a thesaurus.
The spelling checker works only for those languages in the list that have the symbol ( ) next to them. If you do not see the symbol next to your preferred language, you can install the additional dictionary using Tools > Language > More Dictionaries Online. The language used for checking spelling is also shown in the Status Bar, next to the page style in use. Using AutoCorrect Writer’s AutoCorrect function has a long list of common misspellings and typing errors, which it corrects automatically.
Note Automatic word completion only occurs after you type a word for the second time in a document. Using AutoText Use AutoText to store text, tables, graphics and other items for reuse and assign them to a key combination for easy retrieval. For example, rather than typing “Senior Management” every time you use that phrase, you can set up an AutoText entry to insert those words when you type “sm” and press F3. AutoText is especially powerful when assigned to fields.
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 click the Clear Direct Formatting button on the Formatting toolbar, or use Ctrl+M from the keyboard. Writer defines several types of styles, for different types of elements: characters, paragraphs, pages, frames, and lists. See Chapter 3, Using Styles and Templates, in this book and Chapters 6 and 7 in the Writer Guide.
Tip If you notice unexpected formatting changes occurring in your document, this is the first place to look for the cause. The Help describes each of these choices and how to activate the autoformats. Some common unwanted or unexpected formatting changes include: • Horizontal lines. If you type three or more hyphens (---), underscores (___) or equal signs (===) on a line and then press Enter, the paragraph is replaced by a horizontal line as wide as the page.
Numbering dialog. However, the Sidebar does not include tools for promoting and demoting items in the list, as found on the Bullets and Numbering toolbar.
Figure 78: Turning on automatic hyphenation You can also set hyphenation choices through Tools > Options > Language Settings > Writing Aids. In Options, near the bottom of the dialog, scroll down to find the hyphenation settings. Figure 79: Setting hyphenation options To change the minimum number of characters for hyphenation, the minimum number of characters before a line break, or the minimum number of characters after a line break, select the item, and then click the Edit button in the Options section.
Which layout method to choose? The best layout method depends on what the final document should look like and what sort of information will be in the document. Here are some examples. For a book similar to this user guide, with one column of text, some figures without text beside them, and some other figures with descriptive text, use page styles for basic layout, and tables to place figures beside descriptive text when 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”. Creating headers and footers A header is an area that appears at the top of a page above the margin. A footer appears at the bottom of the page below the margin. Information such as page numbers inserted into a header or footer displays on every page of the document with that page style.
Inserting header and footer contents Other information such as document titles and chapter titles is often put into the header or footer. These items are best added as fields. That way, if something changes, the headers and footers are updated automatically. Here is one common example. To insert the document title into the header: 1) Choose File > Properties > Description and type a title for your document. 2) Add a header (Insert > Header > Default). 3) Place the cursor in the header part of the page.
3) On the Text Flow tab of the Paragraph dialog (Figure 78 on page 100), select Breaks. 4) Select Insert and then With Page Style and specify the page style to use. 5) Specify the page number to start from, and then click OK. Tip Method 1 is also useful for numbering the first page of a document with a page number greater than 1. For example, you may be writing a book, with each chapter in a separate file.
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 and displays the current setting in a tool-tip. 2) Hold down the left mouse button and drag the mouse to move the margin. Figure 83: Moving the margins Caution The small arrowheads (gray triangles) on the ruler are used for indenting paragraphs.
Figure 84: Example of comments Choose Tools > Options > LibreOffice > User Data to configure the name you want to appear in the Author field of the comment, or to change it. If more than one person edits the document, each author is automatically allocated a different background color. Right-click on a comment to open a context menu where you can delete the current comment, all the comments from the same author, or all the comments in the document.
To do this: 1) Place the cursor within the table of contents. 2) Right-click and choose Update Index/Table from the context menu. Note If you cannot place the cursor in the table of contents, choose Tools > Options > LibreOffice Writer > Formatting Aids, and then select Enable in the Cursor in protected areas section. You can customize an existing table of contents at any time. Right-click anywhere in it and choose Edit Index/Table from the context menu.
All these facilities use a registered data source (a spreadsheet or database containing the name and address records and other information). Chapter 11, Using Mail Merge, in the Writer Guide describes the process. Tracking changes to a document You can use several methods to keep track of changes made to a document. 1) Make your changes to a copy of the document (stored in a different folder, or under a different name, or both), then use Writer to combine the two files and show the differences.
• When using a hyperlink, you do not have a choice of the content of the link (for example text or page number), but when using a cross-reference, you have several choices, including bookmarks. • To hyperlink to an object such as a graphic, and have the hyperlink show useful text such as Figure 6, you need to give such an object a useful name (instead of a default name like Graphics6), or use the Hyperlink dialog to modify the visible text.
To insert a cross-reference to a heading, figure, bookmark, or other item: 1) In your document, place the cursor where you want the cross-reference to appear. 2) If the Fields dialog is not open, click Insert > Cross-reference. On the Cross-references tab (Figure 86), in the Type list, select the type of item to be referenced (for example, Heading or Figure). You can leave this page open while you insert many cross-references.
Figure 87: Inserting a bookmark Using master documents Master documents are typically used for producing long documents such as a book, a thesis, or a long report; or when different people are writing different chapters or other parts of the full document, so you don’t need to share files. A master document joins separate text documents into one larger document, and unifies the formatting, table of contents (TOC), bibliography, index, and other tables or lists. Since LibreOffice version 4.
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.
Menu bar The Menu bar is where you select one of the menus and various sub-menus appear giving you more options. You can also customize the Menu bar; see Chapter 14 Customizing LibreOffice for more information. Figure 88: Calc main dialog, without Sidebar • File – contains commands that apply to the entire document; for example Open, Save, Wizards, Export as PDF, Print, Digital Signatures and so on.
Toolbars The default setting when Calc opens is for the Standard and Formatting toolbars to be docked at the top of the workspace (Figure 88). 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 either moved to different docked position on the workspace, or left as a floating toolbar.
Spreadsheet layout Individual cells The main section of the workspace in Calc displays the cells in the form of a grid. Each cell is formed by the intersection of one column and one row in the spreadsheet. At the top of the columns and the left end of the rows are a series of header boxes containing letters and numbers. The column headers use an alpha character starting at A and go on to the right. The row headers use a numerical character starting at 1 and go down.
Figure 91: Calc status bar Sidebar The Calc Sidebar (View > Sidebar) is located on the right side of the window. It is a mixture of toolbar and dialog and consists of five decks: Properties, Styles and Formatting, Gallery, Navigator, and Functions. Each deck has a corresponding icon on the Tab panel to the right of the sidebar, allowing you to switch between them. Figure 92: Calc Sidebar with Properties open The decks are described below. • Properties: This deck includes four content panels.
– Number Format: Provides a way to quickly change the format of numbers including decimals, currency, dates, or numeric text. Numerical and label field controls for Forms are also available. Each of these panels has a More Options button, which opens a dialog that gives a greater number of options. These dialogs lock the document for editing until they are closed.
Figure 93: Text Import dialog • • Separator Options – specifies whether your data uses separators or fixed widths as delimiters. – Fixed width – separates fixed-width data (equal number of characters) into columns. Click on the ruler in the preview window to set the width. – Separated by – select the separator used in your data to delimit the data into columns. When you select Other, you specify the character used to separate data into columns. This custom separator must also be contained in your data.
• Fields – shows how your data will look when it is separated into columns. – Column type – select a column in the preview window and select the data type to be applied the imported data. – Standard – Calc determines the type of data. – Text – imported data are treated as text. – US English – numbers formatted in US English are searched for and included regardless of the system language. A number format is not applied. If there are no US English entries, the Standard format is applied.
6) Click Save. 7) Each time you click Save, the Confirm File Format dialog opens (Figure 95). Click Use [xxx] Format to continue saving in your selected spreadsheet format or click Use ODF Format to save the spreadsheet in Calc ODS format. 8) If you select Text CSV format (*.csv) for your spreadsheet, the Export Text File dialog (Figure 96) opens allowing you to select the character set, field delimiter, text delimiter and so on to be used for your CSV file.
• Using the mouse – place the mouse pointer over the cell and click the left mouse button. To move the focus to another cell using the mouse, simply move the mouse pointer to the cell where you want the focus to be and click the left mouse button. • Using a cell reference – highlight or delete the existing cell reference in the Name Box on the Formula Bar (Figure 89 on page 115). Type the new cell reference of the cell you want to move to and press Enter key.
• Using the keyboard – using key combinations Ctrl+Page Down moves one sheet to the right and Ctrl+Page Up moves one sheet to the left. • Using the mouse – clicking on one of the sheet tabs at the bottom of the spreadsheet selects that sheet. If your spreadsheet contains a lot of sheets, then some of the sheet tabs may be hidden behind the horizontal scroll bar at the bottom of the screen.
Table 4. Keyboard cell navigation Keyboard shortcut Cell navigation → Moves cell focus right one cell ← Moves cell focus left one cell ↑ Moves cell focus up one cell ↓ Moves cell focus down one cell Ctrl+→ Moves cell focus to the first column on the right containing data in that row if cell focus is on a blank cell. Moves cell focus to the last column on the right in the same range of occupied cells in that row if cell focus is on a cell containing data.
Customizing the Enter key You can customize the direction in which the Enter key moves the cell focus by going to Tools > Options > LibreOffice Calc > General. Select the direction cell focus moves from the drop-down list. Depending on the file being used or the type of data being entered, setting a different direction can be useful. The Enter key can also be used to switch into and out of editing mode. Use the first two options under Input settings in Figure 100 to change the Enter key settings.
To select a range of cells without using the mouse: 1) Select the cell that will be one of the corners in the range of cells. 2) While holding down the Shift key, use the cursor arrows to select the rest of the range. Tip You can also directly select a range of cells using the Name Box. Click into the Name Box on the Formula Bar (Figure 89 on page 115).
Selecting sheets You can select either one or multiple sheets in Calc. It can be advantageous to select multiple sheets, especially when you want to make changes to many sheets at once. Single sheet Click on the sheet tab for the sheet you want to select. The tab for the selected sheet becomes white (default Calc setup). Multiple contiguous sheets To select multiple contiguous sheets: 1) Click on the sheet tab for the first desired sheet.
Using the mouse: 1) Select a column or row where you want the new column or row inserted. 2) Right-click the column or row header. 3) Select Insert Columns or Insert Rows from the context menu. Multiple columns or rows Multiple columns or rows can be inserted at once rather than inserting them one at a time. 1) Highlight the required number of columns or rows by holding down the left mouse button on the first one and then dragging across the required number of identifiers.
Working with sheets Inserting new sheets Click on the Add Sheet icon . This inserts a new sheet after the last sheet in the spreadsheet without opening the Insert Sheet dialog. The following methods open the Insert Sheet dialog (Figure 103) where you can position the new sheet, create more than one sheet, name the new sheet, or select a sheet from a file. 1) Select the sheet where you want to insert a new sheet, then go to Insert > Sheet on the Menu bar.
Using a dialog Use the Move/Copy Sheet dialog (Figure 104) to specify exactly whether you want the sheet in the same or a different spreadsheet, its position within the spreadsheet, the sheet name when you move or copy the sheet. 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 Menu bar. 2) Select Move to move the sheet or Copy to copy the sheet.
To delete multiple sheets, select the sheets (see “Selecting sheets” on page 127), then right-click one of the sheet tabs and select Delete Sheet from the context menu, or go to Edit > Sheet > Delete from on the Menu bar. Click Yes to confirm the deletion. Renaming sheets By default, the name for each new sheet added is SheetX, where X is the number of the next sheet to be added.
Freezing rows or columns 1) Click on the row header below the rows where you want the freeze, or click on the column header to the right of the columns where you want the freeze. 2) Go to Window on the Menu bar and select Freeze. A heavier line appears between the rows or columns indicating where the freeze has been placed. Freezing rows and columns 1) Click into the cell that is immediately below the rows you want frozen and immediately to the right of the columns you want frozen.
Splitting horizontally and vertically 1) Click in the cell that is immediately below the rows where you want to split the screen horizontally and immediately to the right of the columns where you want to split the screen vertically. 2) Go to Window on the Menu bar and select Split. Heavy black lines appear between the rows or columns indicating where the split has been placed.
Method 1 1) With the cell selected, right-click on the cell, select Format Cells from the context menu or go to Format > Cells on the Menu bar or use the keyboard shortcut Ctrl+1 to open the Format Cells dialog (Figure 108). Figure 108: Format Cells dialog – Numbers page 2) Make sure the Numbers tab is selected then select Number in the Category list. 3) In Options > Leading Zeros, enter the minimum number of characters required. For example, for four characters, enter 4.
If a number is entered with leading zeroes, for example 01481, without first setting the Leading zeros parameter, then by default Calc will automatically drop the leading 0. To preserve leading zeros in a number: 1) Type an apostrophe (') before the number, for example '01481. 2) Move the cell focus to another cell. The apostrophe is automatically removed, the leading zeros are retained and the number is converted to text left aligned.
Method 2 1) Select the cell. 2) Open the Sidebar (View > Sidebar) and click the Open Panel (+) icon on the Number Format panel. 3) Select Date in the Category list box, or click the Date icon below the list box. 4) Click the More Options button in the panel title bar to open the Format Cells dialog. 5) Select the date or time format you want to use from the Format list. 6) Click OK.
Figure 111: AutoCorrect dialog Deactivating automatic changes Some AutoCorrect settings are applied when you press the spacebar after you enter data. To turn off or on Calc AutoCorrect, go to Tools > Cell Contents on the Menu bar and deselect or select AutoInput. Speeding up data entry Entering data into a spreadsheet can be very labor-intensive, but Calc provides several tools for removing some of the drudgery from input.
Alternatively, you can use a shortcut to fill cells. 1) Select the cell containing the contents you want to copy or start the series from. 2) Move the cursor over the small square in the bottom right corner of the selected cell. The cursor will change shape. 3) Click and drag in the direction you want the cells to be filled. If the original cell contained text, then the text will automatically be copied. If the original cell contained a number, a series will be created.
• • Series Type – defines the series type. – Linear – creates a linear number series using the defined increment and end value. – Growth – creates a growth series using the defined increment and end value. – Date – creates a date series using the defined increment and end date. – AutoFill – forms a series directly in the sheet. The AutoFill function takes account of customized lists.
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 114). 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 ensures that they enter data that is valid and 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 but will retain the original formatting used in the cell. Alternatively, click in the Input Line on the Formula Bar (Figure 89 on page 115), then double-click on the data to highlight it completely and type the new data.
3) Under Properties, select Wrap text automatically and click OK. Figure 117: Format Cells dialog – Alignment page Method 2 1) Select the cell. 2) Open the Sidebar (View > Sidebar) and click the Open Panel (+) icon on the Alignment panel. 3) Select the Wrap text option to apply the formatting immediately. Figure 118: Wrap text formatting 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.
Shrinking text to fit the cell The font size of the data in a cell can automatically adjust to fit inside cell borders. To do this, select the Shrink to fit cell size option under Properties in the Format Cells dialog (Figure 117) on the Alignment page. This dialog is also available by clicking the More Options button in the Character title bar of the Properties deck on the opened Sidebar.
4) To change the character format, click on the Bold, Italic, or Underline icons. 5) To change the paragraph alignment of the font, click on one of the four alignment icons (Left, Center, Right, Justified) . 6) To change the font color, click the arrow next to the Font Color icon palette, then select the desired color. to display the color The Properties deck of the Sidebar has two panels, Character and Alignment, which between them contain all the formatting controls from the Formatting toolbar.
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. 2) Go to Format > AutoFormat on the Menu bar to open the AutoFormat dialog (Figure 122). 3) Select the type of format and format color from the list. 4) If necessary, click More to open Formatting if Formatting is not visible.
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 125: 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 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 126: Sort Criteria dialog To sort cells in your spreadsheet: 1) Select the cells to be sorted. 2) Go to Data > Sort on the Menu bar to open the Sort dialog (Figure 126). 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 for page order, details, and scale to be used when printing a spreadsheet: 1) Go to Format > Page on the Menu bar to open the Page Style dialog (Figure 127). 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.
Figure 128: Edit Print Ranges dialog Page breaks While defining a print range can be a powerful tool, it may sometimes be necessary to manually adjust the Calc printout manually using a manual or page break. A page break helps to ensure that your data prints properly according to your page size and page orientation. You can insert a horizontal page break above or a vertical page break to the left of the active cell.
Headers and footers are also assigned to a page style. You can define more than one page style for a spreadsheet and assign different page styles to different sheets within a spreadsheet. For more information on page styles, see the Calc Guide Chapter 4 Using Styles and Templates. Setting a header or footer To set a header or footer: 1) Navigate to the sheet that you want to set the header or footer for. 2) Go to Format > Page on the Menu bar to open the Page Style dialog (Figure 129).
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.
Figure 130: Main window of Impress; ovals indicate the Hide/Show markers Slides pane The Slides pane contains thumbnail pictures of the slides in your presentation in the order in which they will be shown, unless you change the slide show order. Clicking a slide in this pane selects it and places it in the Workspace. When a slide is in the Workspace, you can make changes to it.
Properties Shows the layouts included within Impress. You can choose the one you want and use it as it is, or modify it to meet your own requirements. However, it is not possible to save customized layouts. Master Pages Here you define the page (slide) style for your presentation. Impress includes several designs of Master Pages (slide masters). One of them – Default – is blank, and the rest have background and styled text.
Many of the toolbars in Impress are similar to the toolbars in Draw. Refer to the Draw Guide for details on the functions available and how to use them. Status bar The Status bar (Figure 131), located at the bottom of the Impress window, contains information that you may find useful when working on a presentation. For details on the contents and use of these fields, see Chapter 1 Introducing LibreOffice in this guide and the Impress Guide Chapter 1 Introducing Impress.
Workspace views Each of the workspace views is designed to ease the completion of certain tasks. It is therefore useful to familiarize yourself with them in order to accomplish those tasks quickly. Note Each Workspace view displays a different set of toolbars when selected. These toolbar sets can be customized by going to View > Toolbars on the Menu bar, then check or uncheck the toolbar you want to add or remove. Normal view Normal view is the main view for working with individual slides.
• Compare slides with your outline (if you have prepared one in advance). If you notice from your outline that another slide is needed, you can create it directly in the Outline view or you can return to the Normal view to create it. Notes view Use the Notes view (Figure 134) to add notes to a slide. These notes are for your information and are not seen by the audience when the presentation is shown. Figure 134: Notes view 1) Click the Notes tab in the Workspace.
Figure 135: Handout layouts Figure 136: Header and Footer dialog – Notes and Handouts page Slide Sorter view Slide Sorter view (Figure 137) contains all of the slide thumbnails. Use this view to work with a group of slides or with only one slide. Figure 137: Slide Sorter view 162 | Getting Started with LibreOffice 5.
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 138). 2) Adjust the number of slides (up to a maximum of 15). Figure 138: 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 137).
Creating a new presentation using the Presentation Wizard This section describes how to start a new presentation using the Presentation Wizard. Tip The first thing to do is decide on the purpose of the presentation and set out a plan. Although you can make changes as you go, you will save a lot of time by having an initial idea of who the audience will be, the structure, the content, and how the presentation will be delivered. When you start Impress, the Presentation Wizard may appear (Figure 139).
Figure 140: Selecting a slide design 4) Select how the presentation will be used under Select an output medium. The majority of presentations are created for computer screen display so it is recommended to select Screen. You can change the page format at any time. Note The Screen page is set by default for a 4:3 display (28cm x 21cm) so it is not suitable for modern widescreen displays. Use the Widescreen option instead.
– Choose the desired slide transition from the Effect drop-down menu. – Select the desired speed for the transition between the different slides in the presentation from the Speed drop-down menu. Medium is a good choice for now. – Select the presentation type. For most purposes, choose Default; you can change this later. For details on the choices under Automatic, see the Impress Guide.
Figure 143: Presentation preview Formatting a presentation A new presentation contains only one empty slide. In this section we will start adding new slides and preparing them for the intended contents. Inserting slides New slide A new slide can be inserted into a presentation as follows: 1) Go to Insert on the Menu bar and select Slide. Or, right-click on a slide in the Slides Pane or Slide Sorter view and select New Slide from the context menu.
Or, click on the triangle to the right of the Slide icon in the Presentation toolbar and select Duplicate Slide from the context menu. If the Presentation toolbar is not visible, go to View > Toolbars on the Menu bar and select Presentation from the list. 3) A duplicate slide is inserted after the selected slide in the presentation. Selecting slide layout When creating a presentation, the first slide is normally a title slide.
To select or change the layout of a slide, select the slide in the Slides Pane so that it appears in the Workspace and select the desired layout from the Layouts section in the Sidebar. Several layouts contain one or more content boxes. Each of these content boxes can be configured to contain text, movies, images, charts or tables. You can choose the type of contents by clicking on the corresponding icon that is displayed in the middle of the contents box as shown in Figure 145.
Adding text To add text to a slide that contains a text frame, click on Click to add text in the text frame and then type your text. The Outline styles are automatically applied to the text as you insert it. You can change the outline level of each paragraph as well as its position within the text by using the arrow buttons on the Text Formatting toolbar (see Figure 133 and “Outline view” on page 160). For more information on text, see “Adding and formatting text” on page 171.
You can use Slide Show on the 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. To change the slide transition, animate slides, add a soundtrack to the presentation, and make other enhancements, you need to use functions in the Sidebar. See the Impress Guide for details on how to use all of these features. Adding and formatting text Many of your slides are likely to contain some text.
Figure 148: Creating and editing text boxes 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. Vertical text is available only when Asian languages are enabled in Tools > Options > Language Settings > Languages. Click the Vertical Text icon in the Standard toolbar or Text toolbar to create a vertical text box.
Formatting pasted text When formatting pasted text, you can use the tools available on the Text Formatting toolbar (Figure 150), or the tools available in the Character and Paragraph sections of the Properties deck in the Sidebar (Figure 151). If the Character and Paragraph sections do not automatically open after selecting some text, click on the Properties icon at the side of the Sidebar.
If you are pasting text in a text box, you can still use styles to format the text quickly. Only one graphic style can be applied to the pasted text, as follows: 1) Paste the text in the desired position. 2) Select the text you have just pasted. 3) Select the desired graphic style to format the text. 4) Apply any necessary manual formatting to the text to change font attributes, tabs, and so on.
3) To promote a list entry (move it to the left), press Shift+Tab or click the Promote (left arrow) icon on the Text Formatting toolbar or use the keyboard shortcut Alt+Shift+Left. The list entry moves to the left and is indented at the next higher level. 4) To create a new list entry at the same level as the previous one, press Enter again. In the AutoLayout text boxes, promoting or demoting an item in the list corresponds to applying a different outline style.
3) 4) The Bullets and Numbering dialog (Figure 152) contains five pages: Bullets, Numbering type, Image, Position, and Customize. – If a bullet list is needed, select the desired bullet style from the default styles available on the Bullets page. – If a graphics style is needed, select one from those available on the Image page. – If a numbered list is needed, select one of the default numbering styles on the Numbering type page.
2) If there is a table already on the slide and it is selected, click the Table icon on the Table toolbar. The Table toolbar is only visible after selecting View > Toolbars > Table on the Menu bar and when a table is selected. 3) Alternatively and after inserting a new slide into your presentation, click the Insert Table icon (Figure 145 on page 169). 4) Select the number of rows and columns required from the Insert Table dialog that opens.
After the table is created, you can modify it by adding and deleting rows and columns, adjusting width and spacing, adding borders, background colors and so on. For more information on working with tables see the Impress Guide Chapter 3 Adding and Formatting Text and the Writer Guide Chapter 9 Working with Tables. 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.
have to resize the visible area on the slide. You can also insert an existing spreadsheet and use the viewport to select the data that you want to display on your slide. Impress offers the capability of inserting into a slide various other types of objects such as Writer documents, Math formulas, Draw drawings, or another presentation. For details on using these objects, refer to the Impress Guide Chapter 7 Including Spreadsheets, Charts, and Other Objects.
it to show thumbnails of the slides, or click the – sign to collapse the subsection to hide the thumbnails. Each of the slide masters shown in the Available for Use list is from a template of the same name. If you have created your own templates, or added templates from other sources, slide masters from those templates will also appear in this list.
Applying a slide master To apply a slide master to all the slides in your presentation: 1) Click on the Master Pages icon (Figure 154). in the Sidebar to open the Master Pages section 2) To apply one of the slide masters from the available selection to all slides in your presentation, right-click on it and select Apply to All Slides on the context menu.
Figure 157: Load Slide Design dialog Note The slide masters you have loaded will also be available the next time you load the presentation. If you want to delete the unused slide masters, click the corresponding checkbox in the Slide Design dialog. If the slide master was not used in the presentation, it is removed from the list of available slide masters. Tip To limit the size of the presentation file, you may want to minimize the number of slide masters used.
Note Any changes made to one slide when in Master View mode will appear on all slides using this slide master. Always make sure you Close Master View and return to Normal view before working on any of the presentation slides. Figure 158: Editing a slide master Note The changes made to one of the slides in Normal view (for example, changes to the bullet point style, the color of the title area, and so on) will not be overridden by subsequent changes to the slide master.
Footers To add a footer to your slides: 1) Go to View > Master > Slide Master on the Menu bar to open Master View (Figure 159). 2) Go to Insert > Date or Insert > Page Number on the Menu bar and time to open the Header and Footer dialog (Figure 160). 3) Select the type of date and time and type in the footer text and slide number from the available options in the dialog. Figure 159: Example master view Figure 160: Footer dialog in Impress 184 | Getting Started with LibreOffice 5.
4) Click Apply to All to apply your changes to all the slide masters in your presentation, or click Apply to apply your changes to the selected slide master in your presentation. 5) Alternatively, you can add the date/time, footer text and slide number directly into their respective areas as shown in Figure 159. 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 183.
Figure 161: Inserting comments You can move the small comment markers to anywhere you wish on the slide. Typically you might place it on or near an object you refer to in the comment. To show or hide the comment markers, choose View > Comments. Select Tools > Options > User Data to configure the name you want to appear in the comment. If more than one person edits the document, each author is automatically allocated a different background color for their comments.
2) Go to Slide Show > Custom Slide Show on the Menu bar. 3) Click on the New button to create a new sequence of slides and save it with a different name. You can have as many slide shows as you want from a single presentation. Slide transitions Slide transition is the animation that is played when a slide is changed for the next slide in your presentation. You can configure the slide transition from the Slide Transition section in the Tasks Pane.
If the slide advance is set to Automatically after X sec, let the slide show run by itself. If the slide advance is set to 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. • Click the mouse to move to the next slide. • Press the spacebar on the keyboard to advance to the next slide.
Chapter 7 Getting Started with Draw Vector Drawing in LibreOffice
What is Draw? LibreOffice 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 an assembly of simple geometric elements such as lines, circles, and polygons, rather than a collection of pixels (points on the screen). Vector graphics allow for easier storage and scaling of the image.
Figure 163: LibreOffice Draw workspace Pages pane You can split drawings in Draw over several pages. Multi-page drawings are used mainly for presentations. The Pages pane gives an overview of the pages that you create in your drawing. If the Pages pane is not visible, go to View on the Menu bar and select Page Pane. To make changes to the page order, drag and drop one or more pages. Sidebar The Sidebar has four main sections.
Gallery Opens the Drawing gallery where you can insert an object into your drawing either as a copy or as a link. A copy of an object is independent of the original object. Changes to the original object have no effect on the copy. A link remains dependent on the original object. Changes to the original object are also reflected in the link. Navigator Opens the Drawing navigator, in which you can quickly move between pages in your drawing or select an object on the drawing.
Status bar The Status bar is located at the bottom of the workspace 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 166: Draw status bar Note The sizes are given in the current measurement unit. They might not be the same as the ruler units.
Options toolbar Use the Options toolbar to activate or deactivate various drawing aids. By default, the Options toolbar is not shown, but you can display it from the View > Toolbars menu. Choosing and defining colors To display the Colors dialog (Figure 167), select View > Toolbars > Color Bar to display the current color palette. By default, the Color Bar is displayed below the workspace. You can hide or show it by clicking on its Hide/Show button.
To load another palette, click on the Load Color List icon . The file selector dialog asks you to choose one of the standard LibreOffice palettes (files with the file extension *.soc). For example, web.soc is a color palette that is adapted to creating drawings for placing in web pages. These colors will display correctly on workstations with screens capable of at least 256 colors.
Figure 169: Drawing a straight line Hold down the Alt key while drawing a line to cause the line to extend 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 a line by clicking on it, then right-click and select Line from the context menu or go to Format > Line on the Menu bar to open the Line dialog (Figure 170).
lines and arrows. Alternatively, go to View > Toolbars > Arrows to open the Arrows toolbar as a floating toolbar (Figure 171). 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. After drawing the line, you can change the arrow style by clicking on the Arrowheads icon the Line and Filling toolbar and select the arrow start and end options.
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. The ellipse or circle uses the start point (where you first clicked the mouse button) as the center. Note If you first press and hold down the Ctrl key and then click on one of the icons for Line, Rectangle, Ellipse, or Text, a standard sized object is drawn automatically in the work area; the size, shape, and color are all standard values.
A filled curve automatically joins the last point to the first point to close off the figure and fills it with the current standard fill color. A curve without filling will not be closed at the end of the drawing. Polygons Click and draw the first line from the start point with the left mouse button held down. As soon as you release the mouse button, a line between the first and second points is drawn. Move the cursor to draw the next line.
deselect the text frame. When you have finished typing text, click outside the text frame to cancel adding or editing text. 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 Graphic styles that you can reuse for other text frames.
Figure 175: Glue Points toolbar and available tools Connectors Connectors are lines or arrows whose ends automatically snap to a glue point of an object. Connectors are especially useful in drawing organization charts, flow diagrams, and mind-maps. When objects are moved or reordered, the connectors remain attached to a glue point. Figure 176 shows an example of two objects and a connector. Draw offers a range of different connectors and connector functions.
Drawing geometric shapes The icons for drawing geometric shapes are located on the Drawing toolbar. The geometric shapes are explained in the following sections. Clicking on the triangle to the right of the icon on the Drawing toolbar opens a floating toolbar giving access to the tools for that shape. Tip The use of these tools for geometric shapes is similar to the tool used for drawing rectangles or squares. For more information, see page 197 and the Draw Guide Chapter 2 Drawing Basic Shapes.
Flowcharts Click on the triangle to the right of the Flowcharts icon to open the Flowchart toolbar for symbols used in drawing flowcharts. The creation of flowcharts, organization charts, and similar planning tools is further described in the Draw Guide Chapter 8 Connections, Flowcharts and Organization Charts. Figure 181: Flowcharts toolbar Callouts Click on the triangle to the right of the Callouts icon to open the Callouts toolbar.
To select multiple objects by framing, the Select icon on the Drawing toolbar must be active. Note When dragging the mouse cursor to select multiple objects, the selection rectangle being drawn is also known as a marquee. Selecting hidden objects Even if objects are located behind others and not visible, they can still be selected. Hold down the Alt key and click on the object at the front of where the hidden object is located, then click again to select the hidden object.
Moving and adjusting object size When moving an object or changing its size, check the left-hand area of the status bar at the bottom of the Draw window (Figure 185). The area on the left of the Status bar, from left to right, shows what object is selected, its position on the drawing in X/Y coordinates and dimensions of the object. The units of measurement are those selected in Tools > Options > LibreOffice Draw > General.
Note 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. 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. Note If you press the Shift key while rotating an object, rotation will be restricted to 15° of movement. This is the default behavior of the Shift key.
Editing objects To edit an object or change attributes such as color or border width, the Line and Filling toolbar, the Text Formatting toolbar, the Sidebar Properties section, or a 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 not shown.
Sidebar Properties When you select an object in your drawing, the sub-sections in Sidebar Properties become active (Figure 192). You can change the properties or options of an object without having to open a dialog or use any of the available tools on the various toolbars provided by Draw. To expand a subsection, click on the plus (+) sign or arrow next to the sub-section title.
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 194). Figure 194: Common line properties (style, color, width) If you need to fine tune the appearance of a line, choose Format > Line from the Menu bar, or right-click on the line and select Line from the context menu, or select the Line icon from the Line and Filling toolbar.
Figure 196: Different types of area fill Using styles Suppose that you want to apply the same area fill, line thickness, and border to a set of objects. This repetitive process can be greatly simplified by the use of styles. Styles allow you to define a format (a style) and then apply that format to multiple objects.
Displaying the grid To display the grid in Draw or to switch off the grid, go to View > Grid > Display Grid on the 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 Menu bar to open the options dialog for the grid. Figure 198: Configuring the grid • Vertical and horizontal spacing of the dots in the grid.
Applying special effects With Draw, you can apply many special effects to objects and groups of objects. This section is an introduction to some of these effects. For more information on special effects, see the Draw Guide Chapter 4 Changing Object Attributes. To access the tools used for special effects, go to View > Toolbars > Mode (Figure 199). Rotate and Flip can also be accessed by going to Modify on the Menu bar or by right-clicking on the object and using the context menu.
In all three cases you are initially asked if you want to transform the object to a curve. This is a necessary first step, so click Yes. Then you can move the object handles to produce the desired effect. See the Draw Guide Chapter 4 Changing Object Attributes for more information on how to distort an object. Dynamic transparency gradients You can control transparency gradients in the same manner as color gradients. Both types of gradient can be used together.
Cross-fading Cross-fading transforms one object shape to another object shape and only works when two objects are selected. 1) Select two differently shaped objects. 2) Go to Edit > Cross-fading on the Menu bar to open the Cross-fading dialog (Figure 202). 3) Select Increments to determine the number of shapes between the two objects. 4) Select Cross-fading attributes to apply a gradual change of line and fill properties between the two objects.
Grouping Temporary grouping A temporary grouping is when several objects are selected using the Select icon on the Drawing toolbar or using the mouse to drag a rectangle around the objects (also known as a marquee). Any changes to object parameters you carry out are applied to all of the objects within the temporary group. For example, you can rotate a temporary group of objects in its entirety.
See the Draw Guide Chapter 5 Combining Multiple Objects for more information on arranging and aligning objects in relation to each other. 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 conversion from one graphic format to another. Draw includes a large range of graphic filters so that it can read and display several graphic file formats.
2) Type or paste your comment into the text box. You can apply basic formatting to parts of the text by selecting it, right-clicking, and choosing from the context menu. From this menu, 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.
Chapter 8 Getting Started with Base Relational Databases in LibreOffice
Introduction 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. This chapter covers creating a database, showing what is contained in a database and how the different parts are used by LibreOffice.
elements. The tables are subsets. Relationships are defined in terms of unions and intersections of the subsets (tables). To explain how a database works and how to to use it, we will create one for automobile expenses. 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.
Creating a new database To create a new database, select 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.
Caution As you create a database, you should save your work regularly. This means more than saving what you have just created. You must save the whole database as well. For example, when you create your first table, you must save it before you can close it. This makes it part of the database in memory. But it is only when you save the database file that the table is written to disk. Creating database tables In a database, a table stores information in a group of things we call fields.
2) Sample tables: Select CD-Collection. The Available fields box changes to a list of available fields for this table. 3) Selected fields: Using the > button, move the following fields from the Available fields window to the Selected fields window in this order: CollectionID, AlbumTitle, Artist, DatePurchased, Format, Notes, and NumberofTracks. 4) Selected Fields from another sample table. Click Business as the Category. Select Employees from the drop down list of sample tables.
Note If any of these fields requires a mandatory entry, set Entry required to Yes. A blank field will then not be allowed. In general, only set Entry required to Yes if something must always be put in that field. By default, Entry required is set to No. • CollectionID: Change AutoValue from No to Yes. (example of a mandatory entry) • AlbumTitle: – Entry required: Leave Entry required as No, unless all of your music is in albums.
Note A primary key uniquely identifies an item (or record) in the table. For example, you might know two people called “Randy Herring” or three people living at the same address and the database needs to distinguish between them. The simplest method is to assign a unique number to each one: number the first person 1, the second 2, and so on. Each entry has one number and every number is different, so it is easy to say “record ID 172”.
Creating tables in Design View Design View is a more advanced method for creating a new table, in which you directly enter information about each field in the table. We will use this method for the tables of our database. Note While the Field type and formatting are different in Design View, the concepts are the same as in the Wizard. The first table to be created is Fuel. Its fields are FuelID, Date, FuelCost, FuelQuantity, Odometer, and PaymentType.
Note The primary key serves only one purpose: to identify each record uniquely. Any name can be used for this field. We have used FuelID for convenience, so we know to which table it belongs. 3) All other fields (Date, FuelCost, FuelQuantity, Odometer, and PaymentType): a) Type the next field name in the Field Name column. b) Select the Field Type for each field. • For Date use Date[DATE]. (Press the D key to select it.) • All other fields use Number [NUMERIC]. (Press the N key once to select it.
Figure 210: Format example options 4) To save and close the table, select File > Save. Name the table Fuel. Close the Fuel table. 5) In the main database window, click the Save button. Figure 211: Fields in Vacations table Follow the same steps to create the Vacations table. The fields, field types, and Descriptions are listed in Figure 211. Making Date the primary key has to be done in a different way because this field’s field type is Date, not Integer.
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.
Figure 213: Selected fields in a relationship Tip The primary key can contain more than one field. (Its foreign key1 will contain the same number of fields.) If this were the case in Figure 213, the other fields of the primary field for the Fuel table would be listed under Date. The corresponding fields of the foreign key would be listed under Vacations. Detailed information about this is in the Base Guide. Figure 214: Update options and Delete options section f) Click OK.
Figure 215: Fields of a simple form Figure 216:Simple form with additions In our database, payments for food or fuel might be made from one of two credit cards (Dan or Kevin) or in cash, so these would be the available options for all boxes that contain payments. To create a list box, we first need to create a small, separate table containing the options. This is then linked to the corresponding field in the form.
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 Subform based upon existing relation. 3) Fuel is listed as a relation we want to add. So click Fuel to highlight it, as in Figure 218. Click Next. Figure 218: Adding a subform Step 3: Add subform fields This step is similar to step 1.
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. Caution When selecting a pair of fields from two tables to use as a relationship, they have to have the same field type. That is why we used the Date field from both tables: both their field types are Date[DATE].
Step 7: Apply styles 1) Select the color you want in the Apply Styles list. (I chose the beige which is Orange 4 in the Color table.) 2) Select the Field border you want. (I prefer the 3D look. You might want to experiment with the different possible settings.) 3) Click Next. Step 8: Set name 1) Enter the name for the form. In this case, it is Fuel. 2) Click Modify the form. 3) Click Finish. The form opens in Edit mode.
Figure 222: Selecting a field of a control • Moving a group of controls is almost as easy as moving one of them. a) Click the field of the top left control to be moved, to select it. b) Move the cursor to just above and to the left of the selected control. c) Drag the cursor to the bottom right of the group of controls and release the mouse button. As you drag the cursor, a dashed box appears, showing what is contained in your selection.
Tip To see what the Date field will look like, click the Form Mode On/Off icon (the second icon from the left in Figure 224). You can do this any time you want to see the form with the changes you have made. Step 2: Shorten the width of some fields All of the fields with a label containing the word payment are too wide. They need to be shortened before the controls are moved. Figure 225: Selecting a field 1) Control+click the BPayment field. 2) Move the cursor over the middle green handle on the right.
Figure 22b: Positioning of controls (right side of form) 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) 2) 3) Control+click the SnackNo label.
1) Right-click Breakfast and select Position and Size. On the Position and Size dialog, change Width to 2 cm. 2) Repeat for the other listed controls, using 3 cm for MiscPayment. Caution When changing the position or size of an entire control, use the Position and Size dialog or the drag and drop method. 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.
4) Scroll down to the Scrollbars setting. Change the selection from None to Vertical in this list. 5) Close the Properties window. (Esc key) 6) Lengthen the Misc. Notes field by moving the cursor over the middle green handle at the bottom of the field and dragging down until the length is 6 cm (2.4 inches). Step 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.
Tip If you know how to use styles, you can open the Styles and Formatting window using F11. Right-clicking the Heading 2 paragraph style allows you to modify the appearance of all three headings. See Chapter 6 of the Writer Guide for details. 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.
– None: No background. – Gradient: You can select increments between the colors to be automatic or you can select the amount of it. Remove the check to specify the amount. – Hatching: Select the hatching design. Then if you want a background color, check Background color and select the color. – Bitmap: Select the bitmap design that you want. 4) Click Apply to see what your selection will look like in your form. 5) Change if necessary. 6) Click OK to select your final decision.
Figure 232: Open Gallery Note You can create custom Gradients, Hatchings, and Bitmaps using the Draw component of LibreOffice. See the Draw Guide for information how to do this. 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.
Figure 234: Tab order for the main form Entering data in a form Records are used to organize the data we enter into a form. They also organize the data we enter into a subform. Different types of fields allow different methods of data entry. In many cases, more than one method can be used. The first step to entering data in a form is to open it from the main database window (Figure 205). 1) Click the Forms icon in the Database list. 2) Find the form’s name in the Forms list (Vacations).
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. • Clicking the up arrow increases the value, and the down arrow decreases the value by one unit. • These two arrows only change the numerals to the left of the decimal place. • Numerals to the right of the decimal place must be changed by deleting them and typing the desired ones.
Figure 236 is a record with data inserted in its fields. Figure 236: Sample record of the Vacation form and sub form Creating queries Queries are used to get specific information from a database. Query results are special tables within the database. To demonstrate the use of queries, we will use two different methods: • Using our CD-Collection table, we will create a list of albums by a particular artist. We will do this using the Wizard.
Step 1: Select the fields 1) Select the CD-Collection table from the drop down list of tables. 2) Select fields from the CD-Collection table in the Available fields list. a) Click Artist, and use the > button to move it to the Fields in the Query list. b) Move the AlbumTitle and DatePurchased fields in the same manner. c) Click Next. Tip To change the order of the fields, select the field you want to move and click the up or down arrow to the right of the Fields in the Query list.
3) Repeat this process for CD-Collection.DatePurchased. 4) Click Next. Step 3: Select the search conditions The search conditions allow us to compare the name we entered with the names of the artist in our database and decide whether to include a particular artist in our query results or not.
5) To the right of this are two choices. Select Display Query. 6) 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. What fuel economy is our vehicle getting (miles per gallon in the USA)? This question requires creating two queries, with the first query used as part of the second 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 241: 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. 2) Click the Run Query icon in the Query Design toolbar.
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. a) Click Queries to get the list of queries in the database (Figure 245). b) Click End-Reading. c) Click Add, and then click Close.
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. (Figure 248) 2) Type ='1' in the Criterion cell of this column. 3) Leave the Visible cell of this column unchecked. 4) Calculate the distance traveled: – Type in the Field cell.(Figure 249) "End-Reading".
Figure 250: Fuel economy calculation field Note When entering fields for these calculations, you must follow this format: table or query name followed by a period followed 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 250. Use the arithmetical symbol between the two. More than one calculation can be done by using parentheses to group the arithmetical operations.
Step 10: Close, save, and name the query My suggestion for a name is Fuel Economy. 1) 2) 3) 4) Click the Save icon. Name the query. Close the query. Save the database file. There are obviously other calculations that can be made in this query such as cost per distance traveled and how much of the cost belongs to each of the payment types. Note To fully use queries requires a knowledge of set operations (unions, intersections, and, or, complements, or any combinations of these).
The expenses for our vacation are motel, tolls, miscellaneous, breakfast, lunch, supper, snacks, and fuel. One possible report could list the totals of each of these expense groups. Another could list the expense totals for each day of the vacation. A third could list the totals for each expense group for each type of payment. (This would let us know where the money came from to pay the expenses.) Once you create a query to do any one of these, you can create a report based upon the query.
Step 2: Labeling fields Change any field labels you wish. We will shorten Miscellaneous to Misc. and make SnackCost into two words. Figure 255: Giving aliases to fields 1) Shorten Miscellaneous to Misc. 2) Add a space to separate SnackCost into Snack Cost. 3) Click Next. Step 3: Grouping Since we are grouping by the date, use the > button to move the Date field to the Grouping list. Click Next.
Step 6: Create report 1) Label the report: Vacation Expenses. 2) Select Dynamic report. 3) Select Create report now. 4) Click Finish. The report (Figure 258) has been created, but it needs some editing. The date could be formatted better, and all the numbers need to be formatted as currency. It could use a heading that includes its name, its author, and the date it was prepared.
2) Select Connect to an existing database. Click the arrow next to the Database type field and select the database type from the drop down list. Click Next. 3) Click Browse and select the database. Click Next. 4) Accept the default settings: Register the database for me, and Open the database for editing. Click Finish. Name and save the database in the location of your choice. Caution One of the choices available when you select Connect to an existing database is LDAP Address Book.
Using data sources in LibreOffice Having registered the data source, whether a spreadsheet, text document, external database or other accepted data source, you can use it in other LibreOffice components including Writer and Calc. Viewing data sources Open a document in Writer or Calc. To view the data sources available, press F4 or select View > Data Sources from the pull-down menu.
Launching Base to work on data sources You can launch LibreOffice Base at any time from the Data Source window. Just right-click on a database or its Tables or Queries icons and select Edit Database File. Once in Base, you can edit, add, and delete tables, queries, forms, and reports. Using data sources in Writer and Calc Data can be placed into Writer and Calc documents from the tables in the data source window. In Writer, values from individual fields can be inserted.
8) Add data to the fields of the sentence: – Click the gray box to the left of the row of data you want to add. That row should be highlighted like the second row of Figure 263. – Click the Data to Fields icon (circled). This should fill the fields with the data from the row you chose. – Click another row and then click this icon again. The data in the sentence changes to this selected row of data. – Save the document if you want to use it as an example later.
4) Move the fields you want in your table from the Database Columns list to the Table column(s) list. – To place the fields in the order you select, click the field and use the single arrow to move the fields in the order you desire. You can also limit the fields you use to less than all of the fields available. – If you want to use all of the fields, use the double arrow pointing to the right to move all of them at one time.
7) Click the Edit File button to make the spreadsheet read-only. Click Save when asked if you want to save the file. The Data Sources window goes blank, the fields in the spreadsheet are populated with data from the row you selected, and the Form Navigation toolbar appears at the bottom of the spreadsheet. 8) Click the arrows on the Form Navigation toolbar to view the different records of the table. (The arrows are circled in red.
Chapter 9 Getting Started with Math LibreOffice’s Formula (Equation) Editor
Introduction LibreOfficeMath is a formula editor you can use to create or edit formulas (equations), in a symbolic form, within LibreOffice documents or as standalone objects. Example formulas are shown below. However, if you want to evaluate numeric values using formulas, then refer to the Calc Guide for more information as Math does not carry out any actual calculation. df ( x) + − −1 2 =ln ( x)+tan ( x ) or NH3 +H2 O ⇌NH 4 +OH dx The Formula Editor in Math uses a markup language to represent formulas.
As you enter the markup language in the Formula Editor, the formula will appear in the Preview window during and after input of the markup language. The Elements window to the left of the Preview window may also appear, if it has been selected in View on the menu bar. For more information on creating formulas, see “Creating formulas” on page 267. Formulas in LibreOffice documents To insert a formula into a LibreOffice document, open the document in Writer, Calc, Draw, or Impress.
Formulas are inserted as OLE objects into documents. You can, as with any OLE object, change how the object is placed within the document. For more information on OLE objects, see the user guides for Math, Writer, Calc, Draw, and Impress. If you frequently insert formulas into documents, it is recommended to add the Formula button to the Standard toolbar or create a keyboard shortcut. See Chapter 14, Customizing LibreOffice, for more information.
Figure 268: Context menu in Formula Editor Note The Elements window and the context menu contain only the most common commands that are used in formulas. For some seldom-used commands, you must always enter the command using the markup language. For a complete list of commands, see the Math Guide. Markup language Markup language is entered directly into the Formula Editor. For example, typing the markup language 5 times 4 into the Formula Editor creates the simple formula 5×4 .
Commands Reference, in the Math Guide for a list of Greek characters that can be entered using markup language. • For a lowercase Greek character, type a percentage % sign, then type the character name in lowercase using the English name. For example, typing %lambda creates the Greek character λ. • For an UPPERCASE Greek character, type a percentage % sign, then type the character name in UPPERCASE using the English name. For example, typing %LAMBDA creates the Greek character Λ.
2) Select the first placeholder before the word times in the Formula Editor and replace it with the character 5. The formula in the document updates automatically. 3) Select the second placeholder after the word times in the Formula Editor and replace it with the character 4. The formula in the document updates automatically. This method initially places the formula text times in the Formula Editor and the symbol appears in the document.
2) In Writer, Calc, Impress, or Draw, double-click on the formula, or right-click on the formula and select Edit form the context menu to open the Formula Editor in editing mode. The cursor is positioned at the start of the formula in the Formula Editor. Note If you cannot select a formula element using the cursor, click on the Formula Cursor icon 3) in the Tools toolbar to activate the formula cursor.
Math has recognized the minus sign as a prefix for the 1 and has therefore placed it in the numerator of the fraction. If you wish to show that the whole fraction is negative, with the minus sign in front of the fraction, you must put the fraction in braces to signify to Math that the characters belong together. Adding braces to into the markup language {1 over 2} gives the result – whole fraction is now negative.
Unpaired brackets When using brackets in a formula, Math expects that for every opening bracket there will be a closing one. If you forget to add a closing bracket, Math places an inverted question mark next to where the closing bracket should have been placed. This inverted question mark disappears when all the brackets are paired. However, an unpaired bracket is sometimes necessary and you have the following options.
Formulas over multiple lines Suppose you want to create a formula that requires more than one line, for example x=3 and y=1 your first reaction would normally be to press the Enter key. However, if you press the Enter key, the markup language in the Formula Editor goes to a new line, but the resulting formula does not have two lines. You must type the macro command newline each time you want to create and display a new line in a formula.
Writing derivatives When writing derivatives, you have to tell Math that it is a fraction by using the over command. The over command is combined with the character d for a total derivative or the partial command for a partial derivative to achieve the effect of a derivative. Braces {} are used each side of the element to surround the element and make the derivative as shown by the following examples.
By default, text alignment is left-justified in formulas. To change text alignment, see “Adjusting formula alignment” on page 279. Formatting commands are not interpreted within text used in formulas. If you want to use formatting commands within formula text, then you must break up the text using double quotes in the Formula Editor.
Changing formula appearance Formula font size Current formula font size To change the font size used for a formula already inserted in Math or another LibreOffice module: 1) Click in the markup language in the Formula Editor. 2) Go to Format > Font size on the menu bar to open the Font Sizes dialog (Figure 271). 3) Select a different font size using the Base size spinner or type a new font size in the Base Size box. 4) Click OK to save your changes and close the dialog.
Formula fonts Current formula fonts To change the fonts used for the current formula in Math or another LibreOffice module: 1) Click in the markup language in the Formula Editor. 2) Go to Format > Fonts on the menu bar to open the Fonts dialog (Figure 272). 3) Select a new font for each the various options from the drop-down lists. 4) If the font you want to use does not appear in the drop-down list, click Modify and select the option from the context menu to open a fonts dialog.
Adjusting formula spacing Use the Spacing dialog (Figure 273) to determine the spacing between formula elements. The spacing is specified as a percentage in relation to the defined base size for font sizes. Current formula spacing To change the spacing used for the current formula in Math or another LibreOffice module: 1) Click in the markup language in the Formula Editor. 2) Go to Format > Spacing on the menu bar to open the Spacing dialog (Figure 273).
Note It is not possible to align formulas on a particular character and formula alignment does not apply to text elements. Text elements are always aligned left. Note Independent of using formula alignment given below, it is possible to align formulas using the commands alignl, alignc and alignr. These commands also work for text elements.
Changing formula color Character color Formula color for the characters used in a formula is changed by using the command color in the mark up language. This command only works on the formula element immediately after the color name. For example, entering the markup language color red ABC 5 times 4 gives the result ABC 5×4 . To change the color of the whole formula, you have to enclose the whole formula within brackets.
Using Writer, Calc, Draw, or Impress 1) Create a folder on your computer to contain your formulas and give the folder a memorable name, for example Formula Library. 2) Open a document using Writer, Calc, Draw, or Impress. 3) Go to Insert > Object > Formula on the menu bar to open the Formula Editor and create your formula. See “Formulas in LibreOffice documents” on page 266 for more information.
ABC 5×4 3) (1) Delete the sample formula and insert your formula as an object in the left column. See “Creating formulas” on page 267 for more information on inserting formulas. Alternatively, you can first insert your formula into the document, then carry out Steps 1 and 2 above, replacing the sample formula with your formula.
Anchoring formulas A formula is treated as an object within Writer and its default anchoring is As character within a paragraph when it is inserted into a document. To change the anchoring of a formula object: 1) Right-click on the selected formula object and select Anchor from the context menu. 2) Select a new anchoring option from the context sub-menu. The anchoring positions available are To page, To paragraph, To character, or As character.
To change the vertical alignment position of an individual formula object: 1) Right-click on the selected formula object and select Object from the context menu, or go to Format > Frame/Object to open the Object dialog (Figure 277). 2) Make sure the Type page is selected and select a new alignment position from the dropdown list in the Position section. The vertical alignment options available are Top, Bottom, Center or From bottom.
You can individually adjust the spacing for each formula object within your document as follows: 1) Create the formula in your Writer document. 2) Right-click on the selected formula object and select Object from the context menu, or go to Format > Frame/Object on the menu bar to open the Object dialog. 3) Click on the Wrap tab to open the Wrap page in the Object dialog (Figure 277). 4) In the Spacing section, enter the spacing value for Left, Right, Top and Bottom spacing.
Figure 278: Object dialog – Area page Borders 1) In the document, select the formula where you want to change the borders. 2) Right-click on the formula and select Object from the context menu, or go to Format > Frame/Object on the menu bar to open the object dialog. 3) Click on the Borders tab and select the options you want to use for the formula borders (Figure 279). 4) Click OK to save your changes and close the Object dialog.
2) Select the markup language. 3) Go to Insert > Object on the menu bar and select Formula, or click on the Formula icon on the Standard toolbar to create a formula from the selected markup language. Note If the Formula icon is not displayed on the Standard toolbar, then right-click in an empty area on the toolbar, select Visible Buttons from the context menu, then select Formula from the available options.
• To accurately re-position a formula object, use the various options in pages of the Position and Size dialog. • In Draw and Impress, you can be arrange, align, group, flip, convert, break, combine and edit points of formula objects. • You cannot change the text attributes of a formula object. The text used in a formula is set when you create the formula in the Formula Editor. • Formula object size is set by the formula font size when the formula is created in the Formula Editor.
Chapter 10 Printing, Exporting, E-mailing
Quick printing Click the Print File Directly icon ( for your computer. ) to send the entire document to the default printer defined Note 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. Go to Tools > Options > Load/Save > General and select the Load printer settings with the document option.
The different components of LibreOffice have different available print settings, as summarized in Table 6.
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 283). Figure 283: 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.
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. The details vary slightly in Writer, Calc, Draw and Impress, as described in this section. Writer Printing an individual page: 1) Choose File > Print from the Menu bar, or press Ctrl+P. 2) On the Print dialog, select the page to print.
Calc You can choose single sheets, multiple sheets, and selections of cells for printing. Figure 285: 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 Range and copies section of the Print dialog, choose the Selected sheets option. 4) Click OK. Printing a range of sheets: 1) In the spreadsheet, select the sheets to print.
Figure 286: Choosing what to print in Impress and Draw Printing an individual slide: 1) Choose File > Print from the Menu bar, or press Ctrl+P. 2) Select the slide to print. a) In the Range and copies section of the Print dialog, select the Slides option. b) Enter the number of the slide to print. 3) Click OK. Printing a range of slides: 1) Choose File > Print from the Menu bar, or press Ctrl+P. 2) Select the slides to print.
Printing a brochure In Writer, Impress, and Draw, you can print a document with two pages on each side of a sheet of paper, arranged so that when the printed pages are folded in half, the pages are in the correct order to form a booklet or brochure. Tip Plan your document so it will look good when printed half size; choose appropriate margins, font sizes, and so on. You may need to experiment. To print a brochure on a single-sided printer: 1) Choose File > Print, or press Ctrl+P.
7) 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. 8) On the Print dialog, in the Page sides section, select the Front sides / right pages option from the Include drop-down box. Click OK. Tip If your printer can print double-sided automatically, choose All pages.
Previewing pages/sheets before printing You can use the previewing options in Writer and Calc to view the document as it will be printed. Different viewing options are available. Writer The normal page view in Writer shows you what each page will look like when printed and you can edit the pages in that view. If you are designing a document to be printed double-sided, you may want to see what facing pages look like.
Quick export to PDF Click the Export Directly as PDF icon ( ) to export the entire document using the PDF settings you most recently selected on the PDF Options dialog (see below). You are asked to enter the file name and location for the PDF file, but you do not get a chance to choose a page range, the image compression, or other options. Controlling PDF content and quality For more control over the content and quality of the resulting PDF, use File > Export as PDF. The PDF Options dialog opens.
Range section • All: Exports the entire document to PDF. • Pages: To export a range of pages, use the format 3-6 (pages 3 to 6). To export single pages, use the format 7;9;11 (pages 7, 9 and 11). You can also export a combination of page ranges and single pages, by using a format like 3-6;8;10;12. • Selection: Exports all the selected material. Images section • Lossless compression: Images are stored without any loss of quality. Tends to make large files when used with photographs.
• Export comments: Exports comments as PDF notes. You may not want this! • Export automatically inserted blank pages: If selected, automatically inserted blank pages are exported to the PDF. This is best if you are printing the PDF double-sided. For example, books usually have chapters set to always start on an odd-numbered (right-hand) page. When the previous chapter ends on an odd page, LibreOffice inserts a blank page between the two odd pages. This option controls whether to export that blank page.
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. User interface options section • Hide menubar.
• Default mode: The PDF links will be handled as specified in your operating system. • Open with PDF reader application: Use the same application used to display the PDF document to open linked PDF documents. • Open with Internet browser: Use the default Internet browser to display linked PDF documents. Security page of PDF Options dialog PDF export includes options to encrypt the PDF (so it cannot be opened without a password) and apply some digital rights management (DRM) features.
Figure 295: Setting a password to encrypt a PDF Digital Signatures page of PDF Options dialog This page contains the options related to exporting to a digitally signed PDF. Digital signatures are used to ensure that the PDF was really created by the original author (that is, you), and that the document has not been modified since it was signed. The signed PDF export uses the keys and X.509 certificates already stored in your default key store location or on a smartcard.
When using a smartcard, enter the PIN here. Some smartcard software will prompt you for the PIN again before signing. • Location, Contact information, Reason: Optionally enter additional information about the digital signature that will be applied to the PDF. This information will be embedded in the appropriate PDF fields and will be visible to anyone viewing the PDF. Each or all of the three fields may be left blank. • Time Stamp Authority: Optionally select a Time Stamping Authority (TSA) URL.
E-mailing a document to several recipients To e-mail a document to several recipients, you can use the features in your e-mail program or you can use LibreOffice’s mail merge facilities to extract email addresses from an address book. You can use LibreOffice’s mail merge to send e-mail in two ways: • Use the Mail Merge Wizard to create the document and send it. See Chapter 11, Using Mail Merge, in the Writer Guide for details.
Figure 298: Selecting an address list 4) Back on the Select address list page, click Next. On the Create salutation page, deselect This document should contain a salutation. Figure 299: 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 e-mail settings choices. See Figure 300.
Figure 300: Sending a document as an email message 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.
2) If you have not saved the document since the last change, a message box appears. Click Yes to save the file. 3) The Digital Signatures dialog opens. Click Sign Document to add a public key to the document. 4) In the Select Certificate dialog, select your certificate and click OK to return to the Digital Signatures dialog. 5) The certificate used is displayed in the dialog with an icon next to its name. This icon indicates the status of the digital signature.
Chapter 11 Graphics, Gallery, 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 301: Insert Image 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.
Embedding linked images If you originally linked the images, you can easily embed one or more of them later if you wish. To do so: 1) Open the document in LibreOffice and choose Edit > Links. 2) The Edit Links dialog (Figure 302) shows all the linked files. In the Source file list, select the files you want to change from linked to embedded. 3) Click the Break Link button. 4) Save the document.
Inserting an image using a scanner If a scanner is connected to your computer, LibreOffice can call the scanning application and insert the scanned item into the LibreOffice document as an image. To start this procedure, place the cursor where you want the graphic to be inserted and choose Insert > Image > Scan > Select Source. Although this practice is quick and easy, it is unlikely to result in a high-quality image of the correct size.
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 cropping, resizing, modifying, filtering, and positioning graphics; wrapping text around graphics; and using graphics as backgrounds and watermarks.
By default, the Gallery is opened in the Sidebar. You can float the Gallery as you can other Sidebar panes; see Chapter 1, Introducing LibreOffice, for more information. 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 easily insert these graphics into a document later. 1) Right-click on the desired theme and select Properties from the context menu.
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 304). 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 To delete a theme from the Gallery: 1) Go to Tools > Gallery. 2) Select from the list of themes the theme you wish to delete.
The toolbar at the top of the dialog contains the following tools: • Apply button: click this button to apply the changes. • Load, Save, and Select icons. • Tools for drawing a hotspot shape: these tools work in exactly the same way as the corresponding tools in the Drawing toolbar. • Edit, Move, Insert, Delete Points: advanced editing tools to manipulate the shape of a polygon hotspot. Choose the Edit Points tool to activate the other tools.
Using LibreOffice’s drawing tools You can use LibreOffice’s drawing tools to create graphics such as simple diagrams using rectangles, circles, lines, text, and other predefined shapes. You can also group several drawing objects to make sure they maintain their relative position and proportion. You can place the drawing objects directly on a page in your document, or you can insert them into a frame.
Set or change properties for drawing objects To set the properties for a drawing object before you draw it: 1) On the Drawing toolbar (Figure 307), click the Select tool. 2) On the Drawing Object Properties toolbar (Figure 308), click on the icon for each property and select the value you want for that property. 3) For more control, or to define new attributes, you can click on the Area or Line icons on the toolbar to display detailed dialogs.
Using Fontwork With Fontwork you can create graphical text art objects to make your work more attractive. There are many different settings for text art objects (line, area, position, size, and more), so you have a large choice. Fontwork is available with each component of LibreOffice, but you will notice small differences in the way that each component displays it.
Editing a Fontwork object Now that the Fontwork object is created, you can edit some of its attributes. To do this, you can use the Fontwork toolbar, the Formatting toolbar, or menu options as described in this section. If the selected Fontwork object is a 3-D object, you can also use the 3D-Settings toolbar. Using the Fontwork toolbar Make sure that the Fontwork toolbar, shown in Figure 311, is visible. If you do not see it, go to View > Toolbars > Fontwork.
Fontwork Character Spacing: Changes the character spacing and kerning in the object. Select from the choices in the dropdown list. 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.
Area options Area icon: Opens a dialog with seven tabs: Area, Shadow, Transparency, Colors, Gradients, Hatching, Bitmaps. • Area tab: Choose from the predefined list a color, bitmap, gradient or hatching pattern to fill the selected object. • Shadow tab: Set the shadow properties of the selected object. • Transparency tab: Set the transparency properties of the selected object. • Colors tab: Modify the available colors or add new ones to appear on the Area tab.
Using the 3D-Settings toolbar If the selected Fontwork object is a 3-D object, you can also use the options on the 3D-Settings toolbar. You can also change a 2-D Fontwork object into a 3-D object (or change a 3-D object into a 2-D object) by clicking the Extrusion On/Off icon on the 3D-Settings toolbar. For more information, see the Draw Guide.
Chapter 12 Creating Web Pages Saving Documents as HTML Files
Introduction HTML capabilities in LibreOffice include saving and exporting existing documents in HTML format. 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) and create web pages using the Web Wizard included with LibreOffice.
Creating hyperlinks When you type text (such as a website addresses or URL) that can be used as a hyperlink, and then press the spacebar or the Enter key, LibreOffice automatically creates the hyperlink and applies formatting to the text (usually a color and underlining). If this does not happen, you can enable this feature by going to Tools > AutoCorrect Options > Options on the menu bar and selecting the URL Recognition option.
5) In the Navigator list, select the item that you want to insert as a hyperlink. 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. When using the Navigator to insert a hyperlink to an object such as a graphic, it is recommended to have the hyperlink show a useful name, for example 2009 Sales Graph.
The dialog changes according to the choice made for the hyperlink category in the left panel. A full description of all the choices and their interactions is beyond the scope of this chapter. Here is a summary of the most common choices. • For an Internet hyperlink, choose the type of hyperlink (Web, FTP, or Telnet), and enter the required web address (URL). • For a Mail and News hyperlink, specify whether it is a mail or news link, the address of the receiver and, for email, the subject.
Removing hyperlinks You can remove the link from hyperlink text and leave just the text by right-clicking on the link and selecting Remove Hyperlink from the context menu. You may then need to re-apply some formatting to match the text with the rest of your document. To erase the link text or button from the document completely, select it and press the Backspace or Delete key.
Figure 319: Documents page of Web Wizard dialog Figure 320: Main layout page of Web Wizard dialog Figure 321: Layout details page of Web Wizard dialog Chapter 12 Creating Web Pages | 333
Figure 322: Style page of Web Wizard dialog Figure 323: Web site information page of Web Wizard dialog Figure 324: Preview page of Web Wizard dialog 334 | Getting Started with LibreOffice 5.
Saving and exporting documents as web pages The easiest way to create HTML documents in LibreOffice is to start with an existing document. You can get a good idea of how it will appear as a web page by using View > Web Layout. However, web layout view does not show you which features will or will not be saved correctly in HTML format. Refer to “Relative and absolute hyperlinks” on page 328 on what to consider before creating a web page from a document.
Figure 325. Creating a series of web pages from one document Impress presentations Note Saving as web pages in HTML format does not retain animation and slide transitions. Impress presentations cannot be saved in HTML format, but have to 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.
3) On the Assign design page you can choose to create a new design and select or delete an existing design. Specify a New design or an Existing design and click Next>>. If you have not previously saved a web page design, the Existing Design choice is not available. – New design – creates a new design in the next pages of the Wizard. – Existing design – loads an existing design from the design list to use as a starting point for the steps that follow. The list box displays all existing designs.
what the majority of your viewers might be using. If you specify a high resolution, then a viewer with a medium-resolution monitor will have to scroll sideways to see the entire slide, which is probably not desirable. – Effects – specifies whether sound files defined as an effect for slide transitions are exported and whether any hidden slides are exported. For more information on the options available for this page of the HTML Export dialog, click Help to open the help pages.
8) Select button style to be used for the web pages from the designs available (Figure 330) and then click Next>>. If you do not select a button style, LibreOffice will create a text navigator. This page is not available if you have selected either Automatic or WebCast publication type. Figure 330: HTML Export dialog – button style page 9) Select color scheme to be used for the web pages (Figure 331) such as the color scheme and colors for text and background.
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. For example, if you simply save to your desktop and not in a specific folder, these separate HTML and graphics files will be placed all over your desktop. It is recommended to create a folder to hold all the files created for the web version of your presentation.
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 332: LibreOffice Basic Macros dialog Figure 333: LibreOffice Basic Macro Organizer dialog 11) Click the Compile icon on the Macro toolbar to compile the macro. 12) Place the cursor in the HelloMacro subroutine and click the Run BASIC icon on the Macro toolbar, or press the F5 key, to run the HelloMacro in the module. A small dialog will open with the word “Hello” displayed. If the cursor is not in a subroutine or function, a dialog will open; select the macro to run.
Figure 334: Integrated Debugging Environment dialog Listing 2: Module1 after adding the new macro. REM ***** BASIC ***** Sub HelloMacro Print "Hello" End Sub Sub Main End Sub Recording a macro If you have to repeatedly enter the same information, you can copy this information after it has been entered into your document for the first time, then paste the information into your document each time you want to use it.
1) Go to Tools > Macros > Record Macro on the main menu bar to start recording a macro. A small dialog is displayed indicating that LibreOffice is recording a macro. 2) Type the desired information or perform an appropriate series of operations. As an example, type your name. 3) Click Stop Recording on the small Recording dialog to stop recording and the LibreOffice Basic Macros dialog opens (Figure 332 on page 343). 4) Open the library container My Macros.
Viewing and editing macros To view and/or edit the macro that you created: 1) Go to Tools > Macros > Organize Macros > LibreOffice Basic to open the LibreOffice Basic Macros dialog. 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.
There are advanced topics that are beyond the scope of this user guide, but knowing about them might be of interest: • You can write a macro so that values can be passed to the subroutine. The values are called arguments. However, recorded macros in LibreOffice do not accept arguments. • 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.
dim args1(0) as new com.sun.star.beans.PropertyValue Declares an array of properties. Each property has a name and a value. In other words, it is a name/value pair. The created array has one property at index zero. args1(0).Name = "Text" args1(0).Value = "Your name" Gives the property the name “Text” and the value “Your name”, which is the text that is inserted when the macro is run. dispatcher.executeDispatch(document, ".uno:InsertText", "", 0, args1()) This is where the magic happens.
DONTKNOW The font weight is not specified/known. THIN specifies a 50% font weight. ULTRALIGHT specifies a 60% font weight. LIGHT specifies a 75% font weight. SEMILIGHT specifies a 90% font weight. NORMAL specifies a normal font weight. SEMIBOLD specifies a 110% font weight. BOLD specifies a 150% font weight. ULTRABOLD specifies a 175% font weight. BLACK specifies a 200% font weight.
Listing 4: Copying numeric value to start of the column sub CopyNumToCol1 rem ------------------------------------------------------------rem define variables dim document as object dim dispatcher as object rem ------------------------------------------------------------rem get access to the document document = ThisComponent.CurrentController.Frame dispatcher = createUnoService("com.sun.star.frame.DispatchHelper") rem (3) Press Ctrl+Right Arrow to move the cursor to the start of “specifies”. dispatcher.
rem (12) Press Home to move the cursor to the start of the line. dispatcher.executeDispatch(document, ".uno:GoToStartOfLine", "", 0, Array()) rem (13) Press Ctrl+V to paste the selected number to the start of the line. dispatcher.executeDispatch(document, ".uno:Paste", "", 0, Array()) rem (14) Press Backspace to remove the extra space. dispatcher.executeDispatch(document, ".uno:SwBackspace", "", 0, Array()) rem (15) Press Tab to insert a tab between the number and the name. dim args17(0) as new com.sun.
Macro recorder failures Sometimes the macro recorder has a failure and understanding LibreOffice internal workings helps to understand how and why the macro recorder sometimes fails. The primary offender is related to the dispatch framework and its relationship to the macro recorder. Dispatch framework The purpose of the dispatch framework is to provide uniform access to components (documents) for commands that usually correspond to menu items.
LibreOffice objects rather than generating dispatches. This can be very useful for learning the object model and can be downloaded directly from the web site: http://www.paolo-mantovani.org/downloads/DispatchToApiRecorder/ Macro organization In LibreOffice, macros are grouped in modules, modules are grouped in libraries, and libraries are grouped in library containers. A library is usually used as a major grouping for either an entire category of macros, or for an entire application.
Caution LibreOffice allows you to import libraries into a library container, but it will not allow you to overwrite the library named Standard. Therefore, if you store your macros in the Standard library, you cannot import them into another library container. Just as it makes good sense to give your libraries meaningful names, it is prudent to use meaningful names for your modules. By default, LibreOffice uses names such as Module1, Module2 and so on.
Figure 338: Navigating to a macro library Tip On a computer operating Linux, the LibreOffice specific files are stored in the home directory of a user in a directory whose name begins with a period. Directories and files with names beginning with a period may be hidden and not shown in a normal selection dialog. If using LibreOffice dialogs, rather than the operating system specific dialogs, type the name of the desired directory in the Name field.
b) Select Replace existing libraries if the library you want to import has the same name and you want to replace the existing library. c) Select Insert as reference if you want to use the library as reference, but not import the library into your document. When a library is used as a reference, it remains in its current location and is read only. 5) Click OK to import the macro library you selected. Downloading macros to import Macros are available for download.
Toolbars, menu items, and keyboard shortcuts To add a menu item, keyboard shortcut, or toolbar icon that calls a macro, use the Customize dialog (Figure 340). The Customize dialog contains pages to configure menus, keyboard shortcuts, toolbars, and events. To open this dialog, go to Tools > Customize on the main menu bar or rightclick in an empty space on a toolbar and select Customize Toolbar from the context menu. Complete coverage of the Customize dialog is beyond the scope of this chapter.
1) Go to Tools > Customize on the main menu bar to open the Customize dialog and select the Events tab (Figure 341). The events in the Customize dialog are related to the entire application and specific documents. 2) In Save In, select LibreOffice, or a specific document from the drop down menu to save your event. 3) A common use is to assign the Open Document event to call a specific macro. The macro then performs certain setup tasks for the document.
• New components and functionality, which normally include some level of User Interface (UI) integration such as new menus or toolbars • Pivot Tables that are used directly in Calc • Chart Add-Ins with new chart types • Linguistic components such as spelling checkers • Document templates and images Although individual extensions can be found in several places, there is currently an extension repository at: http://extensions.libreoffice.org/ and some documentation at http://libreplanet.
Included material Many excellent macros are included with LibreOffice. Use Tools > Macros > Organize Macros > LibreOffice Basic to open the Macro dialog. Expand the Tools library in the LibreOffice library container. Inspect the Debug module—some good examples include WritedbgInfo(document) and printdbgInfo(sheet). Online resources The following links and references contain information regarding macro programming: http://ask.libreoffice.
Chapter 14 Customizing LibreOffice
Introduction This chapter describes some common customizations that you may wish to carry out. 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.
4) In the section LibreOffice [name of the program (example: Writer)] Menus, select from the Menu drop-down list the menu that you want to customize. The list includes all the main menus as well as submenus (menus that are contained under another menu). For 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.
To move a menu (such as File), choose Menu > Move. A dialog similar to the one shown in Figure 343 (but without the Menu name box) opens. Use the up and down arrow buttons to move the menu into the required 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.
On the Add Commands dialog (Figure 344), select a category and then the command, and click Add. The dialog remains open, so you can select several commands. When you have finished adding commands, click Close. Back on the Customize dialog, you can use the up and down arrow buttons to arrange the commands in your preferred sequence. 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.
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 346).
Figure 347: Setting up LibreOffice for sending faxes Your toolbar now has a new icon to send the current document as a fax. Figure 348: 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 349: 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 349).
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.
To install directly from a saved *.oxt file on your system, double-click the file. To install from a suitably enabled web browser, select the hyperlink, and then select to Open the file. In both cases, after the Extension Manager opens, a warning dialog opens for you to verify the installation and then continue. The file is installed as a “user only” file in a multi-user system. To install directly from Extension Manager: 1) In LibreOffice, select Tools > Extension Manager from the menu bar.
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. Note 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 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 an icon for creating a draw object. A draw object will be placed into the middle of the view, with a predefined size. 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.
Controlling macros Shortcut Keys Result Ctrl+* (multiplication sign: on number pad only) Runs a macro field. (See Chapter 9 for more about macros.) Shift+Ctrl+Q Stops a running macro. Managing documents Shortcut Keys Result Ctrl+F4 or Alt+F4 Closes the current document. Closes LibreOffice when the last open document is closed. Ctrl+O Launches the Open dialog to open a document. Ctrl+S Saves the current document.
Shortcut Keys Result 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. Ctrl+Shift+I Shows or hides the cursor in read-only text. Selecting rows and columns in a database table opened by F4 Shortcut keys Result Spacebar Toggles row selection, except when the row is in edit mode. Ctrl+Spacebar Toggles row selection. Shift+Spacebar Selects the current column.
Shortcut keys Result Alt+Up/Down/Left/Right Arrow Moves the selected Drawing Object one pixel (in Selection Mode). Re-sizes a Drawing Object (in Handle Selection Mode). Rotates a Drawing Object (in Rotation Mode). Opens the properties dialog for a Drawing Object. Activates the Point Selection mode for the selected drawing object. Spacebar Select a point of a drawing object (in Point Selection mode) / Cancel selection. The selected point blinks once per second.
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 Mozilla Public License (MPL) 2.0. See https://www.libreoffice.org/about-us/licenses/ What is “open source”? The four essential rights of open-source software are embodied within the Free Software Foundation’s General Public License (GPL): • The right to use the software for any purpose. • Freedom to redistribute the software for free or for a fee. • Access to the complete source code of the program (that is, the “blueprints”).
For a full list of file formats that LibreOffice can read and write, see https://en.wikipedia.org/wiki/LibreOffice#Supported_file_formats OpenDocument filename extensions The most common filename extensions used for OpenDocument documents are: *.odt for word processing (text) documents *.ods for spreadsheets *.odp for presentations *.odb for databases *.odg for graphics (vector drawings) *.
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 (.rtf) Text CSV (.csv and .txt) StarCalc formats (.sdc and .vor) dBASE (.dbf) SYLK (.slk) Unified Office Format spreadsheet (.uos, .uof) HTML Document (.htm and .html files, including Web page queries) Pocket Excel (pxl) Quattro Pro 6.0 (.wb2) Apple Numbers 2 (.numbers) ...
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 an LibreOffice Math object.
Saving presentations In addition to OpenDocument formats (.odp, .otp, .fodp, and .odg), Impress can save in these formats: Microsoft PowerPoint 97–2003 (.ppt) Microsoft PowerPoint 97–2003 Template (.pot) Microsoft PowerPoint 97–2003 AutoPlay (.pps) Microsoft PowerPoint 2007–2013 XML (.pptx, .potm) Microsoft PowerPoint 2007–2013 XML AutoPlay (.ppsx) Office Open XML Presentation (.pptx, .potm, .ppsx) Unified Office Format presentation (.uop) Impress can also export to MacroMedia Flash (.
Index This book has no index. We apologize, but no one has volunteered to update it. Our choices were to have no index, or an incomplete index, or to delay publication for so long that the book would be very out of date.
