Entering Values

Calc is designed to do calculations. To do calculations, you need entries in your spreadsheet to provide the raw data to be used in the calculations. And to actually do a calculation, you need a formula that will take the raw data and return some sort of answer. Numerical entries and formulas in a Calc spreadsheet are referred to as values. The cells that hold them have numerical significance, which is just the opposite of the text entries that we talked about in the last section.

Numeric values in the spreadsheet can be entered using the 1 through 0 numeric keys. You are not required to enter commas, dollar signs, or percent signs in a cell (this can all be taken care of using different formatting options). You are required to ...

Get StarOffice™ 5.2 Calc Handbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.