private void Form1_Load(object sender, System.EventArgs e)
{
//自動ソート機能を有効とし、昇順/降順ソートインジケータを非表示にします
fpSpread1.ActiveSheet.Columns[0, 1].AllowAutoSort = true;
fpSpread1.ActiveSheet.Columns[0, 1].ShowSortIndicator = false;
fpSpread1.ActiveSheet.DefaultStyle.CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
fpSpread1.ActiveSheet.SetValue(0, 0, 10);
fpSpread1.ActiveSheet.SetValue(1, 0, 100);
fpSpread1.ActiveSheet.SetValue(2, 0, 50);
fpSpread1.ActiveSheet.SetValue(3, 0, 40);
fpSpread1.ActiveSheet.SetValue(4, 0, 80);
fpSpread1.ActiveSheet.SetValue(5, 0, 1);
fpSpread1.ActiveSheet.SetValue(6, 0, 65);
fpSpread1.ActiveSheet.SetValue(7, 0, 20);
fpSpread1.ActiveSheet.SetValue(8, 0, 30);
fpSpread1.ActiveSheet.SetValue(9, 0, 35);
}
private void button1_Click(object sender, System.EventArgs e)
{
//昇順/降順ソートインジケータを表示させます
fpSpread1.ActiveSheet.Columns[0, 1].ShowSortIndicator = true;
}
Private Sub Form1_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles MyBase.Load
'自動ソート機能を有効とし、昇順/降順ソートインジケータを非表示にします
FpSpread1.ActiveSheet.Columns(0, 1).AllowAutoSort = True
FpSpread1.ActiveSheet.Columns(0, 1).ShowSortIndicator = False
FpSpread1.ActiveSheet.DefaultStyle.CellType = New FarPoint.Win.Spread.CellType.NumberCellType
FpSpread1.ActiveSheet.SetValue(0, 0, 10)
FpSpread1.ActiveSheet.SetValue(1, 0, 100)
FpSpread1.ActiveSheet.SetValue(2, 0, 50)
FpSpread1.ActiveSheet.SetValue(3, 0, 40)
FpSpread1.ActiveSheet.SetValue(4, 0, 80)
FpSpread1.ActiveSheet.SetValue(5, 0, 1)
FpSpread1.ActiveSheet.SetValue(6, 0, 65)
FpSpread1.ActiveSheet.SetValue(7, 0, 20)
FpSpread1.ActiveSheet.SetValue(8, 0, 30)
FpSpread1.ActiveSheet.SetValue(9, 0, 35)
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
'昇順/降順ソートインジケータを表示させます
FpSpread1.ActiveSheet.Columns(0, 1).ShowSortIndicator = True
End Sub