Gets a tab-delimited string that contains the unformatted text in a range.
Parameters
- row
- Starting column header row index, or -1 for all column header rows
- column
- Starting column index, or -1 for all columns
- rowCount
- Number of column header rows, or -1 for all column header rows
- columnCount
- Number of columns, or -1 for all columns
Return Value
Tab-delimited
string containing the unformatted data in the range
This example sets and returns a tab-delimited string containing the formatted text from the column headers.
FpSpread1.ActiveSheetView.ColumnHeader.RowCount = 4;
FpSpread1.ActiveSheetView.ColumnHeader.SetClipValue(0, 0, 2, 4, "one\ttwo\tthree\tfour\r\nfive\tsix\tseven\teight");
string s;
s = FpSpread1.ActiveSheetView.ColumnHeader.GetClipValue(0, 0, 2, 4);
ListBox1.Items.Add(s);
FpSpread1.ActiveSheetView.ColumnHeader.RowCount = 4
FpSpread1.ActiveSheetView.ColumnHeader.SetClipValue(0, 0, 2, 4, "one" + Chr(9) + "two" + Chr(9) + "three" + Chr(9) + "four"
+ vbCrLf + "five" + Chr(9) + "six" + Chr(9) + "seven" + Chr(9) + "eight")
Dim s As String
s = FpSpread1.ActiveSheetView.ColumnHeader.GetClipValue(0, 0, 2, 4)
ListBox1.Items.Add(s)
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6