December 17, 2007

Undocking the Gallery

READ THE WHOLE POST BEFORE YOU DO THIS.

The Gallery is a nice tool for easy access to clip art or any graphics. Here are a couple blogs on it.

http://openoffice.blogs.com/openoffice/2007/09/getting-a-pictu.html

http://openoffice.blogs.com/openoffice/2007/04/adding_graphics.html

Here's a tip from Dave Richards -- you can make the gallery float, so that you can position it in a more convenient place in your work area.

What the Gallery Generally Looks Like

Choose Tools > Gallery, and you get the clip art and categories on your system. (You can click on each of these images to see a bigger version.)

Gal1

Adjusting the Amount of Space for the Gallery

You can make the gallery take up less, or more, room, by moving your mouse over the small dotted portion of the border, as shown. When you mouse turns into a double-ended arrow, drag up or down.

Gal2

Then the Gallery portion is smaller or larger, depending on your adjustments.

Gal3

Floating the Gallery

However, if you'd like your Gallery to be a floating pane like some of the other windows in OpenOffice.org, you can do that. Click and hold down on the gray part at the top, and drag down into the middle of the document.

Galdrag

When you see a rectangle with a gray dashed border, release. The Gallery will be a floating pane.

Gal4

You can resize and move the pane as you would normally for any floating pane.

Redocking the Gallery

Now, here's the question -- how do you get the Gallery back to where it was, docked at the top?

Not easily. ;>

You can drag the Gallery easily to the left, right, or bottom, and redock it there. Just drag toward the border and when you see the gray dashed border again, release and the Gallery will be docked.  (To turn off the Gallery, just choose Tools > Gallery again.)

Gal5

You can redock the Gallery at the top, it's just really tricky. There is a very small area where you can position the Gallery floating pane and the gray dashed border will appear. Here's the area where it is. Drag the Gallery through it slowly; dragging down usually works better for me than dragging up.

Gal7redockarea



Traininglogo




December 10, 2007

Doing page numbers with alternating pagination

I got this question a while ago: how do you set up a document so that the page numbers go 1, 3, 5, etc.?

You take advantage of something that some people find to be a problem but can actually be used as a simple solution for exactly this situation.

In books, the first page, page 1, is on the right; you get page 2 when you flip and start reading on the left side of the spine, and so on. Writer is set up like this.
Pagination_2

If you have a right page, then you instead of doing normal flow have another right page, that skips the left page so you go 1 (no 2 from the left), 3, and so on.

Pagination2

Thus to have alternating odd pages, just set up your page to be Right Page Only. Choose Format > Page, Page Tab, and for the Format, select Only Right.

Onlyright

Click the Header or Footer tab and turn on the header or footer, and click OK. Insert your page number in either the header or footer by choosing Insert > Fields > Page Number.

Now, OpenOffice gives you the option to insert a blank page for that missing Left page. You don't want to, though. You want to make sure the phantom left (even) page doesn't show.

Pagination3

Choose Tools > Options > Writer > Print. Unmark the option to print automatically inserted blank pages. If you leave the option marked, then you'll get blank unnumbered pages between your odd pages.

Optionsprint


Traininglogo




November 29, 2007

Video tutorial for creating cross-references

