spread 3,代码如何分组

收藏

FpSpread1.Sheets[0].AllowGroup=true;
FpSpread1.Sheets[0].GroupBarVisible = true;
//FpSpread1.Sheets[0]. group? 如何代码把某一列加入到分组列,不是用户手工去托

iceman · iceman

你好,可以通过 GroupDataModel 类下的 Group() 方法去添加,参考代码:

protected void Button1_Click(object sender, EventArgs e)
{
FarPoint.Web.Spread.Model.GroupDataModel gm = new FarPoint.Web.Spread.Model.GroupDataModel(FpSpread1.ActiveSheetView.DataModel);
FarPoint.Web.Spread.SortInfo[] sort = new FarPoint.Web.Spread.SortInfo[3];
sort[0] = new FarPoint.Web.Spread.SortInfo(0, true);
sort[1] = new FarPoint.Web.Spread.SortInfo(1,true);
sort[2] = new FarPoint.Web.Spread.SortInfo(2, true);
gm.Group(sort);
FpSpread1.ActiveSheetView.DataModel = gm;
}

复制代码

详细内容请参见帮助文档-GroupDataModel 章节

		自动登录	找回密码
密码			立即注册

1 个回复