LibreOffice 5.4: Release Notes
TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate
About this page
This is the page with our 5.4 release notes. It should be final now that the 5.4 version itself has been released. However, if you spot any missing or incorrect information, then please let us know. Thanks in advance for your help!
Writer
- AutoText import from .dotx and .dotm files blog entry (Szymon Kłos - Collabora)
- RTF filter now supports all types of custom document properties blog entry (Miklos Vajna - Collabora)
- New "Edit Section" UNO command which works if cursor is in a section, has been created and added in context menu. tdf#102132 (Gülşah Köse).
- New "Footnotes and Endnotes" UNO command which works if cursor is in a footnote or endnote, has been created and added in context menu. tdf#103258 (Gülşah Köse)
- Huge improvement in the export of bullets & numbering via copy & paste 0425ccba5b2f8819d6fade05d96a72d64db1ce0c (Jan Holešovský - Collabora)
- New formatting toolbar focused on the use of styles is accessible through tdf#106781 (Yousuf Philips) ▸ ▸ .
- Custom Watermark inserting in blog entry (Szymon Kłos - Collabora) ▸ .
- Styles submenu was added to Context Menu, which includes basic character styles. tdf#102915, tdf#85940 (Yousuf Philips)
- AutoCorrect options for markup strikeout and italic are added 6bfe94a631b5c5029a1f96a52b000d25e33bad4a (Tiago Santos)
- Rename Moderate business letter templates to Modern business letter. tdf#111331 (Caolán McNamara, Heiko Tietze)
Calc
- Calculate with Precision as shown option (Laurent Balland-Poirier) now works also with
- fraction format tdf#105657
- several subformats tdf#106052
- engineering notation tdf#106252
- thousands divisors tdf#106253
- CSV export settings are now remembered. tdf#55236 (Bernhard Widl, CIB)
- Priority of conditional formatting rules can be changed with new up/down buttons. tdf#74074 (Manfred Blume, CIB)
- New cell comment commands added
- Comments toggle command to show/hide all comments on currently selected sheet(s) added to tdf#107258 (Gülşah Köse, Eike Rathke) ▸ .
- Delete All Comments commands available under menu tdf#107143 (Gülşah Köse) ▸ acting on the currently selected sheet(s)
- Show All Comments and Hide All Comments commands acting on the currently selected sheet(s) added. tdf#84837 (Gülşah Köse)
- While building formulas, when selecting a cell or range on another sheet with the pointer, absolute sheet references are now created instead of relative. tdf#90799 (Eike Rathke (Red Hat, Inc.))
- Support negative year date (BCE) in cell input and date display. (Eike Rathke (Red Hat, Inc.))
- Accepted inputs include the ISO 8601 format -YYYY-MM-DD and locale dependent input like -Y/M/D or M/D/-Y or D.M.-Y
- For BCE dates years are displayed negative unless a specified date format already includes an era code, e.g. G or GG
- Last day BCE is -0001-12-31, the next day CE is 0001-01-01
- Previous versions could already calculate such dates, but did not display negative years
- A new Cell Protection toggle command was added to tdf#95885 (Gülşah Köse) ▸ to change the protection status of the cell.
- Four new sheet protection options have been added to optionally allow insertions and deletions of rows and columns. The Insert rows and Insert columns options allow row and column insertions even when the sheet is protected, whereas the Delete rows and Delete columns options allow row and column deletions. Note that when row and column insertions are enabled, you can insert rows or columns even when the range to insert the new rows or columns into contains protected cells which will get shifted after the insertion. Row and column deletions, on the other hand, are only allowed on unprotected cells. tdf#43535 (Kohei Yoshida, Collabora)
- Cell styles now accessible in their own dedicated Styles menu in tdf#91820 (Yousuf Philips) ▸ .
- Standard and Percent buttons of number format became toggle. tdf#86119 (Gülşah Köse)
New spreadsheet functions
- New function ROUNDSIG to round a value at a number of significant digits. tdf#105931 (Winfried Donkers)
Changed spreadsheet functions
- The semantics of the COUNTIF, SUMIF and AVERAGEIF Criteria argument has been changed.
- The equals empty "=" and not-equals not-empty "<>X" criteria now also match empty cells of a given range like they are evaluated in other spreadsheet applications.
Impress & Draw
- Duplicate dialog box ⇧ Shift + F3:
- Enable fractional angle tdf#77816 (Laurent Balland-Poirier)
- Save previous parameters tdf#104423 (Laurent Balland-Poirier)
- Ctrl + M shortcut assigned to inserting a new slide in Impress. tdf#87674 (Yousuf Philips)
Chart
Math
- Implement context menu edit commands: cut, copy, paste for the Formula command input panel tdf#106479 (Maxim Monastirsky)
BASIC
- The CDateFromIso runtime function accepts also ISO 8601 date strings with separators, i.e. in the format YYYY-MM-DD (Eike Rathke (Red Hat, Inc.))
- this was also backported to release 5.3.4
- The CDateFromIso and CDateToIso runtime functions handle the full date range in the proleptic Gregorian calendar, i.e. from -32768-01-01 (BCE) to 32767-12-31 (Eike Rathke (Red Hat, Inc.))
- CDateFromIso input specification:
- The year part must consist of either two (supported only in YYMMDD format without separators for compatibility) or at least four digits. With four digits leading zeros must be given if the absolute value is less than 1000, it can be negative with a leading minus sign if the date passed denotes a year before the common era (BCE) and it can have more than four digits if the absolute value is greater than 9999. The formatted string can be in the range "-327680101" to "327671231", or "-32768-01-01" to "32767-12-31".
- An invalid date results in an error. Year 0 is not accepted, the last day BCE is -0001-12-31 and the next day CE is 0001-01-01. Dates before 1582-10-15 are in the proleptic Gregorian calendar.
- When automatically converting a date serial number to a printable string, for example for the Print or MsgBox command, the locale's default calendar is used and at that 1582-10-15 cutover date may switch to the Julian calendar, which can result in a different date being displayed than expected. Use the CDateToIso function to convert such date number to a string representation in the proleptic Gregorian calendar.
- CDateFromIso input specification:
Core / General
- The standard color palette was updated. tdf#87538 blog post (Yousuf Philips, Thibaut Brandscheid, Heiko Tietze)
- New 'chart palettes' color palette was created containing multiple chart palettes. tdf#106534 (Yousuf Philips)
- Fix text layout issues for Tibetan, Khmer. tdf#109142 (Khaled Hosny)
Help Contents
- The default size of the body help text was increased. (Adolfo Jayme Barrientos)
- New help pages for undocumented BASIC constants, VBA functions and statements. (tdf#84675 - Olivier Hallot)
- Update of Template manager help pages (Gabor Kelemen)
Document signing
- Under Linux, you can now use OpenPGP keys to sign ODF documents. tdf#89037 (Katarína Behrens, Samuel Mehrbrodt, Thorsten Behrens - CIB)
- Added support for ECDSA keys on Linux and macOS blog entry (Miklos Vajna - Collabora)
- The signature status is now shown with colored infobars tdf#105566 (Katarína Behrens, Samuel Mehrbrodt - CIB):
Filters
Improvements in EMF+ vector images import (used by .doc, docx, .xls, .xlsx, .ppt file formats)
- Improve import of EMF+ images, created with ChemDraw tdf#31814 (Bartosz Kosiorek)
- Add support for drawing rectangles, EmfPlusDrawRects tdf#107016 (Bartosz Kosiorek),
- Add support for drawing Bézier curves, EmfPlusDrawBeziers tdf#107019 (Bartosz Kosiorek),
- Add support for drawing Pie, which is used for circle charts, EmfPlusDrawPie tdf#107034 (Bartosz Kosiorek),
- Add support for translating of the current world, EmfPlusTranslateWorldTransform tdf#106084 (Bartosz Kosiorek),
- Draw an extra line between the last point and the first point, to close the shape, EmfPlusDrawLines tdf#39053 (Bartosz Kosiorek),
- Add support for scaling world, EmfPlusScaleWorldTransform tdf#106084 (Bartosz Kosiorek),
- Add support for drawing arc, EmfPlusDrawArc tdf#107034 (Bartosz Kosiorek)
- Add support for bold font, EmfPlusStringFormat (f9af0abce2c266a53f536a207a62bc691213f6a0) (Bartosz Kosiorek)
- Add support for converting page space coordinates to device space coordinates, SetPageTransform tdf#39327, tdf#47243, tdf#103639 (Bartosz Kosiorek)
Test image created by ChemDraw in LO 5.3, image is not visible at all
Test image created by ChemDraw in LO 5.4, image is displayed. Still some lines are shifted.
Reference test image created by ChemDraw in Office 365 (Ubuntu 16.10)
Improvements in the PDF filter
- LibreOffice now uses pdfium to render inserted PDF images. blog report 1, blog report 2 (Miklos Vajna - Collabora)
- Support for linked and embedded videos in the PDF export of Writer and Impress. blog entry (Miklos Vajna - Collabora)
Other filters
- Fix handling of BOM for plain text files tdf#63673 (Maxim Monastirsky)
- Fix export to .xlsx of FLOOR/CEILING functions tdf#100011 (Eike Rathke, Bartosz Kosiorek)
- Implement ADO rowset XML import filter tdf#106525 (Mike Kaganski - Collabora)
- Implement support for Web Query (.iqy) files tdf#106359 (Mike Kaganski - Collabora)
- Fix handling of Word 2013+ tables (table border aligns with margin and text is indented) tdf#106742 (Vitaliy)
GUI
Menu
- In Writer rename tdf#107573 (Yousuf Philips) ▸ to
Basic Editor
- The menu items are moved according to a general design concept. Close item was moved to up the first section of File menu. GoToLine item was moved from View menu to Edit menu under Find&Replace c7c0b8c2e818a4f59ef9003529673bdbfa8ad188 (Lera Goncharuk)
- Setting of the line numbering saves after restart. The line numbering is enabled by default. tdf#91913 (Lera Goncharuk)
Notebookbar (experimental)
- Toolbar with shortcuts was introduced in the tabbed Notebookbar. User can edit shortcuts using the Customization dialog: ▸ ▸ ▸ (Szymon Kłos)
- Notebookbar supports themes (Szymon Kłos)
Online
General
- Responsive design of the document iframe (Pranav Kant, Collabora)
- Read-only mode for the document iframe (Pranav, Kant, Collabora)
- Render all the glyphs in the character dialog on the server (Henry Castro, Collabora)
- Undo / Redo notification when there are conflicting edits (Henry Castro, Collabora)
- Notify the clients about server non-availability / recycling (Ashod Nakashian, Collabora)
- Initial Input Method support for complex languages (Pranav Kant, Collabora)
Performance
- Improve performance by avoiding compression of PNG compression of un-changed tiles, and by avoiding sending PNG's that are already at the client side (Michael Meeks, Collabora; Tor Lillqvist, Collabora)
- Substantial re-write of the WSD core to drastically simplify the code, improve threading - using mostly non-blocking I/O, improve maintainability and performance (Ashod Nakasian, Michael Meeks, Jan Holesovsky Collabora)
Writer
- Native comment rendering, with animations (Henry Castro, Collabora)
- Optional rendering of non-printing characters
- Change-tracking / red-lining support & rendering (Pranav Kant, Henry Castro, Collabora)
Calc
- Increased amount of rows available in the Online Calc to 10.000 (Marco Cecchetti, Collabora)
Localization
Additional languages in the language list
Available for text attribution.
- Manchu [mnc-CN]. tdf#105448 (Eike Rathke (Red Hat, Inc.))
- Xibe [sjo-CN]. tdf#105448 (Eike Rathke (Red Hat, Inc.))
- Kituba (Democratic Republic of the Congo) [ktu-CD]. (Eike Rathke (Red Hat, Inc.))
Incorporation of other languages
Our goal is to support as many languages as possible. We would like to thank the following people for voluntary translation into LibreOffice and helps in preserving their native languages:
- Michael Wolf has translated most of the user interface of LibreOffice into Upper Sorbian (hsb) and has started with the translation to Lower Sorbian (dsb). LibreOffice Online has been completely localized into Upper Sorbian and Lower Sorbian. LibreOffice is the first office suite available in the Sorbian language.
Improvements to proofing tools and language support
- Updated English spell-check dictionaries
- Updated Croatian spell-check dictionary
- Updated Polish spell-check dictionary and thesaurus
- Updated French spell-check dictionary and thesaurus
- The language list for text attribution now also displays BCP47 language tags provided by dictionaries if a language is not known in the predefined set of languages. (Eike Rathke (Red Hat, Inc.))
- Such additional language tags are placed in curly brackets / braces, for example
{en-DK}
, and are displayed at the top of the list after the[None]
entry.
- Such additional language tags are placed in curly brackets / braces, for example
- The grandfathered language tag
en-GB-oed
(deprecated since 2015-04-17) for Oxford English Dictionary spelling is now an alias ofen-GB-oxendict
tdf#100462. (Eike Rathke (Red Hat, Inc.))- en-GB-oxendict was already supported in earlier releases but not mapped to the list of predefined languages; both language tags now map to "English, OED spelling (UK)".
- Writing a document that previously contained text attributed with en-GB-oed the attribution is now written as en-GB-oxendict.
Scripting: Python and Basic
Access2Base updated
Access2Base, the Basic library for Base users, is now available in its version 1.7.0 (Jean-Pierre Ledure).
- Form, subform, dialog and control events can be dynamically got and updated with the new On (form-events), On (dialog-events) and On (control events) properties.
- The new module object class together with its properties and methods makes it easy to navigate through the Basic libraries attached to the current Base file or application.
Full documentation is available on the documentation website.
Python 3.5
On Windows, the bundled CPython has been updated to release 3.5, which was already shipping on other platforms since LO 5.1 - hence all TDF release platforms bundle Python 3.5 now.
Feature removal / deprecation
General
- Interface to Telepathy Tubes was removed
- Trinity Desktop Environment (TDE) integration is deprecated and will be removed in the next release
- Oxygen icon theme is no longer bundled by default
- The Linux Quickstarter is deprecated and will be removed in the next release
Writer
- The Web wizard (which exports a set of documents as html with an index and some styles from the last century) has been removed. Note that this doesn't affect the HTML export. tdf#99967 (Samuel Mehrbrodt, CIB)
Impress
- PlaceWare export filter was removed
Platform Compatibility
Mac
- macOS version 10.8 support is deprecated and the next release will require at least macOS 10.9.
Windows
- Windows XP SP3, Windows Vista SP2 are both deprecated. The 5.4 release will be the last with any support of these operating systems.
- Uwinapi is discontinued.
- Microsoft Visual C++ 2015 Redistributable is required for this release, and is not installed by LibreOffice installer (except for Windows XP). The redistributable is an OS component, that comes preinstalled with Windows 10, and with a Windows Update for Windows Vista through 8.1. If it is absent on user's system, it must be installed separately from Microsoft website. Installed redistributable's bitness (32- or 64-bit) must match LibreOffice's bitness (not OS bitness). Otherwise installation will succeed, but an error will be shown on program start: "The program cannot start because api-ms-win-crt-runtime-l1-1-0.dll is missing from your computer. Try to reinstalling the program to fix this problem".
- LibreOffice bitness is shown in ▸ (for 32-bit, simply "Version: 5.4.2.2" is shown; for 64-bit, "Version: 5.4.2.2 (x64)"). It is OK to install both 32- and 64-bit redistributable on single 64-bit OS in case of doubt.
API changes
Removed configuration options
- The
/org.openoffice.Office/Common/Help/HelpAgent
configuration schema was removed 49b237c46efa1ba3513dfbe6c782c713296352d8 - The
/org.openoffice.Office/WebWizard
configuration schema was removed 5b3022860abfe7eefd2e25b60b5b2a563b42b3c0 - The
/org.openoffice.Office/Common/VCL/TextLayoutEngine
configuration schema was removed e838d143178ee82c786d11fd792d8d6735858933
C++ UNO language binding and URE libraries
- SAL macro
SAL_ABS
is removed. b55c205460fe7e7b133e179cd567764df7ac3508 - SAL macro
SAL_CONSTEXPR
(that had an empty expansion in client code) is removed. No client code should be affected. 5742868ccf030b2c0f03538d030bd18bd5666bdb - All dynamic exception specifications are removed from all URE include files and from
cppumaker
-generated files. Dynamic exception specifications have been deprecated since C++ 11 and will be removed completely from C++ 17. Note thatthrow ()
is not a dynamic exception specification, and its uses are retained. (Theoretically, dynamic exception specifications on any destructors or deallocation functions would have had to be replaced with C++ 11-onlynoexcept(false)
, but there are none in any URE include files nor wouldcppumaker
emit such.) Consequently, no longer necessary#include
s have been removed fromcppumaker
-generated files, which may cause client code to no longer compile (to fix, add the missing#include
s to the client code).
UNO API changes
- Synchronous dispatch of macro loader (
com.sun.star.comp.sfx2.SfxMacroLoader
) used to return emptyUno::Any
in case an error occurred running the macro (and whatever value macro returned otherwise). It now returns singlebeans::PropertyValue
containing the actual error code e.g.{ "ErrorCode" => 0x42 }
- These logging related interface and services were removed:
com.sun.star.logging.DocumentIOLogRing
com.sun.star.logging.SimpleLogRing
com.sun.star.logging.XSimpleLogRing
169bd7718264b0e312052757f9bbd2321e1399c2
- Some unused and unimplemented XML cryptography related interfaces were removed:
com.sun.star.xml.crypto.XMLEncryptionTemplate
com.sun.star.xml.crypto.XMLSignatureTemplate
com.sun.star.xml.crypto.sax.Decryptor
com.sun.star.xml.crypto.sax.Encryptor
com.sun.star.xml.crypto.sax.SAXEventKeeper
com.sun.star.xml.crypto.sax.SignatureCreator
com.sun.star.xml.crypto.sax.SignatureVerifier
a4af8986c94ff2d1bea0c21f798330efcc97b133
The following UNO interfaces and services were changed:
- Added certificate kind (X509 or OpenPGP) to
security::XCertificate
3e3b37ca4cbc881628a71715b67ac172018cf9f2
com.sun.star.ui.test.XUITest
3c979a362b59b87dee62c85403c3c1f28f59f951 aa10a19c8e56a51654bcb26f718f6e7187159c72 4c02332d3d60de7a166d10413edf6e76b85d5a91
com.sun.star.awt.UnoControlComboBoxModel
com.sun.star.awt.UnoControlListBoxModel
838fab822c8052dd9471e28a70b1907dfde111af
com.sun.star.chart2.data.XDataReceiver
8cc8ffdb04f9915c5b7dddd619ef89762c7a40c2
SDK changes
- The
salcpprt
static library (that could be linked into executables, containing replacements of globaloperator new
/delete
forwarding tortl/alloc.h
) is removed. cfd2691e5bf398304d7816227b933e53907b6204 - On macOS, the
OO_SDK_JAVA_HOME
path (as auto-determined bysetsdkenv_unix
) now points at the JDK’sHome
sub-directory, for consistency with other platforms. If you have a special setup to reuse a singlesetsdkenv_unix.sh
across multiple versions of the SDK, you will need to adapt that. Also, the Make variableJAVABIN
has become unused and was removed fromsettings.mk
(on all platforms). c306c444bfd3d0984741fd99ed4f29016ef14ee2