private static readonly string[] HEADER = { "编号", "姓名", "类型"};
private void fpdMember_Grouped(object sender, EventArgs e)
{FarPoint.Win.Spread.FpSpread ss = (FarPoint.Win.Spread.FpSpread)sender;
FarPoint.Win.Spread.Model.GroupDataModel gm;
if (ss.ActiveSheet.Models.Data.GetType() == typeof(FarPoint.Win.Spread.Model.GroupDataModel))
{
gm = (FarPoint.Win.Spread.Model.GroupDataModel)ss.Sheets[0].Models.Data;
string txt = string.Empty;
object obj = null;
FarPoint.Win.Spread.Model.Group g;
for (int i = 0; i < gm.RowCount; i++)
{
g = gm.GetGroup(i);
obj = gm.TargetModel.GetValue(getRow(g), g.Column);
txt = obj == null ? string.Empty : obj.ToString();
g.Text = string.Format("{0}:{1}", HEADER[g.Column], txt);
}
}
}
private int getRow(FarPoint.Win.Spread.Model.Group group)
{
if (group.Rows[0] is FarPoint.Win.Spread.Model.Group)
{
return getRow(group.Rows[0] as FarPoint.Win.Spread.Model.Group);
}
return (int)group.Rows[0];
}