ReleaseNotes/7.0

Writer

 * Implemented a padded numbering in Writer's lists. More info in a first blog post and in a second blog post (Miklos Vajna, Collabora)


 * Actually not limited to lists; e.g., page numbering may also use padding (ODT only).




 * Bookmarks and Fields can now be protected to prevent accidental changes to them (See ) (Katarina Behrens, Michael Stahl, Samuel Mehrbrodt - CIB)


 * Fix in Mail merge: progress is not updated during export of many files (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)




 * Bookmarks can now be displayed in-line in the text, controlled by and     (Michael Stahl, CIB)




 * Empty input fields were completely invisible and now they are highlighted with grey background too (Serge Krot, CIB)


 * An option added to create encrypted PDF files with mail merge (Gülşah Köse, Collabora)

Navigator
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)
 * All objects in Navigator (Headings, Tables, Frames, Images, etc.) have own context menu items like Go To, Edit, Delete, Rename
 * Headings in Navigator have Promote/Demote level and Promote/Demote chapter context menu items
 * Table's context menu in Navigator now has Insert caption item
 * 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
 * Replaced the navigation toolbox with the navigate by elements control
 * Added Navigator section tooltip word and character count

AutoCorrect
Improved usage of quotation marks and apostrophe in several languages (László Németh)


 * Replace ASCII apostrophe with typographic apostrophe (’) in Czech, German, Icelandic, Slovak and Slovene instead of second level quotation mark (‘) outside of second level quotation


 * Before

‚word' → ‚word‘ word' → word‘ (bad)


 * After

‚word' → ‚word‘ word' → word’ (good)
 * Similar in Russian and Ukrainian: replace ASCII apostrophe with typographic apostrophe (’) instead of second level quotation mark (“) outside of second level quotation


 * Before

„word' → „word“ word' → word“ (bad)


 * After

„word' → „word“ word' → word’ (good)


 * Replace character sequences << and >> with double angle quotes « and » in Aragonese, Asturian, Catalan, Finnish, Galician, German, Hungarian, Polish, Portuguese, Romanian, Spanish, Swedish, Ukrainian; and with single angle quotes ‹ and › in Swiss French, where these quotation marks are in use, but their actual Single and Double Quotes replacement doesn't support them

< > → «word» < > → ‹word› (Swiss French)


 * Replace ASCII quotation mark " with second level quotation marks inside primary level quotation in Hungarian and Romanian (these languages use apostrophe and single quotation marks instead of the equally important double angle quotes in Single Quotes AutoCorrect)

" → „     „... " → „... » (Hungarian) or      „... " → „... « (Romanian)      „... »word" → „... »word« (Hungarian) or     „... »word" → „... «word» (Romanian)      „... »word« ..." → „... »word« ...” (Hungarian) or     „... «word» ..." → „... «word» ...” (Romanian)

Transliteration to Old Hungarian
As an RTL (Right-To-Left) AutoCorrect feature in Hungarian, words, numbers and some kind of punctuation are transliterated to Old Hungarian (or Szekler/Székely) writing, turning on the right to left writing direction using Writer’s Complex Text Layout support during typing. See this screencast about the usage: Hungarian, as well as an [[Media:Székely írás sablondokumentum beágyazott Noto betűkészlettel.ott|Old Hungarian template document with embedded Noto Old Hungarian font]]. (László Németh)



Accessibility improvements
New (experimental) features have been added to make documents more accessible: an accessibility check tool to review common accessibility problems in documents, and support for PDF/UA specifications in the PDF export dialog. More information in this blog post (Tomaž Vajngerl, Collabora)

To enable the accessibility check tool and the PDF/UA export, go to:
 * Restart LibreOffice
 * Restart LibreOffice

You can then find the accessibility check tool in, and the PDF/UA export option in.



