Category Archives: LibreOffice / OpenOffice

LibreOffice global menubar still not working properly in Ubuntu 12.10

I upgraded to Ubuntu 12.10 Quantal Quetzal about two weeks ago. As usual, there are a number of new or improved features and changes, the arguably most controversial being the Dash’s Amazon integration. What has not changed, unfortunately, is the … Continue reading

Posted in LibreOffice / OpenOffice, Ubuntu | Tagged , , , | 6 Comments

Freezing LibreOffice icons on the Ubuntu Unity launcher

LibreOffice is still not playing nicely with the Unity interface of Ubuntu. For a start, it does not support the global menu. You can enable this by installing the lo-menu package (available in Ubuntu software centre). This doesn’t work for … Continue reading

Posted in LibreOffice / OpenOffice, Ubuntu | Tagged , , , , | 3 Comments

Create new tables with subsets of your data using the Pivot table in LibreOffice

Just accidentally discovered this nifty feature in Calc of Libreoffice allowing to quickly create sub-sets of your data by double clicking on the row or column totals in a Pivot table.

Posted in LibreOffice / OpenOffice | Tagged , , , , | Leave a comment

Annoying problem converting ODF to Word 2003 documents – solved

Although I almost exclusively work with Libreoffice, most people I work with still use Word 2003 or later MS Word versions. Not too much of a problem; converting ODF documents back and forth to Word 2003, 2007 or 2010 is … Continue reading

Posted in LibreOffice / OpenOffice | Tagged , , , , , | Leave a comment

Macro to remove filters in Libre/OpenOffice

I often use filters in my Open/LibreOffice and wanted to know how to create a macro that removes all existing filters. The OpenOffice Wiki tells you how to do this.

Posted in LibreOffice / OpenOffice | Tagged , , | Leave a comment

A concatenate function on steroids for OpenOffice calc

In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:

Posted in Data handling, LibreOffice / OpenOffice | Tagged , , | 8 Comments

Filling in the blanks

Some worksheets contain cells that have been left blank, e.g., in order to make the headings and subheadings easier to read. However, if for example you want to sort or filter the list or you want to use the table for analyses, you need to fill in the blanks. You could manually copy the value from the first filled cell above the blanks. An easier and faster way to do this is described on this site. The technique they describe requires the Go To function, which unfortunately is not available in Openoffice’s Calc. However, there is an alternative way (which works also in Excel). Continue reading

Posted in Data handling, LibreOffice / OpenOffice | Tagged , | Leave a comment