Spread 8.0 Documentation
SetInteger Method
Support Options
ActiveX Reference > ActiveX Methods > SetInteger Method

Glossary Item Box

SetInteger Method


See Also    DLL

Applies To

fpSpread control

Description

Sets the value for a number cell using an integer value.

Syntax

C++

BOOL CSpreadSheet::SetInteger(long Col, long Row, long Value);

Visual Basic

fpSpread.SetInteger(ByVal Col As Long, ByVal Row As Long, ByVal Value As Long) As Boolean

Parameters

The following parameters are available:

Parameter Description
Col Column number of cell
Row Row number of cell
Value Integer value

Remarks

Use the SetInteger method to set the value of a number cell as an integer value. The Clip, ClipValue, Text, and Value properties set the value in a cell as a string. For more information about using these properties and method, see Adding Data.

Tip: The SetInteger method sets the value as a long data type.

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.

If you set the Col or Row parameter to –1 to set data for multiple cells, the same data is placed in each cell.

Return Type

True if the integer value is set; otherwise, the method returns False.

See Also

Adding Data

Clip, ClipValue, Sheet, Text, Value properties

GetInteger, SetText methods

DLL Correspondence

SSSetInteger function

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