protected void SpreadInit()
{
GCom.InitSpread(spdBody);
spdBody.Height=400;
System.Drawing.ColorConverter coverter=new System.Drawing.ColorConverter();
spdBody.Sheets[0].BackColor = (System.Drawing.Color)coverter.ConvertFromString("#EEEEFF");
spdBody.Sheets[0].Columns.Count = COLUMN_MAXCOLUMNCOUNT;
spdBody.Sheets[0].ColumnHeader.Cells[0,1].ColumnSpan = 2;
//spdBody.Rows.Count = 8;
//項目
SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL1,FarPoint.Web.Spread.ImeMode.Active,300);
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].Width = 230;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL1].Label = COLUMN_NM_PRM_VAL1;
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
//数量
SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_SURYO,0);
spdBody.Sheets[0].Columns[COLUMN_SURYO].Width = 140;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_SURYO].Label = COLUMN_NM_SURYO;
spdBody.Sheets[0].Columns[COLUMN_SURYO].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_SURYO].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
//数量単位
SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL2,FarPoint.Web.Spread.ImeMode.Active,300);
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].Width = 45;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL2].Label = COLUMN_NM_PRM_VAL2;
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
//単価
SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_TANKA,1);
spdBody.Sheets[0].Columns[COLUMN_TANKA].Width = 140;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_TANKA].Label = COLUMN_NM_TANKA;
spdBody.Sheets[0].Columns[COLUMN_TANKA].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_TANKA].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
//金額
SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_KINGAKU,1);
spdBody.Sheets[0].Columns[COLUMN_KINGAKU].Width = 140;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_KINGAKU].Label = COLUMN_NM_KINGAKU;
spdBody.Sheets[0].Columns[COLUMN_KINGAKU].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_KINGAKU].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
//PRM_KEY
spdBody.Sheets[0].Columns[COLUMN_PRM_KEY].Visible = false;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_KEY].Label = COLUMN_NM_PRM_KEY;
}
protected void SpreadInit()
{
GCom.InitSpread(spdBody);
spdBody.Height=400;
System.Drawing.ColorConverter coverter=new System.Drawing.ColorConverter();
spdBody.Sheets[0].BackColor = (System.Drawing.Color)coverter.ConvertFromString("#EEEEFF");
spdBody.Sheets[0].Columns.Count = COLUMN_MAXCOLUMNCOUNT;
spdBody.Sheets[0].ColumnHeader.Cells[0,1].ColumnSpan = 2;
//spdBody.Rows.Count = 8;
//項目
SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL1,FarPoint.Web.Spread.ImeMode.Active,300);
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].Width = 230;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL1].Label = COLUMN_NM_PRM_VAL1;
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL1].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
//数量
SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_SURYO,0);
spdBody.Sheets[0].Columns[COLUMN_SURYO].Width = 140;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_SURYO].Label = COLUMN_NM_SURYO;
spdBody.Sheets[0].Columns[COLUMN_SURYO].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_SURYO].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
//数量単位
SpreadUtil.SetCellTypeText(spdBody.Sheets[0],COLUMN_PRM_VAL2,FarPoint.Web.Spread.ImeMode.Active,300);
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].Width = 45;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_VAL2].Label = COLUMN_NM_PRM_VAL2;
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_PRM_VAL2].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Center;
//単価
SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_TANKA,1);
spdBody.Sheets[0].Columns[COLUMN_TANKA].Width = 140;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_TANKA].Label = COLUMN_NM_TANKA;
spdBody.Sheets[0].Columns[COLUMN_TANKA].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_TANKA].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
//金額
SpreadUtil.SetCellTypeGeneral(spdBody.Sheets[0],COLUMN_KINGAKU,1);
spdBody.Sheets[0].Columns[COLUMN_KINGAKU].Width = 140;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_KINGAKU].Label = COLUMN_NM_KINGAKU;
spdBody.Sheets[0].Columns[COLUMN_KINGAKU].VerticalAlign = System.Web.UI.WebControls.VerticalAlign.Middle;
spdBody.Sheets[0].Columns[COLUMN_KINGAKU].HorizontalAlign = System.Web.UI.WebControls.HorizontalAlign.Right;
//PRM_KEY
spdBody.Sheets[0].Columns[COLUMN_PRM_KEY].Visible = false;
spdBody.Sheets[0].ColumnHeader.Columns[COLUMN_PRM_KEY].Label = COLUMN_NM_PRM_KEY;
}