Modèles

Spreadsheet templates allow you to quickly create spreadsheets without starting from scratch. For example, you could create a template for a monthly budget report or a quarterly sales commission report.

Note

Les modèles sont accessibles à tous les utilisateurs sur la base de données.

Créer un modèle

Any spreadsheet can be saved as a template. Open the relevant spreadsheet or create a new one. From the menu bar, click File ‣ Save as template. Modify the default Template Name if needed and click Confirm.

Important

Once a spreadsheet is saved as a template, any further changes to the open spreadsheet are saved only in that spreadsheet. To make changes to the template, you need to edit the template.

You can also create a template by making a copy of an existing template and editing it.

Use templates

To create a new spreadsheet using a template, open the Documents app and click New ‣ Spreadsheet. Select the relevant template and click Create.

Alternatively, go to Documents ‣ Configuration ‣ Spreadsheet Templates then, on the line of the relevant template, click New spreadsheet.

Note

By default, the new spreadsheet inherits the name of the template, which is shown at the top of the screen. To rename the spreadsheet, click the name and edit it.

Gérer et modifier les modèles

Gérez les modèles en allant aux Documents ‣ Configuration ‣ Modèles de feuille de calcul. Supprimez le filtre Mes modèles pour afficher tous les modèles dans la base de données.

Various actions are possible:

  • Copy an existing template by clicking Make a copy at the right of the screen. The new template appears at the bottom of the list. Click the Name to edit it.

  • Edit an existing template (including one you just copied) by clicking Edit, then making the required changes. Modifications are automatically saved.

  • Delete a template by ticking the checkbox next to it, clicking Actions, then Delete.

Astuce

Use the download button under the Spreadsheet file column to export a template in JSON format. The file can be imported into another database.