LibreOffice 7.2: Release Notes

From The Document Foundation Wiki
Jump to navigation Jump to search
This page is a translated version of the page ReleaseNotes/7.2 and the translation is 1% complete.
Other languages:
Bahasa Indonesia • ‎Deutsch • ‎English • ‎dansk • ‎español • ‎français • ‎italiano • ‎slovenščina • ‎čeština • ‎中文(中国大陆)‎ • ‎日本語 • ‎한국어

Acerca de esta página =


General improvements

  • Alphabetical Indexes, Tables of Contents and User-Defined Indexes will now generate clickable hyperlinks to Document Index Entry Marks core commit 7685c074 (Michael Stahl, allotropia)
Writer showing various indexes with mouse-over tooltip of a hyperlink to a document index entry mark
  • All background fills can now be set to either cover the page inside the margins or the entire page core commit 56d8007a (Michael Stahl, allotropia)
Writer showing pages with BackgroundFullSize on and off



General improvements

  • Calc shows blue row numbers for filtered rows by Autofilter. tdf#89841 (Tünde Tóth, NISZ)
  • Calc now highlights an active autofilter dropdown arrow tdf#140955 (Tünde Tóth, NISZ)
Calc shows a blue filtered row numbers and highlights an active autofilter dropdown arrow
  • AutoFilter dropdown button now scales according to sheet zoom level core commit 008c2354 (Szymon Kłos, Collabora)

New spreadsheet functions

Changed spreadsheet functions

  • CELL() now evaluates the top left cell of a given cell range argument as second parameter instead of the usual intersecting position for scalar parameters, for interoperability and compliance with the ODF OpenFormula standard definition. tdf#66409 (Eike Rathke, Red Hat)


  • Improved speed of pasting formulas with VLOOKUP function tdf#92456 (Noel Grandin, Collabora)

Impress & Draw

