Spread 8.0 Documentation
GetCellPos, ScriptGetCellPos Methods
Support Options
ActiveX Reference > ActiveX Methods > GetCellPos, ScriptGetCellPos Methods

Glossary Item Box

GetCellPos, ScriptGetCellPos Methods


See Also    DLL    Example

Applies To

fpSpread control

Description

Returns the location of the specified cell, and its height and width in twips.

Syntax

C++

BOOL CSpreadSheet::GetCellPos (long Col, long Row, long* x, long* y, long* Width, long* Height);

Visual Basic

fpSpread.GetCellPos(ByVal Col As Long, ByVal Row As Long, x As Long, y As Long, Width As Long, Height As Long) As Boolean

Note: The ScriptGetCellPos method uses the same syntax except method parameters that are not passed "ByVal" are declared as variants. For more information on Script methods, see Scripting Environment Usage.

Parameters

The following parameters are available:

Parameter Description
Col Column number of cell
Row Row number of cell
x x-coordinate of upper-left corner of cell
y y-coordinate of upper-left corner of cell
Width Width of cell
Height Height of cell

Remarks

The returned measurements are specified relative to the upper-left corner of the sheet. The returned height and width values are in twips.

This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.

Note: Call this method if you use the Spread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the Spread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and call the ScriptGetCellPos method. ScriptGetCellPos method parameters that are not passed "ByVal" are declared as variants.

Return Type

True if the cell is displayed on the screen; otherwise, False and the method does not return coordinates.

See Also

ScriptEnhanced, Sheet properties

GetCellFromScreenCoord method

DLL Correspondence

SSGetCellRect function

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