Monthly Archives: January 2010

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

QGIS 1.4.0 released

Release QGIS 1.4.0 ‘Enceladus’ Continue reading

Posted in GIS software, QGIS | Tagged , , , | Leave a comment

Which text editor to use with R?

Although some users would prefer a graphical user interface for R, the arguably best way to work with R is through the command line. This can be done directly in the R console, but often it is more convenient to … Continue reading

Posted in R computing environment | Tagged , , , | Leave a comment

Why a GUI for R isn’t always a bad idea

The arguably best way to work with R is through the command line. Some even argue that the use of a graphical user interface (GUI) should be completely discouraged. And that is where I disagree. The command line can be … Continue reading

Posted in R computing environment | Tagged , , | 3 Comments