Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Mail Systems
Eclipse Documentation

How To Guides
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Problem Solutions
Privacy Policy




OpenOffice Calc User Guide
Previous Page Home Next Page

Formula bar

On the left of theFormula bar (see Figure 3) 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 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.

The Sumbutton 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.

The Functionbutton 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 that already contains something, 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, left-click the appropriate part of the Input Line area, then type your changes.To edit within the current cell, just double-click the cell.

OpenOffice Calc User Guide
Previous Page Home Next Page

  Published under the terms of the Open Publication License Design by Interspire