31.17.1. What is a spreadsheet document in 1C:Enterprise

Although you can use 1C:Enterprise spreadsheets to add, process, and display information like in standard spreadsheets (using spreadsheet documents in a form), they are mainly used to view processed information, for example, a description of a report print form. Program modules in the 1C:Enterprise language are used to process information and store it on the spreadsheet for most configuration objects.

The 1C:Enterprise spreadsheet editor is used to work with spreadsheet documents and print form templates.

Generated spreadsheet documents can be saved to disk in various formats. If a document is saved in MXL format, you can view it later in the file manager that is available at: http://v8.1c.ru/metod/fileworkshop.htm. It is not recommended to include OLE objects in a saved spreadsheet document if it is to be used in a web client or other that Windows operating systems.

Templates are stored in the configuration. There are common templates, which are located in the Common ‑ Templates branch. For example, templates of standard payment documents printed based on different documents. Also, there are templates for specific configuration objects, for example, a fixed asset card. A configuration object may have several print form templates.

Spreadsheet documents may also be placed in a form. For this purpose, use the Spreadsheet document field control. In this mode other controls can be inserted into a spreadsheet document.

Templates and spreadsheet documents in terms of work practices are almost the same.

Spreadsheet documents (files and templates) may be compared and merged.