As a heavy Open Office user, I am constantly looking for shortcuts, tips, tricks, and methods for improving my productivity. Here I'll mention a few that I find very useful or that were hard to discover. Note that there are many, many more tips and shortcuts available for Open Office, just google them. If you find anything especially interesting, then contact me.
Horizontal lines can be created in Writer by typing a symbol three times on a line by itself and then pressing Enter. The choice of symbol decides what type of line is created. These are the lines that I've discovered:
Lists can be created in Writer by typing a symbol and a space before a line of text. Pressing Enter at the end of the line adds a new line that is a continuation of the list. The choice of symbol decides what type of list is created. These are the lists that I've discovered:
|*||Asterisk||• A bulleted list!|
|+||Plus||• Another bulleted list!|
|-||Dash||─ A horizontal line list!|
|1.||One-period||1. A numbered list with periods after the numbers!|
|1)||One-paranthesis||1) A numbered list with close-parenthesis after the numbers!|
Tables can be created by inserting multiple plus signs (the + symbol) and pressing enter. The width of the resulting table can be controlled by adding tabs and spaces between the plus signs, or the mouse can be used to drag the tables' borders to different dimensions. Tables can also be created with pipes (the | symbol, usually found on the same key as the \ backslash symbol) instead of plus signs, however I find that the pipes create cells too narrow to be useful. Additionally, the width of the tables can be controlled not only with tabs and spaces, but also with dashes, underscores, and equals signs.
Ctrl+Shift+P to make the text superscript. Ctrl+Shift+B to make the text subscript. Repeat to turn off.
Pressing F2 opens a line for performing inline calculations. The result is inserted directly into the text.
First, put the List Box in place:
Now, lets add some data:
You may also remove the border around the List Box:
Open Office's AutoCorrect feature can make repetitve text or unusual characters easy to insert by automatically replacing certain character combinations with different characters. Here are some examples from the default configuration:
Text with newlines can be pasted into Calc cells once the cells are selected with an activated cursor. Attempting to paste text with newlines on selected cells without an activated cursor leads to each line of text being pasted in a separate cell.
Data -> Filter -> Autofilter This feature treats the first row of a spreadsheet as a field title, and the remaining rows as database entries with fields. The titles have dropdown menus that let the user filter on each field. This is one of the nicest features of Calc, bridging the gap between spreadsheet and database.
Some tips for keeping your Open Office documents compatible with MSO (Microsoft Office):
This is a problem. It's probably this problem, but it is also related to this problem and this problem and this problem and this problem and the nine-year-old granddaddy of them all, this problem. To fix it, set Tools -> Options... -> Language Settings -> Languages -> Locale Setting. Unfortunately there is no fine-grained setting of date formats, number formats, measurement system, and who knows what else this affects. There is no documentation on exactly what is affected when the locale is changed, furthermore, there is no documentation on exactly what values each locale has. I currently use the Dutch (Netherlands) locale (for the yyyy-mm-dd date format), then disable the decimal separator checkbox from the Same as locale setting and set my default currency as ILS. But that is the extent that one can customize his locale in Open Office, and in Calc this problem will turn around and bite you.
To configure Open Office to work with Hebrew, Arabic, Farsi, and other Right-to-Left languages, enable the checkbox at Tools -> Options... -> Language Settings -> Languages -> Enabled for complex text layout (CTL).
Change directionality of the current paragraph from the LTR and RTL buttons on the Formatting Toolbar. These buttons look like the Nonprinting Characters button (which itself looks like a reverse letter P with a double stem), but they have a Right-facing and Left-facing arrow respectively.
Set the page direction as RTL: Format -> Page -> Page -> Text Direction. This will affect the layout in some non-obvious ways, such as having the first column on a multi-column page be on the right side.
Change directionality of the current cell from the LTR and RTL buttons on the Formatting Toolbar.
Set the sheet direction as RTL: Format -> Sheet -> Right-To-Left.
The PDF Import Extension allows you to import and modify PDF documents. Best results with 100% layout accuracy can be achieved with the "PDF/ODF hybrid file" format, which this extension also enables. A hybrid PDF/ODF file is a PDF file that contains an embedded ODF source file. Hybrid PDF/ODF files will be opened in OpenOffice.org as an ODF file without any layout changes. Users without this extension can open the PDF part of the hybrid file with their PDF viewer.
OOoLatex is a set marcos designed to provide latex support into OpenOffice. The extension contains two mains modules allowing to insert equations as emf or png images, the latex code is saved into the image attribute allowing re-edition while simpler equations are expanded into symbol characters and then inserted as regular text.
Hebrew dictionary for OpenOffice.org spell checker.
The MySQL Connector for OpenOffice.org installs a native MySQL database driver. It is faster, seamless integrated, easier to administrate and there is no need to install and setup a JDBC or ODBC driver separately. It was never easier to use MySQL databases in OpenOffice.org Base. Create new database tables or use the powerful SQL query editor of OpenOffice.org to visually build MySQL database queries without learning SQL commands. Not to forget the database forms, that allow you to display and manipulate data.
Fast selection preset regular and extended expressions.
This extension generates a data input form for tables in calc, reproducing the Data - Form feature of Microsoft Office Excel.
A little macro that adds a 'Insert / Page number...' dialog to writer. It eases the way you can add page numbers to a document.
Export, Update and Import your documents to and from Google Docs, Zoho and WebDAV servers. For Google Docs you may export, update and import all your documents, spreadsheets and presentations, for Zoho you may export documents, spreadsheets and presentations, and import documents and spreadsheets, to WebDAV you may export what you are able to open in OO.org. Needs Java 5+ to work.
The Presenter Console Extension provides more control over your slide show presentation, such as the ability to see the upcoming slide, the slide notes, and a presentation timer whereas the audience see only the current slide.
This extension provides syntax highlighting features for OpenOffice.org. COOoder will be usefull for developers wanting to present code fragments in writer documents. The colors used are the same than the ones from GeSHi. Character styles will be created for each language element.
Colorize C++, C#, Perl, Python, Java, StarBasic, and XML can be color coded for a better appearance.
Note that by the term "Open Office" I am really refering to the
Go-oo LibreOffice office suite. Go-oo LibreOffice is based on OpenOffice.org, which is owned by Sun Oracle. Go-oo is was a community-developed fork of OpenOffice.org. LibreOffice is the project resulting from the merge of Go-oo with OpenOffice defectors after Oracle purchased Sun and handled other Sun FOSS assets in a worring manner. To further clarify confuse things, the term "Open Office" is a registered trademark of an unrelated Dutch company, therefore, in a technical sense the term "Open Office" should not be used to refer to LibreOffice, Go-oo, or to OpenOffice.org.
This page is now available in Swedish! Fler trix i OpenOffice.org
Date Published: 2008-03-05
Date Revised: 2009-01-16
Date Revised: 2009-06-02
Date Revised: 2010-11-08 with several useful tips from Mads Horn. Thanks, Mads!
Date Revised: 2010-11-23: Extensions
Date Revised: 2011-01-28: Fixed some errors, added link to Swedish Translation
Date Revised: 2011-02-03: Cleanup, corrections, elucidation, Writer List boxes, RTL section, General OOo section, revised notes regarding LibreOffice. Special thanks to Harold Fuchs, TomW, and M Henri Day on the Open Office Users mailing list.
Date Revised: 2011-12-04: AutoCorrect tips from Stefano Corradini
openoffice, open, office, tricks, howto, faq Some tricks and methods that I've found to make using OpenOffice.org easier or more productive. openoffice, open, office, tricks, howto, faq
firstname.lastname@example.org email@example.com firstname.lastname@example.org email@example.com firstname.lastname@example.org