LibreOffice



LibreOffice was reviewed within my company as a possible replacement to Office 365 (namely the desktop applications Word, Excel, and PowerPoint). Whereas LibreOffice is an excellent program, ranking well above applications like Google Docs, it still isn't exactly a pop-in replacement for Microsoft Office. Questions and answers for LibreOffice. Please enter your user name, then sign in (or select another login method above) or enter your user name and password. LibreOffice Math Whereas Draw is fairly mainstream, Math is a niche program that may thrill 2 percent of potential LibreOffice users. The title Math makes it sound like a bargain Wolfram.

05 Aug 2020

LibreOffice 7.0: the new major release of the best FOSS office suite ever is available on all OSes and platforms, and provides significant new features

Berlin, August 5, 2020 – The LibreOffice Project announces the availability of LibreOffice 7.0, a new major release providing significant new features: support for OpenDocument Format (ODF) 1.3; Skia graphics engine and Vulkan GPU-based acceleration for better performance; and carefully improved compatibility with DOCX, XLSX and PPTX files.

  • Support for ODF 1.3. OpenDocument, LibreOffice’s native open and standardised format for office documents, has recently been updated to version 1.3 as an OASIS Technical Committee Specification. The most important new features are digital signatures for documents and OpenPGP-based encryption of XML documents, with improvements in areas such as change tracking, and additional details in the description of elements in first pages, text, numbers and charts. The development of ODF 1.3 features has been funded by donations to The Document Foundation.
  • Skia graphics engine and Vulkan GPU-based acceleration. The Skia graphics engine has been implemented thanks to sponsorship by AMD, and is now the default on Windows, for faster performance. Skia is an open source 2D graphics library which provides common APIs that work across a variety of hardware and software platforms, and can be used for drawing text, shapes and images. Vulkan is a new-generation graphics and compute API with high-efficiency and cross-platform access to modern GPUs.
  • Better compatibility with DOCX, XLSX and PPTX files. DOCX now saves in native 2013/2016/2019 mode, instead of 2007 compatibility mode, to improve interoperability with multiple versions of MS Office, based on the same Microsoft approach. Export to XLSX files with sheet names longer than 31 characters is now possible, along with exporting checkboxes in XLSX. The “invalid content error” message was resolved when opening exported XLSX files with shapes. Finally, there were improvements to the PPTX import/export filter.
    LibreOffice offers the highest level of compatibility in the office suite arena, starting from native support for the OpenDocument Format (ODF) – with better security and interoperability features over proprietary formats – to almost perfect support for DOCX, XLSX and PPTX files. In addition, LibreOffice includes filters for many legacy document formats, and as such is the best interoperability tool in the market.

Summary of Other New Features [1]

GENERAL

  • New icon theme, the default on macOS: Sukapura
  • New shapes galleries: arrows, diagrams, icons and more…
  • Glow and soft edge effects for objects

WRITER

  • Navigator is easier to use, with more context menus
  • Semi-transparent text is now supported
  • Bookmarks can now be displayed in-line in text
  • Padded numbering in lists, for consistency
  • Better handling of quotation marks and apostrophes
LibreOffice

CALC

  • New functions for non-volatile random number generation
  • Keyboard shortcut added for autosum

IMPRESS & DRAW

  • Semi-transparent text is supported here too
  • Subscripts now return to the default of 8%
  • PDFs larger than 500 cm can now be generated

LibreOffice Technology

LibreOffice 7.0’s new features have been developed by a large community of code contributors: 74% of commits are from developers employed by companies sitting in the Advisory Board, such as Collabora, Red Hat and CIB, plus several other organizations, and 26% are from individual volunteers.

In addition, there is a global community of individual volunteers taking care of other fundamental activities, such as quality assurance, software localization, user interface design and user experience, editing of help content and documentation, along with free software and open document standards advocacy.

A video summarizing the top new features in LibreOffice 7.0 is available on YouTube: https://www.youtube.com/watch?v=XusjjbBm81s and also on PeerTube: https://tdf.io/lo70peertube

Products based on LibreOffice Technology are available for all major desktop operating systems (Windows, macOS, Linux and ChromeOS), for the cloud and for mobile platforms. They are released by The Document Foundation, and by ecosystem companies contributing to software development.

LibreOffice for End Users

LibreOffice 7.0 represents the bleeding edge in term of features for open source office suites, and as such is targeted at technology enthusiasts, early adopters and power users. The Document Foundation does not provide any technical support for users, although they can get help from other users on mailing lists and the Ask LibreOffice website: https://ask.libreoffice.org

For users whose main objective is personal productivity and therefore prefer a release that has undergone more testing and bug fixing over the new features, The Document Foundation maintains the LibreOffice 6.4 family, which includes some months of back-ported fixes. The current version is LibreOffice 6.4.5.

