devlights
2/6/2013 - 2:02 AM

SPREAD for ASP.NETでCheckBoxCellTypeの状態がページをまたいで保持されることを確認

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));
            }
        }
    }
}