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

Glossary Item Box

LeftCol Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the number of the column to position as the leftmost column in the displayed sheet. This property is available at run time only.

Syntax

C++

long CSpreadSheet::GetLeftCol( );
void CSpreadSheet::SetLeftCol(long value);

Visual Basic

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

Remarks

Set the LeftCol property to a column number to position that column next to the left edge of the fpSpread control.

When the leftmost displayed column changes, the TopLeftChange event occurs.

If you set the ColsFrozen property to a value other than 0, the value returned using the LeftCol property will be the value of the leftmost scrolling column.

Note: Positioning a column using the LeftCol property does not affect the position of the active cell.

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.

Use the TopRow property to set or return the row to position as the topmost row in the displayed sheet.

Spread Designer

Choose the Sheet menu, then the Columns and Rows menu, select the Columns tab, and then choose or type a number in the Left Col spin box in the Settings-All Columns group box in the Column and Row Settings dialog box.

Notes:
  • Spread Designer displays the change only in run-time mode.
  • This setting is not preserved when you save your changes to a file or apply your changes to the selected control.

Data Type

Long Integer

See Also

Designating the Leftmost Column to Display

ColsFrozen, Sheet, TopRow properties

TopLeftChange event

DLL Correspondence

SSGetTopLeftCell, SSShowCell functions

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