GrapeCity.Win.PluginInputMan アセンブリ > GrapeCity.Win.Spread.InputMan.CellType 名前空間 > GcDateTimeCellType クラス : DisplayFields プロパティ |
'Declaration Public Property DisplayFields As DateTimeDisplayFieldCollectionInfo
'使用法 Dim instance As GcDateTimeCellType Dim value As DateTimeDisplayFieldCollectionInfo instance.DisplayFields = value value = instance.DisplayFields
public DateTimeDisplayFieldCollectionInfo DisplayFields {get; set;}
次のサンプルコードは、GcDateTime セルのカスタム書式を作成します。
DisplayFields の数は「0」より大きい場合、セルが編集モードになっていないとき、セル描画に DisplayFields が使用されます;セルが編集モードにある場合、セル描画に Fields が使用されます DisplayFields の数が「0」の場合、表示モードと編集モードの両方が Fields を使用します。 新規フィールドを追加する前に、既存のフィールドを削除する必要があります。
GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayFieldInfo fvalue = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayFieldInfo(); fvalue.BackColor = Color.Lavender; GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthFieldInfo mvalue = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthFieldInfo(); mvalue.BackColor = Color.Azure; GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearFieldInfo yvalue = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearFieldInfo(); yvalue.BackColor = Color.Crimson; GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo eday = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo(); eday.Text = "/"; GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType inputcell = new GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType(); GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayDisplayFieldInfo day = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayDisplayFieldInfo(); day.ShowLeadingZero = true; GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthDisplayFieldInfo month = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthDisplayFieldInfo(); month.ShowLeadingZero = true; GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearDisplayFieldInfo year = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearDisplayFieldInfo(); year.ShowLeadingZero = true; GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralDisplayFieldInfo lday = new GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralDisplayFieldInfo(); lday.Text = "/"; inputcell.DisplayFields.Add(month); inputcell.DisplayFields.Add(lday); inputcell.DisplayFields.Add(day); inputcell.DisplayFields.Add(lday); inputcell.DisplayFields.Add(year); inputcell.Fields.Clear(); inputcell.Fields.Add(mvalue); inputcell.Fields.Add(eday); inputcell.Fields.Add(fvalue); inputcell.Fields.Add(eday); inputcell.Fields.Add(yvalue); fpSpread1.Sheets[0].Cells[1, 1].CellType = inputcell;
Dim fvalue As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayFieldInfo() fvalue.BackColor = Color.Lavender Dim mvalue As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthFieldInfo() mvalue.BackColor = Color.Azure Dim yvalue As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearFieldInfo() yvalue.BackColor = Color.Crimson Dim eday As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralFieldInfo() eday.Text = "/" Dim inputcell As New GrapeCity.Win.Spread.InputMan.CellType.GcDateTimeCellType() Dim day As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateDayDisplayFieldInfo() day.ShowLeadingZero = True Dim month As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateMonthDisplayFieldInfo() month.ShowLeadingZero = True Dim year As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateYearDisplayFieldInfo() year.ShowLeadingZero = True Dim lday As New GrapeCity.Win.Spread.InputMan.CellType.Fields.DateLiteralDisplayFieldInfo() lday.Text = "/" inputcell.DisplayFields.Add(month) inputcell.DisplayFields.Add(lday) inputcell.DisplayFields.Add(day) inputcell.DisplayFields.Add(lday) inputcell.DisplayFields.Add(year) inputcell.Fields.Clear() inputcell.Fields.Add(mvalue) inputcell.Fields.Add(eday) inputcell.Fields.Add(fvalue) inputcell.Fields.Add(eday) inputcell.Fields.Add(yvalue) FpSpread1.Sheets(0).Cells(1, 1).CellType = inputcell