SSpread.Text Property

Set values such as strings, numbers, and dates in cells.

Before setting this property, use the Changing this property does not affect the Col, Changing this property does not affect the Row properties, and so on to specify what to do.

The initial value is a blank character string.

This property has different acquisition and setting rules depending on the cell data type (CellType property). For details, refer to <a href=”package/extension5/sspread/#get-and-set-the-value-for-each-cell-data-type->Get and set the value for each cell data type</a> Index Property.

The string can be obtained before formatting with the Value property and the formatted string with the Text property.

Example of usage

Col = 2;
Row = 3;
Text = "sample1";
 
BlockMode = $TRUE;
Col = 3;
Row = 3;
Col2 = 5;
Row2 = 5;
Text ="sample2";
BlockMode = $FALSE;

Related Items
CellType, Clip, Value property
GetText, SetText method