Libreoffice 6.4

LibreOffice in Business

For enterprise-class deployments, TDF strongly recommends sourcing LibreOffice from one of the ecosystem partners, to get long-term supported releases, dedicated assistance, custom new features and other benefits, including SLA (Service Level Agreements): https://www.libreoffice.org/download/libreoffice-in-business/. The work done by ecosystem partners is an integral part of LibreOffice Technology.

For migrations from proprietary office suites and training, professional support should be sourced from certified professionals who provide value-added services which extend the reach of the community to the corporate world, and offer CIOs and IT managers a solution in line with proprietary offerings. Reference page: https://www.libreoffice.org/get-help/professional-support/.

In fact, LibreOffice – thanks to its mature codebase, rich feature set, strong support for open standards, excellent compatibility and long-term support options from certified partners – represents the ideal solution for businesses that want to regain control of their data and free themselves from vendor lock-in.

Availability of LibreOffice 7.0

LibreOffice 7.0 is immediately available from the following link: https://www.libreoffice.org/download/. Minimum requirements for proprietary operating systems are Microsoft Windows 7 SP1 and Apple macOS 10.12. Builds of the latest LibreOffice Online source code are available as Docker images from TDF: https://hub.docker.com/r/libreoffice/online/

LibreOffice Technology based products for Android and iOS are listed here: https://www.libreoffice.org/download/android-and-ios/, while for App Stores and ChromeOS are listed here: https://www.libreoffice.org/download/libreoffice-from-microsoft-and-mac-app-stores/

LibreOffice users, free software advocates and community members can support The Document Foundation with a donation at https://www.libreoffice.org/donate

LibreOffice 7.0 is built with document conversion libraries from the Document Liberation Project: https://www.documentliberation.org

[1] A more comprehensive list of LibreOffice 7.0 new features is available on the Release Notes wiki page: https://wiki.documentfoundation.org/ReleaseNotes/7.0

Press Kit

The press kit with press release and high-resolution images and screenshots, is available here: https://tdf.io/lo70presskit

Related

If you're looking for a Microsoft Office alternative, don’t want a monthly subscription, or prefer to download your software, LibreOffice is an excellent choice.

Libreoffice.org download free

As open-source software, LibreOffice is continually updated with new improvements and doesn’t need an internet connection to run. In this LibreOffice review, you’ll learn how the software functions and how it differs from other office suites.

Who is LibreOffice for?

LibreOffice

Inside + limbo for mac. LibreOffice is for individual users and small businesses who want free, downloadable tools, without worrying that their software will become obsolete and unsupported in years to come. Although some large enterprises use LibreOffice, the lack of support is an issue.

Companies with developers may prefer LibreOffice because, by the nature of open-source software, you can configure the code to fit your needs. Moreover, several partners sell enterprise versions with customer service and service level agreements (SLA). You may prefer LibreOffice if:

  • Your team uses various operating systems, such as Linux, macOS, or Windows
  • Internet access is spotty or unavailable at remote business locations
  • You want software installed on your computer without worrying about it going extinct
  • Mobile apps and online accessibility aren’t important to you
  • You need extensive language support in your documents
  • You’re familiar with Microsoft Word and are looking for a free version

There is a cloud-based version of LibreOffice available through third parties under names such as Collabora Office and LibreOffice Online powered by CIB. However, the web-based version doesn’t include a file storage system and isn’t supported by The Document Foundation, so this LibreOffice review doesn’t include information about the cloud version.

LibreOffice also gets updated frequently. For example, LibreOffice 5.0 came out in 2015, version 6.0 appeared in 2017, and 7.0 was introduced in 2020.

LibreOffice’s features

Like other Zoho Office Suite, LibreOffice comes with the main tools you need to create documents, spreadsheets, and presentations. It also provides a database comparable to Microsoft Access.

LibreOffice

However, it doesn’t offer any communication or collaboration tools. Nor does it offer cloud storage, so you can use document management best practices using any existing file solution.

Description Use the Microsoft Remote Desktop app to connect to a remote PC or virtual apps and desktops made available by your admin. The app helps you be productive no matter where you are. Getting Started Configure your PC for remote access first. You can control a remote PC by using a Microsoft Remote Desktop client. The client can run on almost any device, including on your mobile smartphone. The client gives you the same powers you would have if you could reach the PC's keyboard. Through the client, you can. In Remote Desktop Connection, type the name of the PC you want to connect to (from Step 1), and then select Connect. On your Windows, Android, or iOS device: Open the Remote Desktop app (available for free from Microsoft Store, Google Play, and the Mac App Store), and add the name of the PC that you want to connect to (from Step 1). You can use the Remote Desktop client for Windows Desktop to access Windows apps and desktops remotely from a different Windows device. You can use Remote Desktop to connect to and control your PC from a remote device by using a Microsoft Remote Desktop client (available for Windows, iOS, macOS and Android). Microsoft remote desk.

