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.
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.