A spreadsheet document is a common object in the 1C:Enterprise language. We use it to create output documents: primary documents and reports. In fact, a spreadsheet document is a powerful interactive tool for presenting information and can be used both on its own and as part of any of the forms included with an application. Essentially, a spreadsheet document is similar to a spreadsheet table: it consists of rows and columns with data. Still, its capabilities are much broader.
Spreadsheet document has excellent design possibilities. Developers can set font types and sizes for text placed in the cells of a spreadsheet document:
It is possible to decorate cells with frames of various types:
Developers can set colors for text, background, and frames. To choose colors, they can use either the operating system palette or the Web color palette supported by the platform, or the palette of the style used by the application:
Spreadsheet documents allow to group rows and columns. This way, we can group data in reports using any desired number of nested groups.
Groups can be horizontal or vertical. Developers can decide where to place totals for a group. Thus, in vertical groups, they can be located at the top or bottom, and in horizontal groups on the right or left.
Spreadsheet documents allow displaying groups in a hierarchy. By pressing numbers in the headings, we can expand all groups of a given level at once and also collapse more detailed groups.
The platform automatically adds indentation for hierarchy levels when using groups:
The system supports the mechanism for providing details that allows users to generate a detailed or additional report by clicking on a line or cell in a spreadsheet document. The platform can process mouse clicks in spreadsheet document cells. In this case, the system can run both standard actions and algorithms specified by a developer.
A standard action of displaying details can be initiated by clicking on a document or a reference element. In this case, the platform opens this object for viewing (unless otherwise provided by the developer).
To process non-standard actions referring to details, we use the 1C:Enterprise language. Thus, a developer can set an algorithm for obtaining a detailed report by regenerating an existing one using additional selection conditions (e.g., show sales only for this contractor). Or, using the mechanism of providing details, users can get a completely new report (e.g., show invoices that contributed to sales for this counterparty).
The mechanism of providing details makes it possible to significantly facilitate the user's work since the platform automatically generates relevant reports to a specific application and does not require users to set initial parameters. The desired report settings can be determined automatically based on the context in which a user invokes the report.
Developers can add comments both for individual cells or groups of document cells: A cell with a comment has a small triangle in the top right corner. The comment is displayed in a pop-up window when a user hovers a cursor over the cell. We use comments to add additional (reference) information to spreadsheet documents that is not displayed on the screen (in standard mode) but can be easily viewed if you move the mouse cursor to the desired cell:
Spreadsheet documents allow different column widths for various rows. This feature is essential for regulated reports. In fact, in this case, the tabular document will consist of several tables, which, for example, is often found in accounting and tax reporting:
The platform can display spreadsheet documents in compact view to ease the use of documents on mobile devices with a narrow screen. The cells are reorganized vertically, so the document has no horizontal scrolling.
Entry of Data into Spreadsheet Documents
Although spreadsheet documents are mainly used to represent already processed information, it is possible to directly enter data into a spreadsheet document as into a "regular" spreadsheet.
The data entered into the cells of a spreadsheet document can be processed with handlers written in the 1C:Enterprise language. The results of such processing can be used to calculate other spreadsheet document cells.
Direct data entry into a spreadsheet document can be used, for example, when generating a goods delivery order or a balance sheet:
Since spreadsheet documents are often used to generate output documents, they can be saved to a file on disk for later use or transfer to other computers. Spreadsheet documents can be saved in their own format or exported to other data storage formats, including the Microsoft Office document format (*.xlsx, *.docx), the OpenDocument spreadsheet format (*.ods), or the Adobe electronic documents (*.pdf):
Developers can use the Spreadsheet Editor to create templates that will be used to form a spreadsheet document shown to the user. This powerful tool allows to design table structures and gives access to vector graphics. Using the editor, we can create everything from small documents with a very complex structure of rows (such as a payment order) to voluminous statements, journals, etc. More…