DAutoFill Property
Applies To
fpSpread control
Description
Sets or returns whether a bound sheet automatically reads in the data from the database.
Syntax
BOOL CSpreadSheet::GetDAutoFill( );
void CSpreadSheet::SetDAutoFill(BOOL value);
[form.]fpSpread.DAutoFill[ = boolean%]
Remarks
The default value for the DAutoFill property is True.
This setting is applied to the entire workbook, including all sheets in the control.
When the DAutoFill property is set to True, the sheet reads the data and places each record into the sheet automatically. When the DAutoFill property is set to False, the application is responsible for loading the data into the sheet.
If the DataFillEvent property is True for a column in the sheet, the DataFill event occurs for each cell in the column as the cell reads in the data from the bound sheet.
The sheet can also automatically determine the cell types for cells in bound columns, 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 DAutoCellTypes, 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 Automatically Fill Data check box in the Data Binding Settings dialog box.
Data Type
Integer (Boolean)
See Also
Specifying Sheet and Database Interaction
DataFillEvent, DAutoCellTypes, DAutoHeadings, DAutoSizeCols properties
DataFill event