首先工具栏加入FarPoint.Win.Spread.FpSpread。假如命名为fpSpread1。
目前成都创新互联公司已为上千多家的企业提供了网站建设、域名、虚拟空间、网站托管维护、企业网站设计、临朐网站维护等服务，公司将坚持客户导向、应用为本的策略，正道将秉承"和谐、参与、激情"的文化，与客户和合作伙伴齐心协力一起成长，共同发展。
定义一个DataTable
System.Data.DataTable pDT = new System.Data.DataTable("T_Sex");
//set columns names
pDT.Columns.Add("SexCode", typeof(System.String));
pDT.Columns.Add("Sex", typeof(System.String));
pDT.Columns.Add("SexName", typeof(System.String));
//Add Rows
System.Data.DataRow mDR = pDT.NewRow();
mDR["SexCode"] = "M";
mDR["Sex"] = "男";
mDR["SexName"] = "男";
pDT.Rows.Add(mDR);
mDR = pDT.NewRow();
mDR["SexCode"] = "F";
mDR["Sex"] = "女";
mDR["SexName"] = "女";
pDT.Rows.Add(mDR);定义一个MultiColumnComboBoxCellType
FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mMCCBCT = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType(); mMCCBCT.DataSourceList = pDT; mMCCBCT.DataMemberList = "T_Sex"; mMCCBCT.EditorValueChanged += mMCCBCT_EditorValueChanged; mMCCBCT.ListWidth = 500; mMCCBCT.ListResizeColumns = FarPoint.Win.Spread.CellType.ListResizeColumns.ByDataType; mMCCBCT.AutoSearch = FarPoint.Win.AutoSearch.MultipleCharacter; mMCCBCT.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows; mMCCBCT.ColumnEditName = "SexName"; mMCCBCT.DataColumnName = "Sex"; this.fpSpread1.Sheets[0].Cells.Get(1, 1).CellType = mMCCBCT; this.fpSpread1.Sheets[0].Cells[1, 1].Value = "男";
ComboBox联动处理，添加事件fpSpread1_ComboCloseUp
private void fpSpread1_ComboCloseUp(object sender, FarPoint.Win.Spread.EditorNotifyEventArgs e)
{
try
{
this.fpSpread1.ActiveSheet.Cells[e.Row, e.Column + 1].Value = this.fpSpread1.ActiveSheet.Cells[e.Row, e.Column].CellType.GetEditorValue();
return;
}
catch
{
}
}