The main features of LibreOffice are:

  • Writer: An easy-to-use word processing application
  • Calc: A spreadsheet program similar to Microsoft Excel or Google Sheets.
  • Impress: A presentation platform to create slideshows
  • Draw: An integrated graphic editing program
  • Base: A database program that integrates with all LibreOffice applications
  • Math: A formula editor used to create intricate formulas for use in all LibreOffice apps
  • Charts: A standalone tool to create and edit charts and graphs
  • Extensions: Hundreds of add-on tools to suit nearly any business need

LibreOffice Writer

LibreOffice Writer is a word processing tool offering standard features found in other similar programs, including an autocorrect dictionary and autocomplete feature.

Writer is compatible with many document formats. However, there may be formatting errors or non-compatible fonts when opening a Word document in LibreOffice, which can pose a problem if you work with clients or team members who use Microsoft Office.

In contrast, if you work with international clients and teams using open document formats, you’ll appreciate the native support for this file type.

LibreOffice Writer also offers pre-built templates for documents such as faxes, business cards, meeting minutes, or conference agendas.

Although the interface is similar to Microsoft Word, completing some tasks, like changing your header style, takes more clicks than with other word processing programs. However, there are some neat built-in features and extensions, such as:

  • An option to export documents as an eBook, which isn’t available without a third-party integration on Microsoft Word
  • A redaction tool to hide sensitive data either one word at a time or automatically by selecting words or phrases to sanitize
  • An out-of-the-box grammar checker in four languages, including English, Brazilian, Hungarian, and Russian
  • Additional extensions for grammar checkers in more than 30 languages, a quick response (QR) code generator, and an emoji toolbar

LibreOffice Writer uses a familiar interface and toolbars. Source: LibreOffice software.

LibreOffice Calc

LibreOffice Calc is a user-friendly spreadsheet program with a wizard that helps you pull in content from databases or ask 'what if' questions from its Scenario Manager.

You can have up to 1,024 columns and 1,048,576 rows per worksheet. Both Microsoft 365 and Google Workspace spreadsheet programs allow over 15,000 columns but offer a similar number of rows per spreadsheet. Calc also offers 508 spreadsheet functions, which is comparable to Microsoft.

Although the software lets you create charts, there is a lag time to update your spreadsheet with a new chart and fewer chart options than other spreadsheet programs. Furthermore, software bugs exist with things like patterned or gradient cell background colors.

To get functionality similar to Microsoft, you’ll need to download extensions. For example, LibreOffice Calc doesn’t come with the function to remove duplicate cells. You can add this feature by downloading the Remove Duplicates extension and restarting Calc. You also won’t find templates for Calc, but a few are available for download as an extension.

Easily get totals for your columns using the sum function. Source: LibreOffice software.

LibreOffice Impress

LibreOffice Impress is a slideshow-creation tool offering several views including, normal, outline, notes, handout, and slide sorter.

It provides 3D imaging tools, downloadable templates from extensions, animation functions, and a presenter console. Use your phone or tablet as a remote during presentations by downloading an app from Google or App.

Create, import, or edit presentations in LibreOffice Impress

.

Source: LibreOffice software.

LibreOffice Draw

LibreOffice Draw is a graphic-editing program perfect for designing flowcharts, network diagrams, and other technical drawings. It offers freehand tools, object grouping functions, and displays dimension lines. You can also use Draw to edit photos and PDF files.

. Citrix viewer app.

Source: LibreOffice software.

LibreOffice Base

LibreOffice Base is a database management system that lets you build a custom database for all LibreOffice suite programs.

Unlike Microsoft Access, which only works on the Windows operating system, LibreOffice Base is fully functional on all operating systems. However, it’s not nearly as visually appealing as Airtable.

Base comes with wizards and pre-defined table definitions, which help you design forms, tables, and reports used for tracking customers, invoices, or assets. Base supports:

  • MySQL
  • MariaDB
  • Java database connectivity (JDBC)
  • Open database connectivity (ODBC)
  • Mozilla Thunderbird address book
  • KDE address book
  • Evolution lightweight directory access protocol (LDAP) and storage
  • Windows system address book
  • Microsoft Outlook address book when using Microsoft Windows

Use the table wizard to quickly build a database in LibreOffice Base.

Source: LibreOffice software.

LibreOffice Math

LibreOffice Math is an advanced formula editor used by researchers or data scientists. You can use Math on its own or within Writer, Impress, Calc, or Draw. You can create scientific and mathematical formulas with various elements, including:

  • Integrals
  • Matrices
  • Systems of equations
  • Fractions
  • Inequalities
  • Terms with exponents

Create advanced formulas in LibreOffice Math. Source: LibreOffice software.

