You can enter data into Calc in several ways: using the keyboard, the mouse (dragging and dropping), the Fill tool, and selection lists. In version 3.0 of OOo, each sheet can have a maximum of 65,536 rows and a maximum of 1024 columns. These cells hold the individual elements-text, numbers, formulas etc.-which make up the data to be displayed and manipulated.Įach spreadsheet can have many sheets and each sheet can have many individual cells. Spreadsheets consist of a number of individual sheets, each containing a block of cells arranged in rows and columns. Spreadsheets, sheets and cells Ĭalc works with elements called spreadsheets. You can enter data, usually numerical data, in a spreadsheet and then manipulate this data to produce certain results.Īlternatively you can enter data and then use Calc in a ‘What If.’ manner by changing some of the data and observing the results without having to retype the entire spreadsheet or sheet. 11.2 Identifying copies of spreadsheetsĬalc is the spreadsheet component of (OOo).11.1 Preparing a document for review (optional).8.3 Working with scenarios using the Navigator.4 Understanding the structure of functions.

Openoffice calculate time difference