Documentation/Third Party Resources

Below is a list of how-tos, tutorials, and other guides, including links to third party sites. The official user documentation is listed elsewhere. For development-related documents, go to development learning materials

Some third party publications do cost money. If you find a paid link on this page that is not marked as such, please add a simple notice: (PAID).

General

 * 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

Writer

 * How to create PDF Forms
 * 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.
 * Intro to Libre Office Navigator tool

Calc

 * Generation of Random Numbers in Calc

Base

 * [[Media:hsqldb guide.pdf|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.
 * [[Media:Base tutorial.pdf|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.

Video tutorials
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


 * https://www.youtube.com/user/TheFrugalComputerGuy/playlists


 * A major collection of video tutorials


 * http://www.spoken-tutorial.org/search/node/libreoffice

[Note: These Firefox Personas have been moved here: https://addons.mozilla.org/en-US/firefox/themes/ They work in LibreOffice 4.0.4.2 (17 Jul 2013)]
 * Firefox Personas - a quick How-To video to help you spice-up your gui (2mins)


 * http://youtu.be/97EvPYgY3Js


 * Create Firefox Personas for LibreOffice 4


 * http://youtu.be/AZeZzxN83HE


 * CMIS - How-To get Content Management Information Systems working in LibreOffice (5-6mins)


 * http://www.youtube.com/watch?v=f2bbnyAjMeM&feature=youtu.be


 * Edit web pages (hyperlinks)


 * http://youtu.be/_rEzl--Si8U


 * Show or hide page numbers (footer) on first page


 * http://youtu.be/o-vHHgdeZ5M


 * Show or hide page number (footer) on last page


 * http://youtu.be/FAbtRoIP8-o


 * Attach comments to text ranges


 * http://youtu.be/9ImnaTY65gA


 * Gradient background in presentation


 * http://youtu.be/a0VLt5zpDfE


 * Create random (word) lists


 * http://youtu.be/O0LVAjwkqLw


 * Create your own calendar


 * http://youtu.be/kWEFi8u_qzI


 * Make a seating plan


 * http://youtu.be/MnKbnOq6xkM


 * Count the number of repeated occurrence in spreadsheet


 * http://youtu.be/L8IBlbWd6VI


 * Install and uninstall LibreOffice 4 on Debian Linux


 * http://youtu.be/tiw2mn1GpUQ


 * Fill in the blanks in LibreOffice 4 - Make a cloze test


 * http://youtu.be/faCVQqJcsdY


 * Conditional formatting in LibreOffice 4


 * http://youtu.be/zXQnBGMIZnY


 * LibreOffice 4 video tutorials - description of functions
 * http://www.fetchiz.com/index.php/en/online-help/libre-office-4.html


 * LibreOffice 4 and Xfce on Debian Linux


 * http://youtu.be/OJYoIZ4WwKY


 * LibreOffice 4 and IBus on Debian Linux - Input Chinese characters
 * http://youtu.be/K0TLAvkRNYc


 * Video Tutorials about Free Software includes LibreOffice step-by-step tutorial


 * http://www.youtube.com/user/TheFrugalComputerGuy/


 * http://www.thefrugalcomputerguy.com/


 * A collection of many videos to help see how to do things in LibreOffice


 * http://www.ilearnthings.com/category/libreoffice/


 * Editable PDFs. This video (by Simon Phipps) shows how to create a "Hybrid PDF".


 * http://www.youtube.com/watch?v=EuVZcygoZsI&feature=youtu.be


 * A spoken guide to getting the Orca screen-reader working. Not for sighted users


 * http://www.che.iitb.ac.in/faculty/km/08-orca_word-processor.mp3

Base

 * Thorough course, specific for Base by TheFrugalComputerGuy:


 * https://www.youtube.com/playlist?list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV


 * LibreOffice Base tutorial on how to create a relational database with forms, so you can add records without code


 * https://www.youtube.com/watch?v=Du1WjROQBpE


 * Full course on Base by Sean Johnson


 * https://www.youtube.com/watch?v=k6XUpvYwuPg&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi

Installation guides
See the installation instructions page on the main website for current instructions for all platforms.

For Linux users, the older but very detailed wiki page is still useful:
 * Installing LibreOffice on Linux (Wiki)
 * See also: [[Media:Readme-for-libreoffice-linux-downloads.odt|The old Linux readme file with full installation instructions]], packaged with stand-alone LibreOffice Linux installation packages.

For advanced users:
 * Installing several versions of LibreOffice in parallel (Wiki)

Feature comparisons
LibreOffice vs. Microsoft Office
 * LibreOffice vs Microsoft Office (Wiki)
 * [[Media:Excel2013 Calc Functions Comparison.ods|Excel and Calc function comparison (ODS)]] - Provided by Zeki Bildirici . It is a work in progress. A new updated version of the spreadsheet is in the making.

LibreOffice vs. Apple iWork
 * Functions comparison of LibreOffice Calc and Numbers

Technical details

 * Documentation/Color and Tone Adjustments
 * Documentation/Text in Custom Shapes

Other links for general users
Languages support:
 * Language support of LibreOffice: Spell check dictionaries, hyphenation, thesaurus, grammar check, autotext, auto correct, and other extensions.

To speed up LibreOffice try the hints from this Arch link:
 * https://wiki.archlinux.org/index.php/LibreOffice#Speed_up_LibreOffice

User profiles. Renaming the User Profile is a good way to reset to "factory defaults".
 * https://forum.openoffice.org/en/forum/viewtopic.php?f=74&t=12426

For students

 * [[Media:ooo for students.pdf|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 [[Media:ooo for students.odt|editable (ODT) format]].

For corporate users
For large scale deployments and administration on multiple machines.
 * Deployment and Migration (Wiki)
 * http://lodahl.blogspot.com/search/label/installation
 * 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.
 * [[Media:AdministrationGuide OOo3.2.0.odt|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 [[Media:AdministrationGuide OOo3.2.0.odt|ODT]] and [[Media:AdministrationGuide OOo3.2.0.pdf|PDF]].