OpenOffice.org Training, Tips, and Ideas

Free Microsoft Office templates for Word, for use with OpenOffice Writer

As I posted yesterday, you can use OpenOffice.org with most of the templates out there. Writer/Word, Calc/Excel, and Impress/Powerpoint. Also remember that OpenOffice opens .docx files without any extra help.

So google away, find your Word or Excel template, download it, and follow the steps in yesterday's post to save it in OpenOffice template format in your own template collection. Here's one of many sites. http://www.docstoc.com/

Here's the only difference: it's after you've saved it. Instead of being able to access it the way you do with Impress, you choose File > New > Templates and Documents to get it.

 

Then you'll see a window with all your templates. It might be in a folder of templates like My Templates or it might be at the top of all your folders. You can tell by the info in the title bar. The template will be in the folder you picked when you chose File > Templates > Save. Then just double-click and you're good.

 
 

Quick new presentation templates to use in OpenOffice Impress

As you know, OpenOffice doesn't come with the dazzling depth or array of templates that Microsoft Office users get. However, here's the thing. 

A) Templates aren't software. You can get great free software, without many templates, then go out and get the templates separately, also for free.

B) You can use Microsoft Office format templates to your heart's content in OpenOffice.

So here's what I just did.

1. Googled free Microsoft Office templates.

2. Picked this of the many results. http://www.presentationmagazine.com/free_powerpoint_template.htm

3. Downloaded this one (a dear friend just got married to the man I set her up with -- it seems an appropriate choice. :) )  http://www.presentationmagazine.com/wedding_powerpoint_template.htm

4. From OpenOffice, chose File > Open and opened the downloaded file.

 

5. Now, I can just use it, save it as a presentation, do whatever I want at this point. However, if I want it in that nice little catalog of templates that pops up when I create a new presentation....

I choose File > Templates > Save and name it, then click OK.

 

6. And now (without restarting or anything) when I choose in OpenOffice File > New > Presentation, that wedding template is right there in My Templates.

 

No templates? No problem. Convert any MS Office template to use easily in OpenOffice.

File > Wizards > Document Converter.

Then choose Tools > Options > OpenOffice > Paths and update the Templates line to specify where the converted copies were created.

For more detail, see this post.

Making a Specific Template Come Up When You Create Any New Document, in OpenOffice.org Writer, Calc, Impress, or Draw (repost)

This is a very useful feature, I think, so I'm reposting it.

Anytime you can help people do something without actually have them do anything is great for them and great for you.

Templates are a great way to save time. Set up templates with the styles, graphics, etc. that people need, and they don't need to re-create them. (Or create them in the first place.)

However, getting users to use the templates is another step. For them, choosing File > New > Templates and Documents might not be something some will want to do or remember to do every time.

What if one of the templates you've created is one that many or all users use all the time as the basis for new documents?   You can make it come up when users just choose File > New > [type of document] by setting it as the default template. I.e. the user uses the template but doesn't even need to select it.

First, create a new document and make it how you want it: create styles, apply styles, include canned text, whatever.

Choose File > Templates > Save. Select a category and name the template. Click OK.

Choose File > Templates > Organize.

Open the category your template is in, in the left side.

Right-click on the template and choose Set as Default Template.

Click Close. You're done! Choose File > New > [type of document] and you'll see the effect.

To switch back to the normal original boring blank document, repeat the steps but this time choose Reset Default Template > [type of document]

---

How to make sure that your graphics are embedded (not linked) in your documents, especially for templates

When you add a graphic to a document, you can either plop it straight in so it's stored in the document, or you can link the graphic so that the document just points to where the graphic is stored.

It looks the same either way, but here's the thing. When you email your document to someone, or post your template in a network directory, what happens to that link pointing to the graphic?

The link points back to your directory at home\documentdrafts\2008\graphics\teamphoto.gif  or whatever the path is. And your cousin in Phoenix or the other people on your team can't get to that graphic.

So what you want to do, typically, when you're sending documents or templates to other people that those people need to work with, is to make sure that your graphics are embedded in your document.

NOTE: If you're doing large books or other documents where there are significant benefits to just linking to graphics, or if you have really big graphics of a few hundred KB or more, think hard before doing only embedded graphics. You'll have some issues, including really really big documents. Consider working with the documents only on the network so that the graphics are there on the network too and you don't have path issues. You might want to link as you work with the document, then if necessary break the links (see the last section here) or even better, make a PDF, before distributing the document.

How to Insert Graphics in Documents so They're Not Linked

When you drag a graphic from the Gallery (Tools > Gallery) into your document, it's automatically embedded. But when you choose Insert > Picture > From File, then you can choose to link or to not. If you want the graphic embedded, then don't select Link.

How to Add Graphics to the Background of Headers, Footers, or Pages So They're Not Linked

You can just click in a header or footer and choose Insert > Picture > From File. But you can also set up headers, footers, and pages with a graphic in the background.

Choose Format > Page.

Click the Header, Footer, or Background tab.

For Headers or Footers click the More.

Then you'll see this window. Select Graphic then click Browse. Find the graphic. Again, just be sure you don't click the Link checkbox which in this case is next to the Browse button.

 

How to Un-Link (Embed) Graphics When They're Already In Your Document

Let's say you've got a document chock full of linked documents and you reallllly don't want to re-insert them. It's easy to fix; just break the link and the graphics will be embedded.

Under the Edit menu, look at Links. If it's dimmed as shown, then you don't have any linked graphics and you're good.

If it's not dimmed, then choose Edit > Links. In the Edit Links window, just select the graphics listed and choose Break Link. The graphics stay, but now they're embedded and you can mail the document wherever you want or store it in another location.

