Using OpenOffice.org

February 22nd, 2003 by John Mark Walker in

Tips for working with this free office suite so you can have Linux in the Workplace.
Your rating: None

Editor's Note: Linux in the Workplace, written by the Linux Journal Staff, was recently released under the GNU Free Documentation License (FDL). It is available at linuxpip.org, courtesy of No Starch Press.

This is my first article of a series that embraces and extends the book, Linux in the Workplace, which was written by several staff members of Linux Journal and published by No Starch Press. The purpose of that book, the same as this article, is to show new Linux users to do those everyday, ordinary tasks for which people use computers in the first place.

This particular article focuses on OpenOffice.org (the office suite formerly known as OpenOffice), in particular its word processor component. Please note that this article is from a KDE-centric viewpoint. Almost all of the items mentioned here, however, apply equally well to GNOME and other desktop environments.

Introduction to OpenOffice

OpenOffice.org is a feature-rich office productivity suite distributed and maintained by Sun Microsystems. Comparable to Microsoft Office, OpenOffice.org includes a word processor, a spreadsheet application, presentation software and graphic program applications. OpenOffice.org is incredibly powerful; many believe that it is not only as good as MS Office, but better in many ways. OpenOffice.org is available for other platforms as well, including Solaris and Microsoft Windows, and it runs equally well on all of them. OpenOffice.org offers the ability to import many different types of documents and templates from a variety of other programs, including Microsoft Word. It can also export to a wide range of formats, including HTML, PDF and MS Office XP.

OpenOffice.org may be included on your distribution already. If it is not, simply visit www.openoffice.org, where you can download the latest version for free. This site also contains a list of distributors who sell CD-ROMs that install the software. On-line help also is available.

The default OpenOffice.org installation places an OpenOffice.org submenu in the K menu, for users of KDE. From there, you can launch any of the OpenOffice programs (Writer, Calc, Draw or Impress). You also can click on any existing OpenOffice document to open it within the appropriate OpenOffice application. Once the application is open, another OpenOffice program can be started from the open application's File menu. The menus and toolbars may look familiar to you, as they are similar to those of other office programs. The main menubar at the top and two tiers of toolbars are displayed by default. As usual, many of the most used menu items are available from the icons in the toolbars. You can discover the function of an icon by holding the mouse pointer over it.

Working with Text

Writer is a word processor that allows you to compose documents such as letters and articles, as well as import and export documents from other systems in a wide range of file formats, including HTML, ASCII, RTF and MS Word.

Using the AutoPilot

AutoPilot, often referred to as a wizard in other office programs, guides you through a series of document customization questions. To use this feature, select AutoPilot from the File menu. Then choose the type of document you want to create. Options include memos, faxes, letters and web pages. Once selected, the AutoPilot Agenda dialog box appears. You are instructed to customize your document by choosing a layout style, including a logo or graphic, and naming your file. Click Next to select your desired options, and continue clicking Next each time you are done with a set of customization questions. When you are finished, click Create, and your document loads.

Formatting Your Document

Formatting allows you to choose the font and page styles to apply to your document, and many options are available in Writer. Here we review standard formatting tools. Advanced users can feel confident that other formatting features, such as those that let you apply text styles, add tables and create indices, are all available. They generally are located in the same places you would find them in other word processing applications. All of these formatting options can be set before beginning a new document or applied to existing documents.

Increasing and Decreasing Indents

To increase or decrease the indentation of text, click one of the two indent icons, featured just above the document to the right of the numbers and bullets icons. The icon featuring text and an arrow pointing left decreases an indent, whereas the icon featuring text and an arrow pointing right increases an indent. Click the appropriate icon more than once to add more or less indentation.

Applying Color

Color can be applied to text characters or added as a highlight over a string of text. The color icons are found next to the indentation icons. Select the text you want to color or highlight by clicking and dragging your mouse pointer over the desired text. Then click the icon featuring a yellow background behind the A character, and your text is highlighted. Color also can be applied to the background of a document. The icon that features a complete palette of colors (positioned next to the character color icons) performs this task for you. When you click the background color icon, a dialog box appears and prompts you to select a color. Once you have clicked on the desired color, your background changes to the new color.

Advanced Formatting Tools

Advanced page formatting tools are available in a central dialog box titled Page Style. To access it, select Page from the Format menu, and the Page Style dialog box appears. Here you are given the opportunity to select the background color, size and margins of the document; apply headers, footers and borders; and even set columns. Advanced paragraph and character formatting tools also are available. Select Paragraph or Character from the Format menu, and the Paragraph or Character dialog box appears. From here you can apply drop caps, tabs and alignment, among other advanced paragraph formatting tools. To add page numbers to your document, choose the Footer tab from Format -> Page, check the Footer On box and select OK. Next, from the Insert menu choose Fields and then Page Numbers. A 1 appears in the footer. If you want the page numbers to appear as 1 of 10 or 1 of 18, and so on, select Fields and then Page Count. Next, under Footer, edit the text to add the word "of".

