« Using the Navigator | Main | Charting: Editing charts : part 3 »
January 05, 2005
Introduction to the Status Bar
How many of us have paid any attention to the row of small windows at the bottom of the OpenOffice Calc window? In this article, we will explore the Status Bar in more depth.The Status Bar displays information about the current sheet. It is shown below in the default configuration with the different fields tagged.
The fields in the default configuration are:
- 1 : Position The number of the current sheet and the total number of sheets in the document.
- 2 : Page Style The Page Style of the currently open sheet. You can double-click in this field to call up the Page Style Editor.
- 3 : Zoom The current page display zoom factor.
- 4 : Insert Mode The current insert mode. This field is active when the cursor is in the input line of a formula or cell. By clicking in this field, you can toggle between INSRT = insert and OVER = overwrite.
- 5 : Selection Mode The current selection mode. By clicking in this field, you can toggle between STD = Standard (default), EXT = Extend and ADD = Add.
- 6 : Modified Flag If modifications to the current document have not been saved, a * is displayed here.
- 7 : Formula A basic evaluation of a simple formula for the currently selected range is displayed here. Default is SUM
Posted by Dave at January 5, 2005 09:55 PM
Comments
I like the formula field, it really saves some time if you quickly want to find the sum, average etc of a range.
Is it possible to have TWO formula fields in the status bar? That way, if you have a sheet where you for some ranges want to check the sum, while for other you want to check the average, you wouldn't have to waste time switching field status. That would be neat.
Posted by: T Petersen at January 14, 2005 08:44 AM