OpenOffice.org 2, Firefox, and Thunderbird for Windows All in One [Electronic resources]

Greg Perry, M. T. Cozzola, Jennifer Fulton

نسخه متنی -صفحه : 231/ 90
نمايش فراداده

67. Create a Calc Template

65 About Calc Styles and Templates

66 Create a Calc Style

73 Import and Export Sheet Data

Templates contain formatting for complete spreadsheets. Think of a template as a model for a spreadsheet. All the OpenOffice.org programs support templates. If you create a new spreadsheet without specifying a template, Calc uses the

Default template style to create the empty spreadsheet and to set up initial font, margin, and other formatting-related details.

The

Template Management dialog box, available from the

File, Templates, Organize menu option, lists all templates currently available to you. You work with templates, selecting and adding them, from the

Template Management dialog box.

NOTE

Calc templates use the filename extension .ots.

1.

Request a Template

Select

File, New, Templates and Documents to open the

Templates and Documents dialog box. The buttons along the top and left side of the dialog box let you navigate among different folders and view information about the selected template. Click the

Templates icon on the left to see folders of templates such as

My Templates (used for Impress; see

86 Use an Impress Template ). To open a template folder, double-click it to see all the available templates in that folder. Double-click the

My Templates folder to see its contents.

2.

Choose a Template

Decide which template you want to work with.

NOTE

If you've recently installed Calc or have not added new templates, you may only see a Writer template named

letter .

67. Create a Calc Template.

70 Protect Spreadsheet Data ).

NOTE

You can also save a template using the

Save As dialog box. To do so, choose

File, Save As and then choose a folder location, type a filename, and change the file type to the .ots filename extension. If you use this option, make sure that you either navigate to the

My Templates folder to save your template to this location, or remember its folder location so that you can navigate to it when you want to create a new spreadsheet based on this template.

4.

Create a New Template

Feel free to create your own templates! Remember to include placeholder instructions to the user of your template, such as

[Type Discount Rate Here] .

After you create and format a spreadsheet that you may need to re-create in the future, save the spreadsheet and then remove all the data specific to that particular spreadsheet, keeping all the formulas and formatting intact.

When you select

File, Templates, Save , Calc opens the

Templates dialog box, where you can assign a name and folder for your template (the default location is the

My Templates folder). The next time you create a new document from a template, your new template will appear in the

My Templates folder.