Tag Archives: OpenOffice

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