我想用MultiColumnComboBoxCellType类型,可是我在帮助中找到代码:
FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType mcb = new FarPoint.Win.Spread.CellType.MultiColumnComboBoxCellType();
mcb.BackgroundImage = null;
mcb.DataSourceList = digestData;
mcb.DataColumn = 2;
mcb.ColumnEdit = 2;
mcb.AcceptsArrowKeys = FarPoint.Win.SuperEdit.AcceptsArrowKeys.AllArrows;
mcb.ButtonAlign = FarPoint.Win.ButtonAlign.Left;
mcb.ListAlignment = FarPoint.Win.ListAlignment.Right;
mcb.ListWidth = 500;
mcb.ListOffset = 5;
mcb.MaxDrop = 5;
mcb.StringTrim = StringTrimming.EllipsisCharacter;
mcb.SubEditor = null;
fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb;
1、//此处改为:fpSpread1.ActiveSheet.Columns[0].CellType = mcb;这列不能显示为这种类型
2、如果 fpSpread1.ActiveSheet.Cells[0, 0].CellType = mcb;,但是该单元格就不能输入了,我希望是用户输入的时候能够模糊定位,应该怎么办?
3、想下拉时树形显示数据又怎么办? |
|