DAutoHeadings Property

Applies To

fpSpread control

Description

Sets or returns whether a bound sheet automatically assigns the text in the column headers to be the data field names.

Syntax

C++

BOOL CSpreadSheet::GetDAutoHeadings( );
void CSpreadSheet::SetDAutoHeadings(BOOL value);

Visual Basic

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

Remarks

The default value for the DAutoHeadings property is True.

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

When the DAutoHeadings property is set to True, the sheet automatically places the name of each data field in the corresponding column header. When the DAutoHeadings property is set to False, if you want the column header to display text different from the default text, you must specify the text using the Text property.

The sheet can also automatically determine the cell types for cells in bound columns, automatically fill the sheet from the bound database, and automatically determine the column width based on the bound database fields, depending on the settings of the DAutoCellTypes, DAutoFill, 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 Use DataField Name As Column Heading check box in the Data Binding Settings dialog box.

If the Use DataField Name As Column Heading check box is cleared, use the box under User Defined Headers on the Columns tab in the Headings dialog box to provide the text for each column header.

Data Type

Integer (Boolean)