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
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

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

  




 

 

SUSE Linux Enterprise Desktop (SLED 10) KDE Guide
Previous Page Home Next Page

3.3 Using Spreadsheets with Calc

Calc is the OpenOffice.org spreadsheet application. Create a new spreadsheet with File New Spreadsheet or open one with File Open . Calc can read and save in Microsoft Excel's format, so it is easy to exchange spreadsheets with Excel users.

NOTE: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.

3.3.1 Using Formatting and Styles in Calc

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.

Creating a Style

  1. Click Format Styles and Formatting.

  2. In the Formatting and Styles window, click either the Cell Styles or the Page Styles icon.

  3. Right-click in the Formatting and Styles window, then click New.

  4. Specify a name for your style and use the various tabs to set the desired formatting options.

  5. Click OK.

Modifying a Style

  1. Click Format Styles and Formatting.

  2. In the Formatting and Styles window, click either the Cell Styles or the Page Styles icon.

  3. Right-click the name of the style you want to change, then click Modify.

  4. Change the desired formatting options.

  5. Click OK.

3.3.2 Using Templates in Calc

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, open the applicable template and the styles you need for that template are available in the Formatting and Styles 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 (https://documentation.openoffice.org/HOW_TO/index.html).

Creating a Template

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:

  1. Click File New Spreadsheet.

  2. Create the styles and content that you want to use in any spreadsheet that uses this template.

  3. Click File Templates Save.

  4. Specify a name for the template.

  5. In the Categories box, click the category you want to place the template in.

    The category is the folder where the template is stored.

  6. Click OK.

SUSE Linux Enterprise Desktop (SLED 10) KDE Guide
Previous Page Home Next Page

 
 
  Published Courtesy of Novell, Inc. Design by Interspire