Text Property

Returns the value of the cell represented by this IRange as a formatted string.

[Visual Basic]
Overridable ReadOnly Property Text As String

[C#]
virtual string Text {get;}

[C++]
__property virtual string* get_Text();

[C++/CLI]
virtual property String^ Text {
   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 for .NET 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).

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

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

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.