Tag Archives: macro

Macro to remove filters in Libre/OpenOffice

Posted on May 3, 2011 by

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

Posted on February 16, 2011 by

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