Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Parts of the main Calc window"
m |
(Minor editorial changes.) |
||
| Line 10: | Line 10: | ||
=== Title bar and Menu bar === | === Title bar and Menu bar === | ||
| − | The Title bar, at the top, shows the name of the current spreadsheet. | + | The Title bar, at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is ''Untitled X'', where ''X'' is a number. When you save a new spreadsheet for the first time, an alert will prompt you to enter a name of your choice. |
| − | Under the Title bar is the Menu bar. When you choose one of the menus, a submenu appears with other options. | + | Under the Title bar is the Menu bar. When you choose one of the menus, a submenu appears with other options. You can modify the Menu bar, as discussed in Chapter 14 (Setting up and Customizing Calc). |
=== Toolbars === | === Toolbars === | ||
| Line 19: | Line 19: | ||
The icons on these toolbars provide a wide range of common commands and functions. You can also modify these toolbars, as discussed in Chapter 14 (Setting up and Customizing Calc). | The icons on these toolbars provide a wide range of common commands and functions. You can also modify these toolbars, as discussed in Chapter 14 (Setting up and Customizing Calc). | ||
| − | Placing the mouse pointer over any of the icons displays a small box, called a tooltip. It gives a brief explanation of the icon’s function. For a more detailed explanation, select '''Help > What's This?''' and hover the mouse pointer over the icon. Tips and extended tips can now be turned on or off from '''Tools > Options > OpenOffice.org > General'''. | + | Placing the mouse pointer over any of the icons displays a small box, called a tooltip. It gives a brief explanation of the icon’s function. For a more detailed explanation, select '''Help > What's This?''' and hover the mouse pointer over the icon. To turn this feature off again, click once or press the ''Esc'' key twice. Tips and extended tips can now be turned on or off from '''Tools > Options > OpenOffice.org > General'''. |
In the Formatting toolbar, the three boxes on the left are the '''Apply Style''', '''Font Name''', and '''Font Size''' lists. If there is something in these boxes, they show the current setting for the selected area. (The Apply Style list may not be visible by default.) Click the down-arrow to the right of each box to open the list. | In the Formatting toolbar, the three boxes on the left are the '''Apply Style''', '''Font Name''', and '''Font Size''' lists. If there is something in these boxes, they show the current setting for the selected area. (The Apply Style list may not be visible by default.) Click the down-arrow to the right of each box to open the list. | ||
| Line 25: | Line 25: | ||
[[Image:CG3Ch1F2.png|thumb|none|500px|''Font name and font size'']] | [[Image:CG3Ch1F2.png|thumb|none|500px|''Font name and font size'']] | ||
| − | === Formula | + | === Formula Bar === |
| − | On the left of the Formula | + | On the left of the Formula Bar is a small text box, called the '''Name box''', with a letter and number combination in it, such as ''D7''. This is the column letter and row number, called the cell reference, of the current cell. |
[[Image:Formula-bar3.png|thumb|none|500px|''Formula bar'']] | [[Image:Formula-bar3.png|thumb|none|500px|''Formula bar'']] | ||
| − | To the right of the Name | + | To the right of the Name Box are the the Function Wizard, Sum, and Function buttons. |
| − | Clicking the '''Function Wizard''' button opens a dialog | + | Clicking the '''Function Wizard''' button opens a dialog from which you can search through a list of available functions. This can be very useful because it also shows how the functions are formatted. |
| − | The '''Sum''' button inserts a formula into the current cell that totals the numbers in the cells above | + | In a spreadsheet the term ''function'' includes much more than mathematical functions; see Chapter 7. |
| + | |||
| + | The '''Sum''' button inserts a formula into the current cell that totals the numbers in the cells above it. If there are no numbers above the current cell, then the cells to the left are placed in the Sum formula. | ||
The '''Function''' button inserts an equals sign into the selected cell and the Input Line, thereby setting the cell ready to accept a formula. | The '''Function''' button inserts an equals sign into the selected cell and the Input Line, thereby setting the cell ready to accept a formula. | ||
| Line 40: | Line 42: | ||
When you enter new data into a cell, the Sum and Equals buttons change to '''Cancel''' and '''Accept''' buttons [[Image:CancelAccept.png]]. | When you enter new data into a cell, the Sum and Equals buttons change to '''Cancel''' and '''Accept''' buttons [[Image:CancelAccept.png]]. | ||
| − | The contents of the current cell (data, formula, or function) are displayed in the Input | + | The contents of the current cell (data, formula, or function) are displayed in the '''Input line''', the remainder of the Formula Bar. You can edit the cell contents of the current cell here, or you can do that in the current cell. To edit inside the Input line area, click the appropriate part of the Input line area, then type your changes. To edit within the current cell, just double-click the cell. |
=== Individual cells === | === Individual cells === | ||
| Line 47: | Line 49: | ||
At the top of the columns and at the left-hand end of the rows are a series of gray boxes containing letters and numbers. These are the column and row headers. The columns start at A and go on to the right and the rows start at 1 and go on down. | At the top of the columns and at the left-hand end of the rows are a series of gray boxes containing letters and numbers. These are the column and row headers. The columns start at A and go on to the right and the rows start at 1 and go on down. | ||
| − | These column and row headers form the cell references that appear in the ''Sheet Area'' box on the Formula Bar. | + | These column and row headers form the cell references that appear in the ''Sheet Area'' box on the Formula Bar. You can turn these headers off by selecting '''View > Column & Row Headers'''. |
=== Sheet tabs === | === Sheet tabs === | ||
At the bottom of the grid of cells are the sheet tabs (see below). These tabs enable access to each individual sheet, with the visible, or active, sheet having a white tab. | At the bottom of the grid of cells are the sheet tabs (see below). These tabs enable access to each individual sheet, with the visible, or active, sheet having a white tab. | ||
| − | Clicking on another sheet tab displays that sheet and its tab turns white. You can also select multiple sheet tabs at once by holding down the ''Control'' key while you click the names. | + | Clicking on another sheet tab displays that sheet, and its tab turns white. You can also select multiple sheet tabs at once by holding down the ''Control'' key while you click the names. |
[[Image:Sheet-tabs.png|thumb|none|500px|''Sheet tabs'']] | [[Image:Sheet-tabs.png|thumb|none|500px|''Sheet tabs'']] | ||
| Line 63: | Line 65: | ||
'''Sheet sequence number''' | '''Sheet sequence number''' | ||
| − | Shows the sequence number of the current sheet the total number of sheets in the spreadsheet. The sequence number may not correspond with the name on the sheet tab. | + | Shows the sequence number of the current sheet and the total number of sheets in the spreadsheet. The sequence number may not correspond with the name on the sheet tab. |
'''Page style''' | '''Page style''' | ||
| Line 73: | Line 75: | ||
'''Insert mode''' | '''Insert mode''' | ||
| − | Click to toggle between ''Insert'' and ''Overwrite'' modes when typing. | + | Click to toggle between INSRT (''Insert'') and OVER (''Overwrite'') modes when typing. This field is blank when the spreadsheet is not in a typing mode (for example, when selecting cells). |
'''Selection mode''' | '''Selection mode''' | ||
| − | Click to toggle between STD (''Standard''), EXT (''Extend''), ADD (''Add | + | Click to toggle between STD (''Standard''), EXT (''Extend''), and ADD (''Add'') selection. EXT is an alternative to ''Shift+click'' when selecting cells. |
| − | '''Unsaved | + | '''Unsaved changes''' |
| − | + | An asterisk (*) appears here if changes to the spreadsheet have not been saved. | |
'''Digital signature''' | '''Digital signature''' | ||
| − | If the document has not been digitally signed, double-clicking in this area opens the Digital Signatures dialog, where you can sign the document. See Chapter | + | If the document has not been digitally signed, double-clicking in this area opens the Digital Signatures dialog, where you can sign the document. See Chapter 6 for more about digital signatures. |
If the document has been digitally signed, an icon [[Image:]] shows in this area. You can double-click the icon to view the certificate. | If the document has been digitally signed, an icon [[Image:]] shows in this area. You can double-click the icon to view the certificate. | ||
| Line 97: | Line 99: | ||
'''Zoom—new in OOo 3.1''' | '''Zoom—new in OOo 3.1''' | ||
| − | To change the view magnification, drag the Zoom slider or click on the + and – signs. You can also right-click on the zoom level | + | To change the view magnification, drag the Zoom slider or click on the + and – signs. You can also right-click on the zoom level percent to select a magnification value. |
{{CCBY}} | {{CCBY}} | ||
[[Category: Calc Guide (Documentation)]] | [[Category: Calc Guide (Documentation)]] | ||
Revision as of 09:24, 25 December 2009
When Calc is started, the main window looks similar to the picture below.
Title bar and Menu bar
The Title bar, at the top, shows the name of the current spreadsheet. When the spreadsheet is newly created, its name is Untitled X, where X is a number. When you save a new spreadsheet for the first time, an alert will prompt you to enter a name of your choice.
Under the Title bar is the Menu bar. When you choose one of the menus, a submenu appears with other options. You can modify the Menu bar, as discussed in Chapter 14 (Setting up and Customizing Calc).
Toolbars
Under the Menu bar by default are three toolbars: the Standard toolbar, the Formatting toolbar, and the Formula Bar.
The icons on these toolbars provide a wide range of common commands and functions. You can also modify these toolbars, as discussed in Chapter 14 (Setting up and Customizing Calc).
Placing the mouse pointer over any of the icons displays a small box, called a tooltip. It gives a brief explanation of the icon’s function. For a more detailed explanation, select Help > What's This? and hover the mouse pointer over the icon. To turn this feature off again, click once or press the Esc key twice. Tips and extended tips can now be turned on or off from Tools > Options > OpenOffice.org > General.
In the Formatting toolbar, the three boxes on the left are the Apply Style, Font Name, and Font Size lists. If there is something in these boxes, they show the current setting for the selected area. (The Apply Style list may not be visible by default.) Click the down-arrow to the right of each box to open the list.
Formula Bar
On the left of the Formula Bar is a small text box, called the Name box, with a letter and number combination in it, such as D7. This is the column letter and row number, called the cell reference, of the current cell.
To the right of the Name Box are the the Function Wizard, Sum, and Function buttons.
Clicking the Function Wizard button opens a dialog from which you can search through a list of available functions. This can be very useful because it also shows how the functions are formatted.
In a spreadsheet the term function includes much more than mathematical functions; see Chapter 7.
The Sum button inserts a formula into the current cell that totals the numbers in the cells above it. If there are no numbers above the current cell, then the cells to the left are placed in the Sum formula.
The Function button inserts an equals sign into the selected cell and the Input Line, thereby setting the cell ready to accept a formula.
When you enter new data into a cell, the Sum and Equals buttons change to Cancel and Accept buttons 
.
The contents of the current cell (data, formula, or function) are displayed in the Input line, the remainder of the Formula Bar. You can edit the cell contents of the current cell here, or you can do that in the current cell. To edit inside the Input line area, click the appropriate part of the Input line area, then type your changes. To edit within the current cell, just double-click the cell.
Individual cells
The main section of the screen displays the individual cells in the form of a grid, with each cell being at the intersection of a particular column and row.
At the top of the columns and at the left-hand end of the rows are a series of gray boxes containing letters and numbers. These are the column and row headers. The columns start at A and go on to the right and the rows start at 1 and go on down.
These column and row headers form the cell references that appear in the Sheet Area box on the Formula Bar. You can turn these headers off by selecting View > Column & Row Headers.
Sheet tabs
At the bottom of the grid of cells are the sheet tabs (see below). These tabs enable access to each individual sheet, with the visible, or active, sheet having a white tab.
Clicking on another sheet tab displays that sheet, and its tab turns white. You can also select multiple sheet tabs at once by holding down the Control key while you click the names.
Status bar
The Calc status bar provides information about the spreadsheet and convenient ways to quickly change some document features. From left to right, the fields are as follows.
Sheet sequence number
Shows the sequence number of the current sheet and the total number of sheets in the spreadsheet. The sequence number may not correspond with the name on the sheet tab.
Page style
Shows the page style of the current sheet. To change the page style, right-click on this field. A list of page styles pops up; choose a different style by clicking on it.
To edit the page style, double-click on this field. The Page Style dialog opens.
Insert mode
Click to toggle between INSRT (Insert) and OVER (Overwrite) modes when typing. This field is blank when the spreadsheet is not in a typing mode (for example, when selecting cells).
Selection mode
Click to toggle between STD (Standard), EXT (Extend), and ADD (Add) selection. EXT is an alternative to Shift+click when selecting cells.
Unsaved changes
An asterisk (*) appears here if changes to the spreadsheet have not been saved.
Digital signature
If the document has not been digitally signed, double-clicking in this area opens the Digital Signatures dialog, where you can sign the document. See Chapter 6 for more about digital signatures.
If the document has been digitally signed, an icon [[Image:]] shows in this area. You can double-click the icon to view the certificate.
Cell or object information
Displays information about the selected items. When a group of cells is selected, the sum of the contents is displayed by default; you can right-click on this field and select other functions, such as the average value, maximum value, minimum value, or count (number of items selected).
When the cursor is on an object such as a picture or chart, the information shown includes the size of the object and its location.
Zoom—new in OOo 3.1
To change the view magnification, drag the Zoom slider or click on the + and – signs. You can also right-click on the zoom level percent to select a magnification value.
| Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY). |
