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

Glossary Item Box

ButtonDrawMode Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether to display buttons in button and combo box cells.

Syntax

C++

long CSpreadSheet::GetButtonDrawMode( );
void CSpreadSheet::SetButtonDrawMode(long value);

Visual Basic

[form.]fpSpread.ButtonDrawMode[ = value&]

Remarks

The following values are available. Note that you can combine values 1 (Current Cell), 2 (Current Column), 4 (Current Row), 8 (Always Button), and 16 (Always Combo) using the Or operator to limit where buttons are displayed in the sheet.

Value Description Constant
0 - Always (Default) Always displays buttons ButtonDrawModeAlways
1 - Current Cell Displays buttons only in the current cell ButtonDrawModeCurrentCell
2 - Current Column Displays buttons only in the current column ButtonDrawModeCurrentColumn
4 - Current Row Displays buttons only in the current row ButtonDrawModeCurrentRow
8 - Always Button Always displays buttons for button cells ButtonDrawModeAlwaysButton
16 - Always Combo Always displays buttons for combo box cells ButtonDrawModeAlwaysCombo

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

When the OperationMode property is set to 2 (Row Mode), the setting of the ButtonDrawMode property is ignored. Instead, while the highlight bar is visible, no buttons are displayed. While the row is being edited, all the buttons in the current row are displayed.

Create a button or combo box cell by setting the CellType property to 7 (Button) or 8 (Combo Box).

Spread Designer

Choose the Book menu, then the Display menu, select the Display tab, and then choose a check box in the Display Buttons group box in the Book Settings dialog box.

Data Type

Integer

See Also

Specifying When Buttons Appear

CellType, OperationMode properties

DLL Correspondence

SSGetButtonDrawMode, SSSetButtonDrawMode functions

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