Recent Comments
Categories
Archives
Meta
Category Archives: libreoffice
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
18 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
42 Comments