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

Glossary Item Box

ColHidden Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether a column is hidden. This property is available at run time only.

Syntax

C++

BOOL CSpreadSheet::GetColHidden( );
void CSpreadSheet::SetColHidden(BOOL value);

Visual Basic

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

Remarks

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property. Before using the ColHidden property, set the Col property to specify which column to hide.

To hide rows in the sheet, use the Row and RowHidden properties.

Spread Designer

Choose the Sheet menu, then the Columns and Rows menu, select the Columns tab, and then select the Columns Hidden option box in the Settings-Current Column group box in the Column and Row Settings dialog box.

Before selecting the check box, select the column you want hidden.

In the Spread Designer in design mode, the ColHidden property is temporarily reset to False, to assist you in the design process. When you switch to run-time mode, the sheet behaves according to the setting you have chosen for this property.

For more information about design mode and run-time mode, see Using Design Versus Run-Time Mode.

Data Type

Integer (Boolean)

See Also

Exporting to an HTML File
Hiding Columns and Rows

Col, Row, RowHidden, Sheet properties

DLL Correspondence

SSIsColHidden, SSShowCol functions

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