LibreOffice 7.0: Release Notes

From The Document Foundation Wiki
< ReleaseNotes(Redirected from ReleaseNotes/6.5)
Jump to: navigation, search
Other languages:
čeština • ‎English • ‎français • ‎Bahasa Indonesia • ‎italiano • ‎日本語 • ‎slovenščina • ‎中文(中国大陆)‎
7.0 alpha1 available.png

About this page


  • Bookmarks and Fields can now be protected to prevent accidental changes to them (See Tools ▸ Protect Document) (Katarina Behrens, Michael Stahl, Samuel Mehrbrodt - CIB)
  • Fix in Mail merge: progress is not updated during export of many files tdf#133270 (Serge Krot, CIB)
  • Improved rotated text handling in Writer's table rows with automatic height. More info in this blog post (Miklos Vajna, Collabora)
  • Implemented support for semi-transparent text in Writer. More info in this blog post (Miklos Vajna, Collabora)


Support for very large spreadsheets

  • Experimental support for very large spreadsheets (16 millions of rows, 16384 columns) were added. tdf#50916 (Dennis Francis, Bartosz Kosiorek, Noel Grandin, Caolán McNamara, Mike Kaganski, Michael Meeks, Aron Budea, Eike Rathke)

To enable very large spreadsheets, just tick following checkboxes:

  • Options... ▸ LibreOffice ▸ Advanced ▸ Optional Features ▸ Enable experimental features (may be unstable)
  • Restart LibreOffice
  • Options... ▸ LibreOffice Calc ▸ Defaults ▸ New Spreadsheet ▸ Enable very large spreadsheets (16m rows, 16384 cols)

New spreadsheet functions

  • RAND.NV() and RANDBETWEEN.NV() non-volatile random number generating functions that are not recalculated on every input like RAND() and RANDBETWEEN() are. tdf#127831 (Eike Rathke (Red Hat, Inc.))

Changed spreadsheet functions

  • Functions that allow using regular expressions now correctly honor case-insensitivity flags (?i) / (?-i) in the expression. Note that the default case-sensitivity of the functions is not changed; the affected functions: AVERAGEIF, AVERAGEIFS, COUNTIF, COUNTIFS, HLOOKUP, LOOKUP, MATCH, SEARCH, SUMIF, SUMIFS, VLOOKUP are case-insensitive by default, so the sensitivity only changes after first (?-i) in the regular expression tdf#78840 (Mike Kaganski, Collabora)
  • TEXT() now allows the second argument to be an empty format string for interoperability with other implementations. If the first argument is numeric or a text string that could be converted to a number (according to formula detailed settings) then an empty string is returned. If the first argument is a text string that can not be converted to number then that text string is returned. In previous releases an empty format string always results in Err:502 (invalid argument) error. tdf#131536 (Eike Rathke (Red Hat, Inc.))

Performance improvements

  • Improved opening speed of XLSX files with many pictures tdf#93831 (Noel Grandin, Collabora)


  • Allow raising text import dialog for paste tdf#125440 (Samuel Mehrbrodt, CIB)
  • Add Alt+= keyboard shortcut for autosum tdf#39302 (Martin van Zijl)

Impress & Draw

  • Subscripts now return to the default of 8%. Automatic positioning fixed for superscripts and subscripts in Textboxes (editeng). Positioning fixed for textboxes with "Autofit text". Users may need to fix exaggerated superscripts in presentations created since LO 4.1. tdf#80194 tdf#89849 (Justin Luth, SIL)
SubscriptReport 7.0.png
  • Implemented support for semi-transparent text in Draw/Impress. More info in this blog post (Miklos Vajna, Collabora)
  • Draw (and other modules) now support page sizes larger than 200" during pdf export (using PDF 1.6 markup). More info in this blog post (Miklos Vajna, Collabora)

