- Android botany climate change Data handling Data sources decision support tool forest GIS GIS software GRASS GIS history LibreOffice / OpenOffice Mobile tools Modelling online mapping Open access Operating system QGIS R computing environment research tools Software release Spatialite SQLite statistics tools Ubuntu Uncategorized vegetation
March 2014 M T W T F S S « Feb 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Category Archives: LibreOffice / OpenOffice
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.
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
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.
In OpenOffice / LibreOffice Calc, you would normally use CONCATENATE to combine strings from different cells, like in the example below:
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