Inserting Graphics into Your Document

From the Insert menu, select Graphics and then From File, and the Insert Graphics dialog box appears. Select the graphics file name just as you selected an existing document file. Once your graphic appears in the document, you can double-click it at any time to pull up the Graphics dialog box. Here you can crop, make the image a hyperlink or add a border. Once you have selected the options you want, click OK to proceed with the changes or Cancel to cancel any changes. To delete the graphic, simply select it with the mouse and select the cut icon, or right- click the image and select Cut from the pull-down menu.

Saving Your Document

To save your document, select the floppy disk (save) icon from the top toolbar or select the Save or Save As options located on the File menu. The Save dialog box appears, instructing you to name your file (if it is not already named), designate the directory to which you want to save the file, and choose the file format you want your document to be saved as (click the arrow next to File type to see a list of file format options). This is where you can prepare your document for exporting, as mentioned previously.

Creating Document Templates

Although the current version of OpenOffice.org does not come with existing document templates, it is possible to create templates. Start by opening a new document. Create a set of styles and give it the desired structure, and then simply save the document as a template from the Save As dialog box.

Printing Your Document

Printing your document is easy. Simply select the print icon from the toolbar immediately below the menubar or select Print from the File menu. In either case, a Print dialog box opens, giving you the option to print to your printer or to a file. Options are presented to print a range of pages, if you don't need the whole document, or to print multiple copies.

For the next article, I will go into more depth for advanced OpenOffice.org functionality, including fun with contact managers, mail merge and printing pitfalls.

John Mark Walker is the Marketing Manager for No Starch Press.

__________________________


Special Magazine Offer -- Free Gift with Subscription
Receive a free digital copy of Linux Journal's System Administration Special Edition as well as instant online access to current and past issues. CLICK HERE for offer

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

Comment viewing options

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

OpenOffice.org TUTORIALS

On March 3rd, 2003 Anonymous says:

Any suggestions on some good tutorials - I need them to teach Open Office to school students Thanks

Anonymous's picture

Re: OpenOffice.org TUTORIALS

On October 19th, 2003 Anonymous says:

Hi :-)

Take a look at this page:

http://www.kaaredyret.dk/openoffice_links_uk.html

Anonymous's picture

Re: Using OpenOffice.org

On March 3rd, 2003 Anonymous says:

I'd use OpenOffice more often, but it doesn't have one feature that I cherish on MS office, and that is the inclusion of a gallery of preformatted documents that you can just change the text to suit your needs. For instance, a preformatted resume' template where all I do is fill in the values. It makes work go much faster. One other thing is the lack of fonts and the inability to type in things like mathematical symbols.

Anonymous's picture

Re: Using OpenOffice.org

On July 21st, 2003 Anonymous says:

insert->object->formula .. that gies you the "mathematical symbols".. i use it all the time for assignments

Anonymous's picture

Re: Using OpenOffice.org

On March 10th, 2003 Anonymous says:

I think maybe this represents one of the differences between a commercial program, such as office, and an open source program such as OO. However the answer is in your hands and the hands of others who use OO. If you can create some templates then make them available to OO. If others do the same re their particular areas then very quickly OO could have an even better set of templates than office.

Anonymous's picture

Re: Using OpenOffice.org

On March 6th, 2003 Anonymous says:

Actually there is a web site for templates, but personally I havent found any good ones yet. This is not so much a proble mfor business, since those have to roll out their own CD/CI document templates anyway.

http://whiteboard.openoffice.org/doc/Samples_Templates/User/template/

http://ooextras.sourceforge.net/

Greetings

Bernd

--

www.eckes.org

Anonymous's picture

OpenOffice documentation

On March 1st, 2003 Anonymous says:

Some of the previous posts complained about the lack of documentation for specific features. It may be helpful to know that Prentice Hall has published a new book : OpenOffice.Org 1.0 Resource Kit. With a thousand pages, it certainly offers more tips than one can ask for.

Anonymous's picture

It lacks OLAP support

On February 28th, 2003 Anonymous says:

Unfortunately OO completely lacks support for OLAP queries (MDX or JOLAP), in order to be used as a frontend to OLAP servers.

Excel has this feature, which is important for industries, which use it for advanced data analysis.

It would be nice to have support for JOLAP built into it, as a reference implementation.

Anonymous's picture

Linking with MySQL

On February 27th, 2003 Anonymous says:

Would be great to see deeper explanations/uses for using MySQL with OO. (Further than the recent articles on hooking them together) - for example, how would we create form letters or envelopes?

Thanks!

Anonymous's picture

Re: Using OpenOffice.org

On February 25th, 2003 Anonymous says:

Yes, I use OpenOffice.org on Windows and Linux. I think it has great potential but when it comes to certain tasks, it is just not quite ready for small business use. I cannot or at least I have not figured out how to print column headers for

each page printed on my printer using the spreadsheet tool.

Sure, I can print a header. but no column headers? I cannot

give customers a 20 page price list that only has a column header on the first page!

Anonymous's picture

Re: Using OpenOffice.org

On August 11th, 2003 Anonymous says:

Can someone tell me how to paste screenshots into an OpenOffice.org document. Here is what I have done so far, without success.

1. Press ALT Printscreen (I also tried using Printscreen alone)
2. Go to the place in document I need to Paste and Press CTRL V or PASTE icon

Your suggestions will be greatly appreciated.

Thanks
OpenOffice.org Newbie

johnmark's picture

You can print headers

On February 25th, 2003 johnmark (not verified) says:

Actually, you can, although it's not in a very intuitive place. If you select Format -> Print Ranges -> Edit, you can define what row(s) or column(s) to repeat. There's probably another way to accomplish the same thing using defined names and such, but I never really understood what that was for anyway.

-John Mark Walker
Marketing Manager
No Starch Press
Linux in the Workplace

Anonymous's picture

Re: You can print headers

On February 26th, 2003 Anonymous says:

Thanks for the tip on column headers. I think that if OpenOffice.org is to compete against the dark-side it needs

to focus more on the meat and potatos and less on the special

effects. (at least for now) For example, more cute and paste power would be great. Better ODBC support (not that it is bad now). Improved intergration with Linux would be great - Redhat does a good job but getting a RPM upgrade to 1.02 is not available as far as I know? One thing that would cool, would be script (like VBS, Perl or Python...) control of the spreadsheet object, so one could populate the cells from a database - my wish list!

Anonymous's picture

Re: Wish list

On February 27th, 2003 Anonymous says:

Be careful with your wishes -- they can become true. Better scripting would be nice, but OOo could become a virus-fertile environment such as MS Office.

A virus-free environment is my wish #1.

My wish #2 would be a kind of "OpenOffice.lite", with less features.

sentiblue's picture

Re: Wish list

On March 29th, 2003 sentiblue (not verified) says:

Yes sir... I definitely agree on this virus part....

years ago I was an Excel and Access programmer.... All I did was writing these macros using VB and the thing that drove me nuts almost everyday was the Laroux.AJ or whatever the heck it was....

this virus was embedded in the source code of the macro page... yet you can't delete the whole thing cuz some of it is written by you for very specific purpose... when it travels through couple email destinations, it detaches my autoopen() function and replaces with its own... people who are used to seeing my report thought i did this... gosh! nightmare!!!

Anonymous's picture

Re: Using OpenOffice.org

On February 25th, 2003 Anonymous says:

Actually, you can, although it's not in a very intuitive place. If you select Format -> Print Ranges -> Edit, you can define what row(s) or column(s) to repeat. There's probably another way to accomplish the same thing using defined names and such, but I never really understood what that was for anyway.

-John Mark Walker
Marketing Manager
No Starch Press
Linux in the Workplace

Anonymous's picture

Re: Using OpenOffice.org

On February 25th, 2003 Anonymous says:

I almost never use a spreadsheet, so I don't know how to do it in the spreadsheet, but I have just done just what you want with a table in the word-processor. It shouldn't be too difficult to copy the spreadsheet to the wordprocessor I guess.

Post new comment

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

More information about formatting options

Newsletter

Each week Linux Journal editors will tell you what's hot in the world of Linux. You will receive late breaking news, technical tips and tricks, and links to in-depth stories featured on www.linuxjournal.com.
Sign up for our Email Newsletter

Tech Tip Videos

From the Magazine

December 2009, #188

If last month's Infrastrucuture issue was too "big" for you then try on this month's Embedded issue. Find out how to use Player for programming mobile robots, build a humidity controller for your root cellar, find out how to reduce the boot time of your embedded system, and if you're new to embedded systems find out the basics that go into one. You can also read about the Beagle Board, the Mesh Potato and a spate of other interestingly named items. And along with our regular columns don't miss our new monthly column: Economy Size Geek.


Read this issue