41 Open an Existing Spreadsheet
Often, entering worksheet data requires nothing more than clicking the correct cell to select it and then typing the data. The various kinds of data behave differently when entered, however, so you should understand how Calc accepts assorted data.
Calc works with the following kinds of data:
Labels Text values such as names and addresses, as well as date and time values.
Numbers Numeric values such as 34, 291, 545.67874, and 0.
Dates and times Calc accepts date and time values that you type in virtually any format.
Formulas Expressions that compute numeric results. (Some formulas work with text values as well.)
This task walks you through a short editing session just to give you a feel for entering data into a Calc sheet. Keep in mind that Calc's interface is different from most other programs you may have worked with, unless you've worked with electronic spreadsheet programs before. Having said that, some of the editing skills you acquire in one OpenOffice.org program apply to the other OpenOffice.org programs as well. For example, both Calc and Writer offer the capability to display or hide the
Standard toolbar. The
Standard toolbar changes slightly depending on which program you use, but most of its functions are similar across the OpenOffice.org programs.
1. | Move the Active Cell Click cell D5 to make D5 the active cell. The cell's dark outline indicates that the cell is selected. Also, the cell name appears in the |
2. | Type Text in the Cell Type ABC Co. into cell D5 . To enter the text, simply type the text, and it appears both in the cell as well as in the Input line toward the top of the screen. When you press Enter , the active cell moves down one row. Instead of Enter , you can press the right arrow button or Tab , and the cell to the right of the cell becomes active next. 42. Enter Simple Data into a Spreadsheet
31 About Writer's Automatic Correction Tools ). AutoInput matches your text to input found elsewhere in the column. You can accept the proposed completion by pressing Enter or ignore the suggestion and continue typing. 60 Format Cells goes into detail about how to format cells. Click OK to close the dialog box. |
12. | Type 6:15 p.m. Type 6:15 p.m. in cell A7 . |
13. | Calc Converts the Time Press Enter and Calc converts your time to a different format. Calc converts the time to 06:15:00 PM , the time's full value in the |
Type the
am or
pm designation when entering time values or enter the time using a 24-hour clock. Either
6:15 pm or
18:15 work to enter the same time in the cell.