65 About Calc Styles and Templates
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.
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. 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 ). 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 |