Category Archives: openoffice

January 9, 2013
5:23 pm
by: louic

Automatically (almost) importing and updating data from an external CSV file in LibreOffice Calc

How import a CSV file into a LibreOffice (or OpenOffice) spreadsheet? The easiest/most practical way I found (if you want an easy way to update the data when the CSV file changes) is described below. Importing a CSV file as … Continue reading →

Posted in libreoffice, openoffice

June 19, 2012
12:39 pm
by: louic

Defining your own functions in libreoffice calc

This post will explain how to define your own function in LibreOffice Calc. Your own function can then be used in the same way as the standard functions that LibreOffice comes with. Go to Tools->Macros->Organise Macros->Libreoffice Basic Select Module1 (it … Continue reading →

Posted in libreoffice, openoffice

February 18, 2010
6:48 pm
by: louic

Turn off auto complete in libreoffice or openoffice calc and writer

Assuming you already found the Tools -> Autocorrect options (which is exactly where you'd expect it to be), that still leaves the (very annoying) autocomplete function enabled. To turn it off, you need to disable: Tools -> Cell Contents -> … Continue reading →

Posted in libreoffice, openoffice