ReleaseNotes/5.0/nl

About this page
KLAD - moet vertaald !

Emoji and in-word replacement support
Modern graphical operating systems have default Unicode 6 support with several Emojis and other useful special characters. LibreOffice 5 has got a new AutoCorrect extension to simplify Emoji and other Unicode character input using de facto standard Emoji shortcodes, and other keywords surrounded by colons. For example:  will be replaced by ⌨ (U+2328),   by 📷 (U+1F4F7),   by α. See the full shortcode list in (only in en-US in LibreOffice RC versions):



The colon-separated names are handled specially by AutoCorrect feature of LibreOffice: they are replaced immediately within words, too (no need to press space after words). This is useful to add custom character replacements for typography, phonology, etc. Some of the them are there in the default replacements:

:--: → – (n-dash, U+2013) :---: → — (m-dash, U+2014) :x: → × (times, U+00D7) :': → ’ (apostrophe, U+2019) :inch: → ″ inch (U+2033)

Or for repeated replacements:



The shortcodes will be localized for the final version of LibreOffice 5.0 (see more).

Voorbeeld van Opmaakprofielen in de Zijbalk
Het paneel Stijlen en opmaak van de Zijbalk geeft nu een voorbeeld van de beschikbare opmaakprofielen. (Tomaž Vajngerl, Collabora)

Word-compatibile tekstmarkering

 * Zowel markeringen als schaduwen worden behouden, tijdens import/export van Microsoft Word-documenten. (Tamás Zolnai)
 * Nieuwe compatibiliteitsoptie om aan te geven hoe LibreOffice de achtergrond van tekens naar Microsoft Office-bestandsformaten moet exporteren: als markering of als schaduw. (Tamás Zolnai)
 * Om deze optie te gebruiken, ga naar . Bekijk voor meer informatie deze blog



Afbeelding bijsnijden
Het is nu mogelijk om een afbeelding met gebruik van de muis bij te snijden. De actie is bereikbaar via het contextmenu: Afbeelding bijsnijden, menu en werkbalk Afbeelding. (Philippe Jung)

Standaard gedrag:
 * slepen vanuit het midden van een rand, snijdt alleen verticaal of horizontaal bij,
 * slepen vanuit een hoek, snijdt bij naar waar de muisaanwijzer zich bevindt,
 * slepen met ingedrukt, forceert een rechthoekige bijsnijding, die proportioneel is ten opzichte van de oorspronkelijke afmeting van de afbeelding.
 * bijsnijden is mogelijk tijdens het aanpassen van de afmetingen van de afbeelding,
 * de modus bijsnijden stopt als u op drukt of ergens buiten de bijgesneden afbeelding klikt.



Betere berekening van het getoonde paginanummer
Een ander probleem die van OpenOffice.org is geërfd - de statusbalk van Writer geeft, tijdens het scrollen, het verkeerde paginanummer weer - is in LibreOffice opgelost. Writer zal nu de pagina-indicator bijwerken, als er minder dan 43% van een pagina op het scherm zichtbaar is. Met dank aan: Hamidi Massinissa.

Tabelbeheer

 * Invoegen van rijen of kolommen wordt beïnvloed door preselectie van de gebruiker, vergelijkbaar met Calc. (Philippe Jung)
 * Mogelijkheid om rijen en kolommen vóór de huidige positie van de cursor toe te voegen, door middel van het contextmenu. (Philippe Jung, Yousuf Philips)

Verbeteringen aan werkbalken
Aanvullende verbeteringen zijn gemaakt aan de werkbalken “Standaard”, “Opmaak”, “Tekening” en contextuele werkbalken, om gebruikers van veelgebruikte opdrachten te voorzien. (Yousuf Philips)

DOC-verbeteringen
Import van geannoteerde tekstgebieden van binaire DOC-formaat was al geruime tijd een probleem, nu moet het zo goed zijn als het altijd was in de ODT/DOCX/RTF-filter. blog (Miklós Vajna, Collabora)

OOXML improvements
Improved support for the arcTo command in OOXML shapes described using drawingML. blog entry (Miklós Vajna, Collabora)