Performance improvements

 * : Find & Replace is ~50% faster (Noel Grandin, Collabora)

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. (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 (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. (Eike Rathke (Red Hat, Inc.))


 * OFFSET optional 4th parameter (Width) and 5th parameter (Height) now must be greater than 0 if given, otherwise the result is Err:502 (invalid argument) error. In previous releases a negative argument value was silently taken as value 1, which does not comply with the specification and other implementations. (Eike Rathke (Red Hat, Inc.))


 * : TEXTJOIN and CONCAT now handle array/matrix arguments row-wise instead of column-wise, to behave the same as for cell range references and interoperability with other implementations. If formula expressions relied on the old erroneous behaviour that an internal matrix with two columns or more was processed column-wise, they must be changed to pass a transposed matrix to achieve the same (e.g. old CONCAT({"a","b";"c","d"}) would now have to be CONCAT(TRANSPOSE({"a","b";"c","d"})) for the same  acbd  result). Again, this change is only for the array/matrix case, cell reference arguments are not affected. (Eike Rathke (Red Hat, Inc.))

Performance improvements

 * Improved opening speed of XLSX files with many pictures (Noel Grandin, Collabora)
 * Improved searching speed in autofilter pulldown (Noel Grandin, Collabora)
 * Improved Calc autofill speed (Noel Grandin, Collabora)
 * Decreased a time for a sheet deleting's undoing operation (Luboš Luňák and Noel Grandin, Collabora)

Other

 * Allow raising text import dialog for paste (Samuel Mehrbrodt, CIB)
 * Add keyboard shortcut for autosum  (Martin van Zijl)
 * Preserve non-breaking space between number and percent sign when adding/deleting decimal (Laurent Balland)
 * Add/Delete decimal to time format for 100th second (Laurent Balland)

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.  (Justin Luth, SIL)


 * 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 (Serge Krot, CIB)
 * Speed up: entering to table editing mode became faster (Mark Hung)
 * Speed up: improved opening speed for some PPT files (Miklos Vajna, Collabora)

Base

 * Macro signatures are now evaluated on document load (Samuel Mehrbrodt, CIB)

Math

 * Added RGB personalized color. You should use syntax like color rgb 0 100 0 { your_symbols } in Formula editor. That "color" is available in Element's Attributes pane too (Dante DM)
 * Added a Laplace transform symbol (Dante DM)

BASIC

 * 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. (Andreas Heinisch)


 * Replace function now case-insensitively replaces non-ASCII Unicode character by default. (Andreas Heinisch)

Core / General

 * The underlying OpenGL backend on Windows was replaced with the Skia library and Vulkan. List of commits (Luboš Luňák, Collabora)


 * Fontwork got some new artistic shapes. See this blog post (Jun Nogata & Andreas Kainz)

Gallery

 * Move previous image galleries to extensions.libreoffice.org (Andreas Kainz)
 * Add new shape galleries which can be easily edited and stylized by the user
 * Arrows (Andreas Kainz)
 * BPMN (Andreas Kainz)
 * Diagrams (Andreas Kainz)
 * Flowchart (Andreas Kainz)
 * Icons (Andreas Kainz)
 * Network See this blog post (Rizal Muttaqin & Andreas Kainz)
 * Shapes (Andreas Kainz)
 * Symbols (Andreas Kainz)

Templates

 * Most Impress templates were updated from a 4∶3 ratio to 16∶9, some of templates got style support (Andreas Kainz) and cleaned  (Laurent Balland-Poirier)


 * See this YouTube video:


 * Add Draw BPMN template (Andreas Kainz)

Config options

 * New config options to disable individual Infobars has been added. (Samuel Mehrbrodt, CIB)
 * Look for  in Expert config
 * New config option to prevent disabling readonly mode (Samuel Mehrbrodt, CIB)
 * Look for  in Expert config
 * New option to disallow opening files locked by other users (Samuel Mehrbrodt, CIB)
 * Look for  in Expert config

LibreOffice Help

 * Internet Explorer 11 is no longer supported for viewing the Help


 * New help pages for  and   LibreOffice Basic statements as well as   VBA object (Alain Romedenne).


 * Basic Syntax diagrams are starting to be included inside help pages (Alain Romedenne).




 * Help pages now have module brand color in the header (Olivier Hallot).

SUMIFS(Func_Range; Range1; Criterion1[; Range2; Criterion2][; … ; [Range127; Criterion127]])
 * Review and enhancements of Calc functions syntax in Help pages, using square brackets for optional arguments (S. Fanning).


 * Continuous improvements in Help contents and accuracy (S. Fanning, O. Hallot, A. Romedenne, S. Chaiklin, M. Kaganski, S. Horacek, A. Barrientos, S. Schröder, E. Rahtke, I.Lauhakangas, S. Bergman and many others).

ODF 1.3
LibreOffice 7.0 adds support for exporting to new versions of ODF, available via : "ODF 1.3" and "ODF 1.3 Extended"; the latter is the default, unless the user has previously changed the version in the configuration. These implement the current OASIS OpenDocument 1.3 Committee Specification 01. (Michael Stahl, CIB)

All of the previously existing versions are still available. There were several fixes to prevent producing invalid files when choosing earlier ODF versions ("ODF 1.0/1.1", "ODF 1.2", "ODF 1.2 Extended"). In particular, Chart interpolation type "stepped" and regression curve types "moving-average" and "polynomial" are no longer exported in version "ODF 1.2 Extended". These features are available in ODF 1.3, so it is recommended to save documents with version "ODF 1.3" or "ODF 1.3 Extended". The latter is the default file format in LibreOffice 7.0. (Michael Stahl, CIB)

Recent versions of LibreOffice should have no issues consuming "ODF 1.3 Extended" files. The only known exception is OpenPGP/GPG encrypted ODF 1.3 documents, which can be imported only since LibreOffice 6.4.5. If compatibility with old and no longer maintained ODF consumers (such as OpenOffice.org, Apache OpenOffice or LibreOffice 3.x) is required, and conformance to the ODF standard is no concern, the version "ODF 1.2 Extended (compatibility mode)" continues to be available.

Improvements of the EMF+ import filter

 * Add support for linear gradient import (Armin Le Grand, Bartosz Kosiorek)


 * Add support for BeginContainer record to properly display image (Bartosz Kosiorek)


 * LibreOffice is now able to import and display custom labels from charts in OOXML format and store them in the ODF format. More information in the blog post (Tamás Bunth, Collabora)

Improvements of DOCX import/export filter

 * Improve interoperability of table formulas at import time   (Michael Warner)
 * Table formulas are exported to DOCX   (László Németh)
 * Formula fields are exported to DOCX (László Németh)
 * Formula cells are exported to DOCX (László Németh)
 * Formula cells are exported to DOCX (László Németh)


 * 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.   (Justin, SIL; Miklos/Mike, Collabora; Samuel Mehrbrodt, CIB)
 * DOCX export of non-default cell margins has been implemented. Previously, the only cell margins that were being exported were the row defaults from the last column (Justin Luth, Miklos Vajna, Collabora)
 * Glow effect on objects was implemented (Tamás Bunth, Mike Kaganski, Collabora)

Improvements of XLSX import/export filter

 * Export into XLSX with sheet names bigger than 31 characters (Serge Krot, CIB)
 * Export checkboxes into XLSX (Serge Krot, CIB)
 * Resolved "invalid content error" when opening exported XLSX file with shape (Serge Krot, CIB)
 * Glow effect on objects was implemented (Tamás Bunth, Mike Kaganski, Collabora)
 * Soft edge effect on objects was implemented. More info in this blog post (Mike Kaganski, Collabora)

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)
 * The handling of predefined table styles for imported PPTX has been improved (Gülşah Köse, Collabora)
 * The OOXML “strips” slide transition is now read properly as SLIDEWIPE in Impress (Luboš Luňák, Collabora)
 * The “flashing” transitions of slides have been implemented to the API. This effect used in PowerPoint presentations is similar to “fade” but flashes in white instead of fading to black. (Luboš Luňák, Collabora)

Standard Toolbars

 * All toolbars are locked by default now on fresh user profiles (Ahmad Ganzouri)

Icon Theme

 * Added a new icon theme, named Sukapura. This icon theme follows Apple's color palette as defined in its macOS Human Interface Guidelines for Visual Design. This icon theme will be the default for new LibreOffice installations in macOS. (Rizal Muttaqin)


 * Colibre icon theme used for Windows operating system as the default theme got a refreshing look to adjust to the new monoline style iconography as in MS Office 365. More info in this blog post (Rizal Muttaqin)




 * Sifr has been polished and receive many updates                and now fewer icons are still falling back to Breeze or Colibre       . (Rizal Muttaqin)


 * The unmaintained Tango icon theme was removed from core, but is still available as extension. (Rizal Muttaqin, Heiko Tietze)

Dialogs

 * New icons and banner in Windows installer. (Bayu Rizaldhan Rayes, Rizal Muttaqin, Muhammad Rivan)


 * Renaming a page in Draw or slide in Impress with empty or already used name give a tool tip dialog. (Heiko Tietze)

Impress Presenter Screen

 * Impress presenter screen/presenter console got new refreshed and more up to date user interface design. More info in this blog post (Rizal Muttaqin)

Start Center

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

New languages/locales with locale data

 * Ligurian [lij-IT]. (Jean Maillard, Eike Rathke (Red Hat, Inc.))
 * Minangkabau [min-ID]. (Peter Farley, Eike Rathke (Red Hat, Inc.))
 * Sundanese [sun-ID]. (Rizal Muttaqin, Eike Rathke (Red Hat, Inc.))
 * Võro [vro-EE]. (Mihkel Tõnnov, Sulev Iva)

Incorporation of other languages

 * Brand-new UI translation into Central Kurdish / Soranî‎ / سۆرانی (ckb)
 * Brand-new UI translation into Friulian (fur)

Improvements to proofing tools and language support
See details on the changes:
 * Afrikaans. The spelling dictionary was updated.
 * Catalan. The spelling dictionary was updated.
 * English (GB). The spelling dictionary was updated.
 * Latvian. The spelling dictionary was updated.
 * Slovak. The spelling dictionary was updated.
 * Belarusian (Belarus). The spelling dictionary was updated and hyphenation patterns added.
 * Russian. Updated Russian thesaurus and conversion of spelling dictionary from KOI8-R to UTF-8.

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

LibreLogo
Add command FONTTRANSPARENCY for semi-transparent text (similar to PENTRANSPARENCY and FILLTRANSPARENCY)  (László Németh, based on the new Writer feature by Miklós Vajna)

General

 * Support for the unofficial environment variables  and   has been removed.

Filters

 * Macromedia Flash export filter was removed as Flash player will be end-of-life by the end of 2020

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

Windows
button was added to, 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_REGISTRY=1 installation option) releases (Mike Kaganski, Collabora)

