private void Form1_Load(object sender, EventArgs e)
{
DataTable dt = new DataTable();
dt.Columns.Add("A");
DataRow row = dt.NewRow();
row["A"] = "2017/04/07 12:00:00";// リテラル文字を含む値はセルに設定されません
// 以下のようにリテラル文字を含まない値を設定してください
//row("A") = "20170407120000"
dt.Rows.Add(row);
fpSpread1.Sheets[0].DataAutoCellTypes = false;
fpSpread1.Sheets[0].DataSource = dt;
FarPoint.Win.Spread.CellType.MaskCellType mcDatetime = new FarPoint.Win.Spread.CellType.MaskCellType();
mcDatetime.Mask = "####/##/## ##:##:##";
fpSpread1.Sheets[0].Columns[0].CellType = mcDatetime;
fpSpread1.Sheets[0].Columns[0].DataField = "A";
}
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
Dim dt As New DataTable
dt.Columns.Add("A")
Dim row As DataRow = dt.NewRow
row("A") = "2017/04/07 12:00:00" ' リテラル文字を含む値はセルに設定されません
' 以下のようにリテラル文字を含まない値を設定してください
'row("A") = "20170407120000"
dt.Rows.Add(row)
FpSpread1.Sheets(0).DataAutoCellTypes = False
FpSpread1.Sheets(0).DataSource = dt
Dim mcDatetime As New FarPoint.Win.Spread.CellType.MaskCellType
mcDatetime.Mask = "####/##/## ##:##:##"
FpSpread1.Sheets(0).Columns(0).CellType = mcDatetime
FpSpread1.Sheets(0).Columns(0).DataField = "A"
End Sub