Getting Started Guide 7.5
This document is Copyright © 2023 by the LibreOffice Documentation Team. Contributors are listed below. This document maybe distributed and/or modified under the terms of either the GNU General Public License (https://www.gnu.org/licenses/gpl.html), version 3 or later, or the Creative Commons Attribution License (https://creativecommons.org/licenses/by/4.0/), version 4.0 or later. All trademarks within this guide belong to their legitimate owners.
Contributors for this edition:
Peter Schofield
Olivier Hallot
Contributors for previous editions:
Amanda Labby
Andrew Jensen
Cathy Crumbley
Dan Lewis
Dave Barton
Jean Hollis Weber
Jorge Rodriguez
Kees Kriek
Leo Moons
Lera Goncaruk
Olivier Hallot
Paul Figueiredo
Peter Schofield
Simon Quigley
Steve Fanning
Valerii Goncharuk
Please direct any comments, or suggestions, about this document to the Documentation Team Forum at https://community.documentfoundation.org/c/documentation/loguides/ (registration is required), or send an email to: loguides@community.documentfoundation.org.
Note
Everything sent to a forum, including email addresses and any other personal information that is written in the message, is publicly archived and cannot be deleted. Emails sent to the Forum are moderated.
Published July 2023. Based on LibreOffice 7.5 Community.
Other versions of LibreOffice may differ in appearance and functionality.
Anyone who wants to quickly acquire knowledge on LibreOffice and is new to office software, or may be familiar with another office suite, will find this Getting Started Guide very useful.
LibreOffice is an open-source office productivity software suite containing capabilities for word processing, spreadsheets, presentations, graphics, databases, and formula editing.
This user guide introduces the main modules of LibreOffice.
Writer (word processing)
Calc (spreadsheets)
Impress (presentations)
Draw (vector graphics)
Base (database)
Math (equation editor)
It also covers some of the features common to all modules, including setup and customization, styles and templates, macro recording, and printing. For more detail, see the user guides for the individual modules.
LibreOffice is a freely available, fully-featured, open source office productivity suite that is compatible with other major office suites and is available on a variety of platforms. The native file format used is Open Document Format (ODF). However, LibreOffice can also open and save documents in many other formats, including those used by several versions of Microsoft Office. For more information, see Appendix B, Open Source, Open Standards, OpenDocument.
Writer is a feature-rich tool for creating letters, books, reports, newsletters, brochures, and other documents. Graphics and objects from other LibreOffice modules can be inserted into Writer documents. Writer can export files to HTML, XHTML, XML, Portable Document Format (PDF), and EPUB. Also, Writer can save files in many formats, including several versions of Microsoft Word files and connect to the email application being used.
Calc has all of the advanced analysis, charting, and decision making features expected from a high-end spreadsheet. It includes over 500 functions for financial, statistical, and mathematical operations, among others. The Scenario Manager provides “what if” analysis. Calc generates 2D and 3D charts, which can be integrated into other LibreOffice documents. Also, Microsoft Excel workbooks can be opened and worked on, then saved in Excel format. Calc can also export spreadsheets in several formats, including, for example, Comma Separated Value (CSV), Adobe PDF and HTML formats.
Impress provides all the common multimedia presentation tools, such as special effects, animation, and drawing tools. It is integrated with the advanced graphics capabilities of LibreOffice Draw and Math modules. Slideshows can be further enhanced using Fontwork special effects text, as well as sound and video clips. Impress can open, edit, and save Microsoft PowerPoint presentations and save presentations in numerous graphics formats.
Draw is a vector drawing tool that can produce everything from simple diagrams, flowcharts, or 3D artwork. Its Smart Connectors feature allows definition connection points. Draw creates drawings for use in any of the LibreOffice modules, and clip art can be created and added to the Gallery. Draw can import graphics from many common formats and save them in many formats, including PNG, GIF, JPEG, BMP, TIFF, SVG, HTML and PDF.
Base provides tools for day-to-day database work within a simple interface. Base can create and edit forms, reports, queries, tables, views, and relations, so that managing a relational database is much the same as in other popular database applications. Base provides many new features, such as the ability to analyze and edit relationships from a diagram view. Base incorporates two relational database engines, HSQLDB and Firebird. It can also use PostgreSQL, dBASE, Microsoft Access, MySQL, Oracle, or any ODBC compliant or JDBC compliant database. Base also provides support for a subset of ANSI-92 SQL.
Math is a formula, or equation editor. Math can create complex equations that include symbols or characters not available in standard font sets. While Math is most commonly used to create formulas in other documents, such as Writer and Impress files, Math can also work as a standalone tool. Formulas can be saved in the standard Mathematical Markup Language (MathML) format for inclusion in web pages and other documents not created with LibreOffice.
The following explains some of the advantages of LibreOffice has over other office suites:
No licensing fees
Open source
Cross-platform
Extensive language support
Consistent user interface
Integration
Granularity
File compatibility
No vendor lock-in
All LO users have a voice
Read more about LibreOffice and The Document Foundation on their websites at https://www.libreoffice.org/ and https://www.documentfoundation.org/.
LibreOffice 7.5 requires one of the following operating systems:
Linux x64 (deb) and Linux x64 (rpm)
Mac OS X (Aarch64/Apple Silicon)
macOS x86_64 (10.14 (Mojave or higher)
Windows x86_64 (Windows 7 or newer required)
For a detailed list of requirements and operating systems supported, see the LibreOffice website, https://www.libreoffice.org/get-help/system-requirements/.
Some LibreOffice features (wizards and the HSQLDB database engine) require that the Java Runtime Environment (JRE) or, for macOS, the Java Development Kit (JDK) is installed on a computer. If Java is not going to be used, nearly all of the LibreOffice features can still be used.
Java is available at no cost. More information and download links to the appropriate edition for your operating system can be found at: https://java.com/en/download/manual.jsp.
For macOS, the Oracle Java Development Kit (JDK) has to be installed, not just the Java Runtime Environment (JRE). Download links can be found at: https://www.oracle.com/java/technologies/downloads/.
If LibreOffice features that require Java are to be used, it is important that the correct 32-bit or 64-bit edition matches the installed version of LibreOffice. See the Advanced Options in Chapter 12, Configuring LibreOffice.
Versions of LibreOffice for Windows, Linux, and macOS are freely available and can be downloaded from https://www.libreoffice.org/download. Linux users will also find LibreOffice included free in many of the latest distributions.
Linux, Vanilla, and other versions may differ in a few features from the descriptions in this user guide. Also, LibreOffice is included in many of the latest Linux distributions, for example Ubuntu. Portable and other versions of LibreOffice are listed on the download page. LibreOffice is also available in the Microsoft Store and Apple Mac App Store at a low and attractive price. The profits from the sale of LibreOffice are invested to support the development of the LibreOffice project.
Information on installing LibreOffice on the various supported operating systems can be found at this web page: https://www.libreoffice.org/get-help/install-howto/. When LibreOffice is acquired through official app stores, follow the installation instructions provided by the store.
After installation, to change the default settings (options) in LibreOffice to suit working requirements and preferences, go to Tools > Options on the Menu bar (LibreOffice > Preferences in macOS).. For more information, see Chapter 12, Configuring LibreOffice.
Tip
Some settings are intended for power users and programmers. If it is difficult to understand what an option does, LibreOffice recommends leaving the option on its default setting unless instructions in this user guide recommend changing the setting.
Functionality can be added to LibreOffice with extensions and add-ons. Several extensions are installed with the program and other extensions from the official extensions repository, https://extensions.libreoffice.org/ or from other sources. See Chapter 13, Customizing LibreOffice, for more information on installing extensions and add-ons.
This user guide, the LibreOffice module user guides, Help system, and user support systems assume that users are familiar with computers and basic functions such as starting a program, opening and saving files.
LibreOffice comes with an extensive Help system and this can be used as the first line of support. Windows and Linux users can choose to download and install the offline Help for use when not connected to the Internet. Offline Help is installed with the MacOS version of LibreOffice.
To display the LibreOffice Help, press F1 or go to Help > LibreOffice Help on the Menu bar. If the offline help is not installed on a computer, but connected to the Internet, a dialog opens giving the option to Read Help Online. Select this option and the default web browser opens at the LibreOffice online help pages in the LibreOffice website.
The Help menu also includes links to other LibreOffice information and support resources. The options marked by a ‡ sign in the list below are only accessible if the computer is connected to the Internet.
What's This?
User Guides
Show Tip of the Day
Search Commands
Get Help Online
Send Feedback
Restart in Safe Mode
Get Involved
Donate to LibreOffice
License Information
Check for Updates
About LibreOffice
The LibreOffice community not only develops software, but provides free, volunteer-based support. See Table 1 and the web page https://www.libreoffice.org/get-help/. For comprehensive online support from the community, look at mailing lists and the Ask LibreOffice website, https://ask.libreoffice.org/en/questions/. Other user websites also offer free tips and tutorials.
Table 1: Free support for LibreOffice users
|
Free LibreOffice support |
|
|
FAQs |
Answers to frequently asked questions |
|
Mailing lists |
Free community support is provided by a network of experienced users |
|
Questions & Answers and |
Free community assistance is provided in a Question & Answer formatted web service. Search similar topics or open a new one in https://ask.libreoffice.org/en/questions The service is available in several other languages; just replace /en/ with de, es, fr, ja, ko, nl, pt, tr, and so on in the web address above. |
|
Native language support |
The LibreOffice website in various languages Mailing lists for native languages Information about social networking |
|
Accessibility options |
Information about available accessibility options. https://www.libreoffice.org/get-help/accessibility/ |
|
OpenOffice Forum |
Another forum that provides support for LibreOffice, among other open source office suites. https://forum.openoffice.org/en/forum/ |
Support and training is available through service contracts from a vendor or consulting firm specializing in LibreOffice. For information about certified professional support, see The Document Foundation website: https://www.documentfoundation.org/gethelp/support/.
For schools, educational and research institutions, and large organizations, see https://www.libreoffice.org/download/libreoffice-in-business/.
Figure 1: Options LibreOffice General dialog
LibreOffice runs on Windows, Linux, and macOS operating systems, each of which has several versions and can be customized by users (fonts, colors, themes, window managers). The illustrations in this guide were taken from a variety of computers and operating systems. Therefore, some illustrations will not look exactly like what is seen on a computer display.
Also, some of the dialogs may differ because of the settings selected in LibreOffice. Either use dialogs from the computer system (default), or dialogs provided by LibreOffice.
To change to using LibreOffice dialogs:
1) On Linux and Windows operating systems, go to Tools > Options > LibreOffice > General on the Menu bar to open the dialog for general options.
2) On a Mac operating system, go to LibreOffice > Preferences > LibreOffice > General on the Menu bar to open the dialog for general options.
3) Select Use LibreOffice dialogs in Open/Save dialogs to display the LibreOffice dialogs on a computer display, as shown in Figure 1.
4) Click OK to save the settings and close the dialog.
Figure 2: Options LibreOffice View dialog
The LibreOffice community has created icons for several icon sets, including Breeze, Colibre, Elementary, and Sifr. Each user can select a preferred set of fonts to use. The icons used to illustrate some of the many tools available in LibreOffice may differ from the ones used in this guide. The icons in this user guide have been taken from a LibreOffice installation that has been set to display the Colibre set of icons.
Change the icon set used in a LibreOffice installation as follows:
1) On Linux and Windows operating systems, go to Tools > Options > LibreOffice > View on the Menu bar to open the dialog for view options.
2) On a Mac operating system, go to LibreOffice > Preferences > LibreOffice > View on the Menu bar to open the dialog for view options.
3) In Icon Style, select a font from the options available in the drop-down list as shown in Figure 2.
4) In Icon Size, select the required size from the drop-down lists for Toolbar, Notebookbar and Sidebar, as shown in Figure 2.
5) Click OK to save the settings and close the dialog.
Notes
Some Linux operating systems, for example Ubuntu, include LibreOffice as part of the installation and may not include the required icon set. This icon set can be downloaded from the software repository for the Linux operating system being used.
Some of the previously included icon sets are now available only as extensions; see https://extensions.libreoffice.org/?Tags%5B%5D=49 or search for specific ones. For example, the People Gallery is available from https://extensions.libreoffice.org/en/extensions/show/people-gallery
Some keystrokes and menu items are different on macOS from those used in Windows and Linux. Table 2 below gives some common substitutions for the instructions in this user guide. For a more detailed list, see the application help.
Table 2: Example of macOS keyboard shortcuts
|
Windows or Linux |
macOS equivalent |
Effect |
|
Tools > Options on Menu bar |
LibreOffice > Preferences on Menu bar |
Access to setup options |
|
Right-click |
Ctrl+click and/or right-click depending on computer setup |
Opens a context menu |
|
Ctrl or Control |
⌘ and/or Cmd or Command, depending on keyboard |
|
|
Alt |
⌥ and/or Alt or Option depending on keyboard |
Used with other keys |
The terms used in LibreOffice for most parts of the user interface (the parts of the program seen and used, in contrast to the behind-the-scenes code that actually makes it work) are the same as for most other programs.
A dialog is a special type of window. Its purpose is to inform, or request input, or both. The technical names for common controls are shown in Figure 3. In most cases, these technical terms are not used in this user guide, but are useful to know because the Help and other sources of information often use these terms.
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 adjacent text box, 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. When you close the dialog after use (usually, clicking OK or another button saves your changes and closes the dialog), then you can again work with the document.
Some dialogs can be left open as you work, so you can switch back and forth between the dialog and the document. An example of this type is the Find & Replace dialog.
Figure 3: Dialog showing an example of common controls
This user guide was written by volunteers from the LibreOffice community. Profits from sales of the printed edition will be used to benefit the community.
How is LibreOffice licensed?
Can LibreOffice be distributed to anyone?
Can LibreOffice be sold?
Can LibreOffice be used in a business?
How many computers can LibreOffice be installed on?
Is LibreOffice available in different languages?
How can LibreOffice be freely available?
Can the programming code from LibreOffice be used when developing a software application?
Why is Java required to run LibreOffice? Is it written in Java?
Note
If the LibreOffice features that require Java are to be used, it is important that the correct 32-bit or 64-bit edition matches the installed version of LibreOffice. If Java is not to be used, nearly all of the LibreOffice features can still be used.
How can users contribute to LibreOffice?
Can the PDF copy of this user guide be distributed, or printed and copies sold?
The LibreOffice Release Notes are available at this link https://wiki.documentfoundation.org/ReleaseNotes/7.5.
Also at this link, the release notes for earlier versions of LibreOffice are located giving more information on the features that are included in LibreOffice.
Noticeable improvements or enhancements to this version include the following:
A new set of application and mime types icons as shown in Figure 4. The icon groups are, from left to right, standard (apps), standard (mime types), macOS specific.
Support for dark and high contrast operating system themes on Windows, macOS and Linux is improved.
The Start Center can now filter recent documents by type.
Figure 4: New LibreOffice icons