RTF improvements

 * Import of old-style (pre-2010 for RTF, pre-2007 for DOCX) math equations embedded into text documents should be now imported as editable embedded math objects. blog entry (Miklós Vajna, Collabora)


 * The RTF filter used to have a custom OOo-specific markup for describing hyphenation settings, not understood by Word. The specification gained controls words to describe hyphenation in the meantime, now the RTF filter uses those to describe hyphenation properties. (Miklós Vajna, Collabora)
 * Import part: ,
 * Export part: ,


 * The RTF importer now supports wrap distance picture properties (Miklós Vajna, Collabora)

Afbeeldingen slepen en neerzetten
Het slepen en neerzetten van afbeeldingen werkt nu in Writer op macOS. (Manik Malhotra)

Optional RSIDs
In case RSIDs are not useful in a workflow, they can now be disabled in. (Miklós Vajna, Collabora)



Calc

 * Itemlabels in Draaitabellen kunnen nu worden herhaald. Dit is optioneel. Als u een Draaitabel maakt, dubbelklik op het gewenste veld in de lijst "Rijvelden". Klik, in het dialoogvenster Gegevensveld, op de knop Opties. Selecteer, in het volgende dialoogvenster "Herhaal itemlabels". Klik op OK. (Deena Francis) Schermafdruk

Voorwaardelijke opmaak

 * UI voor gegevensbalken met een vaste achtergrond. (feature zonder UI is al vanaf 3.6 beschikbaar) (Katarina Behrens)


 * UI voor gegevensbalken zonder de onderliggende waarden te tonen. (feature zonder UI is al vanaf 3.6 beschikbaar) (Katarina Behrens)


 * Minimale en maximale balklengtes voor gegevensbalken (beschikbaar voor verticale assen, ingesteld op Midden of Geen) (Benjamin Ni and Markus Mohrhard)


 * Exporteren van de opmaak van voorwaardelijke opmaak naar XLSX is gerepareerd. (Markus Mohrhard)


 * Import van gegevensbalken en kleuren voor kleurschaling kan met themakleuren omgaan. (Markus Mohrhard)


 * Import en export van definities van gebruikergedefinieerde pictogrammensets (bevat MSO extensies naar OOXML) (geen UI) (Markus Mohrhard)


 * Additionele pictogrammensets: 3 driehoeken, 3 sterren, 5 vakken (Markus Mohrhard)

Scientific Format and Number Format
(Laurent Balland-Poirier and Eike Rathke)


 * Engineering notation:
 * enable exponent multiple of 3 (or other value) with format : set the number of digits (  or  ) before decimal separator.
 * add format  to scientific format list in UI dialog  for all localizations.
 * replace checkbox with  for scientific formats.




 * General format using scientific, and default scientific format, keep 2 minimum digits (instead of 3) in exponent for all localizations.
 * Trend line equation with 1 minimum digit in exponent (instead of 3).
 * Add/remove decimal digits of scientific format: with buttons / ; with Sidebar: ; with UI dialog.
 * Allow variable decimal with format  for scientific numbers and   for numbers (decimal part can contain some   and then some  ). This format is now correctly saved in ODF files.
 * Sign of exponent can be skipped for positive exponent with format  (remove sign after  ). This format is now correctly saved in ODF files.

Table structured references
(Eike Rathke)
 * Table structured references in spreadsheet formula expressions are imported from OOXML spreadsheet documents.
 * Usable with defined database ranges, which OOXML tables (content of &lt;table&gt; elements) are imported to.
 * The following restrictions apply:
 * The column names must be present as cell content in the table's header row; column-header-less tables are not supported.
 * Saving to ODF or OOXML, structured references are not written, but transformed to A1 style reference notation instead. The references continue to work, but the table context is lost on export.
 * Saving to OOXML, the defined database ranges are not exported as &lt;table&gt; elements.
 * Saving to binary .xls (Microsoft Excel 97-2003 Format), formulas using table structured references are lost.

