作成日: 2022/11/09 最終更新日: 2022/11/09
文書種別
技術情報
詳細
チェックボックスを設定したセルをロックすると以下のように表示されますが、CheckBoxCellTypeクラスのPictureプロパティに任意の画像を設定することで表示を変更することができます。
＜セルをロックした際の表示＞
＜ロック時のチェックボックスに任意の画像を設定した場合の表示＞
◎サンプルコード(VB)
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' ロック時のチェックボックス画像を設定する
Dim ch_cell = New FarPoint.Win.Spread.CellType.CheckBoxCellType()
ch_cell.ThreeState = True
ch_cell.Picture(FarPoint.Win.CheckBoxPictureIndex.FalseDisabled) = Image.FromFile("..\..\..\ch_off.png")
ch_cell.Picture(FarPoint.Win.CheckBoxPictureIndex.TrueDisabled) = Image.FromFile("..\..\..\ch_on.png")
ch_cell.Picture(FarPoint.Win.CheckBoxPictureIndex.IndeterminateDisabled) = Image.FromFile("..\..\..\ch_indeterminate.png")
FpSpread1.ActiveSheet.Columns(0, 1).CellType = ch_cell
FpSpread1.ActiveSheet.Columns(0).Locked = True
FpSpread1.ActiveSheet.Columns(1).Locked = False
FpSpread1.ActiveSheet.Cells(0, 0, 0, 1).Value = 1
FpSpread1.ActiveSheet.Cells(1, 0, 1, 1).Value = 0
FpSpread1.ActiveSheet.Cells(2, 0, 2, 1).Value = 2
FpSpread1.ActiveSheet.Protect = True
FpSpread1.ActiveSheet.RowCount = 3
FpSpread1.ActiveSheet.ColumnCount = 2
FpSpread1.ActiveSheet.Columns(0, 1).Width = 120
FpSpread1.ActiveSheet.ColumnHeader.Rows(0).Locked = False
FpSpread1.ActiveSheet.RowHeader.Columns(0).Locked = False
FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 0).Text = "Locked = True"
FpSpread1.ActiveSheet.ColumnHeader.Cells(0, 1).Text = "Locked = False"
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// ロック時のチェックボックス画像を設定する
var ch_cell = new FarPoint.Win.Spread.CellType.CheckBoxCellType();
ch_cell.ThreeState = true;
ch_cell.Picture[FarPoint.Win.CheckBoxPictureIndex.FalseDisabled] = Image.FromFile(@"..\..\..\ch_off.png");
ch_cell.Picture[FarPoint.Win.CheckBoxPictureIndex.TrueDisabled] = Image.FromFile(@"..\..\..\ch_on.png");
ch_cell.Picture[FarPoint.Win.CheckBoxPictureIndex.IndeterminateDisabled] = Image.FromFile(@"..\..\..\ch_indeterminate.png");
fpSpread1.ActiveSheet.Columns[0, 1].CellType = ch_cell;
fpSpread1.ActiveSheet.Columns[0].Locked = true;
fpSpread1.ActiveSheet.Columns[1].Locked = false;
fpSpread1.ActiveSheet.Cells[0, 0, 0, 1].Value = 1;
fpSpread1.ActiveSheet.Cells[1, 0, 1, 1].Value = 0;
fpSpread1.ActiveSheet.Cells[2, 0, 2, 1].Value = 2;
fpSpread1.ActiveSheet.Protect = true;
fpSpread1.ActiveSheet.RowCount = 3;
fpSpread1.ActiveSheet.ColumnCount = 2;
fpSpread1.ActiveSheet.Columns[0, 1].Width = 120;
fpSpread1.ActiveSheet.ColumnHeader.Rows[0].Locked = false;
fpSpread1.ActiveSheet.RowHeader.Columns[0].Locked = false;
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 0].Text = "Locked = True";
fpSpread1.ActiveSheet.ColumnHeader.Cells[0, 1].Text = "Locked = False";
}