General improvements

  • The set of default templates was refreshed (tdf#138097 — Indonesian LibreOffice team and Heiko Tietze, TDF):
    • Removed: Alizarin, Bright Blue, Classy Red, Impress, Lush Green (introduced in 4.4)
    • Added: Candy, Freshes, Grey Elegant, Growing Liberty, Yellow Idea
Candy template
Freshes template
Gray Elegant template
Growing Liberty template
Yellow Idea template
  • All background fills can now be set to either cover the page inside the margins or the entire page core commit dda83832 (Michael Stahl, allotropia).
Impress dialog showing new "Background covers margins" checkbox

User Interface

  • Direct access to the document's scaling factor via statusbar in Draw tdf#66470 (Heiko Tietze, TDF)
Feedback of the scaling factor with context menu to change for this document




  • Adding series name to data series label is now possible tdf#94235 (Samuel Mehrbrodt, allotropia)
  • For "Moving average" trend line, the type can now be selected tdf#133423 (Samuel Mehrbrodt, allotropia)
    • Prior (default)
    • Central
    • Averaged Abscissa


Core / General

  • Selecting form fields inside a document is now possible using Alt+<Mnemonic>. tdf#139804 (Samuel Mehrbrodt, allotropia)
  • QR library was changed to zxing library. It will allow to create many types of 1D and 2D codes, like UPC-A, UPC-E, EAN-8, EAN-13, UPC/EAN Extension 2/5, Code 39, Code 93, COde 128, Codabar, ITF, QR Code, Data Matrix, Aztec, PDF 417, MaxiCode, RSS-14, RSS-Expanded tdf#139778 (Akshit Kushwaha)
  • SVM-Format was improved: When handling tdf#127471 I stumbled upon a never identified bug: When using ScaledText, the export to SVM is System-dependent due to the differing internal representation in the Font-MetafileAction. Thus, the SVM content differs if it was written on a Windows or non-Windows System, which leads to errors when exchanging SVM-based Metafiles between those systems (details in the task ([1]) ). Due to SVM being used partially as Metafile-Format in saved files (e.g. ODF variants), this was leading to 'strange' looking SWcaledText's. ScaledText is luckily not too often used, but e.g. heavily in Chart Labels which were most obviously hit by this. Since SVM is our own format, this could be enhanced by adding information to the SVM-Format in a backward compatible way. After the fix, all newly written SVM-Files can be exchanged now between LibreOffice Versions containing that fix without that error. For already existing files this is not always possible, see this Table ([2]) (2nd half) for details. (Armin Le Grand, allotropia)
  • EMF/WMF-Formats were improved: When handling tdf#127471 and correcting the SVM format (see above), I also found out that the same error is in the EMF/WMF files that we write. These formats are Windows-specific formats, what makes the versions written under Windows the valid ones. The definitions for EMF/WMF are not in our hands, so I had to fix that differently. A fix is not only important for flawless data exchange between LibreOffice Versions, but also with all kinds of Windows-Applications that use EMF/WMF as DataType. After the fix EMF/WMF is always produced in Windows-conform form for ScaledText. This leads to this working data exchange Table ([3]). (Armin Le Grand, allotropia)
  • Detect wrong written old EMF/WMF Files: To not have to accept old wrong written files, I added a kind of 'Old-Emf-Wmf-Format-Detector' that uses fuzzy evaluation and corrects old files when loaded in LibreOffice from now on. This makes the exchange between EMF/WMF written by old and new LibreOffice Versions complete: no old written files are lost or need to be reproduced. This is unfortunately not possible for other Windows-Applications, so these EMF/WMF files produced by older non-Windows LibreOffice Versions have - as a workaround - e.g. be loaded and rewritten by a LibreOffice Version containing these fixes. (Armin Le Grand, allotropia)

LibreOffice Help


Improvements of DOCX import/export filter

  • DOCX: import discarded headers/footers. Before the inactive DOCX headers/footers lost during import time. Now it can be restored by disabling the options “Same content on left and right pages” and “Same content on first page” on the Header and the Footer panes of the Page style. This is for improving the interoperability with other Office programs, e.g. supporting DOCX text document templates better. tdf#141158 (Attila Bakos, NISZ)
  • DOCX: rtlGutter is supported now. tdf#140343 (Miklos Vajna, Collabora)
  • DOCX: export NONE background for ParaBackColor. tdf#140336 (Justin Luth)
  • DOCX: fix lost tables in footnotes and endnotes by converting them to floating tables during the import, and removing floating at the DOCX export. tdf#95806, tdf#125877, tdf#141172 (László Németh, NISZ)
  • DOCX export: save header image once. Writer used to dump the same image file as many times as it was featured in different headers or footers in the document, bloating the .docx file size. tdf#118535 (Dániel Arató, NISZ)
  • DOCX table import: fix extra page break. tdf#140182 (Attila Szűcs, NISZ)
  • Improvements for better DOCX import/export. tdf#108518 (Justin Luth)
  • DOCX: fix handling for effect extent vs line width. tdf#138895 (Miklos Vajna, Collabora)
  • DOCX export: put fly before fieldmark start into its own run. core commit 3eced2d5 (Michael Stahl, allotropia)
  • DOCX import: fix missing tblPrEx border of first table cells. Now property set of a new cell is a copy of the table exception property set of the table row, as needed for the import of the table style inheritance. tdf#140957 (László Németh, NISZ)
  • DOCX export: always write title page in section props. Even if page description is not set we should try to mark title page because chaining of two page styles can not work for continuous sections. tdf#124678 (Vasily Melenchuk, allotropia)
  • DOCX export: fix missing page break. When an empty paragraph has both page break and section break, only the section break was exported to DOCX, the page break was not, while MSO needs that to show all page breaks. tdf#121666 (Attila Szűcs, NISZ)
  • DOCX import: fix frame direction. Frames used to be imported with zero rotation even if a w:textDirection tag explicitly called for a non-default orientation. tdf#97128 (Dániel Arató, NISZ)
  • DOCX import: fix slow endnote import by parsing endnotes.xml only once instead of parsing again and again for every endnotes. This was a serious performance problem for documents with hundreds of endnotes, where the endnote import took minutes instead of seconds. tdf#76260, tdf#120351 (László Németh, NISZ)
  • DOCX: fix page margins imported as border padding. Trying to import non-existing "none" borders of w:pgBorders zeroed page margins, removing their values to border padding. tdf#74367 (Attila Szűcs, NISZ)
  • DOCX import: preserve formatting of CREATEDATE fields. The create date of a document doesn't really change, so we can only loose if the cached result of the field is not preserved. tdf#134592 (Miklos Vajna, Collabora)
  • DOCX table import: fix zero para top margin when only w:beforeAutospacing=0 was specified, but not PARA_TOP_MARGIN (see default_spacing = -1 in processing of LN_CT_Spacing_beforeAutospacing). tdf#137655 (László Németh, NISZ)
  • DOCX: added import/export support for Hebrew/Arabic numbering Types tdf#141341 (Justin Luth)

Improvements of XLSX import/export filter

  • XLSX import: set filtered flag for rows hidden by AutoFilter to support copying the result of filtering. Unlike ODS and XLS, XLSX doesn't differentiates filtered and manually hidden rows, and without this fix, copy of the unupdated data of the loaded filtering contained the hidden rows, too. tdf#99913 (Tünde Tóth, NISZ)
  • XLSX import: fix lost rounded filters if the stored filter values are in the visible cell format (e.g. rounded values) instead of the original (editing) values. Now AutoFilter popup window shows the items according to the visible cell format (e.g. 1.0 instead of 1.01 or 0.99), but still grouping them based on the "editing format" (e.g. not rounded values which visible during editing), i.e. there could be repeated values in the filtering conditions (e.g. two options "1.0" and "1.0" for 1.01 and 0.99). tdf#140968, tdf#140978 (Balazs Varga, NISZ)
  • XLSX import: fix missing datetime filters by convert string representation of the datetime data to ISO 8601 (with blank instead of T) datetime to eliminate locale dependent behaviour when filtering for datetimes. tdf#137626 (Balazs Varga, NISZ)
  • XLSX import: apply more than 8 filters in OOXML autofilter import by removing the artificial limit (which looked like the limit for conditions handled by the standard filter in LO, but not for the autofilter). Now the autofilter popup menu does not always select all items, if the document contained more than 8 selected items there. tdf#140469 (Balazs Varga, NISZ)
  • XLSX import: fix conditional formatting in same cell range. Multiple conditional formatting rules of the same cell range were imported incorrectly because of missing handling of their (different) priorities and operators. tdf#139928 (Nagy Tibor, NISZ)
  • XLSX export autofiltered date columns. Export XML_dateGroupItem, XML_year, XML_month, XML_day, XML_dateTimeGrouping based on the OOXML standard. tdf#139809 (Balazs Varga, NISZ)
  • XLSX export: fix proliferation of conditional styles. Run-time created styles “ExtConditionalStyle_N N” for extended conditional styles were written back to the XLSX file, growing the cell style list by each save-reload with unused styles. tdf#139167 (Nagy Tibor, NISZ)
  • XLSX import: fix autofiltered date columns by importing dateGroupItem. tdf#116818 (Balazs Varga, NISZ)
  • XLSX export: fix lost file names in modified links. tdf#138832 (Attila Szűcs, NISZ)
  • XLSX export: fix position of rotated images tdf#139258 (Szabolcs Toth, NISZ)
  • XLSX import: fix "Formula is" type conditional formatting rule when the formula contains a reference to another worksheet. {tdf|113013}} (Nagy Tibor, NISZ)
  • XLSX export: remove extra quotation marks. tdf#139394 (Nagy Tibor, NISZ)
  • XLSX: fix "begins/ends with" conditional formatting when using "Given text" type and cell reference. tdf#120749 (Nagy Tibor, NISZ)
  • XLSX export: fix "contains" conditional formatting when using "Given text" type with cell reference instead of fixed string. Fix also "notContainsText", and prepare the fix for "beginsWith", "endsWith" and "expression" type conditions. tdf#139021 (Nagy Tibor, NISZ)

