OpenOffice.org Template Collections

June 9th, 2008 by Bruce Byfield in

Your rating: None Average: 4.5 (4 votes)

Stubbornly, OpenOffice.org continues to ship with only a handful of templates. Despite the efforts of several sub-projects and individuals to change the situation, the standard OpenOffice.org download includes only a couple of slide show presentations and a few templates to accompany the wizards available in the file menu. This lack of templates is a serious handicap for many users, and often leaves a poor impression on new users who are accustomed to the selection of templates found in other office suites.

Fortunately, an hour on the Internet can net you hundreds of templates. Depending on the templates, you can install some as a package via Tools -> Extension Manage, and some individually by downloading the file and placing it in the ~/.openoffice.org2/user/template directory. To use a template, go to File -> New -> Templates and Documents, and scan.

Below are some of the most useful sources for templates. The content of these sources overlap to a degree, and the quality of individual templates varies in all of them. Still, between these sources, you may be able to find what you need without taking the trouble to design your own template.

OO Extras

OO Extras was one of the first sites for templates. It has been inactive for at least two periods that I'm aware of, but with a handful of contributions in 2008, the site show signs of recent revival.

With previews for everything, OO Extras is a site designed primarily for downloading individual templates as you need them. The site is somewhat haphazardly organized, with top-level buttons for clipart and Impress, but with templates for other OpenOffice.org applications divided by language -- Czech, English, French, German, or Italian. However, one you drill down to a specific language, tabs guide you to Writer, Calc, or Draw templates. You can start with the templates for your preferred language, but you may find that, with a few modifications, templates for other languages will be useful as well.

The selection of templates is also somewhat variable. No templates for Base are available on OO Extras at all. Nor is the clipart selection very useful, since it consists largely of icon sets and a few collections such as flow chart symbols, which are now integrated into the Drawing tool bar. The Draw tools are only slightly better, with a handful of templates for such purposes as CD covers, inlays, and booklets.

But the site more than makes up for these deficiencies with templates for the core templates. For Writer, the site includes a legal pleading template, as well as one for a research paper that uses APA style and a template for software or hardware documentation. Calc is even better represented, with a mixture of spreadsheets for home use, such as bank account balancing, credit card payment and vehicle service, and spreadsheets for small businesses, such as petty cash, sales targets, and employee attendance.

However, by far the best-represented application is Impress. As you have probably seen and cursed, in most incarnations, Impress ships with only two background templates, neither of which is polished enough for serious use. Since slide shows are nothing without suitable backgrounds, this is a serious usability defect. But OO Extras more than compensates, with over sixty templates. Maybe a fifth of these are too busy for print in their foreground to be legible, and palettes of blues are over-represented in the remainder, but, despite these limitations, you should still be able to find templates for your purposes. Many of the Impress templates come in both OpenOffice.org and PowerPoint formats, which may be useful if you are regularly switching between operating systems.

Licensing is not given for individual templates, but apparently everything on the OO Extras site is released under the GNU Lesser Public License, like OpenOffice.org itself.

Professional Template Pack

The Professional Template Pack is a bit of an anomaly. Available as an extension, it is released under a peculiar freeware license that, while permitting both personal and commercial use, prohibits redistribution or the making of more than a single backup. Essentially, the license is not a free one, which may make it unacceptable to some users.

For those who decide to use the collection, its templates round off the handful that OpenOffice.org includes by default. Using the wizards in the File menu, you can create various business documents with formats described (loosely, in my opinion) as as Elegant, Formal, or Modern. The Professional Template pack adds other documents to this collection, such as Elegant press releases and Modern invoices, providing a complete set of branded documents.

Other templates in the download include ones for writing master's theses, preparing lecture notes, and writing a standard resume, as well as several for home use, such as ones for a gift certificate or for league tournaments. Several examples of personal stationery are also included.

However, as with OO Extras, the Professional Template Pack is especially useful if you are looking for Impress templates. The pack comes with 40 backgrounds, almost all of which are either careful to avoid being so busy that they obscure the text or else confine designs to the margins of the slides -- although, as with OO Extra's collection, shades of blue tend to predominate.

Even more welcome are the pack's organizational templates. Although often overlooked by users, these are the templates you can choose by selecting the From template radio button on the first slide of Impress' opening wizard. Chosen independently of the background template, an organizational template starts your slide show with a number of pre-set (but editable) slides. The Professional Template Pack comes with almost two dozen organizational templates, including ones for such purposes as brainstorming, making a business report, and welcoming new employees.

Documentation Project Samples and Templates

OpenOffice.org's Documentation Project provides another major source for individual templates. On the whole, its collection tends to be more idiosyncratic than those in OO Extras or the Professional Template Pack -- but, if you need one of its unusual collections, that is an attraction rather than a drawback.

