Spread 8.0 Documentation
GetBottomRightCell, ScriptGetBottomRightCell Methods
Support Options
ActiveX Reference > ActiveX Methods > GetBottomRightCell, ScriptGetBottomRightCell Methods

Glossary Item Box

GetBottomRightCell, ScriptGetBottomRightCell Methods


See Also    DLL    Example

Applies To

fpSpread control

Description

Returns the coordinates of the cell displayed at the lower-right in the current view.

Syntax

C++

void CSpreadSheet::GetBottomRightCell (long* Col, long* Row);

Visual Basic

fpSpread.GetBottomRightCell(Col As Long, Row As Long)

Note: The ScriptGetBottomRightCell 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 lower-right cell
Row Row number of lower-right cell

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 ScriptGetBottomRightCell method. ScriptGetBottomRightCell method parameters that are not passed "ByVal" are declared as variants.

Return Type

Returns coordinates of the lower-right cell in the Col and Row parameters.

See Also

LeftCol, ScriptEnhanced, Sheet, TopRow properties

DLL Correspondence

SSGetBottomRightCell function

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