Performance improvements

  • Speed up: Long operation during typing in list with animations tdf#129708 (Serge Krot, CIB)
  • Speed up: entering to table editing mode became faster tdf#120216 (Mark Hung)



  • Chart interpolation type "stepped" has been remove in file format "ODF 1.2 extended", because such interpolation type does not exist in the standard "ODF 1.2" and LibreOffice versions prior to version 7.0 produce invalid markup in regard to chart interpolation type "stepped". The interpolation type "stepped" is available in standard "ODF 1.3". So in case you need these kind of interpolation save the document in file format "ODF 1.3" or "ODF 1.3 extended". The latter is default file format in LibreOffice 7.0. tdf#130176 core commit 58c01351 (Michael Stahl, CIB)



  • For numeric types, the current locale for the decimal and thousands separators is taken into account, e.g., 1.234,321 in de_DE becomes 1234, whereas 1,234.321 in the en_UK locale provides the same result. tdf#97983 (Andreas Heinisch)
  • Replace function now case-insensitively replaces non-ASCII Unicode character by default. tdf#132389 (Andreas Heinisch)

Core / General

  • Glow effect on objects was implemented tdf#101181 (Tamás Bunth, Mike Kaganski, Collabora)


Writer's Navigator got many improvements by Jim Raykowski:

  • Navigator's categories are gray if they don't have any items (the same for Calc's Navigator) tdf#129625
  • All objects in Navigator (Headings, Tables, Frames, Images, etc.) have own context menu items like Go To, Edit, Delete, Rename tdf#128814
  • Headings in Navigator have Promote/Demote level and Promote/Demote chapter context menu items tdf#128814
  • Table's context menu in Navigator now has Insert caption item tdf#128814
  • Added Outline tracking for Headings in Navigator. It can be in three states: Default, Focus, Off. Try clicking with your mouse in several places in your big text document with many headings. You'll see that Headings in Navigator will be selected automatically according to text cursor position tdf#108766
  • Replaced the navigation toolbox with the navigate by elements control tdf#89566
  • Added Navigator section tooltip word and character count tdf#63967

Config options

  • New config options to disable individual Infobars has been added. core commit 29575dc6 (Samuel Mehrbrodt, CIB)
    • Look for org.openoffice.Office.UI.Infobar in Expert config
  • New config option to prevent disabling readonly mode tdf#101652 (Samuel Mehrbrodt, CIB)
    • Look for AllowEditReadonlyDocs in Expert config
  • New option to disallow opening files locked by other users (Samuel Mehrbrodt, CIB)
    • Look for AllowOverrideLocking in Expert config

LibreOffice Help

New help pages for Property and Resume LibreOffice Basic statements as well as Err VBA object. Basic Syntax diagrams are starting to be included inside help pages.

Argument syntax in Function/Property/Sub


Improvements of the EMF+ import filter

  • Add support for linear gradient import tdf#124424 (Armin Le Grand, Bartosz Kosiorek)
  • Add support for BeginContainer record to properly display image tdf#131542 (Bartosz Kosiorek)

Improvements of DOCX export filter

  • DOCX now saves in native 2013/2016/2019 mode instead of in 2007 compatibility mode. “This mode is intended to ensure users of different versions of Microsoft Office can continue working together and documents created with older versions of Office won’t look any different when they’re opened in future versions of Office.” So this mainly benefits Word users - where documents can use more features and Word’s bugfixes since DOCX 1.0 can be applied. Although this means Word 2010 users lose out a little, Microsoft has done the same to them since 2013, and it is end-of-life before 7.0 reaches stable status. Word 2010 users should upgrade to LibreOffice. tdf#131304 tdf#123116 tdf#131121 (Justin, SIL; Miklos/Mike, Collabora; Samuel Mehrbrodt, CIB)

Improvements of XLSX export filter

  • Export into XLSX with sheet names bigger than 31 characters tdf#79998 (Serge Krot, CIB)
  • Export checkboxes into XLSX tdf#106181 (Serge Krot, CIB)

Improvements of PPTX import/export filter

  • Implemented better support for Impress math objects from PPTX, avoiding duplication. More info in this blog post (Miklos Vajna, Collabora)


Classic Toolbars

  • All toolbars are locked by default now on fresh user profiles tdf#92484 (Ahmad Ganzouri)

Icon Theme

Best Fit for macOS
  • The unmaintained Tango icon theme was removed from core but will be available as extension. tdf#132022 (Rizal Muttaqin, Heiko Tietze)


  • New icons and banner in Windows installer. tdf#130778 (Rizal Muttaqin, Bayu Rizaldhan Rayes, Muhammad Rivan)
Installation Type-en.png
Installation Progress-en.png
  • Renaming a page in Draw or slide in Impress with empty or already used name give a tool tip dialog. tdf#129032 (Heiko Tietze)
Renaming Same Name Slide.png

Start Center

  • Fixed unnecessary scrolling for recent documents and templates in Start Center when all thumbnails displays in the window tdf#91818 (Roman Kuznetsov)
  • Fixed unnecessary scrolling for recent documents and templates in Start Center to empty space not appear below of last thumbnails row tdf#132441 (Roman Kuznetsov)



New languages/locales with locale data

  • Ligurian [lij-IT]. tdf#130579 (Jean Maillard, Eike Rathke (Red Hat, Inc.))
  • Minangkabau [min-ID]. tdf#130772 (Peter Farley, Eike Rathke (Red Hat, Inc.))
  • Sundanese [sun-ID]. tdf#131297 (Rizal Muttaqin, Eike Rathke (Red Hat, Inc.))

Additional languages in the language list

Incorporation of other languages



Support for building against the obsolete CPython 2.7 has been removed, and scripts are now always executed on CPython 3 core commit c4fa6efa67775a6b333a4a5aa873b5cc24a4f7bc (Michael Stahl, CIB)

Feature removal / deprecation



Platform Compatibility


Support for macOS 10.10 and 10.11 is deprecated. Minimum runtime requirement will be raised in a future release.


  • Windows Default apps button was added to Options ▸ LibreOffice ▸ General, to call Windows file associations management. This button behaves according to Microsoft file association management policy, which is to open "Default apps" on Windows 7, 8, and 8.1; and to show a message telling user how to open that applet manually in Windows 10. This only works with registered application, so would not work for portable or testing (e.g. beta, when not using WRITE_REGSITRY=1 installation option) releases tdf#44462 (Mike Kaganski, Collabora)


On Linux, file://host/ URLs (denoting filesystem resources on a specific host) were in the past sometimes silently treated as smb://host/ URLs denoting resources accessed via the SMB protocol. This is no longer done. If you want to access a file via the SMB protocol, use a smb URL. core commit fa314082a89f917912dd2e610ac19991b84921fa (Stephan Bergman)

KDE 5 + Qt5

  • Introduced basic HiDPI scaling for Qt5 tdf#127687 (Luca Carlon, Jan-Marek Glogowski)

Java support

  • The four Java jars juh.jar, jurt.jar, ridl.jar, and unoil.jar are now combined into a single libreoffice.jar. The four jars provided classes in overlapping packages, so could not be used with the Java module system. For backwards compatibility, juh.jar, jurt.jar, ridl.jar, and unoil.jar are still present as empty stubs referencing the combined libreoffice.jar. tdf#117331 (Stephan Bergmann; Samuel Mehrbrodt, CIB)
  • Java Modules are now supported (using JRE >= 9). The following modules are available:
    • libreoffice.jar:
    • unoloader.jar: org.libreoffice.unoloader

API changes

UNO API changes

  • remove BasicImport UNO interfaces and service (css::document::XMLBasicImporter, css::document::XMLOasisBasicImporter, css::document::XXMLOasisBasicImporter), which were used internally to load the scripts embedded in documents. core commit 214e6caf2c503d817c47ebcc419e4f7e33b336ac (Noel Grandin)

Configuration changes

SDK changes

Android Viewer

New Features