LibreOffice Charts

LibreOffice Charts can be used as a standalone application or within any other LibreOffice programs. It allows you to create embeddable pie charts, 2D and 3D charts, dot charts, and trend graphs.

Extensions

All LibreOffice programs allow you to add an unlimited number of extensions or templates to improve your software’s functionality. You can find extensions via LibreOffice or OpenOffice, with more than 1,100 available options.

Popular extensions include:

  • OpenOffice.org2GoogleDocs: Lets you import, export, and update documents from Zoho, Google Docs, and WebDAV.
  • Language support: You’ll find an extensive list of dictionaries, grammar checkers, and thesauruses for tons of languages.
  • Clipart: None of the LibreOffice tools come with clipart, but there are more than 30 different clipart extensions.

Choose from hundreds of extensions in the LibreOffice extension center. Source: extensions.libreoffice.org.

LibreOffice’s ease of use

If you grew up using Microsoft Office products, then you may find LibreOffice easy to use. The interface resembles older versions of Microsoft, although the latest update offers a Notebook bar design view, closely resembling Google or Microsoft interfaces.

Regardless, there is definitely a learning curve with the LibreOffice suite. Some functions are hidden under submenus, meaning you’ll click more times to get the results you want.

LibreOffice’s pricing

As an open-source software, LibreOffice is free to download and use on as many supported devices as you want. New updates come out frequently; you simply download the latest update without uninstalling the current version or losing any saved files.

However, there isn’t any type of technical or customer service options. The Document Foundation recommends using an ecosystem partner for assistance and new features.

Ecosystem partners include:

  • Collabora: Offers a free version for up to 20 users, a paid plan for up to 99 users that costs $18 per user per year, and an Enterprise version available for a custom quote.
  • CIB: Provides LibreOffice software and support for $14.99 for installation on up to 10 Windows devices. It’s unclear if this is a subscription or a one-time fee.

LibreOffice also has a certification program and can direct you to various professionals for support services. Professionals include developers, migration experts, and certified trainers.

LibreOffice’s support

Unlike other platforms, LibreOffice doesn’t provide any direct support. There aren’t phone, live chat, or email customer services. To get help with LibreOffice, you can:

  • Join a group mailing list and pose your question to the group
  • Use the LibreOffice support site by posting a query to the message board
  • Purchase LibreOffice through an ecosystem partner offering support services
  • Search online to find answers through various blogs and help forums

Benefits of LibreOffice

LibreOffice can be a great alternative to Microsoft or Google products if you want free software that won’t ever require you to upgrade and pay.

Your company can use LibreOffice with the peace of mind that it’ll still be around and be able to open your old documents, even a decade from now. Other advantages of using LibreOffice include:

  • Zero cost to download and use the software on an unlimited number of devices
  • Frequent updates and extensions added to improve functionality
  • Works well on older operating systems, laptops, and desktop computers
  • Language support for 191 languages and counting
  • Cross-platform use, as it works equally well on Linux, macOS, or Windows devices
  • No internet connection required
  • Most file types are compatible with LibreOffice
  • Unlike legacy programs, you won’t lose functionality or access during upgrades
  • No privacy or data collection concerns as it only exists on your computer

Best open-source office software

If you’re tired of per-user or per-device subscription fees or are worried about losing access to documents when using outdated software, then LibreOffice is a good alternative. It provides basic office tools that work without an internet connection. Although there’s a learning curve for simple word processing documents and spreadsheets, this tool is relatively easy to use.

Frequently Asked Questions for LibreOffice

For basic word processing and spreadsheets, LibreOffice works as well as Microsoft Office does. However, the Microsoft 365 office suite provides cloud storage, real-time collaboration, and a friendlier user interface.

Yes, using LibreOffice is as safe as using any other type of software. Since it’s developed using the open-source method, any type of malicious code would be caught quickly. Furthermore, LibreOffice doesn’t store your files online or collect your personal data, so using it is as safe as using your office computer’s hard drive.

If you download LibreOffice through The Document Foundation, there is no online version. However, ecosystem partners offer online LibreOffice versions, which usually have less functionality than downloaded programs.

Decide if switching to open-source software is right for you by downloading the free LibreOffice platform today.

Libreoffice Download

Decide if switching to open-source software is right for you by downloading the free LibreOffice platform today.

Libreoffice Download

Suzanne Frey, an executive at Alphabet, is a member of The Motley Fool’s board of directors. Teresa Kersten, an employee of LinkedIn, a Microsoft subsidiary, is a member of The Motley Fool’s board of directors. The Motley Fool owns shares of and recommends Alphabet (C shares), Apple, and Microsoft and recommends the following options: short March 2023 $130 calls on Apple and long March 2023 $120 calls on Apple. The Motley Fool has a disclosure policy.