Documentation/Other Documentation and Resources
Below is a list of third party guides and publications. Usually you can download documentation for free or pay to get it posted to you. Some publications do cost some money but we try to make it obvious on this page. If you don't notice a note here you should notice when you get to their page!
One book that is often highly recommended is OpenOffice.org Macros Explained by Andrew Pitonyak, who is a member of the LibreOffice documentation team. He wrote the book independently and it is well worth the money if you want to understand Macros well.
We hope to develop or link to useful video tutorials. Do you know of a good one to list here? When we get enough of them, we'll start a separate wiki page.
- Great collection of short video tutorials for Writer, Calc, Draw, Base
- A major collection of video tutorials
- Firefox Personas - a quick How-To video to help you spice-up your gui (2mins)
[Note: These Firefox Personas have been moved here: https://addons.mozilla.org/en-US/firefox/themes/
They work in LibreOffice 184.108.40.206 (17 Jul 2013)]
- Create Firefox Personas for LibreOffice 4
- CMIS - How-To get Content Management Information Systems working in LibreOffice (5-6mins)
- Edit web pages (hyperlinks)
- Show or hide page numbers (footer) on first page
- Show or hide page number (footer) on last page
- Attach comments to text ranges
- Gradient background in presentation
- Create random (word) lists
- Create your own calendar
- Make a seating plan
- Count the number of repeated occurrence in spreadsheet
- Install and uninstall LibreOffice 4 on Debian Linux
- Fill in the blanks in LibreOffice 4 - Make a cloze test
- Conditional formatting in LibreOffice 4
- LibreOffice 4 video tutorials - description of functions
- LibreOffice 4 and Xfce on Debian Linux
- LibreOffice 4 and IBus on Debian Linux - Input Chinese characters
- Video Tutorials about Free Software includes LibreOffice step-by-step tutorial
- A collection of many videos to help see how to do things in LibreOffice
- Editable PDFs. This video (by Simon Phipps) shows how to create a "Hybrid PDF".
- A spoken guide to getting the Orca screen-reader working. Not for sighted users
- HSQLDB v 1.8 User Guide for the version of HSQLDB used by LibreOffice Base.
- http://dcparris.net/2012/07/06/connecting-libreoffice-to-postgresql-natively/ connecting LibreOffice to PostgreSQL using the native SDBC driver (0.8.1).
- https://www.devart.com/odbc/sqlite/docs/index.html connecting LibreOffice to SQLite database via SQLite ODBC driver.
- http://dl.dropbox.com/u/9113961/virtualclassroom/chap8/libreoffice_base.html A LibreOffice tutorial. Primarily aimed at healthcare professionals in the UK using UMS but useful for anyone else too.
- http://dl.dropbox.com/u/9113961/virtualclassroom/edin_cl1/index.html More for health care professionals in the UK using UMS.
- Base tutorial (PDF) by Mariano Casanova. Although written for OpenOffice.org Base, this tutorial should be equally useful for users of LibreOffice Base.
- http://www.scribd.com/doc/48635562/Base-Tutorial-OOo Written for OpenOffice but recommended by an expert on the Users List.
- Base a rough space for people to jot down notes about Base. Fairly unused but feel free to add notes.
- Writer Tutorial - Two part tutorial covering styles and tables
- LibreOffice Styles Tutorial - It introduces and exemplifies the notion of Paragraph and Character Styles, Direct Formatting, chapter rearrengement through the Navigator and automatic table of contents generation.
- Bernard John Poole's LibreOffice Tutorials for Teachers - 10-part pdf tutorial geared towards teachers and students
- BVCC Schoolhouse's LibreOffice Tutorial - Tutorial covering writer and draw
- OSSDoc.com's LibreOffice Tutorial - 4-part tutorial cover an intro, menu bars, and opening & saving documents
Large scale deployments and administration on multiple machines.
- Deployment and Migration
- http://lodahl.blogspot.com/2011/02/silent-installation-of-libreoffice-on.html written for LibreOffice on Windows Xp but can be adapted using this link about user-profiles.
- Administrators Guide. Written for OpenOffice.org 3.2.0 but should be useful as a starting point for LibreOffice administrators. Docs team has plans to update it for LibreOffice.
- Administrator's Guide (wiki format for OOo 3.2.0, but seems to still work with LibreOffice) - including deployment throughout the network and command line options on Linux, Mac and Windows. Also available in ODT and PDF.
- Publishing Extensions for LibreOffice ( ODT, PDF ). A how-to for contributors that gives detailed information about the process of publishing an extension on the LibreOffice Extensions site.
- BASIC Programmers' Guide. Written for OpenOffice.org 3.2.0 BASIC but should be useful for programmers using LibreOffice BASIC. Docs team has plans to update it for LibreOffice.
- Developers' Guide. Written for OpenOffice.org 3.1.0 but should be useful as a starting point for LibreOffice developers. Docs team has plans to update it for LibreOffice.
- How to build LibreOffice. The best place to start if you want to build your own copy of LibreOffice.
- Development FAQ. A few helpful hints to understand the the LibreOffice source code.
- Notes about String classes. Another guide for programmers.
- Andrew Pitonyak's macro page contains many documents such as AndrewMacro.odt, which contains numerous examples (about 500 pages worth) and an updated copy of his book OpenOffice Macros Explained that is finished with periodic updates.
- OpenOffice for Students (PDF). Kindly donated by the author, David Paenson. Written for OpenOffice.org but should be equally good for LibreOffice. Also available in editable (ODT) format.
- Readme file with full installation instructions, packaged with stand-alone LibreOffice Linux installation packages. The installation instructions part is also published on the wiki at Installing LibreOffice on Linux.
- Language support of LibreOffice: Spell check dictionaries, hyphenation, thesaurus, grammar check, autotext, auto correct, and other extensions.
- Installing Extensions in LibreOffice: A guide about the installation of an extension in LibreOffice (see in Programmers/developers section for a guide for writing extensions).
The Document Foundation Mirrors have previous releases of LibreOffice in their "old" folder. There are also folders for portable, src, stable, testing and for the german boxed Dvd project.
To speed up LibreOffice try the hints from this Arch link
User profiles. Renaming the User Profile is a good way to reset to "factory defaults".
Comparison of LibreOffice and MS Office
LibreOffice 2013 Calendars