New spreadsheet functions

 * Changes related to FLOOR and CEILING spreadsheet functions. (Winfried Donkers and Eike Rathke)
 * The second parameter of FLOOR and CEILING is now optional, as defined by OpenFormula (ODFF).
 * Additional FLOOR.XCL and CEILING.XCL functions were introduced that expect only two parameters and both parameters have to be specified. When importing Microsoft Excel documents, their old FLOOR and CEILING functions are imported as FLOOR.XCL and CEILING.XCL
 * New functions FLOOR.MATH and CEILING.MATH were added for Microsoft Excel interoperability.  (Winfried Donkers)
 * Exporting to Microsoft Excel file formats, Calc FLOOR and CEILING are written as Excel FLOOR.MATH and CEILING.MATH, and Calc FLOOR.XCL and CEILING.XCL are written as Excel FLOOR and CEILING
 * Added ENCODEURL spreadsheet function for Microsoft Excel interoperability. (Winfried Donkers)
 * Added ERROR.TYPE spreadsheet function according to OpenFormula (ODFF) and for Microsoft Excel interoperability. (Winfried Donkers)

A:A / 1:1 entire column/row references
(Eike Rathke)
 * It is now possible to specify references to entire columns or rows using the A:A or 1:1 notation instead of A1:A1048576 or A1:AMJ1
 * Such references will be saved as A$1:A$1048576 or $A1:$AMJ1 to maintain interoperability with earlier releases and other applications reading ODF spreadsheet documents.
 * When reading from a document, A$1:A$1048576 or $A1:$AMJ1 are converted to A:A or 1:1 notation.
 * Note that for entire column references both row anchors have to be either absolute or relative, and for entire row references both column anchors have to be either absolute or relative to have the reference converted into A:A or 1:1 notation. Mixed absolute/relative anchors lead to a full range notation being displayed, e.g. A$1:A1048576 or A1:A$1048576 because Calc assumes the user did that on purpose.
 * Inserting rows/columns to or deleting rows/columns from entire column/row references keeps the anchored other axis' endpoints, in particular inserting rows in a column reference will not produce a #REF! error and deleting rows in a column reference will not move the last referenced row that number of rows up, contrary to the standard A1:A1048576 reference behaviour.
 * Standard absolute/relative reference addressing can be used, i.e. A:B, A:$B, $A:B and $A:$B are all valid references and imply the same different reference update mechanisms when copy&paste, fill, move and other spreadsheet editing operations affecting cell formula references are applied.

Een afbeelding bijsnijden, aanpassen en opslaan
(Philippe Jung)
 * Het is nu mogelijk om vanuit het menu, vanuit contextuele menu's en vanaf de werkbalk Afbeelding, een afbeelding met behulp van de muis bij te snijden, een afbeelding op te slaan en het door een andere afbeelding vanaf de schijf te vervangen.
 * Deze functies gedragen zich hetzelfde als die in Impress of Writer.
 * menu is als volgt bijgewerkt: er is nu
 * menu-item met Positie en grootte, Lijn, Vlak en Tekstattributen,
 * menu-item met Afbeelding bijsnijden, Bewerken met extern gereedschap, Afbeelding wijzigen, Afbeelding comprimeren en Afbeelding opslaan.



Verbeteringen aan werkbalken
Aanvullende verbeteringen zijn gemaakt aan de werkbalken “Standaard”, “Opmaak”, “Tekening” en contextuele werkbalken, om gebruikers van veelgebruikte opdrachten te voorzien. (Yousuf Philips)

Impress en Draw

 * Herindeling van werkbalken in Impress  (Yousuf Philips)


 * Herindeling van werkbalken in Draw  (Yousuf Philips)


 * Contextmenu's voor Afbeelding en vorm zijn verbeterd door minder belangrijke items er uit te verwijderen. (Yousuf Philips)


 * Het openklapvak voor Vulkleur is nu in de kleurselector in Impress en Draw geïmplementeerd. Blog entry  (Caolán McNamara, Red Hat)


 * Achtergrondkleur voor tekst in tekstvakken in Draw/Impress (GSoC 2014, Matteo Campanelli) (blog post) kan nu in de UI met een knop op een werkbalk of in de Zijbalk ingesteld worden. (Katarina Behrens, CIB)

