OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources] نسخه متنی

38. About Sheets and Spreadsheets

39 Set Calc Options

40 Create a New Spreadsheet

46 Edit Cell Data

Calc enables you to create and edit one or more sheets that you store in spreadsheets. Generally, people work with a single sheet for simple applications, such as a worksheet that an investor might use to analyze a single stock investment.Chapter 10, "Using Calc as a Simple Database"), although you'll want to use OpenOffice.org's Base program for in-depth database projects (see Chapter 18, "Organizing Your Data with Base"). If your project requires multiple closely linked financial sheets, you'll keep these sheets in one large spreadsheet file.File, Save As ; then name your Calc spreadsheet, specify the location, and select the format if you want to save the spreadsheet in a non-Calc format. To load an existing Calc or compatible spreadsheet file, use

File, Open .23 About Writer Tables ), except that Calc sheets can do much more high-end, numeric calculating than Writer tables can.

Initially, blank Calc spreadsheets contain three sheets, named

Sheet1, Sheet2 , and

Sheet3 . When you click a sheet's tab, Calc brings that sheet into view. Initially, you'll probably stay with one sheet per spreadsheet, so you may never have to click the secondary sheet tabs to bring the other sheets into view.cell reference , and it is unique for each cell in the sheet. The active cell or cells are always highlighted with a dark border (

46 Edit Cell Data shows how to select multiple cells). A cell's location, also known as its

reference , appears in the Name Box.

KEY TERM

Cell reference
The name of the cell, composed of its column and row intersection, such as

G14 . This is also called the

cell address .