OpenOffice.org Training, Tips, and Ideas

Creating Keyboard Shortcuts in OpenOffice, including Assigning Keyboard Shortcuts to Styles, a GREAT Feature

One of the complaints people have when switching from any software package to another is that the keyboard shortcuts that they're used to don't work anymore.

However, in OpenOffice.org you can set your keyboard shortcuts pretty much any way you want. You can even assign shortcut keys to styles. This means that:

• You can blow through formatting quickly without using the Styles and Formatting window
• You can set up styles, put them in the default template that your users use, then just give them all quick reference guides that might look like this:

         

        Text with hanging left indent   In WordPerfect was [whatever]  In OpenOffice Ctrl F4
        Heading indented from left and right   In WordPerfect was [whatever]  In OpenOffice Ctrl F6
        Back to normal text   In WordPerfect was [whatever]  In OpenOffice Ctrl Q

Assigning a Keyboard Shortcut to a Task

1. Create or open a document in the program where you want to apply the shortcut. You'll be able to choose that program, such as Writer, or all of OpenOffice.org, as the context in which the shortcut will work.

2. Choose Tools > Customize, Keyboard tab.

3. Select the program, such as Writer, or OpenOffice.org, at the top.

4. Use the Category and Function lists at the bottom to select the feature you want to assign a shortcut to. You have to be willing to spend some time looking but you'll eventually get a sense of where things are.

5. Find the keyboard shortcut, in the Shortcut Keys list in the top half of the window, that you want to assign. If it's already assigned to something, that's fine. Select the keyboard shortcut you want.

6. Click Modify. The shortcut will be assigned to the item.

7. If you want to remove a shortcut key from an item, select it in the Keys list and click Delete.

8. Click OK.

Assigning a Keyboard Shortcut to a Style

You might find it easier to just use a keyboard shortcut for styles, than to double-click them in the Styles and Formatting window. (Format > Styles and Formatting.)

To use a keyboard shortcut for a style, you do pretty much the same thing.

1. Create or open a document in the program where you want to apply the shortcut. You'll be able to choose that program, such as Writer, or all of OpenOffice.org, as the context in which the shortcut will work.

2. Choose Tools > Customize, Keyboard tab.

3. Select the program, such as Writer, or OpenOffice.org, at the top.

4. In the Category list, scroll to the bottom and select Styles. Expand the + next to it and select the category of style: Paragraph, Page, etc. Then in the Function list select the specific style. Select the shortcut you want from the Shortcut Keys list and click Modify.

5. Click OK.

Remember, the style has to be in the document where you use the shortcut key, otherwise of course it won't work.

Giving the Configurations You've Made to All Users

Shortcut keys are stored here in XP:

openofficedirectory\soffice.cfg\modules\swriter (or another module) \accelerator\en-us\default.xml

If you want everyone to have the same shortcuts, you can modify that file, then copy it to other machines or user directories. This is the directory on XP; different for Vista. (Grrr.....my impression of Vista is, OK, it's pretty because it looks like Mac, but I am sure sick of the blue screen of death.)

In Vista, it's

\Users\username\AppData\Roaming\OpenOffice.org2\user\config\soffice.cfg\
modules\swriter (or other module)\accelerator\en-US\current.xml

If you're having trouble finding the location, just make a change, then search your system for files that were recently modified, or contains a word in the change you made.

Here's what it looks like.

xlink:href=".uno:StyleApply?Style:string=HangingIndent&
FamilyName:string=ParagraphStyles" accel:shift="true" accel:mod1="true"/>

---

Doing an email mail merge without most of the overhead of the OpenOffice Mail Merge wizard

I'm afraid the Tools > Mail Merge Wizard has never been one of my favorites. Too complicated.

I always train people to just "roll their own" when making a mail merge document.

http://openoffice.blogs.com/openoffice/2007/01/mail_merge_in_o.html

Everything you can do in the mail merge wizard, you can pretty much do in the roll-your-own approach, especially since you can now print all documents to a single file and then open that and customize it as you like, before printing on paper.

Printing

and viewing/editing the file output. (Click to see the bigger version; you'll see different values in the two letters.)

BUT

One thing you can't do in the roll-your-own approach is do an email mail merge.

Do you really want to go through the complexity and muscle aches of using the Mail Merge Wizard? No. And you don't have to. You're going to mix and match.

Step 1. Create your email the way you want it with the roll-your-own approach.

http://openoffice.blogs.com/openoffice/2007/01/mail_merge_in_o.html

Save it. Keep it open.

Step 2: Set up email configuration. In Writer, choose Tools > Options > OpenOffice.org Writer > Email. This setup worked for me. Key settings are smtp.comcast.net and port 587. You just need to do this once. If you have security on your email, like requiring a password to send, you'll have to click the Server Authentication button and enter additional information.

Step 3: Choose Tools > Mail Merge Wizard. Choose Current Document, or else browse to your document, and click Next.

Choose Email and click Next.

Select the database you're using and the table. Click OK and click Next.

Keep clicking next til you're here. Fill it in by selecting the field from the database that has the emails in it, and anything else you want.  Click Send Documents.

You'll see the progress window (in this test I only sent two emails).

 

And you're done!

The received email looks like this. Note that I sent it in email format, but with the extra carriage returns I put between the lines in Writer, it looks a little spacey here. You'll want to experiment with and adjust how you format the original Writer documents and what format you send in.

My article on transitioning to OpenOffice.org from Microsoft Office

I really thought that I had posted this article, but I have not seen it in a quick page through.

http://www.fanaticattack.com/2008/switching-office-suites-from-microsoft-office-to-openofficeorg.html

It is a big, big article with most of what I recommend about setting up and switching, with the primary focus on individual users. But it applies to transitioning groups, as well.

See also this blog post, which has some really specific info about how to distribute clip art to many users on a network.

---

---

OpenOffice.org deployment guides: administration, customation, installation, etc.

Here is some very good information. If you're doing installation or customization on a network for StarOffice or OpenOffice.org on Windows, Solaris, or Linux, this is what you need.

Setup:
http://documentation.openoffice.org/setup_guide2/2.x/en/SETUP_GUIDE_A4.pdf

Migration:
http://documentation.openoffice.org/manuals/oooauthors2/0600MG-MigrationGuide.pdf

Admin:
http://wiki.services.openoffice.org/wiki/Documentation/Administration_Guide

---

---