ReleaseNotes/4.3

Raise limit of characters in paragraphs
Raise the 16bit (65,535) characters limitation of Writer paragraphs to 32bit (2,147,483,647). Especially useful in locales where there is a requirement to record minutes of meetings in a single paragraph. , (Caolán McNamara)

Moved Navigation buttons
The Navigation buttons have been moved from below the scrollbar to the Find bar (Samuel Mehrbrodt, UX-Advise Team)

Increase/decrease font size buttons

 * Removed the 72 pt limitation of the Increase font button. (Maxim Monastirsky, Caolán McNamara)
 * Also added Increase/decrease font functionality to drawing objects. commit (Maxim Monastirsky)

DrawingML import/export
Brand new drawingML-based DOCX import/export filter for shapes and TextFrames. For more details, see this blog entry. (Miklos Vajna) Try this example DOCX document

Import/Export nested comments
Import and export of nested comments in the ODF, DOC, DOCX and RTF filters. (Oliver-Rainer Wittmann - Apache: ODF filter and DOCX import part, Miklos Vajna: DOCX export and RTF/DOC filter parts)

Proportion image scaling
Images are now scaled proportionally by default, free resizing is available holding. (Tomaž Vajngerl)

Solarized blue for Non-printing characters
Non-printing Characters are shown with "Solarized blue" color (currently not available on macOS). (Tomaž Vajngerl)

Relative text frame anchoring improvements
Multiple relations are now supported for relative text frames. For more details, see this blog entry. (Miklos Vajna)

Vertical alignment for text frames
Vertical alignment of text (and other content) is now supported for text frames. This can be set under the "Options" tab. (Zolnai Tamás)

Printing comments in margins
Comments can now be printed next to the text in the right margin as they appear on screen. Each page is scaled down in order to make space for the comments to fit on the underlying paper size. (Caolán McNamara)

Format all comments
The character properties of all comments can be set at the same time now in order to reformat all comments in a document at the same time. (Caolán McNamara)

Unicode-compliant soft hyphen handling
Soft hyphens can result non-standard hyphenation, according to the Unicode standard, and (soft hyphen based) hyphenation dialog window suggests these hyphenation points, too. (László Németh)

Non-standard hyphenation support in user-defined dictionaries
In the user-defined dictionaries, now it is possible to use a [] block instead of the = sign to specify character changes before the hyphenation break. Possible character changes: Note: also it is possible to complete the hyphenation of Dutch, Norwegian, Swedish, Catalan, Hungarian without the modification of the TeX-like hyphenation patterns, using a default shared user-defined dictionary file. (László Németh)
 * Extra characters, for example tug[g]gumi results the correct hyphenation “tugg- gummi” of the Swedish word “tuggummi”.
 * Character removing specified by a digit, for example paral·[1]lel results correct hyphenation “paral- lel” of the Catalan word “paral·lel”, removing one character before the break point.
 * Both removed and extra characters, for example cafee[2é]tje results correct hyphenation “café- tje” of the Dutch word “cafeetje”, removing two characters before the break point, and adding an extra one.

LibreLogo
Improvements of LibreLogo, the Logo-like programming environment of LibreOffice for graphic design and education:
 * Several user interface fixes
 * New PENTRANSPARENCY, FILLTRANSPARENCY commands to set transparency after PENCOLOR, FILLCOLOR usage
 * Color and transparency gradients are now supported via FILLCOLOR and FILLTRANSPARENCY commands. (introduction)
 * For additional information, see the new portal for LibreLogo news and examples: LibreLogo.org

Smarter highlighting of cell in a formula

 * Border highlight on multiple instances of the same cell, when selecting a formula, now get same color. After calculating a long formula, the cells can be easily referenced with the formula, as they get the same color i.e., the highlight of the cell and the name of the cell in the formula. (Rachit Gupta)

Number selected rows and columns in status bar

 * When selecting cells, the number of selected rows and columns is shown in the status bar. (Manmeet Singh)
 * Sheet tab area: when expanding the space available for sheet tabs make better use of that. (Michael Meeks)

Start cell edit with content of cell above

 * Allow starting of cell edit with the content of the cell above it as its initial content. It is bound to the (single quote) key by default. (Note: On some locales this keyboard shortcut may conflict with the system default shortcuts.  If the default shortcut does not work due to conflict, bind it to a different shortcut). (Kohei Yoshida)

User selectable text conversion models
Under in  the user can select how textual cell content shall be treated in arithmetic operations. See also this blog entry for some details. and related (Eike Rathke)

Pivot Table layout improvement
"Data" field is now on columns by default, and can be moved to rows if needed. This makes it much faster to generate useful pivot tables from large data sources. (Tomaž Vajngerl)

