Formatting spreadsheet document rows

1C:Enterprise spreadsheet documents support custom column width for individual rows. This article describes how to use this feature.

Customizing column width 

To customize column width in several rows, select the rows and drag the column borders. Once you resize a column, the platform asks whether you want to create new row format. If you confirm that, new format is created for the selected rows and next time you change the column width in any of these rows this will only affect these rows.

You can set the row format for a specific spreadsheet document area using 1C:Enterprise script method CreateFormatOfRows(). It changes the row format in the area where it is called.

Selecting and copying rows

The built-in 1C:Enterprise spreadsheet document editor does not allow selection of rectangular areas if they include multiple row formats. To copy a document part that includes multiple row formats, select the entire rows. You can do it either by clicking the row headers or by pressing Alt + Shift + Up Arrow/Down Arrow.

If you copy a group of rows with multiple formats to the clipboard, the formats are preserved when you paste the rows. If rows with this specific format are already present in the target document, the pasted rows are treated as if they have the same format. In other words, copying and pasting a row with custom format within a single document results in two rows having the same format and dragging a column border in one of the rows changes the column width in the other row as well.

The algorithm described above is also applied when rows are copied from 1C:Enterprise script. Rows that have the same format in a source document also have the same format in a target document.

Exporting spreadsheet documents

Exporting a spreadsheet document with custom row format to Microsoft Excel leads to a loss of custom column width settings. If you want to preserve the formatting in an exported spreadsheet document, export it to HTML format instead.

Add comment