The project's collection includes templates for marketing plans, organization charts, raffle tickets, curriculum vitae, three-fold brochures, and even an origami CD envelope. One section is given over to legal documents, which includes not only two separate pleading templates, but also ones for confidentiality,joint, maintenance, and partnership and agreements. It also includes a small but high-quality collection of Impress backgrounds, strangely divided into the categories of Bitmaps, Gradient Fills, and Plain.

Rather annoyingly, you have to drill down to see previews of these templates -- if any is provided at all. However, the general quality makes this source worth taking time over, especially if you are unable to find the template you need elsewhere.

OxygenOffice Extras

OxygenOffice Professional is an enhanced version of OpenOffice.org. For the most part, these enhancements take the form of dozens of templates, some of them borrowed from other sources, and others that are apparently original to OxygenOffice. You can download OxygenOffice's templates separately from the program, and install them as an extension.

The collection is too varied to do full justice to in a summary, but two areas in which it is especially comprehensive are business letters and graph paper templates. If anything, OxygenOffice Extras tends to be too undiscriminating, with the quality of its contents varying from the professional to the sloppily amateurish, and templates carry a variety of licenses, varying from Creative Commons variants to the GNU General Public License, but, all the same, if you only want to install a single template collection, it should probably be your first choice.

Other sources

These are only the largest collections of templates. Increasingly, the OpenOffice.org Extensions site is including templates; those already posted include ones for writing books and movie scripts. The site also contains links to all the other sources listed here.

I should also mention the label templates made by WorldLabel.com, the company that sponsored an OpenOffice.org template contest several years ago. Free for the download, these templates are compatible with most Avery labels.

Like extensions, templates have been slow to appear for OpenOffice.org, but are finally starting to become more readily available. Many of the collections mentioned here welcome new contributions, so if you have a template that you are willing to release under a free license, you might consider doing so. It's a small but effective way to contribute to free software, particularly if you have developed something unique.
__________________________
--
Bruce Byfield (nanday)


Special Magazine Offer -- 2 Free Trial Issues!
Receive 2 free trial issues of Linux Journal as well as instant online access to current and past issues. There's NO RISK and NO OBLIGATION to buy. CLICK HERE for offer

Linux Journal: delivering readers the advice and inspiration they need to get the most out of their Linux systems since 1994.

Sorry, offer available in the US only. International orders, click here.

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
yuban's picture

Eugene is named after its

On November 19th, 2008 yuban (not verified) says:

Eugene is named after its founder, Eugene Franklin Skinner. In 1846, Skinner erected the first cabin in the area. It was used as a trading And By sohbet - chat

Fabis's picture

Eugene is named after its

On November 19th, 2008 Fabis (not verified) says:

Eugene is named after its founder, Eugene Franklin Skinner. In 1846, Skinner erected the first cabin in the area. It was used as a trading And By sohbet - chat

seslichatchat's picture

sesli chat

On November 18th, 2008 seslichatchat (not verified) says:

thanks admin muck

hasan's picture

"Gates is due to retire?the

On November 17th, 2008 hasan (not verified) says:

"Gates is due to retire?the transition from monopolist to philanthropist"

And what is that suppose to mean? Bill Gates is not a monopolist, Microsoft's core businesses are very vulnerable. You can say Microsoft is an aggressively competitive Company, but they are certainly not a monopoly.

If Microsoft is a monopoly then so is Oracle in databases and ERP, so is IBM in Services, so is Google in search and advertising

çet

çet's picture

Excellent writeup Ethan,

On November 17th, 2008 çet (not verified) says:

Excellent writeup Ethan, I’m in the process of adopting this technique, as well as setting up an archive such as the one in your screencast (supplemented by DEVONthink). I was curious, would it be possible to see a screenshot of your archive, with all the fields open? that is to say, all the sub-categories showing. The reason I’d like to see this, is you seem to have developed

sohbet
sohbet odaları
sohpet
muhabbet

söve's picture

söve

On November 17th, 2008 söve (not verified) says:

thanks. mantolama

Susohbet's picture

sohbet

On November 13th, 2008 Susohbet (not verified) says:

I believe Open Office need much more documentation

__________________________

sohbet And & Chat

Andre Da Costa : 's picture

Andre Da Costa :

On November 5th, 2008 Andre Da Costa : (not verified) says:

"Gates is due to retire?the transition from monopolist to philanthropist"

And what is that suppose to mean? Bill Gates is not a monopolist, Microsoft's core businesses are very vulnerable. You can say Microsoft is an aggressively competitive Company, but they are certainly not a monopoly.

If Microsoft is a monopoly then so is Oracle in databases and ERP, so is IBM in Services, so is Google in search and advertising.

sohbet odaları And & sohbet

Jason's picture

Very good collection of

On September 27th, 2008 Jason (not verified) says:

Very good collection of templates especially "OxygenOffice Extras".Does anyone know if they are compatible for openoffice 3?

medikal's picture

Re

On October 27th, 2008 medikal (not verified) says:

+1 Your comment I agree

Driver indir's picture

driver indir

