LibreOffice 7.0: Release Notes
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 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)
- Empty input fields were completely invisible and now they are highlighted with grey background too tdf#101830 (Serge Krot, CIB)
- An option added to create encrypted PDF files with mail merge 983db96a (Gülşah Köse, Collabora)
- Hidden paragraphs are no longer shown by default, to match the print layout ac14ed9f26582701032a28cb424f2b6bf35ca7fd (Samuel Mehrbrodt, CIB)
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
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 tdf#128860
- 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 tdf#123786
- 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 tdf#133524
<<word>> → «word» <<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) tdf#133524
" → „ „... " → „... » (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 Old Hungarian template document with embedded Noto Old Hungarian font. tdf#133589 (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
Performance improvements
- Available since 7.0.2: Find & Replace is ~50% faster tdf#119286 (Noel Grandin, Collabora)
Calc
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.))
- 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. tdf#85551 (Eike Rathke (Red Hat, Inc.))
- Changed since 7.0.1: 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. tdf#109409 (Eike Rathke (Red Hat, Inc.))
Performance improvements
- Improved opening speed of XLSX files with many pictures tdf#93831 (Noel Grandin, Collabora)
- Improved searching speed in autofilter pulldown tdf#76481 (Noel Grandin, Collabora)
- Improved Calc autofill speed tdf#88109 (Noel Grandin, Collabora)
- Decreased a time for a sheet deleting's undoing operation tdf#132454 (Luboš Luňák and Noel Grandin, Collabora)
Other
- Allow raising text import dialog for paste tdf#125440 (Samuel Mehrbrodt, CIB)
- Add Alt + = keyboard shortcut for autosum tdf#39302 (Martin van Zijl)
- Preserve non-breaking space between number and percent sign when adding/deleting decimal tdf#133342 (Laurent Balland)
- Add/Delete decimal to time format for 100th second tdf#103414 (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. tdf#80194 tdf#89849 (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 tdf#129708 (Serge Krot, CIB)
- Speed up: entering to table editing mode became faster tdf#120216 (Mark Hung)
- Speed up: improved opening speed for some PPT files tdf#131496 (Miklos Vajna, Collabora)
Base
- Macro signatures are now evaluated on document load f2f93434 (Samuel Mehrbrodt, CIB)
Math
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. tdf#97983 (Andreas Heinisch)
- Replace function now case-insensitively replaces non-ASCII Unicode character by default. tdf#132389 (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 tdf#131779
- Arrows tdf#131784 (Andreas Kainz)
- BPMN tdf#99675 (Andreas Kainz)
- Diagrams (Andreas Kainz)
- Flowchart tdf#99674 (Andreas Kainz)
- Icons tdf#131860 (Andreas Kainz)
- Network See this blog post tdf#131308 (Rizal Muttaqin & Andreas Kainz)
- Shapes (Andreas Kainz)
- Symbols tdf#131795 (Andreas Kainz)
Templates
- Most Impress templates were updated from a 4∶3 ratio to 16∶9, some of templates got style support tdf#132138 (Andreas Kainz) and cleaned tdf#132771 (Laurent Balland-Poirier)
- See this YouTube video:
Please accept this video. By accepting you will be accessing content from YouTube, a service provided by an external third party.
- Add Draw BPMN template (Andreas Kainz)
Config options
- New config options to disable individual Infobars has been added. 29575dc6 (Samuel Mehrbrodt, CIB)
- Look for
org.openoffice.Office.UI.Infobar
in Expert config
- Look for
- New config option to prevent disabling readonly mode tdf#101652 (Samuel Mehrbrodt, CIB)
- Look for
AllowEditReadonlyDocs
in Expert config
- Look for
- New option to disallow opening files locked by other users (Samuel Mehrbrodt, CIB)
- Look for
AllowOverrideLocking
in Expert config
- Look for
LibreOffice Help
- Internet Explorer 11 is no longer supported for viewing the Help
- New help pages for
Property
andResume
LibreOffice Basic statements as well asErr
VBA object (Alain Romedenne).
- Basic Syntax diagrams are starting to be included inside help pages (Alain Romedenne).
- Review and enhancements of Calc functions syntax in Help pages, using square brackets for optional arguments (S. Fanning).
SUMIFS(Func_Range; Range1; Criterion1[; Range2; Criterion2][; … ; [Range127; Criterion127]])
- 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).
Filters
ODF 1.3
LibreOffice 7.0 adds support for exporting to new versions of ODF, available via a541cd919 (Michael Stahl, CIB)
▸ ▸ ▸ ▸ : "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.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. tdf#130176 58c01351 (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 tdf#124424 (Armin Le Grand, Bartosz Kosiorek)
- Add support for BeginContainer record to properly display image tdf#131542 (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
- Available since 7.0.2:
- Improve interoperability of table formulas at import time tdf#133647 tdf#123386 tdf#123389 (Michael Warner)
- Table formulas are exported to DOCX tdf#133647 tdf#123386 tdf#123389 (László Németh)
- Formula fields are exported to DOCX tdf#118682 (László Németh)
- Formula cells are exported to DOCX tdf#133163 (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. tdf#131304 tdf#123116 tdf#131121 (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 tdf#98409 (Justin Luth, Miklos Vajna, Collabora)
- Glow effect on objects was implemented tdf#101181 (Tamás Bunth, Mike Kaganski, Collabora)
Improvements of XLSX import/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)
- Resolved "invalid content error" when opening exported XLSX file with shape tdf#133595 (Serge Krot, CIB)
- Glow effect on objects was implemented tdf#101181 (Tamás Bunth, Mike Kaganski, Collabora)
- Soft edge effect on objects was implemented. More info in this blog post tdf#49247 (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 tdf#107604 (Gülşah Köse, Collabora)
- The OOXML “strips” slide transition is now read properly as SLIDEWIPE in Impress c69e5e3 (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. e3d7fdf (Luboš Luňák, Collabora)
GUI
Standard Toolbars
- All toolbars are locked by default now on fresh user profiles tdf#92484 (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. tdf#130500 (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 tdf#133268 (Rizal Muttaqin)
- Sifr has been polished and receive many updates tdf#99185 tdf#122488 tdf#127415 tdf#128689 tdf#128849 tdf#129846 tdf#130204 tdf#130648 tdf#130871 tdf#130875 tdf#130939 tdf#131509 tdf#131974 tdf#131975 tdf#132490 tdf#131975 and now fewer icons are still falling back to Breeze or Colibre tdf#132022 tdf#125510 tdf#130898 tdf#130885 tdf#130864 tdf#131708 tdf#132489. (Rizal Muttaqin)
- The unmaintained Tango icon theme was removed from core, but is still available as extension. tdf#132022 (Rizal Muttaqin, Heiko Tietze)
Dialogs
- New icons and banner in Windows installer. tdf#130778 (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. tdf#129032 (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 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)
Localization
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.))
- Available since 7.0.3Võro [vro-EE]. tdf#136951 (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.
Scripting
Python
Support for building against the obsolete CPython 2.7 has been removed, and scripts are now always executed on CPython 3 c4fa6efa67775a6b333a4a5aa873b5cc24a4f7bc (Michael Stahl, CIB)
LibreLogo
Add command FONTTRANSPARENCY for semi-transparent text (similar to PENTRANSPARENCY and FILLTRANSPARENCY) d4c92c836c42d8fa7e31657d0534bef3979a03e2 (László Németh, based on the new Writer feature by Miklós Vajna)
Feature removal / deprecation
Writer
- Blinking effect was removed from the character properties dialog tdf#132373 (Gabor Kelemen, NISZ)
General
- Support for the unofficial environment variables
JFW_PLUGIN_DO_NOT_CHECK_ACCESSIBILITY
andJFW_PLUGIN_FORCE_ACCESSIBILITY
has been removed. c0ac7ae73480cd2b01f24e88c01bee507e8638f9
Filters
- Macromedia Flash export filter was removed as Flash player will be end-of-life by the end of 2020 63e43c1db9d0d5c52916dc6d2d7cd1d3d9bcae76
Platform Compatibility
Mac
Support for macOS 10.10 and 10.11 is deprecated. Minimum runtime requirement will be raised in a future release.
Windows
tdf#44462 (Mike Kaganski, Collabora)
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) releasesLinux
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. 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
, andunoil.jar
are now combined into a singlelibreoffice.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
, andunoil.jar
are still present as empty stubs referencing the combinedlibreoffice.jar
. tdf#117331 (Stephan Bergmann; Samuel Mehrbrodt, CIB)
- Java Modules are now supported (using JRE >= 9). The following modules are available:
- libreoffice.jar:
org.libreoffice.uno
- unoloader.jar:
org.libreoffice.unoloader
- libreoffice.jar:
API changes
- The upcasting constructor of the C++ class
com::sun::star::uno::Reference
has been hidden (as it should have been from the start). 39a1edd6fec902ef378acce8af42c4d7fba280d0
UNO API changes
- XStyleLoader::loadStylesFromURL now supports loading from stream 0322a412 (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. 214e6caf2c503d817c47ebcc419e4f7e33b336ac (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 b9353394f46e46485fd148f2842f0c1e8e5322e3 (Vasily Melenchuk, CIB)
Configuration changes
- support for the obsolete “
module
” layer type has been removed from theCONFIGURATION_LAYERS
bootstrap variable 8c93e2c280536ba3acf9553aa199c752c8ca23f6 - remove some 3D configuration settings c71656f51a09e88ecae4f3423c96fee84778647d (Noel Grandin)