LibreOffice 5.4: Release Notes

    From The Document Foundation Wiki

    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).
    EditCurrentSection.png
    • 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)
    Contextual footendnote.png
    Greatly improve the export of bullets & numbering.png
    • New formatting toolbar focused on the use of styles is accessible through View ▸ Toolbars ▸ Formatting (Styles). tdf#106781 (Yousuf Philips)
    New toolbar formatting styles
    • Custom Watermark inserting in Format ▸ Watermarks. blog entry (Szymon Kłos - Collabora)
    Watermark dialog full.png
    • Styles submenu was added to Context Menu, which includes basic character styles. tdf#102915, tdf#85940 (Yousuf Philips)
    New submenu Styles in context menu Writer
    New AutoCorrect markup options in Writer
    • 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
    • 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 buttons for priority of rules conditional formatting
    • New cell comment commands added
      • Comments toggle command to show/hide all comments on currently selected sheet(s) added to View ▸ Comments. tdf#107258 (Gülşah Köse, Eike Rathke)
      • Delete All Comments commands available under menu Sheet ▸ Cell Comments acting on the currently selected sheet(s) tdf#107143 (Gülşah Köse)
      • 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 Edit ▸ Cell Protection to change the protection status of the cell. tdf#95885 (Gülşah Köse)
    • 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)
    New sheet protection options.
    • Cell styles now accessible in their own dedicated Styles menu in Format ▸ Styles. 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

    Pivot Charts

    Math

    • Implement context menu edit commands: cut, copy, paste for the Formula command input panel tdf#106479 (Maxim Monastirsky)
    Context menu edit commands: cut, copy, paste for the Formula command input panel

    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.

    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):
    Document with invalid signature

    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)

    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 BOMWikipedia logo v3.svg 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 Tools ▸ Outline Numbering to Chapter Numbering tdf#107573 (Yousuf Philips)

    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: Tools ▸ Customize... ▸ Toolbars ▸ Notebookbar shortcuts (Szymon Kłos)
    Tabbed Notebookbar with shortcuts
    • Notebookbar supports themes (Szymon Kłos)
    Notebookbar with blue theme

    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.
    • The grandfathered language tag en-GB-oed (deprecated since 2015-04-17) for Oxford English Dictionary spelling is now an alias of en-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.

     

    Note pin.svg

    If you speak an endangered language and want to help us to achieve our goal of providing free tools for every single person on Earth, please join us.

     

    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 Help ▸ About (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

    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 that throw () 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-only noexcept(false), but there are none in any URE include files nor would cppumaker emit such.) Consequently, no longer necessary #includes have been removed from cppumaker-generated files, which may cause client code to no longer compile (to fix, add the missing #includes to the client code).

    UNO API changes

    • Synchronous dispatch of macro loader (com.sun.star.comp.sfx2.SfxMacroLoader) used to return empty Uno::Any in case an error occurred running the macro (and whatever value macro returned otherwise). It now returns single beans::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:

    SDK changes

    • The salcpprt static library (that could be linked into executables, containing replacements of global operator new/delete forwarding to rtl/alloc.h) is removed. cfd2691e5bf398304d7816227b933e53907b6204
    • On macOS, the OO_SDK_JAVA_HOME path (as auto-determined by setsdkenv_unix) now points at the JDK’s Home sub-directory, for consistency with other platforms. If you have a special setup to reuse a single setsdkenv_unix.sh across multiple versions of the SDK, you will need to adapt that. Also, the Make variable JAVABIN has become unused and was removed from settings.mk (on all platforms). c306c444bfd3d0984741fd99ed4f29016ef14ee2