SpreadsheetGear 2023
Text Property (IRange)

SpreadsheetGear Namespace > IRange Interface : Text Property
Returns the value of the cell represented by this IRange as a formatted string.
ReadOnly Property Text As System.String
Dim instance As IRange
Dim value As System.String
value = instance.Text
System.string Text {get;}

The value of the cell is formatted using the number format of the cell and returned as a string.

Note: Microsoft Excel truncates the number of significant digits displayed, or displays "######" for numbers which do not fit, based on the column width and font of the cell. SpreadsheetGear does not limit the returned text in this way.

Use the Value property to get the raw data of the cell (such as a Double for dates and times).


Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also


IRange Interface
IRange Members
Formula Property
NumberFormat Property
NumberFormatType Property
Value Property
ValueType Property
Entry Property