Category Archives: openoffice

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? I wanted an easy way to update the data when the CSV file changes, and describe the method that was most suitable for me below. Importing a CSV file … Continue reading

Posted in libreoffice, openoffice | 17 Comments

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 | Leave a comment

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 in calc, you need to disable: Tools -> Cell … Continue reading

Posted in libreoffice, openoffice | 41 Comments