LibreOffice 7.0: Release Notes

    From The Document Foundation Wiki



    Writer

    • Actually not limited to lists; e.g., page numbering may also use padding (ODT only).
    Padded numbering in Writer
    • Bookmarks and Fields can now be protected to prevent accidental changes to them (See Tools ▸ Protect Document) (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)
    Semi-transparent text in Writer
    • Bookmarks can now be displayed in-line in the text, controlled by Standard Toolbar ▸ Toggle Formatting Marks and Tools ▸ Options... ▸ LibreOffice Writer ▸ Formatting Aids ▸ Bookmarks tdf#45589 4ce8120f1 04405edc3 (Michael Stahl, CIB)
    Bookmark positions in the text
    • 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)

    Navigator

    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
    New features for 'Headings' section items
    Possibility to select the entire section

    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)

    Transliteration of “Székely írás 2020-ban” (“Szekler script in 2020”)

    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:

    • Tools ▸ Options... ▸ LibreOffice ▸ Advanced ▸ Optional Features ▸ Enable experimental features (may be unstable)
    • Restart LibreOffice

    You can then find the accessibility check tool in Tools ▸ Accessibility Check..., and the PDF/UA export option in File ▸ Export As ▸ Export as PDF... ▸ Universal Accessibility (PDF/UA).

    Accessibility check tool in action
    Option to create a universal accessibility-compliant PDF file that follows the requirements of PDF/UA (ISO 14/289) specifications. The "Tagged PDF" option is automatically ticked.

    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)
    SubscriptReport 7.0.png
    • Implemented support for semi-transparent text in Draw/Impress. More info in this blog post (Miklos Vajna, Collabora)
    Semi-transparent text in Draw
    • 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

    • Added RGB personalized color. You should use syntax like color rgb 0 100 0 { your_symbols } in Formula editor. That "color" is available in Element's Attributes pane too tdf#40436 (Dante DM)
    • Added a Laplace transform symbol tdf#47914 (Dante DM)

    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

    Gallery

    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.

    YouTube privacy policy

    • 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
    • New config option to prevent disabling readonly mode tdf#101652 (Samuel Mehrbrodt, CIB)
      • Look for AllowEditReadonlyDocs in Expert config
    • New option to disallow opening files locked by other users (Samuel Mehrbrodt, CIB)
      • Look for AllowOverrideLocking in Expert config

    LibreOffice Help

    • Internet Explorer 11 is no longer supported for viewing the Help
    • New help pages for Property and Resume LibreOffice Basic statements as well as Err VBA object (Alain Romedenne).
    • Basic Syntax diagrams are starting to be included inside help pages (Alain Romedenne).
    Argument syntax in Function/Property/Sub
    • Help pages now have module brand color in the header (Olivier Hallot).
    Help pages with module color
    • 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 Tools ▸ Options ▸ Load/Save ▸ General ▸ ODF format version: "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. a541cd919 (Michael Stahl, CIB)

    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)
    Display of custom labels in charts

    Improvements of DOCX import/export filter

    • 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)
    Glow effect on objects

    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)
    Soft edges on objects

    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)
    Display of the improvements of the import of predefined PPTX table styles. On the left is the original MS Office slide. The screen in the middle displays the old behaviour, the one to the right the improved import.
    • 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

    Best Fit for macOS
    "Neo" Colibre icon theme reborn

    Dialogs

    • New icons and banner in Windows installer. tdf#130778 (Bayu Rizaldhan Rayes, Rizal Muttaqin, Muhammad Rivan)
    Installation First-en.png
    Installation Type-en.png
    Installation Progress-en.png
    • Renaming a page in Draw or slide in Impress with empty or already used name give a tool tip dialog. tdf#129032 (Heiko Tietze)
    Renaming Same Name Slide.png

    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.3
      Võ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: [1]

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

    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

    Filters

    Platform Compatibility

    Mac

    Support for macOS 10.10 and 10.11 is deprecated. Minimum runtime requirement will be raised in a future release.

    Windows

    Windows Default apps button was added to Options ▸ LibreOffice ▸ General, 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) releases tdf#44462 (Mike Kaganski, Collabora)

    Linux

    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, and unoil.jar are now combined into a single libreoffice.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, and unoil.jar are still present as empty stubs referencing the combined libreoffice.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

    API changes

    UNO API changes

    • 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