On September 26th, 2008 Driver indir (not verified) says:

In an effort to curb malicious comment posting by abusive users, I've enabled a feature that requires a weblog commenter to wait a short amount of time before being able to post again. Please try to post your comment again in a short while. Thanks for your patience. driver indir

Ayne's picture

Thank you very much for this

On November 17th, 2008 Ayne says:

Thank you very much for this useful article and the comments.

Leonard The Magazine Stundent at 9 Eylul University. evden eve nakliyat

Anonymous's picture

was not either a spam

On July 3rd, 2008 Anonymous (not verified) says:

My first attempt to reply with a compliment was flagged as possible spam, and I bet no human ever looks at those, but they just get dropped in the bitbucket. So here is another try:

thank you for a good article. OOo is full of powerful cool features, if you can figured them out!

Anonymous's picture

Another list of templates

On June 13th, 2008 Anonymous (not verified) says:

Here is another list of OpenOffice.org templates

Cristiano's picture

Enjoyable templates, I'll

On August 9th, 2008 Cristiano says:

Enjoyable templates, I'll use these.

Regards,
Cristiano

__________________________

Sohbet & Sohbet- Cristiano The Magazine Stundent at Ege University. -

Morten Juhl-Johansen Zölde-Fejér (mjjzf)'s picture

Prompting?

On June 10th, 2008 Morten Juhl-Johansen Zölde-Fejér (mjjzf) (not verified) says:

Is it possible to have a template with popup boxes for relevant information? I have appreciated this in Lotus WordPro - it is easier than to navigate the document.
And if this is possible, is it possible for the template to fetch the data from a database?
In my job as a refugee administrator, I write letters to the people associated with the institution. If I could keep a base of these people, writing the letters would be a snap: Appointment with trauma therapist template *click* Recipient social security number *entered, data fetched* - entering appointment date and time: There, letter done. That would be excellent.
Is that something that is doable now, or would it require a macro of some sort?

Michael Crider's picture

Re: Prompting?

On June 10th, 2008 Michael Crider (not verified) says:

Prompting is simple in OpenOffice once you have done it a few times. Go to Insert -> Fields -> Other..., then choose the Functions tab in the Fields dialogue box. Click on Input field under Type, and fill in your prompting text under Reference. When you click Insert, OpenOffice will bring up a sample dialog box and you can enter default text if you wish. Click OK, then click Close on the Fields box. You will have a grey square representing your field (unless you select View -> Field Names). Save this document as a template (it won't work if it is saved as a regular document), and the next time you open it, it will automatically pop up a Fields dialogue box for each input field.
If you use these on a regular basis, I would suggest adding one item to your edit menu. Go to Tools -> Customize..., select the Edit menu at the top, and click on Add under Menu Content. In the Edit category is the Command "Update Input Fields". This will allow you to bring up all the input fields again without closing and re-opening the template - useful if you have several of the same letter to print.
Templates can fetch data from a database just like regular documents. See my article at http://www.freesoftwaremagazine.com/articles/mail_merge_openoffice_org. As I say in the article, I would suggest just printing the template rather than using the Mail Merge Wizard. This will give you a chance to select one or more contacts in your database for filling in the database fields.

Wsdcent's picture

Thanks

On July 1st, 2008 Wsdcent (not verified) says:

Thank for sharing this tip. great

Anonymous's picture

It's good to see open office documentation

On June 12th, 2008 Anonymous (not verified) says:

I believe Open Office need much more documentation

jza's picture

OOoAuthors documentation?

On June 21st, 2008 jza says:

have u seen OOoAuthors.org?
there is tons of documentation there.

__________________________

Alexandro Colorado

Post new comment

Please note that comments may not appear immediately, so there is no need to repost your comment.
The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <pre> <ul> <ol> <li> <dl> <dt> <dd> <i> <b>
  • Lines and paragraphs break automatically.

More information about formatting options

Featured Videos

The November 13, 2008 edition of Linux Journal Live! Shawn Powers and special guest, Linux Journal Author Daniel Bartholomew, talk e-book readers and Daniel's Kindle, DRM, and other goodness.

From the Magazine

December 2008, #176

The Oxford English Dictionary says the word "gadget" is a placeholder name for a technical item whose precise name one can't remember. Like that book-reader thingy from Amazon...what's it called? Spindle, Gindle...Kindle, that's it. Check it out in this month's gadget issue.

Other gadgets covered include the Nokia tablets, the BlackBerry, the Neo FreeRunner, the Dash Express, the Roku Netflix Player, the Kangaroo TV, The TomTom GO 930 and the MooBella Ice Cream System. On the larger hardware front, read the reviews of the Acer Aspire One and the YDL PowerStation. On the software front, check out the articles and columns on memcached, Samba security, Mutt, desktop gadgets, bash and Puppet. To wrap it all up, read Doc's thoughts on Google and the browser platform.

Read this issue

Sign up for our Email Newsletter