Formula engine

 * Added GAMMA.DIST, GAMMA.INV and GAMMALN.PRECISE spreadsheet functions for Excel interoperability. (Winfried Donkers)
 * Added LOGNORM.DIST, LOGNORM.INV, NORM.DIST, NORM.INV, NORM.S.DIST and NORM.S.INV spreadsheet functions for Excel interoperability. (Winfried Donkers)
 * Added T.DIST, T.DIST.2T, T.DIST.RT, T.INV, T.INV.2T and T.TEST spreadsheet functions for Excel interoperability. (Winfried Donkers)
 * Added PERCENTILE.EXC, PERCENTILE.INC, PERCENTRANK.EXC, PERCENTRANK.INC, QUARTILE.EXC, QUARTILE.INC, RANK.EQ and RANK.AVG spreadsheet functions for Excel interoperability. (Winfried Donkers)
 * Added MODE.SNGL, MODE.MULT, NEGBINOM.DIST and Z.TEST spreadsheet functions for Excel interoperability. (Winfried Donkers)
 * Added FLOOR.PRECISE, CEILING.PRECISE and ISO.CEILING spreadsheet functions for Excel interoperability. (Winfried Donkers, Eike Rathke)
 * Added NETWORKDAYS.INTL and WORKDAY.INTL spreadsheet functions for Excel interoperability. (Winfried Donkers)
 * Added ERF.PRECISE and ERFC.PRECISE spreadsheet functions for Excel interoperability. (Winfried Donkers)

Enable CoinMP solver
Previously LibreOffice shipped the lpsolve solver, now we can build both the lpsolve and coin-mp solvers. (Matúš Kukan)

