On the Spreadsheet, for boxes such as "Loc Tag", it may be useful to use LibreOffice's ability to allow only certain values - this also allows LibreOffice to list the available options as a dropdown.
To set OBS/DR/PORT/PLACE as the only valid inputs on the Bear 1914 spreadsheet:
Open Data > Validity, Criteria tab
And then set the options like so: http://i.imgur.com/U9DNH72.png
This then gives me a nice drop down box to select from!
There might be other places where this is useful, and it's also possible to enforce certain columns containing only values, but I'm sure we're all well aware that logkeepers can't be trusted to write only numbers in the temperature column...