Although word processing may be one of the most needed tools in an enterprise environment, spreadsheets and databases may have equal or even greater importance in some workplaces. With Linux, users can create high quality spreadsheets and databases files with programs such as Corel Quattro, StarOffice Base, KSpread, or one of many other available programs. These programs are highly useable and capable of creating a spreadsheet or database in any office environment. With these applications, Linux is able to provide the required compatibility with programs that are used in other operating systems. Programs such as Corel Quattro, StarOffice Base, and KSpread can easily create a spreadsheet or database that is compatible in format with other commercial applications. Such compatibility is vital because interoperations with other versions of databases and spreadsheets make Linux a viable selection in the enterprise environment.
Getting back to our example, it looks a little basic at the moment as there is no formatting involved. For instance, what's the billing currency You can also see that some of the cells have text that does not fit, which is highlighted by a small right arrow in the cell. We should also add some labels and titles to our spreadsheet to make it a bit more visually appealing. Now you need to space all the cells so that you can read all the information. A quick and easy way to do this is to click the area immediately to the left of column A and immediately above row 1 to select the entire spreadsheet. Now all you have to do is double-click the dividing lines and each column resizes according to its longest entry. FIGURE 6.9 Add a touch of color to an otherwise dull spreadsheet with the fill background icon. If you have followed the steps as described, you should end up with a spreadsheet similar to the one in Figure 6.10.
Calc is the spreadsheet program in the OpenOffice.org application suite. To start Calc, select Main Menu O Office O OpenOffice.org Calc from the GNOME or KDE panel. The Calc program displays its main window, which looks similar to Windows-based spreadsheets, such as Microsoft Excel. (In fact, Calc can read and write Microsoft Excel format spreadsheet files.) Use Calc in the same way you use Microsoft Excel. You can type entries in cells, use formulas, and format the cells (such as specifying the type of value and the number of digits after the decimal point). Figure 10-6 shows a typical spreadsheet in Calc. When preparing the spreadsheet, use formulas you normally use in Microsoft Excel. For example, use the formula SUM(D2 D6) to add up the entries from cell D2 to D6. To set cell D2 as the product of the entries A2 and C2, type A2*C2 in cell D2. To learn more about the functions available in OpenOffice.org Calc, select Help O OpenOffice.org Help from the menu (or press F1). This opens...
When you launch OpenOffice Calc, you are dropped into a new spreadsheet automatically, and you can begin entering data. Or you can open an existing spreadsheet (New Open) to begin working. A spreadsheet contains cells organized in rows and columns. To begin entering data into your spreadsheet, simply click in a cell. A black outline appears around the selected cell. Enter data, either text or numbers. When you are finished, simply click in another cell or press ENTER on the keyboard. You can also use the arrow keys or the TAB key to move to the next cell. This process is much like entering data into a word processor except that, in this case, each piece of data is entered into one cell at a time. Figure 5.15 Entering Data into Your Spreadsheet Since your spreadsheet is likely structured with formulas, deleting or moving data can be a bit more complex than it is in a word processor.
When it comes time to keep your records, analyze last year's earnings, or just tabulate numbers, Spreadsheets is where you want to do it. As you can see from Figure 8-8, it comes with the regular row-column grid of cells and the multiple worksheets. Like any spreadsheet, you can create formulas that reference the cells containing the data used in the formula. Figure 8-8 This spreadsheet shows how a chart displays the data in the cells. Figure 8-8 This spreadsheet shows how a chart displays the data in the cells.
Formatting a spreadsheet is much like formatting a document. The same capabilities are available, such as features to alter fonts and font size, and add color to some or all of the background. Refer to Formatting Your Document earlier in this chapter for details. When formatting a spreadsheet, you can easily format a single cell or an entire group of cells. For instance, you may want to add a background color to all cells in column D. To do so, highlight a group of cells by clicking the uppermost cell of the desired area and holding down the mouse button. Then drag the mouse pointer to the bottom cell and release. Now click the Background Color icon, select your color of choice and voila It's easy to convert data from a spreadsheet into a chart. To begin, open an existing spreadsheet. Highlight the group of rows, columns, and headings from which you want to build the chart. Select Object from the Insert menu, and then OLE Object from the resulting submenu. The Insert OLE Object dialog...
Sometimes you may want to have multiple separate pages in one spreadsheet. For example, say you create a detailed report every month. You want to have every month on its own page, but you'd like to keep all the pages together. Notice the tabs at the bottom of the screen that say Sheet 1, Sheet 2, and so on. You can use your mouse to flip between the pages and rename them by rightclicking a tab and choosing Rename. You can also change the order in which the sheets appear by placing the mouse pointer on the tab, and then dragging and dropping the sheet to the new location.
Before printing your spreadsheet, you should take the time to think about how you want your spreadsheet to look. Do you want the grid boxes to appear Do you want all of the spreadsheet or only certain data within it to appear To print the entire spreadsheet, select Print from the File menu. To print just a portion of your spreadsheet, highlight that portion, and then select Print Ranges from the Format menu. From there, select Define. Now continue on with the standard printing procedure. It is common to turn off grid boxes on a spreadsheet before printing it. Other formatting features include scaling the spreadsheet to fit on one page, printing only a chart, and printing only the data. To access any of these formatting tools and others, select Page from the Format menu. Often spreadsheets look better, and are more efficient and effective, if they are printed across the page sideways to show more columns on a single printed page. By default, all documents print in the normal 81 2 -...
As with most of the packages that form the OpenOffice.org suite, Calc (Applications Office OpenOffice.org Spreadsheet) does a good impersonation of its proprietary counterpart, Microsoft Excel, both in terms of powerful features and the look and feel, as you can see in Figure 11-2. However, it has only limited support for Excel's Visual Basic for Applications (VBA) macros at present. Instead, Calc and other OpenOffice.org programs use their own macro language, called OpenOffice.org Basic (for more information, see http development.openoffice.org).
To open an existing spreadsheet in KSpread, select Open from the File menu, or simply click the open icon to make the Open dialog box appear. Moving around the Open document dialog box is quite intuitive. The up arrow will take you back one directory level, the house icon will take you to your home directory, and so on. When you have chosen the spreadsheet you want to load, click its name and select OK.
This section provides background information on what a spreadsheet is, how it works, and how to use one. If you're already familiar with spreadsheets, you can skip this section. However, if you're not, this section is for you. In paper terms, a spreadsheet is a sheet of paper divided into rows and columns that break down financial transactions into separate entities that a business person can examine and analyze. The first computerized spreadsheet was created for a mainframe computer system in the early 1960s by a professor named Richard Mattessich, then at the University of California at Berkeley. As a mainframe application, this had a somewhat limited audience for you and me, spreadsheets were one of the original killer applications for personal computers, going all the way back to VisiCalc on misty dawn-of-time systems such as the Apple II. Then, like now, the power of the personal computer gave people the ability to enter and manipulate financial data on their own systems....
As mentioned in the introduction to this chapter, spreadsheets are often as important to home computer users as they are to business users. This is especially true once a year for those of us in the United States, when tax time for anyone who itemizes deductions means trotting out all of your receipts for the past year, entering them into a spreadsheet, and totaling up anything that is legally deductible. likely, recognize Linux as a growing market opportunity), spreadsheets will have to do for tracking my personal business expenses. Fortunately, Linux provides some excellent spreadsheet packages. The spreadsheet component of the OpenOffice.org package is called OpenOffice.org Calc, although you start it by selecting the OpenOffice.org Spreadsheet menu item. The OpenOffice.org Office suite is a set of applications that were designed together, share extensive amounts of code, have a similar look and feel, and invoke each other to satisfy certain requirements. For example, as I discuss...
Spreadsheets aren't just for accountants. I have a friend who uses spreadsheets to track his fantasy football team's statistics, and a chef I know stores all her recipes in a spreadsheet, including extremely specific quantities for spices and cook times for individual herbs. Who knew cooking could be so scientific These days, spreadsheet applications are as common as e-mail and word processing. The structure they provide for storing information and performing calculations goes hand in hand with the increased readability of a well-designed spreadsheet. The big name in spreadsheets these days is Microsoft Excel. The Excel application can be purchased individually for about 300, or you can get it as a bundle with the Microsoft Office suite of applications, starting at about 400. But as I mentioned in Chapter 5, Microsoft likes to update its Office products every three to four years keeping up with the latest versions can get expensive fast.
Similar to any other spreadsheet application, Calc is used to process numerical information or text in tabular form. It is primarily used for tabulating numerical figures. It also allows you to sort and manipulate data, apply arithmetic, mathematic and statistical functions to data sets and represent the datasets in charts or graphical forms. The following sections describe the instructions to perform some basic spreadsheet tasks in Calc. To format tables and cells in a Calc spreadsheet 1. On the Applications menu, point to Office and then click OpenOffice.org Spreadsheet to open a Calc spreadsheet. A new Calc window opens. The sheet tabs at the bottom of the sheet indicate the number of worksheets present in the current spreadsheet. By default, a new spreadsheet includes three worksheets. 3. After you have entered the required data in the spreadsheet, you can apply different formatting styles to it by selecting from the wide range of options available in Calc. To apply desired...
Linux folks like me tend to be Linux-centric, but that doesn't mean that we can completely ignore reality. When you're working with existing spreadsheets (and any other office-related documents, to be honest), the chances are pretty good that you created them using more common software packages, such as Microsoft Excel, that run on other operating systems, such as Mac OS X and Microsoft Windows. The folks who wrote and support KSpread couldn't ignore this reality either, so KSpread provides built-in support for opening Microsoft Excel spreadsheets and workbooks.
Preparing documents in OpenOffice.org Writer Working with spreadsheets in OpenOffice.org Calc reparing documents and spreadsheets are the staples of the modern office. SUSE Linux comes with the OpenOffice.org (often shortened as OO.o or Ooo) suite of office applications that includes very capable word processing and spreadsheet software to help you with these tasks. Both KDE and GNOME desktops use OpenOffice.org as the primary office application suite. In this chapter, I describe two OpenOffice.org applications Writer for preparing documents and Calc for working with spreadsheets in considerable detail. Writer is similar to Microsoft Word, and Calc is like Microsoft Excel.
Printing, saving, and loading spreadsheets in OpenOffice Calc is nearly identical to printing, saving, and loading word processing documents in OpenOffice Writer. To save a spreadsheet, follow these steps To print a spreadsheet, click on File, Print and click the OK button in the Print dialog. To print only a range of cells that you select, follow these steps
Some people like to balance their checkbooks by hand. When I first graduated from a university, I decided that it was time to get hold of my finances, and a spreadsheet was the way to do it. These days, I use spreadsheets to keep track of my time card when I'm doing consulting or contract work, help me manage project teams, and complete other tasks. I'm sure that you have your favorite uses for spreadsheets. The following sections take a look at OpenOffice.org Calc so that you can get to work.
Linux folks like me tend to be Linux-centric, but that doesn't mean that we can completely ignore reality. When you're working with existing spreadsheets (and any other office-related documents, to be honest), the chances are pretty good that you created them using more common software packages, such as Microsoft Excel, that run on other operating systems, such as Mac OS X and Microsoft Windows. The folks who wrote and support the OpenOffice.org suite and OpenOffice.org Calc couldn't ignore this reality either, so Calc provides built-in support for opening Microsoft Excel spreadsheets and workbooks. S'iV- Tf J'ft 'f y u have a existing spreadsheets and are wondering how to transfer them to your For example, to open an existing Excel spreadsheet, simply select the File C Open command. By default, the file selection dialog that opens enables you to select files with any extension, including the .xls extension used by Microsoft Excel spreadsheets. The same mechanism described in the...
Gnumeric, a component of the GNOME Office suite, was one of the first spreadsheets available for Linux and, like a fine wine, has only continued to improve with age. The GNOME Office suite is a collection of office applications that depend on the GIMP Toolkit (GTK) graphics library for many of their graphical controls. These have been semantically collected into the GNOME Office suite through their allegiance to GTK and the need for the GNOME folks to have an office suite just like the KDE folks, not necessarily because of any internal similarities or common functionality beyond GTK itself. Although OpenOffice.org Calc is installed by default on Ubuntu desktop systems, you may find that you prefer using a lighter-weight spreadsheet such as Gnumeric, and this may be especially true on systems with limited disk space or a limited amount of memory. Linux is all about choice and Gnumeric is a fine choice for a powerful and highly usable spreadsheet if there's something that you don't like...
Linux folks like me tend to be Linux-centric, but that doesn't mean that we can completely ignore reality. When you're working with existing spreadsheets (and any other office-related documents, to be honest), the chances are pretty good that you created them using more common software packages, such as Microsoft Excel, that run on other operating systems, such as Mac OS X and Microsoft Windows. The folks who wrote and support Gnumeric couldn't ignore this reality either, so Gnumeric provides built-in support for opening Microsoft Excel spreadsheets and workbooks. Y --r- If you have a lot of existing spreadsheets and are wondering how to transfer them to your For example, to open an existing Excel spreadsheet, simply select the File C Open command. By default, the file selection dialog that opens enables you to select files with any extension, including the .xls extension used by Microsoft Excel spreadsheets. The same mechanism is used to open files in any other format supported by...
OpenOffice's OpenCalc (or Calc) application again provides numerous features that you would expect of a commercial application and is comparable with Microsoft Excel, the spreadsheet application within Microsoft Office. Some of the key features present are Ability to handle multiple spreadsheets simultaneously OpenCalc also supports compatibility with Excel, in its ability to load and save spreadsheets and templates in a number of Excel file formats, including Microsoft Excel 97 2000 XP and Microsoft Excel 4.x-5.0. Other interoperability features include the handling of VBA code and embedded objects (as we mentioned earlier in this chapter). Tools Options dialog box, in the Spreadsheet Calculate tab
KSpread (www.koffice.org kspread ) is the spreadsheet component of the KDE KOffice office suite (www.koffice.org). KSpread is installed by default on Kubuntu systems running KDE 3.5.x, but is not installed by default on Kubuntu systems running KDE 4.x (at least not at the time of this writing). KSpread provides a lighter-weight alternative to OpenOffice.org Calc as well as tight integration with the other components of the KOffice suite. This integration makes it easy to embed KSpread spreadsheets or charts in KWord documents, KPresenter presentations, and so on. KSpread has been actively under development since the late 1990s, and is a nice, full-featured spreadsheet package.
In the accounting world, spreadsheets are king. These days, however, many home users have discovered the benefits of using spreadsheet software. From balancing checkbooks to keeping track of budgets, having all the numbers at your fingertips can come in handy. The Microsoft Excel spreadsheet is the most popular package used in the Windows world. In the OpenOffice.org suite, the spreadsheet package is called Calc.
If you work in an office and use spreadsheets, the odds are that you need to share those spreadsheets with Microsoft Excel users. It's also quite probable that you have used Excel and that it is the spreadsheet application with which you are most comfortable. For example, most spreadsheet users are familiar with the procedure to add a column of numbers click the mouse in any of the fields, and enter a number in the formula field at the top of the window. Press Return to move down to the next one, and enter a new number. Once you have a few, go to an empty cell and press the Sum button, labeled with the Greek letter sigma, to calculate the sum. Then, enter the range of cells you want to add, or just select them with the mouse.
I currently use the good spreadsheet called calc. which is part of OpenOffice.org. It can be run by clicking an appropriate menu item from your favourite desktop ( K Office OpenOffice.org Calc ) or typing in an X terminal I am a very heavy spreadsheet user. so here are some other promising programs I keep my eyes on. In my opinion. Linux does not have an excellent spreadsheet program yet. but oocalc can do a lot. and then use it from my spreadsheet using something like my_function(2 3) The user interface is sometimes awkward. For example. adding a new data series to a chart requires highlighting a spreadsheet range. and then dragging and dropping it onto the chart with a mouse. Still. the chart component supports (for XY graphs) two Y axes. two X axes. good selection of line types. bitmaps for data points. error bars. regression fits. etc. Really powerful if you learn how to use it--to my taste too much of careful mouse clicking is required. I would really enjoy a giant dialog box...
Part VI moves on to explain how typical office tasks can be accomplished under SUSE Linux. We investigate OpenOffice.org, the complete office suite built into SUSE Linux. After an introduction to OpenOffice.org, separate chapters explore its word processor, spreadsheet, database, and presentation package. You'll also learn how to use the Evolution e-mail and personal information manager program, and how to run Microsoft Office under SUSE Linux.
An operating system is made up of software instructions that lie between the computer hardware (disks, memory, ports, and so on) and the application programs (word processors, Web browsers, spreadsheets, and so on). At the center is the kernel, which provides the most basic computing functions (managing system memory, sharing the processor, opening and closmg devices, and so on). Besdes the kernel, an operating system provides other basic services needed to operate the computer, including
The Linux kernel itself is licensed under the GPL. However, all Linux systems include a large number of packages, and not all of these are licensed under the same license. The packages included in SUSE Linux Professional and SUSE Linux Enterprise Server are almost all licensed under one of the licenses mentioned previously. However, SUSE Linux Professional includes a small number of packages that are commercial demo versions, or that SUSE has been given permission to distribute in binary form, although they are not free software. Examples from SUSE Professional 9.1 include the TextMaker word processor and the PlanMaker spreadsheet from SoftMaker.
StarOffice is a complete office productivity suite for Linux, released by Sun Microsystems (originally developed by a smaller company called Star Division, which was bought by Sun). This suite, which is also available for Windows and Solaris, is more or less a clone of Microsoft Office, including a word processor, spreadsheet, HTML editor, presentation manager, and other tools. It is capable of reading file formats from a wide range of similar applications (including Microsoft Office) and is available for free download for noncommercial use. Corel has released WordPerfect Office 2000 for Linux, another office suite which includes a word processor, spreadsheet, presentation software, personal information manager, and other applications. It is free for personal use and commercial licenses are also available. Corel has also released the CorelDRAW professional graphics suite for Linux.
Table 2.1 shows a general guideline for determining the amount of RAM your system should have. Begin by using the first column to determine which conditions are likely to exist on your system (such as running X, running larger applications, or adding users), and then move across to the minimum, recommended, and best performance columns. Consider any program that uses a lot of RAM such as a word processor (not a line editor like vi), a database, a spreadsheet program, or a desktop publishing system to be a large application. Large applications also include video players, some sound editors, and similar multimedia applications. The Development System entry is if you plan to do a lot of programming, including X application development.
A file is nothing more than a collection of information that programs and your operating system can locate and deal with as a single unit. Files are containers for some sort of data, whether they contain a letter to your mother or parole board, a copy of one of your favorite songs (legitimate, of course), a digital photograph, or the data used by a spreadsheet to calculate the health of your
You don't have to spend additional money to buy typical productivity applications such as word processing or spreadsheet programs. All versions of Enterprise Linux ship with a complete office productivity suite OpenOffice. org as well as many other graphical applications that can be used for editing graphics, building Web sites, and much more.
I need three things from you by lunchtime. First, I need some way to be able to share documents and project spreadsheets with Joe Underling down the hall. Second, my PC crashes all the time. This tape thingy-ma-watchit takes too long to reload all my important documents. I need a better way to protect my files. And finally, I need to be able to print to my secretary's printer located outside my office.
OpenOffice.org is a powerful open source office suite, available as a download and as part of many Linux distributions. Based on Sun Microsystem's StarOffice productivity suite, OpenOffice.org includes a word processor, spreadsheet program, presentation manager, and other personal productivity tools. In most cases, OpenOffice.org can be used as a drop-in replacement for Microsoft Office.
Some have called OpenOffice.org the most significant threat to Microsoft's dominance of the desktop market. Thousands in business, education, and government have already migrated their documents, spreadsheets, and presentations from Microsoft Office to OpenOffice.org. While cost savings are a big reason for using OpenOffice.org, the freedom of not being locked into proprietary formats and forced upgrades may be even more important in the long run. Calc A spreadsheet application that lets you incorporate data from Microsoft Excel, StarOffice, Dbase, and several other spreadsheet formats. Some nice features in Calc enable you to create charts, set up database ranges (to easily sort data in an area of a spreadsheet), and use the data pilot tool to arrange data in different points of view.
When you right-click an object or group of objects either on the desktop or in a File Browser window, GNOME displays an Object Context menu. Different types of objects display different context menus, but most context menus share common selections. Figure 4-18 shows context menus for a OpenOffice.org spreadsheet file and for a plain text file. Table 4-1 lists some common Object Context menu selections.
Now that I've shown you how Linux can support servers with DNS, e-mail, file, firewall, FTP, proxy, Web, and many other server services and clients with word processors, e-mail programs, spreadsheets, database, graphic views and manipulators, Web browsers, file transfer, printing support, presentation, and virtually every other type of program, it's time to determine the roles and services that a system may require. You can use Linux for all the roles that I have discussed, and in fact, Linux is often used for all of these and many more.
I Office This menu choice gives you access to the OpenOffice.org office suite. The OpenOffice suite contains word processing, spreadsheet, presentation software, and much more. You can also start several of the OpenOffice applications by clicking the icons on the left side of the panel.
WordPerfect is a popular word processor that is available for both Microsoft and Linux operating systems. Microsoft Word has not been ported to Linux Opera is a Web browser and Domino is an e-mail server. See the sections Word Processing and Spreadsheets and Databases for more information.
Think of a typical office computer and you're likely to imagine a system that runs certain types of programs, such as word processors and spreadsheets. A prototypical desktop office system has a monitor, a keyboard, and a mouse for human interaction, and it is connected to a printer for output. One component is missing from this stereotypical office desktop computer, though a scanner. Not every computer has or needs a scanner however, for many applications, scanners are indispensable. With a scanner, you can load printed photographs into files you can manipulate with graphics programs, convert textual documents into word processing files, and even (with the help of a printer and a modem) turn a computer into a photocopier and fax machine.
OpenOffice.org contains a number of productivity applications for use in creating text documents, preparing spreadsheets, organizing presentations, managing projects, and more. The following components of the OpenOffice.org package are included with Ubuntu . Calc This spreadsheet program enables you to manipulate numbers in a spreadsheet format. Support for all but the most esoteric Microsoft Excel functions means that trading spreadsheets with Excel users should be successful. Calc offers some limited compatibility with Excel macros, but those macros generally have to be rewritten. We walk through setting up a basic spreadsheet with some formulas as well as showing you how to build a basic Data Pilot later on in this chapter.
By office applications, I mean software for word processing, spreadsheets, presentations (briefing slides), calendars, and managing contacts. You can, of course, think of the Internet applications at least e-mail and Web browser as office applications as well, but I am differentiating between the applications that need the Internet to work versus the ones you may use on stand-alone PCs different applications for different tasks such as word processing, working with spreadsheets, and preparing presentations. Table 4-2 summarizes the office applications available in GNOME and KDE desktops. Spreadsheet t Spreadsheet applications are for creating what else spreadsheets. The OpenOffice.org office suite includes the Calc application for preparing spreadsheets. Calc is compatible with Microsoft Excel.
You can either click the shortcut icon that is located on the top GNOME panel, or select Spreadsheet from the Office menu under the Applications main menu. Whichever route you take, the result is the same and Calc starts to load. By default, Calc loads with a blank spreadsheet just waiting for you to enter information into it. In Figure 6.7, you can see that we have already started to enter some basic information into Calc.
For our purposes, business applications are programs running on an individual PC that perform business functions. The top-selling software titles are loaded with various business applications. For instance, the top-selling Microsoft Office is a bundle of common business applications, including a word processor (Word), spreadsheet (Excel), and presentation software (PowerPoint).
Calc includes a powerful tool that lets you summarize large groups of data to help you when you need to carry out any analysis. This tool is called a data pilot, and you can use it to quickly summarize data that might normally take a long time if you did the calculations manually. Using the sample spreadsheet from earlier, we will take you through how to build a simple data pilot, showing you how to analyze and manipulate long lists of data. The previous section featured a spreadsheet that showed sales people, customers, date of invoice, and revenue. At the foot of the spreadsheet were a couple of formulas that enabled you to quickly see the total revenue earned and the average order value.
Workstation configurations are generally the best choice for end users who do not need all the server applications installed. The Workstation installation includes the standard software packages that are needed to perform daily tasks. This includes software to perform Web browsing, to create documents and spreadsheets, and to retrieve e-mail. Some Workstation class packages allow the installation of commercial software to be included with the installation of Linux. Selecting a Workstation installation does not, however, limit the system to this role, but it does use a configuration that is meant for workstations.
Sun's Star Office has very good support for Microsoft Office files. It offers equivalent programs for word processing (Writer), spreadsheets (Calc), presentations (Impress), graphics (Draw), email (Mail), calendaring (Schedule), and a database (Base). It also has an integrated Web browser. While it is not as feature-rich as Microsoft Office, it offers all its major functions such as fonts, headers, footers, and template style sheets. Star Office isn't for everyone, though. Probably the biggest drawbacks are its size and speed. Star Office requires 160MB of disk space and at least 32MB of RAM, although 64MB is required to get decent performance. It also takes a long time to load, even on a fast system. Low-end machines that are often used for Linux boxes are definitely out of the question.
However, you are strongly advised to round up a selection of documents and spreadsheets that could potentially fall foul of the import export filter and test them thoroughly (of course, keeping a backup of the originals ). There is nothing worse than for a system administrator who has deployed a new productivity suite than to suddenly get users complaining that they cannot read their files. This would quickly destroy any benefits felt from the other useful functions within OpenOffice.org, and could even spell the return of proprietary formats and expensive office suites. Many users do not mind switching to OpenOffice.org, largely because the user interface closely resembles that of similar Microsoft applications. This helps to settle users into their environment and should dispel any fears they have over switching. Such similarity makes the transition to OpenOffice.org a lot easier.
The spreadsheet component of OpenOffice.org is named Calc, and is a very capable Excel alternative. You can either click the shortcut icon that is located on the top GNOME panel, or select Spreadsheet from the Office menu under the Applications main menu. Whichever route you take, the result is the same and Calc starts to load. By default, Calc loads with a blank spreadsheet just waiting for you to enter information into it. In Figure 6.7, you can see that we have already started to enter some basic information into Calc.
Included with Ubuntu is a full office suite called OpenOffice.org. This comprehensive collection of applications includes a word processor, spreadsheet, presentations, database, drawing editor, and math editor. The suite provides an extensive range of functionality, reads and writes Microsoft Office file formats, and can also export documents as Web pages, PDF files, and Macromedia Flash animations.
Enterprise Linux includes the complete office application suite OpenOffice.org. OpenOffice.org includes a word processing application, a presentation application, a spreadsheet application, a drawing application, a math equation editor, and an HTML page creation tool. In most cases, OpenOffice.org is compatible with documents created with other office suite applications such as MS Office. I have successfully created documents with OpenOffice.org and then exchanged those documents MS Office users and vice versa. The great thing about OpenOffice.org is its price namely, free. And when you consider that it works with documents, presentations, and spreadsheets created with MS Office, it is an incredible value. In this section, I explain the basic steps for using OpenOffice.org Writer for creating documents, OpenOffice.org Impress for creating presentations, and OpenOffice.org Calc for creating spreadsheets.
You can configure your desktop to restore your previously opened windows and applications as well as specify startup programs. When you log out, you may want the windows you have open and the applications you have running to be automatically started when you log back in. In effect, you are saving your current session so that it can be restored when you log in again. For example, if you are working on a spreadsheet, you can save your work, but not close the file, and then log out. When you log back in, your spreadsheet will open automatically where you left off.
Because Online Desktop is still under development, expect to have many more features and services available by the time you read this text. In particular, work is being done to integrate online applications, so you will be able to work with Web applications to use your documents, spreadsheets, and other important information.
Another member of the OpenOffice.org office suite is the Calc program. Calc is a full-featured spreadsheet program similar to MS Excel. In fact, anything that you can do with Excel, you can most likely do with Calc. To start the program, click the OpenOffice.org Calc icon from the desktop panel (it looks like a pie chart on top of a spreadsheet) or choose ApplicationsOOfficeO OpenOffice.org Calc. You are presented with a blank document, as shown in Figure 3-11. OpenOffice.org Calc is a typical spreadsheet application. If you've used a spreadsheet program, you can soon master Calc. Many of the commands and formulas that you might have used in MS Excel also work in Calc. You can also save your spreadsheets in MS Excel format (.xls) so that you can share your files with Windows users or use them yourself on Windows PCs. term LinG - Live, informative, Non-cost and Genuine Opening and saving spreadsheets in Calc works exactly the same as opening and saving documents using OpenOffice.org...
Note KDE applications are developed using several supporting KDE technologies. These include KIO, which offers seamless and modular access of files and directories across a network. For interprocess communication, KDE uses the Desktop Communications Protocol (DCOP). KParts is the KDE component object model used to embed an application within another, such as a spreadsheet within a word processor. The XML GUI uses XML to generate and place GUI objects such as menus and toolbars. KHTML is an HTML 4.0 rendering and drawing engine. Numerous applications written specifically for KDE are easily accessible from the desktop. These include editors, photo and paint image applications, spreadsheets, and office applications. Such applications usually have the letter K as part of their name-for example, KWord or KMail. A variety of tools are provided with the KDE desktop. These include calculators, console windows, notepads, and even software package managers. On a system administration level, KDE...
Although you can get word processing programs, spreadsheet programs, graphics programs, and almost any other type of application that you want for Linux, many of the most popular applications in each category don't run well in Linux or don't run at all. For example, the latest Microsoft Office product will not run in Linux. If your company uses Microsoft Word for word processing or Microsoft Excel for spreadsheets, you could try converting files from those applications to run in StarOffice in Red Hat Linux. However, those files won't always convert cleanly.
Fedora Core comes with a whole lot of applications. All you have to do is look at the menus in GNOME or KDE and you'll see what I mean. Often, there is more than one application of each type. Both GNOME and KDE come with the OpenOffice.org office application suite with a word processor, spreadsheet, presentation software, and more. You find many choices for CD players and multimedia players, not to mention the games, utility programs, and useful tools, such as a scanner and digital camera applications.
Word processor, spreadsheet, presentation software, calendar, calculator these are some of the staples of the office. Both GNOME and KDE come with the OpenOffice.org (often shortened as OO.o or Ooo) suite of office applications and tools. You can try out all of them one by one and see which OpenOffice.org Calc A Microsoft Excel-like spreadsheet program
Between OpenOffice.org Writer and other spreadsheet programs you might have used, much of what you see in OpenOffice.org Calc should look familiar. Take a look at the layout shown in Figure 7-2. If you've used spreadsheet programs before, Calc should be familiar to you. Calc uses the common spreadsheet grid layout, with increasing numbers identifying the rows and increasing letters identifying the columns. The following sections describe the individual elements of Calc.
GNOME Office A sub-project of GNOME is GNOME Office, which is an effort to create a coherent whole out of a disparate group of office tools. A few of the programs just described are technically part of GNOME Office, but GNOME Office is most focused on office productivity tools such as word processors and spreadsheets. It's described in more detail in Chapter 8.
You can start OpenOffice.org in any of several ways. OOo is integrated into both the KDE and GNOME menus, under Office. In KDE, each application is listed under the appropriate type (word processor, spreadsheet, and so on). At the bottom is the Office Suite icon with the OOo logo. This opens the Documents and Templates window. With either method, you are presented with the OOo menu. Depending on your OOo version, you may be presented with either the list of programs or the type of document you want to open or create Text Document, HTML Document, Spreadsheet, Drawing, Presentation. Choosing From Template brings up a list of existing
After you have played around with Ubuntu for a while, you may have made some changes to the desktop environment. Maybe you added some icons or changed the background. Quite possibly, you used Open Office and created a document or spreadsheet. Unfortunately, you cannot save your changes or your work to your computer's hard drive in the live environment. The purpose of the Live CD is to allow you to get a feel for GNU Linux and see if it is compatible with your computer before installing the software. If you sat down to a live session and completed the Great American Novel on Writer, or knocked out your company's quarterly projections on Calc, not to fear. You can still save this work on a USB drive or some other removable media. The desktop changes, however, will not stay once you shut down your live session.
Most office productivity suites are broken into multiple components, each of which handles one task. Typical components are a word processor, a spreadsheet, a presentation program, and a graphics editor. Most suites include additional components, but the details of what's included vary from one suite to another. LaTeX is an exception to this rule it's a document preparation system that's very different from a typical office suite. I describe LaTeX in this chapter because it's an extremely flexible tool, and because it's very useful in preparing scientific and technical documents.
Softmaker Office 2004 is a new addition to SUSE Linux 9.2. This small commercial suite promises a small memory footprint, fast loading, and seamless conversion to and from Microsoft formats. As with GNOME Office, Softmaker is a very loosely connected collection of two applications word processor Textmaker 2002 and spreadsheet Planmaker2004.
Hancom Office is produced by a South Korean firm. Version 2.0 offers a word processor, a spreadsheet, a presentation tool, and a paint program. ThinkFree Office for Linux was released just days before the OpenSUSE project was announced in August 2005. Its chief claim to fame is even easier document sharing with Microsoft Office tools. ThinkFree saves files to the Microsoft format by default and also makes Acrobat PDF files for use in the Adobe Reader. ThinkFree Office contains a word processor (Write), a spreadsheet (Calc), and a presentation (Show) package. You can try it out free at the ThinkFree website http www.thinkfree.com. Applixware, by VistaSource, has been around for a while. The recently released v4.3.3 has a word processor, a spreadsheet, a presentation product, a graphics generation toolkit, a database management integration client, and an email client.
Figure 914 Abi Word is a word processing program for Ubuntu GNOME and X11 It handles some formats that Open Officeorg
You can use the Gnumeric spreadsheet application to perform financial calculations and to graph data, as shown in Figure 9.15. It can import comma- or tab-separated files, text, or files in the Gnumeric XML format, saving files only as XML or text. To launch Gnumeric from the menu, choose Office, More Office Applications, and then Gnumeric Spreadsheet. You can also launch the spreadsheet editor from the command line, as follows
If you are coming from another desktop publishing environment, you will find that Anyware Office enables you to open or import documents from many of the most popular formats. Import filters for graphics, document, and spreadsheet formats also exist. Here are the filters for these formats supported by Anyware Office. Spreadsheets import filters Anyware Spreadsheets enables you to import these spreadsheet formats Lotus (.wks, .wk1, .wk3, and .wk4) Microsoft Excel (versions 3.0, 4.0, 5.0, 7.0, and 97, .xls) Symbolic Link file (.slk) Data Interchange Format (.sdi, .dif, and .xdf) ASCII (any format) and Comma Separated Values (.csv).
The demo opens an Anyware Office icon bar. Move the mouse over the icon bar to see tool tips identifying each application. From left to right, the icon bar lets you open the following applications Words, Spreadsheets, Presents, Graphics, Data, Inbox, Sendmail, Data, and Directory Displayer. The last two buttons let you select Tools and Preferences. Figure 6-10 shows an example of the Anyware Office icon bar, Anyware Words, and Anyware Sendmail.
Several commercial office suites are available for Ubuntu in addition to StarOffice, already mentioned. None of these commercial suites are provided with Ubuntu. Of note is Hancom Office. Using the same QT widget set found in the KDE desktop, Hancom Office scores well on Microsoft file format compatibility. The suite includes a word processor, a spreadsheet presentation tool, and a graphics application. Corel produced a version of its WordPerfect Office 2000 for Linux before it discontinued the release of any new Linux products. It still offers a support page, but the software is no longer available, nor is the excellentbut whiskeredWordPerfect 8 for Linux.
A variety of office suites are now available for Linux (see Table 11-1). These include professional-level word processors, presentation managers, drawing tools, and spreadsheets. The freely available versions are described in this chapter. Sun has initiated development of an Open Source office suite using StarOffice code. The applications, known as OpenOffice, provide Office applications integrated with GNOME. OpenOffice is currently the primary office application supported by Fedora and Red Hat. KOffice is an entirely free office suite designed for use with KDE. The GNOME Office suite integrates GNOME applications into a productivity suite that is freely available. CodeWeavers CrossOver Office provides reliable support for running MS Office Windows applications directly on Linux, integrating with them with KDE and GNOME. You can also purchase commercial office suites such as StarOffice from Sun. For desktop publishing, especially PDF generation, you can use Scribus, a cross-platform...
The slider in the Priority field lets you determine how much of your CPU the screensaver will use. Linux, being a true multitasking operating system, continues to run other programs even when the screensaver takes over the entire screen. This means that if you're compiling a program, calculating a spreadsheet, or sorting a database, the operation continues while the screensaver does its tricks.
OpenOffice is a feature- rich office productivity suite distributed and maintained by Sun Microsystems. Comparable to Microsoft Office, OpenOffice includes a word processor, a spreadsheet application, presentation software, and graphic program applications. OpenOffice is incredibly powerful many believe that not only is it as good as MS Office, but also better in many ways. OpenOffice is available for other platforms as well, including Solaris and Microsoft Windows, and runs equally well on all of them.
As Linux finds its way into more homes, offices, and businesses, the need for productivity tools grows. With the market dominated by Microsoft's Office 95 98 2000 suite of word processor, spreadsheet, and presentation programs, a search ensued for equivalent tools on the Linux platform. Right now, two products stand out as having hope for a what you see is what you get (WYSIWYG) application for creating documents, spreadsheets, and presentations StarOffice and Applixware.
With all applications, several pre-configured wizards can help you quickly create documents, spreadsheets, and so on. The name Calc gives away the function of this feature of StarOffice the spreadsheet. It has many of the commonly used, favorite features people look for in a spreadsheet. Figure 8-3 shows the interface. In addition to creating its own files, Spreadsheet opens and works with most Excel spreadsheets. Figure 8-3 Spreadsheet showing a chart Figure 8-3 Spreadsheet showing a chart Along with the standard row-column layout of cells typifying a spreadsheet, you can also create multiple worksheets. Each worksheet contains its own data. If all you need is to tabulate data, format cells, or run straightforward mathematical calculations on the data, then this feature can do the trick.
Before describing the types of tasks you can perform in Calc, I want to highlight the key features of Calc. Calc can do all the basic spreadsheet functions you expect in a spreadsheet program. Here are some things you can do with Calc Save versions of a spreadsheet as you continue to change it, allowing you to revert to an older version if necessary. Format your spreadsheet with styles and templates.
The Format menu (shown in Figure 2-3) contains many of the options for formatting the spreadsheet. Thanks to the tooltips, all you have to do is mouse over a menu item to get a hint about what that menu item does. After you enter data into a spreadsheet, save it by choosing FileOSave As. A dialog box appears from which you can specify the file format, the directory location, and the name of the file. You've seen similar Save As dialog boxes a thousand times before. OpenOffice.org Calc can save the file in a number of formats, including Microsoft Excel 97 2000 XP, Microsoft Excel 95, Microsoft Excel 5.0, and a text file with comma-separated values (CSV). If you want to exchange files with Microsoft Excel, save the spreadsheet in the Microsoft Excel format (choose an appropriate version of Excel). Then you can transfer that file to a Windows system and open it in Microsoft Excel. After you save the spreadsheet once, you can also save intermediate versions of a spreadsheet. To save a new...
Create a new spreadsheet Create a spreadsheet from a template Open an existing spreadsheet Add a sheet to the spreadsheet Choose DataoDataPilotoStart. Use the subsequent dialog boxes to select a source of data, and to select the data you want to bring into the spreadsheet. Move around the spreadsheet
One interesting feature of Calc is the support for scenarios. A scenario is simply a collection of values for one or more cells. Scenarios are useful when you compare the effect of some cells on other calculations in the spreadsheet. For example, the monthly payment on a loan depends on the principal, the interest rate, and the duration of the loan. You can use Calc's scenario feature to compare the monthly payments for a number of different scenarios where each scenario has a certain combination of interest rate and loan duration in months. To use a scenario for this comparison, follow these steps 1. Set up the spreadsheet cells with labels and values for the principal, annual interest rate in percentage, and loan duration in months. Calculate the monthly payment using this formula The formula appears in the spreadsheet cell.
So, it's a nice change of pace to find a suite of productivity applications (word processor, spreadsheet, and slideshow presentation software, among others) that is not only packed with features but is also 100 percent free to download, install, and use no strings attached. The OpenOffice suite of applications is making waves in both the business world and in the home PC market, providing users with a great-looking collection of tools that provide professionalgrade results. In this chapter, I introduce you to OpenOffice Writer, one of three OpenOffice apps covered in the book. (Chapter 6 will cover OpenOffice Calc, a spreadsheet app Chapter 7 will cover OpenOffice Impress, a slideshow presentation app.)
OpenOffice Calc Spreadsheets OpenOffice Calc Spreadsheets OpenOffice Calc is a powerful spreadsheet program that also imports and exports other popular spreadsheet formats, including MS Excel. Spreadsheets are large tables where information is entered in individual cells that appear in rows and columns. They're ideal for accounting purposes and for creating data comparisons.
Imagine the following You're working on a project and have been saving the files in your Documents folder, which is where all your files tend to end-up, regardless of project. This particular project involves pictures (of varying file types), word processing documents, spreadsheets You spend a few minutes considering how chaotic it all is and then your boss asks you to send all the files to him. However, there are hundreds, and you can't sort by file extension or alphanumerically, because they're all different.
The cells in a spreadsheet are fairly small, but the size can be changed to accommodate larger entries and make data more readable on printouts. There are two ways to accomplish size changes. The first is to place the mouse cursor over the lines separating rows and columns in the guides (the lettered boxes at the top of the spreadsheet for columns, and the numbered ones along the left side for rows). For instance, if you want column A to be wider, position the mouse pointer over the borderline between the column A guide and the column B guide. When the pointer changes to a double-headed arrow, click and drag to the left or right to shorten or lengthen the column as desired. For rows, it's the same procedure except you move the double-headed arrow up and down to shorten or heighten the rows.
Today, Linux supports several desktop suites several more are under development. Apparently, if rumors are to be believed, even Microsoft is considering adapting their Office desktop suite to run under Linux. Whether or not Linux users can expect to soon run Microsoft Office for Linux (or whatever name Microsoft might give this potential product), Linux users who prefer to avoid other operating systems can now do so without compromising their ability to produce first-rate documents, spreadsheets, and graphics.
As with Kontour, Draw allows you to draw Bezier curves, geometric shapes, and to import bitmap images into your document. You can also import spreadsheets or charts from spreadsheets. With Draw, you can add 3-D shapes and convert the boundaries of 2-D images to 3-D so they can be manipulated as 3-D objects.
The office suite OpenOffice.org offers a complete set of office tools including a word processor, spreadsheet, presentation, vector drawing, and database components. Because OpenOffice.org is available for a number of operating systems, you can use the same data across different computing platforms. You can also open and edit files in Microsoft Office formats then save them back to this format, if needed.
The most common proprietary file format is probably Microsoft Word's format (denoted by a .doc extension). Many businesses run on Microsoft Word if you work with such a business, you'll have to exchange Microsoft Word files. In some fields, the file formats associated with other Microsoft Office components, such as Microsoft Excel (.xls) spreadsheets are equally or more important. Although Microsoft retains tight control over these file formats, most competing programs make at least some effort to support them. Chapter 7 describes some of the Linux programs that can handle these files. In brief, OpenOffice.org and its commercial twin StarOffice do the best job with Microsoft Word files. Unfortunately, no Linux program handles these files perfectly, so you may need to resort to emulation in some cases.
OpenOffice.org (www.openoffice.org) is a suite of office applications including a word processor (Writer), a spreadsheet (Calc), a drawing program (Draw), software for creating presentations (Impress), and a database program called Base, which keeps tagging along after the rest of OpenOffice. This section focuses on the word processing application other chapters in this book discuss the OpenOffice.org spreadsheet, graphics, and presentation software. But first, a word from our sponsor.
Long before OpenOffice.org was even a gleam in the eye of Tux, the Linux penguin mascot, Linux users still needed to create documents graphically. Over the years, a fine selection of quality business office applications have been developed for both the GNOME and KDE desktop environments, including suites for each environment. For GNOME, the GNOME Office suite (http live.gnome.org GnomeOffice) is a loosely coupled grouping of business office applications that includes applications such as the AbiWord word processor, the Gnumeric spreadsheet (discussed in Chapter 17), and a few other applications. By loosely coupled, I mean that there is little automatic interaction or data-sharing between the programs in the GNOME Office suite it's really more of a fraternal organization than an integrated office suite. On the KDE side, however, the story is very different. KDE's KOffice suite is a tightly coupled set of business office applications that easily and automatically share data whenever...
Calc is the spreadsheet component of the OpenOffice.org office software suite. The comprehensive range of advanced functions included in Calc helps professionals accomplish complex tasks. At the same time, Calc is user-friendly, which makes it easier for new users. This topic will familiarise you with its key features and teach you how to perform some basic spreadsheet functions. Similar to all other applications in the OpenOffice.org suite, Calc allows you to save spreadsheets in OASIS OpenDocument (ODF) format. This XML-based format enables you to access your spreadsheets from any OpenDocument-compliant software. In addition, Calc allows you to save spreadsheets directly as Portable Document Format (PDF) files without using any additional, expensive software.
Another popular desktop application is Corel's WordPerfect for Linux, available free of charge for personal use from Corel's web site, http www.corel.com . WordPerfect is more a word processor than a complete desktop suite for example, no spreadsheet application accompanies it. However, WordPerfect does provide many functions and features, including spreadsheet functions in tables
Some of the key features of OpenOffice.org Calc are Dynamic Charts As the name suggests, these charts update automatically as the data in the spreadsheet changes. Opening and Saving Microsoft Files Calc allows you to use your old Microsoft spreadsheets and save your work in Microsoft Excel or a variety of other formats. This facilitates the easy sharing of data with others using Microsoft or similar applications.
Spreadsheet, and Includes a word processor, desktop publishing application, and spreadsheet. Linux license 49 (US). Printed manuals 60 (US) per application. Java applets that provide a word processor, spreadsheet, presentation graphics, project scheduler, chart, SQL JDBC, and CGI gateway. Single-user license 127 (US).
One of the things that differentiates Ubuntu Linux from other Linux distributions is its extreme dedication to the user, especially in terms of internationalization. If you are installing Calc for use when creating spreadsheets in languages other than English, you may also want to search for and install the appropriate hyphenation, localization, and thesaurus packages for whatever other locales you are creating spreadsheets for. This is especially important for working with spreadsheets that use non-U.S. currencies.
This section holds a series of fascinating user guides and tutorials. You did not find a free software equivalent to your usual spreadsheet Browse the GNOME Documents and look for the gnumeric hyperlink. Those documents are the best way to quickly learn and feel comfortable with a GNU Linux desktop.
Formulas and functions perform calculations automatically before displaying the results within a cell. For detailed information on entering formulas and functions into a spreadsheet, refer to the OpenOffice Calc Spreadsheets section in Chapter 5. Figure 6.15 Entering Formulas and Functions in Your KSpread Spreadsheet
The spreadsheet tutorial in this section used fairly straightforward types of data that Calc could easily recognize sequences of characters from the alphabet and spaces are probably words, whereas numbers and decimal points are probably numeric values. Knowing the type of data that is contained in a cell (generally referred to as its data type or data format) is fairly important, especially when you subsequently want to invoke functions that calculate values from the contents of various cells. When you enter values in a spreadsheet without specifying their type, spreadsheets such as Calc assign them a general data format, which performs a best-guess of their data format based on the type of characters that they contain. However, you can also manually specify the format of any cell (or cells) by selecting those cells and using the commands on the Format C Cells dialog, shown in Figure 17-18. As an example, note that cell C3 in your example spreadsheet (most recently shown in Figure...
The Format Cells dialogue box also provides you with options to add smart borders and vibrant backgrounds to your spreadsheet. It also allows you to select a background colour, from a spectrum of colours, for your otherwise bland and dull spreadsheet. Define the specifications and click OK to apply the formatting effects. Figure 5.28 The Formatted Spreadsheet Figure 5.28 The Formatted Spreadsheet
A formula is a spreadsheet function, complete with arguments, entered in a cell. All formulae begin with an equal sign and may contain number, text and, in some cases, other data such as format details. The formulae may also contain arithmetic operators, logic operators or function starts.
StarOffice can be used for many purposes. It acts as a WYSIWYG (What You See Is What You Get) texteditor, a spreadsheet, a presentation software, etc. And you can even retrieve your mail from it. Now that you know what StarOffice can do for you, let us describe its basic utilities and features. Font replacement View Desktop 1 Other H Internet El Browser H Text document H HTML Document 0 Spreadsheet IS Presentation S Drawing H Picture
Official Download Page Vertex42 The Excel Nexus
Free version of Vertex42 The Excel Nexus can not be found on the internet. And you can safely download your risk free copy of Vertex42 The Excel Nexus from the special discount link below.