Tag Archives: LibreOffice

LibreOffice 5.1 becomes “still”, time to upgrade

28 Jun

If you haven’t done so already, it is the right time to upgrade to the LibreOffice 5.1 branch given that, with the release of the 5.1.4 version a few days ago, this branch becomes the “still” (i.e. more stable and secure) branch. Plus, the 5.0 branch reached end of life back in May, which means there won’t be any security fixes any more.

The 5.1 branch brings exciting new features (full release notes here), including:

  • Improvements to formula wizard (Calc)
  • New commands to add rows and column (Calc)
  • New statistics dialogue for calculating regressions (Calc)
  • PNG export (Calc)
  • Many improvements to formula engine (Calc)
  • Reorganised mode selection (Impress)
  • New “equalise” command for shapes (Impress, Draw)
  • Restart counter from presenter console (Impress)
  • Four new transitions (Impress)
  • Import MathML from clipboard (Math)
  • Improved trend line (Chart)
  • New and improved import/export filters (which means better format compatibility)
  • Reorganised menus
  • Lots of sidebar improvements (new sidebar, reorganised items, new buttons and icons…)
  • Special characters in spelling dialogue

On an Ubuntu-based system, you can upgrade to 5.1 by using the following commands in a terminal.

If you already had a PPA installed, remove it. For example, for the 5.0 PPA:

sudo add-apt-repository --remove ppa:libreoffice/libreoffice-5-0

Remove LibreOffice entirely:

sudo apt-get purge libreoffice*

Add the new PPA:

sudo add-apt-repository ppa:libreoffice/libreoffice-5-1

Update your repository info:

sudo apt-get update

Finally, install LibreOffice from the new repository:

sudo apt-get install libreoffice

That’s it!

Note: If you are on Linux Mint, your LibreOffice version might be “pinned” and you will need to do a bit more to upgrade. See this post for example. You might also need to install re-install libreoffice-gnome for it to look right.

Exportez vos anniversaires depuis Facebook via Evolution

27 Apr

Si vous dépendez de Facebook pour vous rappeler des anniversaires de vos amis, il est possible de récupérer cette information pour l’avoir sous forme de tableur, ou pour les transférer à un autre calendrier. Voilà la marche à suivre :

