Spreadsheet Document Editor

How do I print a spreadsheet document?
How do I specify automatic repetition of rows and columns during printing?
How do I specify print area?

1C:Enterprise is intended to create and edit spreadsheet documents, print form templates (as well as form controls of the spreadsheet document type).

You can create a new document using:

  • "File — New menu item and selecting "Spreadsheet Document" for the created document type;

  • Ctrl+N keyboard shortcut.

The built-in spreadsheet document editor makes it possible to edit spreadsheet documents.

To open an existing document, use one of the following options:

  • "File - Open

  • Ctrl+O keyboard shortcut;
  • drag the file from Windows Explorer to 1C:Enterprise workspace.

Spreadsheet document is stored in a separate file on disk (outside of the configuration). Normally it is a pre-configured print form and is used independently.

A spreadsheet document editor can be used to create templates. A Template is stored in the configuration. A template may be shared or may refer to a specific configuration object (for example, a fixed asset card). A configuration object may have several different templates.

A spreadsheet document control may be located in a form. At that other controls can be inserted into a spreadsheet document while cells and groups of cells (areas) can support the so-called detalization, i.e. allow the user to obtain a detailed report or information on the data located in this area. In 1C:Enterprise mode, when you hover mouse pointer over such an area, it changes its appearance to crosshair with a magnifying glass . Pressing Enter in such an area will result in building a new report (as defined in the task configuration development by the developer). If the data is a reference to a database object (for example, a catalog item value, a document, and, etc.), an object form is opened. 

Working with templates is similar to working with spreadsheet documents.

A spreadsheet document control can be located in a form. In this event spreadsheet documents can contain other controls while cells and groups of cells (areas) can support the so-called detalization, i.e. allow the user to obtain a detailed report or information on the data located in this area. In 1C:Enterprise mode, when you hover mouse pointer over such an area, it changes its appearance to crosshair with a magnifying glass . Pressing Enter in such an area will result in building a new report (as defined in the task configuration development by the developer). If the data is a reference to a database object (for example, a catalog item value, a document, and, etc.), an object form is opened. 

Table view management

Using the commands from "Table View" you can adjust the display of various areas of the table; column and row headers, grid, etc.
Each command "View" works like a radio button: clicking them displays or hides the respective table area.:

    Command

    Action

Dock the table

Docks the top rows and leftmost columns of the table so that they are always displayed when scrolling through the table;

Show grid

Toggles display of the table grid (thin lines that separate cells).

Show headers

Toggles display of column and row headers;

Show Groups

Toggles display of named areas (to the left from the row headers and above the column headers);

Editing

Toggles table lock for editing;

Show comments

Toggles display of comments;

Show named cells

Toggles display of named areas (cells);

Black and white view

Toggles colors specified for the table. If this command is selected (it will be marked with a tick in the menu), all the colors will be determined by Microsoft Windows settings;

View pages mode

Toggles display of a minimum number of rows (determined by the information entered), print area and page breaks;

Scaling

Performs a discrete image scaling.

Names

You can specify names for individual table cells, cell ranges and graphical objects.

If you select an entire row or multiple rows (entire column or multiple columns) and designate a name for the selected area (Table - Names - Set Name… menu item) and the Display named rows/columns mode is enabled, the area names will be displayed on the left (for rows) or at the top (for columns). If Display named cells mode is enabled, the "internal" named areas are displayed. The name of an area is displayed in the center of the area.

Adjusting row height and column width
To adjust row height or column width manually
Place the mouse pointer at the header's border and move it as required.
To set up the minimum possible column width, double-click the header's border.
You can change column width or row height by dragging their borders while holding the Ctrl key down.
Automatically adjusting row height or column width.
To adjust the height or width automatically, select the required row or column by left-clicking its header. Then select Table Cells Row height or Table Cells Column width menu item. In the window that opens, specify the required height or width.
If you specify "Auto" in the prompt, row height will be adjusted to fit the maximum text height in this row.
If you specify "Auto" in the column width prompt, column width will be set to the value selected for columns of the entire table. If you specify "Auto" for the entire table column width, column width will be set to 9.

If cells contain information and you need to set minimum column width or row height, double-click the column or row separator. The program will determine maximum height or width of the text and resize the cell so that the entered text fits.

The cursor changes when placed on the right border for cells of a spreadsheet document in a form with quick change mode enabled (softset or set during configuration development). It is possible to change cell size by dragging the border (holding the left mouse button down) to the left or to the right.

Cell text input

To enter a text into an empty cell, you should simply start typing. The cell will switch to the editing mode: a text cursor (blinking vertical line) will appear in the cell, and you will see the text being typed in the cell. Press Enter when you finish typing.