Video tutorial, take 2. Smaller display area. It takes a while to load, but should run fine once it gets going. (Optimization is one of the things I'm working on as I create more of these.)

It's about how to create cross-references in Writer, and what they are.

Note: The video uses the Navigator (press F5) to get around more easily to various headings being referenced. The Navigator shows you the structure of your document and the objects in it. By "structure" I mean that it shows all the text to which you have applied the paragraph styles Heading1, Heading2, and so on. More specifically, it shows whatever you have set up as the paragraph styles defining your documentBy structure under Tools > Outline Numbering. That's a whole nother topic, though a very useful one. To learn more about outline numbering and the Navigator, see these blog entries.

http://openoffice.blogs.com/openoffice/2006/10/in_praise_of_ou.html

http://openoffice.blogs.com/openoffice/2007/06/using_the_navig.html
http://openoffice.blogs.com/openoffice/2007/06/going_to_a_spec.html
http://openoffice.blogs.com/openoffice/2007/06/leaving_a_trail.html


Traininglogo




November 09, 2007

Things that don't work when you save Writer documents in Word's .doc format

OpenOffice.org has a feature that lets you automatically save documents in Microsoft Office format. Save Writer as Word, save Calc as Excel, etc. This lets your users send out documents to the outside world without having to remember to save in MS format first.

Choose Tools > Options > OpenOffice.org > Load/Save and use the lists in the bottom half of the window.

Loadsave

Likewise, you can save an OOo document in MS format by choosing File > Save As, or by choosing File > Send > Document as [microsoft format for that document type].

However. There's a but. It's not a huge but, but it's significant.

In some versions of OpenOffice.org, the following features don't work when you save a Writer document in Word format. It's not just the automatic saving, it's saving in Word format through File > Save As, as well. So the only way to get around it is to save as PDF (click the PDF icon on the toolbar or choose File > Export as PDF).

This isn't a complete list; please add your own through comments. I just tested all of these on the standard 2.3 release.

Mail merge prints field names, not content. If you save your mail merge document in Word format, then print, all you'll get is the names of the fields, like Firstname, rather than the data, like Bob.

Background graphics disappear. If you choose to put a graphic in the background of a header footer or page, under Format > Page, the graphics will disappear when you save in Word format.

Custom frame, page, and list styles get screwed up This one is an issue because page styles are the basis for doing so much really good, powerful stuff. (I hope this is on the list of things to fix, and/or not a problem in other builds.) I just tested, in 2.3, a file I'd created with custom page styles to automatically switch from a page style with no page number on the first page footer to a page number on subsequent page footers.

If you insert page breaks between page styles with Insert > Manual Break, and the  Break With feature in the Text Flow tab of a paragraph style, do preserve more formatting than the Next Style feature in the Organizer tab, which preserves nothing.  The headers and footers are preserved in the first two approaches, as are page borders and jumps from page 2 to page 66.  Landscape versus portrait is also preserved.

However, no background formatting is preserved, and the page style names are changed to Default for the first one, Convert1 for the second, and so on.

If these are issues for you, please vote to have the following bugs prioritized as things to work on. (I'm actually having trouble bringing up the OOo issue tracker right now; I think these are correct but I will check them later.)

http://www.openoffice.org/issues/show_bug.cgi?id=78723

http://www.openoffice.org/issues/show_bug.cgi?id=73533

http://www.openoffice.org/issues/show_bug.cgi?id=11522

http://www.openoffice.org/issues/show_bug.cgi?id=22635


Traininglogo




November 07, 2007

Fixing problem OpenOffice files by unzipping, mixing, and matching

Surgeonlogo_2

One of the great things about OpenOffice.org is that you can open corrupted Word files with it. Or Word files that are just too big to open in Word, open fine in OpenOffice Writer.

However, every so often you will get a rogue OpenOffice file that just won't behave. It crashes constantly, or behaves in other ways that just don't make sense.

In that case, the best approach is surgery.

OpenOffice file formats can be unzipped to reveal their components. Once you see their components, you can take copy different components from a different uncorrupted file and replace the corrupted ones in your problem file. Zip it all up together again, and whammo, your file works.

I'll show an example in Writer but the same principles apply to Calc, Draw, and Impress.

So you have your file. Let's say this is the file you're having problems with. It's got a couple styles, a picture, and of course content.
Z_blogzip0

I like to make a copy of the problem file, just to make sure I can always get back to the original version. So I create a copy, give it a different name, and change the extension to .zip. (Or gzip, or whatever works for you on your operating system.)
Z_blogzip1

Then unzip the .zip file, and you'll get a directory of component files and directories.
Z_blogzip2

Here's what's inside that new directory.
Z_blogzip3

I'm not going to go into painful detail about all of the content. But content.xml contains the content, styles.xml contains the style definitions, Pictures contains the graphics, and so on.

Here's a snap of part of the content.xml.
Z_blogzip_contentxml

And of the styles.xml.
Z_blogzipo_stylesxml

And the Pictures directory. Note that the file name is different than the inserted picture.
Zblog_picturescontents

So here's what I do. If I have content but don't care about the styles, pictures, whatever else in the problem document, I:

- create a new totally empty OpenOffice document of the same type (Writer, Calc, etc.)

- change the extension to .zip and unzip it

- copy the content.xml file from the problem doc directory into the new empty doc directory, replacing the empty doc's content.xml file

- zip up the new empty doc directory

- change the .zip extension to .odt, .ods, or whatever

- and open it up again, using this as the new version of the problem document


If you have pictures and styles in the problem document that you need, then just copy the Pictures and Thumbnails directories, and the content.xml and styles.xml files, into the new empty doc directory, replacing the corresponding directories and files.

It's a techy but quite effective way to redo a document.

Would it be better to just copy and paste the content of the problem document to another new empty document? Not always--nasties have a nasty way of accompanying the content. But sure, try that first, and if that doesn't work, then do this.


Traininglogo




November 01, 2007

Another way to tweak labels, and save the format

Logolabels_2

In this entry I talked about a fairly straightforward but manual way of giving your labels a little room to breathe.

In this entry, I'll go through how to use the Format tab to tweak a particular layout, then save it for re-use.

When you create labels, you of course choose File > New > Labels. You select your type and layout here, then add your content, and then click New Document.

Tweak0

You get something that looks like this.

Tweak1

Now, what if you then print and everything is too high, too low, too much to the left, etc.?

Well, you just adjust it, then save that adjustment as a specific format you can select next time.

When you're in the Labels window, click the Format tab.
Tweak2

Here's what all the measurements mean. I suggest starting by changing the left and top margin, then get into changing the pitch if necessary.

Horizontal pitch

The distance from the left of one label to the left of the label to the right of it. If you want to actually increase the distance between columns of labels, i.e. if labels get increasingly (or decreasingly) cut off as you go across the sheet, change this.

Vertical pitch

The distance from the top of one label to the top of the label below it. If you want to actually increase the distance between rows of labels, i.e. if labels get increasingly (or decreasingly) cut off as you go down the sheet, change this.

Width

Just the width of the actual space for the label content.

Height

Just the height of the actual space for the label content.

Left margin

The distance from the left side of your sheet of labels to where content begins. If all your labels are getting cut off on the left, adjust this.

Upper margin

The distance from the top of your sheet of labels to where content begins. If all your labels are getting cut off on the top adjust this.

Columns

The number of columns. You don't need to adjust this.

Rows

The number of rows. You don't need to adjust this.

Examples

Here's a normal sheet, next to one where I increased just the top margin. Click the image to see it larger.

Tweak4

Here's an example where I increased the vertical pitch by a half inch. You wouldn't want to increase it that much, but I made it big to make sure you could see the effect. Click the image to see it bigger.  Note that on the right, you only are at the 5th row while at the same place on the left, you're at the 7th row.

Verticalpitch

Once you've got the label adjustments where you want them, click Save in the Format tab. Name the label in the window that appears, and click OK.

Tweak7

Then when you create labels again, that saved format will be in the list.

Tweak8


Traininglogo




October 23, 2007

Summary of new features in OpenOffice.org 2.3

Here’s a summary of the features from the 2.3 new features list that I considered the most useful or important to write about. This page  http://wiki.services.openoffice.org/wiki/New_Features_2.3 about the new features is an excellent guide, as well.

General

  • This is convenient for anyone who prints to multiple printers, all over the world. You can load or ignore the printer settings for your documents. This means you don’t end up accidentally printing to the printer in building 4 which is on the opposite side of the country, just because you were on a business trip there last week and that’s where you last printed your document.
    Feature_printsettings

  • If your document isn’t wider than the OpenOffice.org window, then it will be centered in the window, not left-aligned.
    Feature_centered

  • Lots of locale information was added, for locations such as Tagalog, Frisian, and Hausa.
    Feature_locale

Writer and Web

  • The HTML editor now has a preview feature. Choose File > Preview in Web Browser and the document opens in the default browser.

  • I love this feature. You know how when you get a hyperlink but then want to retype it or reformat it, but clicking on it takes you to the target of the link? No more. You can select hyperlinked text all you want; you now have to Ctrl Click to open a link. This is very nice.
    Feature_controlclick

  • The notes say that there is a new compatibility option on Tools > Options > OpenOffice.org Writer > Compatibility: Do Not Justify Alignment in Lines Ending With Manual Line Break. However, I’m mentioning this because I couldn’t see it. The illustration shows the compatibility options that are there.
    Feature_writercompatibility

  • When you open the Styles and Formatting window (Format > Styles and Formatting), you can set what kinds of styles you wanted to see: Applied, Custom, Automatic, etc. Previously, you had to reset this every time you opened a new document or re-opened OpenOffice.org. Now, thankfully, that category will stick. The setting is saved per application. However, the choice you make for Paragraph, Character, Frame, List, or Page doesn’t stick.
    Feature_stylist_2

  • When you right-click on text, you used to see Default as one of the options. Now you see Default Formatting, which is clearer. (Default Formatting is a great way to just clear out any extraneous formatting and apply the default style to the selected item.) This is a very nice feature regardless of the text; for one thing, it’s the best way to remove the hotlink from a URL.
    Feature_defaultformatting

  • A new export filter lets you export to MediaWiki format. Choose File > Export and select MediaWiki in the file format list.

Calc

  • This is a very, very smart change. By default, the print options for Calc are now set to Print Only Selected Sheets and Suppress Output of Empty Pages. If the Print Only Selected Sheets option is enabled, the Calc page preview shows only the displayed sheet and the message “There is nothing to print.” To change these options, choose Tools > Options > OpenOffice.org Calc > Print, or choose File > Print and click the Options button.
    Feature_calcprintoptions

  • Here’s another very smart change that will screw up all my documentation. :) The SUM icon on the main Calc toolbar has changed. Now you can select the range of numbers to add, click the SUM icon, and get the total in the first cell below the selected range. Phew. But if you liked it the old way, it still works that way, too.
    Feature_sumicon

  • Graphics can be linked to macros. This should help with Excel compatibility.
    Feature_graphicmacro

  • The Excel export filter now handles the cotangent functions COT, ACOT, COTH, and ACOTH.

  • Calc now supports inline matrix/array constants in formulas. An inline array is surrounded by curly braces '{' and '}'. Elements can be each a number (including negatives), a logical constant (TRUE, FALSE) or a literal string. See this link for more detail. http://sc.openoffice.org/servlets/ReadMsg?list=features&msgNo=230

  • You can now use dynamic ranges, rather than absolute ranges defined with $, in lists in Data Validity. Choose Data > Validity, and under the Criteria tab select Cell Range from the list.
    Feature_cellrange

  • The GETPIVOTDATA function returns a result value from a DataPilot table, so it can be used in a cell formula.
    Feature_getpivotdata

Mail Merge, Databases, and Forms

  • The infamous checkbox on the print message when you print a mail merge document, Do Not Show Warning Again, is gone. Phew! See this blog http://openoffice.blogs.com/openoffice/2006/10/how_to_get_the_.html for why that caused problems.
    Feature_mailmergemessage

  • This is nice. When you choose File > Print with a mail merge document, in the Mail Merge window, you can choose to save the document as separate documents or as one document.
    Feature_mailmergesinglefile

  • Unfortunately, in Base there is still no File > Export or File > Import feature. File > Export does appear, but it’s dimmed.


Traininglogo




October 03, 2007

A fabulous way to do list numbering. Note: with great power comes great responsibility and a little extra setup work.

Spidermanlogo

OpenOffice Writer numbering is powerful but it lacks at least one very important feature. Well, two. Here's the first.

First Problem

To restart the list at 1, you have to do it manually. You have to click on something like this, click on the first item:

6. Badgers
7. Toads
8. Owls

and click the Restart at 1 icon on the numbering toolbar
Restarticon

to make it look like this.

1. Badgers
2. Toads
3. Owls

NOTE However that this restart attribute is NOT available when you create a style. You can't create a style that restarts at 1. So it's a manual-only attribute. This can be annoying. Especially since importing new versions of the style you're using can wipe out the restart setting.

Fieldsrestartissueinstyle

Second Problem

The numbers are inserted automatically so you can't click between the number and the text to insert a tab, or just format the number directly, or whatever. You can do this all through the numbering setup window, so it's not a huge issue, but sometimes it's nice to just grab hold of something and format it.

Here's what you might want to do if these are problems for you and you're up for something completely different.

I really like it. It's powerful and reliable.

The solution comes from my colleague Jean Weber, at www.jeanweber.com.  She has an excellent book on Writer, including high-end complex issues like this.

Here’s the link to the OOo doc, to which she contributed. http://documentation.openoffice.org/manuals/oooauthors2/

Here’s a link to her book on Amazon. http://www.amazon.com/OpenOffice-org-Writer-Free-Alternative-Microsoft/dp/0596008260/sr=8-1/qid=1163013762/ref=pd_bbs_1/002-0539644-5923228?ie=UTF8&s=books

Here’s a link to the file you’re going to be using to solve this problem. http://documentation.openoffice.org/manuals/oooauthors2/0214WG-WorkingWithFields.pdf

What you do is, you create a numbering series of your own that has nothing to do with the normal numbering.

I’ll leave the particular details to Jean’s guide; go to the section called Defining your own numbering sequences. Here’s what you need to accomplish.

1. Create a single number range for every level. For instance, if your top level is regular Arabic, your second level is Alphabetic, and your third level is lower Roman, then create a single number range for each of those called Arabic, Alpha, and Roman (or one two and three, or Larry Moe and Curly, or whatever). Choose Insert > Fields > Other, click the Variables tab, choose Number Range on the left, and the rest is pretty clear. Jean's guide provides lots of nice detail for this.

Fields1

2. Create paragraph styles with the indenting you want, one style for each level. The paragraph styles are what will take care of the indenting. You also need to set up the correct tabs since you’ll press Tab between the number range and the text.

Here are examples for levels 1, 2, and 3. In this formatting example  there’s an indent of .3 inches from the left margin of the document for all text. Also the distance from the number to the text is .3 inches.

Level 1 (plus set a .3 tab in the Tabs tab)

Paragraphsetuplevel1

Level 2 (plus set a .3 tab in the Tabs tab)

Paragraphsetuplevel2

Level 3 (plus set a .3 tab in the Tabs tab)

Paragraphsetuplevel3

3. Start inserting the numbers, just anywhere in the document. You're going to insert them, then make shortcuts so that you can insert them more easily.

Choose Insert > Fields > Other, select your top level variable such as Arabic, specify 1 in the Value field, and click Insert.

Fields2_1

Now   create your ArabicContinued field.  Press Return or just make a space or two. Still in the Fields window, delete the 1 from the Value field, and click Insert to insert another field of the same range. It’ll show up in the document as  2. Click Insert again if you want to prove it's working; it'll show up as 3.

Fields3

DO NOT set up different variables here for the regular and the restart. They need to have the same name.

Do the same for the first item and the next item at all the levels you’re using.

4. Apply the appropriate paragraph styles to each number range you're using. If you created a paragraph style called TopLevelNumbering, apply it to all the Arabic fields (or whatever you're using at the top level). Also press Tab to insert a tab after each number.

