Libreoffice Xp

• Libreoffice Export To Epub
• Libreoffice Export To Excel
• Libreoffice Xp Support
• Libreoffice Xps File
• Libreoffice Xpath

7.0.5 This version is slightly older and does not have the latest features, but it has been tested for longer. For business deployments, we strongly recommend support from certified partners which also offer long-term support versions of LibreOffice. LibreOffice 7.0.5 release notes.

LibreOffice Suite 2021 Home Student Professional & Business Compatible With Microsoft Office Word Excel & PowerPoint Software CD for PC Windows 10 8.1 8 7 Vista XP 32 & 64 Bit, Mac OS X and Linux. LibreOffice for Windows XP (32/64 bit) LibreOffice for Windows XP - office suite of programs designed to work with tabular, textual, graphical data. The application package is distributed among the three main popular platforms, allowing you to work with most modern extensions.

• Article Title: ReleaseNotes/5.4

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 commit 0425ccba5b2f8819d6fade05d96a72d64db1ce0c (Jan Holešovský - Collabora)

• New formatting toolbar focused on the use of styles is accessible through View ▸ Toolbars ▸ Formatting (Styles). tdf#106781 (Yousuf Philips)

• Custom Watermark inserting in Format ▸ Watermarks. 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 commit 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 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)

• 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

• New feature - Pivot Charts tdf#83257: blog 1, blog 2, blog 3 (Tomaž Vajngerl, Collabora)

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.

Core / General

• The standard color palette was updated. tdf#87538blog 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 ChemDrawtdf#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 (commit 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 in LO 5.3, labels and circuit elements are not correctly placed,

• Test image in LO 5.4, labels and circuit elements are correctly placed. Still rotating support needs to be implemented

• Reference test image from XnView (Wine 1.8.5)

• 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 Tools ▸ Outline Numbering to Chapter Numberingtdf#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 commit 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)

• 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)

• LibreOffice Online

• Responsive design

• Readonly mode

• 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-oxendicttdf#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 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.

Libreoffice Export To Epub

API changes

Removed configuration options

• The /org.openoffice.Office/Common/Help/HelpAgent configuration schema was removed commit 49b237c46efa1ba3513dfbe6c782c713296352d8
• The /org.openoffice.Office/WebWizard configuration schema was removed commit 5b3022860abfe7eefd2e25b60b5b2a563b42b3c0
• The /org.openoffice.Office/Common/VCL/TextLayoutEngine configuration schema was removed commit e838d143178ee82c786d11fd792d8d6735858933

C++ UNO language binding and URE libraries

Libreoffice Export To Excel

• SAL macro SAL_ABS is removed. commit b55c205460fe7e7b133e179cd567764df7ac3508
• SAL macro SAL_CONSTEXPR (that had an empty expansion in client code) is removed. No client code should be affected. commit 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).

• 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

• New feature - Pivot Charts tdf#83257: blog 1, blog 2, blog 3 (Tomaž Vajngerl, Collabora)

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.

Core / General

• The standard color palette was updated. tdf#87538blog 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 ChemDrawtdf#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 (commit 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 in LO 5.3, labels and circuit elements are not correctly placed,

• Test image in LO 5.4, labels and circuit elements are correctly placed. Still rotating support needs to be implemented

• Reference test image from XnView (Wine 1.8.5)

• 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 Tools ▸ Outline Numbering to Chapter Numberingtdf#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 commit 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)

• 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)

• LibreOffice Online

• Responsive design

• Readonly mode

• 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-oxendicttdf#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 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.

Libreoffice Export To Epub

API changes

Removed configuration options

• The /org.openoffice.Office/Common/Help/HelpAgent configuration schema was removed commit 49b237c46efa1ba3513dfbe6c782c713296352d8
• The /org.openoffice.Office/WebWizard configuration schema was removed commit 5b3022860abfe7eefd2e25b60b5b2a563b42b3c0
• The /org.openoffice.Office/Common/VCL/TextLayoutEngine configuration schema was removed commit e838d143178ee82c786d11fd792d8d6735858933

C++ UNO language binding and URE libraries

Libreoffice Export To Excel

• SAL macro SAL_ABS is removed. commit b55c205460fe7e7b133e179cd567764df7ac3508
• SAL macro SAL_CONSTEXPR (that had an empty expansion in client code) is removed. No client code should be affected. commit 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.DocumentIOLogRingcom.sun.star.logging.SimpleLogRingcom.sun.star.logging.XSimpleLogRingcommit 169bd7718264b0e312052757f9bbd2321e1399c2

• Some unused and unimplemented XML cryptography related interfaces were removed: com.sun.star.xml.crypto.XMLEncryptionTemplatecom.sun.star.xml.crypto.XMLSignatureTemplatecom.sun.star.xml.crypto.sax.Decryptorcom.sun.star.xml.crypto.sax.Encryptorcom.sun.star.xml.crypto.sax.SAXEventKeepercom.sun.star.xml.crypto.sax.SignatureCreatorcom.sun.star.xml.crypto.sax.SignatureVerifiercommit a4af8986c94ff2d1bea0c21f798330efcc97b133

The following UNO interfaces and services were changed:

Libreoffice Xp Support

• Added certificate kind (X509 or OpenPGP) to security::XCertificatecommit 3e3b37ca4cbc881628a71715b67ac172018cf9f2

• com.sun.star.ui.test.XUITestcommit 3c979a362b59b87dee62c85403c3c1f28f59f951commit aa10a19c8e56a51654bcb26f718f6e7187159c72commit 4c02332d3d60de7a166d10413edf6e76b85d5a91

• com.sun.star.awt.UnoControlComboBoxModelcom.sun.star.awt.UnoControlListBoxModelcommit 838fab822c8052dd9471e28a70b1907dfde111af

Libreoffice Xps File

• com.sun.star.chart2.data.XDataReceivercommit 8cc8ffdb04f9915c5b7dddd619ef89762c7a40c2

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. commit 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). commit c306c444bfd3d0984741fd99ed4f29016ef14ee2

Libreoffice Xpath