The Spreadsheet Editor allows developers to take full advantage of the wide range of spreadsheet document features. Here are the main ones:
General Properties of a Spreadsheet Document
The editor allows setting general properties of a spreadsheet document, such as:
How to display totals when using groups of rows and columns in a document;
Turn a document into a template;
Add an image as a background for a document;
Set the area of the document that will be printed;
Set the color design of the document;
Specify the rows and columns of the document that will be printed on each new sheet.
The editor allows developers to specify the names of areas in a document. An area can be a cell or a group of cells.
When naming rows and columns in a document, the editor can display the area names in the edit window and highlight named areas. Multi-level nesting of named areas is supported:
Developers can add notes both for individual cells or groups of document cells:
The Spreadsheet Editor allows grouping rows or columns in a document. Groups can be created, deleted, or expanded (to include additional adjacent rows or columns). Additionally, it is possible to create nested and external groups:
When designing a spreadsheet document in the editor, we can draw straight lines, rectangles, and ovals and insert ready-made pictures saved in external files or created using the graphic editor:
In addition, the editor allows to group (ungroup) graphic objects and specify the names of graphic objects.
One of the essential features of the editor is the support for pivot tables in spreadsheet documents. A pivot table is a versatile mechanism to display and analyze multidimensional data retrieved from queries:
The support for OLE objects is a universal feature that allows users to embed into spreadsheet documents objects created in other Windows applications. For example, it can be a Word sheet, a CorelDraw drawing, or an Excel sheet. The OLE mechanism allows editing embedded objects as if they are opened in a native application:
Using the editor, we can add to spreadsheet documents various graphic objects like charts, Gantt charts, and dendrograms. These objects allow presenting 1C:Enterprise data in a convenient graphic form. Also, these objects can be accessed using the 1C:Enterprise language:
The utilization of these objects makes it possible to enhance the design of output documents and improve the visibility of the displayed information: