Difference between revisions of "Documentation/OOo3 User Guides/Calc Guide/Parts of the main Calc window"

From Apache OpenOffice Wiki
Jump to: navigation, search
m (→‎Formula bar)
 
(8 intermediate revisions by 3 users not shown)
Line 7: Line 7:
 
When Calc is started, the main window looks similar to the picture below.
 
When Calc is started, the main window looks similar to the picture below.
  
−
[[Image:Calc-mainwindow.png|thumb|none|600px|''Parts of the Calc window'']]
+
[[Image:Calc3-mainwindow.png|thumb|none|600px|''Parts of the Calc window'']]
  
−
=== Title bar and Menu bar ===
+
{{Note|If any part of the Calc window is not shown, you can display it using the View menu. For example, View > Status Bar will toggle (show or hide) the Status Bar. It is not always necessary to display all the parts, as shown; show or hide any of them, as desired.}}
−
The Title bar, at the top, shows the name of the current spreadsheet. If the spreadsheet is new, then its name is ''Untitled X'', with ''X'' being a number. When you save a new spreadsheet for the first time, you will be prompted to enter a name.
+
  
−
Under the Title bar is the Menu bar. When you choose one of the menus, a submenu appears with other options. The Menu bar can be modified, as discussed in Appendix D (Setting up and Customizing Calc).
+
=== Title bar===
 +
The Title bar, located 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, you are prompted to enter a name of your choice.
 +
 
 +
=== Menu bar ===
 +
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 [[Documentation/OOo3_User_Guides/Calc Guide/Customizing Calc|Setting up and Customizing Calc]].
 +
 
 +
* '''File''' contains commands that apply to the entire document such as Open, Save, Wizards, Export as PDF, and Digital Signatures.
 +
* '''Edit''' contains commands for editing the document such as Undo, Changes, Compare Document, and Find and Replace.
 +
* '''View''' contains commands for modifying how the Calc user interface looks such as Toolbars, Full Screen, and Zoom.
 +
* '''Insert''' contains commands for inserting elements such as cells, rows, columns, sheets, and pictures into a spreadsheet.
 +
* '''Format''' contains commands for modifying the layout of a spreadsheet such as Styles and Formatting, Paragraph, and Merge Cells.
 +
* '''Tools''' contains functions such as Spelling, Share Document, Cell Contents, Gallery, and Macros.
 +
* '''Data''' contains commands for manipulating data in your spreadsheet such as Define Range, Sort, Filter, and DataPilot.
 +
* '''Window''' contains commands for the display window such as New Window, Split, and Freeze.
 +
* '''Help''' contains links to the Help file bundled with the software, What's This?, Support, Registration, and Check for Updates.
  
 
=== Toolbars ===
 
=== Toolbars ===
−
Under the Menu bar by default are three toolbars: the Standard toolbar, the Formatting toolbar, and the Formula bar.
+
Three toolbars are located under the Menu bar by default: the Standard toolbar, the Formatting toolbar, and the Formula Bar.
  