Statistics Wizard (alternative to Excel's Add-in "Analysis ToolPak")
In Statistics Wizard
 * added Two factor Analysis of Variance (ANOVA) (Tomaž Vajngerl)
 * added F-test. (Tomaž Vajngerl)
 * added t-test. (Tomaž Vajngerl)

Random number generation
In random number generation dialog box, now user can optionally limit the number of decimal places in the generated random number. (Tomaž Vajngerl)

Number of Pages
Hidden slides are no longer included in the “Number of pages” counting field, to avoid confusion. (J. Fernando Lagrange)

Fit slide to window
Add an icon to the statusbar to allow fitting the current slide to window with a single click. (Caolán McNamara)

Slide Pane selected/unselected slides with mouse over
It is now possible to distinguish between selected and unselected slides when the mouse over highlight activates. (Caolán McNamara)

3D models
LibreOffice now supports inserting 3D models in the glTF format into presentations (using libgltf). To use this feature, go to. Currently this option is available for Windows and Linux. (Zolnai Tamás, Jan Holesovsky, Markus Mohrhard).

Document including duck model.
 * Static model: Duck

Document including monster model.
 * Animated model: Monster

Limited support for 3D models in *.dae and *.kmz formats (using collada2gltf). (Zolnai Tamás, Matúš Kukan).

For more information about 3D model support see this blog post.

Base

 * LibreOffice bundles a new version of Access2Base, see Scripting / Base for details.

Property Mapping
Added property mapping functionality for charts, allowing to change data series properties based on spreadsheet values. For more details see this blog entry (Markus Mohrhard)

Accessibility

 * On Windows, IAccessible2 is now the only assistive technology support option. Support for the Java Accessibility Bridge has been removed, and turning on experimental features is no longer necessary in the Advanced options to enable assistive technology support.
 * Added new, specialized roles for specific text, spreadsheet and presentation documents. (blog post) (Jacobo Aragunde)
 * Improve mapping of ATK and LibreOffice roles, matching new(ish) ATK roles with existing UNO ones. (blog post) (Jacobo Aragunde)
 * Expose the role change between a heading and a paragraph through a new UNO accessibility event. (blog post) (Jacobo Aragunde)
 * Remove unnecessary text-attributes-changed events when typing. (Jacobo Aragunde)
 * Notify misspelled words to accessibility. (Jacobo Aragunde)
 * Use quick help text as the accessible name for toolbar buttons if not explicitly set. (Jacobo Aragunde)

VCL (GUI Toolkit)

 * Major refactoring and cleanup of the VCL code (Chris Sherlock)

CUPS, fax machines and spadmin
LibreOffice will now autodetect that fax4CUPS printers are fax machines and prompt for the fax number to use when you print to them. Multiple numbers, separated by commas, can be entered. Other printer drivers that contain custom options which can take arbitrary text or numbers are now supported. So to set the phone number for printer drivers for fax machines that utilize a custom option for that purpose the number can be entered in the device tab of the printer properties. The graphical utility spadmin is now removed in favor of these new features and the operating system's standard printer administration tools. (Caolán McNamara)

Improved PDF import

 * Import Line Join and Cap. (Vort, Sponsored Feature)
 * Improve display and editing of rotated text., (Vort, Sponsored Feature)
 * Correctly detect whitespace. (Vort, Sponsored Feature)
 * Correctly detect colors. (Vort, Sponsored Feature)
 * Correctly position rotated text. (Vort, Sponsored Feature)
 * Fix problem with lines getting stacked. (Vort, Sponsored Feature)
 * Add dashes support. (Vort, Sponsored Feature)

Improved OOXML support

 * Initial import support for OOXML Strict in the DOCX, XLSX and PPTX formats. For more details, see this blog entry. (Markus Mohrhard, Miklos Vajna)
 * Theme fonts support: detect and render the proper fonts and preserve font theme attributes. Details in this blog entry. (Jacobo Aragunde)
 * Preserve theme colors on fonts, paragraphs and table cells. (Jacobo Aragunde, blog entry)
 * Preserve style attribute on shapes and tables. (Jacobo Aragunde)
 * Preserve line and fill theme colors on shapes, including color transformations. (Jacobo Aragunde, blog entry)
 * Preserve gradient shape fill, although the render is not accurate the gradient information is completely preserved on export. (Jacobo Aragunde, blog entry)
 * Save embedded spreadsheets, presentations, etc. in docx documents. (Jacobo Aragunde)
 * Improved Standard Document Tags support: fix export of date and checkbox controls, fix import of combobox controls reusing dropdown control and preserve the other kinds of tags. (Jacobo Aragunde)
 * Preserve effects on shapes and pictures, including 3D effects and artistic effects. (Jacobo Aragunde, blog entry)




 * Improved handling of Writer track changes in groupshape text. (Miklos Vajna, blog entry)




 * Shape adjustment names are now exported according to the specification. (Miklos Vajna)
 * VML import now handles optional command parameters. commit (Miklos Vajna)
 * Improved drawingML export of pattern fill for shapes. commit (Miklos Vajna)
 * DOCX import now handles explicit horizontal merges of table cells. (Miklos Vajna)
 * DOCX import now handles floating tables anchored inside tables. (Miklos Vajna)

New import filters

 * Microsoft Works spreadsheets and databases (Laurent Alonso)
 * A host of legacy Mac formats (Laurent Alonso)
 * spreadsheets: BeagleWorks, ClarisWorks, Claris Resolve, GreatWorks, MacWorks, Wingz
 * vector and bitmap images: BeagleWorks, ClarisWorks, GreatWorks, MacPaint, MacWorks, SuperPaint

GUI

 * There was a leftover 1 px border around the Start Center, which is now removed. (Adolfo Jayme Barrientos)
 * The background color was tweaked and unified with that of the rulers, streamlining and improving the default look., (Michael Meeks, Adolfo Jayme Barrientos)

Refreshed Tango icons
The default Tango icon set has received a general update, including the addition of new icons for the Sidebar. (Alexander Wilms, Miroslav Mazel)

Native background rendering on macOS
Native rendering of toolbars background on macOS. (Joren De Cuyper, Jan Holesovsky, Tor Lillqvist)

Color pickers improvements

 * Line color picker now uses a color palette instead of a list. (Maxim Monastirsky)
 * Several color pickers were converted to split buttons, making it possible to apply the last used color with one mouse click. This includes: Font color (Impress, Draw), Font color of drawing objects (Writer, Calc), Line color, 3D Extrusion color. commit (Maxim Monastirsky)

Start Center improvements

 * Preview of all file types in start center, not only ODF. (Jan Holesovsky)
 * Selectively delete Recent Documents (Jan Holesovsky)

Initial HiDPI support

 * Some HiDPI support for Linux and Windows, most of the patches have been backported to 4.2.3 (Keith Curtis, Jan Holesovsky, Caolán McNamara, Andrzej Hunt)

Progressbar for DOCX documents

 * DOCX import now has a progressbar. (Miklos Vajna)

Font support

 * We now ship Adobe’s Source Sans Pro 2.0, which includes a greatly expanded range of characters. It now supports the Cyrillic, Greek and IPA writing systems, tweaks several diacritic marks and adds the new Russian Rupee sign (, , included since Unicode 7.0).  (András Tímar)

New languages/locales in language list
Available for character attribution and spell-checking.


 * Added Maninkakan, Eastern, Latin [emk-Latn-GN]. (Eike Rathke)
 * Added Avar [av-RU]. (Eike Rathke)
 * Added Cree, Plains, Latin [crk-Latn-CN] and Syllabics [crk-Cans-CN]. (Eike Rathke)

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


 * Added Lengo [lgr-SB] locale data. (pcunger, Eike Rathke)
 * Added Moore [mos-BF] locale data. (David Delma, Eike Rathke)
 * Added French (Côte d'Ivoire) [fr-CI] locale data. (David Delma, Eike Rathke)
 * Added French (Mali) [fr-ML] locale data. (David Delma, Eike Rathke)
 * Added French (Senegal) [fr-SN] locale data. (David Delma, Eike Rathke)
 * Added French (Benin) [fr-BJ] locale data. (David Delma, Eike Rathke)
 * Added French (Niger) [fr-NE] locale data. (David Delma, Eike Rathke)
 * Added French (Togo) [fr-TG] locale data. (David Delma, Eike Rathke)

Adding a new language tag
In character attribution dialogues the language list box (of the Western text font if CJK or CTL are enabled) is now a combo box with an edit field where the user can specify a valid BCP 47 language tag to define a text language attribute if the language they wants to assign is not available from the selectable list. (Eike Rathke)

Performance

 * Algorithm of reordering sorted data has been overhauled. Sorting of large data set is now substantially faster. (Kohei Yoshida, Michael Meeks)
 * Importing OOXML documents with lots of relations is much faster. (Michael Meeks)
 * Much accelerated DOCX hyperlink import. (Miklos Vajna)

Access2Base new version
LibreOffice bundles Access2Base V1.1.0, a simplified API for scripting of Base (and database forms stored in Writer, Calc, ... documents) in the Basic programming language. It is more concise and easier to learn than the cross-language standard UNO API. The current version allows dynamic data access from any Basic macro, including, just as an example, from a user-defined function invoked in a Calc cell formula. (Jean-Pierre Ledure)

Feature removal / deprecation

 * Exporting to the OpenOffice.org 1.0 XML file format was removed; users are recommended to save in ODF, which is a perfect substitute that is better in all respects. Import of old files is still possible. (Bryan Quigley)
 * The Sidebar in Draw doesn't have an "Insert Shapes" panel anymore. (Rob Snelders)

Removed configuration options

 * org.openoffice.Office.Impress.Start/CurrentPage

C++ UNO language binding and URE libraries

 * All inline C++ functions that took a  parameter by value or returned   have been changed to use   instead.  This should effectively be transparent to client code, and potentially helps static analyzers produce better diagnostics.
 * cppu::Enterable::v_isValid returns  instead of
 * Removed the  override with   parameter, intended only for internal use anyway.
 * Removed, intended only for internal use anyway.
 * Removed the obsolete functions originally underlying osl/diagnose.h before that got rebased onto sal/log.hxx

OSL macro clean up

 * Remove
 * Remove
 * Remove

Remove dead support for nonexisting UNO &ldquo;array&rdquo; and &ldquo;union&rdquo; concepts
Removed functionality of
 * function
 * function
 * function
 * struct
 * struct
 * * inline functions

Removing XInitialization from a service implementations

 * com.sun.star.comp.document.OwnSubFilter
 * com.sun.star.comp.embed.DocumentCloser
 * com.sun.star.comp.framework.DocumentAcceleratorConfiguration
 * com.sun.star.comp.sfx2.IFrameObject
 * com.sun.star.comp.sfx2.SfxMacroLoader
 * com.sun.star.comp.sfx2.AppDispatchProvider
 * com.sun.star.comp.framework.ModuleUIConfigurationManager
 * com.sun.star.comp.framework.ModuleAcceleratorConfiguration

Deprecating
Implementations should just always return an empty sequence, and clients should be prepared to routinely obtain empty sequences (which already could have happened in the past) or (better) not call this method at all.

Other

 * Changed 's   method to allow raising.
 * Removed service com.sun.star.accessibility.AccessBridge (JAB)
 * com.sun.star.presentation.XSlideShowController
 * com.sun.star.chart2.XChartType
 * Removed com.sun.star.animations.TargetPropertiesCreator
 * com.sun.star.graphic.XGraphicTransformer
 * com.sun.star.chart2.XChartDocument
 * com.sun.star.chart2.data.XDataProvider

Windows
Affected CPUs include Intel Pentium III and older, and all AMD 32-bit CPUs (Athlon XP and older).
 * Updated build environment on Windows (Windows Server 2012R2 with Visual Studio 2012).
 * Known Issue: there are problems with running the Windows release on older CPUs that lack support for SSE2 instructions, see.

Mac

 * macOS 32 bits build and version 10.6 and 10.7 are deprecated.

Most Annoying Bugs
The following annoying bugs were not fixed in time and will be addressed in the regular bug fix releases: