Using OpenOffice.org
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 OpenOfficeOpenOffice.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 TextWriter 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 AutoPilotAutoPilot, 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 DocumentFormatting 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 IndentsTo 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 ColorColor 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 ToolsAdvanced 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 DocumentFrom 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 DocumentTo 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 TemplatesAlthough 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 DocumentPrinting 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.










This week 5 lucky Members will receive a copy of The Official Ubuntu Server Book by Benjamin Mako Hill and Linux Journal's very own Kyle Rankin. No entry necessary. Check back here early next week to find out who the lucky Online Members are.




Comments
OpenOffice.org TUTORIALS
Any suggestions on some good tutorials - I need them to teach Open Office to school students Thanks
Re: OpenOffice.org TUTORIALS
Hi :-)
Take a look at this page:
http://www.kaaredyret.dk/openoffice_links_uk.html
Re: Using OpenOffice.org
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.
Re: Using OpenOffice.org
insert->object->formula .. that gies you the "mathematical symbols".. i use it all the time for assignments
Re: Using OpenOffice.org
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.
Re: Using OpenOffice.org
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
OpenOffice documentation
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.
It lacks OLAP support
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.
Linking with MySQL
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!
Re: Using OpenOffice.org
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!
Re: Using OpenOffice.org
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
You can print headers
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
Re: You can print headers
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!
Re: Wish list
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.
Re: Wish list
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!!!
Re: Using OpenOffice.org
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
Re: Using OpenOffice.org
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