Creating the control

1. On the "Creación" tab, in the "Datos" group, click "Hoja de cálculo".
2. Click where you want to create the control.

• be determined through programming (for example, direct display of an xls or xlsx file).
• correspond to a memo item in a data file or query, etc.
  • correspond to a Spreadsheet control in a window.
  • correspond to an xlsDocument variable.

• Tab "General": The option Escalado corresponds to the property AdjustmentMode. The available options are:
  • No scaling: The spreadsheet sheet is printed at its own size.. The print can be performed on several pages in width and in height if necessary.
  • Fit the spreadsheet to the field dimensions: The spreadsheet will be reduced to fit entirely within the Spreadsheet control area..
  • Fit all columns to field width: Columns in the spreadsheet will be reduced or enlarged so that all columns in the spreadsheet are displayed within the width of the field..
  • Adjust all rows to field height: Rows in the spreadsheet will be reduced or enlarged so that all rows in the spreadsheet are displayed at the height of the field..
• Tab "Link": Used to define the link for the Spreadsheet control.. The control can be:
  • bound to a control in an application window.
  • bound to a variable.
  • programmed ("None" is selected). For more details, see Manipulating Spreadsheet controls programmatically (in a report).

Handling a Spreadsheet control in a report programmatically