−
The icons on these toolbars provide a wide range of common commands and functions. The toolbars can be modified, as discussed in Appendix D (Setting up and Customizing Calc).
+
The icons (buttons) on these toolbars provide a wide range of common commands and functions. You can also modify these toolbars, as discussed in [[Documentation/OOo3_User_Guides/Calc Guide/Customizing Calc|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 two rectangular areas on the left are the '''Font Name''' and '''Font Size''' menus. If there is something in these boxes, they show the current setting for the selected area.
+
In the Formatting toolbar, the three boxes on the left are the '''Apply Style''', '''Font Name''', and '''Font Size''' lists. They show the current settings for the selected cell or 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.
  
 
[[Image:CG3Ch1F2.png|thumb|none|500px|''Font name and font size'']]
 
[[Image:CG3Ch1F2.png|thumb|none|500px|''Font name and font size'']]
  
−
Click the little button with an inverted triangle to the right of the box to open a menu. From the '''Font Name''' and '''Font Size''' menus, you can change the font and its size in selected cells.
+
{{Note|If any of the icons (buttons) is not shown, you can display it by clicking the small triangle at the right end of the Formatting toolbar, selecting '''Visible Buttons''' in the drop-down menu, and selecting the desired icon (for example, '''Apply Style''') in the drop-down list. It is not always necessary to display all the toolbar buttons, as shown; show or hide any of them, as desired.}}
  
−
=== Formula bar ===
+
=== 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.
+
On the left hand side 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 combination, called the cell reference, is the column letter and row number of the selected 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 box are the the Function Wizard, Sum, and Function buttons.
+
To the right of the Name Box are the Function Wizard, Sum, and Function buttons.
  
−
Clicking the '''Function Wizard''' button opens a dialog box 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.
+
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, or to the left if there are no numbers above, the current cell.
+
In a spreadsheet the term ''function'' includes much more than just mathematical functions; see [[Documentation/OOo3_User_Guides/Calc_Guide/Formulas_and_Functions|Formulas and functions]] for more details.
  
−
The '''Function''' button inserts an equals sign into the selected cell and the Input Line, thereby setting the cell ready to accept a formula.
+
Clicking the '''Sum''' button inserts a formula into the current cell that totals the numbers in the cells above the current cell. If there are no numbers above the current cell, then the cells to the left are placed in the Sum formula.
 +
 
 +
Clicking the '''Function''' button inserts an equals (=) sign into the selected cell and the Input line, thereby enabling the cell to accept a formula.
  
 
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 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.
+
The contents of the current cell (data, formula, or function) are displayed in the '''Input line''', which is the remainder of the Formula Bar. You can either 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 in the area, then type your changes. To edit within the current cell, just double-click the cell.
  
 
=== Individual cells ===
 
=== 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.
+
The main section of the screen displays the cells in the form of a grid, with each cell being at the intersection of a 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.
+
At the top of the columns and at the left 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 headers can also be turned off by selecting '''View > Column & Row Headers'''.
+
These column and row headers form the cell references that appear in the ''Name Box'' 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. These tabs enable access to each individual sheet, with the visible (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'']]
+
  
 
=== Status bar ===
 
=== 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.
+
The Calc status bar provides information about the spreadsheet and convenient ways to quickly change some of its features.  
  
−
[[Image:CalcStatusbar3.png]]
+
[[Image:CalcStatusbar3a.png|thumb|none|500px|''Left end of Calc status bar'']]
  
−
'''Sheet sequence number'''
+
[[Image:CalcStatusbar3b.png|thumb|none|500px|''Right end of Calc status bar'']]
  
−
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.
+
'''Sheet sequence number''' ([[Image:CalcStatusbar3c.png]])
  
−
'''Page style'''
+
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.
  
−
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.
+
'''Page style''' ([[Image:CalcStatusbar3d.png]])
  
−
To edit the page style, double-click on this field. The Page Style dialog opens.
+
Shows the page style of the current sheet. To edit the page style, double-click on this field. The Page Style dialog opens.
  
−
'''Insert mode'''
+
'''Insert mode''' ([[Image:CalcStatusbar3e.png]])
  
−
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''' ([[Image:CalcStatusbar3f.png]])
  
−
Click to toggle between STD (''Standard''), EXT (''Extend''), ADD (''Add'') and BLK (''Block'') selection. EXT is an alternative to ''Shift+click'' when selecting text.
+
Click to toggle between STD (''Standard''), EXT (''Extend''), and ADD (''Add'') selection. EXT is an alternative to ''Shift+click'' when selecting cells. See [[Documentation/OOo3_User_Guides/Calc_Guide/Selecting_items|Selecting items in a sheet or spreadsheet]] for more information.
  
−
'''Unsaved document flag'''
+
'''Unsaved changes''' ([[Image:CalcStatusbar3g.png]])
  
−
If changes have been made to the document since it was last saved, an asterisk (*) appears in this field.
+
An asterisk (*) appears here if changes to the spreadsheet have not been saved.
  
−
'''Digital signature'''
+
'''Digital signature''' ([[Image:SecurePDFicon.png]])
  
−
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 5 for more about digital signatures.
+
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 [[Documentation/OOo3_User_Guides/Calc_Guide/Digital_signing|Digital signing of documents]] 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:SecurePDFicon.png]] shows in this area. You can double-click the icon to view the certificate. A document can be digitally signed only after it has been saved.
  
−
'''Cell or object information'''
+
'''Cell or object information''' ([[Image:CalcStatusbar3h.png]])
  
 
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).
 
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).
Line 97: Line 108:
 
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.
 
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'''
+
'''Zoom—new in OOo 3.1''' ([[Image:CalcStatusbar3j.png]])
  
−
To change the view magnification, drag the Zoom slider or click on the + and – signs. You can also right-click on the zoom level percentage to select a magnification value.
+
To change the view magnification, drag the Zoom slider or click on the + and – signs. You can also right-click on the zoom level percentage to select a magnification value or double-click to open the Zoom & View Layout dialog.
  
  
 
{{CCBY}}
 
{{CCBY}}
 
[[Category: Calc Guide (Documentation)]]
 
[[Category: Calc Guide (Documentation)]]

Latest revision as of 19:20, 6 July 2018



When Calc is started, the main window looks similar to the picture below.

Parts of the Calc window
Documentation note.png If any part of the Calc window is not shown, you can display it using the View menu. For example, View > Status Bar will toggle (show or hide) the Status Bar. It is not always necessary to display all the parts, as shown; show or hide any of them, as desired.

Title bar

The Title bar, located 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, you are prompted to enter a name of your choice.

Menu bar

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 Setting up and Customizing Calc.

  • File contains commands that apply to the entire document such as Open, Save, Wizards, Export as PDF, and Digital Signatures.
  • Edit contains commands for editing the document such as Undo, Changes, Compare Document, and Find and Replace.
  • View contains commands for modifying how the Calc user interface looks such as Toolbars, Full Screen, and Zoom.
  • Insert contains commands for inserting elements such as cells, rows, columns, sheets, and pictures into a spreadsheet.
  • Format contains commands for modifying the layout of a spreadsheet such as Styles and Formatting, Paragraph, and Merge Cells.
  • Tools contains functions such as Spelling, Share Document, Cell Contents, Gallery, and Macros.
  • Data contains commands for manipulating data in your spreadsheet such as Define Range, Sort, Filter, and DataPilot.
  • Window contains commands for the display window such as New Window, Split, and Freeze.
  • Help contains links to the Help file bundled with the software, What's This?, Support, Registration, and Check for Updates.

Toolbars

Three toolbars are located under the Menu bar by default: the Standard toolbar, the Formatting toolbar, and the Formula Bar.

The icons (buttons) on these toolbars provide a wide range of common commands and functions. You can also modify these toolbars, as discussed in 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. They show the current settings for the selected cell or 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.

Font name and font size
Documentation note.png If any of the icons (buttons) is not shown, you can display it by clicking the small triangle at the right end of the Formatting toolbar, selecting Visible Buttons in the drop-down menu, and selecting the desired icon (for example, Apply Style) in the drop-down list. It is not always necessary to display all the toolbar buttons, as shown; show or hide any of them, as desired.

Formula Bar

On the left hand side 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 combination, called the cell reference, is the column letter and row number of the selected cell.

Formula bar

To the right of the Name Box are 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 just mathematical functions; see Formulas and functions for more details.

Clicking the Sum button inserts a formula into the current cell that totals the numbers in the cells above the current cell. If there are no numbers above the current cell, then the cells to the left are placed in the Sum formula.

Clicking the Function button inserts an equals (=) sign into the selected cell and the Input line, thereby enabling the cell to accept a formula.

When you enter new data into a cell, the Sum and Equals buttons change to Cancel and Accept buttons CancelAccept.png.

The contents of the current cell (data, formula, or function) are displayed in the Input line, which is the remainder of the Formula Bar. You can either 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 in the 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 cells in the form of a grid, with each cell being at the intersection of a column and row.

At the top of the columns and at the left 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 Name Box 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. These tabs enable access to each individual sheet, with the visible (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 of its features.

Left end of Calc status bar
Right end of Calc status bar

Sheet sequence number (CalcStatusbar3c.png)

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 (CalcStatusbar3d.png)

Shows the page style of the current sheet. To edit the page style, double-click on this field. The Page Style dialog opens.

Insert mode (CalcStatusbar3e.png)

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 (CalcStatusbar3f.png)

Click to toggle between STD (Standard), EXT (Extend), and ADD (Add) selection. EXT is an alternative to Shift+click when selecting cells. See Selecting items in a sheet or spreadsheet for more information.

Unsaved changes (CalcStatusbar3g.png)

An asterisk (*) appears here if changes to the spreadsheet have not been saved.

Digital signature (SecurePDFicon.png)

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 Digital signing of documents for more about digital signatures.

If the document has been digitally signed, an icon SecurePDFicon.png shows in this area. You can double-click the icon to view the certificate. A document can be digitally signed only after it has been saved.

Cell or object information (CalcStatusbar3h.png)

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 (CalcStatusbar3j.png)

To change the view magnification, drag the Zoom slider or click on the + and – signs. You can also right-click on the zoom level percentage to select a magnification value or double-click to open the Zoom & View Layout dialog.


Content on this page is licensed under the Creative Common Attribution 3.0 license (CC-BY).
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/OOo3_User_Guides/Calc_Guide/Parts_of_the_main_Calc_window&oldid=240549"
Personal tools