LibreOffice 4.1.0 Final (released 2013-07-25)

Yesterday (on 2013-07-25) LibreOffice 4.1.0 Final was released. This is good news for people running Linux, Windows or Mac, since the software is available for all three platforms.

They call it “a landmark for interoperability”, because it mainly contains compatibility fixes. This is a version you should upgrade to, because it will make your “free Office” experience even smoother.

Let’s get to a selection of the new features:

  • Add “Match Case” option to the search bar.
  • Improvements to Microsoft OOXML import and export filters
  • Improvements to legacy Microsoft Office and RTF file filters
  • Font embedding in Writer, Calc, Impress and Draw
  • Support for Mac OS X for PowerPC has been dropped.
  • Calc: Excel 2013 for ODF OpenFormula compatibility.
  • Calc: Import large HTML documents with more than 64k table cells
  • Calc: Count the number of selected cells.
  • Calc: Add a Stepped Lines line type to Line and XY (Scatter) graphs.
  • Writer: Comments to text ranges can now span over multiple paragraphs.
  • Writer: Rotate images in 90 degree increments.
  • Impress: It is now easy to include a series of photos with the “Photo Album” feature.




Automatic updates in Symfony2

With a lot of pride we present our 7th Symfony2 bundle: LswAutomaticUpdateBundle. You could say we are on a role here, since all these bundles were published in the past 3 months! We are very proud that LswGettextTranslationBundle seems to be installed a lot (588 installs so far) and that LswApiCallerBundle was top trending bundle this month on


Automatic Update Bundle

So, what is new? Well, would’nt it be cool to have a WordPress-style automatic update button? That’s exactly what we deliver with LswAutomaticUpdateBundle! Whether or not this desirable can be argued about, but if you are after fast and consistent deployments, this might work for you. You get an extra icon in the Web Debug Toolbar indicating how long ago you last ran the Composer ‘update’ command. By clicking the icon you get to a panel where you can enter the password to actually execute the upgrade. Before the upgrade is executed the dry-run is executed. Only if all commands succeed, the upgrade button is shown.



The bundle does some cool tricks, such as:

  • Showing app/console and composer.phar output in color, thanks to ANSI to HTML support.
  • Showing days not updated to remind you to keep your software up-to-date.
  • Listing all requires and installed versions of the packages with their descriptions.
  • Identifying unstable (dev) packages to encourage you to run stable versions

It also has some password based security, so that it can only be invoked by authorized people.

Pros and Cons

Maybe system administrators could see this bundle as a stability threat, because it enables quick updating of the code. Also, from a security point of view one could argue that this bundle is not desirable, since the use of ‘system()’ calls from PHP to execute shell commands is frowned upon.

On the other hand the bundle encourages frequent updates and use of versioned packages which should enhance security. Also, because this is a single click upgrade, upgrades should not fail because somebody forgot to type a command or makes a mistake in a command.


As always, you can find the bundle on Github and Packagist. It supports installation using Composer as described in the README.