Linux
On Linux,  URLs (denoting filesystem resources on a specific  ) were in the past sometimes silently treated as   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  URL. (Stephan Bergman)

KDE 5 + Qt5
Introduced basic HiDPI scaling for Qt5 (Luca Carlon, Jan-Marek Glogowski)

Java support

 * The four Java jars,  ,  , and   are now combined into a single  .  The four jars provided classes in overlapping packages, so could not be used with the Java module system.  For backwards compatibility,  ,  ,  , and   are still present as empty stubs referencing the combined  .  (Stephan Bergmann; Samuel Mehrbrodt, CIB)


 * Java Modules are now supported (using JRE >= 9). The following modules are available:
 * libreoffice.jar:
 * unoloader.jar:

API changes

 * The upcasting constructor of the C++ class  has been hidden (as it should have been from the start).

UNO API changes

 * XStyleLoader::loadStylesFromURL now supports loading from stream (Samuel Mehrbrodt, CIB)


 * 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. (Noel Grandin)


 * add new XPackageEncryption UNO interface and service (css::packages::XPackageEncryption and css::packages::PackageEncryption), can be used to implement encryption plugins via extensions. The older MS-Crypto schemes were modified to implement that API (Vasily Melenchuk, CIB)

Configuration changes

 * support for the obsolete &ldquo; &rdquo; layer type has been removed from the  bootstrap variable
 * remove some 3D configuration settings (Noel Grandin)