作成日: 2022/01/21 最終更新日: 2022/02/24
文書種別
使用方法
詳細
異なるコントロール間で値をコピーする機能は用意されていませんが、クリップボードを経由することで行/列/セル範囲のコピーを実現できます。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
' SPREAD1の行列数を設定
FpSpread1.ActiveSheet.RowCount = 5
FpSpread1.ActiveSheet.ColumnCount = 5
' SPREAD1の値を設定
For i As Integer = 0 To FpSpread1.ActiveSheet.RowCount - 1
For j As Integer = 0 To FpSpread1.ActiveSheet.ColumnCount - 1
FpSpread1.ActiveSheet.SetValue(i, j, String.Format("R{0}C{1}", i, j))
Next
Next
' SPREAD2の行列数を設定
FpSpread2.ActiveSheet.RowCount = 5
FpSpread2.ActiveSheet.ColumnCount = 5
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' SPREAD1の2行目をクリップボードにコピー
FpSpread1.ActiveSheet.ClipboardCopy(New FarPoint.Win.Spread.Model.CellRange(1, -1, 1, -1))
' SPREAD2の2行目にペースト
FpSpread2.ActiveSheet.SetActiveCell(1, 0)
FpSpread2.ActiveSheet.ClipboardPaste(FarPoint.Win.Spread.ClipboardPasteOptions.All)
' SPREAD2の選択状態を解除
FpSpread2.ActiveSheet.ClearSelection()
End Sub
' SPREAD1の行列数を設定
FpSpread1.ActiveSheet.RowCount = 5
FpSpread1.ActiveSheet.ColumnCount = 5
' SPREAD1の値を設定
For i As Integer = 0 To FpSpread1.ActiveSheet.RowCount - 1
For j As Integer = 0 To FpSpread1.ActiveSheet.ColumnCount - 1
FpSpread1.ActiveSheet.SetValue(i, j, String.Format("R{0}C{1}", i, j))
Next
Next
' SPREAD2の行列数を設定
FpSpread2.ActiveSheet.RowCount = 5
FpSpread2.ActiveSheet.ColumnCount = 5
End Sub
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
' SPREAD1の2行目をクリップボードにコピー
FpSpread1.ActiveSheet.ClipboardCopy(New FarPoint.Win.Spread.Model.CellRange(1, -1, 1, -1))
' SPREAD2の2行目にペースト
FpSpread2.ActiveSheet.SetActiveCell(1, 0)
FpSpread2.ActiveSheet.ClipboardPaste(FarPoint.Win.Spread.ClipboardPasteOptions.All)
' SPREAD2の選択状態を解除
FpSpread2.ActiveSheet.ClearSelection()
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// SPREAD1の行列数を設定
fpSpread1.ActiveSheet.RowCount = 5;
fpSpread1.ActiveSheet.ColumnCount = 5;
// SPREAD1の値を設定
for (int i=0;i<fpSpread1.ActiveSheet.RowCount;i++)
{
for (int j=0;j<fpSpread1.ActiveSheet.ColumnCount;j++)
{
fpSpread1.ActiveSheet.SetValue(i, j, String.Format("R{0}C{1}", i, j));
}
}
// SPREAD2の行列数を設定
fpSpread2.ActiveSheet.RowCount = 5;
fpSpread2.ActiveSheet.ColumnCount = 5;
}
private void button1_Click(object sender, EventArgs e)
{
// SPREAD1の2行目をクリップボードにコピー
fpSpread1.ActiveSheet.ClipboardCopy(new FarPoint.Win.Spread.Model.CellRange(1, -1, 1, -1));
// SPREAD2の2行目にペースト
fpSpread2.ActiveSheet.SetActiveCell(1, 0);
fpSpread2.ActiveSheet.ClipboardPaste(FarPoint.Win.Spread.ClipboardPasteOptions.All);
// SPREAD2の選択状態を解除
fpSpread2.ActiveSheet.ClearSelection();
}
{
// SPREAD1の行列数を設定
fpSpread1.ActiveSheet.RowCount = 5;
fpSpread1.ActiveSheet.ColumnCount = 5;
// SPREAD1の値を設定
for (int i=0;i<fpSpread1.ActiveSheet.RowCount;i++)
{
for (int j=0;j<fpSpread1.ActiveSheet.ColumnCount;j++)
{
fpSpread1.ActiveSheet.SetValue(i, j, String.Format("R{0}C{1}", i, j));
}
}
// SPREAD2の行列数を設定
fpSpread2.ActiveSheet.RowCount = 5;
fpSpread2.ActiveSheet.ColumnCount = 5;
}
private void button1_Click(object sender, EventArgs e)
{
// SPREAD1の2行目をクリップボードにコピー
fpSpread1.ActiveSheet.ClipboardCopy(new FarPoint.Win.Spread.Model.CellRange(1, -1, 1, -1));
// SPREAD2の2行目にペースト
fpSpread2.ActiveSheet.SetActiveCell(1, 0);
fpSpread2.ActiveSheet.ClipboardPaste(FarPoint.Win.Spread.ClipboardPasteOptions.All);
// SPREAD2の選択状態を解除
fpSpread2.ActiveSheet.ClearSelection();
}