5. If you have a lot more work to do, you want all this inserting stuff to be easier so make AutoTexts.

5.a. Select the first top-level numbering item, the Arabic one that equals 1 and the tab. (Not crucial, but as long as you're saving yourself some work, you can make the tab show up automatically, too.) Be sure the appropriate style is applied so that you can bundle the number and the correct style into one convenient autotext.

5.b. Choose Edit > AutoText. Type a name like ArabicRestart, make the shortcut something obvious like AR for ArabicRestart. Click and hold down on the Autotext button and choose New.

Autotext

5.c. Repeat the steps for the next number at that level, the one that doesn’t have 1 as the value. So select the field that shows 2 in your document, choose  Edit > AutoText,  and call this one just Arabic or ArabicContinued. Make the shortcut something like A or AC.

5.d. Repeat those  steps for every level.

6. Now just keep on formatting or typing your list by inserting numbers. Type AR F3 (the shortcut plus the key that says "insert the autotext with that shortcut" to insert a numeral 1 plus a tab. Type AC F3 to insert a sequential continuous number.   

Note on inserting: You can't have the cursor immediately next to any existing text or the AutoText tool will get confused about what you want to do. There has to be at least a space between the cursor and any other text.

Alternately, if your list already exists, copy and paste the appropriate restart and continuous number variables to the appropriate spots, rather than using the shortcut keys.

In Conclusion

Is it wildly different from normal numbering? Yes. Is it complicated to set up? No more than any other complex numbering.

Does it offer much more reliability and control than other numbering in OpenOffice Writer, for complex lists? Yes, yes, oh god, yes.


September 17, 2007

Sorting: Your basic everyday sorting

In the mood of fall cleaning and to celebrate having gotten my office organized, I'm going to blog this week about sorting. Today, it's just basic run-of-the-mill sorting using the sorting icons on the toolbar.

Sort3icon

Let's say you've just got this list, and you want to sort it alphabetically.
Simple1

Select it, without selecting any data you don't want sorted.
Simple2

Click either the A-Z or Z-A icon.
Sort3icon

You get your results.
Simple3

Be sure not to select any headings, i.e. the word Employee in this case, or you get this result, which you don't want.
Simpl4bad

What if you have something like this, though? Something with multiple columns.
Sort1

Here's the thing. Selecting, say, the 2000 column and clicking a sort icon will NOT give you good results. It will sort just the data in the 2000 column and leave all the other data behind. So all of a sudden your data is wrong.

You cannot specify the column to sort by, using the simple sort icons. That's covered in my next blog entry on sorting.

Here's what you can do. You can sort by the first column in the data set. You select ALL the data, again without the headings.
Sort2

You click the sort icon you want.
Sort3icon

And you get your results; the data is sorted by the first column. That's your only choice.
Sort4_3

If you had selected just one column, the data would be goofed up.
Sort5bad

For more control over sorting, tune in for the next sorting blog.













Traininglogo




September 13, 2007

Back to School: Creating cute graphic-filled borders in OpenOffice Writer like you can in Microsoft products

Bor11pagepreview

One of the nice things about Microsoft products is that they have a lot of prefab goodies.  OpenOffice.org is a little more of a from-scratch situation. But you have much more flexibility, and you can still do a lot of great stuff. It's not easy, at least not using this approach, to add borders all around, but you can do it in the top and bottom.

Step 1: Add graphics to the gallery.

You can find lots of great graphics on the Internet by googling for "free clip art." For the purposes of borders, keep an eye out for graphics that are small, i.e. under an inch by an inch, and also that have some white space around them.

Step 2: Learn to use the feature documented here.
I'll also describe it in this blog but that's another one that talks about using it in general. Can't hurt to skim that blog.

Step 3: Use this blog entry to add top and bottom headers and footers with any appropriately sized graphic in your gallery.

NOTE: To take out the repeating background borders in this blog, use the instructions here or just Undo (Ctrl Z or use the Undo icon) to go back to not having a background border.

How to Create Graphical Top and Bottom Borders in the Header and Footer

First, open your document.

Bor1

Turn on the header and footer. Choose Insert > Header > Default, then Insert > Footer > Default.
Bor2

You now have headers and footers. The graphics will repeat in the background of each to create the graphical border.

Bor3

Next, turn on the Gallery by choosing Tools > Gallery or clicking the Gallery icon.

Bor4

Find a category you like, then find a graphic you want to use. Drag the graphic into the document to see how big it is, if you don't know. This one, for instance, is too big. To delete it, just select it so that the green handles are showing, in the document, and press Delete on your keyboard. You can also press Ctrl Z or use the Undo icon.
Preview1

This one is better. It's a good size, plus there's some white space around the graphic so that when it tiles, you won't see part of another row of the graphic.

Preview2

Delete the graphic from the document once you know which one you're going to use.

Click in the header.
Bor5small

Right-click on the graphic, in the gallery, and choose Insert > Background > Header.

Bor8insert

The graphic will appear, repeating, but not all of it will show at first.
Bor9insert

Click in the header and press Return once or more times to add more space, to show the entire graphic.

Halfshowing

If part of the graphic is showing on the right side, click in the header and move your mouse over the ruler, at the edge of the right margin. When your mouse becomes a 2-ended arrow, click and hold down, and drag to the left or right to show the amount of graphic you want.

Half

Then only whole graphics will show.

Bor10adjust_2

Then click in the footer, and do the same thing. Insert the same graphic, or another graphic if you want, in the background of the footer, then adjust it as necessary the same way you adjusted the header.

Bor11insertagai_2

Choose File > Page Preview to see the document.

Bor11pagepreview_2


Traininglogo




September 10, 2007

Getting a Picture from a Document Into the Gallery

I've already written about how to get a graphic from a file on your computer into the Gallery. But how do you get a graphic you like, that's just sitting in some OpenOffice document, into the Gallery? You could just copy it and paste it from that document to others, but putting it in the Gallery is more convenient.


1. Open the document containing the graphic.
Drag1_2

2. If the gallery isn't showing, open the gallery by choosing Tools > Gallery or clicking on the Gallery icon.
Galleryicon

3. Select the theme, the category you want to put the graphic in, in the gallery.

4. If you want to make a new one, click New Theme. Type the new name and click OK. Then select that theme in the Gallery.
Mytheme

5. Select the graphic. Release the mouse.
Drag3

6. Click and hold down, and keep holding down on the graphic, for at least two seconds. Don't release the mouse, and drag the graphic into the gallery.

Drag4

7. The graphic will appear in the gallery, at whatever location is set up as your gallery location, in a subdirectory for draganddrop.
Drag5

You can set or change your gallery paths here. Tools > Options > OpenOffice.org > Paths.
Drag5showpaths


Traininglogo




September 04, 2007

Making Illustrated Callouts With Clip Art From the Gallery, and the OpenOffice Callout Drawing Tools

Earlybird_2

I love the callouts in OpenOffice.org. I also love that they're available in Draw, Impress, Writer, and Calc.

To get started, just choose View > Toolbars > Drawing. If there isn't a checkmark next to the Drawing option, select it.

Viewtoolbars
Now look for the Drawing toolbar. It usually appears at the bottom of your work area.

Toolbar

Adding a Graphic

You can choose Insert > Picture > From File to add a graphic if you know where it is. Or just choose Tools > Gallery to turn on the picture gallery, and drag in a graphic from there. Click here to learn more about using the Gallery, including adding graphics to it.

Cl2drag

Adding a Callout

You can choose Insert > Picture > From File to add a graphic if you know where it is. Or just choose Tools > Gallery to turn on the picture gallery, and drag a graphic into your document.

1. Be sure you've got the Drawing toolbar on, according to the instructions at the top of this blog.

2. Find the Callouts icon.
Call1_2

3. Click and hold down on the black triangle to the right of the Callouts icon.
Call2

4. Click on the tool you want. Move your mouse into the drawing area.
Call3

<>

5. Click and hold down, drag your mouse down and to the right (or up and to the left) and you'll see the callout being drawn.
Call4

6. Release the mouse, the callout you drew appears.
Call5

<>

7. Select a different fill color for the callout.
Call6

8. Select different line width, style, and color for the callout.
Call7

9. Double-click in the graphic; the cursor will appear.
Call8

10. Type the callout.
Call9

11. If the text is too big, click the callout border, find a handle, and drag the handle to resize the callout.
Call10

12. Double-click in the callout to select the text so you can change the font, then select a font from the dropdown window.
Call11

13. Drag the point of the callout to where it needs to be; it will change sides if necessary. Alternately, drag the callout to a different position in relation to the graphic.
Call12

And you're done!

Call13


From Draw or Impress: Exporting the Graphic to Reuse Later (for Use in the Gallery, on a Web Page Like This Blog, or Any Other Reason)

You can copy and paste to Writer or Calc. However, if you want to add your graphic with callout to the Gallery, put it in a web page, or anything else more reusable, do this.

Select everything you want to export. You can select everything manually, press Ctrl A, or just draw  a box with your mouse (not the box tool) completely around the items to select.
Ex1_2

Choose File > Export.

Specify the location to export to and name the file. Select the format, not HTML but JPG, PNG, or something similar.
Ex2

Click Save.

If a message prompts you to make some choices, either click OK accepting the options, or make your choices. For instance, with JPG, the highest number is the best quality.

Ex3


 


Traininglogo




August 27, 2007

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

Logo_flower

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 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.
Conveter1

Step 2, then just follow the wizard as prompted.
Converter2


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.
Point1

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.)
Point3

Click OK, and OK, and OK  again.

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


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.


Traininglogo




August 16, 2007

Addon tools for OpenOffice.org Writer

I received this information a while ago and have been meaning to blog about it for some time.

http://nothickmanuals.info/doku.php/writertools

After a cursory look, it's a set of macros that provide the following tools:

  • Lookup Tool allows you to lookup the currently selected word in several online references, including Cambridge Dictionaries, WordNet, and Google Define.
  • Google Translate allows users to quickly translate selected text fragments between different languages using the Google Translate service.
  • Show on the Map tool allows you to select a city, a street name, or a postal code and map it using the Multimap service.
  • Email Backup can be used to quickly send a backup copy of the currently opened document to a specified email address.
  • Multi-format Backup macro saves the currently opened Writer document in the Word, RTF, and TXT formats. The backup files are stored in a separate folder with a date stamp. On Linux, the macro also archives the resulting folder using the tar utility.
  • Remote Backup allows you to quickly save a backup copy of the current document on a FTP server.
  • Convert to DokuWiki converts the current document into DokuWiki format.
  • Start/Stop Timer tool can be used to keep tabs on time spent on the currently opened document and save the time data (the document name, used time, and date) in the accompanying WriterDB database.
  • Word Hunt Game is a simple game, where you have to guess the word randomly picked by Writer.
  • Word of the Day tool picks and displays a random word and its definition from the from the accompanying WriterDB database. As a writer, you may often come across a new word or an interesting expression. The WriterDB database allows you to store your language findings in one place, while the Word of the Day tool helps you to keep them active in your memory.
  • Add to Basket tool copies the currently selected text fragment into the basket table in the WriterDB database. It’s perfect for storing notes and text snippets.

The web site states that the Writer’s Tools extension is released under GNU GPL and that Writer’s Tools is very much a work in progress.

Once installed, you get this menu.

Wt1

The lookup tool, for instance, gives you this window at first:

Wt2lookuptool

You then get this window or a similar one with the results.

Wt2lookuptoolresults

Converting to docuwiki looks like this:

Wr3converttodocuwiki

I got an error trying to use the add to basket feature. I might or might not have fully set up the database correctly.

Here's the first window of the translation feature:

Translate12

And the results.
Places to Stay and Things to Do was translated into Plätze zum zu bleiben und Sachen zum zu tun by Google.

Translate2


Traininglogo




August 13, 2007

Printing Envelopes in OpenOffice.org Writer (Repost)

I ran into Christian Einfeldt at Linuxworld, who mentioned that he had some questions about printing  envelopes. It's a good perennial topic, so I'm rereposting.


(Originally posted December 2, 2005)

I get a lot of questions about envelopes. A lot. I wrote an article for TechTarget.com about how to do envelopes in OpenOffice.org 2.0.

I included some templates there; here are the same envelope templates for OpenOffice.org 2.0.


The article is long and detailed. Here are the key points.


  • You need to get to know your printer and let it know to expect envelope shapes, not letter or A4 shapes.

  • You also