Calc is the OpenOffice.org spreadsheet application. Create a new spreadsheet with
+ + or open one with + . Calc can read and save in Microsoft Excel's format, so it is easy to exchange spreadsheets with Excel users.Calc can process many VBA macros in Excel documents; however, support for VBA macros is not yet complete. When opening an Excel spreadsheet that makes heavy use of macros, you might discover that some do not work. |
In the spreadsheet cells, enter fixed data or formulas. A formula can manipulate data from other cells to generate a value for the cell in which it is inserted. You can also create charts from cell values.
Calc comes with a few built-in cell and page styles to improve the appearance of your spreadsheets and reports. Although these built-in styles are adequate for many uses, you will probably find it useful to create styles for your own frequently used formatting preferences.
Click
+ .In the
window, click either the or the icon.Right-click in the
window, then click .Specify a name for your style and use the various tabs to set the desired formatting options.
Click
.If you use different styles for different types of spreadsheets, you can use templates to save your styles for each spreadsheet type. Then, when you create a particular type of spreadsheet, use the applicable template and the styles you need for that template are available in the
window.A detailed explanation of templates is beyond the scope of this section. However, more information is found in the help system and detailed how-tos are found at the OpenOffice.org Documentation page, see http://documentation.openoffice.org/HOW_TO/index.html.
A Calc template is a spreadsheet that contains styles and content that you want to appear in every spreadsheet created with that template, such as headings or other cell styles. When a spreadsheet is created or opened with the template, the styles are automatically applied to that spreadsheet.
To create a template:
Click
+ + .Create the styles and content that you want to use in any spreadsheet that uses this template.
Click
+ + .Specify a name for the template.
In the
box, click the category you want to place the template in.The category is the folder where the template is stored.
Click
.