SPREAD for ASP.NETでCheckBoxCellTypeの状態がページをまたいで保持されることを確認
using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using FarPoint.Web.Spread;
namespace WebApplication3
{
public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
spd.UseClipboard = false;
spd.EnableClientScript = true;
spd.ClientAutoCalculation = false;
var sheet = spd.ActiveSheetView;
sheet.ColumnCount = 2;
sheet.RowCount = 100;
sheet.PageSize = 10;
for (var i = 0; i < 100; i++)
{
var chkCellType = new CheckBoxCellType();
chkCellType.AutoPostBack = false;
sheet.Cells[i, 0].CellType = chkCellType;
sheet.Cells[i, 0].Value = 0;
var txtCellType = new TextCellType();
txtCellType.ShowEditor = true;
sheet.Cells[i, 1].CellType = txtCellType;
}
}
}
protected void btn_Click(object sender, EventArgs e)
{
spd.SaveChanges();
var sheet = spd.ActiveSheetView;
for (var i = 0; i < sheet.RowCount; i++)
{
var cell1 = sheet.Cells[i, 0].Value;
var cell2 = sheet.Cells[i, 1].Value;
lst.Items.Add(string.Format("{0}:{1}, {2}", i, int.Parse(cell1.ToString()) == 0 ? "チェック無し" : "チェック有り", cell2));
}
}
}
}