Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Introducing Calc"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Minor editorial changes.)
m (Spreadsheets, sheets and cells: name spreadsheets as 'documents', specify column before row, etc->and so on.)
Line 14: Line 14:
  
 
== Spreadsheets, sheets and cells ==
 
== Spreadsheets, sheets and cells ==
Calc works with elements called ''spreadsheets''. Spreadsheets consist of a number of individual ''sheets'', each containing cells arranged in rows and columns. A particular cell is identified by its row number and column letter.
+
Calc works with documents called ''spreadsheets''. Spreadsheets consist of a number of individual ''sheets'', each containing cells arranged in rows and columns. A particular cell is identified by its column letter and row number.
  
These cells hold the individual elements—text, numbers, formulas etc.—which make up the data to display and manipulate.
+
These cells hold the individual elements—text, numbers, formulas, and so on—which make up the data to display and manipulate.
  
 
Each spreadsheet can have many sheets and each sheet can have many individual cells. In version 3.x of OOo, each sheet can have a maximum of 65,536 rows and a maximum of 1024 columns, which is over 67 million cells.
 
Each spreadsheet can have many sheets and each sheet can have many individual cells. In version 3.x of OOo, each sheet can have a maximum of 65,536 rows and a maximum of 1024 columns, which is over 67 million cells.

Revision as of 20:28, 15 March 2010



This is Chapter 1 of the OpenOffice.org 3 Calc Guide, produced by the OOoAuthors group.

What is Calc?

Calc is the spreadsheet component of OpenOffice.org (OOo). You can enter data, usually numerical, in a spreadsheet and then manipulate this data to produce certain results.

Alternatively 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.

Spreadsheets, sheets and cells

Calc works with documents called spreadsheets. Spreadsheets consist of a number of individual sheets, each containing cells arranged in rows and columns. A particular cell is identified by its column letter and row number.

These cells hold the individual elements—text, numbers, formulas, and so on—which make up the data to display and manipulate.

Each spreadsheet can have many sheets and each sheet can have many individual cells. In version 3.x of OOo, each sheet can have a maximum of 65,536 rows and a maximum of 1024 columns, which is over 67 million cells.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Personal tools