Chapter 10. Office Work

Table of Contents
10.1. StarOffice Writer
10.1.1. Getting Started
10.1.2. Getting Help
10.2. Spreadsheets
10.2.1. What Is a Spreadsheet?
10.2.2. Gnumeric
10.2.3. StarOffice's StarCalc
10.2.4. Conclusion

10.1. StarOffice Writer

StarOffice was conceived by Marco Börries in 1985 and he was so successful with this office suite that he decided to offer it to a wider range of users, that is GNU/Linux, MacOS and Windows users alike. In this chapter, we will refer to the 6.0 version, which is different from the OpenOffice.org suite developed by Sun Microsystems and the open-source community. The latter, however, is completely GPL, whereas the one we describe is still in binary form, therefore proprietary. This may mean absolutely nothing to you. If you feel dazzled, please refer to the Reference Manual's The GNU General Public License appendix.

Warning

As we are writing this documentation, we are still unsure whether StarOffice or OpenOffice.org will be included in our distribution. The OpenOffice.org package should be either in the main CD-ROM or in the contribs section.

The StarOffice Suite can be used for many purposes. It acts as a WYSIWYG (What You See Is What You Get) word processor, a spreadsheet, a presentation software, etc. In this section, we will describe the word processor's functioning, while the StarOffice spreadsheet will be described in the section called Spreadsheets.

10.1.1. Getting Started

Figure 10-1. Writing Documents

Let us go through the menu in order for you to grasp StarOffice's capabilities. But first, to launch StarOffice, click on your KDE menu icon, then choose the Office->Wordprocessors sub-menu and choose StarOffice. You can also create a symbolic link on your desktop. To do so, right-click anywhere on your desktop and choose Create New->Link to Application.

Figure 10-2. Linking to StarOffice

Then, write the name of the application in the dialog box followed by the extension .desktop and choose an icon by pressing on the default one. Also, in the Execute tab, you must set the path for the application to be launched. It should be:
/home/your_user_name/staroffice60/soffice

Figure 10-3. Linking Properties

Note

A little comment about keyboard shortcuts... Many of us are still fascinated by this little two-or-three button thing called the mouse. Keyboard shortcuts allow to execute simple commands and apply them for specific meanings, hence leaving your hands on the keyboard and accelerating the rhythm at which you can make your work progress. As an example, Ctrl-O opens a document, Ctrl-C copies a piece of document which you want to copy elsewhere, etc. Browse through the menus, you will see that shortcuts are set for most major functions.

File Menu

It enables simple commands such as Open, Close, Print, etc. This is probably the mostly used menu since it holds the utmost basic commands. It is also through this menu that you access the latest opened documents.

Edit Menu

Since it contains the famous Cut & Paste commands, it is also largely utilized. The very practical Find & Replace option is also found in this menu. Ctrl-H pops up this familiar window.

Figure 10-4. Finding And Replacing Words

Note

Notice the little underscore under each menu item. This is another rapid way to access commands. For example, Alt-E (Edit Menu) and the N character is a shortcut to the Navigator (F5 is another way to access it).

Figure 10-5. StarOffice Navigator

View Menu

The Zoom, Toolbars and Nonprinting character are within this handy menu. If you have the unfortunate bad luck of owning a 14'' screen, you will surely appreciate the zoom option... By configuring your toolbar, if you are a mouse aficionado, remove the buttons you never use and replace them with more often-utilized ones. As for the Nonprinting character, it facilitates basic letter and document layout, in order to be very precise.

Figure 10-6. Nonprinting Characters

Insert Menu

This menu holds very practical features such as Manual Break, Headers, Footers and the Indexes. The first one is often used when you prepare documents in which you want the sections to start at the top of a page, not halfway through. Note that Ctrl-Enter gives you the same result. The Headers & Footers option avoids repeating the same document title at the beginning or end of a page, which is, you will admit, tedious to say the least. When you are responsible for medium-to-large documents, you might want to index them and create a table of contents, which you can create through the index sub-menu.

Note

To insert tables, files or images, this is the menu. Alt-I and the t character pops up a dialog window in which you can choose the number of table rows and columns you wish to insert.

Figure 10-7. Create Tables For Your Documents

Format Menu

This menu contains essential formatting features, such as Character, Paragraph and Page. The first one applies font, style and size parameters, amongst others, to your document. Click on the different tabs and you will find font effects, hyperlinks and background features. The Page sub-menu allows general and more advanced page formatting. In the Paragraph sub-menu, you determine background colors, indent and spacing, tabs, etc.

Tools Menu

A writer's best friends reside in this menu: Spellcheck, Thesaurus and Options. When you select the Spellcheck option (or F7), you launch a corrector which indicates what words are badly spelled. Note that the language must properly be set before trying to correct a document (i.e.: you want to correct an English document but the French dictionary is active: mission impossible). If you wish to change the language for a specific document, access the Tools->Option and then change the Language parameter to the desired language. As for the Thesaurus option, it also pops a window from which you can select same-family words and synonyms.

Figure 10-8. Spellchecking Documents

The Options menu, however, is the most important personalization tool. There, you can set the correct paths for opening directories directly instead of having to browse your entire tree to find a file.

Figure 10-9. StarOffice Options

Windows Menu

This menu gives you access to all the documents you opened.

Figure 10-10. Accessing Your Documents

Help Menu

Finally, this is the one to go to if you need specific help on anything concerning StarOffice. Say you have a question about hyperlinks. Just select that topic in the index. If you are not accustomed to software such as the one we are describing, maybe you should enable the Tips and Extended Tips. Once you remember the operations you do everyday, however, you will soon want to disable them since they can get annoying...

10.1.2. Getting Help

We hope our introductory tour of StarOffice will help you use this great software. However, if you were to have any problems, here are a few sites which might help you out:

  • Sun web site: the StarOffice section describes all the features, includes a FAQ and a Support Forum;

  • OpenOffice web site: this site is dedicated to the free version of StarOffice. Although it is not directly related to StarOffice, you might find relevant information there.


Tux on Star from MandrakeSoft Linux is a registered trademark of Linus Torvalds. All other trademarks and copyrights are the property of their respective owners.
Unless otherwise stated, all the content of these pages and all images are Copyright MandrakeSoft S.A. and MandrakeSoft Inc. 2002.
http://www.mandrakelinux.com/