(You could also select a graphic link and choose Modify to change where it's pointing to.)

---

---

Software is not Templates.

Just some analogies to start things off.

A fridge is not milk. You buy groceries.

An Ipod is not Lyle Lovett. You wouldn't buy a different brand of mp3 player just because it didn't have your favorite music. You just load your music and you've got everything you want.

A closet is not a great pair of peep-toe pumps. You supply your own shoes, clothes, furniture, etc.

And a piece of software is not its templates.  But if you don't have them, you can get them.

Software is written by programmers and you have to install it. Templates are just documents, created by people who generally are not programmers. Sometimes you get templates with software and sometimes you don't, but they operate independently. If you deleted all the templates out of Word it would still be Word. Templates are just goodies included to help you design the documents you want to create.

OpenOffice.org is free and doesn't come with a lot of templates when you install it.  However, OpenOffice.org can make postcards and brochures and bumper stickers and business cards and resumes and invoices until the cows come home. In fact, until the cows have come home, had their drinks, gotten into fights, and passed out.

Because:

• You might have Word/Excel/Powerpoint templates. You can run a little conversion wizard on your MS Office templates, point OpenOffice.org at those MS Office templates and then, bam, OpenOffice.org has all those templates. Templates with macros can work too since the code that pops up the little window for you to fill in won't run, but you will see the gray blank that you can delete and type in.
• Check out the list of template locations at the left side of this blog, including http://wiki.services.openoffice.org/wiki/Extensions.
• And you can google, and you can download files
• You can also choose File > Open and open templates or documents you created in Word.

Check this out. How many results do I get when I google for for free postcard template? 75,000.

And for free brochure template? 158,000.

And just free template (leaving out all the web templates, even)? This is out of control. Over seven million hits.

Here's my directory of Microsoft Office templates. I just went to C:Program Files\Microsoft Office and burrowed down.

And that's not all, folks. You don't even need templates. You can make your own postcards, for instance, totally from scratch.

How big is a postcard? 4x6. So just set your margins in your document so that they fit the postcard st0ck you're printing on. Drag the margins like this

 

or choose Format > Page, Page tab, and set them in the margin fields. (Measurements will vary depending on what you're printing on and how margins are treated.) You might need a ruler to measure the card stock margins and then apply that to the page setup. This measurement would be big enough for two 4x6s, a front and back or two fronts leaving the back blank.

You can also choose Insert > Frame and specify the measurements for one postcard. If you don't want a border on the frame, click the Borders tab in this window and find the "no border" icon.

Insert another frame of the same dimensions, OR copy and paste the frame, and you've got places for two postcards. (Or the front and back of the same card.)

It took me five (I timed it) minutes to insert the frames, type in a little text, format it, add the picture, then copy the contents down to the other frame.

Once you've made your own once, then you can choose File > Templates > Save and save it as a template. Then it'll be there whenever you want it under File > New > Templates & Documents.

Yes, this is part rant. But mostly I want to make it really, really clear that:

The software is entirely different than its templates.

You can get a template for anything and use it in OpenOffice.org, for free, really easily, on the Internet.

OpenOffice.org can make anything, with or without a template.

You can make anything in OpenOffice.org, with or without a template.

And if you do want more help with step-by-steps or with where to find templates, see this blog.

---

---

Search this blog:

» Blogs that link here

Free clip art, templates, and fonts

I've updated my sidebars and have added a new list on the left for several places you can get free OpenOffice.org and Microsoft Office templates. Also I've listed places to get free fonts and clip art. I fond them all just by googling, free templates, free fonts, and free clip art, so please feel free to go out there looking yourself if these sites don't give you everything you need.

Templates -- Keep in mind that most templates in MS Office will open up fine in OpenOffice.org. Start OpenOffice.org, choose File > Open, open the template. Then choose File > Templates > Save, give the template a name, click OK, and it's now an OpenOffice.org template. To use it, just choose File > New > Templates and Documents. (And if it was a Powerpoint template, it will show up when you choose File > New > Presentation.)

To convert a bunch of MS templates to OOo format, just choose File > Wizards > Document Converter and follow the wizard through. Then choose Tools > Options > OpenOffice.org > Paths and, for the Templates line, just add the location of the converted copies that the wizard made.

With Powerpoint templates you do need to do an extra step because of an annoying naming thing that MS does.

Here's some more supplementary info on templates.

Clip art -- If you're associated with a school, company, etc. then centralize the effort. Just get one person (a student with a period free or an intern, ideally) to download the clip art, organize it, and add it to the gallery.

Fonts -- Lots of new fonts are a good way to help smooth the way for apprehensive new users. Plus, they're just fun. Download the ones you want for your operating system and copy them to the appropriate directory, such as C:\WINDOWS\FONTS. They'll then show up in OpenOffice.org.

---

---

Taking Your Microsoft Office Templates, and Making Them Available in OpenOffice.org or StarOffice

If you have a bunch of Microsoft Office templates that you love, you can just choose File > Open in OpenOffice.org to use them. However, if you want them to be available in the wizard when you create a new presentation, or available from File > New > Templates and Documents in OpenOffice.org, you need to do two things: convert them to OOo format, and put them where OOo expects to find them.

Converting Your Microsoft Office Templates to OpenOffice.org/StarOffice Format
You need to convert them to OpenOffice format. Choose File > Wizards > Document Converter. Follow the wizard through to create a converted set of copies of the templates.

Step 1.

Step 2, then just follow the wizard as prompted.

Pointing to Templates to Use: Approach 1
(Use Approach 2 if this doesn't work)
Now, choose Tools > Options > OpenOffice.org > Paths. Select the Templates line.

Click Edit, then click Add, and add the path to the templates you want to point to. (Click this image to see a larger version if you like.)

Click OK, and OK, and OK  again.

Now you'll see the templates when you choose File > New > Templates and Documents.

Pointing to Templates to Use: Approach 2 (Usually Need to Do This for Impress)
1. Copy the directory of converted copies.
2. Paste it into this directory:
openoffice\share\template\en-us (or whatever your language is)
3. If they don't show up in the wizard, restart OpenOffice.org and your computer if necessary

If You Only See One of the PowerPoint Templates That You Converted, in the OpenOffice Wizard
See this entry.

For More Information on Templates
For more information on templates, see this post, which includes this information.

---

---

Search this blog:

» Blogs that link here

Correcting a Small Annoyance: OpenOffice Calc Spreadsheet Cells Don't Wrap By Default, Plus Making a Spreadsheet Template

Me, I like cell contents to wrap.

This is wrapping.

This is not wrapping.

This is more not wrapping.

So, wrapping is nice.

You can make cell contents wrap by selecting one, two, five, or all the cells, then choosing Format > Cells, clicking the Alignment tab, and selecting the Wrap Text Automatically option.

But then, when you cut the contents out of a wrapped cell, those wrapping attributes aren't applied any longer. This is a small point but one I find annoying. Look at this first example, where I applied the Wrap formatting to alllll cells in the spreadsheet.

Now here I cut out the middle item, paste it to the right, and type in the empty cell. The Wrap formatting left along with the contents.

Correcting the Problem
There are a few ways to get around this. Here's one way. Just redefine the cell Default Cell Style to be wrapped.

- Choose Format > Styles and Formatting.
- Right-click on Default and choose Modify.

- In the Alignment tab, select Wrap Text Automatically.

- Click OK.

Now forever and ever, for that spreadsheet, all cells will wrap period. (You can overwrite them on a cell by cell basis if you like.)

If you want to set up allllll  new spreadsheets to be like this so you don't need to redefine the default style for every new spreadsheet, do this.

- Create a new spreadsheet.
- Define the default style as wrapping as shown in the last set of instructions. Before you click OK, set up any other formatting that you want to always be there by default. For instance, you might want the font to be different.

Or you might want the number format to be always a specific, different format.

- Click OK.

- Choose File > Templates > Save.

- Select the My Templates category (or another if you want) and name the template something obvious.

- Click OK.

- Choose File > Templates > Organize.

- In the left-hand pane, open the category you choose previously when saving the template. Find the template. Right-click on it and choose Set as Default Template.

- Click Close.

Now, when you create a new spreadsheet, it'll be based on that template you created: cells will all wrap, they'll all have the font you wanted, etc.

To go back to the regular way of creating new spreadsheets, just choose File > Templates > Organize again, right-click on the template, choose Reset Default Template > Spreadsheet.

---

---

Making a Specific Template Come Up When You Create Any New Document, in OpenOffice.org Writer, Calc, Impress, or Draw

Anytime you can help users do something without actually have them do anything is great for them and great for you.

Templates are a great way to save time. Set up templates with the styles, graphics, etc. that people need, and they don't need to re-create them. (Or create them in the first place.)

However, getting users to use the templates is another step. For them, choosing File > New > Templates and Documents might not be something they'll want to do or remember to do every time.

What if one of the templates you've created is one that many or all users use all the time as the basis for new documents?   You can make it come up when users just choose File > New > [type of document] by setting it as the default template. I.e. the user uses the template but doesn't even need to select it.

First, create a new document and make it how you want it: create styles, apply styles, include canned text, whatever.

Choose File > Templates > Save. Select a category and name the template. Click OK.

Choose File > Templates > Organize.

Open the category your template is in, in the left side.

Right-click on the template and choose Set as Default Template.

Click Close. You're done! Choose File > New > [type of document] and you'll see the effect.

To switch back to the normal original boring blank document, repeat the steps but this time choose Reset Default Template > [type of document]

---

Publisher Users: Making Postcards, Brochures, and Other Cool Stuff With OpenOffice Writer and Draw, and Existing Microsoft Templates (Repost)

Reposted April 2007 because this post doesn't show up in Technorati searches.

Update: See The Linux Box for more ready-made OpenOffice Impress templates.

One of the biggest losses people experience when switching to open source is the loss of all those cool templates. They are, as the song says, a hard habit to break.

The good news is, you usually don't have to break the habit. (Unless you've been using Publisher, unfortunately, and you can't open Publisher files in anything—not even Word.) Here's how to keep on using the same templates you know and love; find new ones, or create your own in Draw and Writer.

You Can Still Use Your Own Word Templates and Any Others You Can Find

Here's where you might really start to enjoy the value of OpenOffice.org's compatibility with Microsoft Office.
You can still use all those Microsoft Office templates you got with the software. (Assuming the license doesn't forbid it--just putting that in just in case. ;> ) In OpenOffice.org, just choose File > Open, go to Program Files\Microsoft Office\templates (or wherever) and find the one you want. 

You can also set up OpenOffice.org to just find those templates. See this blog on templates. Go to the end.

And you can google around for more. I googled for “postcard templates” and came to this nice site from HP. The templates are available not just in Publisher but in Word. Click the image to see it larger if you like.

http://www.hp.com/sbso/productivity/office/direct_marketing.html

Follow a few links, and you get here. Click the image to see it larger if you like.

http://www.hp.com/sbso/productivity/office/stocklayout/stocklayout_overview.html

 

I decided to download the postcard template and the brochure template. I clicked on each; here's what it looked like to choose the brochure template.

Once the files were downloaded, I just went to OpenOffice.org, chose File > Open,  and opened them in OpenOffice Writer. Here's what the postcard template looks like.

 

I modified it according to my own information; it was relatively easy. Here's what that looks like. Here's the file itself. Right-click on the link and choose to save link as.

So that's really all there is to it. Use your own  or find new ones. There are a zillion free templates out there, and you can use the Word format templates (or Powerpoint, or Excel) in OpenOffice.org. Just google for the free ones, or ask friends where they are.

Making Your Own Postcards, Brochures, etc. in Draw and Writer

Now, that's not all the fun. If you want to create a postcard yourself, let's say in Draw, you can go ahead and do that, too. Or a brochure, or anything with specific measurements.

(You can do this in Writer to; I'm just showing it in Draw since the previous section was all about Writer.)

You need to know three  things.
- Choose Format > Page and click the Page tab to set the overall page size and orientation.

- Use the drawing tools like the text box and shapes to create the borders of the items in the document. Choose View > Toolbars > Drawing to bring up that toolbar.

- Select any item, right-click, and choose Position and Size. In the window that appears, click the Position and Size tab. will let you specify that the border of the postcard box, for instance, is 4x6. Remember to mark or unmark the Keep Ratio checkbox depending on whether you want to change one measurement of the object or both.

 

So let's do an example.

 

I'm going to create another postcard template. So I choose File > New > Drawing to create a new Draw document. I choose Format > Page, click the Page tab, and set the page size and margins.  I'll need a document that's like the first one or the second one, depending on what I'm printing on.

Option 1: A document with no margins, 6 across by 8 high (for two 4x6 postcards), and portrait orientation

Option 2: A document with half-inch margins, 7 across by 9 high (for two 4x6 postcards with two half-inch margins around the outside),  and portrait orientation

Next, I create a box to show me where the content should go. I just click on the rectangle tool in the Drawing toolbar and draw the box. I don't want a fill in it so I make the fill Invisible.

I right-click on the border of the rectangle, choose Position and Size, and click on the Position and Size tab. I choose 6 wide by 4 high, and unmark the Keep Ratio checkbox.

I put the edge of the box against the edge of where the postcard paper will end.

At this point, I make a template of it, so I can get at it again. See this blog on templates. If you want my document to download and make into a template,  here it is. Right-click on the link and choose to save link as.

 

Now I just make one version of the postcard, the way I want it. I put the content in the box, keeping in mind I need a bit of space between the text and the edge of the paper.

 

I copy the postcard and paste it, and drag the pasted version down to the bottom end of the document.

 

And now I just delete the boxes.

 

That's all there is to it. A little bit of work to set up, but the template takes care of that; you only need to do it once.

 

---

OpenOffice Template for Writer: Suppressing the Page Number on the First Page

Suppressing the page number on the first page of a document is, unfortunately, not available simply by selecting the Suppress First Page Number checkbox.

You can set up your own documents, using page styles, so that you nave no page number on the first page, but a page number on the second and subsequent pages.
http://openoffice.blogs.com/openoffice/2006/12/merry_christmas.html

http://openoffice.blogs.com/openoffice/2006/09/starting_page_n.html

But if you want a template already made, here are two.
No page number on first page, second page is numbered page 1

No page number on first page, second page is numbered page 2

Here's how to use them.

1. Right-click on each item to download it. Save each file to a location on your computer or a network drive you can access.

Note: You might want to just save the templates to the location already listed under Tools > Options > OpenOffice.org > Paths, Templates item. Then in step 3 choose Commands > Update instead of Commands > Import.

2. Then in OpenOffice.org Writer choose File > Templates > Organize.

3. If you saved the template to one of the existing template paths, choose Commands > Update instead and continue to step 4.

If you saved the template to another location, then select a category on the left side,  click and hold down on the Commands button and choose Import as shown.

Find the files where you downloaded them. To select both, select the first, then hold down Ctrl and select the second. Click Open.

4. The templates will appear. Click Close.

5.  If you want one of the templates to be what comes up when you choose File > New > Text document, then right-click on it and choose Set as Default Template. I strongly recommend customizing the default template, whether you use this one or another one.

6.  Click Close.

7. To access the templates, choose File > New > Templates and Documents. If necessary, click the Templates icon at the left, double-click the name of the category you put the templates in in step 3, and you'll see the templates. Select the one you want.

---

OpenOffice Label Templates Article got Dugg and Delicioused

I'm a little fuzzy on how it happened, but my article, somewhat edited down, got Dugg and Delicioused bigtime last week! (The folks at WorldLabel sometimes engage me to write articles, and they re-released it. Kind of like a DVD Director's Cut or something. ;> )

Apparently it even made the front page of Delicious. Very fun.

Anyway, here's the article.

http://www.tech-recipes.com/rx/1955/making_labels_with_openoffice_org_templates

If you feel the urge to Digg it, or just FYI, it's in the Software category.
http://www.digg.com/software

---

An Extra Step to Do When Converting PowerPoint Templates to OpenOffice.org Impress Format

You can and should run the Document Converter (File > Wizards > Document Converter) to convert all those lovely Microsoft Office templates you want to use in OpenOffice. The wizard creates converted copies. You then copy those copies to openoffice\share\templates\en-us\ and they show up in all your template windows. (If necessary, restart the program and/or the computer to make them show up.)

All of that works just great with Writer and Calc, and the converter works just fine for everything, including Powerpoint/Impress. Here's a directory of converted copies.

But here's the deal.

The Powerpoint templates each have a different filename, of course. blue, red, bluefancy, etc.

But they all have the same TITLE, the name that appears in the upper left corner when you're looking at the document. So the converted templates end up all having the SAME TITLE.

So that means that when you copy a bunch of templates to the template directory, all with the same TITLE, the organizer gets horribly confused and won't let you get to more than one.

All you need to do is before you convert, right-click on each PowerPoint template in your file manager that you want to convert, and choose Properties. In the Summary tab of that window, in the Title field, type a unique name. Me, I like to copy the  file name from the General tab and paste it into the Title field.

(You might want to assign that promising young intern to this task.)

---

Search this blog:

» Blogs that link here

OpenOffice Templates: Making Them, and Making New Documents Based on Them (Writer, Calc and Impress): Reposted January 2007

This is embarrassing. I have a huge blogapalooza on styles but left out templates.

I shall remedy that immediately.

All right. Let's say you have the following:

• A bunch of styles you need to have when you create a document.
• Some canned text, like your signature or a graphic logo, that you use in a lot of documents
• Or you're just darned picky about how you want your documents ;>

You are an excellent candidate for using templates. Templates are documents that store styles, text, graphics, general formatting—whatever you want. You create a document, save it as a template in the Template Place, then point to that template when you want to create a new document using what it's got. (“Styles and canned text...that's what it's got....remember that.”)

And it really couldn't be easier.

Making a Template

Open a new document.

Put in it what you want in the template. Styles, graphics, text of every kind and variety. Whatever.

Then choose File > Templates > Save.

Specify My Templates unless you have another idea for a category.

(To create a new category, click the Organizer button, select a category in the button that appears, right-click on it and choose New. An untitled category will appear. IMMEDIATELY start typing the name of your new category. Click somewhere else in the category list when you're done typing. Click Close.)

Type the name of your template like Meeting Minutes.

Click OK.

Now you've got a template.

Using a Template

You need to create a new document using that template.

Choose File > New > Templates and Documents.

Select the Template icon on the left.

Open the category you chose like My Templates. You'll see your template.

Click Open and you'll have a new untitled document based on that template.

The Coolest Part—Making That Template Come Up When You Create Any New Document

Choosing File > New > Templates and Documents is fine but what if that's your template you use all the time? You can make it come up when you just choose File > New > [type of document] by setting it as the default template.

Choose File > Templates > Organize.

Open the category your template is in, in the left side.

Right-click on the template and choose Set as Default Template.

Click Close. You're done! Choose File > New > [type of document] and you'll see the effect.

To switch back to the normal original boring blank document, repeat the steps but this time choose Reset Default Template > [type of document]

Pointing to an Existing Directory of Templates

If you have a bunch of templates, Microsoft or OpenOffice.org, set up OpenOffice.org to know where they are. Then you can get to them as above by choosing File > New > Templates and Documents.

Converting, If You Want to Point to Microsoft Format Templates
First, if they're in Microsoft format, you need to convert them to OpenOffice format. Choose File > Wizards > Document Converter. Follow the wizard through to create a converted set of copies of the templates.

Step 1.

Step 2, then just follow the wizard as prompted.

Pointing to Templates to Use
Now, choose Tools > Options > OpenOffice.org > Paths. Select the Templates line.

Click Edit, then click Add, and add the path to the templates you want to point to. (Click this image to see a larger version if you like.)

Click OK, and OK, and OK  again.

Now you'll see the templates when you choose File > New > Templates and Documents.

---

A Design Contest! Enhancing the OpenOffice.org Template Coffers

The deadline is October 31st! Still plenty of time to enter!

It's another contest! Anyone with OpenOffice.org and a dream (that's all of us, potentially) can enter.

It's the Worldlabel-sponsored OpenOffice.org Design Competition.

" The OpenOffice.org documentation project has announced a Template & Clipart Contest.

The total prize money is to the tune of $5000 sponsored by WorldLabel, which has long been a strong champion of OpenOffice.org.

The goal is to increase the trove of templates and clipart. The current collection of template samples leaves a huge gap that needs to be filled. Step up and fill that gap. Winners will also have the option of including their winning entries in the OpenOffice.org installation sets available from the site.

If you are interested, visit the Documentation Project for more information. Everyone is eligible and everyone is encouraged to participate. The contest officially starts this week and ends 31
October 2006. Winning entries will be judged by a panel of three and winners will be announced."

Enter! I'm definitely going to do it. It's fun, plus with more templates, OpenOffice.org will be even more appealing for those still with Microsoft Office.

---

Free Software Magazine: Issue 13

Get the latest issue of Free Software Magazine here!

I have an article on templates in the next issue.

---

Open Source Web Site Templates

Check'em out! Very pretty stuff.

"Open Source Templates was mainly created to support non-profit organizations.

If you run a non profit org, and are needing to cut down on the costs associated with website development than you have come to the right place. We offer a wide range of free for personal use or non profit use website templates that are easy to modify and add content to.

We will be offering a wide range of tutorials dedicated to helping your organization easily download and create your own great looking site in a matter of hours."

See also this web site, http://www.oswd.org/

About this site:

"To put it simply, Open Source Web Design is a collection of web designs submitted by the community that anyone can download free of charge!

The Open Source Web Design project was founded in September, 2000 by Francis J. Skettino. The goal was to provide the Open Source community with quality web designs to help get people's projects on the web in a way that is both organized and good looking. From personal blogs to content managements systems to full fledged businesses, OSWD has been providing free web designs to those who need them for years. With your help, we will continue to do this for years to come. "

---

A Few OpenOffice Impress Presentation Templates

I had an artistic urge over the weekend and thought I'd try to come up with some interesting presentation templates. You can judge whether I did or not, but not being an artist, I had to jumpstart myself by looking at some Powerpoint templates for ideas. The themes seem to be A) cool pictures in the background and B) interesting Mondrian-type graphical shapes. If you're looking for ideas, I'd suggest doing the same thing--just vary your own, of course, so that you don't get a nasty visit in the middle of the night from the Microsoft copyright lawyers. ;>

I verified while doing this that if you create new colors, they'll transfer over in the document to someone else's computer correctly.  That is, they won't show up in the other person's color list, but they will be retained in the document as they were used.

Also, master pages seem to be really troublesome sometimes. I'll apply changes in master page view and they won't show up; or they'll show up in master view but not normal view. Let's cross our fingers and hope that 2.0.3 corrects this. I don't remember having this much trouble in 2.0.

Here are my templates; they range from Cloyingly Sweet to Sophisticated Grays. ;> If you don't have the same fonts I used, you might want to pep up the templates with something of your own choosing.

See these posts to learn more about templates, creating Impress presentations and master pages, and importing Impress master pages.

Right-click on each one that you want and choose to save the link target to your computer. Unzip the downloaded .zip file once you get it and follow these instructions to use the template in OpenOffice.org.

Flower template (not sure what kind of flower it is, just a picture I took in my front yard--the flower.jpg file is included with this zip file))

Rose Template (this would be the  Sweet one)

Gray template (the presentation uses a gradient; the screen shot doesn't show it perfectly)

OpenOffice Impress Presentation Templates: They're Just a Bit Tricky

First, I'm back from a non-vacation trip, and will be able to blog regularly again.

Secondly, Kent wrote to me recently to ask about Impress templates. As he states, you can make a template, put it in the correct directory, and even restart OpenOffice.org--and the template still won't show up in the wizard when you choose File > New > Presentation.  That approach works fine with spreadsheets and text documents; what's up with presentation templates?

They're just a bit cranky, and/or the logic for getting them to show up in the wizard is less inclusive and aware of its surroundings than we'd like. At any rate, here's how to make Impress templates (or backgrounds, whatever you like to call them) show up when you're creating a new presentation.

Here's how to create templates.  For creating just one template at a time, make the presentation the way you want it, then choose File > Templates > Save.  Select a category and name the template, and click OK. That's all you need to do to create the template, and to make it show up in the new presentation wizard. When you do it this way, you don't pull your hair out and you don't have to force the program to recognize the new template.

(To create a new category, see that blog.)

Now, how about if you've got a directory of templates that you've copied to the templates directory of OpenOffice.org? You don't want to have to open every single one following the instructions above. There's a quicker way.  See that same blog for info on how to point to a directory.

However, when you do it that way, that's when the wizard gets cranky and won't usually recognize the new templates. Here's how to force OpenOffice.org to recognize the templates. Choose File > Templates > Organize,  click and hold down on the Commands button, and choose Update. More info in the referenced blog.

This line of thinking might lead you to ask "OK, how do I import a template into a presentation I've already created?" And that's a very good question, which I'll answer in tomorrow or Wednesday's blog.

Back From Frankfort, Kentucky

I'm back from a fun week of training in Frankfort, Kentucky where I learned more about desktop support, what to wear to the Derby, and "Doctor Hobo" than I ever dreamed possible.

Here are a few things we talked about implementing that I wanted to reinforce as very useful--especially if you have a lot of users who might not be wild about the change, and want to help ensure consistency and ease-of-use.

• Templates, templates, templates! Make the templates, set'em up in clearly named categories, and point users at them. For best results, store the templates centrally on a server.  To make a template, choose File > Templates > Save, or just copy it to the templates directory of your OOo installation on the server. To point users to that location, choose Tools > Options > OpenOffice.org > Paths, select the Templates line, click Edit, and add a location.  See more in this blog on templates.
• Configure the menus and toolbars! You can make menus that say "Admissions Department" and it's not going to take any training at all to get the folks in the Admissions Department to use that menu. Then stick whatever you want in there. Choose Tools >  Customize to modify or create menus and toolbars. When you add items, you can choose to rename the menu or toolbar item so that it says "Use This For Printing Envelopes" or even "Diane, This Is For You". See more in this blog on toolbars.
• To skip blank Address2 lines, just use the mongo mail merge wizard: Tools > Mail Merge Wizard. This is a bit complex so just set it all up with the content and the database users need, then make a template and point them to the template. You might need to fuss with the database setup to be sure that the users' systems recognize it if you've got the template and database on a central server; one thing to try is Tools > Options > OpenOffice.org Base > Database and register the database. See more in this blog on the big wizard.
• If you have a lot of forms with fill-in fields (the usual gray fields that pop up to let you enter something), consider creating a form from File > New >  XML Form Document. This gives you the data entry form tools but you can use them easily for forms that just need to be filled in and printed, or filled in and saved. You can create dropdown lists for instance that make it easier for the people filling in the fields to know what the correct possible values are. When you create the form, make it a template too, then point users to it. Here's a blog on tweaking forms created with the wizard, which isn't exactly what you might want but it's a step in the right direction.

Those were the big implementation ideas that we bandied about and I think are darned useful for anyone who needs to work with a lot of users.  If you have other ideas along these lines, let me know!

Sexy Presentation Templates for OpenOffice Impress

Want something more for your templates than a nice gradient background? Check out The Linux Box.

http://thelinuxbox.org/?p=24

It inspires me to break out PhotoShop (not good at Gimp yet) , break my imagination out of the box, and spend this rainy Saturday morning trying something fancy, myself.

Shortcuts in OpenOffice Writer: Quickly Inserting Text, and Text and Graphics, with AutoFormat and AutoText

I think pretty much everyone likes to save time, and avoid painful carpal tunnel surgery. Here are the two very nice shortcut features that let you slap in a bunch of text with just a couple keystrokes.

• AutoFormat lets you create a shortcut for a line of text like your name, email, department, etc.
• Autotext lets you put in huge amounts of text and graphics, with the formatting

Using  the Automatic Formatting to Create Handy Shortcuts

The same tab where you turned off word completion has a really great feature for creating shortcuts. Let’s say you type the word supercalfragilisticexpealidocious a zillion times a day, or your name and title, or anything kinda long. You can set up a shortcut for it. It's a much more reliable approach than word completion.

To do this: Choose Tools > AutoCorrect and click on the Replace tab.

1. In the left-hand field type your shortcut like sig and in the right-hand field, type the word you’re tired of typing all the time.

2. Click New, then click OK.

3. Click the Options tab and be sure that both checkboxes for the top item, Use Replacement Table, are marked. That just means "use the stuff in the Replace tab."

4.  In your document, type the shortcut, followed by a space, and your word will appear.

Note: You can also delete anything in the Replace tab that you don't want.

AutoText: Storing and Quickly Inserting Text and Graphics

Let's say you've got a signature that looks like this.

It would be nice to just insert all that instead of typing, or even copying and pasting.

1. Go to a document where you've got that text and the logo. Select it all, including the logo, and including the paragraph above and below. MAKE SURE THAT THE LITTLE ANCHOR GRAPHIC IS NOT SHOWING FOR THE GRAPHIC—I.E. DON'T CLICK ON IT.

GOOD

BAD

2. Choose Edit > Autotext.

3. In the Autotext window, select a category, then type the name and the shortcut for it. Remember this shortcut; you can use it later to quickly insert the autotext.

4. Click and hold down on the Autotext button and choose New.

5. Expand the selected category and click on the titleof the autotext. Click the Preview checkbox below the blank area at the right. The autotext will be displayed.

6. Click Close.

 

Now you're ready to insert the Autotext. Here's how.

Long way: Click in any document. Choose Edit > Autotext, select the category and the autotext to insert, and click Insert.

The autotext will appear in the document.

Short way requiring that you remember the shortcut for the item: Type the shortcut that you entered earlier when you set up the autotext item, then press F3.

Note: To determine where your autotexts are stored, choose Tools > Options > OpenOffice.org > Paths and look at the Autotext item in the big list.

That's all there is to it! Once you get everything set up, you might never type again. ;>

---

OpenOffice Pan-Galactic Post: Posts on Charts, PDF, Spreadsheets, Templates, Drawings, OpenOffice Training, Toolbars, and Much More

I've been having a problem that some of you might sympathize with--getting posts to show up in Technorati. So as a cheater, I've created this post that links to a bunch of posts that I don't think have been showing up. Not all of them like links to current discussions or issues, just the ones I think are  important that have been missed.

So I'm sorry this isn't new content, but perhaps somewhere in the last six months there's something useful that Technorati didn't let you see the first time around.

Templates, Writer, general setup and toolbars

• Creating and using OpenOffice templates, including converting Microsoft Word templates for use in OpenOffice
• Doing calculations in tables
• The styles posts on what they are, how to get styles from one document to another, how to create and update them, etc.
• The much-discussed topic of centering text vertically in a Writer document
• Starting page numbering on page 2 and related topics (relates to page styles)
• Tables of contents
• Searching and replacing for carriage returns (paragraph breaks), tabs, and other items, using regular expressions (regex)
• Creating your own toolbar
• Setting up OpenOffice under Tools > Options and Tools > Autocorrect. This is how to turn off word completion, stop automatic formatting, set defaults, increase icon size, and much more.

Calc spreadsheets and charts

• Calc spreadsheet data entry shortcuts
• Dragging a cell in a spreadsheet (see the end of the post)
• Charts in Calc and Writer; how to click in just the right spot and modify exactly what you want.
• Opening a CSV text file in Calc so that it opens as a spreadsheet. Useful if you export files from databases of other formats and want to create them as spreadsheets or databases in OpenOffice.
• Controlling what people can put into spreadsheets with error messages, online help for the cell, ranges of permitted data, etc.

Draw, Diagrams, Impress presentations

• Using the 3D shapes in Draw (I love this stuff)
• Using OpenOffice FontWork, which is kind of like WordArt
• Creating your own arrows and other line ends for UML diagrams and other purposes
• Using the OpenOffice Gallery to store graphics; this too is useful for UML diagrams
• Printing Impress presentation handouts

Web publishing and PDF

• What I did with the web tools, creating colors, image maps, etc. to redo my getopenoffice.org StarOffice and OpenOffice Training page
• PDF, with linked articles on PDF presentations, and using hyperlinked PDFs. That post is particularly interesting since you can generate PDFs from linked OpenOffice.org documents, and the links carry over to the PDF.
• Using the wonderful Web Wizard (that's the techtarget article, here's the blog link) for creating web sites from existing OpenOffice, Microsoft, and graphics documents. You can also use it for  PDF batch convert.

Mail merge, labels, envelopes, and databases

• The very very powerful Mail Merge Wizard.
• The less powerful but far easier Secret Mail Merge that you need to add to your toolbar.
• Creating OpenOffice.org databases from spreadsheets, text files, and your address book. Even Access databases are easy.
• A bunch of articles for TechTarget.com on creating databases from scratch in Base,  creating forms, doing reports, views and joins between tables , and all the fun new stuff in the Openoffice Base database module.
• How to do labels the regular way, and manually.

Openoffice training, change management, and general discussions

• My thoughts on training and its benefits.
• My suggestions for transitioning to OpenOffice.org, including the change management aspects.
• Why OpenDocument Format is important (parental advisory, contains references to tube tops).
• Switching to OpenOffice.org, or any open source product, means you can spend the budget leftover on something important. Education, firefighters--anything that's more important than using Microsoft Office.
• Office 2007 could be a big retraining job. Think about whether you'd rather spend money and time upgrading to Office 2007, or just time on switching to OpenOffice.

---

Making Postcards, Brochures, and Other Cool Stuff With OpenOffice Writer and Draw, and Existing Microsoft Templates

Update: See The Linux Box for more ready-made OpenOffice Impress templates.

One of the biggest losses people experience when switching to open source is the loss of all those cool templates. They are, as the song says, a hard habit to break.

The good news is, you usually don't have to break the habit. (Unless you've been using Publisher, unfortunately, and you can't open Publisher files in anything—not even Word.) Here's how to keep on using the same templates you know and love; find new ones, or create your own in Draw and Writer.

You Can Still Use Your Own Word Templates and Any Others You Can Find

Here's where you might really start to enjoy the value of OpenOffice.org's compatibility with Microsoft Office.
You can still use all those Microsoft Office templates you got with the software. (Assuming the license doesn't forbid it--just putting that in just in case. ;> ) In OpenOffice.org, just choose File > Open, go to Program Files\Microsoft Office\templates (or wherever) and find the one you want. 

You can also set up OpenOffice.org to just find those templates. See this blog on templates. Go to the end.

And you can google around for more. I googled for “postcard templates” and came to this nice site from HP. The templates are available not just in Publisher but in Word. Click the image to see it larger if you like.

http://www.hp.com/sbso/productivity/office/direct_marketing.html

Follow a few links, and you get here. Click the image to see it larger if you like.

http://www.hp.com/sbso/productivity/office/stocklayout/stocklayout_overview.html

 

I decided to download the postcard template and the brochure template. I clicked on each; here's what it looked like to choose the brochure template.

Once the files were downloaded, I just went to OpenOffice.org, chose File > Open,  and opened them in OpenOffice Writer. Here's what the postcard template looks like.

 

I modified it according to my own information; it was relatively easy. Here's what that looks like. Here's the file itself. Right-click on the link and choose to save link as.

So that's really all there is to it. Use your own  or find new ones. There are a zillion free templates out there, and you can use the Word format templates (or Powerpoint, or Excel) in OpenOffice.org. Just google for the free ones, or ask friends where they are.

Making Your Own Postcards, Brochures, etc. in Draw and Writer

Now, that's not all the fun. If you want to create a postcard yourself, let's say in Draw, you can go ahead and do that, too. Or a brochure, or anything with specific measurements.

(You can do this in Writer to; I'm just showing it in Draw since the previous section was all about Writer.)

You need to know three  things.
- Choose Format > Page and click the Page tab to set the overall page size and orientation.

- Use the drawing tools like the text box and shapes to create the borders of the items in the document. Choose View > Toolbars > Drawing to bring up that toolbar.

- Select any item, right-click, and choose Position and Size. In the window that appears, click the Position and Size tab. will let you specify that the border of the postcard box, for instance, is 4x6. Remember to mark or unmark the Keep Ratio checkbox depending on whether you want to change one measurement of the object or both.

 

So let's do an example.

 

I'm going to create another postcard template. So I choose File > New > Drawing to create a new Draw document. I choose Format > Page, click the Page tab, and set the page size and margins.  I'll need a document that's like the first one or the second one, depending on what I'm printing on.

Option 1: A document with no margins, 6 across by 8 high (for two 4x6 postcards), and portrait orientation

Option 2: A document with half-inch margins, 7 across by 9 high (for two 4x6 postcards with two half-inch margins around the outside),  and portrait orientation

Next, I create a box to show me where the content should go. I just click on the rectangle tool in the Drawing toolbar and draw the box. I don't want a fill in it so I make the fill Invisible.

I right-click on the border of the rectangle, choose Position and Size, and click on the Position and Size tab. I choose 6 wide by 4 high, and unmark the Keep Ratio checkbox.

I put the edge of the box against the edge of where the postcard paper will end.

At this point, I make a template of it, so I can get at it again. See this blog on templates. If you want my document to download and make into a template,  here it is. Right-click on the link and choose to save link as.

 

Now I just make one version of the postcard, the way I want it. I put the content in the box, keeping in mind I need a bit of space between the text and the edge of the paper.

 

I copy the postcard and paste it, and drag the pasted version down to the bottom end of the document.

 

And now I just delete the boxes.

 

That's all there is to it. A little bit of work to set up, but the template takes care of that; you only need to do it once.

 

---

OpenOffice Styles: What, Why, and How to Use Them

March 2006: I've had some trouble getting some of my posts to show up, so I'm reposting a couple of the ones I think are most important.

Styles are like wearing your seatbelt, eating your broccoli, and apologizing to your honey even when you think you're right. They might be a bit of a pain to make yourself do, but they will so save your butt in the long run.

This is just the lead-in to  a big multi-blog post, grouped into a few different ones.

• What are styles?
• Why should everyone absolutely use styles?
• How do you create and modify styles?

---

OpenOffice Templates: Making Them, and Making New Documents Based on Them (Writer, Calc and Impress): Updated March 2006

March 2006: I've added info at the end about how to point to a directory of templates.

This is embarrassing. I have a huge blogapalooza on styles but left out templates. (Updated it yesterday a bit but still, no real thorough coverage.)

I shall remedy that immediately.

All right. Let's say you have the following:

• A bunch of styles you need to have when you create a document.
• Some canned text, like your signature or a graphic logo, that you use in a lot of documents
• Or you're just darned picky about how you want your documents ;>

You are an excellent candidate for using templates. Templates are documents that store styles, text, graphics, general formatting—whatever you want. You create a document, save it as a template in the Template Place, then point to that template when you want to create a new document using what it's got. (“Styles and canned text...that's what it's got....remember that.”)

And it really couldn't be easier.

Making a Template

Open a new document.

Put in it what you want in the template. Styles, graphics, text of every kind and variety. Whatever.

Then choose File > Templates > Save.

Specify My Templates unless you have another idea for a category.

(To create a new category, click the Organizer button, select a category in the button that appears, right-click on it and choose New. An untitled category will appear. IMMEDIATELY start typing the name of your new category. Click somewhere else in the category list when you're done typing. Click Close.)

Type the name of your template like Meeting Minutes.

Click OK.

Now you've got a template.

Using a Template

You need to create a new document using that template.

Choose File > New > Templates and Documents.

Select the Template icon on the left.

Open the category you chose like My Templates. You'll see your template.

Click Open and you'll have a new untitled document based on that template.

The Coolest Part—Making That Template Come Up When You Create Any New Document

Choosing File > New > Templates and Documents is fine but what if that's your template you use all the time? You can make it come up when you just choose File > New > [type of document] by setting it as the default template.

Choose File > Templates > Organize.

Open the category your template is in, in the left side.

Right-click on the template and choose Set as Default Template.

Click Close. You're done! Choose File > New > [type of document] and you'll see the effect.

To switch back to the normal original boring blank document, repeat the steps but this time choose Reset Default Template > [type of document]

Pointing to an Existing Directory of Templates

If you have a bunch of templates, Microsoft or OpenOffice.org, set up OpenOffice.org to know where they are. Then you can get to them as above by choosing File > New > Templates and Documents.

Converting, If You Want to Point to Microsoft Format Templates
First, if they're in Microsoft format, you need to convert them to OpenOffice format. Choose File > Wizards > Document Converter. Follow the wizard through to create a converted set of copies of the templates.

Step 1.

Step 2, then just follow the wizard as prompted.

Pointing to Templates to Use
Now, choose Tools > Options > OpenOffice.org > Paths. Select the Templates line.

Click Edit, then click Add, and add the path to the templates you want to point to. (Click this image to see a larger version if you like.)

Click OK, and OK, and OK  again.

Now you'll see the templates when you choose File > New > Templates and Documents.

---

http://rpc.technorati.com/rpc/ping

What Are Styles? An Overview of Paragraph, Page, Character, and List Styles

Note: This is part of a three-part post on styles. See this post for the intro and links to the other posts.

Styles are recipes, or definitions, or paragraphs, of individual characters, of pages, and of lists. (Frames too but I find them less useful.)

Here are some illustrations.

 

Here are some pictures of the definition window. They look a lot like the formatting windows, but you choose Format > Styles and Formatting, then create styles from the Styles and Formatting window.

Everything starts by choosing Format > Styles and Formatting. You get the Styles and Formatting window.  Click the icon at the top for the kind of style you want: paragraph, character, etc.  Right-click in that window and choose New or Modify to get the editing window you want.

Click each thumbnail if you want a bigger view.

Paragraph style definition window:

Character style definition window:

Page style definition window:

List style definition window:

---