Calcs Data Pilot function

Filter

U V.

Salesperson

Data

Avi Abad;

Sum - Revenue

£2,553.03

Average - Units

48.36

Clare Dodds

Sum - Revenue

£4,027.72

Average - Units

54.94

Damjan Hughes

Sum - Revenue

£1,350.70

Average - Units

22.66

3

¡Darren Gratton

Sum - Revenue

£3,977.39

1

Average - Units

39.43

2

□ erek Smith

Sum - Revenue

£3,832.41

3

Average - Units

49.95

4

Jo Penny

Sum - Revenue

£3,153.61

5

Average - Units

55.72

5

Kim Holthan

Sum - Revenue

£1,994.56

7

Average - Units

33.56

3

Matt Bailey

Sum - Revenue

£1,901.61

9

Average - Units

36.47

3

Nick Harvey

Sum - Revenue

£2,609.61

1

Average - Units

49.19

2

Rachael Unsworth

Sum - Revenue

£3,170.63

3

Average - Units

40.99

4

Rob Last

Sum - Revenue

£2,194.16

5

Average - Units

30

5

Rob Wrttmaack

Sum - Revenue

£4,633.20

7

Average - Units

52.2

3

Scott Douglass

Sum - Revenue

£3,040.17

9

Average - Units

50.9

3

Steve Griag

Sum - Revenue

£2,410.06

1

Average - Units

46.67

2

Steve Hawkins

Sum - Revenue

£1,001.50

3

Average - Units

50.21

4

Tim Weeks

Sum - Revenue

£3,255.96

5

Average - Units

55.56

5

Tom Denning

Sum - Revenue

£4,933.40

7

Average - Units

48.30

3

Total Sum - Revenue

£51,635.15

9

Tota! Average - Units

46.02

0

1

Working with GNOME Office

The other office suite available for GNOME is GNOME Office, which is a collection of individual applications. Unlike OpenOffice.org, GNOME Office does not have a coherent suite of applications, meaning that you have to get used to using a word processor that offers no integration with a spreadsheet, and which cannot work directly with a presentation package. However, if you only need one or two components, it is worthwhile investigating GNOME Office.

The GTK Widget Set

Open-source developers are always trying to make it easier for people to build applications and help in development. To this end, there are a number of widgets or toolkits that other developers can use to rapidly create and deploy GUI applications. These widgets control things such as drop-down lists, Save As dialogs, window buttons, and general look and feel. Unfortunately, whereas Windows and Apple developers have to worry about only one set of widgets each, Linux has a plethora of different widgets, including GTK+, QT, and Motif. What is worse is that these widgets are incompatible with one another, making it difficult to easily move a finished application from one widget set to another.

GTK is an acronym for GIMP Tool Kit. The GIMP (The GNU Image Manipulation Program) is a graphics application similar to Adobe Photoshop. By using the GTK-based jargon, we save ourselves several hundred words of typing and help move along our discussion of GNOME Office. You might also see similar references to QT and Motif, as well as other widget sets, in these chapters.

Here are some of the primary components of the GNOME Office suite available in Ubuntu:

• AbiWord This word processing program enables you to compose, format, and organize text documents and has some compatibility with the Microsoft Word file format. It uses plug-ins (programs that add functionality such as language translation) to enhance its functionality.

• Gnumeric This spreadsheet program enables you to manipulate numbers in a spreadsheet format. Support for all but the most esoteric Microsoft Excel functions means that users should have little trouble trading spreadsheets with Excel users.

• The GIMP This graphics application enables you to create images for general use. It can import and export all common graphic file formats. The GIMP is analogous to Adobe Photoshop application and is described in Chapter 10, "Multimedia Applications."

• Evolution Evolution is a mail client with an interface similar to Microsoft Outlook, providing email, scheduling, and calendaring. It is described in Chapter 8, "On the Internet: Surfing the Web, Writing Email, and Reading the News."

• Dia Dia is the open-source version of Visio, allowing you to create complex diagrams depending on your specific requirements. It supports a range of diagram standards, including the increasingly popular UML diagrams.

• Planner This is a surprisingly powerful project management tool, allowing you create and manage projects through a simple interface.

• Balsa This lightweight mail client is in the mold of Microsoft Outlook Express. It is described in Chapter 8.

The loose association of applications known as GNOME Office includes several additional applications that duplicate the functionality of applications already provided by Ubuntu. Those extra GNOME applications are not included in a default installation of Ubuntu to eliminate redundancy. They are all available through synaptic repositories, making installation easy. Both The GIMP and Evolution are available with Ubuntu by default.

AbiWord (shown in Figure 9.14) can import XML, Microsoft Word, RTF, UTF8, plain text, WordPerfect, KWord, and a few other formats. AbiWord is notable for its use of plug-ins, or integrated helper applications, that extend its capabilities. These plug-ins add language translation, HTML editing, a thesaurus, a Linux command shell, and an online dictionary, among other functions and features. If you just need a lightweight but powerful word processing application, you should examine AbiWord.

Was this article helpful?

0 0

Post a comment