Math

 * See also: Feature removal / deprecation

Trendlines

 * option is now also available for exponential trendlines. (Laurent Balland-Poirier)

PDF export supports Time-Stamp Protocol

 * Export to PDF now supports the Time-Stamp Protocol (IETF standard RFC 3161). The address of a Time-Stamp Authority can be specified in the security settings of PDF options (Tor Lillqvist, Collabora sponsored by Wilhelm Tux crowd-funding)

Adobe Swatch Exchange (.ase) support

 * Support for reading Adobe Swatch Exchange (.ase) color palettes. Handles CMYK, RGB, and grayscale color models. LAB colors are not yet supported, and are replaced by black during import. (, sponsored by LibreOffice users through FreedomSponsors.org) (Chris Laplante)

Maintaining invisible content in Emails

 * Option added to preserve document invisible content when sending a document by email. (Stephan Bergmann)

New import filters

 * Writer can now import Apple Pages files (Pages '09 and older), via libetonyek. (David Tardon)
 * Calc can now import Apple Numbers files (Numbers '09 and older), via libetonyek. (Anurag Kanungo, GSoC 2015)
 * This is only a preview. It is a loss of time to report bugs.
 * Draw can now import ClarisDraw and MacDraft (v. 1) files, via libmwaw. (Laurent Alonso)
 * Calc can now import Lotus 123 (wk3, wk4) and Quattro Pro files (wq1, wq2), via libwps. (Laurent Alonso)

Improvements in OOXML filter

 * Support for handling differences between OOXML written by MSO 2007 and the specification. (Markus Mohrhard)
 * Chart streams support MSO 2007 and OOXML conforming input now. (Markus Mohrhard)
 * Chart streams are exported according to OOXML spec and no longer according to MSO 2007 format. (Markus Mohrhard)

Improvements in MediaWiki export filter
Robert Buj made the following improvements to our MediaWiki export component:
 * Replace  with


 * Image
 * Add the alternative text in a image
 * Add support for image align with wrap='none'


 * Paragraph
 * Replace tags
 * Add support for background-color and font-color


 * Table
 * Cell
 * Use align element
 * Add support for background-color and font-color
 * If all cells have the same style then specify that in the row section
 * Table
 * Add support for table align and table width
 * Row
 * Fix new line at the end of the row
 * Header
 * Treat the header like the row


 * Text
 * Add support for background-color and font-color

Improvements in Keynote import filter

 * Correctly set text language. (David Tardon)
 * Import links. (David Tardon)
 * Fix import of tab stops. (David Tardon)
 * Fix import of simple cell text content, which was ignored previously. (David Tardon)
 * Import more text and paragraph formatting properties. (David Tardon)
 * Import document metadata. (David Tardon)
 * Fix a typo that caused all shapes being dropped from output. (David Tardon)
 * Import table borders. (Anurag Kanungo)

Improvements in MS Works import filter

 * Ask for text encoding if it cannot be determined. (Laurent Alonso)

Improvements in Freehand import filter

 * Drastically improve import of fills, strokes, embedded images, and embedded text. (Fridrich Strba)
 * Fix positioning of visible objects on the canvas. (Fridrich Strba)
 * Cover formats from Freehand 3.0 to Freehand 11. (Fridrich Strba)

General UI changes

 * Impress's user interface was improved to provide more space to the slide by hiding the text, shape and image formatting contextual toolbars.  (Yousuf Philips, Philippe Jung)


 * Draw's user interface was improved by hiding formatting contextual toolbars, aligning the shapes toolbar to the left to resemble other drawing applications, and with an expanded sidebar to provide access to formatting options. (Yousuf Philips; Jan Holešovský, Collabora)


 * The design of the display-toggling button in pane dividers has been updated to increase its visibility. (Tomaž Vajngerl)

Wijzigingen in de Zijbalk

 * Het gedeelte Diawissel in de Zijbalk van Impress is herschikt om beter gebruik van de ruimte te maken. (Katarina Behrens, Rishabh Kumar, Yousuf Philips)


 * De knoppen in de Zijbalk in Impress zijn in de volgende volgorde herschikt - Eigenschappen, Diawissel, Aangepaste animatie, Hoofdpagina's. (Yousuf Philips)


 * Secties van het paneel Eigenschappen in Calc zijn heringericht om onnodige features te verwijderen en het passend te maken op schermen met lagere resolutie. (Rishabh Kumar, Yousuf Philips)


 * De knoppen inspringing vergroten en verlagen zijn aan het gedeelte Inspringingen in Impress en Draw toegevoegd. (Maxim Monastirsky, Yousuf Philips)


 * De knoppen voor randen zijn aan de Zijbalk in Impress en Draw toegevoegd. (Maxim Monastirsky)

Improvements in Calc/Draw sheet tab controls
The following changes were made by Tomaž Vajngerl (Collabora):


 * The scroll buttons in Calc have been reduced to two: First and Last are removed, and Previous and Next can assume the functions of First and Last when pressing the key while clicking
 * The Add Sheet and Previous and Next buttons are displayed without borders.
 * The Add Sheet button is now in the left, so that users can click it repeatedly without chasing its changing position.
 * It is now possible to scroll the sheet tabs with the mouse wheel if the number of tabs overflows the bar’s space.



HiDPI changes

 * See also: Development/HiDpi


 * Scale menu icons (Tomaž Vajngerl, Collabora).
 * Multiply status bar width depending on DPI scale factor (Tomaž Vajngerl, Collabora).
 * Scale "add Sheet" button for Calc tabs (Tomaž Vajngerl, Collabora).
 * Scale drag-and-drop indicators in the aforementioned tab bar (Tomaž Vajngerl, Collabora).
 * Scale rulers according to DPI scale factor (Darcy Beurle).

Mouse cursor improvements in Windows

 * Many hardcoded cursors, drawn back in the StarOffice era to support now-obsolete Windows versions, were dropped in favor of native cursors, which have a more modern look.  (Rimas Kudelis)

Contextmenu's

 * Herindeling van het contextmenu voor Afbeelding.  (Yousuf Philips)
 * Herindeling van het contextmenu voor Tabel.  (Yousuf Philips)


 * Alle items voor directe opmaak zijn verwijderd, omdat ze al op werkbalken en in de Zijbalk beschikbaar zijn. (Yousuf Philips)
 * Plakbordfuncties (Knippen, Kopiëren, Plakken) zijn altijd zichtbaar. (Trent MacAlpine)
 * Items voor contextmenu's van werkbalken worden met kleine pictogrammen weergegeven. (Philippe Jung)
 * Contextmenu's voor werkbalken geven de naam van de corresponderen werkbalk weer. (Philippe Jung)



Nieuwe pictogrammenset, Breeze

 * Een nieuwe pictogrammenset, Breeze, is aan LibreOffice toegevoegd. Met dank aan: Uri Herrera (Nitrux, S. A.), Andreas Kainz (KDE e. V.), Jonathan Riddell (Kubuntu), Jan Holešovský (Collabora), Yousuf Philips, en Andrew Dent.

Updates to the Tango icon set
New icons by Alexander Wilms, Adolfo Jayme Barrientos and Yousuf Philips have been integrated into the main Tango theme. There are now fewer gaps, in which old-style Industrial icons were displayed.

Updates to the Sifr icon set
Cassandra Freund has fixed bugs and increased icon coverage for Sifr.

Expert Configuration usability improvements
The following changes were made by Palenik Mihály:
 * The settings are now searchable.
 * The table’s rows are displayed using alternate colors to facilitate scanning.

A brand new Guarani localization
LibreOffice’s user interface has been completely translated into Guarani (avañe’ẽ), the native language of the Paraguayan people. This groundbreaking work confirms the innovation pace of the LibreOffice project towards facilitating the use of technology for as many people as possible, which is one of the ethos of The Document Foundation. Special thanks go to Giovanni Caligaris (who is leading this effort), András Tímar (Collabora), Christian Lohmaier, and Eike Rathke (Red Hat).

New languages/locales with locale data
Available as default document language and for locale specific formatting.


 * Added Church Slavic [cu-RU] to language list and locale data. (Aleksandr Andreev and Eike Rathke)
 * Added Nyanja [ny-MW] locale data. (Eike Rathke)
 * Added Venetian [vec-IT] to language list and locale data. (Eike Rathke, it46.se/localegen data by veneto.abc)
 * Added Tigrigna (Ethiopia) [ti-ET] locale data. (Eike Rathke, it46.se/localegen data by kinfe)

Updated language proofing tools

 * The bundled Spanish spelling dictionary pack is updated to version 0.8. (Jacobo Aragunde Pérez)
 * The bundled Portuguese spelling dictionary pack is updated to version 15.4.4.1. (András Tímár)
 * The bundled French spelling dictionary pack is updated to version 5.3.2. (Olivier R.)
 * Several fixes were made to the Czech affix files. (Petr Gajdos and Tomáš Chvátal)

Other language initiatives
We aim to support as many languages as possible. We would like to thank the following people for volunteering to translate LibreOffice and help preserving their native tongues:
 * Chechen:
 * Kabyle: Hamidi Massinissa
 * Venetian: Alessandro Mocellin

Feature removal / deprecation

 * The obsolete, StarOffice-inherited option “Use system font for user interface” was removed. LibreOffice will always use the system’s font to display its user interface elements. Thanks to: Julien Nabet and Caolán McNamara (Red Hat).
 * Since the introduction of a new “Elements” docked pane in Math (in version 4.1), it was intended that it would replace the old, OOo-inherited “toolbox”, or floating pane, which was difficult to use and had visual problems in certain UI configurations (such as dark themes). This old element has finally been removed, thus streamlining the UI by removing redundancy. Thanks to: Julien Nabet and Adolfo Jayme Barrientos.
 * The ability to insert hyperlinks in the,  and  protocols was removed.  Thanks to: Tor Lillqvist (Collabora).
 * Vestigial support was dropped as well.  Thanks to: Adolfo Jayme Barrientos.

C++ UNO language binding and URE libraries
The following changes were done to the C++ UNO language binding and URE libraries:
 * the header files rtl/logfile.h and rtl/logfile.hxx where removed

UNO API changes
The following UNO interfaces and services were changed:

Writer

 * New Dispatch commands were created for Inserting in tables:
 * InsertColumsBefore : insert columns before the selected columns. If more than one column is selected, insert as many columns as selected.
 * InsertRowsBefore : insert rows before the selected rows. If more than one row is selected, insert as many rows as selected.
 * InsertColumsAfter : insert columns after the selected columns. If more than one column is selected, insert as many columns as selected.
 * InsertRowsAfter : insert rows after the selected rows. If more than one row is selected, insert as many rows as selected.
 * These commands should be now prefered to uno:InsertColumns and .uno:InsertRows. For compatibility with previous versions, in writer uno:InsertColumns and .uno:InsertRows are equivalent to uno:InsertColumnsAfter and .uno:InsertRowsAfter
 * The following Dispatch commands are now available in Writer:
 * .uno:CompressGraphic
 * .uno:ChangePicture
 * .uno.Crop

Calc

 * The following Dispatch commands are now available in Calc:
 * .uno:ChangePicture
 * .uno:SaveGraphic
 * .uno.Crop

UNO API removals
The following UNO interfaces and services were removed from the API:

Windows

 * A native, 64-bit Windows build is now available.
 * TDF release builds require Windows Vista or later.
 * Outlook and Outlook Express address book access will not be supported until a new maintainable driver is implemented (see and ).
 * The experimental Firebird database driver is not yet available.
 * For development information, look at Development/msvc-x86_64.

Android

 * Added basic editing capabilities. blog entry 1 2 3 4 5 (Miklos Vajna, Tomaz Vajngerl, Siqi Liu, Henry Castro, Kohei Yoshida, Jan Holesovsky - Collabora, sponsored by The Document Foundation and our generous donors)






 * For development information, see Development/BuildingForAndroid.