Sur Facebook, allez dans « Évènements ». Dans une boîte sur la droite, vous trouverez des instructions pour ajouter des données à un calendrier externe. Copiez le lien « anniversaires » (il devrait commencer par « webcal:// »).

Dans Evolution, allez dans l’onglet Agenda et choisissez « Fichier > Nouveau > Agenda ». Sélectionnez « Type: Sur le Web » puis collez l’URL que vous avez copié dans la boîte « URL ».

Si tout se passe bien, vous avez à présent vos anniversaires dans votre agenda. Mais comme ce nouvel agenda reste connecté à votre compte Facebook, il se peut que vous vouliez extraire cette info et garder un fichier statique, sous forme de tableur par exemple.

Pour cela, il faut exporter l’agenda en question en format CSV (clic-droit sur son nom, « enregistrer sous > Format: .csv »). Vous pouvez à présent manipuler cette information comme vous le voulez, avec LibreOffice Calc par exemple, ou l’importer dans un autre calendrier, local ou externe à Evolution. Et ne plus dépendre de Facebook pour vous rappeler d’envoyer vos souhaits !

Update LibreOffice 4.4 in Linux Mint 17.2

28 Oct

You might have noticed that LibreOffice on Linux Mint 17.2 Rafaela is blocked at version 4.4.3, with no updates being suggested even though 4.4.6 is already out, with hundreds of bug fixes between the two versions (243 to be precise). To update it to the most recent bugfix version, just adding a PPA (like in previous versions, or in Ubuntu) does not help. That is because that particular LibreOffice version is “pinned”.

You can change that by creating a new preference file before adding the PPA.

In a terminal, type the following to create the new file:

gksu gedit /etc/apt/preferences.d/libreoffice-libreoffice-4-4.pref

In this file, copy-paste the following and save:

Package: *
Pin: release o=LP-PPA-libreoffice-libreoffice-4-4
Pin-Priority: 701

You can now add the relevant stable PPA by using the following command in a terminal:

sudo add-apt-repository ppa:libreoffice/libreoffice-4-4

You can now update and upgrade your packages. You can do that through your Update Manager, but make sure you have the relevant level of updates activated (probably level 2) so the updates are visible (in “Edit > Preferences > Levels”).

[This was tested on Linux Mint 17.2 Cinnamon 64-bit, from LO to; the commands are for the most part a rip-off from this WEB UPD8 article.]

Upgrade to LibreOffice 4.4 from PPA on an Ubuntu 14.04-based distro

6 Jul

[This post is based on an older one, but I thought it would be worth publishing an updated version.]

With version 4.4.4 of LibreOffice recently released, and the 4.3 branch having reached its end of life a while ago, you might want to upgrade your office suite. It is a good idea anyway, knowing that the 4.3 branch will not receive any more security updates officially delivered by The Document Foundation, and the 4.4 branch already integrates extra bug fixes. Plus, it comes packed with an array of exciting changes, including improvements to track changes (Writer), many toolbar improvements, better auto-correct, an enhanced statistics wizard (Calc), colour support in Math, new fonts, new import filters, improved OOXML support, new colour selector, better start centre, a few reworked drop-down menus, more intuitive context menus, and heaps more. Phew!

I have noticed in previous attempts that when I change the LibreOffice PPA I use, I end up still using the older version even though I have upgraded the packages.

Here is how to upgrade to a more recent branch properly.

You can find all the LibreOffice PPAs on this page. In my example, we will upgrade from the 4.3 PPA to the 4.4 PPA, but you can easily replace the version numbers by the ones that suit you. Of course, if you were not using a PPA, just omit the first step.

You will first need to remove the old PPA. You can do that by using your corresponding GUI: for example, in stock Ubuntu, go into “Software and Updates” in your system settings and delete it in the “Other software” tab; in Kubuntu or KXStudio, got to the Muon Update Manager and navigate to “Advanced > Configure software sources” to find it. Another quicker option is to open the terminal straight away (ctrl + alt + T) and use the “–remove” flag, with the following command:

sudo add-apt-repository --remove ppa:libreoffice/libreoffice-4-3

You can now add the new PPA with the following command:

sudo add-apt-repository ppa:libreoffice/libreoffice-4-4

Then you need to uninstall entirely LibreOffice with the following command:

sudo apt-get purge libreoffice*

Make sure you update the repository information now that you have a new PPA:

sudo apt-get update

And finish with installing LibreOffice:

sudo apt-get install libreoffice

And you should be right!

Upgrade LibreOffice from one PPA to another on Ubuntu

19 Nov

With version 4.3.4 of LibreOffice just released, and 4.2.7 reaching its end of life today, you might want to upgrade your office suite from the 4.2 “still” branch to the 4.3 “fresh” branch.  You might also be excited about the new features that the 4.3 branch brings along, including better format compatibility, printable comments (Writer), better pivot table layout and improved statistics wizard (Calc), 3D models (Impress), improved PDF import, neater GUI (including a brand new colour picker), plus lots more.

I have noticed in previous attempts that when I change the LibreOffice PPA I use, I end up still using the older version even though I have upgraded the packages.

I am writing down here the process that actually properly upgrade LibreOffice by using PPAs, especially because I know I will have forgotten how to do it next time I am upgrading.

You can find all the LibreOffice PPAs on this page. In my example, we will upgrade from the 4.2 PPA to the 4.3 PPA, but you can easily replace the version numbers by the ones that suit you.

You will first need to remove the old PPA, if you already had one. You can do that by going into “Software and Updates” in your system settings and deleting it in the “Other software” tab, or you can install the nifty package ‘ppa-purge’ by opening the terminal (ctrl + alt + T) and typing in ‘sudo apt-get install ppa-purge’, and then using the command ‘sudo ppa-purge ppa:libreoffice/libreoffice-4-2’.

You can now add the new PPA with the following command:

sudo add-apt-repository ppa:libreoffice/libreoffice-4-3

Then you need to uninstall entirely LibreOffice with the following command:

sudo apt-get purge libreoffice*

Make sure you update the repository information now that you have a new PPA:

sudo apt-get update

And finish with installing LibreOffice:

sudo apt-get install libreoffice

And you should be right!

You can also do all this by copy-pasting one single command after you removed the old PPA:

sudo add-apt-repository ppa:libreoffice/libreoffice-4-3 && sudo apt-get purge libreoffice* && sudo apt-get update && sudo apt-get install libreoffice

Nota bene: At the time of writing, 4.3.4 for Trusty (14.04) is not in the 4.3 PPA yet. There always is a bit of lagging between the official release and the PPA upload, but lately the packaging team has been way more responsive than in the past.

LibreOffice 4.3.0 and 4.2.6 are out

5 Aug LibreOffice website

Last week was a big week at The Document Foundation (TDF) as they released both the shiny first version of the new 4.3 branch (the “fresh” one), and the very polished last version of the 4.2 branch (now nicknamed “still”) of their office suite LibreOffice (LO).

The renaming from “stable” to “still” is probably a smart move as the former would have made people think that the “fresh” branch would be too “unstable” to give it a go. (See the fourth point in Charles Schulz’ post.)

Version 4.2.6 is (possibly) the latest bugfix version of the 4.2 branch, which means it is the right time for you to transition from 4.1 to 4.2 if you are into hardcore stability: a total of 117 issues were fixed just for this release. However, it is important to note that the code gets cleaner and cleaner as the developments of LO goes, something that is partly revealed by the Coverity scan results, that went from 1.11 to 0.08 defect per 1000 lines of code since October 2012 (when LO joined the Coverity project). So moving to a more recent branch before the last bugfix update might still be a good idea if you are not satisfied by the conservative version you use.

I said that 4.2.6 might be the last version in the 4.2 branch because it is what was stated in the official TDF blog announcement but the release plan on the wiki lists a 4.2.7 version that is expected to be released in October this year (probably because 4.2.1 was an unplanned extra release).

Version 4.3.0, on the other hand, brings quite a few new features, and here are the ones that I find the most exciting:

  • The possibility to print comments in the margins in Writer
  • Images are scaled proportionally by default (makes a lot more sense)
  • A less confusing cell highlighting system for formulas in Calc
  • Feedback about the number of cells selected in Calc
  • Better layout of pivot tables in Calc: a lot more useful for data analysis!
  • New statistics tools in Calc, including 2-factor Analysis of Variance, very exciting for data analysis too!
  • “Fit slide to window” button in Impress
  • Import of 3D models in glTF format
  • New property mapping functionality for charts
  • Improved PDF import in many ways
  • Improved OOXML compatibility
  • A real colour picker instead of a silly drop-down unordered list!
  • A lot more things, and of course heaps of performance improvements and under-the-hood changes that will make the whole experience better.

You can see the full release notes on the wiki.

Download links: Still (4.2.6) and Fresh (4.3.0). There are branch-specific PPAs available on Launchpad, as updates take a long time to make it to the stock Ubuntu updates.

You can support the development of LO with a donation.

Integrate Zotero in Ubuntu 12.10

26 Mar Zotero Standalone in the launcher

This has been tested in Ubuntu 12.10, but should probably work flawlessly with other versions – please let me know!

Zotero is an amazing open-source reference management software that integrates in your browser, your office suite and even as a standalone app. It is supported by the Roy Rosenzweig Center for History and New Media – go have a look at their website, it is well documented. It is without a doubt the best of its kind in the FLOSS ecosystem.

Here is how to use it to its full capabilities in Ubuntu.

Get plugged-in

You should start with installing the plug-in / add-on / extension / whatever you want to call it in your Internet browser.

In Firefox, go to “Tools > Add-ons” and search for “Zotero”.

In Chromium / Chrome, go to “Tools > Extensions > Get more extensions” and search for “Zotero Connector”.

After installing one of those, you will be able to add references to you database by clicking on the icon that appears in the address bar.

Quick link to add a reference to Zotero

Click the icon that appears in the toolbar to add a new reference to you database. The icon – here, the little book – depends on the kind of reference Zotero detected.

In Firefox – the browser for which Zotero was originally designed – you can invoke the Zotero panel by hitting CTRL + SHIFT + Z in order to have a look at your collected references.

Get Zotero Standalone

To be able to use Zotero as a separate app, you will need to install Zotero Standalone.

A very well-kept PPA (“Personal Package Archive”) can be added to your software sources in order to always have an up-to-date version of the app. To add it, follow those easy steps:

  1. Open you Terminal by hitting CTRL + ALT + T
  2. Copy and paste those code lines:
    sudo add-apt-repository ppa:smathot/cogscinl
    sudo apt-get update && sudo apt-get install zotero-standalone

    …and press Return after each one, then follow the prompts

  3. And you should be all done!
Screenshot from 2013-03-26 22:07:51

Zotero Standalone can be locked to the launcher for easy access.

You can now manage you database directly from the desktop.

Zotero standalone

Fancy that.

Integrate Zotero in your office suite

Finally, you just need to be able to cite away like a boss directly from your office suite, be it Apache Open Office or LibreOffice.

This could not be easier.

Simply into Zotero Standalone, navigate in “Edit > Options… > Cite > Word processors” and install the extension directly from there.

You should be able to see a new toolbar in Writer!

Zotero integration in LibreOffice

The toolbar in LibreOffice, with the nifty citation dialogue

This makes it über easy to insert citations in document, as well as directly adding the whole corresponding bibliography at the end, which will automatically update as you go. Fucking rad, in my humble opinion.

If you need to tweak your citation, you can always choose the oldschool citation dialogue that lets you edit it, which is pretty useful if you want to integrate it in a sentence for example, like Grünenschweinbergen (2006) and Ög (2009) profusely did in their respective papers. (This can be permanently toggled in the same “Cite” panel of the standalone app’s preferences.)

So there you go. Hopefully you will find this little how-to useful, and will enjoy citing away like one bloody should.


Install LibreOffice 4.0 in Ubuntu 12.10

25 Mar LibreOffice 4.0 splash


LibreOffice, the successor of OpenOffice.org – or let’s just say fork, before I get harassed by the Apache OpenOffice community -, saw its 4.0 version released a few weeks ago (on the 7th of February to be precise). The bugfix version 4.0.2 should be released next week (check out The Document Foundation’s release plan), which means that more users would like to install it as it is getting more stable.

LibreOffice 4.0 splash

The brand new “splash” image for LibreOffice 4.0

LO 4.0 comes with a number of new features, including:

  • Attaching comments to text ranges in Writer
  • Many import and export support improvements for DOCX, RTF and PPTX formats
  • New conditional formats in Calc
  • Automatic rotation of a chart’s axis labels if overlapping, and capacity to export a chart directly as a picture in Calc
  • A number of new functions in Calc
  • An Impress presentation can now be remote-controlled from an Android phone
  • Improved handling of videos in Impress
  • Four new open-source font families
  • Possibility to send documents via Bluetooth
  • Import filter for Microsoft Publisher format and extended filter for Visio format
  • Better display quality for pictures
  • Styles can be directly previewed in the drop-down box
  • Unity integration is improved
  • Firefox Personas are supported to personalize your window
  • And lots more stuff that you can check out in this full list or in this fancier-looking version.

With the launch of this version (which changed it’s name from 3.7 to 4.0 a few months ago), The Document Foundation renewed its façade with their schmick brand new website.

LibreOffice new website

The new façade of LibreOffice, launched with its 4.0 version

However, this is just a few pages to present the software. Most of the information is still in the older-looking pages.

In Ubuntu 12.10, the default version is 3.6. If you want to enjoy the new features and fixes, as well as keep up to date with the 4.0 cycle’s security updates, you will have to add a PPA (“Personal Package Archive”) to your software sources. Don’t sigh, it’s effing easy.


Now, here are the easy steps to achieve this, lucky bugger:

  1. Open a terminal by using the keyboard shortcut CTRL + ALT + T
  2. Copy and paste this line, press enter and follow the prompts:
    sudo add-apt-repository ppa:libreoffice/libreoffice-4-0
  3. Copy and paste this next one when Terminal stops talking:
    sudo apt-get update && sudo apt-get upgrade
  4. You should then have the newest version of LibreOffice.


Beware: if you have another LibreOffice PPA installed, you might have problems with packages being kept back for a dependency issue, even if you delete it beforehand. To avoid this, make sure you purge the old PPA, which means that you go back to the original package versions that are in the official repositories.

To do this, run the following commands in a terminal before installing the new LibreOffice PPA (copy-paste, replace the PPA name by the right one, press enter, follow the prompts):

sudo apt-get install ppa-purge

sudo ppa-purge ppa:nameoftheppa


If this is not enough, you might have to chase down the naughty package that messes everything up, by trying to figure out what the unmet dependency is. A good way to figure this out is to try and install problematic packages on their own. For example, the problem I encountered previously was related to libexttextcat-data having a higher version number than needed. I figured it out by trying to install the main LibreOffice package (libreoffice-core), which told me that libexttextcat was problematic, and then trying to install libexttextcat on its own, which told me about libexttextcat-data being a shit. I had to uninstall this package, and everything went swell afterwards.

There you go! Hopefully this can help a few!