DAutoCellTypes Property

Applies To

fpSpread control

Description

Sets or returns whether a bound sheet automatically sets the cell type for the cells in a column.

Syntax

C++

BOOL CSpreadSheet::GetDAutoCellTypes( );
void CSpreadSheet::SetDAutoCellTypes(BOOL value);

Visual Basic

[form.]fpSpread.DAutoCellTypes[ = boolean%]

Remarks

The default value for the DAutoCellTypes property is True.

This setting is applied to the entire workbook, including all sheets in the control.

When this property is set to True, the sheet automatically sets the cell type based on the field type for each column that receives data from the database. When the DAutoCellTypes property is set to False, you must set the cell type for each column bound to a database field if you want the cells to be a cell type other than edit cells.

When the sheet automatically assigns cell types, the DataColConfig event occurs as the sheet assigns each column, and you can override the assigned cell type for each column in the DataColConfig event using the CellType property.

The sheet can also automatically fill the sheet from the bound database, automatically set the text in the column headers, and automatically determine the column width based on the bound database fields, depending on the settings of the DAutoFill, DAutoHeadings, and DAutoSizeCols properties.

This property is valid only when the sheet is bound to a database.

Spread Designer

Choose the Sheet menu, and then the Data Binding menu, and then select the Set Cell Type Automatically check box in the Data Binding Settings dialog box.

Data Type

Integer (Boolean)