Version History of LibreOffice 4.0.0 (RC 2)


  • Enable attaching comments to document text ranges. fdo#38244 (Miklós Vajna)
  • Enable attaching comments to document text ranges
  • Allow extra word boundary characters. This feature overrides long dash (—) and short dash (–) to be word boundary characters for the purposes of counting words, and allows the user to specify additional word boundary characters (at Tools→Options→Writer→General→Word Count). (Caolán McNamara)
  • The new options for word counting (Tools→Options→Writer→General→Word Count)
  • Import ink annotations from DOCX and RTF documents (available when using Word on a Tablet PC). (Eilidh McAdam)
  • Drawn ink annotations
  • Import / export support for native RTF math expressions (Miklós Vajna)
  • Native RTF math in Writer.
  • Allow different header and footer on the first page without using a separate page style. For more details, see this blog entry. (Miklós Vajna)
  • First pages can now have a separate header/footer in Writer.
  • RTF filter now imports old Drawing Objects syntax (fdo#42407). See this blog entry for details and screenshots. (Miklós Vajna)
  • Various DOCX improvements: import of floating tables, OLE objects inside rectangles, margins of inline images using the WordProcessing markup. See this blog entry for details and screenshots. (Miklós Vajna)
  • Clicking fields selects them instead of placing the cursor before them. (Cédric Bosdonnat)
  • Logo toolbar and interpreter (László Németh, help in integration: András Tímár).


  • Improved performance of ODS document import. (Daniel Bankston)
  • When opening ODS and XLSX files, the values of formula can be shown as they were saved in the files (cached), without recalculating the formula directly when opening the file (Daniel Bankston)
  • This makes opening of (larger) files faster;
  • When the spreadsheet was last used by someone else, this will always show the values, as they were on that computer. (It is known that large, real complex spreadsheets on different computers, with different OS, processor or software, can have different results.) So that may be seen as an advantage when opening spreadsheets that have last been edited in Excel.
  • The user gets a message on opening the file. That message can be turned on/off at "Tools > Option > LibreOffice Calc > Formula ... Recalculation on file load."
  • Cached value import from ODS and XLSX (Daniel Bankston)
  • Due to possible different implementations you get a warning when the cached values are used.
  • Save settings of Text Import Dialog for Text to Columns and Paste Unformatted Text from Clipboard (in addition to Text File Import). fdo#47674 (Laurent Balland-Poirier)
  • Export color scales and data bars to XLSX (also supports Excel 2010+ extensions for databars). (Markus Mohrhard)
  • Increased size limit on (uncompressed) ODF documents from 2Gb to 4Gb. (Michael Meeks)
  • Support "type-ahead" search in the autofilter popup. It is now possible to search for specific entry via key input. (Kohei Yoshida)
  • XML Source dialog to quickly import arbitrary XML content. Refer to this page for more information on this feature. (Kohei Yoshida)
  • Enhanced chart visualisation - better quality rendering / print and PDF export of charts (Armin Le-Grand - Apache)
  • New conditional formats: (Markus Mohrhard)
    • Date formats
    • Top/Bottom rules
    • String rules
  • Improved conditional format dialogs (Markus Mohrhard)
  • Icon sets (Markus Mohrhard)
  • Overlapping conditional formats (Markus Mohrhard)
  • Initial work on a gnumeric import filter based on orcus (orcus by Kohei Yoshida, gnumeric parts by Markus Mohrhard)
    • This is a technical demonstration of the orcus integration and hidden behind the experimental flag
    • Only imports value, strings and formulas in 4.0 (more will follow in the future)
  • Exporting of a single chart as image (PNG, JPG) fdo#30944
  • Formula engine
  • New spreadsheet function XOR as defined in ODF OpenFormula. fdo#50882 (Winfried Donkers)
  • New configuration option to toggle handling of empty strings when used in arithmetic expression. fdo#44720 (Kohei Yoshida)
  • New configuration option for empty string.
  • New pricing Add-In containing spreadsheet functions for option pricing in particular barrier (OPT_BARRIER(...)) and touch (OPT_TOUCH(...)) options. Example :File:Calc-pricing-add-in.ods (Tino Kluge)

pricing add-in

  • Re-implemented RAND() function with better random number generation algorithm. fdo#33365 (Tino Kluge)
  • New spreadsheet functions AVERAGEIF, SUMIFS, AVERAGEIFS and COUNTIFS as defined in ODF OpenFormula. fdo#41214 (Marina Plakalovic, Daniel Rentz, Eike Rathke)
  • New spreadsheet functions IFERROR and IFNA as defined in ODF OpenFormula. fdo#56124 (Winfried Donkers, Eike Rathke)

Pivot table

  • Support multiple selections in page field of pivot table. (Kohei Yoshida)
  • New page field popup allows multiple selection


  • The state of the sidebar pane in Impress is now remembered. (Rob Snelders)
  • There's now an Impress remote control for Android phones. (Andrzej Hunt)


  • Improve quality of page previews in Draw/Impress with supersampling. (Tomaž Vajngerl)
  • Linecap improvements - adding rounded caps (ends) to lines, see right-click "Line"->"Corner and Cap Styles" (Regina Henschel, Armin Le-Grand - Apache)

Rounded line caps

  • Shear transforms for GraphicObjects, and shear + properties for OLE Objects (Armin Le-Grand - Apache)
  • Multi-image support in ODF allowing a bitmap + SVG representation eg. (Armin Le-Grand - Apache)
  • Circles and Ovals toolbar from Impress now also available in Draw (Rob Snelders)


  • On all non-Windows platforms a new mork driver implementation is used to access Thunderbird address book. This means that Debian/Ubuntu users can finally integrate LO with their Thunderbird address book. (Debian/Ubuntu distros are not shipping a Mozilla-based mork driver, therefore their native Base package can not access the address book.) This also fixes some really old bugs for different distros. (David Ostrovsky)
  • For more information please see:
  • In Forms, AutoFilter does not anymore treat values as patterns. As a consequence, an AutoFilter on "A*" will not anymore match any value starting with an A, but only the exact value "A*". fdo#48807 (Lionel Elie Mamane)


  • CMIS protocol support for easy access to document stored on Document Management Systems like Alfresco, Nuxeo, SharePoint... (Cédric Bosdonnat)
  • Integration of session installer to add missing parts of LibreOffice on the fly (Björn Michaelsen)

Core: session installer

  • Reduce Java code: Port Fax and Letter Wizard to Python (Xisco Faulí)
  • LibreOffice 4.0 ships four new open-source font families: Open Sans (Ascender), PT Serif (ParaType), Source Code Pro and Source Sans Pro (Adobe).

Options / General

  • Java and advanced options now combined in Tools > Options > LibreOffice > Advanced. For choosing experimental features and enabling macro-recording. (Joel Madero)
  • Options: Advanced options for Java, Macro recording and Experimental
  • New Regular Expression Engine (Herbert Duerr - Apache)
  • We now use the ICU regular expression engine instead of a custom version. This solves several "find and replace" bugs, and is faster and smaller. We have compatibility code to map old-style word boundary syntax \> and \< to \b while upgrading. Read more about the ICU regexp engine. Japanese users should be aware that some more advanced transliterations may behave differently.


  • Import filter for Microsoft Publisher publications.
  • The same document in LibreOffice Draw
  • Extended coverage of Visio file-format. LibreOffice 4.0.0 supports all existing Visio file formats from Visio 1.0 released in 1992 to Microsoft Visio 2013 released in 2012. More details in this blog.
  • Improved ODF compatibility in various points. (Michael Stahl)


  • New Widget layout technique for dialog windows introduced, and converted various dialogs; see WidgetLayout. (Caolán McNamara, Jack Leigh, Gokul)
  • UI mockups can be created with Glade UI designer then hooked up to code.
  • Converted widgets can be edited without recompiling Libreoffice. More easy to iterate for good UI design.
  • Support for easily resizing and hiding elements. Reduces code complexity.
  • Intent to follow best-practice guidelines for spacing and indentation yielding nicely spaced, clearer dialogs.
  • Added dialog for Smooth image filter, where it is possible to select the radius (strength) of smoothing/blurring. (Tomaž Vajngerl)
  • Graphics can be resized and recompressed with the new Compress Graphics.. popup menu function. (Tomaž Vajngerl)
  • Menu function is available is available in Draw, Impress and Calc but not (yet) Writer.
  • Supports displaying of current graphics information: original dimensions, dimensions inside of document.
  • Ability to reduce image resolution with setting a new dimension (width/height in pixels and DPI).
  • Lossless (PNG) or lossy (JPEG) compression with ability to set the quality and compression strength.
  • Possibility to select the interpolation (resampling) algorithm.
  • The new Compress Graphics Dialog available in Draw, Impress and Calc
  • Added Edit with External Tool to Calc, Impress and Draw. (Tomaž Vajngerl)
  • Unify Popup menu option Save Graphic… from Writer and Save as Picture… from Draw and Impress to Save Graphic…. (Tomaž Vajngerl)
  • Improve quality of displaying images in documents. (Tomaž Vajngerl)
  • It is possible now to select and copy text from message boxes. fdo#46193 (Tamas Zolnai)
  • The "Apply Style" combo box in the toolbar now features previews of the styles to choose. (Jan Holesovsky)
  • Unity integration (Antonio Fernandez, Björn Michaelsen, Alberto Ruiz, Ryan Lortie, Ted Gould)
  • unity menu integration
  • Hide / Show styles in the “Styles & Formatting” dialog (Cédric Bosdonnat)

Core: Hidden styles

  • The templates management interfaces now allows to have non-native template files: templates from other office suites are now handled like the ODF ones. (Cédric Bosdonnat)
  • Support for the Mac OS X “Full screen” mode (fdo#39983; needs Mac OS X 10.7/Lion or better). (Tor Lillqvist)
  • Support Firefox Personas in LibreOffice. With LibreOffice 4.0, you can choose Tools -> Options... -> Personalization -> Select Persona, choose a persona you like in your browser, paste its address to the dialog, confirm, and LibreOffice will use that. (Jan Holesovsky)
  • New templates manager to bring the templates to the user (Rafael Dominguez and Cédric Bosdonnat)


  • idxexample.odt localizable via PO files (Insert→Indexes and Tables→Indexes and Tables…). (Istvan Turi)
  • agenda/fax/letter/report templates localizable via PO files (File→Wizards). (Istvan Turi)
  • Added locale data files for axk_CG beq_CG bkw_CG bvx_CG dde_CG ebo_CG iyx_CG kkw_CG kng_CG ldi_CG mdw_CG mkw_CG ngz_CG njx_CG njy_CG puu_CG sdj_CG tek_CG tsa_CG tyx_CG vif_CG xku_CG yom_CG. (Jeremy Brown)
  • Autocorrection improvements for pt-BR. (Raimundo Moura, Olivier Hallot)
  • The LightProof grammar checker for Brazilian Portuguese is now avaiable. Improvements in pt-BR spell checking (Raimundo Moura, João Mac-Cormick, Olivier Hallot, László Németh).
  • Translated key names on Windows for Asturian (Xuacu Saturio), Catalan (Jesús Corrius), Estonian (Mihkel Tõnnov), Slovenian (Martin Srebotnjak) and Spanish (Adolfo Jayme Barrientos). Translated key names on Linux for Slovenian (Martin Srebotnjak).
  • Updated Slovenian thesaurus (Martin Srebotnjak/


  • Improved ODS load times (see this blog entry for details). (Daniel Bankston)
  • Improved XLSX load time (see this blog entry for details). (Daniel Bankston)
  • Significantly improved the performance of saving a new entry to a large autocorrect replacement table (fdo#49350). (Tomaž Vajngerl)
  • Significant load and save time improvements for slides / drawings with large numbers of shapes (Michael Meeks)
  • Significantly improved RTF file load times (fdo#44736). (Miklós Vajna, Michael Meeks)


  • Many modules ported to gbuild. (Peter Foley, Matúš Kukan, Caolán McNamara, David Ostrovsky, David Tardon, Norbert Thiebaud and others)
  • all legacy container classes (Sv*Array*, Table, Container, List etc.) replaced with STL containers (Noel Grandin, Michael Stahl, etc.)
  • used for code review and easy patch submission -- more than 500 patches reviewed and merged with it already (David Ostrovsky, Norbert Thiebaud, Robert Einsle, Björn Michaelsen and many more)
    • ssh logerrit gerrit query status:merged|grep change|wc -l for number of merged patches


  • Add GStreamer 1.0 support, and refactor existing gstreamer code. (Tim-Philipp Müller, Michael Meeks)


  • PDF Import, the Presenter Console, and the Python Scripting Provider are no longer bundled extensions but core features. (Stephan Bergmann)

Feature removal / deprecation

  • Dropped support for legacy binary StarOffice (version 1.x → 5.x) files.
  • Note: the old XML file format (.sxw, .sxi etc.) which was used as the default format by StarOffice versions 6 and 7 is still supported.
  • Dropped support for export to legacy Word and Excel (version 6.0/95) files. These files can still be opened, but they will save in your default format (usually .odt/.ods). We continue to export to the Office 97 and later binary file formats of course..
  • This avoids user confusion, and accidentally selecting very old formats that will lose document data.
  • Dropped support for ODMA document management integration, this windows-specific integration point is deep legacy, and yields some horrible user interactions.
  • Dropped legacy STLport library for compatibility with old extensions that linked against it (was only included for 32-bit Linux and Windows).
  • Deprecated Mac / PPC as a platform, raising our base-line to 10.6.
  • Dropped support of Windows 2000.