Desktop version

Main > Knowledge Base > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 3. Spreadsheet document editor > Editing spreadsheet document and cell properties > Editing spreadsheet document properties > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 3. Spreadsheet document editor > Editing spreadsheet document and cell properties > Editing spreadsheet document properties > 1C:Enterprise documentation > 1C:Enterprise User Manual > Appendix 3. Spreadsheet document editor > Editing spreadsheet document and cell properties > Editing spreadsheet document properties

Editing spreadsheet document properties

Use the spreadsheet document property palette to configure its properties.

To view the spreadsheet document properties, at the top of the property palette, select Spreadsheet document.

You can customize the appearance of groups and headers by selecting the text and background colors.

To save the display settings (header view, grid, groups, names, and fixed rows and columns), select the Save Settings checkbox. 

The Total Horizontally and Total Vertically options define the rows and columns that are a logical part of a group but remain visible when the group is collapsed.  

Let us consider an example with the Total Vertically option set to Above. The spreadsheet is shown in the figure below.

Fig. 264. An example spreadsheet

If you click the first-level marker, the table looks as follows.

Fig. 265. First-level data

These are division totals.

If you click the second-level marker, the table looks as follows.

Fig. 266. Second-level data

These are department totals.

If you click the third-level marker, the table looks as follows.

Fig. 267. Third-level data.

These are employee data.

Next page: Specifying background picture




© 1C LLC. All rights reserved
1C Company respects the privacy of our customers and visitors
to our Web-site.