March 2013


I created a LibreOffice cheat sheet to help me quickly learn and recall the syntax.

It covers some very useful things:

 

Getting the Sheet

Getting A Cell

Iterate over a range of cells:

Getting Form Elements
Set a Cell to current timestamp

HTTP Method GET call and store data
Reading And Writing A File

 

Trying out a new category: Snippets

These will be tiny shell scripts or pieces of code.

The first one is how to have linux convert GPS NMEA text files to kml format.

 

#!/bin/sh
gpsbabel -i NMEA -f $1 -o openoffice -F test.csv
gpsbabel -i openoffice -f ./test.csv -o kml -F test.kml

 

Im sure there is a better way…but this one works and gives a .csv file as an intermediate.