Improvements of PPTX import/export filter

  • PPTX import: fix WordArt effect textDeflate and textInflateTop. These effects were mapped incorrectly, resulting missing display and after ODP round-trip, changed effects. tdf#125560 (Gabor Kelemen, NISZ and Regina Henschel)
  • PPTX import: fix lost direct hyperlink colors. tdf#137367 (Nagy Tibor, NISZ)
  • PPTX table export: fix vertical alignment. tdf#131905 (Nagy Tibor, NISZ)
  • PPTX wordart 3D, add sp3d. tdf#140865 (Regina Henschel)

Improvements of WMF/EMF filter

  • EMF PAINTRGN record is implemented and displayed correctly now tdf#55058 (Bartosz Kosiorek)


Icon theme


  • Templates dialog got a list view. You can sort templates by name, category, date, modules, size, etc. tdf#104154 (Vert D.)
Templates dialog list view



New languages/locales with locale data

Additional languages in the language list

Available for text attribution.

  • Pali Thai {pi-Thai} in the CTL language list. tdf#139607 (Eike Rathke, Red Hat)
  • Cabécar {cjp-CR} and Bribri {bzd-CR}. tdf#138839 (Eike Rathke, Red Hat)

Incorporation of other languages




Feature Removal / Deprecation

Platform Compatibility



  • You can now use wildcards when converting documents from command line. tdf#48413 (Deborah Barkley-Yeung)
For example, the following command converts all documents with .doc extension in C:\Docs\In\ directory to ODF format:
    soffice.exe --headless --convert-to odf --outdir C:\Docs\Out C:\Docs\In\*.doc
  • It was added a feature for default file format assotiation checking tdf#45735 (Matt K.)
A new dialog if some ODF file formats don't assotiate with LibreOffice


Java Support

API Changes

UNO API changes

  • XSystemTransferable interface was removed from CDOTransferable. It was only implemented for transferable objects on Windows; and its implementation was wrong, so unusable in any way core commit 818a84c4 (Mike Kaganski, Collabora)
  • Replace "No-width No Break" (uno:InsertZWNBSP) by "Word Joiner" (uno:InsertWJ) since it inserts U+2060 character tdf#140796 (Julien Nabet)

Configuration changes

SDK changes

Android Viewer

New features