The Menu

Along the top of the window is the menu bar. Calc has all the features you expect from a modern spreadsheet system. It has too many menu options to cover in depth, so, instead, here's a summary of what you find on each menu:

♦ File: the Open, Save, Save As, Print, and Page Preview (called Print Preview in other spreadsheets) commands, along with a set of wizards and options for sending documents through email, creating templates, and creating web pages

♦ Edit: the Select All and Find commands, along with change tracking, headers and footers, and plug-in loading

♦ View: the Zoom functions and toolbars, along with options for showing or hiding column and row headers

♦ Insert: commands for adding page breaks and special characters, along with cells, rows, functions, and external data to your spreadsheets

♦ Format: cell and row formatting, cell merging, and page settings, along with conditional formatting and specifying the format to identify data in a cell (explained in further detail below)

♦ Tools: spell checker and thesaurus, along with hyphenation, autocorrection features, an image gallery, and a macro creator and editor

♦ Data: data selection, sorting, and grouping routines

If you've used Excel or any other spreadsheet application, you should recognize these functions.

By default, Calc attempts to detect the format of the data you enter into a cell. However, sometimes it guesses wrong, and other times you may want to select another format, such as the format used to display a date or numeric value. Calc provides formatting for






Scientific numbers


Boolean values


Each category of cell data has several options for how Calc presents it. There's even a user-defined option to allow you to customize how the data appears in the cells.

Was this article helpful?

0 0

Post a comment