Understanding spreadsheet documents

The 1C:Enterprise spreadsheet editor looks like a typical spreadsheet, with rectangular cells that form rows and columns.

Each column and row has a unique number. Columns and rows are numbered independently of each other. Numbering starts at 1 at the top left corner of a spreadsheet. Therefore, any cell may be identified by a row number and a column number.

You can name cells and cell ranges (rectangular groups of cells). Use the Names window or the property palette to assign cell names and manage named cells.

The topmost cell of a column is referred to as the column header. It contains the column number and you can use it to select a column or change column width. The leftmost cell of a row is referred to as the row header, you can use it to select a row or change row height.

A spreadsheet document can be generated by an application (as a result of a running report or data processor) or by a user. It can be saved as a file. Spreadsheet documents are usually ready-to-use print forms.

Next page: Managing spreadsheet documents

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.