LibreOffice 4.1


While the once popular OpenOffice has languished for the past couple of years, the LibreOffice suite that spun off in 2011 has been steadily improving - although with a combination of under -the-hood bug fixes, improved compatibility with Microsoft Office documents and incremental features rather than any really big developments.

LibreOffice 4.1 continues this trend, with useful new features but no major changes. Like OpenOffice, LibreOffice is free and includes the same programs: Writer, Calc, impress for presentations, the Base database, Draw and the math formula editor. Unlike the single installer for OpenOffice or Microsoft Office 2013, the download is in two separate files that have to be transferred in order if you want the built-in help. That makes it a slightly less polished installation  process than for OpenOffice, but The Document Foundation has digitally signed the files so that, unlike with OpenOffice, it doesn't trigger security warnings on Windows and Mac OS.

Another oddity is that the Windows release is a generic 'international build'. The English Version installs not only th UK and US interface languages, but also the South African Variant, plus French and Spanish dictionaries (you can save space by removing them during installation). You may also want to skip the QuickStart component which pre-loads much of OpenOffice as soon as Windows starts; even though it's installed by default, it;s not enabled unless you choose to turn it on.

Select multiple images to show on the pages of your presentation

When you have installed OpenOffice 4.1 it looks very much like OpenOffice 4.0 with different icons. It also has broadly the same features, with some extras. The interface is firmly in the menus and toolbars era, although the toolbar icons in OpenOffice are larger and slightly easier to make out than in OpenOffice, many dialogue boxes are also larger with better layouts, except for the Find & Replace dialogue, which looks cramped compared to the OpenOffice writer Find & Replace. However, if you just want to find a word you can use the search bar that opens at the bottom of your document in all the OpenOffice applications. Also , you can now choose whether you only want to find words with the right case (Office rather than office, for example).

OpenOffice 4.1 offers similar links to templates and extensions in its start page as OpenOffice 4.0, and they're equally confusing for inexperienced users. The site concentrates on telling you how to upload templates rather than how to find and download  them, and the template section isn't as well designed as the OpenOffice site. Once of new features - the sidebar - may look familiar from older versions of Microsoft or OpenOffice 4.0. It reflects the fact that the Document Foundation that maintains LibreOffice is able to incorporate code from OpenOffice to fix bugs, remove unused features or improve performance.

The sidebar is marked as an 'experimental' feature that you have to enable in the advanced options. If you don't, you'll still see a side bar that works slightly differently from OpenOffice: instead of an obscure list of icons, it shows all the available panes in collapsible sections. In this mode the Gallery is a large pane at the top of the window and the Navigator, Styles and Formatting open as panes you can move around or dock at the side of the screen, where they sit on top of the sidebar rather than opening inside it. This leaves you with small panes that don't show very much.


If you enable the sidebar it becomes full height, as in OpenOffice, and you get the same obscure list of icons, but it still doesn't expose all the properties you can get by right-clicking on an object. The new clip art in the Gallery that comes from OpenOffice is probably more useful. Similarly, LibreOffice takes advantages of the Office file format compatibility still isn't the same in the two suites - or perfect, especially on longer, more complex Office documents with intricate page layouts. In one of our test documents, neither program got page layouts quite right, with images aligned incorrectly or placed on the wrong side of the page.

OpenOffice Writer did slightly better than LibreOffice Writer, but only LibreOffice Writer can open ink writing with a stylus in Microsoft Word - although even then it doesn't render the ink as smooth lines. One big advantages over OpenOffice 4.0 is that when you save a file in LibreOffice 4.1 you can choose the XML Office formats as well as the older binary versions and the ODF formats. That makes it more likely that you'll find a format you can share with people.

If you're switching from very old versions of Office, BlibreOffice 4.1 no longer exports to version 6 word and Excel file formats. That's good for security as these older binary formats can carry viruses and do not support newer features. And if you have documents in elderly Mac word processing formats, like Microsoft Word for Mac 5.1, you can now open those in Writer, although LibreOffice no longer runs on Power PC Macs.

LibreOffice didn't get the pagination or layout of this complex Word document right; OpenOffice did only slightly better

In addition, if you're moving documents between machines or sharing with people who work elsewhere, you can now embed fonts in LibreOffice documents when you save them. Performance is generally slightly better in LibreOffice 4.1 also has some useful new features of its own. If you want to turn a set of images into an Impress presentation, you can insert them as a 'photo album'. You have to select images one at a time in the dialog box and you don't get a preview, but you can choose as them placed one, two or four to a slide.

It's a shame Impress doesn't also get Writer's new option to rotate images by right-clicking. You can only choose to rotate 90 degrees clockwise or counter-clockwise, but it's much faster than having to right-click on the image in Impress and delve into a dialogue box. Also, LibreOffice 4.1 has not matched all the improvements seen in OpenOffice 4.0. For example, it gets the new selection of color gradients, but still has the old rather random color palette rather than the more logical new layout. Inconsistencies like this are down to the different teams working on the two projects, and they're frustrating for the user.

Neither LibrOffice nor OpenOffice matches Microsoft Office 2013 for features, but if you don't want to pay for Office or you just can't get used to the ribbon interface (even tough you can customize it now), which of the two free suites should you pick?



LibreOffice 4.1 is, as the numbering suggests, a point release. Certainly it's not as big an update from LibreOffice 4.0 as OpenOffice 4.0 is from its predecessor. But then LibreOffice 4.0 had already improved on both OpenOffice and its own initial release, adding features such as better support for importing PivotTables and more master pages in Impress. LibreOffice 4.1 also has several new features that put it ahead of OpenOffice 4.0, while lacking only minor features like the new color palette. Add to that the commitment from The Document Foundation to six-monthly releases rather than the 'when it's ready' approach of Apache OpenOffice, and you're probably getting more from LibreOffice, now and in the future.