Working with Open Officeorg Calc

The spreadsheet component of OpenOffice.org is named Calc, and is a capable Excel alternative. Earlier versions of Calc were limited to only 32,000 rows, but now Calc can support 65,656 rows, the same number as Excel.

Calc is used for storing numeric information that you need to analyze in some way. So, for instance, you could use it to help you budget month by month. It can take care of the calculations for you, as long as you tell Calc what you want it to do. Anyone with experience with Excel will feel right at home with Calc.

In this section, we show you how to get started with Calc, including entering formulas and formatting. We also take a look at some of the more advanced features of Calc, including the Data Pilot feature, which enables you to easily summarize information.

Getting Started

You can either click the shortcut icon 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: Calc starts to load.

By default, Calc loads with a blank spreadsheet just waiting for you to enter information into it. In Figure 9.7, you can see that we have already started to enter some basic information into Calc.

Was this article helpful?

0 0

Post a comment