If you want to edit text in a cell without replacing it but adding to the text instead, press Enter or F2 or double-click the cell before typing the text.

Note the Shift+Enter keyboard shortcut. Using this shortcut allows you to start a new text line in a cell completing editing the cell.

A comment may be created for any cell in a spreadsheet. A comment is a custom text that describes the cell. A cell with a comment is marked by a red triangle in the upper right corner.

Inputting text into cells of a spreadsheet document located in a form

Input methods are the same as described earlier, but a few special features should be mentioned here.

Spreadsheet cells may contain typed data (e.g. a cell may contain only numeric data or specific catalog values).

If a cell is of Number, String, Date, or Boolean type, a standard method can be used to input a value (from keyboard or clipboard). It is also possible to use standard value selection tools (calculator, calendar) for these types (except for String). You can bring these tools up by pressing F4 when editing a cell.

If a catalog (document, enumeration, etc.) value can be entered into a cell, press F4 when editing the cell to select the required value. Another way is to type the required value directly into the cell. 

Use Shift+F4 keyboard shortcut to clear a value.

If a compound data type is defined for a cell (you can select values of different catalogs, different documents, etc.), data is entered in the same way as for form input field of compound type.

View and edit table and cell properties

You can specify the behavior of a table and a cell or a group of cells using the properties palette.

To switch to viewing and modifying table properties, select Spreadsheet document from the list on the upper line of the properties palette. To switch to viewing and modifying cell or cell group properties, select Cells from the list on the upper line of the properties palette.

Editing Panel

The editing panel is used to view and edit cell texts properties in a table.

Split Cells

To split a cell, select the cell and use TableCellsSplit cell menu item. This will display a prompt to choose the split type. Select the split direction (horizontal or vertical).

Specifying varying column widths

Select one or multiple table rows. Place the mouse pointer over the column separator, left-click and drag the separator to the right or left while holding the mouse button down. Release the mouse button. The following confirmation prompt will be displayed: New format will be created for selected rows.

When the selection area of the spreadsheet document is modified, if rows with different row formats appear in the selection area, the selection mode is enabled automatically.

Merge Cells

Select the cells you want to merge and use TableCellsMerge menu item.
All the text in the merged cells will be lost except for the text in the upper left cell, which becomes the text of the merged cell.
To split a merged cell, select it and use TableCellsMerge menu item again.

Outlining rows and columns
Creating a group

There are horizontal groups (they include selected rows) and vertical groups (containing selected columns). To create a group, select the required rows or columns and use TableGroupsMerge to group menu item.  

You can manage the display of grouped rows and columns. There are special markers that you can use to simplify this management.

Deleting a group

To delete a group, select the group (all the rows or columns in the group) and use TableGroupsExclude from Group menu item.

Using graphical objects

Graphical elements include lines, rectangles, ellipses, texts, pictures, embedded objects (OLE-objects) and charts.

To insert a graphical element into a table, use TablePictures menu item in a MS Windows manner. Use the properties palette to customize graphical objects.

Chart

The spreadsheet editor allows you to insert a special graphical object - a chart.

To create a chart, do the following:
select TablePicturesChart;
Use the mouse to draw a rectangle of the desired size where you want to insert the chart;
Enter the range of cells containing the source data for the chart (you can change the range at any time).
Printing a spreadsheet document

A spreadsheet document can be printed.

To do so, select File Print which will open the system dialog box to select the printer and specify other print options. Use File Preview for preview.

To do so, select File Print in the system panel of auxiliary windows (for a spreadsheet document in a form you need to activate any cell of the document). This will open an auxiliary window for preview. You will find the How to set up print options... hyperlink near the Print button.
Clicking the Print button will open a system dialog box to select the printer and other print options. The commands are displayed when the auxiliary window is independent and the main form of the window contains at least one control that supports these commands or when this auxiliary window is a window that displays an individual document.
Use web browser command File Print Preview for preview.  

Automatic repetition of rows and columns during printing

You can make any row or column in a table (or a range of rows or columns) to be printed on every page. To do so, select a row or a range of rows (a column or a range of columns) and choose TablePrint setupRepeat on every page.

Specify Print Area

To specify a print area, select a range in the table and select TablePrint setupSet Print Area.

 

See also: 

                  Saving Print Forms

                  Keyboard Shortcuts

                  Using mouse. General actions

                  Using mouse. Spreadsheet Editor

                  Keyboard Shortcuts

                  Using mouse. General actions

                  Using mouse. Spreadsheet Editor

1C:Enterprise Developer's Community