SpreadsheetGear 2017
Text Property (IRange)






SpreadsheetGear Namespace > IRange Interface : Text Property
Returns the value of the cell represented by this IRange as a formatted string.
Syntax
'Declaration
 
ReadOnly Property Text As System.String
'Usage
 
Dim instance As IRange
Dim value As System.String
 
value = instance.Text
System.string Text {get;}
read-only property Text: System.String; 
function get Text : System.String
__property System.string* get_Text();
property System.String^ Text {
   System.String^ get();
}
Remarks

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 IRange.Value property to get the raw data of the cell (such as a Double for dates and times).

Requirements

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

Reference

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