لطفا منتظر باشید ...
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.
NOTECalc 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. NOTEIf you've recently installed Calc or have not added new templates, you may only see a Writer template named letter . 70 Protect Spreadsheet Data ). NOTEYou 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. |
