Spread 8.0 Documentation
DAutoFill Property
Support Options
ActiveX Reference > ActiveX Properties > DAutoFill Property

Glossary Item Box

DAutoFill Property


See Also    Example

Applies To

fpSpread control

Description

Sets or returns whether a bound sheet automatically reads in the data from the database.

Syntax

C++

BOOL CSpreadSheet::GetDAutoFill( );
void CSpreadSheet::SetDAutoFill(BOOL value);

Visual Basic

[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

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.