Spreadsheet document fields

A form can contain an embedded spreadsheet document (a Spreadsheet document field form item). For information about operations available in the Spreadsheet document field, see Appendix 3. Spreadsheet document editor.

Navigating in spreadsheets. A spreadsheet document window displays a part of a spreadsheet located in that window. To select a cell, click it. You can scroll a spreadsheet using the scroll bars.

Tip. To scroll a document horizontally, hold down Shift and rotate the wheel button.

For convenient scrolling of a large document, you can hold the wheel button and select the scrolling direction with the pointer. The scrolling speed depends on the distance between the current pointer location and the pointer location at the time when the wheel button was pressed (it is marked with a special icon).

Managing spreadsheet view. Use the Table – View section of the main menu to configure the view of the spreadsheet document parts: column and row headers, grid, and more.

The following table briefly describes the View menu items. When a menu items is checked, it has effect.

Menu item

Action

Dock Table

Keep top rows and left columns visible when scrolling the rest of the spreadsheet.

Show Grid

Show or hide the lines between the rows and columns in the sheet.

View Headers/Footers

Show or hide row and column headings.

View Groups

Show or hide groups (the areas to the left of the row header or above the column header).

Edit

Allow or prohibit editing the spreadsheet.

Show Comments

Show or hide comments.

Black and White View

Show or hide the colors specified for the spreadsheet document. If you check this item, spreadsheet colors are defined by the operating system settings.

Page view mode

Show or hide the area that contains data, the print area, and page breaks.

Scale

Set spreadsheet scale.

Tip. You can use the wheel button to change the scale. Hold down Ctrl and rotate the wheel button forward (to zoom in) or backward (to zoom out). 

Docking a table (headers). 1C:Enterprise spreadsheet editor features freezing the top rows and left columns of a spreadsheet document, making them visible when scrolling the rest of the spreadsheet.

To freeze spreadsheet rows, select a row and then, on the main menu, point to Table, point to View, and click Dock Table. This freezes the rows above the selected one.

To freeze spreadsheet columns, select a column and then, on the main menu, point to Table, point to View, and click Dock Table. This freezes the columns to the left of the selected one. 

To freeze spreadsheet rows and columns simultaneously, click a cell and then, on the main menu, point to Table, point to View, and click Dock Table. This freezes the rows above the cell and the columns to the left of the cell.

To release the frozen rows and columns, on the main menu, point to Table, point to View, and click Dock Table.

Protection from editing. To protect a spreadsheet document from editing, on the main menu, point to Table, point to View, and click Edit (it this item is checked, the document is already protected).

If a cell contains a text that does not fit the visible area, move the pointer over that cell to display the full text as a tooltip. If the text is too large to fit in a tooltip, only a part of the text is displayed.

Next page: Formatted document fields

Be the first to know tips & tricks on business application development!

A confirmation e-mail has been sent to the e-mail address you provided .

Click the link in the e-mail to confirm and activate the subscription.